A B C D E F G H I J L M N O P Q R S T U V W

A

AbstractBooleanExpression - Class in com.exasol.sql.expression

Abstract base class for all types of BooleanExpressions.

AbstractBooleanExpression() - Constructor for class com.exasol.sql.expression.AbstractBooleanExpression

AbstractBooleanExpression(BooleanExpression) - Constructor for class com.exasol.sql.expression.AbstractBooleanExpression

AbstractBooleanExpression(BooleanExpression...) - Constructor for class com.exasol.sql.expression.AbstractBooleanExpression

AbstractBottomUpTreeNode - Class in com.exasol.util

This is an abstract base class for nodes in a tree structure.

AbstractBottomUpTreeNode() - Constructor for class com.exasol.util.AbstractBottomUpTreeNode

Create a new instance of a AbstractBottomUpTreeNode that serves as leaf node for a tree.

AbstractBottomUpTreeNode(List<TreeNode>) - Constructor for class com.exasol.util.AbstractBottomUpTreeNode

Create a new instance of a AbstractBottomUpTreeNode.

AbstractBottomUpTreeNode(TreeNode...) - Constructor for class com.exasol.util.AbstractBottomUpTreeNode

Create a new instance of a AbstractBottomUpTreeNode.

AbstractExpressionRenderer - Class in com.exasol.sql.expression.rendering

Common base class for expression renderers.

AbstractExpressionRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.expression.rendering.AbstractExpressionRenderer

AbstractFragment - Class in com.exasol.sql

Common base class for SQL statement fragments

AbstractFragment(Fragment) - Constructor for class com.exasol.sql.AbstractFragment

Create an instance of an SQL fragment

AbstractFragmentRenderer - Class in com.exasol.sql.rendering

Abstract base class for SQL fragment renderers.

AbstractFragmentRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.rendering.AbstractFragmentRenderer

Create a new instance of an AbstractFragmentRenderer-based class.

AbstractFunction - Class in com.exasol.sql.expression.function

This is a base class for functions.

AbstractFunction(String, List<ValueExpression>) - Constructor for class com.exasol.sql.expression.function.AbstractFunction

Create a new instance using AbstractFunction.

AbstractInsertValueTable<T extends AbstractInsertValueTable<T>> - Class in com.exasol.sql.dml.insert

Abstract base class for SQL fragments that contain a insert value table (for example INSERT, MERGE).

AbstractInsertValueTable(Fragment) - Constructor for class com.exasol.sql.dml.insert.AbstractInsertValueTable

Create the abstract base for a fragment containing a value table.

AbstractInterval - Class in com.exasol.datatype.value

AbstractInterval(long) - Constructor for class com.exasol.datatype.value.AbstractInterval

AbstractInterval(long, boolean) - Constructor for class com.exasol.datatype.value.AbstractInterval

AbstractStringDataType<T extends AbstractStringDataType<T>> - Class in com.exasol.datatype.type

Implements common logic for String data types

AbstractStringDataType(int, int, String) - Constructor for class com.exasol.datatype.type.AbstractStringDataType

AbstractTreeNode - Class in com.exasol.util

This is an abstract base class for nodes in a tree structure.

AbstractTreeNode() - Constructor for class com.exasol.util.AbstractTreeNode

Create a new instance of a AbstractTreeNode that serves as root for a tree.

AbstractValueExpression - Class in com.exasol.sql.expression

Abstract base class for all types of value expressions

AbstractValueExpression() - Constructor for class com.exasol.sql.expression.AbstractValueExpression

Create a new instance of a AbstractValueExpression

accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Boolean

accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Char

accept(ColumnDefinitionVisitor) - Method in interface com.exasol.datatype.type.DataType

accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Date

accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Decimal

accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.DoublePrecision

accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.IntervalDayToSecond

accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.IntervalYearToMonth

accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Timestamp

accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.TimestampWithLocalTimezone

accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Varchar

accept(ColumnDefinitionVisitor) - Method in class com.exasol.sql.Column

accept(ColumnDefinitionVisitor) - Method in class com.exasol.sql.ColumnsDefinition

accept(CreateSchemaVisitor) - Method in class com.exasol.sql.ddl.create.CreateSchema

accept(CreateSchemaVisitor) - Method in interface com.exasol.sql.ddl.create.CreateSchemaFragment

