Index (Exasol SQL Statement Builder 4.2.0 API)

A B C D E F G H I J 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
AbstractBooleanExpression - Class in com.exasol.sql.expression: Abstract base class for all types of BooleanExpressions.
AbstractBooleanExpression() - Constructor for class com.exasol.sql.expression.AbstractBooleanExpression
AbstractBooleanExpression(BooleanExpression) - Constructor for class com.exasol.sql.expression.AbstractBooleanExpression
AbstractBooleanExpression(BooleanExpression...) - Constructor for class com.exasol.sql.expression.AbstractBooleanExpression
AbstractBottomUpTreeNode - Class in com.exasol.util: This is an abstract base class for nodes in a tree structure.
AbstractBottomUpTreeNode(TreeNode...) - Constructor for class com.exasol.util.AbstractBottomUpTreeNode: Create a new instance of a AbstractBottomUpTreeNode.
AbstractBottomUpTreeNode(List<TreeNode>) - Constructor for class com.exasol.util.AbstractBottomUpTreeNode: Create a new instance of a AbstractBottomUpTreeNode.
AbstractExpressionRenderer - Class in com.exasol.sql.expression.rendering: Common base class for expression renderers.
AbstractExpressionRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
AbstractFragment - Class in com.exasol.sql: Common base class for SQL statement fragments
AbstractFragment(Fragment) - Constructor for class com.exasol.sql.AbstractFragment: Create an instance of an SQL fragment
AbstractFragmentRenderer - Class in com.exasol.sql.rendering: Abstract base class for SQL fragment renderers.
AbstractFragmentRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.rendering.AbstractFragmentRenderer: Create a new instance of an AbstractFragmentRenderer-based class.
AbstractFunction - Class in com.exasol.sql.expression.function: This is a base class for functions.
AbstractFunction(String, List<ValueExpression>) - Constructor for class com.exasol.sql.expression.function.AbstractFunction: Create a new instance using AbstractFunction.
AbstractInsertValueTable<T extends AbstractInsertValueTable<T>> - Class in com.exasol.sql.dml.insert: Abstract base class for SQL fragments that contain a insert value table (for example INSERT, MERGE).
AbstractInsertValueTable(Fragment) - Constructor for class com.exasol.sql.dml.insert.AbstractInsertValueTable: Create the abstract base for a fragment containing a value table.
AbstractInterval - Class in com.exasol.datatype.value
AbstractInterval(long) - Constructor for class com.exasol.datatype.value.AbstractInterval
AbstractInterval(long, boolean) - Constructor for class com.exasol.datatype.value.AbstractInterval
AbstractStringDataType<T extends AbstractStringDataType<T>> - Class in com.exasol.datatype.type: Implements common logic for String data types
AbstractStringDataType(int, int, String) - Constructor for class com.exasol.datatype.type.AbstractStringDataType
AbstractTree - Class in com.exasol.util: An abstract base for TreeNode implementations.
AbstractTree() - Constructor for class com.exasol.util.AbstractTree
AbstractTreeNode - Class in com.exasol.util: This is an abstract base class for nodes in a tree structure.
AbstractTreeNode() - Constructor for class com.exasol.util.AbstractTreeNode: Create a new instance of a AbstractTreeNode that serves as root for a tree.
AbstractValueExpression - Class in com.exasol.sql.expression: Abstract base class for all types of value expressions
AbstractValueExpression() - Constructor for class com.exasol.sql.expression.AbstractValueExpression: Create a new instance of a AbstractValueExpression
accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Boolean
accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Char
accept(ColumnDefinitionVisitor) - Method in interface com.exasol.datatype.type.DataType
accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Date
accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Decimal
accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.DoublePrecision
accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.IntervalDayToSecond
accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.IntervalYearToMonth
accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Timestamp
accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.TimestampWithLocalTimezone
accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Varchar
accept(ColumnDefinitionVisitor) - Method in class com.exasol.sql.Column
accept(ColumnDefinitionVisitor) - Method in class com.exasol.sql.ColumnsDefinition
accept(CreateSchemaVisitor) - Method in class com.exasol.sql.ddl.create.CreateSchema
accept(CreateSchemaVisitor) - Method in interface com.exasol.sql.ddl.create.CreateSchemaFragment: Accept a visitor (e.g.
accept(CreateSchemaVisitor) - Method in class com.exasol.sql.ddl.Schema
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(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(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(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(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(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(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.AbstractBooleanExpression
accept(BooleanExpressionVisitor) - Method in interface com.exasol.sql.expression.BooleanExpression: Accept a visitor
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.AbstractBooleanExpression
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.BigDecimalLiteral
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.BinaryArithmeticExpression
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.BooleanLiteral
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.ColumnReference
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.DefaultValue
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.DoubleLiteral
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.FloatLiteral
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.function.exasol.ExasolFunction
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.function.exasol.ExasolUdf
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.IntegerLiteral
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.LongLiteral
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.NullLiteral
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.StringLiteral
accept(ValueExpressionVisitor) - Method in interface com.exasol.sql.expression.ValueExpression: Accept a visitor
accept(ValueExpressionVisitor) - Method in class com.exasol.sql.UnnamedPlaceholder
accept(ValueTableVisitor) - Method in class com.exasol.sql.ValueTable: Accept a visitor.
accept(ValueTableVisitor) - Method in class com.exasol.sql.ValueTableRow: Accept a visitor.
acceptConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.AbstractBooleanExpression: Sub-classes must override this method so that the visitor knows the type of the visited class at compile time.
acceptConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.And
acceptConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.BooleanLiteral
acceptConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Comparison
acceptConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Like
acceptConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Not
acceptConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Or
ACOS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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
ADD_DAYS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ADD_HOURS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ADD_MINUTES - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ADD_MONTHS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ADD_SECONDS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ADD_WEEKS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ADD_YEARS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
addChild(TreeNode) - Method in class com.exasol.util.AbstractBottomUpTreeNode
addChild(TreeNode) - Method in class com.exasol.util.AbstractTreeNode
addChild(TreeNode) - Method in interface com.exasol.util.TreeNode: Add a child node below this node.
addPlaceholder() - Method in class com.exasol.sql.ValueTable: Add an unnamed placeholder to the value table.
addPlaceholder() - Method in class com.exasol.sql.ValueTableRow.Builder: Add an UnnamedPlaceholder to the row.
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.
and(boolean...) - Static method in class com.exasol.sql.expression.BooleanTerm
and(boolean, BooleanExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
and(BooleanExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm
and(BooleanExpression, boolean) - Static method in class com.exasol.sql.expression.BooleanTerm
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.ExasolAnalyticFunctions
append(int) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
append(String) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
append(String) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
appendAutoQuoted(String) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
appendAutoQuoted(String) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
appendBooleanLiteral(BooleanLiteral) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
appendCommaWhenNeeded(ValueExpression) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
appendCommaWhenNeeded(Fragment) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
appendKeyword(String) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
appendKeyWord(String) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
appendListOfValueExpressions(List<? extends ValueExpression>) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
appendOperand(ValueExpression) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer
appendOperand(ValueExpression) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
appendRenderedBooleanExpression(BooleanExpression) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
appendRenderedValueExpression(ValueExpression) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
appendRow(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
appendValueTableRow(ValueTableRow) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
APPROXIMATE_COUNT_DISTINCT - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
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
ASIN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ATAN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ATAN2 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
AVG - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction

B

BigDecimalLiteral - Class in com.exasol.sql.expression: 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
BIT_CHECK - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
BIT_LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
BIT_LROTATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
BIT_LSHIFT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
BIT_NOT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
BIT_OR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
BIT_RROTATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
BIT_RSHIFT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
BIT_SET - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
BIT_TO_NUM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
BIT_XOR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
Boolean - Class in com.exasol.datatype.type: This class implements the SQL data type boolean
Boolean() - Constructor for class com.exasol.datatype.type.Boolean
booleanColumn(String) - Method in class com.exasol.sql.ColumnsDefinition.Builder: Add boolean column
booleanColumn(String) - Method in class com.exasol.sql.ddl.create.CreateTable: Add boolean column
BooleanExpression - Interface in com.exasol.sql.expression: Common interface for all types of boolean expressions
BooleanExpressionRenderer - Class in com.exasol.sql.expression.rendering
BooleanExpressionRenderer() - Constructor for class com.exasol.sql.expression.rendering.BooleanExpressionRenderer
BooleanExpressionRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.expression.rendering.BooleanExpressionRenderer
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: This class represents boolean literals (read "true" and "false")
BooleanTerm - Class in com.exasol.sql.expression
build() - Method in class com.exasol.sql.ColumnsDefinition.Builder: Build a new ColumnsDefinition.
build() - Method in class com.exasol.sql.expression.Like.Builder: Create a new instance of Like.
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() - Static method in class com.exasol.sql.ColumnsDefinition: Create a new builder for ColumnsDefinition.
builder() - Static method in class com.exasol.sql.expression.Like: Create a new builder for Like.
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.Like.Builder
Builder(Fragment) - Constructor for class com.exasol.sql.ValueTableRow.Builder

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
CEIL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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_LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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.
children - Variable in class com.exasol.util.AbstractTree
COALESCE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
COLOGNE_PHONETIC - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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
ColumnReference - Class in com.exasol.sql.expression: This class represents column reference.
ColumnsDefinition - Class in com.exasol.sql: This class represents a list of column definitions in an SQL statement.
ColumnsDefinition(SqlStatement) - Constructor for class com.exasol.sql.ColumnsDefinition: Create an new instance of ColumnsDefinition.
ColumnsDefinition(List<Column>) - Constructor for class com.exasol.sql.ColumnsDefinition: Create an new instance of ColumnsDefinition.
ColumnsDefinition.Builder - Class in com.exasol.sql: A builder for ColumnsDefinition.
ColumnsDefinitionRenderer - Class in com.exasol.sql.rendering: Renderer for columns definition.
ColumnsDefinitionRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.rendering.ColumnsDefinitionRenderer: Create a new instance of an AbstractFragmentRenderer-based class.
com.exasol.datatype.type - package com.exasol.datatype.type
com.exasol.datatype.value - package com.exasol.datatype.value
com.exasol.sql - package com.exasol.sql
com.exasol.sql.ddl - package com.exasol.sql.ddl
com.exasol.sql.ddl.create - package com.exasol.sql.ddl.create
com.exasol.sql.ddl.create.rendering - package com.exasol.sql.ddl.create.rendering
com.exasol.sql.ddl.drop - package com.exasol.sql.ddl.drop
com.exasol.sql.ddl.drop.rendering - package com.exasol.sql.ddl.drop.rendering
com.exasol.sql.dml.insert - package com.exasol.sql.dml.insert
com.exasol.sql.dml.insert.rendering - package com.exasol.sql.dml.insert.rendering
com.exasol.sql.dml.merge - package com.exasol.sql.dml.merge
com.exasol.sql.dml.merge.rendering - package com.exasol.sql.dml.merge.rendering
com.exasol.sql.dql.select - package com.exasol.sql.dql.select
com.exasol.sql.dql.select.rendering - package com.exasol.sql.dql.select.rendering
com.exasol.sql.expression - package com.exasol.sql.expression
com.exasol.sql.expression.function - package com.exasol.sql.expression.function
com.exasol.sql.expression.function.exasol - package com.exasol.sql.expression.function.exasol
com.exasol.sql.expression.rendering - package com.exasol.sql.expression.rendering
com.exasol.sql.rendering - package com.exasol.sql.rendering
com.exasol.util - package com.exasol.util
compare(ValueExpression, ComparisonOperator, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
compare(ValueExpression, String, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
Comparison - Class in com.exasol.sql.expression
Comparison(ComparisonOperator, ValueExpression, ValueExpression) - Constructor for class com.exasol.sql.expression.Comparison
ComparisonOperator - Enum in com.exasol.sql.expression: This enum represents the different types of Comparisons that can be used in Expressions.
CONCAT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
config - Variable in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
config - Variable in class com.exasol.sql.rendering.AbstractFragmentRenderer
connect(BooleanExpression) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
connectorDeque - Variable in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
CONVERT_TZ - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
CORR - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
COS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
COSH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
COT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
COUNT - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
COVAR_POP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
COVAR_SAMP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
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
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
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
CURRENT_DATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
CURRENT_SCHEMA - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
CURRENT_SESSION - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
CURRENT_STATEMENT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
CURRENT_TIMESTAMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
CURRENT_USER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction

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
DAYS_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
DBTIMEZONE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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
DEFAULT - com.exasol.sql.dql.select.JoinType
defaultValue() - Static method in class com.exasol.sql.expression.DefaultValue
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
DerivedColumn - Class in com.exasol.sql: This class represents a derived column in an SQL query.
DerivedColumn(Fragment, ValueExpression) - Constructor for class com.exasol.sql.DerivedColumn: Create a new instance of a DerivedColumn.
DerivedColumn(Fragment, ValueExpression, String) - Constructor for class com.exasol.sql.DerivedColumn: Create a new instance of a DerivedColumn.
desc() - Method in class com.exasol.sql.dql.select.OrderByClause: Add DESC option to the OrderByClause
dismissConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.AbstractBooleanExpression: Sub-classes must override this method so that the visitor knows the type of the visited class at compile time.
dismissConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.And
dismissConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.BooleanLiteral
dismissConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Comparison
dismissConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Like
dismissConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Not
dismissConcrete(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Or
DIV - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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
doubleLiteral(double) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create a double literal.
DoubleLiteral - Class in com.exasol.sql.expression: 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
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
DUMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction

E

EDIT_DISTANCE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
endParenthesis() - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
endParenthesis() - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
eq(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
EQUAL - com.exasol.sql.expression.ComparisonOperator
escape(char) - Method in class com.exasol.sql.expression.Like.Builder: Add an escape character.
EVERY - com.exasol.sql.expression.function.exasol.ExasolAnalyticFunctions
ExasolAggregateFunction - Enum in com.exasol.sql.expression.function.exasol: This class is a list of Aggregate Functions that the Exasol database supports.
ExasolAnalyticFunctions - Enum in com.exasol.sql.expression.function.exasol: This class is a list of Analytic Functions that the Exasol database supports.
ExasolFunction - Class in com.exasol.sql.expression.function.exasol: This class represents a function in the Exasol database.
ExasolScalarFunction - Enum in com.exasol.sql.expression.function.exasol: This class is a list of Scalar Functions that the Exasol database supports.
ExasolUdf - Class in com.exasol.sql.expression.function.exasol: This class represents a User Defined Function in the Exasol database.
EXP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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
floatLiteral(float) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create a float literal.
FloatLiteral - Class in com.exasol.sql.expression: This class represents float literals.
FLOOR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
Fragment - Interface in com.exasol.sql: This is the common interface for all fragments of SQL statements.
FragmentRenderer - Interface in com.exasol.sql.rendering
from() - Method in class com.exasol.sql.dql.select.Select: Get the FromClause of this select statement.
FROM_POSIX_TIME - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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_OUTER - com.exasol.sql.dql.select.JoinType
fullJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause: Create a new full Join that belongs to a FROM clause.
fullOuterJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause: Create a new full outer Join that belongs to a FROM clause.
function(FunctionName) - 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 - Interface in com.exasol.sql.expression.function: This class represents a function in an SQL statement.
functionName - Variable in class com.exasol.sql.expression.function.AbstractFunction
FunctionName - Interface in com.exasol.sql.expression.function

G

ge(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
getAlias() - Method in class com.exasol.sql.Table: Get the correlation name (i.e.
getAutoQuoted(String) - Method in class com.exasol.util.QuotesApplier: Applies quotes if it ie required in the configuration.
getCascade() - Method in class com.exasol.sql.ddl.drop.DropSchema: Get the cascade.
getCascadeConstraints() - Method in class com.exasol.sql.ddl.drop.DropTable
getChild(int) - Method in class com.exasol.util.AbstractTree
getChild(int) - Method in interface com.exasol.util.TreeNode: Get child node by position in the list of siblings.
getChildren() - Method in class com.exasol.util.AbstractTree
getChildren() - Method in interface com.exasol.util.TreeNode: Get all child nodes of this node
getColumn() - Method in class com.exasol.sql.dml.merge.MergeColumnUpdate: Get the column to be updated.
getColumnName() - Method in class com.exasol.sql.Column: Get the column name
getColumnName() - Method in class com.exasol.sql.expression.ColumnReference: Get the column name.
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.
getEscape() - Method in class com.exasol.sql.expression.Like: Get an escape character.
getExpression() - Method in class com.exasol.sql.dml.merge.MergeColumnUpdate: Get the expression that serves as the value for the update.
getExpression() - Method in class com.exasol.sql.dql.select.WhereClause: Get the boolean expression defining the filter criteria
getExpressions() - Method in class com.exasol.sql.ValueTableRow: Get the list of expressions the row consists of.
getFunctionName() - Method in class com.exasol.sql.expression.function.AbstractFunction
getFunctionName() - Method in interface com.exasol.sql.expression.function.Function: Get a function's name.
getHavingBooleanExpression() - Method in class com.exasol.sql.dql.select.GroupByClause: Get the boolean expression.
getInsert() - Method in class com.exasol.sql.dml.merge.NotMatchedClause: Get the THEN INSERT clause.
getInstance() - Static method in class com.exasol.sql.StatementFactory: Get an instance of a StatementFactory.
getLeft() - Method in class com.exasol.sql.expression.BinaryArithmeticExpression: Get a left operand of the arithmetic expression.
getLeftOperand() - Method in class com.exasol.sql.expression.Comparison: Get the left-hand side operator of the comparison
getLeftOperand() - Method in class com.exasol.sql.expression.Like: Get the left-hand side operator.
getLength() - Method in class com.exasol.datatype.type.AbstractStringDataType
getMatched() - Method in class com.exasol.sql.dml.merge.Merge: Get the WHEN MATCHED clause.
getMillisecondPrecision() - Method in class com.exasol.datatype.type.IntervalDayToSecond
getName() - Method in class com.exasol.datatype.type.AbstractStringDataType
getName() - Method in class com.exasol.datatype.type.Boolean
getName() - Method in interface com.exasol.datatype.type.DataType
getName() - Method in class com.exasol.datatype.type.Date
getName() - Method in class com.exasol.datatype.type.Decimal
getName() - Method in class com.exasol.datatype.type.DoublePrecision
getName() - Method in class com.exasol.datatype.type.IntervalDayToSecond
getName() - Method in class com.exasol.datatype.type.IntervalYearToMonth
getName() - Method in class com.exasol.datatype.type.Timestamp
getName() - Method in class com.exasol.datatype.type.TimestampWithLocalTimezone
getName() - Method in class com.exasol.sql.ddl.Schema: Get the schema name
getName() - Method in class com.exasol.sql.dql.select.Join: Get the name of the joined table
getName() - Method in class com.exasol.sql.Table: Get the name of the table
getNotMatched() - Method in class com.exasol.sql.dml.merge.Merge: Get the WHEN NOT MATCHED clause.
getNullsFirst() - Method in class com.exasol.sql.dql.select.OrderByClause: Get nulls first.
getOffset() - Method in class com.exasol.sql.dql.select.LimitClause: Get the offset row for the limit
getOn() - Method in class com.exasol.sql.dml.merge.Merge: Get the merge criteria (i.e.
getOperator() - Method in class com.exasol.sql.expression.Comparison: Get the comparison operator
getParent() - Method in class com.exasol.util.AbstractTree
getParent() - Method in interface com.exasol.util.TreeNode: Get the parent of this node
getPrecision() - Method in class com.exasol.datatype.type.Decimal
getRestrict() - Method in class com.exasol.sql.ddl.drop.DropSchema: Get the restriction.
getRight() - Method in class com.exasol.sql.expression.BinaryArithmeticExpression: Get a right operand of the arithmetic expression.
getRightOperand() - Method in class com.exasol.sql.expression.Comparison: Get the right-hand side operator of the comparison
getRightOperand() - Method in class com.exasol.sql.expression.Like: Get the right-hand side operator.
getRoot() - Method in class com.exasol.sql.AbstractFragment
getRoot() - Method in interface com.exasol.sql.Fragment: Get the root statement of this SQL fragment.
getRoot() - Method in class com.exasol.util.AbstractBottomUpTreeNode
getRoot() - Method in class com.exasol.util.AbstractTreeNode
getRoot() - Method in interface com.exasol.util.TreeNode: Get the root of the tree
getRows() - Method in class com.exasol.sql.ValueTable: Get a list of all rows in the value table.
getScale() - Method in class com.exasol.datatype.type.Decimal
getSchemaName() - Method in class com.exasol.sql.ddl.create.CreateSchema: Get the schema name.
getSchemaName() - Method in class com.exasol.sql.ddl.drop.DropSchema: Get the schema name.
getSign() - Method in class com.exasol.datatype.value.AbstractInterval
getSignedValue() - Method in class com.exasol.datatype.value.AbstractInterval
getSpecification() - Method in class com.exasol.sql.dql.select.Join: Get the join specification
getStringOperatorRepresentation() - Method in class com.exasol.sql.expression.BinaryArithmeticExpression: Get a string representation of a member of this enum class.
getTableName() - Method in class com.exasol.sql.ddl.create.CreateTable: Get the table name
getTableName() - Method in class com.exasol.sql.ddl.drop.DropTable
getTableName() - Method in class com.exasol.sql.dml.insert.Insert: Get the name of the table into which data should be inserted
getTableName() - Method in class com.exasol.sql.expression.ColumnReference: Get the table name.
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
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.BigDecimalLiteral: Get the value of the BigDecimalLiteral.
getValue() - Method in class com.exasol.sql.expression.DoubleLiteral: Get the value of the DoubleLiteral
getValue() - Method in class com.exasol.sql.expression.FloatLiteral: Get the value of the FloatLiteral
getValue() - Method in class com.exasol.sql.expression.IntegerLiteral: Get the value of the IntegerLiteral.
getValue() - Method in class com.exasol.sql.expression.LongLiteral: Get the value of the LongLiteral
getValueExpression() - Method in class com.exasol.sql.DerivedColumn: Get a value expression that belongs to this derived column.
getWhere() - Method in class com.exasol.sql.dml.merge.MergeInsertClause: Get the WHERE clause of the insert definition.
getWhere() - Method in class com.exasol.sql.dml.merge.MergeMethodDefinition: Get the WHERE clause of the merge method definition.
getYearPrecision() - Method in class com.exasol.datatype.type.IntervalDayToSecond
getYearPrecision() - Method in class com.exasol.datatype.type.IntervalYearToMonth
GREATER_THAN - com.exasol.sql.expression.ComparisonOperator
GREATER_THAN_OR_EQUAL - com.exasol.sql.expression.ComparisonOperator
GREATEST - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
GROUP_CONCAT - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
groupBy(ColumnReference...) - Method in class com.exasol.sql.dql.select.Select: Create a new GroupByClause.
GroupByClause - Class in com.exasol.sql.dql.select: This class represents the GROUP BY clause of an SQL statement.
GroupByClause(SqlStatement, ColumnReference...) - Constructor for class com.exasol.sql.dql.select.GroupByClause: Create a new instance of a GroupByClause.
gt(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm

H

hasAlias() - Method in class com.exasol.sql.Table: Check if a correlation name (i.a.
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.Like: 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
HASH_SHA - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
HASH_SHA256 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
HASH_SHA512 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
HASH_TIGER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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.Like: 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.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.
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
HOURS_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction

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.
INITCAP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
INNER - com.exasol.sql.dql.select.JoinType
innerJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause: Create a new inner Join that belongs to a FROM clause.
Insert - Class in com.exasol.sql.dml.insert: This class implements an SQL Insert statement.
Insert(String) - Constructor for class com.exasol.sql.dml.insert.Insert: Create a new instance of an Insert statement
INSERT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
insertFields - Variable in class com.exasol.sql.dml.insert.AbstractInsertValueTable
InsertFields - Class in com.exasol.sql.dml.insert: Field list that defines the fields data is being inserted into.
InsertFields(Fragment) - Constructor for class com.exasol.sql.dml.insert.InsertFields: Create an new instance of InsertFields
InsertFragment - Interface in com.exasol.sql.dml.insert: This is the common interface for all fragments of a INSERT statement.
insertInto(String) - Method in class com.exasol.sql.StatementFactory: Create an Insert statement.
InsertRenderer - Class in com.exasol.sql.dml.insert.rendering: The InsertRenderer turns SQL statement structures in to SQL strings.
InsertRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.dml.insert.rendering.InsertRenderer: Create a new InsertRenderer with custom render settings.
insertValueTable - Variable in class com.exasol.sql.dml.insert.AbstractInsertValueTable
InsertVisitor - Interface in com.exasol.sql.dml.insert
INSTR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
integerLiteral(int) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create an integer literal.
IntegerLiteral - Class in com.exasol.sql.expression: This class represents integer literals.
IntervalDayToSecond - Class in com.exasol.datatype.type: This class implements the Exasol-proprietary data type interval day to second.
IntervalDayToSecond - 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
IS_BOOLEAN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
IS_DATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
IS_DSINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
IS_NUMBER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
IS_TIMESTAMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
IS_YMINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
isChild() - Method in class com.exasol.util.AbstractTree
isChild() - Method in interface com.exasol.util.TreeNode: Check whether this node is a child node
isEmpty() - Method in class com.exasol.sql.ValueTable
isFirstSibling() - Method in class com.exasol.util.AbstractTree
isFirstSibling() - Method in interface com.exasol.util.TreeNode: Check whether a child is the first in the list of siblings
isRoot() - Method in class com.exasol.util.AbstractTree
isRoot() - Method in interface com.exasol.util.TreeNode: Check whether this node is the root of the tree.
isSibling(TreeNode) - Method in class com.exasol.util.AbstractTree
isSibling(TreeNode) - Method in interface com.exasol.util.TreeNode: Check whether this node is a sibling of the second node.

J

join(String, String) - Method in class com.exasol.sql.dql.select.FromClause: Create a new Join that belongs to a FROM clause.
Join - Class in com.exasol.sql.dql.select: This class implements the Join part of a WHERE clause.
Join(Fragment, JoinType, String, String) - Constructor for class com.exasol.sql.dql.select.Join: Create a new Join instance
JoinType - Enum in com.exasol.sql.dql.select: This class represents the Join types supported by SQL.

L

LAST_VALUE - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
LCASE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
le(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
LEAST - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
leave(ColumnsDefinition) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
leave(ColumnsDefinition) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
leave(CreateTable) - Method in interface com.exasol.sql.ddl.create.CreateTableVisitor
leave(CreateTable) - Method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer
leave(InsertFields) - Method in interface com.exasol.sql.dml.insert.InsertVisitor
leave(InsertFields) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
leave(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(And) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
leave(And) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer
leave(BooleanLiteral) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
leave(BooleanLiteral) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer
leave(Comparison) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
leave(Comparison) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer
leave(ExasolFunction) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
leave(ExasolFunction) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
leave(ExasolUdf) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
leave(ExasolUdf) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
leave(Like) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
leave(Like) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer
leave(Not) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
leave(Not) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer
leave(Or) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
leave(Or) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer
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(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
left(ValueExpression) - Method in class com.exasol.sql.expression.Like.Builder: Add the left operand.
LEFT - com.exasol.sql.dql.select.JoinType
LEFT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
LEFT_OUTER - com.exasol.sql.dql.select.JoinType
leftJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause: Create a new left Join that belongs to a FROM clause.
leftOuterJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause: Create a new left outer Join that belongs to a FROM clause.
LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
LESS_THAN - com.exasol.sql.expression.ComparisonOperator
LESS_THAN_OR_EQUAL - com.exasol.sql.expression.ComparisonOperator
like(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
like(ValueExpression, ValueExpression, char) - Static method in class com.exasol.sql.expression.BooleanTerm
Like - Class in com.exasol.sql.expression: This class represents a logical LIKE predicate.
Like.Builder - Class in com.exasol.sql.expression: A builder for Like.
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.ExasolAnalyticFunctions
LN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
LOCALTIMESTAMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
LOCATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
LOG - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
LOG10 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
LOG2 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
longLiteral(long) - Static method in class com.exasol.sql.expression.ExpressionTerm: Create an long literal.
LongLiteral - Class in com.exasol.sql.expression: This class represents long literals.
LOWER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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
lt(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
LTRIM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction

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
MEDIAN - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
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
MIN - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
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
MINUTES_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
MOD - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
MONTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
MONTHS_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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

N

name() - Method in interface com.exasol.sql.expression.function.FunctionName
ne(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
not() - Method in class com.exasol.sql.expression.Like.Builder: Set for NOT LIKE expression.
not(boolean) - Static method in class com.exasol.sql.expression.BooleanTerm
not(BooleanExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
Not - Class in com.exasol.sql.expression: This class implements the logical unary NOT 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_EQUAL - com.exasol.sql.expression.ComparisonOperator
notLike(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
notLike(ValueExpression, ValueExpression, char) - Static method in class com.exasol.sql.expression.BooleanTerm
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
NPROC - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
NULLIF - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
NULLIFZERO - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
nullLiteral() - Static method in class com.exasol.sql.expression.ExpressionTerm: Create a NULL literal.
nullLiteral() - Static method in class com.exasol.sql.expression.NullLiteral
NullLiteral - Class in com.exasol.sql.expression: 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
NUMTOYMINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
NVL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
NVL2 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction

O

OCTET_LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
of(boolean) - Static method in class com.exasol.sql.expression.BooleanLiteral
of(char) - Static method in class com.exasol.sql.expression.StringLiteral: Create a new StringLiteral from a character.
of(double) - Static method in class com.exasol.sql.expression.DoubleLiteral: Create a new DoubleLiteral from a double.
of(float) - Static method in class com.exasol.sql.expression.FloatLiteral: Create a new FloatLiteral from a float.
of(int) - Static method in class com.exasol.sql.expression.IntegerLiteral: Create a new IntegerLiteral from an integer.
of(long) - Static method in class com.exasol.sql.expression.LongLiteral: Create a new LongLiteral from a long.
of(BinaryArithmeticExpression.BinaryArithmeticOperator, ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BinaryArithmeticExpression: Create a new BinaryArithmeticExpression 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(String) - Static method in class com.exasol.sql.expression.BooleanLiteral: Create a new BooleanLiteral instance from a String.
of(String) - Static method in class com.exasol.sql.expression.ColumnReference: Create a new ColumnReference from a column name.
of(String) - Static method in class com.exasol.sql.expression.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.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.ComparisonOperator: Get the ComparisonOperator for the provided symbol
on(BooleanExpression) - Method in class com.exasol.sql.dml.merge.Merge: Define the merge criteria.
OnClause - Class in com.exasol.sql.dml.merge: The ON clause of an SQL MERGE statement.
OnClause(Fragment, BooleanExpression) - Constructor for class com.exasol.sql.dml.merge.OnClause: Create a new instance of a OnClause.
operation(String, BooleanExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm: Create a logical operation from an operator name and a list of operands
or(boolean...) - Static method in class com.exasol.sql.expression.BooleanTerm
or(boolean, BooleanExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
or(BooleanExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm
or(BooleanExpression, boolean) - Static method in class com.exasol.sql.expression.BooleanTerm
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(ColumnReference...) - Method in class com.exasol.sql.dql.select.Select: Create a new OrderByClause.
OrderByClause - Class in com.exasol.sql.dql.select: This class represents the ORDER BY clause of an SQL statement.
OrderByClause(SqlStatement, ColumnReference...) - Constructor for class com.exasol.sql.dql.select.OrderByClause: Create a new instance of a OrderByClause.

P

parent - Variable in class com.exasol.util.AbstractTree
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
PI - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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
POSIX_TIME - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
POWER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction

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
RANDOM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
REGEXP_INSTR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
REGEXP_REPLACE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
REGEXP_SUBSTR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
REGR_AVGX - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
REGR_AVGY - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
REGR_COUNT - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
REGR_INTERCEPT - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
REGR_R2 - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
REGR_SLOPE - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
REGR_SXX - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
REGR_SXY - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
REGR_SYY - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
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
REPLACE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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
right(ValueExpression) - Method in class com.exasol.sql.expression.Like.Builder: Add the right operand.
RIGHT - com.exasol.sql.dql.select.JoinType
RIGHT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
RIGHT_OUTER - com.exasol.sql.dql.select.JoinType
rightJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause: Create a new right Join that belongs to a FROM clause.
rightOuterJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause: Create a new right outer Join that belongs to a FROM clause.
root - Variable in class com.exasol.sql.AbstractFragment
ROUND - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ROWID - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ROWNUM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
RPAD - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
RTRIM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction

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
SECOND - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
SECONDS_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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.
SelectRenderer - Class in com.exasol.sql.dql.select.rendering: The SelectRenderer turns SQL statement structures in to SQL strings.
SelectRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.dql.select.rendering.SelectRenderer: Create a new SelectRenderer with custom render settings.
SelectVisitor - Interface in com.exasol.sql.dql.select
self() - Method in class com.exasol.datatype.type.AbstractStringDataType
self() - Method in class com.exasol.datatype.type.Char
self() - Method in class com.exasol.datatype.type.Varchar
self() - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
self() - Method in class com.exasol.sql.dml.insert.Insert
self() - Method in class com.exasol.sql.dml.merge.MergeInsertClause
SESSIONTIMEZONE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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(ValueExpression) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
setLastVisited(Fragment) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
setParent(TreeNode) - Method in class com.exasol.util.AbstractBottomUpTreeNode
setParent(TreeNode) - Method in class com.exasol.util.AbstractTreeNode: Link to a parent node
setParent(TreeNode) - Method in interface com.exasol.util.TreeNode: Set a parent for this node.
setToDefault(String) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause: Update a column with the default value defined for that column.
SIGN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
SIN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
SINH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
SOUNDEX - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
SqlStatement - Interface in com.exasol.sql: This interface represents an SQL statement.
SQRT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_AREA - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_BOUNDARY - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_BUFFER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_CENTROID - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_CONTAINS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_CONVEXHULL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_CROSSES - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_DIFFERENCE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_DIMENSION - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_DISJOINT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_DISTANCE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_ENDPOINT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_ENVELOPE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_EQUALS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_EXTERIORRING - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_FORCE2D - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_GEOMETRYN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_GEOMETRYTYPE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_INTERIORRINGN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_INTERSECTION - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_INTERSECTS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_ISCLOSED - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_ISEMPTY - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_ISRING - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_ISSIMPLE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_NUMGEOMETRIES - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_NUMINTERIORRINGS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_NUMPOINTS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_OVERLAPS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_POINTN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_SETSRID - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_STARTPOINT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_SYMDIFFERENCE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_TOUCHES - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_TRANSFORM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_UNION - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_WITHIN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_X - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
ST_Y - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
startParenthesis() - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
startParenthesis() - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
StatementFactory - Class in com.exasol.sql: The StatementFactory implements an factory for SQL statements.
STDDEV - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
STDDEV_POP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
STDDEV_SAMP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
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: 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
SUBTRACT - com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator
SUM - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
SYS_GUID - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
SYSDATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
SYSTIMESTAMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction

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
TANH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
thenDelete() - Method in class com.exasol.sql.dml.merge.MatchedClause: Select deleting as merge strategy for rows where that are considered matches between source and destination.
thenInsert() - Method in class com.exasol.sql.dml.merge.NotMatchedClause: Select inserting as merge strategy for rows from the source for which no match in the destination exists.
thenUpdate() - Method in class com.exasol.sql.dml.merge.MatchedClause: Select updating as merge strategy for rows where that are considered matches between source and destination.
Timestamp - Class in com.exasol.datatype.type: This class implements the SQl data type timestamp
Timestamp() - Constructor for class com.exasol.datatype.type.Timestamp
timestampColumn(String) - Method in class com.exasol.sql.ColumnsDefinition.Builder: Add timestamp column.
timestampColumn(String) - Method in class com.exasol.sql.ddl.create.CreateTable: Add timestamp column
TimestampWithLocalTimezone - Class in com.exasol.datatype.type: This class implements the Exasol-proprietary data type timestamp with local timezone data
TimestampWithLocalTimezone() - Constructor for class com.exasol.datatype.type.TimestampWithLocalTimezone
timestampWithLocalTimeZoneColumn(String) - Method in class com.exasol.sql.ColumnsDefinition.Builder: Add timestamp with local time zone column.
timestampWithLocalTimeZoneColumn(String) - Method in class com.exasol.sql.ddl.create.CreateTable: Add timestamp with local time zone column
TO_CHAR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
TO_DATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
TO_DSINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
TO_NUMBER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
TO_TIMESTAMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
TO_YMINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
toBoolean() - Method in class com.exasol.sql.expression.BooleanLiteral: Get boolean value this literal represents.
toBooleanExpressions(boolean[]) - Static method in class com.exasol.sql.expression.BooleanLiteral: Map an array of booleans to and array of BooleanExpressions
toMillis() - Method in class com.exasol.datatype.value.IntervalDayToSecond: Get the interval as the total number of milliseconds between two points in time.
toMonths() - Method in class com.exasol.datatype.value.IntervalYearToMonth: Get the interval as the total number of months between two points in time
toString() - Method in class com.exasol.datatype.value.IntervalDayToSecond
toString() - Method in class com.exasol.datatype.value.IntervalYearToMonth
toString() - Method in enum com.exasol.sql.dql.select.JoinType
toString() - Method in class com.exasol.sql.expression.BigDecimalLiteral
toString() - Method in class com.exasol.sql.expression.BooleanLiteral
toString() - Method in class com.exasol.sql.expression.ColumnReference
toString() - Method in enum com.exasol.sql.expression.ComparisonOperator: Returns the operator symbol that represents the comparison.
toString() - Method in class com.exasol.sql.expression.DoubleLiteral
toString() - Method in class com.exasol.sql.expression.FloatLiteral
toString() - Method in class com.exasol.sql.expression.IntegerLiteral
toString() - Method in class com.exasol.sql.expression.LongLiteral
toString() - Method in class com.exasol.sql.expression.StringLiteral
toString() - Method in class com.exasol.sql.UnnamedPlaceholder
TRANSLATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
TreeNode - Interface in com.exasol.util: This class represents a node in a tree structure.
TRIM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
TRUNC - com.exasol.sql.expression.function.exasol.ExasolScalarFunction

U

UCASE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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.
UNICODE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
UNICODECHR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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
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
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
VALUE2PROC - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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
valueExpressions - Variable in class com.exasol.sql.expression.function.AbstractFunction
ValueExpressionVisitor - Interface in com.exasol.sql.expression: Visitor interface for a BooleanTerm.
valueOf(String) - Static method in enum com.exasol.sql.dql.select.JoinType: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.ComparisonOperator: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAnalyticFunctions: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Returns the enum constant of this type with the specified name.
valuePlaceholder() - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable: Add an unnamed value placeholder to the value list (this is useful for prepared statements).
valuePlaceholders(int) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable: Add a given number unnamed value placeholder to the value list (this is useful for prepared statements).
values() - Static method in enum com.exasol.sql.dql.select.JoinType: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.exasol.sql.expression.ComparisonOperator: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAggregateFunction: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAnalyticFunctions: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.exasol.sql.expression.function.exasol.ExasolScalarFunction: Returns an array containing the constants of this enum type, in the order they are declared.
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
VAR_POP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
VAR_SAMP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
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
visit(Boolean) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
visit(Boolean) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(Char) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
visit(Char) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(Date) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
visit(Date) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(Decimal) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
visit(Decimal) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(DoublePrecision) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
visit(DoublePrecision) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(IntervalDayToSecond) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
visit(IntervalDayToSecond) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(IntervalYearToMonth) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
visit(IntervalYearToMonth) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(Timestamp) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
visit(Timestamp) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(TimestampWithLocalTimezone) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
visit(TimestampWithLocalTimezone) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(Varchar) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
visit(Varchar) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(Column) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
visit(Column) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(ColumnsDefinition) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
visit(ColumnsDefinition) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
visit(CreateSchema) - Method in interface com.exasol.sql.ddl.create.CreateSchemaVisitor
visit(CreateSchema) - Method in class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer
visit(CreateTable) - Method in interface com.exasol.sql.ddl.create.CreateTableVisitor
visit(CreateTable) - Method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer
visit(Cascade) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor
visit(Cascade) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
visit(CascadeConstraints) - Method in interface com.exasol.sql.ddl.drop.DropTableVisitor
visit(CascadeConstraints) - Method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer
visit(DropSchema) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor
visit(DropSchema) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
visit(DropTable) - Method in interface com.exasol.sql.ddl.drop.DropTableVisitor
visit(DropTable) - Method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer
visit(Restrict) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor
visit(Restrict) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
visit(Schema) - Method in interface com.exasol.sql.ddl.create.CreateSchemaVisitor
visit(Schema) - Method in class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer
visit(Schema) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor
visit(Schema) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
visit(DerivedColumn) - Method in interface com.exasol.sql.dml.insert.InsertVisitor
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(InsertFields) - Method in interface com.exasol.sql.dml.insert.InsertVisitor
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(GroupByClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(GroupByClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor
visit(Join) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(Join) - Method in interface com.exasol.sql.dql.select.SelectVisitor
visit(LimitClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(LimitClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor
visit(OrderByClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(OrderByClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor
visit(Select) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
visit(Select) - Method in interface com.exasol.sql.dql.select.SelectVisitor
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(And) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
visit(And) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer
visit(BigDecimalLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(BigDecimalLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
visit(BinaryArithmeticExpression) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(BinaryArithmeticExpression) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
visit(BooleanExpression) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(BooleanExpression) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
visit(BooleanLiteral) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
visit(BooleanLiteral) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer
visit(BooleanLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(BooleanLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
visit(ColumnReference) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(ColumnReference) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
visit(Comparison) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
visit(Comparison) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer
visit(DefaultValue) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(DefaultValue) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
visit(DoubleLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(DoubleLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
visit(FloatLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(FloatLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
visit(ExasolFunction) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(ExasolFunction) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
visit(ExasolUdf) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(ExasolUdf) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
visit(IntegerLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(IntegerLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
visit(Like) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
visit(Like) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer
visit(LongLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(LongLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
visit(Not) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
visit(Not) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer
visit(NullLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(NullLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
visit(Or) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
visit(Or) - Method in class com.exasol.sql.expression.rendering.BooleanExpressionRenderer
visit(StringLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(StringLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
visit(SqlStatement) - Method in interface com.exasol.sql.dml.insert.InsertVisitor
visit(SqlStatement) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
visit(Table) - Method in interface com.exasol.sql.ddl.create.CreateTableVisitor
visit(Table) - Method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer
visit(Table) - Method in interface com.exasol.sql.ddl.drop.DropTableVisitor
visit(Table) - Method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer
visit(Table) - Method in interface com.exasol.sql.dml.insert.InsertVisitor
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(UnnamedPlaceholder) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
visit(UnnamedPlaceholder) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
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(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

W

WEEK - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
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 - Variable in class com.exasol.sql.dml.merge.MergeMethodDefinition
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

Y

YEAR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
YEARS_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction

Z

ZEROIFNULL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction

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