Index (Exasol SQL Statement Builder 4.5.3 API)

A B C D E F G H I J K L M N O P Q R S T U V W Y Z
All Classes All Packages

A

ABS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Absolute value of a number
AbstractBooleanExpression - Class in com.exasol.sql.expression: Abstract base class for all types of BooleanExpressions.
AbstractBooleanExpression() - Constructor for class com.exasol.sql.expression.AbstractBooleanExpression
AbstractComparison - Class in com.exasol.sql.expression.comparison: Abstract basis for comparisons.
AbstractComparison(ComparisonOperator, ValueExpression, ValueExpression) - Constructor for class com.exasol.sql.expression.comparison.AbstractComparison: Create a new instance of AbstractComparison.
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: Create a new instance of a 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: Abstract base class for interval types.
AbstractInterval(long) - Constructor for class com.exasol.datatype.value.AbstractInterval: Create an interval from a long integer value.
AbstractInterval(long, boolean) - Constructor for class com.exasol.datatype.value.AbstractInterval: Create an interval from an absolute value and a sign.
AbstractLiteral - Class in com.exasol.sql.expression.literal: Abstract basis for Literals.
AbstractLiteral() - Constructor for class com.exasol.sql.expression.literal.AbstractLiteral
AbstractPredicate - Class in com.exasol.sql.expression.predicate: An abstract basis for predicate classes.
AbstractPredicate(PredicateOperator) - Constructor for class com.exasol.sql.expression.predicate.AbstractPredicate: Creates a new instance of AbstractPredicate.
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: Create a new common base for a string type.
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 a ColumnDefinitionVisitor.
accept(ColumnDefinitionVisitor) - Method in class com.exasol.sql.ColumnsDefinition: Accept a ColumnDefinitionVisitor.
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(CreateSchemaVisitor) - Method in class com.exasol.sql.ddl.Schema: Accept a CreateSchemaVisitor.
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(CreateTableVisitor) - Method in class com.exasol.sql.Table: Accept a CreateTableVisitor.
accept(DropSchemaVisitor) - Method in class com.exasol.sql.ddl.drop.Cascade
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(DropSchemaVisitor) - Method in class com.exasol.sql.ddl.drop.Restrict
accept(DropSchemaVisitor) - Method in class com.exasol.sql.ddl.Schema: Accept a DropSchemaVisitor.
accept(DropTableVisitor) - Method in class com.exasol.sql.ddl.drop.CascadeConstraints
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(DropTableVisitor) - Method in class com.exasol.sql.Table: Accept a DropTableVisitor.
accept(InsertVisitor) - 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(InsertVisitor) - Method in interface com.exasol.sql.dml.insert.InsertFragment: Accept a visitor (e.g.
accept(InsertVisitor) - Method in class com.exasol.sql.Table: Accept an InsertVisitor.
accept(MergeVisitor) - Method in class com.exasol.sql.DerivedColumn
accept(MergeVisitor) - Method in class com.exasol.sql.dml.insert.InsertFields
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(MergeVisitor) - Method in class com.exasol.sql.dql.select.WhereClause: Accept a visitor for MERGE statements
accept(MergeVisitor) - Method in class com.exasol.sql.Table: Accept a MergeVisitor.
accept(SelectVisitor) - Method in class com.exasol.sql.DerivedColumn
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(SelectVisitor) - Method in class com.exasol.sql.Table: Accept a SelectVisitor.
accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.And
accept(BooleanExpressionVisitor) - Method in interface com.exasol.sql.expression.BooleanExpression: Accept a visitor
accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.comparison.AbstractComparison
accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.literal.BooleanLiteral
accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Not
accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Or
accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.predicate.AbstractPredicate
accept(ComparisonVisitor) - Method in interface com.exasol.sql.expression.comparison.Comparison: Accept ComparisonVisitor.
accept(ComparisonVisitor) - Method in class com.exasol.sql.expression.comparison.LikeComparison
accept(ComparisonVisitor) - Method in class com.exasol.sql.expression.comparison.SimpleComparison
accept(FunctionVisitor) - Method in class com.exasol.sql.expression.function.exasol.AnalyticFunction
accept(FunctionVisitor) - Method in class com.exasol.sql.expression.function.exasol.CastExasolFunction
accept(FunctionVisitor) - Method in class com.exasol.sql.expression.function.exasol.ExasolFunction
accept(FunctionVisitor) - Method in class com.exasol.sql.expression.function.exasol.ExasolUdf
accept(FunctionVisitor) - Method in interface com.exasol.sql.expression.function.Function: Accept FunctionVisitor.
accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.BigDecimalLiteral
accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.BooleanLiteral
accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.DoubleLiteral
accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.FloatLiteral
accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.IntegerLiteral
accept(LiteralVisitor) - Method in interface com.exasol.sql.expression.literal.Literal: Accept a LiteralVisitor.
accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.LongLiteral
accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.NullLiteral
accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.StringLiteral
accept(PredicateVisitor) - Method in class com.exasol.sql.expression.predicate.BetweenPredicate
accept(PredicateVisitor) - Method in class com.exasol.sql.expression.predicate.ExistsPredicate
accept(PredicateVisitor) - Method in class com.exasol.sql.expression.predicate.InPredicate
accept(PredicateVisitor) - Method in class com.exasol.sql.expression.predicate.IsNullPredicate
accept(PredicateVisitor) - Method in interface com.exasol.sql.expression.predicate.Predicate: Accepts PredicateVisitor.
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.AbstractBooleanExpression
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.BinaryArithmeticExpression
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.function.AbstractFunction
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.literal.AbstractLiteral
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.predicate.AbstractPredicate
accept(ValueExpressionVisitor) - Method in interface com.exasol.sql.expression.ValueExpression: Accept a visitor
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.
ACOS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Arccosine
add(boolean...) - Method in class com.exasol.sql.ValueTable: Add boolean values to the last row of the value table.
add(boolean...) - Method in class com.exasol.sql.ValueTableRow.Builder: Add one or more boolean literals to the row.
add(char...) - Method in class com.exasol.sql.ValueTable: Add character values to the last row of the value table.
add(char...) - Method in class com.exasol.sql.ValueTableRow.Builder: Add one or more char literals to the row.
add(double...) - Method in class com.exasol.sql.ValueTable: Add double values to the last row of the value table.
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.ValueTable: Add float values to the last row of the value table.
add(float...) - Method in class com.exasol.sql.ValueTableRow.Builder: Add one or more float literals to the row.
add(int...) - Method in class com.exasol.sql.ValueTable: Add integer values to the last row of the value table.
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.ValueTable: Add long values to the last row of the value table.
add(long...) - Method in class com.exasol.sql.ValueTableRow.Builder: Add one or more long literals to the row.
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.ValueTable: Add string values 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(String, DataType) - Method in class com.exasol.sql.ColumnsDefinition: Add a new column to the ColumnsDefinition
add(List<ValueExpression>) - Method in class com.exasol.sql.ValueTableRow.Builder: Add a list of expressions to the ValueTableRow.
ADD - com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator: Addition
ADD_DAYS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Add days
ADD_HOURS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Add hours
ADD_MINUTES - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Add minutes
ADD_MONTHS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Add months
ADD_SECONDS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Add seconds
ADD_WEEKS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Add weeks
ADD_YEARS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Add years
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.
alias(String, String...) - Method in class com.exasol.sql.ValueTable: Set alias for the value table.
all() - Method in class com.exasol.sql.dql.select.Select: Add a wildcard field for all involved fields.
ALL - com.exasol.sql.expression.function.exasol.AnalyticFunction.Keyword: Function over all values (including duplicates)
AnalyticFunction - Class in com.exasol.sql.expression.function.exasol: This class represents an analytic function in the Exasol database that supports keywords DISTINCT and ALL and the over clause.
AnalyticFunction.Keyword - Enum in com.exasol.sql.expression.function.exasol: Analytic function keywords
and(boolean...) - Static method in class com.exasol.sql.expression.BooleanTerm: Logical AND combination of boolean values.
and(boolean, BooleanExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: Logical AND combination of boolean value and expression.
and(BooleanExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm: Logical AND combination of boolean expressions.
and(BooleanExpression, boolean) - Static method in class com.exasol.sql.expression.BooleanTerm: Logical AND combination of boolean expression and value.
And - Class in com.exasol.sql.expression: This class represents a logical AND predicate.
And(boolean...) - Constructor for class com.exasol.sql.expression.And: Create a new And instance
And(BooleanExpression...) - Constructor for class com.exasol.sql.expression.And: Create a new And instance
ANY - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
ANY - com.exasol.sql.expression.function.exasol.ExasolAnalyticFunction: Deprecated.

Any expression true
append(int) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer: Append on integer number.
append(String) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer: Append a string.
append(String) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer: Append a string.
appendAutoQuoted(String) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer: Append a SQL identifier with the right form of quotes.
appendAutoQuoted(String) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer: Append an auto-quoted SQL identifier.
appendBooleanLiteral(BooleanLiteral) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer: Append a boolean literal (i.e.
appendCommaWhenNeeded(Fragment) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer: Append a comma where necessary.
appendKeyword(String) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer: Append a SQL keyword (like SELECT).
appendKeyWord(String) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer: Append an unquoted SQL keyword.
appendListOfValueExpressions(List<? extends ValueExpression>) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer: Append a list of value expressions.
appendRenderedValueExpression(ValueExpression) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer: Append a value expression that has already been rendered.
appendRow(ValueTableRow) - Method in class com.exasol.sql.ValueTable: Append a ValueTableRow to the ValueTable.
appendRow(String...) - Method in class com.exasol.sql.ValueTable: Append a value table row consisting of value literals to the value table.
appendSpace() - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer: Append a white space.
appendValueTableRow(ValueTableRow) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer: Append a row of a value table (SELECT ... FROM VALUES).
APPROXIMATE_COUNT_DISTINCT - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Faster, but only approximate count of distinct values
APPROXIMATE_COUNT_DISTINCT - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
arithmeticExpression(BinaryArithmeticExpression) - Method in class com.exasol.sql.dql.select.Select: Deprecated.
please use a Select.valueExpression(ValueExpression) valueExpression} method instead.
arithmeticExpression(BinaryArithmeticExpression, String) - Method in class com.exasol.sql.dql.select.Select: Deprecated.
please use a Select.valueExpression(ValueExpression, String) valueExpression} method instead.
asc() - Method in class com.exasol.sql.dql.select.OrderByClause: Add ASC option to the OrderByClause
ASCII - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: ASCII code of character
ASIN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Arcsine
ATAN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Arctangens
ATAN2 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Arctanges of two numbers (instead of fration)
AVG - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Average
AVG - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.

B

between(ValueExpression, ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: Check if value is between two other values.
BETWEEN - com.exasol.sql.expression.predicate.BetweenPredicate.BetweenPredicateOperator: Between boundaries
BetweenPredicate - Class in com.exasol.sql.expression.predicate: A class that represents a [NOT] BETWEEN predicate.
BetweenPredicate.BetweenPredicateOperator - Enum in com.exasol.sql.expression.predicate: A class that represents BetweenPredicate operator.
BetweenPredicate.Builder - Class in com.exasol.sql.expression.predicate: A builder for BetweenPredicate.
BigDecimalLiteral - Class in com.exasol.sql.expression.literal: This class represents BigDecimal literals.
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.
BIT_AND - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Bitwise and
BIT_CHECK - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Check bit set
BIT_LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: String size in bits
BIT_LROTATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Rotate left
BIT_LSHIFT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Shift left
BIT_NOT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Bitwise not
BIT_OR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Bitwise or
BIT_RROTATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Rotate right
BIT_RSHIFT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Shift right
BIT_SET - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Set bit
BIT_TO_NUM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Bitmask to number
BIT_XOR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Bitwise exclusive or
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
BooleanExpressionVisitor - Interface in com.exasol.sql.expression: Visitor interface for a BooleanTerm
booleanLiteral(boolean) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create a boolean literal.
BooleanLiteral - Class in com.exasol.sql.expression.literal: This class represents boolean literals (read "true" and "false")
BooleanTerm - Class in com.exasol.sql.expression: This class represents boolean terms like AND or NOT.
build() - Method in class com.exasol.sql.ColumnsDefinition.Builder: Build a new ColumnsDefinition.
build() - Method in class com.exasol.sql.expression.comparison.LikeComparison.Builder: Create a new instance of LikeComparison.
build() - Method in class com.exasol.sql.expression.predicate.BetweenPredicate.Builder: Creates a new instance of [NOT] BETWEEN predicate class.
build() - Method in class com.exasol.sql.expression.predicate.InPredicate.Builder: Creates a new instance of [NOT] IN predicate class.
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 - Variable in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer: Builder that holds the fragments of the rendered string
builder() - Static method in class com.exasol.sql.ColumnsDefinition: Create a new builder for ColumnsDefinition.
builder() - Static method in class com.exasol.sql.expression.comparison.LikeComparison: Create a new builder for LikeComparison.
builder() - Static method in class com.exasol.sql.expression.predicate.BetweenPredicate: Creates a new builder for BetweenPredicate.
builder() - Static method in class com.exasol.sql.expression.predicate.InPredicate: Creates a new builder for InPredicate.
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() - Constructor for class com.exasol.sql.ColumnsDefinition.Builder
Builder() - Constructor for class com.exasol.sql.expression.comparison.LikeComparison.Builder
Builder(Fragment) - Constructor for class com.exasol.sql.ValueTableRow.Builder: Create a new builder for a value table row.

C

cascade() - Method in class com.exasol.sql.ddl.drop.DropSchema: Add CASCADE clause to a DROP SCHEMA statement.
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
cascadeConstraints() - Method in class com.exasol.sql.ddl.drop.DropTable: Add CASCADE CONSTRAINTS clause into a DROP TABLE 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
CastExasolFunction - Class in com.exasol.sql.expression.function.exasol: This class represents the Exasol CAST function.
CEIL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Ceiling
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
CHAR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Character for number
CHARACTER_LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: String size in characters
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.
COALESCE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: First non-null value
COLOGNE_PHONETIC - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Phonetic representation of a string
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.ColumnReference: Create a new ColumnReference from a column name and a table name.
column(String, String) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create a reference to a column in a specific table.
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
ColumnDefinitionVisitor - Interface in com.exasol.sql: Visit the definition of a column.
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.comparison - package com.exasol.sql.expression.comparison
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.literal - package com.exasol.sql.expression.literal
com.exasol.sql.expression.predicate - package com.exasol.sql.expression.predicate
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, SimpleComparisonOperator, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: General comparison with operator enum.
compare(ValueExpression, String, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: General comparison with operator as string.
Comparison - Interface in com.exasol.sql.expression.comparison: Interface for classes that implement comparisons between two columns.
ComparisonOperator - Interface in com.exasol.sql.expression.comparison: Interface for comparison operators.
ComparisonVisitor - Interface in com.exasol.sql.expression.comparison: Visitor for Comparison.
CONCAT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: String concatenation
config - Variable in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer: Configuration that controls string rendering options
config - Variable in class com.exasol.sql.rendering.AbstractFragmentRenderer: Configuration that controls string rendering options.
CONVERT_TZ - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Convert timezone
CORR - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Correlation coefficient
CORR - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
COS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Cosine
COSH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Hyperbolic cosine
COT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Cotangens
COUNT - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Precise count
COUNT - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
COVAR_POP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Population covariance
COVAR_POP - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
COVAR_SAMP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Sample covariance
COVAR_SAMP - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
create() - Static method in class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer: Create an CreateSchemaRenderer using the default renderer configuration
create() - Static method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer: Create an CreateTableRenderer using the default renderer configuration
create() - Static method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer: Create an DropSchemaRenderer using the default renderer configuration
create() - Static method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer: Create an DropTableRenderer using the default renderer configuration
create() - Static method in class com.exasol.sql.dml.insert.rendering.InsertRenderer: Create an InsertRenderer using the default renderer configuration
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.ddl.create.rendering.CreateSchemaRenderer: Create an CreateSchemaRenderer
create(StringRendererConfig) - Static method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer: Create an CreateTableRenderer
create(StringRendererConfig) - Static method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer: Create an DropSchemaRenderer
create(StringRendererConfig) - Static method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer: Create an DropTableRenderer
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(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: Prepare the value table.
createSchema(String) - Method in class com.exasol.sql.StatementFactory: Create a CreateSchema statement.
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.
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: Visitor for CREATE SCHEMA statements.
createTable(String) - Method in class com.exasol.sql.StatementFactory: Create a CreateTable statement.
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
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: Visitor for CREATE TABLE statements.
CUME_DIST - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
CURRENT_DATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Current date
CURRENT_ROW - com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType: Current row
CURRENT_ROW - com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameExclusionType: Current row
CURRENT_SCHEMA - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Current database schema
CURRENT_SESSION - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Current session
CURRENT_STATEMENT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Current statement
CURRENT_TIMESTAMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Current timestamp
CURRENT_USER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Current user

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
DAY - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Day part of date
DAYS_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Days between two dates
DBTIMEZONE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Database-wide Timezone
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.
DECODE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: String-based case selection
DEFAULT - com.exasol.sql.dql.select.JoinType: Default join
defaultValue() - Static method in class com.exasol.sql.expression.DefaultValue: Create a default value expression.
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
DEGREES - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Radians to degrees
DENSE_RANK - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
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
DISTINCT - com.exasol.sql.expression.function.exasol.AnalyticFunction.Keyword: Function over distinct values
DIV - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Integer division
divide(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create a binary arithmetic expression with DIVIDE operator.
DIVIDE - com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator: Division
doubleLiteral(double) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create a double literal.
DoubleLiteral - Class in com.exasol.sql.expression.literal: This class represents double literals.
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(String) - Method in class com.exasol.sql.StatementFactory: Create a DropSchema statement.
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.
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: Visitor for DROP SCHEMA statements.
dropTable(String) - Method in class com.exasol.sql.StatementFactory: Create a DropTable statement.
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.
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: Visitor for DROP TABLE statements.
DUMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: String dump in various notations

E

EDIT_DISTANCE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Edit distance of two strings
end(ValueExpression) - Method in class com.exasol.sql.expression.predicate.BetweenPredicate.Builder: Adds the end expression of predicate.
endParenthesis() - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer: End a parenthesis.
endParenthesis() - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer: End a parenthesis.
eq(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: Equality comparison.
EQUAL - com.exasol.sql.expression.comparison.SimpleComparisonOperator: Equals comparator
escape(char) - Method in class com.exasol.sql.expression.comparison.LikeComparison.Builder: Add an escape character.
EVERY - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
EVERY - com.exasol.sql.expression.function.exasol.ExasolAnalyticFunction: Deprecated.

Every expression true
ExasolAggregateFunction - Enum in com.exasol.sql.expression.function.exasol: Deprecated, for removal: This API element is subject to removal in a future version.
Use enum ExasolAnalyticAggregateFunctions.
ExasolAnalyticAggregateFunctions - Enum in com.exasol.sql.expression.function.exasol: This enum is a list of Analytic and Aggregate Functions that the Exasol database supports.
ExasolAnalyticFunction - Enum in com.exasol.sql.expression.function.exasol: Deprecated, for removal: This API element is subject to removal in a future version.
Use enum ExasolAnalyticAggregateFunctions.
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.
exclude(WindowFrameClause.WindowFrameExclusionType) - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause: Set the exclusion type of this WindowFrameClause.
exists(Select) - Static method in class com.exasol.sql.expression.BooleanTerm: Check if the sub-select has any result.
EXISTS - com.exasol.sql.expression.predicate.ExistsPredicate.ExistsPredicateOperator: Exists operator
ExistsPredicate - Class in com.exasol.sql.expression.predicate: A class that represents a EXISTS predicate.
ExistsPredicate(Select) - Constructor for class com.exasol.sql.expression.predicate.ExistsPredicate: Creates a new instance of ExistsPredicate.
ExistsPredicate.ExistsPredicateOperator - Enum in com.exasol.sql.expression.predicate: An operator for ExistsPredicate class.
EXP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Exponent
expression(ValueExpression) - Method in class com.exasol.sql.expression.predicate.BetweenPredicate.Builder: Adds the left expression of predicate.
expression(ValueExpression) - Method in class com.exasol.sql.expression.predicate.InPredicate.Builder: Adds the predicate expression.
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.
FIRST_VALUE - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

First value in set
FIRST_VALUE - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
floatLiteral(float) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create a float literal.
FloatLiteral - Class in com.exasol.sql.expression.literal: This class represents float literals.
FLOOR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Floor
FOLLOWING - com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType: Following
Fragment - Interface in com.exasol.sql: This is the common interface for all fragments of SQL statements.
FragmentRenderer - Interface in com.exasol.sql.rendering: Common interface for SQL statement fragment renderers.
from() - Method in class com.exasol.sql.dql.select.Select: Get the FromClause of this select statement.
FROM_POSIX_TIME - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Posix time to timestamp
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.
FULL - com.exasol.sql.dql.select.JoinType: Full join (x(x)x)
FULL_OUTER - com.exasol.sql.dql.select.JoinType: Full outer jon (x( )x)
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(Function) - 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...) - Method in class com.exasol.sql.dql.select.Select: Add a function.
function(FunctionName, ValueExpression...) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create an Exasol function.
function(FunctionName, String, ValueExpression...) - Method in class com.exasol.sql.dql.select.Select: Add a function.
function(Function, String) - Method in class com.exasol.sql.dql.select.Select: Add a 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: Name of the function
FunctionName - Interface in com.exasol.sql.expression.function: Interface for function names.
FunctionVisitor - Interface in com.exasol.sql.expression.function: Visitor interface for Function.

G

ge(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: Greater-than-or-equal comparison.
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: Get the CASCADE CONSTRAINTS option.
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.
getColumnNameAliases() - Method in class com.exasol.sql.ValueTable: Get column name aliases.
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.
getEndExpression() - Method in class com.exasol.sql.expression.predicate.BetweenPredicate: Returns the end expression in the [NOT] BETWEEN predicate.
getEscape() - Method in class com.exasol.sql.expression.comparison.LikeComparison: Get an escape character.
getExclusion() - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause: Get the exclusion type.
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
getExpression() - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameUnitClause: Get the expression.
getExpression() - Method in class com.exasol.sql.expression.predicate.BetweenPredicate: Returns the left expression in the [NOT] BETWEEN predicate.
getExpression() - Method in class com.exasol.sql.expression.predicate.InPredicate: Returns the left expression in the [NOT] IN predicate.
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 "having" 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.
getKeyword() - Method in class com.exasol.sql.expression.function.exasol.AnalyticFunction: Get the keyword for the function call, may be null.
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.AbstractComparison: Get the left-hand side operator of the comparison
getLeftOperand() - Method in interface com.exasol.sql.expression.comparison.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.
getOperand() - Method in class com.exasol.sql.expression.Not: Get the boolean expression literal to be negated.
getOperand() - Method in class com.exasol.sql.expression.predicate.IsNullPredicate: Returns the value expression to be checked for null.
getOperands() - Method in class com.exasol.sql.expression.And: Get the operands of this AND.
getOperands() - Method in class com.exasol.sql.expression.Or: Get the operands of this OR.
getOperands() - Method in class com.exasol.sql.expression.predicate.InPredicate: Returns the value expressions in the [NOT] IN predicate.
getOperator() - Method in class com.exasol.sql.expression.comparison.AbstractComparison: Get the comparison operator
getOperator() - Method in interface com.exasol.sql.expression.comparison.Comparison: Get the comparison operator
getOperator() - Method in class com.exasol.sql.expression.predicate.AbstractPredicate
getOperator() - Method in interface com.exasol.sql.expression.predicate.Predicate: Returns the predicate operator.
getOrderByClause() - Method in class com.exasol.sql.expression.function.exasol.OverClause: Get the order by clause of this OverClause.
getOverClause() - Method in class com.exasol.sql.expression.function.exasol.AnalyticFunction: Get the "over clause" appended to the function call, may be null.
getParameters() - Method in class com.exasol.sql.expression.function.AbstractFunction: Get the value expressions (parameters of the function)
getPartitionByColumns() - Method in class com.exasol.sql.expression.function.exasol.OverClause: Get the columns of the partition by clause of this OverClause.
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.AbstractComparison: Get the right-hand side operator of the comparison
getRightOperand() - Method in interface com.exasol.sql.expression.comparison.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.
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.
getSelectQuery() - Method in class com.exasol.sql.expression.predicate.ExistsPredicate: Returns the sub select query in the EXISTS predicate.
getSelectQuery() - Method in class com.exasol.sql.expression.predicate.InPredicate: Returns the sub select query in the [NOT] IN predicate.
getSign() - Method in class com.exasol.datatype.value.AbstractInterval: Produce the sign of the interval.
getSignedValue() - Method in class com.exasol.datatype.value.AbstractInterval: Get the signed long integer value.
getSpecification() - Method in class com.exasol.sql.dql.select.Join: Get the join specification
getSqlKeyword() - Method in enum com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType: Get the keyword for rendering to SQL.
getSqlKeyword() - Method in enum com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameExclusionType: Get the keyword for rendering to SQL.
getStartExpression() - Method in class com.exasol.sql.expression.predicate.BetweenPredicate: Returns the start expression in the [NOT] BETWEEN predicate.
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: Get the table name.
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.
getTableNameAlias() - Method in class com.exasol.sql.ValueTable: Get a table name alias.
getType() - Method in class com.exasol.sql.dql.select.Join: Get the type of the join
getType() - Method in class com.exasol.sql.expression.function.exasol.CastExasolFunction: Get the type to cast the value to.
getType() - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause: Get the window frame type.
getType() - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameUnitClause: Get the type.
getUnit1() - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause: Get the BETWEEN unit.
getUnit2() - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause: Get the AND unit.
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.function.exasol.CastExasolFunction: Get the value to cast.
getValue() - Method in class com.exasol.sql.expression.literal.BigDecimalLiteral: Get the value of the BigDecimalLiteral.
getValue() - Method in class com.exasol.sql.expression.literal.DoubleLiteral: Get the value of the DoubleLiteral
getValue() - Method in class com.exasol.sql.expression.literal.FloatLiteral: Get the value of the FloatLiteral
getValue() - Method in class com.exasol.sql.expression.literal.IntegerLiteral: Get the value of the IntegerLiteral.
getValue() - Method in class com.exasol.sql.expression.literal.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.
getWindowFrameClause() - Method in class com.exasol.sql.expression.function.exasol.OverClause: Get the window frame clause of this OverClause.
getWindowName() - Method in class com.exasol.sql.expression.function.exasol.OverClause: Get the window name of this OverClause.
getYearPrecision() - Method in class com.exasol.datatype.type.IntervalDayToSecond
getYearPrecision() - Method in class com.exasol.datatype.type.IntervalYearToMonth
GREATER_THAN - com.exasol.sql.expression.comparison.SimpleComparisonOperator: Greater-than comparator
GREATER_THAN_OR_EQUAL - com.exasol.sql.expression.comparison.SimpleComparisonOperator: Greater-than-or-equal comparator
GREATEST - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Greatest value
GROUP - com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameExclusionType: Group
GROUP_CONCAT - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Group concatenation
GROUP_CONCAT - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
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.
GROUPING - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
GROUPING_ID - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
GROUPS - com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameType: Groups frame
gt(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: Greater-than comparison.

H

hasAlias() - Method in class com.exasol.sql.Table: Check if a correlation name (i.a.
hasAlias() - Method in class com.exasol.sql.ValueTable: CHeck if the value table has an alias.
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.
hasEscape() - Method in class com.exasol.sql.expression.comparison.LikeComparison: Check if LIKE predicate has ESCAPE.
hasFields() - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable: Check if a insert fields are defined.
HASH_MD5 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: MD5 hash
HASH_SHA - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: SHA1 hash
HASH_SHA256 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: SHA256 hash
HASH_SHA512 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: SHA512 hash
HASH_TIGER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Tiger hash
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.
hasNot() - Method in class com.exasol.sql.expression.comparison.LikeComparison: Check if LIKE predicate has NOT.
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.AnalyticFunction
hasParenthesis() - Method in class com.exasol.sql.expression.function.exasol.CastExasolFunction
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.
hasSelectQuery() - Method in class com.exasol.sql.expression.predicate.InPredicate: Checks if InPredicate has a sub query.
hasSubSelect() - Method in class com.exasol.sql.dql.select.FromClause: Check if the FromClause contains a sub-select statement.
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.
HOUR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Hour part of a date / time
HOURS_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Hours between

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.
in(ValueExpression, Select) - Static method in class com.exasol.sql.expression.BooleanTerm: Check for value sub-select.
in(ValueExpression, ValueExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm: Check for value in list.
IN - com.exasol.sql.expression.predicate.InPredicate.InPredicateOperator: In-list operator
INITCAP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Capitalize first letter of each word
INNER - com.exasol.sql.dql.select.JoinType: Inner join ( (x) )
innerJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause: Create a new inner Join that belongs to a FROM clause.
InPredicate - Class in com.exasol.sql.expression.predicate: A class that represents a [NOT] IN predicate.
InPredicate.Builder - Class in com.exasol.sql.expression.predicate: A builder for InPredicate.
InPredicate.InPredicateOperator - Enum in com.exasol.sql.expression.predicate: A class that represents InPredicate operator.
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
INSERT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Insert string into other string
insertFields - Variable in class com.exasol.sql.dml.insert.AbstractInsertValueTable: Fields to insert
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: Table with values used in the INSERT statement
InsertVisitor - Interface in com.exasol.sql.dml.insert: Visitor for INSERT statements.
INSTR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Find occurrence in string
integerLiteral(int) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create an integer literal.
IntegerLiteral - Class in com.exasol.sql.expression.literal: 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 - Class in com.exasol.datatype.value: This class implements the Exasol-proprietary data type value INTERVAL DAY(x) TO SECONDS(y).
IntervalDayToSecond(int, int) - Constructor for class com.exasol.datatype.type.IntervalDayToSecond: Create a new instance of an IntervalDayToSecond data type
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 - Class in com.exasol.datatype.value: This class implements the Exasol-proprietary data type value INTERVAL YEAR(x) TO MONTH(y).
IntervalYearToMonth(int) - Constructor for class com.exasol.datatype.type.IntervalYearToMonth: Create a new instance of an IntervalYearToMonth data type
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.
IPROC - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Data node number
IS_BOOLEAN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Is a boolean
IS_DATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Is a date
IS_DSINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Is an interval with second precision
IS_NOT_NULL - com.exasol.sql.expression.predicate.IsNullPredicate.IsNullPredicateOperator: Is-not-null operator
IS_NULL - com.exasol.sql.expression.predicate.IsNullPredicate.IsNullPredicateOperator: Is-null operator
IS_NUMBER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Is a number
IS_TIMESTAMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Is a timestamp
IS_YMINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Is an interval with month precision
isEmpty() - Method in class com.exasol.sql.ValueTable: Check if the value table is empty.
isNotNull(ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: Check for not null.
isNull(ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: Check for null.
IsNullPredicate - Class in com.exasol.sql.expression.predicate: A class that represents a IS [NOT] NULL predicate.
IsNullPredicate(IsNullPredicate.IsNullPredicateOperator, ValueExpression) - Constructor for class com.exasol.sql.expression.predicate.IsNullPredicate: Creates a new instance of IsNullPredicate for IS [NOT] NULL predicate.
IsNullPredicate(ValueExpression) - Constructor for class com.exasol.sql.expression.predicate.IsNullPredicate: Creates a new instance of IsNullPredicate for IS NULL predicate.
IsNullPredicate.IsNullPredicateOperator - Enum in com.exasol.sql.expression.predicate: An operator for IsNullPredicate class.

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.

K

keywordAll() - Method in class com.exasol.sql.expression.function.exasol.AnalyticFunction: Add keyword ALL to the function call
keywordDistinct() - Method in class com.exasol.sql.expression.function.exasol.AnalyticFunction: Add keyword DISTINCT to the function call

L

LAG - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
LAST_VALUE - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Last value in set
LAST_VALUE - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
LCASE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Lower case
le(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: Less-than-or-equal comparison.
LEAD - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
LEAST - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Least value
leave(CreateTable) - Method in interface com.exasol.sql.ddl.create.CreateTableVisitor: Leave a CREATE TABLE statement.
leave(CreateTable) - Method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer
leave(InsertFields) - Method in interface com.exasol.sql.dml.insert.InsertVisitor: Leave the list of fields to insert into.
leave(InsertFields) - 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(FromClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
leave(FromClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor: Leave the FROM clause.
leave(ValueTable) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
leave(ValueTable) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
leave(ValueTable) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
leave(ValueTable) - Method in interface com.exasol.sql.ValueTableVisitor: Leave a value table.
leave(ValueTableRow) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
leave(ValueTableRow) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
leave(ValueTableRow) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
leave(ValueTableRow) - Method in interface com.exasol.sql.ValueTableVisitor: Leave a row in a value table.
left(ValueExpression) - Method in class com.exasol.sql.expression.comparison.LikeComparison.Builder: Add the left operand.
LEFT - com.exasol.sql.dql.select.JoinType: Left join (x(x) )
LEFT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Left part of string
LEFT_OUTER - com.exasol.sql.dql.select.JoinType: Left outer join (x( ) )
leftJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause: Create a new left Join that belongs to a FROM clause.
leftOperand - Variable in class com.exasol.sql.expression.comparison.AbstractComparison: left part of the comparison
leftOuterJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause: Create a new left outer Join that belongs to a FROM clause.
LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: String length in characters (differs from bytes for UTF)
LESS_THAN - com.exasol.sql.expression.comparison.SimpleComparisonOperator: Less-than comparator
LESS_THAN_OR_EQUAL - com.exasol.sql.expression.comparison.SimpleComparisonOperator: Less-than-or-equal comparator
like(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: Comparison with LIKE operator.
like(ValueExpression, ValueExpression, char) - Static method in class com.exasol.sql.expression.BooleanTerm: Comparison with LIKE operator.
LIKE - com.exasol.sql.expression.comparison.LikeComparison.LikeComparisonOperator: LIKE comparator
LikeComparison - Class in com.exasol.sql.expression.comparison: This class represents a LIKE comparison.
LikeComparison.Builder - Class in com.exasol.sql.expression.comparison: A builder for LikeComparison.
LikeComparison.LikeComparisonOperator - Enum in com.exasol.sql.expression.comparison: Fuzzy string comparators.
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
LISTAGG - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
LISTAGG - com.exasol.sql.expression.function.exasol.ExasolAnalyticFunction: Deprecated.

Concatenated string of values of expression from all rows in the window or group
Literal - Interface in com.exasol.sql.expression.literal: Interface for classes that represent literal values.
LiteralVisitor - Interface in com.exasol.sql.expression.literal: Visitor for Literal.
LN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Logarithm to base e
LOCALTIMESTAMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Timestamp in local time
LOCATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Find position in string
LOG - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Logarithm with user-defined base
LOG10 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Logarithm to base 10
LOG2 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Logrithm to base 2
longLiteral(long) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create an long literal.
LongLiteral - Class in com.exasol.sql.expression.literal: This class represents long literals.
LOWER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Lower case
lowerCase(boolean) - Method in class com.exasol.sql.rendering.StringRendererConfig.Builder: Define whether the statement should be produced in lower case
LPAD - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Pad left
lt(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: Less-than comparison.
LTRIM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Trim left

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.
MAX - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Maximum value
MAX - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
MEDIAN - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Median
MEDIAN - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
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.
MID - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Take a part from the mid of the string
MIN - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Minimum Value
MIN - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
minus(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create a binary arithmetic expression with SUBTRACT operator.
MINUTE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Minute part of a date / time
MINUTES_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Minutes between
MOD - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Modulo
MONTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Month part of a date
MONTHS_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Months between two dates
MUL - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
multiply(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create a binary arithmetic expression with DIVIDE operator.
MULTIPLY - com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator: Multiplication

N

name() - Method in interface com.exasol.sql.expression.function.FunctionName: Function name.
ne(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: Not-equal comparison.
NO_OTHERS - com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameExclusionType: No others
not() - Method in class com.exasol.sql.expression.comparison.LikeComparison.Builder: Set for NOT LIKE expression.
not() - Method in class com.exasol.sql.expression.predicate.BetweenPredicate.Builder: Sets NOT BETWEEN predicate.
not() - Method in class com.exasol.sql.expression.predicate.InPredicate.Builder: Sets NOT IN predicate.
not(boolean) - Static method in class com.exasol.sql.expression.BooleanTerm: Unary NOT of boolean value.
not(BooleanExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: Unary NOT of boolean expression.
Not - Class in com.exasol.sql.expression: This class implements the logical unary NOT predicate.
Not(boolean) - Constructor for class com.exasol.sql.expression.Not: Create a new instance of a unary Not from a boolean literal
Not(BooleanExpression) - Constructor for class com.exasol.sql.expression.Not: Create a new instance of a unary Not from a boolean expression
Not(String) - Constructor for class com.exasol.sql.expression.Not: Create a new instance of a unary Not from a string literal
NOT_BETWEEN - com.exasol.sql.expression.predicate.BetweenPredicate.BetweenPredicateOperator: Outside boundaries
NOT_EQUAL - com.exasol.sql.expression.comparison.SimpleComparisonOperator: Not equals comparator
NOT_IN - com.exasol.sql.expression.predicate.InPredicate.InPredicateOperator: Not-in-list operator
NOT_LIKE - com.exasol.sql.expression.comparison.LikeComparison.LikeComparisonOperator: NOT_LIKE comparator
notBetween(ValueExpression, ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: Check if value is not between two other values.
notIn(ValueExpression, Select) - Static method in class com.exasol.sql.expression.BooleanTerm: Check if value not in sub-select.
notIn(ValueExpression, ValueExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm: Check if value not in list.
notLike(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: Comparison with inverted LIKE operator.
notLike(ValueExpression, ValueExpression, char) - Static method in class com.exasol.sql.expression.BooleanTerm: Comparison with inverted LIKE operator.
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.
NOW - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Current timestamp
NPROC - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Number of cluster nodes
NTH_VALUE - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
NTILE - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
NULLIF - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Null if
NULLIFZERO - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Null if zero
nullLiteral() - Static method in class com.exasol.sql.expression.ExpressionTerm: Create a NULL literal.
nullLiteral() - Static method in class com.exasol.sql.expression.literal.NullLiteral: Create a NULL literal.
NullLiteral - Class in com.exasol.sql.expression.literal: This class represents a null literal.
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
NUMTODSINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Number to days-to-second interval
NUMTOYMINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Number to years-to-month interval
NVL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Replace null with expression
NVL2 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Replace null with expression.

O

OCTET_LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: String length in bytes
of(boolean) - Static method in class com.exasol.sql.expression.literal.BooleanLiteral: Create a boolean literal from a boolean value
of(char) - Static method in class com.exasol.sql.expression.literal.StringLiteral: Create a new StringLiteral from a character.
of(double) - Static method in class com.exasol.sql.expression.literal.DoubleLiteral: Create a new DoubleLiteral from a double.
of(float) - Static method in class com.exasol.sql.expression.literal.FloatLiteral: Create a new FloatLiteral from a float.
of(int) - Static method in class com.exasol.sql.expression.literal.IntegerLiteral: Create a new IntegerLiteral from an integer.
of(long) - Static method in class com.exasol.sql.expression.literal.LongLiteral: Create a new LongLiteral from a long.
of(BinaryArithmeticExpression.BinaryArithmeticOperator, ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BinaryArithmeticExpression: Create a new BinaryArithmeticExpression instance.
of(ExasolAnalyticAggregateFunctions, ValueExpression...) - Static method in class com.exasol.sql.expression.function.exasol.AnalyticFunction: Create a new AnalyticFunction instance.
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(ValueExpression, DataType) - Static method in class com.exasol.sql.expression.function.exasol.CastExasolFunction: Create a new CastExasolFunction instance.
of(String) - Static method in class com.exasol.sql.expression.ColumnReference: Create a new ColumnReference from a column name.
of(String) - Static method in class com.exasol.sql.expression.function.exasol.OverClause: Create a new OverClause with the given window name.
of(String) - Static method in class com.exasol.sql.expression.literal.BooleanLiteral: Create a new BooleanLiteral instance from a String.
of(String) - Static method in class com.exasol.sql.expression.literal.StringLiteral: Create a new StringLiteral from a string.
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(BigDecimal) - Static method in class com.exasol.sql.expression.literal.BigDecimalLiteral: Create a new BigDecimalLiteral from a BigDecimal.
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.comparison.SimpleComparisonOperator: Get the SimpleComparisonOperator 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.
operands(ValueExpression...) - Method in class com.exasol.sql.expression.predicate.InPredicate.Builder: Adds the operands.
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
operator - Variable in class com.exasol.sql.expression.comparison.AbstractComparison: comparison operator
or(boolean...) - Static method in class com.exasol.sql.expression.BooleanTerm: Logical OR combination of boolean values.
or(boolean, BooleanExpression) - Static method in class com.exasol.sql.expression.BooleanTerm: Logical OR combination of boolean value and expression.
or(BooleanExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm: Logical OR combination of boolean expressions.
or(BooleanExpression, boolean) - Static method in class com.exasol.sql.expression.BooleanTerm: Logical OR combination of boolean expression and value.
Or - Class in com.exasol.sql.expression: This class represents a logical OR predicate.
Or(boolean...) - Constructor for class com.exasol.sql.expression.Or: Create a new Or instance
Or(BooleanExpression...) - Constructor for class com.exasol.sql.expression.Or: Create a new Or instance
orderBy(OrderByClause) - Method in class com.exasol.sql.expression.function.exasol.OverClause: Set the OrderByClause for this OverClause.
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.
over(OverClause) - Method in class com.exasol.sql.expression.function.exasol.AnalyticFunction: Add the given over clause to the function call.
over(UnaryOperator<OverClause>) - Method in class com.exasol.sql.expression.function.exasol.AnalyticFunction: Add an OVER clause to the function call.
OverClause - Class in com.exasol.sql.expression.function.exasol: This represents an OVER clause of an analytic function in Exasol.
OverClause() - Constructor for class com.exasol.sql.expression.function.exasol.OverClause

P

parameters - Variable in class com.exasol.sql.expression.function.AbstractFunction: Function parameters
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: Parse a group that came out of a string match to an interval.
partitionBy(ValueExpression...) - Method in class com.exasol.sql.expression.function.exasol.OverClause: Set the columns for the PARTITION BY clause of this OverClause.
PERCENT_RANK - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
PERCENTILE_CONT - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
PERCENTILE_DISC - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
PI - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Pi
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: Cache that remembers if the interval is positive
POSIX_TIME - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Seconds since Epoch
POWER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Power
PRECEDING - com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType: Preceding
Predicate - Interface in com.exasol.sql.expression.predicate: Interface for classes that implement predicate expressions.
PredicateOperator - Interface in com.exasol.sql.expression.predicate: An interface for the predicate operators.
PredicateVisitor - Interface in com.exasol.sql.expression.predicate: An interface for Predicate visitor.

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

RADIANS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Degrees to radians
RANDOM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Random number
RANGE - com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameType: Range frame
RANK - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
RATIO_TO_REPORT - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
REGEXP_INSTR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Find occurrence of regular expression in string
REGEXP_REPLACE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Replace occurrence of regular expression in string
REGEXP_SUBSTR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Return substring that matches regular expression
REGR_AVGX - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Average of the independent values (x values)
REGR_AVGX - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
REGR_AVGY - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Average of the independent values (y values)
REGR_AVGY - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
REGR_COUNT - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Number of non-null number pairs
REGR_COUNT - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
REGR_INTERCEPT - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

y-Intercept of the regression line
REGR_INTERCEPT - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
REGR_R2 - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Coefficient of determination (goodness of fit)
REGR_R2 - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
REGR_SLOPE - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Slope of the regression line
REGR_SLOPE - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
REGR_SXX - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Auxiliary function SXX
REGR_SXX - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
REGR_SXY - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Auxiliary function SXY
REGR_SXY - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
REGR_SYY - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Auxiliary function SYY
REGR_SYY - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
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.
REPEAT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Repeat string sequence
REPLACE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Replace substring
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
REVERSE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Reverse string
right(ValueExpression) - Method in class com.exasol.sql.expression.comparison.LikeComparison.Builder: Add the right operand.
RIGHT - com.exasol.sql.dql.select.JoinType: Right join ( (x)x)
RIGHT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Right part of a string
RIGHT_OUTER - com.exasol.sql.dql.select.JoinType: Right outer join ( ( )x)
rightJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause: Create a new right Join that belongs to a FROM clause.
rightOperand - Variable in class com.exasol.sql.expression.comparison.AbstractComparison: right part of the comparison
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: Root fragment of the statement fragment tree.
ROUND - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Round
ROW_NUMBER - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
ROWID - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Row ID
ROWNUM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Row counter
ROWS - com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameType: Rows frame
RPAD - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Pad right
RTRIM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Trim right

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
SCOPE_USER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Scope user
SECOND - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Second part of a date / time
SECONDS_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Seconds between two dates / times
select() - Method in class com.exasol.sql.StatementFactory: Create a Select statement.
select(Select) - Method in class com.exasol.sql.dql.select.FromClause: Add a select to the FromClause.
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.
SelectFragment - Interface in com.exasol.sql.dql.select: This is the common interface for all fragments of a SELECT statement.
selectQuery(Select) - Method in class com.exasol.sql.expression.predicate.InPredicate.Builder: Adds the sub select query.
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: Visitor for SELECT SQL statements.
self() - Method in class com.exasol.datatype.type.AbstractStringDataType: Get the generic self pointer.
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: Generic self pointer.
self() - Method in class com.exasol.sql.dml.insert.Insert
self() - Method in class com.exasol.sql.dml.merge.MergeInsertClause
SESSIONTIMEZONE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Session timezone
set(String, boolean) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause: Update a column with a boolean value.
set(String, char) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause: Update a column with a char 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, 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, 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.
setLastVisited(Fragment) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer: Set the last statement fragment that was visited.
setToDefault(String) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause: Update a column with the default value defined for that column.
SIGN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Sign
SimpleComparison - Class in com.exasol.sql.expression.comparison: This class implements all simple comparison operators.
SimpleComparison(SimpleComparisonOperator, ValueExpression, ValueExpression) - Constructor for class com.exasol.sql.expression.comparison.SimpleComparison: Create a new instance of SimpleComparison.
SimpleComparisonOperator - Enum in com.exasol.sql.expression.comparison: This enum represents the different types of SimpleComparisons that can be used in Expressions.
SIN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Sine
SINH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Hyperbolic sine
SOME - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: This is an alias for ExasolAnalyticAggregateFunctions.ANY.
SOUNDEX - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Sounds like
SqlStatement - Interface in com.exasol.sql: This interface represents an SQL statement.
SQRT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Square root
ST_AREA - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Area of (multi-)polygon
ST_BOUNDARY - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Geometric boundary
ST_BUFFER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Points of maximal distance
ST_CENTROID - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Center of mass
ST_CONTAINS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Object fully contains another object
ST_CONVEXHULL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Convex hull
ST_CROSSES - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Object crosses another object
ST_DIFFERENCE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Difference
ST_DIMENSION - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Dimmension of object: Points / Lines / Poligons
ST_DISJOINT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Object disjoint of another object
ST_DISTANCE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Minimal distance between two objects
ST_ENDPOINT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Endpoint of line
ST_ENVELOPE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Smallest rectangle containing object
ST_EQUALS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Objects equal
ST_EXTERIORRING - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Outer ring of object
ST_FORCE2D - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Turn to 2D object
ST_GEOMETRYN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: The n-th object of a GeometryCollection
ST_GEOMETRYTYPE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Type as string
ST_INTERIORRINGN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Inner ring
ST_INTERSECTION - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Intersection of two objects
ST_INTERSECTS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Objects intersect
ST_ISCLOSED - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Object is closed
ST_ISEMPTY - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Empty set
ST_ISRING - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Start point = end point
ST_ISSIMPLE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Simple object
ST_LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Length
ST_NUMGEOMETRIES - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Number of objects in collection of geometry objects
ST_NUMINTERIORRINGS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Number of holes within a Polygon
ST_NUMPOINTS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Points in line string
ST_OVERLAPS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Objects overlap
ST_POINTN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: n-th point
ST_SETSRID - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Set SRID
ST_STARTPOINT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Start point
ST_SYMDIFFERENCE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Symmetric difference
ST_TOUCHES - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Object touches another object
ST_TRANSFORM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Coordinate transformation
ST_UNION - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Union of two objects
ST_WITHIN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Object fully contained in another object
ST_X - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: X coordinate of point
ST_Y - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Y coordinate of point
start(ValueExpression) - Method in class com.exasol.sql.expression.predicate.BetweenPredicate.Builder: Adds the start expression of predicate.
startParenthesis() - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer: Start a parenthesis.
startParenthesis() - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer: Start a parenthesis.
StatementFactory - Class in com.exasol.sql: The StatementFactory implements an factory for SQL statements.
STDDEV - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Standard deviation
STDDEV - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
STDDEV_POP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Standard deviation of expr within a window or group of rows
STDDEV_POP - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
STDDEV_SAMP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Standard deviation of expr within a window or group of rows
STDDEV_SAMP - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
stringLiteral(char) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create a string literal from a character.
stringLiteral(String) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create a string literal.
StringLiteral - Class in com.exasol.sql.expression.literal: 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
SUBSTR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Substring
SUBTRACT - com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator: Subtraction
SUM - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Sum
SUM - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
SYS_GUID - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Unique system wide ID
SYSDATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Current date
SYSTIMESTAMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Current timestamp

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 alias to the FromClause.
TAN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Tangens
TANH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Hyperbolic tangens
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.
TIES - com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameExclusionType: Ties
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
TO_CHAR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Convert to character string
TO_DATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Convert to date
TO_DSINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Convert to interval with second precision
TO_NUMBER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Convert to number
TO_YMINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Convert to timestamp +/ TO_TIMESTAMP, /** Convert to interval with month precision
toBoolean() - Method in class com.exasol.sql.expression.literal.BooleanLiteral: Get boolean value this literal represents.
toBooleanExpressions(boolean[]) - Static method in class com.exasol.sql.expression.literal.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.ColumnReference
toString() - Method in interface com.exasol.sql.expression.comparison.ComparisonOperator: Returns the operator symbol that represents the comparison.
toString() - Method in enum com.exasol.sql.expression.comparison.LikeComparison.LikeComparisonOperator
toString() - Method in enum com.exasol.sql.expression.comparison.SimpleComparisonOperator
toString() - Method in class com.exasol.sql.expression.literal.BigDecimalLiteral
toString() - Method in class com.exasol.sql.expression.literal.BooleanLiteral
toString() - Method in class com.exasol.sql.expression.literal.DoubleLiteral
toString() - Method in class com.exasol.sql.expression.literal.FloatLiteral
toString() - Method in class com.exasol.sql.expression.literal.IntegerLiteral
toString() - Method in class com.exasol.sql.expression.literal.LongLiteral
toString() - Method in class com.exasol.sql.expression.literal.StringLiteral
toString() - Method in enum com.exasol.sql.expression.predicate.BetweenPredicate.BetweenPredicateOperator
toString() - Method in enum com.exasol.sql.expression.predicate.ExistsPredicate.ExistsPredicateOperator
toString() - Method in enum com.exasol.sql.expression.predicate.InPredicate.InPredicateOperator
toString() - Method in enum com.exasol.sql.expression.predicate.IsNullPredicate.IsNullPredicateOperator
toString() - Method in interface com.exasol.sql.expression.predicate.PredicateOperator: Returns the predicate operator symbol.
toString() - Method in class com.exasol.sql.UnnamedPlaceholder
TRANSLATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Replace characters in string
TRIM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Remove surrounding white spaces
TRUNC - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Trim decimal places
type(WindowFrameClause.WindowFrameType) - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause: Set the type of this WindowFrameClause.

U

UCASE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Upper case
udf(String, ColumnsDefinition, 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...) - Method in class com.exasol.sql.dql.select.Select: Add a User Defined Function.
udf(String, ValueExpression...) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create a User Defined Function.
UNBOUNDED_FOLLOWING - com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType: Unbounded following
UNBOUNDED_PRECEDING - com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType: Unbounded preceding
UNICODE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Numeric unicode representation of character
UNICODECHR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Character for numeric unicode
unit(WindowFrameClause.UnitType) - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause: Set the unit type of this WindowFrameClause.
unit(ValueExpression, WindowFrameClause.UnitType) - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause: Set the unit type of this WindowFrameClause.
unitBetween(WindowFrameClause.UnitType, WindowFrameClause.UnitType) - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause: Set the unit type of this WindowFrameClause to BETWEEN ... AND ....
unitBetween(ValueExpression, WindowFrameClause.UnitType, ValueExpression, WindowFrameClause.UnitType) - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause: Set the unit type of this WindowFrameClause to BETWEEN ... AND ....
UnnamedPlaceholder - Class in com.exasol.sql: This class implements a nameless placeholder ("?") in an SQL statement
UnnamedPlaceholder() - Constructor for class com.exasol.sql.UnnamedPlaceholder
UPPER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Upper case
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.
USER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Current user
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: Interval value
VALUE2PROC - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Number of the node a value is on
valueExpression(ValueExpression) - Method in class com.exasol.sql.dql.select.Select: Add a value expression.
valueExpression(ValueExpression, String) - Method in class com.exasol.sql.dql.select.Select: Add a value expression expression.
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: Create a new instance of ValueExpressionRenderer.
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.comparison.LikeComparison.LikeComparisonOperator: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.comparison.SimpleComparisonOperator: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.AnalyticFunction.Keyword: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAnalyticFunction: Deprecated.

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.
valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameExclusionType: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameType: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.predicate.BetweenPredicate.BetweenPredicateOperator: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.predicate.ExistsPredicate.ExistsPredicateOperator: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.predicate.InPredicate.InPredicateOperator: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.predicate.IsNullPredicate.IsNullPredicateOperator: 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() - 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.comparison.LikeComparison.LikeComparisonOperator: 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.comparison.SimpleComparisonOperator: 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.AnalyticFunction.Keyword: 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: Deprecated.

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.ExasolAnalyticAggregateFunctions: 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.ExasolAnalyticFunction: Deprecated.

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.
values() - Static method in enum com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType: 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.WindowFrameClause.WindowFrameExclusionType: 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.WindowFrameClause.WindowFrameType: 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.predicate.BetweenPredicate.BetweenPredicateOperator: 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.predicate.ExistsPredicate.ExistsPredicateOperator: 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.predicate.InPredicate.InPredicateOperator: 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.predicate.IsNullPredicate.IsNullPredicateOperator: Returns an array containing the constants of this enum type, in the order they are declared.
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(String...) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable: Insert a list of string values.
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.
valueTableAs(ValueTable, String, String...) - Method in class com.exasol.sql.dql.select.FromClause: Create a FromClause from a value table and an alias.
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: Visitor for ValueTable.
VAR_POP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Variance of expr within a window or group of rows
VAR_POP - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
VAR_SAMP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Variance of expr within a window or group of rows
VAR_SAMP - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
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.
VARIANCE - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Deprecated.

Variance
VARIANCE - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions: See documentation.
visit(Boolean) - Method in interface com.exasol.sql.ColumnDefinitionVisitor: Visit a boolean column.
visit(Boolean) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(Char) - Method in interface com.exasol.sql.ColumnDefinitionVisitor: Visit a character column.
visit(Char) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(Date) - Method in interface com.exasol.sql.ColumnDefinitionVisitor: Visit a date column.
visit(Date) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(Decimal) - Method in interface com.exasol.sql.ColumnDefinitionVisitor: Visit a decimal column.
visit(Decimal) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(DoublePrecision) - Method in interface com.exasol.sql.ColumnDefinitionVisitor: Visit a double-precision floating point column.
visit(DoublePrecision) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(IntervalDayToSecond) - Method in interface com.exasol.sql.ColumnDefinitionVisitor: Visit an interval column with second precision.
visit(IntervalDayToSecond) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(IntervalYearToMonth) - Method in interface com.exasol.sql.ColumnDefinitionVisitor: Visit an interval column with month precision.
visit(IntervalYearToMonth) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(Timestamp) - Method in interface com.exasol.sql.ColumnDefinitionVisitor: Visit a timestamp column.
visit(Timestamp) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(TimestampWithLocalTimezone) - Method in interface com.exasol.sql.ColumnDefinitionVisitor: Visit a timestamp-with-local-timezone column.
visit(TimestampWithLocalTimezone) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(Varchar) - Method in interface com.exasol.sql.ColumnDefinitionVisitor: Visit a variable-length character column.
visit(Varchar) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(Column) - Method in interface com.exasol.sql.ColumnDefinitionVisitor: Visit a single column.
visit(Column) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(ColumnsDefinition) - Method in interface com.exasol.sql.ColumnDefinitionVisitor: Visit a set of column definitions.
visit(ColumnsDefinition) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(CreateSchema) - Method in interface com.exasol.sql.ddl.create.CreateSchemaVisitor: Visit a CREATE SCHEMA statement.
visit(CreateSchema) - Method in class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer
visit(CreateTable) - Method in interface com.exasol.sql.ddl.create.CreateTableVisitor: Visit a CREATE TABLE statement.
visit(CreateTable) - Method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer
visit(Cascade) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor: Visit the CASCADE option.
visit(Cascade) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
visit(CascadeConstraints) - Method in interface com.exasol.sql.ddl.drop.DropTableVisitor: Visit the CASCADE CONSTRAINTS option.
visit(CascadeConstraints) - Method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer
visit(DropSchema) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor: Visit a DROP SCHEMA statement.
visit(DropSchema) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
visit(DropTable) - Method in interface com.exasol.sql.ddl.drop.DropTableVisitor: Visit a DROP TABLE statement.
visit(DropTable) - Method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer
visit(Restrict) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor: Visit the RESTRICT option.
visit(Restrict) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
visit(Schema) - Method in interface com.exasol.sql.ddl.create.CreateSchemaVisitor: Visit the schema to be created.
visit(Schema) - Method in class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer
visit(Schema) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor: Visit the name of the schema to drop.
visit(Schema) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
visit(DerivedColumn) - Method in interface com.exasol.sql.dml.insert.InsertVisitor: Visit a derived column.
visit(DerivedColumn) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
visit(DerivedColumn) - Method in interface com.exasol.sql.dml.merge.MergeVisitor: Visit a derived column reference.
visit(DerivedColumn) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
visit(DerivedColumn) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(DerivedColumn) - Method in interface com.exasol.sql.dql.select.SelectVisitor: Visit a derived column.
visit(InsertFields) - Method in interface com.exasol.sql.dml.insert.InsertVisitor: Visit the list of fields to insert into.
visit(InsertFields) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
visit(InsertFields) - Method in interface com.exasol.sql.dml.merge.MergeVisitor: Visit the insert field list.
visit(InsertFields) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
visit(MatchedClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor: Visit the definition of the merge strategy in case of matching rows.
visit(MatchedClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
visit(Merge) - Method in interface com.exasol.sql.dml.merge.MergeVisitor: Visit MERGE statements.
visit(Merge) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
visit(MergeColumnUpdate) - Method in interface com.exasol.sql.dml.merge.MergeVisitor: Visit the update of a single column inside a MERGE statement.
visit(MergeColumnUpdate) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
visit(MergeDeleteClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor: Visit the deletion definition.
visit(MergeDeleteClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
visit(MergeInsertClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor: Visit the insert definition.
visit(MergeInsertClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
visit(MergeUpdateClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor: Visit the update definition.
visit(MergeUpdateClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
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(NotMatchedClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
visit(OnClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor: Visit the merge condition definition.
visit(OnClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
visit(UsingClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor: Visit the source definition of a MERGE statement.
visit(UsingClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
visit(FromClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(FromClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor: Visit the FROM clause.
visit(GroupByClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(GroupByClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor: Visit the GROUP BY clause.
visit(Join) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(Join) - Method in interface com.exasol.sql.dql.select.SelectVisitor: Visit the JOIN clause.
visit(LimitClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(LimitClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor: Visit the LIMIT clause.
visit(OrderByClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(OrderByClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor: Visit the ORDER BY clause.
visit(Select) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(Select) - Method in interface com.exasol.sql.dql.select.SelectVisitor: Visit the SELECT part of the statement.
visit(WhereClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor: Visit a WHERE clause.
visit(WhereClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
visit(WhereClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(WhereClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor: Visit the WHERE clause.
visit(And) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor: Visit a logical AND expression.
visit(And) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(BinaryArithmeticExpression) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(BinaryArithmeticExpression) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor: Visit a binary arithmetic expression.
visit(BooleanExpression) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(BooleanExpression) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor: Visit a boolean expression.
visit(ColumnReference) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(ColumnReference) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor: Visit a column reference.
visit(Comparison) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor: Visit a comparison.
visit(Comparison) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(LikeComparison) - Method in interface com.exasol.sql.expression.comparison.ComparisonVisitor: Visit a LIKE comparison.
visit(LikeComparison) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(SimpleComparison) - Method in interface com.exasol.sql.expression.comparison.ComparisonVisitor: Visit a simple comparison (e.g.
visit(SimpleComparison) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(DefaultValue) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(DefaultValue) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor: Visit a default value.
visit(AnalyticFunction) - Method in interface com.exasol.sql.expression.function.FunctionVisitor: Visit an analytic function.
visit(AnalyticFunction) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(CastExasolFunction) - Method in interface com.exasol.sql.expression.function.FunctionVisitor: Visit an explicit cast.
visit(CastExasolFunction) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(ExasolFunction) - Method in interface com.exasol.sql.expression.function.FunctionVisitor: Visit a built-in Exasol function.
visit(ExasolFunction) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer: Function visitor
visit(ExasolUdf) - Method in interface com.exasol.sql.expression.function.FunctionVisitor: Visit an Exasol user-defined function (UDF).
visit(ExasolUdf) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(Function) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(Function) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor: Visit a function.
visit(BigDecimalLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor: Visit a big decimal literal.
visit(BigDecimalLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(BooleanLiteral) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor: Visit a boolean literal.
visit(BooleanLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor: Visit a boolean literal.
visit(BooleanLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(DoubleLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor: Visit a double-precision floating point literal.
visit(DoubleLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(FloatLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor: Visit a single-precision floating point literal.
visit(FloatLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(IntegerLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor: Visit an integer literal.
visit(IntegerLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(Literal) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(Literal) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor: Visit a literal.
visit(LongLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor: Visit a long integer literal.
visit(LongLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(NullLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor: Visit a literal null.
visit(NullLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(StringLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor: Visit a string literal.
visit(StringLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer: Literal visitor
visit(Not) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor: Visit a unary NOT expression.
visit(Not) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(Or) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor: Visit a logical OR expression.
visit(Or) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(BetweenPredicate) - Method in interface com.exasol.sql.expression.predicate.PredicateVisitor: Visit a value-between predicate.
visit(BetweenPredicate) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(ExistsPredicate) - Method in interface com.exasol.sql.expression.predicate.PredicateVisitor: Visit a value-exists predicate.
visit(ExistsPredicate) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(InPredicate) - Method in interface com.exasol.sql.expression.predicate.PredicateVisitor: Visit a value-in-constant-list predicate.
visit(InPredicate) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(IsNullPredicate) - Method in interface com.exasol.sql.expression.predicate.PredicateVisitor: Visit an is-null predicate.
visit(IsNullPredicate) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(Predicate) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor: Visit a predicate.
visit(Predicate) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(ValueExpression...) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer: Visit a value expression.
visit(SqlStatement) - Method in interface com.exasol.sql.dml.insert.InsertVisitor: Visit an INSERT statement.
visit(SqlStatement) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
visit(Table) - Method in interface com.exasol.sql.ddl.create.CreateTableVisitor: Visit the table to be created.
visit(Table) - Method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer
visit(Table) - Method in interface com.exasol.sql.ddl.drop.DropTableVisitor: Visit the TABLE to be dropped.
visit(Table) - Method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer
visit(Table) - Method in interface com.exasol.sql.dml.insert.InsertVisitor: Visit the table to insert into.
visit(Table) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
visit(Table) - Method in interface com.exasol.sql.dml.merge.MergeVisitor: Visit database tables.
visit(Table) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
visit(Table) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(Table) - Method in interface com.exasol.sql.dql.select.SelectVisitor: Visit a table.
visit(UnnamedPlaceholder) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(UnnamedPlaceholder) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor: Visit an unnamed placeholder.
visit(ValueTable) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
visit(ValueTable) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
visit(ValueTable) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(ValueTable) - Method in interface com.exasol.sql.ValueTableVisitor: Visit a value table.
visit(ValueTableRow) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
visit(ValueTableRow) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
visit(ValueTableRow) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(ValueTableRow) - Method in interface com.exasol.sql.ValueTableVisitor: Visit a row in a value table.
visit(List<ValueExpression>) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer: Visit expressions.

W

WEEK - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Week part of a date
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 clause
where - Variable in class com.exasol.sql.dml.merge.MergeMethodDefinition: WHERE clause
where(BooleanExpression) - Method in class com.exasol.sql.dml.merge.MergeInsertClause: Add a WHERE clause insertion definition.
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
windowFrame(UnaryOperator<WindowFrameClause>) - Method in class com.exasol.sql.expression.function.exasol.OverClause: Set and configure the WindowFrameClause for this OverClause.
WindowFrameClause - Class in com.exasol.sql.expression.function.exasol: This represents a window frame clause of an analytic function in Exasol.
WindowFrameClause.UnitType - Enum in com.exasol.sql.expression.function.exasol: Represents a unit type.
WindowFrameClause.WindowFrameExclusionType - Enum in com.exasol.sql.expression.function.exasol: Represents the type of a window frame exclusion.
WindowFrameClause.WindowFrameType - Enum in com.exasol.sql.expression.function.exasol: Window frame clause
WindowFrameClause.WindowFrameUnitClause - Class in com.exasol.sql.expression.function.exasol: Represents a window frame unit.
windowName(String) - Method in class com.exasol.sql.expression.function.exasol.OverClause: Set the window name for this OverClause.

Y

YEAR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Year part of a date
YEARS_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Years between two dates

Z

ZEROIFNULL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Zero if null

A B C D E F G H I J K L M N O P Q R S T U V W Y Z
All Classes All Packages