Accept a visitor (e.g.

accept(CreateTableVisitor) - Method in class com.exasol.sql.ddl.create.CreateTable

accept(CreateTableVisitor) - Method in interface com.exasol.sql.ddl.create.CreateTableFragment

Accept a visitor (e.g.

accept(DropSchemaVisitor) - Method in class com.exasol.sql.ddl.drop.Cascade

accept(DropTableVisitor) - Method in class com.exasol.sql.ddl.drop.CascadeConstraints

accept(DropSchemaVisitor) - Method in class com.exasol.sql.ddl.drop.DropSchema

accept(DropSchemaVisitor) - Method in interface com.exasol.sql.ddl.drop.DropSchemaFragment

Accept a visitor (e.g.

accept(DropTableVisitor) - Method in class com.exasol.sql.ddl.drop.DropTable

accept(DropTableVisitor) - Method in interface com.exasol.sql.ddl.drop.DropTableFragment

Accept a visitor (e.g.

accept(DropSchemaVisitor) - Method in class com.exasol.sql.ddl.drop.Restrict

accept(CreateSchemaVisitor) - Method in class com.exasol.sql.ddl.Schema

accept(DropSchemaVisitor) - Method in class com.exasol.sql.ddl.Schema

accept(SelectVisitor) - Method in class com.exasol.sql.DerivedColumn

accept(InsertVisitor) - Method in class com.exasol.sql.DerivedColumn

accept(MergeVisitor) - Method in class com.exasol.sql.DerivedColumn

accept(InsertVisitor) - Method in class com.exasol.sql.dml.insert.Insert

accept(InsertVisitor) - Method in class com.exasol.sql.dml.insert.InsertFields

accept(MergeVisitor) - Method in class com.exasol.sql.dml.insert.InsertFields

accept(InsertVisitor) - Method in interface com.exasol.sql.dml.insert.InsertFragment

Accept a visitor (e.g.

accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.MatchedClause

accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.Merge

accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.MergeColumnUpdate

accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.MergeDeleteClause

accept(MergeVisitor) - Method in interface com.exasol.sql.dml.merge.MergeFragment

Accept a visitor (e.g.

accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.MergeInsertClause

accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause

accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.NotMatchedClause

accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.OnClause

accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.UsingClause

accept(SelectVisitor) - Method in class com.exasol.sql.dql.select.FromClause

accept(SelectVisitor) - Method in class com.exasol.sql.dql.select.GroupByClause

accept(SelectVisitor) - Method in class com.exasol.sql.dql.select.Join

accept(SelectVisitor) - Method in class com.exasol.sql.dql.select.LimitClause

accept(SelectVisitor) - Method in class com.exasol.sql.dql.select.OrderByClause

accept(SelectVisitor) - Method in class com.exasol.sql.dql.select.Select

accept(SelectVisitor) - Method in interface com.exasol.sql.dql.select.SelectFragment

Accept a visitor (e.g.

accept(SelectVisitor) - Method in class com.exasol.sql.dql.select.WhereClause

Accept a visitor for SELECT statements

accept(MergeVisitor) - Method in class com.exasol.sql.dql.select.WhereClause

Accept a visitor for MERGE statements

accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.AbstractBooleanExpression

accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.AbstractBooleanExpression

accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.BinaryArithmeticExpression

accept(BooleanExpressionVisitor) - Method in interface com.exasol.sql.expression.BooleanExpression

Accept a visitor

accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.BooleanLiteral

accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.ColumnReference

accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.DefaultValue

accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.DoubleLiteral

accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.FloatLiteral

accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.function.exasol.ExasolFunction

accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.function.exasol.ExasolUdf

accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.IntegerLiteral

accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.LongLiteral

accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.NullLiteral

accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.StringLiteral

accept(ValueExpressionVisitor) - Method in interface com.exasol.sql.expression.ValueExpression

Accept a visitor

accept(CreateTableVisitor) - Method in class com.exasol.sql.Table

accept(DropTableVisitor) - Method in class com.exasol.sql.Table

accept(MergeVisitor) - Method in class com.exasol.sql.Table

accept(InsertVisitor) - Method in class com.exasol.sql.Table

accept(SelectVisitor) - Method in class com.exasol.sql.Table

accept(ValueExpressionVisitor) - Method in class com.exasol.sql.UnnamedPlaceholder

accept(ValueTableVisitor) - Method in class com.exasol.sql.ValueTable

Accept a visitor.

accept(ValueTableVisitor) - Method in class com.exasol.sql.ValueTableRow

Accept a visitor.

acceptConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.AbstractBooleanExpression

Sub-classes must override this method so that the visitor knows the type of the visited class at compile time.

acceptConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.And

acceptConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.BooleanLiteral

acceptConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Comparison

acceptConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Not

acceptConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Or

add(String, DataType) - Method in class com.exasol.sql.ColumnsDefinition

Add a new column to the ColumnsDefinition

add(String...) - Method in class com.exasol.sql.ValueTable

Add string values to the last row of the value table.

add(char...) - Method in class com.exasol.sql.ValueTable

Add character values to the last row of the value table.

add(int...) - Method in class com.exasol.sql.ValueTable

Add integer values to the last row of the value table.

add(long...) - Method in class com.exasol.sql.ValueTable

Add long values to the last row of the value table.

add(double...) - Method in class com.exasol.sql.ValueTable

Add double values to the last row of the value table.

add(float...) - Method in class com.exasol.sql.ValueTable

Add float values to the last row of the value table.

add(boolean...) - Method in class com.exasol.sql.ValueTable

Add boolean values to the last row of the value table.

add(ValueExpression...) - Method in class com.exasol.sql.ValueTable

Add a list of value expressions to the last row of the value table.

add(String...) - Method in class com.exasol.sql.ValueTableRow.Builder

Add one or more string literals to the row.

add(char...) - Method in class com.exasol.sql.ValueTableRow.Builder

Add one or more char literals to the row.

add(int...) - Method in class com.exasol.sql.ValueTableRow.Builder

Add one or more integer literals to the row.

add(long...) - Method in class com.exasol.sql.ValueTableRow.Builder

Add one or more long literals to the row.

add(double...) - Method in class com.exasol.sql.ValueTableRow.Builder

Add one or more double literals to the row.

add(float...) - Method in class com.exasol.sql.ValueTableRow.Builder

Add one or more float literals to the row.

add(boolean...) - Method in class com.exasol.sql.ValueTableRow.Builder

Add one or more boolean literals to the row.

add(List<ValueExpression>) - Method in class com.exasol.sql.ValueTableRow.Builder

Add a list of expressions to the ValueTableRow.

addChild(TreeNode) - Method in class com.exasol.util.AbstractBottomUpTreeNode

addChild(TreeNode) - Method in class com.exasol.util.AbstractTreeNode

addChild(TreeNode) - Method in interface com.exasol.util.TreeNode

Add a child node below this node.

addPlaceholder() - Method in class com.exasol.sql.ValueTable

Add an unnamed placeholder to the value table.

addPlaceholder() - Method in class com.exasol.sql.ValueTableRow.Builder

Add an UnnamedPlaceholder to the row.

all() - Method in class com.exasol.sql.dql.select.Select

Add a wildcard field for all involved fields.

And - Class in com.exasol.sql.expression

This class represents

And(BooleanExpression...) - Constructor for class com.exasol.sql.expression.And

Create a new And instance

And(boolean...) - Constructor for class com.exasol.sql.expression.And

Create a new And instance

and(boolean...) - Static method in class com.exasol.sql.expression.BooleanTerm

and(BooleanExpression, boolean) - Static method in class com.exasol.sql.expression.BooleanTerm

and(boolean, BooleanExpression) - Static method in class com.exasol.sql.expression.BooleanTerm

and(BooleanExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm

append(String) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer

append(String) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer

append(int) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer

appendAutoQuoted(String) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer

appendAutoQuoted(String) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer

appendBooleanLiteral(BooleanLiteral) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer

appendCommaWhenNeeded(ValueExpression) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer

appendCommaWhenNeeded(Fragment) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer

appendKeyword(String) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer

appendKeyWord(String) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer

appendListOfValueExpressions(List<? extends ValueExpression>) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer

appendOperand(ValueExpression) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer

appendOperand(ValueExpression) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

appendRenderedBooleanExpression(BooleanExpression) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer

appendRenderedValueExpression(ValueExpression) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer

appendRow(String...) - Method in class com.exasol.sql.ValueTable

Append a value table row consisting of value literals to the value table.

appendRow(ValueTableRow) - Method in class com.exasol.sql.ValueTable

Append a ValueTableRow to the ValueTable.

appendSpace() - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer

appendValueTableRow(ValueTableRow) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer

arithmeticExpression(BinaryArithmeticExpression) - Method in class com.exasol.sql.dql.select.Select

Add an arithmetic expression.

arithmeticExpression(BinaryArithmeticExpression, String) - Method in class com.exasol.sql.dql.select.Select

Add an arithmetic expression.

asc() - Method in class com.exasol.sql.dql.select.OrderByClause

Add ASC option to the OrderByClause

B

BinaryArithmeticExpression - Class in com.exasol.sql.expression

This class represents a binary arithmetic expression.

BinaryArithmeticExpression.BinaryArithmeticOperator - Enum in com.exasol.sql.expression

This enum represents arithmetic operators in an SQL statement.

Boolean - Class in com.exasol.datatype.type

This class implements the SQL data type boolean

Boolean() - Constructor for class com.exasol.datatype.type.Boolean

booleanColumn(String) - Method in class com.exasol.sql.ColumnsDefinition.Builder

Add boolean column

booleanColumn(String) - Method in class com.exasol.sql.ddl.create.CreateTable

Add boolean column

BooleanExpression - Interface in com.exasol.sql.expression

Common interface for all types of boolean expressions

BooleanExpressionRenderer - Class in com.exasol.sql.expression.rendering

BooleanExpressionRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.expression.rendering.BooleanExpressionRenderer

BooleanExpressionRenderer() - Constructor for class com.exasol.sql.expression.rendering.BooleanExpressionRenderer

BooleanExpressionVisitor - Interface in com.exasol.sql.expression

Visitor interface for a BooleanTerm

BooleanLiteral - Class in com.exasol.sql.expression

This class represents boolean literals (read "true" and "false")

booleanLiteral(boolean) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create a boolean literal.

BooleanTerm - Class in com.exasol.sql.expression

build() - Method in class com.exasol.sql.ColumnsDefinition.Builder

Build a new ColumnsDefinition.

build() - Method in class com.exasol.sql.rendering.StringRendererConfig.Builder

Create a new instance of a StringRendererConfig

build() - Method in class com.exasol.sql.ValueTableRow.Builder

Build a new ValueTableRow.

builder() - Static method in class com.exasol.sql.ColumnsDefinition

Create a new builder for ColumnsDefinition.

Builder() - Constructor for class com.exasol.sql.ColumnsDefinition.Builder

builder - Variable in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer

builder() - Static method in class com.exasol.sql.rendering.StringRendererConfig

Get a builder for StringRendererConfig

builder(Fragment) - Static method in class com.exasol.sql.ValueTableRow

Get a ValueTableRow.Builder for a ValueTableRow.

Builder(Fragment) - Constructor for class com.exasol.sql.ValueTableRow.Builder

C

Cascade - Class in com.exasol.sql.ddl.drop

This class represents CASCADE clause in DROP SCHEMA SQL statement

Cascade(Fragment) - Constructor for class com.exasol.sql.ddl.drop.Cascade

Create an instance of Cascade class

cascade() - Method in class com.exasol.sql.ddl.drop.DropSchema

Add CASCADE clause to a DROP SCHEMA statement.

CascadeConstraints - Class in com.exasol.sql.ddl.drop

This class represents CASCADE CONSTRAINTS clause in the DROP TABLE SQL statement

CascadeConstraints(Fragment) - Constructor for class com.exasol.sql.ddl.drop.CascadeConstraints

Create an instance of CascadeConstraints class

cascadeConstraints() - Method in class com.exasol.sql.ddl.drop.DropTable

Add CASCADE CONSTRAINTS clause into a DROP TABLE statement.

Char - Class in com.exasol.datatype.type

This class implements the SQL data type char

Char(int) - Constructor for class com.exasol.datatype.type.Char

Create a new instance of an Char data type

charColumn(String, int) - Method in class com.exasol.sql.ColumnsDefinition.Builder

Add char column.

charColumn(String, int) - Method in class com.exasol.sql.ddl.create.CreateTable

Add char column.

Column - Class in com.exasol.sql

This class represents a column in an SQL statement

Column(Fragment, String, DataType) - Constructor for class com.exasol.sql.Column

Create a new instance of a Column

column(String, String) - Static method in class com.exasol.sql.expression.ColumnReference

Create a new ColumnReference from a column name and a table name.

column(String) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create a reference to a table column.

column(String, String) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create a reference to a column in a specific table.

ColumnDefinitionVisitor - Interface in com.exasol.sql

ColumnReference - Class in com.exasol.sql.expression

This class represents column reference.

ColumnsDefinition - Class in com.exasol.sql

This class represents a list of column definitions in an SQL statement.

ColumnsDefinition(SqlStatement) - Constructor for class com.exasol.sql.ColumnsDefinition

Create an new instance of ColumnsDefinition.

ColumnsDefinition(List<Column>) - Constructor for class com.exasol.sql.ColumnsDefinition

Create an new instance of ColumnsDefinition.

ColumnsDefinition.Builder - Class in com.exasol.sql

A builder for ColumnsDefinition.

ColumnsDefinitionRenderer - Class in com.exasol.sql.rendering

Renderer for columns definition.

ColumnsDefinitionRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.rendering.ColumnsDefinitionRenderer

Create a new instance of an AbstractFragmentRenderer-based class.

com.exasol.datatype.type - package com.exasol.datatype.type

com.exasol.datatype.value - package com.exasol.datatype.value

com.exasol.sql - package com.exasol.sql

com.exasol.sql.ddl - package com.exasol.sql.ddl

com.exasol.sql.ddl.create - package com.exasol.sql.ddl.create

com.exasol.sql.ddl.create.rendering - package com.exasol.sql.ddl.create.rendering

com.exasol.sql.ddl.drop - package com.exasol.sql.ddl.drop

com.exasol.sql.ddl.drop.rendering - package com.exasol.sql.ddl.drop.rendering

com.exasol.sql.dml.insert - package com.exasol.sql.dml.insert

com.exasol.sql.dml.insert.rendering - package com.exasol.sql.dml.insert.rendering

com.exasol.sql.dml.merge - package com.exasol.sql.dml.merge

com.exasol.sql.dml.merge.rendering - package com.exasol.sql.dml.merge.rendering

com.exasol.sql.dql.select - package com.exasol.sql.dql.select

com.exasol.sql.dql.select.rendering - package com.exasol.sql.dql.select.rendering

com.exasol.sql.expression - package com.exasol.sql.expression

com.exasol.sql.expression.function - package com.exasol.sql.expression.function

com.exasol.sql.expression.function.exasol - package com.exasol.sql.expression.function.exasol

com.exasol.sql.expression.rendering - package com.exasol.sql.expression.rendering

com.exasol.sql.rendering - package com.exasol.sql.rendering

com.exasol.util - package com.exasol.util

compare(ValueExpression, String, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm

compare(ValueExpression, ComparisonOperator, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm

Comparison - Class in com.exasol.sql.expression

Comparison(ComparisonOperator, ValueExpression, ValueExpression) - Constructor for class com.exasol.sql.expression.Comparison

ComparisonOperator - Enum in com.exasol.sql.expression

This enum represents the different types of Comparisons that can be used in Expressions.

config - Variable in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer

config - Variable in class com.exasol.sql.rendering.AbstractFragmentRenderer

connect(BooleanExpression) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer

connectorDeque - Variable in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer

create() - Static method in class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer

Create an CreateSchemaRenderer using the default renderer configuration

create(StringRendererConfig) - Static method in class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer

Create an CreateSchemaRenderer

create() - Static method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer

Create an CreateTableRenderer using the default renderer configuration

create(StringRendererConfig) - Static method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer

Create an CreateTableRenderer

create() - Static method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer

Create an DropSchemaRenderer using the default renderer configuration

create(StringRendererConfig) - Static method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer

Create an DropSchemaRenderer

create() - Static method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer

Create an DropTableRenderer using the default renderer configuration

create(StringRendererConfig) - Static method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer

Create an DropTableRenderer

create() - Static method in class com.exasol.sql.dml.insert.rendering.InsertRenderer

Create an InsertRenderer using the default renderer configuration

create(StringRendererConfig) - Static method in class com.exasol.sql.dml.insert.rendering.InsertRenderer

Create an InsertRenderer

create(StringRendererConfig) - Static method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

Create a MergeRenderer.

create() - Static method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

Create a MergeRenderer using the default renderer configuration.

create() - Static method in class com.exasol.sql.dql.select.rendering.SelectRenderer

Create an SelectRenderer using the default renderer configuration

create(StringRendererConfig) - Static method in class com.exasol.sql.dql.select.rendering.SelectRenderer

Create an SelectRenderer

createDefault() - Static method in class com.exasol.sql.rendering.StringRendererConfig

Create the default configuration.

createInsertValueInstanceIfItDoesNotExist() - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable

CreateSchema - Class in com.exasol.sql.ddl.create

This class implements an SQL CreateSchema statement.

CreateSchema(String) - Constructor for class com.exasol.sql.ddl.create.CreateSchema

Create a new instance of an CreateSchema statement.

createSchema(String) - Method in class com.exasol.sql.StatementFactory

Create a CreateSchema statement.

CreateSchemaFragment - Interface in com.exasol.sql.ddl.create

This is the common interface for all fragments of a CREATE SCHEMA statement.

CreateSchemaRenderer - Class in com.exasol.sql.ddl.create.rendering

The CreateSchemaRenderer turns SQL statement structures in to SQL strings.

CreateSchemaRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer

Create a new CreateSchemaRenderer with custom render settings.

CreateSchemaVisitor - Interface in com.exasol.sql.ddl.create

CreateTable - Class in com.exasol.sql.ddl.create

This class implements an SQL CreateTable statement

CreateTable(String) - Constructor for class com.exasol.sql.ddl.create.CreateTable

Create a new instance of an CreateTable statement

createTable(String) - Method in class com.exasol.sql.StatementFactory

Create a CreateTable statement.

CreateTableFragment - Interface in com.exasol.sql.ddl.create

This is the common interface for all fragments of a CREATE TABLE statement.

CreateTableRenderer - Class in com.exasol.sql.ddl.create.rendering

The CreateTableRenderer turns SQL statement structures in to SQL strings.

CreateTableRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.ddl.create.rendering.CreateTableRenderer

Create a new CreateTableRenderer with custom render settings.

CreateTableVisitor - Interface in com.exasol.sql.ddl.create

D

DataType - Interface in com.exasol.datatype.type

This class represents different SQL data types

Date - Class in com.exasol.datatype.type

This class implements the SQL data type date

Date() - Constructor for class com.exasol.datatype.type.Date

dateColumn(String) - Method in class com.exasol.sql.ColumnsDefinition.Builder

Add date column.

dateColumn(String) - Method in class com.exasol.sql.ddl.create.CreateTable

Add date column

Decimal - Class in com.exasol.datatype.type

This class implements the Exasol-proprietary data type decimal

Decimal(int, int) - Constructor for class com.exasol.datatype.type.Decimal

Create a new instance of an Decimal data type

decimalColumn(String, int, int) - Method in class com.exasol.sql.ColumnsDefinition.Builder

Add decimal column.

decimalColumn(String, int, int) - Method in class com.exasol.sql.ddl.create.CreateTable

Add decimal column.

DefaultValue - Class in com.exasol.sql.expression

The DefaultValue is an expression that tells the database to take the default value for a column (in case it is defined).

DefaultValue() - Constructor for class com.exasol.sql.expression.DefaultValue

defaultValue() - Static method in class com.exasol.sql.expression.DefaultValue

DerivedColumn - Class in com.exasol.sql

This class represents a derived column in an SQL query.

DerivedColumn(Fragment, ValueExpression) - Constructor for class com.exasol.sql.DerivedColumn

Create a new instance of a DerivedColumn.

DerivedColumn(Fragment, ValueExpression, String) - Constructor for class com.exasol.sql.DerivedColumn

Create a new instance of a DerivedColumn.

desc() - Method in class com.exasol.sql.dql.select.OrderByClause

Add DESC option to the OrderByClause

dismissConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.AbstractBooleanExpression

Sub-classes must override this method so that the visitor knows the type of the visited class at compile time.

dismissConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.And

dismissConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.BooleanLiteral

dismissConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Comparison

dismissConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Not

dismissConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Or

divide(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create a binary arithmetic expression with DIVIDE operator.

DoubleLiteral - Class in com.exasol.sql.expression

This class represents double literals.

doubleLiteral(double) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create a double literal.

DoublePrecision - Class in com.exasol.datatype.type

This class implements a double precision floating point number data type

DoublePrecision() - Constructor for class com.exasol.datatype.type.DoublePrecision

doublePrecisionColumn(String) - Method in class com.exasol.sql.ColumnsDefinition.Builder

Add double precision column.

doublePrecisionColumn(String) - Method in class com.exasol.sql.ddl.create.CreateTable

Add double precision column

DropSchema - Class in com.exasol.sql.ddl.drop

This class implements an SQL DropSchema statement.

DropSchema(String) - Constructor for class com.exasol.sql.ddl.drop.DropSchema

Create a new instance of an DropSchema statement.

dropSchema(String) - Method in class com.exasol.sql.StatementFactory

Create a DropSchema statement.

DropSchemaFragment - Interface in com.exasol.sql.ddl.drop

This is the common interface for all fragments of a DROP SCHEMA statement.

DropSchemaRenderer - Class in com.exasol.sql.ddl.drop.rendering

The DropSchemaRenderer turns SQL statement structures in to SQL strings.

DropSchemaRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer

Create a new DropSchemaRenderer with custom render settings.

DropSchemaVisitor - Interface in com.exasol.sql.ddl.drop

DropTable - Class in com.exasol.sql.ddl.drop

This class implements an SQL DropTable statement.

DropTable(String) - Constructor for class com.exasol.sql.ddl.drop.DropTable

Create a new instance of an DropTable statement.

dropTable(String) - Method in class com.exasol.sql.StatementFactory

Create a DropTable statement.

DropTableFragment - Interface in com.exasol.sql.ddl.drop

This is the common interface for all fragments of a DROP TABLE statement.

DropTableRenderer - Class in com.exasol.sql.ddl.drop.rendering

The DropTableRenderer turns SQL statement structures in to SQL strings.

DropTableRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.ddl.drop.rendering.DropTableRenderer

Create a new DropTableRenderer with custom render settings.

DropTableVisitor - Interface in com.exasol.sql.ddl.drop

E

endParenthesis() - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer

eq(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm

ExasolAggregateFunction - Enum in com.exasol.sql.expression.function.exasol

This class is a list of Aggregate Functions that the Exasol database supports.

ExasolAnalyticFunctions - Enum in com.exasol.sql.expression.function.exasol

This class is a list of Analytic Functions that the Exasol database supports.

ExasolFunction - Class in com.exasol.sql.expression.function.exasol

This class represents a function in the Exasol database.

ExasolScalarFunction - Enum in com.exasol.sql.expression.function.exasol

This class is a list of Scalar Functions that the Exasol database supports.

ExasolUdf - Class in com.exasol.sql.expression.function.exasol

This class represents a User Defined Function in the Exasol database.

ExpressionTerm - Class in com.exasol.sql.expression

Static factory methods for SQL expressions.

F

field(String...) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable

Define fields into which should be inserted.

field(String...) - Method in class com.exasol.sql.dql.select.Select

Add one or more named fields.

floatLiteral(float) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create a float literal.

FloatLiteral - Class in com.exasol.sql.expression

This class represents float literals.

Fragment - Interface in com.exasol.sql

This is the common interface for all fragments of SQL statements.

FragmentRenderer - Interface in com.exasol.sql.rendering

from() - Method in class com.exasol.sql.dql.select.Select

Get the FromClause of this select statement.

FromClause - Class in com.exasol.sql.dql.select

This class represents the FROM clause of an SQL SELECT statement.

FromClause(Fragment) - Constructor for class com.exasol.sql.dql.select.FromClause

Create a new instance of a FromClause.

fullJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause

Create a new full Join that belongs to a FROM clause.

fullOuterJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause

Create a new full outer Join that belongs to a FROM clause.

function(FunctionName, ValueExpression...) - Method in class com.exasol.sql.dql.select.Select

Add a function.

function(FunctionName, String, ValueExpression...) - Method in class com.exasol.sql.dql.select.Select

Add a function.

function(FunctionName) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create an Exasol function.

function(FunctionName, ValueExpression...) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create an Exasol function.

Function - Interface in com.exasol.sql.expression.function

This class represents a function in an SQL statement.

functionName - Variable in class com.exasol.sql.expression.function.AbstractFunction

FunctionName - Interface in com.exasol.sql.expression.function

G

ge(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm

getAlias() - Method in class com.exasol.sql.Table

Get the correlation name (i.e.

getAutoQuoted(String) - Method in class com.exasol.util.QuotesApplier

Applies quotes if it ie required in the configuration.

getCascade() - Method in class com.exasol.sql.ddl.drop.DropSchema

Get the cascade.

getCascadeConstraints() - Method in class com.exasol.sql.ddl.drop.DropTable

getChild(int) - Method in class com.exasol.util.AbstractBottomUpTreeNode

getChild(int) - Method in class com.exasol.util.AbstractTreeNode

getChild(int) - Method in interface com.exasol.util.TreeNode

Get child node by position in the list of siblings.

getChildren() - Method in class com.exasol.util.AbstractBottomUpTreeNode

getChildren() - Method in class com.exasol.util.AbstractTreeNode

getChildren() - Method in interface com.exasol.util.TreeNode

Get all child nodes of this node

getColumn() - Method in class com.exasol.sql.dml.merge.MergeColumnUpdate

Get the column to be updated.

getColumnName() - Method in class com.exasol.sql.Column

Get the column name

getColumnName() - Method in class com.exasol.sql.expression.ColumnReference

Get the column name.

getColumnReferences() - Method in class com.exasol.sql.dql.select.GroupByClause

Get list of column references.

getColumnReferences() - Method in class com.exasol.sql.dql.select.OrderByClause

Get list of column references.

getColumns() - Method in class com.exasol.sql.ColumnsDefinition

Get a list of columns.

getColumnsDefinition() - Method in class com.exasol.sql.ddl.create.CreateTable

Get columns definition of the table.

getCondition() - Method in class com.exasol.sql.dml.merge.OnClause

Get the merge condition.

getCount() - Method in class com.exasol.sql.dql.select.LimitClause

Get the maximum number of rows to be handed back

getDataType() - Method in class com.exasol.sql.Column

Get the column data type

getDelete() - Method in class com.exasol.sql.dml.merge.MatchedClause

Get the THEN DELETE clause.

getDerivedColumnName() - Method in class com.exasol.sql.DerivedColumn

Get a derived column name.

getDesc() - Method in class com.exasol.sql.dql.select.OrderByClause

Get descending.

getEmitsColumnsDefinition() - Method in class com.exasol.sql.expression.function.exasol.ExasolUdf

Get a columns definition for the EMITS.

getExpression() - Method in class com.exasol.sql.dml.merge.MergeColumnUpdate

Get the expression that serves as the value for the update.

getExpression() - Method in class com.exasol.sql.dql.select.WhereClause

Get the boolean expression defining the filter criteria

getExpressions() - Method in class com.exasol.sql.ValueTableRow

Get the list of expressions the row consists of.

getFunctionName() - Method in class com.exasol.sql.expression.function.AbstractFunction

getFunctionName() - Method in interface com.exasol.sql.expression.function.Function

Get a function's name.

getHavingBooleanExpression() - Method in class com.exasol.sql.dql.select.GroupByClause

Get the boolean expression.

getInsert() - Method in class com.exasol.sql.dml.merge.NotMatchedClause

Get the THEN INSERT clause.

getInstance() - Static method in class com.exasol.sql.StatementFactory

Get an instance of a StatementFactory.

getLeft() - Method in class com.exasol.sql.expression.BinaryArithmeticExpression

Get a left operand of the arithmetic expression.

getLeftOperand() - Method in class com.exasol.sql.expression.Comparison

Get the left-hand side operator of the comparison

getLength() - Method in class com.exasol.datatype.type.AbstractStringDataType

getMatched() - Method in class com.exasol.sql.dml.merge.Merge

Get the WHEN MATCHED clause.

getMillisecondPrecision() - Method in class com.exasol.datatype.type.IntervalDayToSecond

getName() - Method in class com.exasol.datatype.type.AbstractStringDataType

getName() - Method in class com.exasol.datatype.type.Boolean

getName() - Method in interface com.exasol.datatype.type.DataType

getName() - Method in class com.exasol.datatype.type.Date

getName() - Method in class com.exasol.datatype.type.Decimal

getName() - Method in class com.exasol.datatype.type.DoublePrecision

getName() - Method in class com.exasol.datatype.type.IntervalDayToSecond

getName() - Method in class com.exasol.datatype.type.IntervalYearToMonth

getName() - Method in class com.exasol.datatype.type.Timestamp

getName() - Method in class com.exasol.datatype.type.TimestampWithLocalTimezone

getName() - Method in class com.exasol.sql.ddl.Schema

Get the schema name

getName() - Method in class com.exasol.sql.dql.select.Join

Get the name of the joined table

getName() - Method in class com.exasol.sql.Table

Get the name of the table

getNotMatched() - Method in class com.exasol.sql.dml.merge.Merge

Get the WHEN NOT MATCHED clause.

getNullsFirst() - Method in class com.exasol.sql.dql.select.OrderByClause

Get nulls first.

getOffset() - Method in class com.exasol.sql.dql.select.LimitClause

Get the offset row for the limit

getOn() - Method in class com.exasol.sql.dml.merge.Merge

Get the merge criteria (i.e.

getOperator() - Method in class com.exasol.sql.expression.Comparison

Get the comparison operator

getParent() - Method in class com.exasol.util.AbstractBottomUpTreeNode

getParent() - Method in class com.exasol.util.AbstractTreeNode

getParent() - Method in interface com.exasol.util.TreeNode

Get the parent of this node

getPrecision() - Method in class com.exasol.datatype.type.Decimal

getRestrict() - Method in class com.exasol.sql.ddl.drop.DropSchema

Get the restriction.

getRight() - Method in class com.exasol.sql.expression.BinaryArithmeticExpression

Get a right operand of the arithmetic expression.

getRightOperand() - Method in class com.exasol.sql.expression.Comparison

Get the right-hand side operator of the comparison

getRoot() - Method in class com.exasol.sql.AbstractFragment

getRoot() - Method in interface com.exasol.sql.Fragment

Get the root statement of this SQL fragment.

getRoot() - Method in class com.exasol.util.AbstractBottomUpTreeNode

getRoot() - Method in class com.exasol.util.AbstractTreeNode

getRoot() - Method in interface com.exasol.util.TreeNode

Get the root of the tree

getRows() - Method in class com.exasol.sql.ValueTable

Get a list of all rows in the value table.

getScale() - Method in class com.exasol.datatype.type.Decimal

getSchemaName() - Method in class com.exasol.sql.ddl.create.CreateSchema

Get the schema name.

getSchemaName() - Method in class com.exasol.sql.ddl.drop.DropSchema

Get the schema name.

getSign() - Method in class com.exasol.datatype.value.AbstractInterval

getSignedValue() - Method in class com.exasol.datatype.value.AbstractInterval

getSpecification() - Method in class com.exasol.sql.dql.select.Join

Get the join specification

getStringOperatorRepresentation() - Method in class com.exasol.sql.expression.BinaryArithmeticExpression

Get a string representation of a member of this enum class.

getTableName() - Method in class com.exasol.sql.ddl.create.CreateTable

Get the table name

getTableName() - Method in class com.exasol.sql.ddl.drop.DropTable

getTableName() - Method in class com.exasol.sql.dml.insert.Insert

Get the name of the table into which data should be inserted

getTableName() - Method in class com.exasol.sql.expression.ColumnReference

Get the table name.

getType() - Method in class com.exasol.sql.dql.select.Join

Get the type of the join

getUpdate() - Method in class com.exasol.sql.dml.merge.MatchedClause

Get the THEN UPDATE clause.

getUsing() - Method in class com.exasol.sql.dml.merge.Merge

Get the USING clause of the MERGE statement.

getValue() - Method in class com.exasol.sql.expression.DoubleLiteral

Get the value of the DoubleLiteral

getValue() - Method in class com.exasol.sql.expression.FloatLiteral

Get the value of the FloatLiteral

getValue() - Method in class com.exasol.sql.expression.IntegerLiteral

Get the value of the IntegerLiteral.

getValue() - Method in class com.exasol.sql.expression.LongLiteral

Get the value of the LongLiteral

getValueExpression() - Method in class com.exasol.sql.DerivedColumn

Get a value expression that belongs to this derived column.

getWhere() - Method in class com.exasol.sql.dml.merge.MergeInsertClause

Get the WHERE clause of the insert definition.

getWhere() - Method in class com.exasol.sql.dml.merge.MergeMethodDefinition

Get the WHERE clause of the merge method definition.

getYearPrecision() - Method in class com.exasol.datatype.type.IntervalDayToSecond

getYearPrecision() - Method in class com.exasol.datatype.type.IntervalYearToMonth

groupBy(ColumnReference...) - Method in class com.exasol.sql.dql.select.Select

Create a new GroupByClause.

GroupByClause - Class in com.exasol.sql.dql.select

This class represents the GROUP BY clause of an SQL statement.

GroupByClause(SqlStatement, ColumnReference...) - Constructor for class com.exasol.sql.dql.select.GroupByClause

Create a new instance of a GroupByClause.

gt(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm

H

hasAlias() - Method in class com.exasol.sql.Table

Check if a correlation name (i.a.

hasDelete() - Method in class com.exasol.sql.dml.merge.MatchedClause

Check if the THEN DELETE clause is present.

hasDerivedColumnName() - Method in class com.exasol.sql.DerivedColumn

Check if this function has a derived column name.

hasEmitsColumnsDefinition() - Method in class com.exasol.sql.expression.function.exasol.ExasolUdf

Check if the EMITS part is required.

hasFields() - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable

Check if a insert fields are defined.

hasIfExistsModifier() - Method in class com.exasol.sql.ddl.drop.DropSchema

Check whether the IF EXISTS clause is present.

hasIfExistsModifier() - Method in class com.exasol.sql.ddl.drop.DropTable

Check if the IF EXISTS clause is present.

hasInsert() - Method in class com.exasol.sql.dml.merge.NotMatchedClause

Check if the THEN INSERT clause is present.

hasMatched() - Method in class com.exasol.sql.dml.merge.Merge

Check if the WHEN MATCHED clause exists.

hasNotMatched() - Method in class com.exasol.sql.dml.merge.Merge

Check if the WHEN NOT MATCHED clause exists.

hasOffset() - Method in class com.exasol.sql.dql.select.LimitClause

Check if the limit clause has an offset

hasOn() - Method in class com.exasol.sql.dml.merge.Merge

Check if the ON clause exists.

hasParenthesis() - Method in class com.exasol.sql.expression.function.exasol.ExasolFunction

hasParenthesis() - Method in class com.exasol.sql.expression.function.exasol.ExasolUdf

hasParenthesis() - Method in interface com.exasol.sql.expression.function.Function

Check if function needs parenthesis.

hasUpdate() - Method in class com.exasol.sql.dml.merge.MatchedClause

Check if the THEN UPDATE clause is present.

hasUsing() - Method in class com.exasol.sql.dml.merge.Merge

Check if the USING clause exists.

hasValues() - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable

Check if a value table is present.

hasWhere() - Method in class com.exasol.sql.dml.merge.MergeInsertClause

Check if the WHERE clause exists.

hasWhere() - Method in class com.exasol.sql.dml.merge.MergeMethodDefinition

Check if the WHERE clause exists.

having(BooleanExpression) - Method in class com.exasol.sql.dql.select.GroupByClause

Add having statement to the SQL query.

I

ifExists() - Method in class com.exasol.sql.ddl.drop.DropSchema

Add IF EXISTS clause into a DROP SCHEMA statement.

ifExists() - Method in class com.exasol.sql.ddl.drop.DropTable

Add IF EXISTS clause into a DROP TABLE statement.

innerJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause

Create a new inner Join that belongs to a FROM clause.

Insert - Class in com.exasol.sql.dml.insert

This class implements an SQL Insert statement.

Insert(String) - Constructor for class com.exasol.sql.dml.insert.Insert

Create a new instance of an Insert statement

insertFields - Variable in class com.exasol.sql.dml.insert.AbstractInsertValueTable

InsertFields - Class in com.exasol.sql.dml.insert

Field list that defines the fields data is being inserted into.

InsertFields(Fragment) - Constructor for class com.exasol.sql.dml.insert.InsertFields

Create an new instance of InsertFields

InsertFragment - Interface in com.exasol.sql.dml.insert

This is the common interface for all fragments of a INSERT statement.

insertInto(String) - Method in class com.exasol.sql.StatementFactory

Create an Insert statement.

InsertRenderer - Class in com.exasol.sql.dml.insert.rendering

The InsertRenderer turns SQL statement structures in to SQL strings.

InsertRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.dml.insert.rendering.InsertRenderer

Create a new InsertRenderer with custom render settings.

insertValueTable - Variable in class com.exasol.sql.dml.insert.AbstractInsertValueTable

InsertVisitor - Interface in com.exasol.sql.dml.insert

integerLiteral(int) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create an integer literal.

IntegerLiteral - Class in com.exasol.sql.expression

This class represents integer literals.

IntervalDayToSecond - Class in com.exasol.datatype.type

This class implements the Exasol-proprietary data type interval day to second

IntervalDayToSecond(int, int) - Constructor for class com.exasol.datatype.type.IntervalDayToSecond

Create a new instance of an IntervalDayToSecond data type

IntervalDayToSecond - Class in com.exasol.datatype.value

This class implements the Exasol-proprietary data type value INTERVAL DAY(x) TO SECONDS(y) .

intervalDayToSecondColumn(String, int, int) - Method in class com.exasol.sql.ColumnsDefinition.Builder

Add interval day to second column.

intervalDayToSecondColumn(String, int, int) - Method in class com.exasol.sql.ddl.create.CreateTable

Add interval day to second column.

IntervalYearToMonth - Class in com.exasol.datatype.type

This class implements the Exasol-proprietary data type interval year to month

IntervalYearToMonth(int) - Constructor for class com.exasol.datatype.type.IntervalYearToMonth

Create a new instance of an IntervalYearToMonth data type

IntervalYearToMonth - Class in com.exasol.datatype.value

This class implements the Exasol-proprietary data type value INTERVAL YEAR(x) TO MONTH(y) .

intervalYearToMonthColumn(String, int) - Method in class com.exasol.sql.ColumnsDefinition.Builder

Add interval year to month column.

intervalYearToMonthColumn(String, int) - Method in class com.exasol.sql.ddl.create.CreateTable

Add interval year to month column.

isChild() - Method in class com.exasol.util.AbstractBottomUpTreeNode

isChild() - Method in class com.exasol.util.AbstractTreeNode

isChild() - Method in interface com.exasol.util.TreeNode

Check whether this node is a child node

isEmpty() - Method in class com.exasol.sql.ValueTable

isFirstSibling() - Method in class com.exasol.util.AbstractBottomUpTreeNode

isFirstSibling() - Method in class com.exasol.util.AbstractTreeNode

isFirstSibling() - Method in interface com.exasol.util.TreeNode

Check whether a child is the first in the list of siblings

isRoot() - Method in class com.exasol.util.AbstractBottomUpTreeNode

isRoot() - Method in class com.exasol.util.AbstractTreeNode

isRoot() - Method in interface com.exasol.util.TreeNode

Check whether this node is the root of the tree.

isSibling(TreeNode) - Method in class com.exasol.util.AbstractBottomUpTreeNode

isSibling(TreeNode) - Method in class com.exasol.util.AbstractTreeNode

isSibling(TreeNode) - Method in interface com.exasol.util.TreeNode

Check whether this node is a sibling of the second node.

J

join(String, String) - Method in class com.exasol.sql.dql.select.FromClause

Create a new Join that belongs to a FROM clause.

Join - Class in com.exasol.sql.dql.select

This class implements the Join part of a WHERE clause.

Join(Fragment, JoinType, String, String) - Constructor for class com.exasol.sql.dql.select.Join

Create a new Join instance

JoinType - Enum in com.exasol.sql.dql.select

This class represents the Join types supported by SQL.

L

le(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm

leave(ColumnsDefinition) - Method in interface com.exasol.sql.ColumnDefinitionVisitor

leave(CreateTable) - Method in interface com.exasol.sql.ddl.create.CreateTableVisitor

leave(CreateTable) - Method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer

leave(InsertFields) - Method in interface com.exasol.sql.dml.insert.InsertVisitor

leave(InsertFields) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer

leave(ValueTable) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer

leave(ValueTableRow) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer

leave(InsertFields) - Method in interface com.exasol.sql.dml.merge.MergeVisitor

Leave the insert field list.

leave(InsertFields) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

leave(ValueTable) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

leave(ValueTableRow) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

leave(ValueTable) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer

leave(ValueTableRow) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer

leave(Not) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor

leave(BooleanLiteral) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor

leave(And) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor

leave(Or) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor

leave(Comparison) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor

leave(Not) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer

leave(And) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer

leave(Or) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer

leave(BooleanLiteral) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer

leave(Comparison) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer

leave(ExasolFunction) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

leave(ExasolUdf) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

leave(ExasolFunction) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

leave(ExasolUdf) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

leave(ColumnsDefinition) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer

leave(ValueTable) - Method in interface com.exasol.sql.ValueTableVisitor

leave(ValueTableRow) - Method in interface com.exasol.sql.ValueTableVisitor

leftJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause

Create a new left Join that belongs to a FROM clause.

leftOuterJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause

Create a new left outer Join that belongs to a FROM clause.

limit(int) - Method in class com.exasol.sql.dql.select.Select

Create a new full outer LimitClause.

limit(int, int) - Method in class com.exasol.sql.dql.select.Select

Create a new full outer LimitClause.

LimitClause - Class in com.exasol.sql.dql.select

This class represents the limit clause of an SQL statement.

LimitClause(SqlStatement, int) - Constructor for class com.exasol.sql.dql.select.LimitClause

Create a new instance of a LimitClause

LimitClause(SqlStatement, int, int) - Constructor for class com.exasol.sql.dql.select.LimitClause

Create a new instance of a LimitClause

longLiteral(long) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create an long literal.

LongLiteral - Class in com.exasol.sql.expression

This class represents long literals.

lowerCase(boolean) - Method in class com.exasol.sql.rendering.StringRendererConfig.Builder

Define whether the statement should be produced in lower case

lt(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm

M

MatchedClause - Class in com.exasol.sql.dml.merge

Representation of the WHEN MATCHED part of an SQL MERGE statement.

MatchedClause(Fragment) - Constructor for class com.exasol.sql.dml.merge.MatchedClause

Create a new instance of a MatchedClause.

Merge - Class in com.exasol.sql.dml.merge

This class implements an SQL Merge statement which is a combination of INSERT, UPDATE and DELETE.

Merge(String) - Constructor for class com.exasol.sql.dml.merge.Merge

Create a new instance of a Merge.

Merge(String, String) - Constructor for class com.exasol.sql.dml.merge.Merge

Create a new instance of a Merge.

MergeColumnUpdate - Class in com.exasol.sql.dml.merge

Update of a value in a column caused by a MERGE command.

MergeColumnUpdate(Fragment, String, ValueExpression) - Constructor for class com.exasol.sql.dml.merge.MergeColumnUpdate

Create a new instance of a MergeColumnUpdate.

MergeDeleteClause - Class in com.exasol.sql.dml.merge

This class represents the MERGE strategy of deleting matched rows.

MergeDeleteClause(Fragment) - Constructor for class com.exasol.sql.dml.merge.MergeDeleteClause

Create a new instance of a MergeDeleteClause.

MergeFragment - Interface in com.exasol.sql.dml.merge

This is the common interface for all fragments of a MERGE statement.

MergeInsertClause - Class in com.exasol.sql.dml.merge

Represents the MERGE strategy of inserting rows from the source that do not match any row in the destination.

MergeInsertClause(Fragment) - Constructor for class com.exasol.sql.dml.merge.MergeInsertClause

Create a new instance of a MergeInsertClause.

mergeInto(String) - Method in class com.exasol.sql.StatementFactory

Create a Merge statement.

mergeInto(String, String) - Method in class com.exasol.sql.StatementFactory

Create a Merge statement.

MergeMethodDefinition - Class in com.exasol.sql.dml.merge

Abstract base class for merge method definitions like WHEN MATCHED THEN UPDATE.

MergeMethodDefinition(Fragment) - Constructor for class com.exasol.sql.dml.merge.MergeMethodDefinition

Create the abstract base for a merge method definition.

MergeRenderer - Class in com.exasol.sql.dml.merge.rendering

The InsertRenderer turns SQL statement structures in to SQL strings.

MergeRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.dml.merge.rendering.MergeRenderer

Create a new MergeRenderer with custom render settings.

MergeUpdateClause - Class in com.exasol.sql.dml.merge

Represents the MERGE strategy of updating matched rows.

MergeUpdateClause(Fragment) - Constructor for class com.exasol.sql.dml.merge.MergeUpdateClause

Create a new instance of a MergeUpdateClause.

MergeVisitor - Interface in com.exasol.sql.dml.merge

Visitor for value tables.

minus(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create a binary arithmetic expression with SUBTRACT operator.

multiply(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create a binary arithmetic expression with DIVIDE operator.

N

name() - Method in interface com.exasol.sql.expression.function.FunctionName

ne(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm

not(boolean) - Static method in class com.exasol.sql.expression.BooleanTerm

not(BooleanExpression) - Static method in class com.exasol.sql.expression.BooleanTerm

Not - Class in com.exasol.sql.expression

This class implements the logical unary NOT

Not(boolean) - Constructor for class com.exasol.sql.expression.Not

Create a new instance of a unary Not from a boolean literal

Not(String) - Constructor for class com.exasol.sql.expression.Not

Create a new instance of a unary Not from a string literal

Not(BooleanExpression) - Constructor for class com.exasol.sql.expression.Not

Create a new instance of a unary Not from a boolean expression

NotMatchedClause - Class in com.exasol.sql.dml.merge

Representation of the WHEN NOT MATCHED part of an SQL MERGE statement.

NotMatchedClause(Fragment) - Constructor for class com.exasol.sql.dml.merge.NotMatchedClause

Create a new instance of a NotMatchedClause.

nullLiteral() - Static method in class com.exasol.sql.expression.ExpressionTerm

Create a NULL literal.

NullLiteral - Class in com.exasol.sql.expression

This class represents a null literal.

nullLiteral() - Static method in class com.exasol.sql.expression.NullLiteral

nullsFirst() - Method in class com.exasol.sql.dql.select.OrderByClause

Add NULLS FIRST option to the OrderByClause

nullsLast() - Method in class com.exasol.sql.dql.select.OrderByClause

Add NULLS LAST option to the OrderByClause

O

of(BinaryArithmeticExpression.BinaryArithmeticOperator, ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BinaryArithmeticExpression

Create a new BinaryArithmeticExpression instance.

of(boolean) - Static method in class com.exasol.sql.expression.BooleanLiteral

of(String) - Static method in class com.exasol.sql.expression.BooleanLiteral

Create a new BooleanLiteral instance from a String.

of(String) - Static method in class com.exasol.sql.expression.ColumnReference

Create a new ColumnReference from a column name.

of(double) - Static method in class com.exasol.sql.expression.DoubleLiteral

Create a new DoubleLiteral from a double.

of(float) - Static method in class com.exasol.sql.expression.FloatLiteral

Create a new FloatLiteral from a float.

of(FunctionName) - Static method in class com.exasol.sql.expression.function.exasol.ExasolFunction

Create a new ExasolFunction instance.

of(FunctionName, ValueExpression...) - Static method in class com.exasol.sql.expression.function.exasol.ExasolFunction

Create a new ExasolFunction instance.

of(String, ColumnsDefinition, ValueExpression...) - Static method in class com.exasol.sql.expression.function.exasol.ExasolUdf

Create a new ExasolUdf instance.

of(String, ValueExpression...) - Static method in class com.exasol.sql.expression.function.exasol.ExasolUdf

Create a new ExasolUdf instance.

of(int) - Static method in class com.exasol.sql.expression.IntegerLiteral

Create a new IntegerLiteral from an integer.

of(long) - Static method in class com.exasol.sql.expression.LongLiteral

Create a new LongLiteral from a long.

of(String) - Static method in class com.exasol.sql.expression.StringLiteral

Create a new StringLiteral from a string.

of(char) - Static method in class com.exasol.sql.expression.StringLiteral

Create a new StringLiteral from a character.

ofMillis(long) - Static method in class com.exasol.datatype.value.IntervalDayToSecond

Create an IntervalDayToSecond from a number of milliseconds

ofMonths(long) - Static method in class com.exasol.datatype.value.IntervalYearToMonth

Create an IntervalDayToSecond from a number of months

ofSymbol(String) - Static method in enum com.exasol.sql.expression.ComparisonOperator

Get the ComparisonOperator for the provided symbol

on(BooleanExpression) - Method in class com.exasol.sql.dml.merge.Merge

Define the merge criteria.

OnClause - Class in com.exasol.sql.dml.merge

The ON clause of an SQL MERGE statement.

OnClause(Fragment, BooleanExpression) - Constructor for class com.exasol.sql.dml.merge.OnClause

Create a new instance of a OnClause.

operation(String, BooleanExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm

Create a logical operation from an operator name and a list of operands

or(boolean...) - Static method in class com.exasol.sql.expression.BooleanTerm

or(BooleanExpression, boolean) - Static method in class com.exasol.sql.expression.BooleanTerm

or(boolean, BooleanExpression) - Static method in class com.exasol.sql.expression.BooleanTerm

or(BooleanExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm

Or - Class in com.exasol.sql.expression

This class represents

Or(BooleanExpression...) - Constructor for class com.exasol.sql.expression.Or

Create a new Or instance

Or(boolean...) - Constructor for class com.exasol.sql.expression.Or

Create a new Or instance

orderBy(ColumnReference...) - Method in class com.exasol.sql.dql.select.Select

Create a new OrderByClause.

OrderByClause - Class in com.exasol.sql.dql.select

This class represents the ORDER BY clause of an SQL statement.

OrderByClause(SqlStatement, ColumnReference...) - Constructor for class com.exasol.sql.dql.select.OrderByClause

Create a new instance of a OrderByClause.

P

parse(String) - Static method in class com.exasol.datatype.value.IntervalDayToSecond

Parse an IntervalDayToSecond from a string

parse(String) - Static method in class com.exasol.datatype.value.IntervalYearToMonth

Parse an IntervalDayToSecond from a string

parseMatchingGroupToLong(Matcher, int) - Static method in class com.exasol.datatype.value.AbstractInterval

plus(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create a binary arithmetic expression with ADD operator.

positive - Variable in class com.exasol.datatype.value.AbstractInterval

Q

quoteIdentifiers(boolean) - Method in class com.exasol.sql.rendering.StringRendererConfig.Builder

Define whether schema, table and field identifiers should be enclosed in double quotation marks.

QuotesApplier - Class in com.exasol.util

This class handles quotes in a string identifier.

QuotesApplier(StringRendererConfig) - Constructor for class com.exasol.util.QuotesApplier

Create a new instance of a QuotesApplier.

R

render() - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer

Render expression to a string

render() - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer

render() - Method in interface com.exasol.sql.rendering.FragmentRenderer

Render an SQL statement to a string.

restrict() - Method in class com.exasol.sql.ddl.drop.DropSchema

Add RESTRICT clause to a DROP SCHEMA statement.

Restrict - Class in com.exasol.sql.ddl.drop

This class represents RESTRICT clause in DROP SCHEMA SQL statement

Restrict(Fragment) - Constructor for class com.exasol.sql.ddl.drop.Restrict

Create an instance of Restrict class

rightJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause

Create a new right Join that belongs to a FROM clause.

rightOuterJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause

Create a new right outer Join that belongs to a FROM clause.

root - Variable in class com.exasol.sql.AbstractFragment

S

Schema - Class in com.exasol.sql.ddl

This class represents a Schema in an SQL Statement

Schema(Fragment, String) - Constructor for class com.exasol.sql.ddl.Schema

Create a new Schema

Select - Class in com.exasol.sql.dql.select

This class implements an SQL Select statement.

Select() - Constructor for class com.exasol.sql.dql.select.Select

Create a new instance of a Select.

select() - Method in class com.exasol.sql.StatementFactory

Create a Select statement.

SelectFragment - Interface in com.exasol.sql.dql.select

This is the common interface for all fragments of a SELECT statement.

SelectRenderer - Class in com.exasol.sql.dql.select.rendering

The SelectRenderer turns SQL statement structures in to SQL strings.

SelectRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.dql.select.rendering.SelectRenderer

Create a new SelectRenderer with custom render settings.

SelectVisitor - Interface in com.exasol.sql.dql.select

self() - Method in class com.exasol.datatype.type.AbstractStringDataType

self() - Method in class com.exasol.datatype.type.Char

self() - Method in class com.exasol.datatype.type.Varchar

self() - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable

self() - Method in class com.exasol.sql.dml.insert.Insert

self() - Method in class com.exasol.sql.dml.merge.MergeInsertClause

set(String, ValueExpression) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause

Update a column with a value expression.

set(String, String) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause

Update a column with a string value.

set(String, char) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause

Update a column with a char value.

set(String, int) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause

Update a column with an integer value.

set(String, long) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause

Update a column with a long value.

set(String, double) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause

Update a column with a double value.

set(String, float) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause

Update a column with a float value.

set(String, boolean) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause

Update a column with a boolean value.

setLastVisited(ValueExpression) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer

setLastVisited(Fragment) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer

setParent(TreeNode) - Method in class com.exasol.util.AbstractBottomUpTreeNode

setParent(TreeNode) - Method in class com.exasol.util.AbstractTreeNode

Link to a parent node

setParent(TreeNode) - Method in interface com.exasol.util.TreeNode

Set a parent for this node.

setToDefault(String) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause

Update a column with the default value defined for that column.

SqlStatement - Interface in com.exasol.sql

This interface represents an SQL statement.

startParenthesis() - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer

StatementFactory - Class in com.exasol.sql

The StatementFactory implements an factory for SQL statements.

stringLiteral(String) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create a string literal.

stringLiteral(char) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create a string literal from a character.

StringLiteral - Class in com.exasol.sql.expression

This class represents string literals (or character literals in SQL terms).

StringRendererConfig - Class in com.exasol.sql.rendering

This class implements a parameter object containing the configuration options for the StatementFactory.

StringRendererConfig.Builder - Class in com.exasol.sql.rendering

Builder for StringRendererConfig

T

table(String) - Method in class com.exasol.sql.dql.select.FromClause

Add a table name to the FromClause.

Table - Class in com.exasol.sql

Represents a Table in an SQL Statement.

Table(Fragment, String) - Constructor for class com.exasol.sql.Table

Create a new Table with a name and an alias.

Table(Fragment, String, String) - Constructor for class com.exasol.sql.Table

Create a new Table with a name and an alias.

tableAs(String, String) - Method in class com.exasol.sql.dql.select.FromClause

Add a table name with an an alias to the FromClause.

thenDelete() - Method in class com.exasol.sql.dml.merge.MatchedClause

Select deleting as merge strategy for rows where that are considered matches between source and destination.

thenInsert() - Method in class com.exasol.sql.dml.merge.NotMatchedClause

Select inserting as merge strategy for rows from the source for which no match in the destination exists.

thenUpdate() - Method in class com.exasol.sql.dml.merge.MatchedClause

Select updating as merge strategy for rows where that are considered matches between source and destination.

Timestamp - Class in com.exasol.datatype.type

This class implements the SQl data type timestamp

Timestamp() - Constructor for class com.exasol.datatype.type.Timestamp

timestampColumn(String) - Method in class com.exasol.sql.ColumnsDefinition.Builder

Add timestamp column.

timestampColumn(String) - Method in class com.exasol.sql.ddl.create.CreateTable

Add timestamp column

TimestampWithLocalTimezone - Class in com.exasol.datatype.type

This class implements the Exasol-proprietary data type timestamp with local timezone data

TimestampWithLocalTimezone() - Constructor for class com.exasol.datatype.type.TimestampWithLocalTimezone

timestampWithLocalTimeZoneColumn(String) - Method in class com.exasol.sql.ColumnsDefinition.Builder

Add timestamp with local time zone column.

timestampWithLocalTimeZoneColumn(String) - Method in class com.exasol.sql.ddl.create.CreateTable

Add timestamp with local time zone column

toBoolean() - Method in class com.exasol.sql.expression.BooleanLiteral

Get boolean value this literal represents.

toBooleanExpressions(boolean[]) - Static method in class com.exasol.sql.expression.BooleanLiteral

Map an array of booleans to and array of BooleanExpressions

toMillis() - Method in class com.exasol.datatype.value.IntervalDayToSecond

Get the interval as the total number of milliseconds between two points in time.

toMonths() - Method in class com.exasol.datatype.value.IntervalYearToMonth

Get the interval as the total number of months between two points in time

toString() - Method in class com.exasol.datatype.value.IntervalDayToSecond

toString() - Method in class com.exasol.datatype.value.IntervalYearToMonth

toString() - Method in enum com.exasol.sql.dql.select.JoinType

toString() - Method in class com.exasol.sql.expression.BooleanLiteral

toString() - Method in class com.exasol.sql.expression.ColumnReference

toString() - Method in enum com.exasol.sql.expression.ComparisonOperator

Returns the operator symbol that represents the comparison.

toString() - Method in class com.exasol.sql.expression.DoubleLiteral

toString() - Method in class com.exasol.sql.expression.FloatLiteral

toString() - Method in class com.exasol.sql.expression.IntegerLiteral

toString() - Method in class com.exasol.sql.expression.LongLiteral

toString() - Method in class com.exasol.sql.expression.StringLiteral

toString() - Method in class com.exasol.sql.UnnamedPlaceholder

TreeNode - Interface in com.exasol.util

This class represents a node in a tree structure.

U

udf(String, ColumnsDefinition, ValueExpression...) - Method in class com.exasol.sql.dql.select.Select

Add a User Defined Function.

udf(String, ValueExpression...) - Method in class com.exasol.sql.dql.select.Select

Add a User Defined Function.

udf(String, ColumnsDefinition, ValueExpression...) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create a User Defined Function.

udf(String, ValueExpression...) - Static method in class com.exasol.sql.expression.ExpressionTerm

Create a User Defined Function.

UnnamedPlaceholder - Class in com.exasol.sql

This class implements a nameless placeholder ("?") in an SQL statement

UnnamedPlaceholder() - Constructor for class com.exasol.sql.UnnamedPlaceholder

useLowerCase() - Method in class com.exasol.sql.rendering.StringRendererConfig

Get whether the statements should be produced in lower case.

useQuotes() - Method in class com.exasol.sql.rendering.StringRendererConfig

Get whether identifiers should be enclosed in double quotation marks.

using(String) - Method in class com.exasol.sql.dml.merge.Merge

Define the data source.

using(String, String) - Method in class com.exasol.sql.dml.merge.Merge

Define the data source.

UsingClause - Class in com.exasol.sql.dml.merge

The USING clause of an SQL MERGE statement.

UsingClause(Fragment, String) - Constructor for class com.exasol.sql.dml.merge.UsingClause

Create a new instance of a UsingClause.

UsingClause(Fragment, String, String) - Constructor for class com.exasol.sql.dml.merge.UsingClause

Create a new instance of a UsingClause.

V

value - Variable in class com.exasol.datatype.value.AbstractInterval

ValueExpression - Interface in com.exasol.sql.expression

Common interface for all types of value expressions

ValueExpressionRenderer - Class in com.exasol.sql.expression.rendering

Renderer for common value expressions.

ValueExpressionRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.expression.rendering.ValueExpressionRenderer

valueExpressions - Variable in class com.exasol.sql.expression.function.AbstractFunction

ValueExpressionVisitor - Interface in com.exasol.sql.expression

Visitor interface for a BooleanTerm.

valueOf(String) - Static method in enum com.exasol.sql.dql.select.JoinType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.exasol.sql.expression.ComparisonOperator

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAggregateFunction

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAnalyticFunctions

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolScalarFunction

Returns the enum constant of this type with the specified name.

valuePlaceholder() - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable

Add an unnamed value placeholder to the value list (this is useful for prepared statements).

valuePlaceholders(int) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable

Add a given number unnamed value placeholder to the value list (this is useful for prepared statements).

values(String...) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable

Insert a list of string values.

values(int...) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable

Insert a list of integer values.

values(ValueExpression...) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable

Insert a list of value expressions.

values() - Static method in enum com.exasol.sql.dql.select.JoinType

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.exasol.sql.expression.ComparisonOperator

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAggregateFunction

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAnalyticFunctions

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum com.exasol.sql.expression.function.exasol.ExasolScalarFunction

Returns an array containing the constants of this enum type, in the order they are declared.

valueTable(ValueTable) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable

Insert a value table.

valueTable(ValueTable) - Method in class com.exasol.sql.dql.select.FromClause

Create a FromClause from a value table.

ValueTable - Class in com.exasol.sql

Value tables are pseudo-tables constructed from rows and columns of expressions (e.g.

ValueTable(Fragment) - Constructor for class com.exasol.sql.ValueTable

Create a new ValueTable.

ValueTableRow - Class in com.exasol.sql

This class represents a row in a ValueTable.

ValueTableRow(Fragment, ValueExpression...) - Constructor for class com.exasol.sql.ValueTableRow

Create a value table row from a list of expressions.

ValueTableRow(Fragment, String...) - Constructor for class com.exasol.sql.ValueTableRow

Create a value table row from a list of string literals.

ValueTableRow.Builder - Class in com.exasol.sql

Builder for ValueTableRows

ValueTableVisitor - Interface in com.exasol.sql

Varchar - Class in com.exasol.datatype.type

This class implements the Exasol-proprietary data type varchar

Varchar(int) - Constructor for class com.exasol.datatype.type.Varchar

Create a new instance of an Varchar data type

varcharColumn(String, int) - Method in class com.exasol.sql.ColumnsDefinition.Builder

Add varchar column.

varcharColumn(String, int) - Method in class com.exasol.sql.ddl.create.CreateTable

Add varchar column.

visit(ColumnsDefinition) - Method in interface com.exasol.sql.ColumnDefinitionVisitor

visit(Column) - Method in interface com.exasol.sql.ColumnDefinitionVisitor

visit(Char) - Method in interface com.exasol.sql.ColumnDefinitionVisitor

visit(Varchar) - Method in interface com.exasol.sql.ColumnDefinitionVisitor

visit(Boolean) - Method in interface com.exasol.sql.ColumnDefinitionVisitor

visit(Date) - Method in interface com.exasol.sql.ColumnDefinitionVisitor

visit(Decimal) - Method in interface com.exasol.sql.ColumnDefinitionVisitor

visit(DoublePrecision) - Method in interface com.exasol.sql.ColumnDefinitionVisitor

visit(Timestamp) - Method in interface com.exasol.sql.ColumnDefinitionVisitor

visit(TimestampWithLocalTimezone) - Method in interface com.exasol.sql.ColumnDefinitionVisitor

visit(IntervalDayToSecond) - Method in interface com.exasol.sql.ColumnDefinitionVisitor

visit(IntervalYearToMonth) - Method in interface com.exasol.sql.ColumnDefinitionVisitor

visit(CreateSchema) - Method in interface com.exasol.sql.ddl.create.CreateSchemaVisitor

visit(Schema) - Method in interface com.exasol.sql.ddl.create.CreateSchemaVisitor

visit(Table) - Method in interface com.exasol.sql.ddl.create.CreateTableVisitor

visit(CreateTable) - Method in interface com.exasol.sql.ddl.create.CreateTableVisitor

visit(CreateSchema) - Method in class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer

visit(Schema) - Method in class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer

visit(CreateTable) - Method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer

visit(Table) - Method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer

visit(DropSchema) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor

visit(Schema) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor

visit(Cascade) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor

visit(Restrict) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor

visit(Table) - Method in interface com.exasol.sql.ddl.drop.DropTableVisitor

visit(DropTable) - Method in interface com.exasol.sql.ddl.drop.DropTableVisitor

visit(CascadeConstraints) - Method in interface com.exasol.sql.ddl.drop.DropTableVisitor

visit(DropSchema) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer

visit(Schema) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer

visit(Cascade) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer

visit(Restrict) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer

visit(DropTable) - Method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer

visit(CascadeConstraints) - Method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer

visit(Table) - Method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer

visit(SqlStatement) - Method in interface com.exasol.sql.dml.insert.InsertVisitor

visit(Table) - Method in interface com.exasol.sql.dml.insert.InsertVisitor

visit(InsertFields) - Method in interface com.exasol.sql.dml.insert.InsertVisitor

visit(DerivedColumn) - Method in interface com.exasol.sql.dml.insert.InsertVisitor

visit(SqlStatement) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer

visit(Table) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer

visit(DerivedColumn) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer

visit(InsertFields) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer

visit(ValueTable) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer

visit(ValueTableRow) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer

visit(Merge) - Method in interface com.exasol.sql.dml.merge.MergeVisitor

Visit MERGE statements.

visit(Table) - Method in interface com.exasol.sql.dml.merge.MergeVisitor

Visit database tables.

visit(UsingClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor

Visit the source definition of a MERGE statement.

visit(OnClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor

Visit the merge condition definition.

visit(MatchedClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor

Visit the definition of the merge strategy in case of matching rows.

visit(MergeUpdateClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor

Visit the update definition.

visit(MergeColumnUpdate) - Method in interface com.exasol.sql.dml.merge.MergeVisitor

Visit the update of a single column inside a MERGE statement.

visit(MergeDeleteClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor

Visit the deletion definition.

visit(NotMatchedClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor

Visit the merge strategy in case of rows that have no match in the destination table.

visit(MergeInsertClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor

Visit the insert definition.

visit(InsertFields) - Method in interface com.exasol.sql.dml.merge.MergeVisitor

Visit the insert field list.

visit(DerivedColumn) - Method in interface com.exasol.sql.dml.merge.MergeVisitor

Visit a derived column reference.

visit(WhereClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor

Visit a WHERE clause.

visit(Merge) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

visit(Table) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

visit(UsingClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

visit(OnClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

visit(MatchedClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

visit(MergeUpdateClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

visit(MergeColumnUpdate) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

visit(MergeDeleteClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

visit(NotMatchedClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

visit(MergeInsertClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

visit(DerivedColumn) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

visit(InsertFields) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

visit(ValueTable) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

visit(ValueTableRow) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

visit(WhereClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer

visit(Select) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer

visit(DerivedColumn) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer

visit(FromClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer

visit(Table) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer

visit(Join) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer

visit(WhereClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer

visit(GroupByClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer

visit(OrderByClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer

visit(LimitClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer

visit(ValueTable) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer

visit(ValueTableRow) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer

visit(Select) - Method in interface com.exasol.sql.dql.select.SelectVisitor

visit(FromClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor

visit(Join) - Method in interface com.exasol.sql.dql.select.SelectVisitor

visit(LimitClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor

visit(WhereClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor

visit(GroupByClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor

visit(OrderByClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor

visit(DerivedColumn) - Method in interface com.exasol.sql.dql.select.SelectVisitor

visit(Table) - Method in interface com.exasol.sql.dql.select.SelectVisitor

visit(Not) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor

visit(BooleanLiteral) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor

visit(And) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor

visit(Or) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor

visit(Comparison) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor

visit(Not) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer

visit(And) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer

visit(Or) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer

visit(BooleanLiteral) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer

visit(Comparison) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer

visit(StringLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(IntegerLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(LongLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(DoubleLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(FloatLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(BooleanLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(ColumnReference) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(UnnamedPlaceholder) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(DefaultValue) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(ExasolFunction) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(ExasolUdf) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(BinaryArithmeticExpression) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(NullLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(BooleanExpression) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(UnnamedPlaceholder) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(StringLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(IntegerLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(LongLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(DoubleLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(FloatLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(BooleanLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(ColumnReference) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(DefaultValue) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(ExasolFunction) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(ExasolUdf) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(BinaryArithmeticExpression) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(NullLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(BooleanExpression) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(ColumnsDefinition) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer

visit(Column) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer

visit(Char) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer

visit(Varchar) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer

visit(Boolean) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer

visit(Date) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer

visit(Decimal) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer

visit(DoublePrecision) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer

visit(Timestamp) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer

visit(TimestampWithLocalTimezone) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer

visit(IntervalDayToSecond) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer

visit(IntervalYearToMonth) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer

visit(ValueTable) - Method in interface com.exasol.sql.ValueTableVisitor

visit(ValueTableRow) - Method in interface com.exasol.sql.ValueTableVisitor

W

whenMatched() - Method in class com.exasol.sql.dml.merge.Merge

Define the merge strategy if the match criteria is met.

whenNotMatched() - Method in class com.exasol.sql.dml.merge.Merge

Define the merge strategy if the match criteria is not met.

where - Variable in class com.exasol.sql.dml.merge.MergeInsertClause

where(BooleanExpression) - Method in class com.exasol.sql.dml.merge.MergeInsertClause

Add a WHERE clause insertion definition.

where - Variable in class com.exasol.sql.dml.merge.MergeMethodDefinition

where(BooleanExpression) - Method in class com.exasol.sql.dml.merge.MergeMethodDefinition

Add a WHERE clause MERGE definition.

where(BooleanExpression) - Method in class com.exasol.sql.dql.select.Select

Create a new WhereClause.

WhereClause - Class in com.exasol.sql.dql.select

This class represents the where clause of an SQL statement.

WhereClause(SqlStatement, BooleanExpression) - Constructor for class com.exasol.sql.dql.select.WhereClause

Create a new instance of a WhereClause

A B C D E F G H I J L M N O P Q R S T U V W