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
All Classes All Packages
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
- AbstractComparison - Class in com.exasol.sql.expression.comparison
-
Abstract basis for comparisons.
- AbstractComparison(ComparisonOperator, ValueExpression, ValueExpression) - Constructor for class com.exasol.sql.expression.comparison.AbstractComparison
-
Create a new instance of
AbstractComparison. - AbstractExpressionRenderer - Class in com.exasol.sql.expression.rendering
-
Common base class for expression renderers.
- AbstractExpressionRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
- 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
- AbstractLiteral - Class in com.exasol.sql.expression.literal
-
Abstract basis for
Literals. - AbstractLiteral() - Constructor for class com.exasol.sql.expression.literal.AbstractLiteral
- AbstractPredicate - Class in com.exasol.sql.expression.predicate
-
An abstract basis for predicate classes.
- AbstractPredicate(PredicateOperator) - Constructor for class com.exasol.sql.expression.predicate.AbstractPredicate
-
Creates a new instance of
AbstractPredicate. - AbstractStringDataType<T extends AbstractStringDataType<T>> - Class in com.exasol.datatype.type
-
Implements common logic for String data types
- AbstractStringDataType(int, int, String) - Constructor for class com.exasol.datatype.type.AbstractStringDataType
- 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
MERGEstatements - 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
SELECTstatements - accept(SelectVisitor) - Method in class com.exasol.sql.Table
- accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.And
- accept(BooleanExpressionVisitor) - Method in interface com.exasol.sql.expression.BooleanExpression
-
Accept a visitor
- accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.comparison.AbstractComparison
- accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.literal.BooleanLiteral
- accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Not
- accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Or
- accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.predicate.AbstractPredicate
- accept(ComparisonVisitor) - Method in interface com.exasol.sql.expression.comparison.Comparison
-
Accept
ComparisonVisitor. - accept(ComparisonVisitor) - Method in class com.exasol.sql.expression.comparison.LikeComparison
- accept(ComparisonVisitor) - Method in class com.exasol.sql.expression.comparison.SimpleComparison
- accept(FunctionVisitor) - Method in class com.exasol.sql.expression.function.exasol.CastExasolFunction
- accept(FunctionVisitor) - Method in class com.exasol.sql.expression.function.exasol.ExasolFunction
- accept(FunctionVisitor) - Method in class com.exasol.sql.expression.function.exasol.ExasolUdf
- accept(FunctionVisitor) - Method in interface com.exasol.sql.expression.function.Function
-
Accept
FunctionVisitor. - accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.BigDecimalLiteral
- accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.BooleanLiteral
- accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.DoubleLiteral
- accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.FloatLiteral
- accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.IntegerLiteral
- accept(LiteralVisitor) - Method in interface com.exasol.sql.expression.literal.Literal
-
Accept a
LiteralVisitor. - accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.LongLiteral
- accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.NullLiteral
- accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.StringLiteral
- accept(PredicateVisitor) - Method in class com.exasol.sql.expression.predicate.BetweenPredicate
- accept(PredicateVisitor) - Method in class com.exasol.sql.expression.predicate.ExistsPredicate
- accept(PredicateVisitor) - Method in class com.exasol.sql.expression.predicate.InPredicate
- accept(PredicateVisitor) - Method in class com.exasol.sql.expression.predicate.IsNullPredicate
- accept(PredicateVisitor) - Method in interface com.exasol.sql.expression.predicate.Predicate
-
Accepts
PredicateVisitor. - accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.AbstractBooleanExpression
- accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.BinaryArithmeticExpression
- accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.ColumnReference
- accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.DefaultValue
- accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.function.AbstractFunction
- accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.literal.AbstractLiteral
- accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.predicate.AbstractPredicate
- accept(ValueExpressionVisitor) - Method in interface com.exasol.sql.expression.ValueExpression
-
Accept a visitor
- accept(ValueExpressionVisitor) - Method in class com.exasol.sql.UnnamedPlaceholder
- accept(ValueTableVisitor) - Method in class com.exasol.sql.ValueTable
-
Accept a visitor.
- accept(ValueTableVisitor) - Method in class com.exasol.sql.ValueTableRow
-
Accept a visitor.
- ACOS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
- 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
- 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
UnnamedPlaceholderto 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
Andinstance - And(BooleanExpression...) - Constructor for class com.exasol.sql.expression.And
-
Create a new
Andinstance - ANY - com.exasol.sql.expression.function.exasol.ExasolAnalyticFunction
- 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(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
- appendRenderedValueExpression(ValueExpression) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
- appendRow(ValueTableRow) - Method in class com.exasol.sql.ValueTable
-
Append a
ValueTableRowto theValueTable. - 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
- between(ValueExpression, ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
- BETWEEN - com.exasol.sql.expression.predicate.BetweenPredicate.BetweenPredicateOperator
- BetweenPredicate - Class in com.exasol.sql.expression.predicate
-
A class that represents a
[NOT] BETWEENpredicate. - BetweenPredicate.BetweenPredicateOperator - Enum in com.exasol.sql.expression.predicate
-
A class that represents
BetweenPredicateoperator. - BetweenPredicate.Builder - Class in com.exasol.sql.expression.predicate
-
A builder for
BetweenPredicate. - BigDecimalLiteral - Class in com.exasol.sql.expression.literal
-
This class represents BigDecimal literals.
- BinaryArithmeticExpression - Class in com.exasol.sql.expression
-
This class represents a binary arithmetic expression.
- BinaryArithmeticExpression.BinaryArithmeticOperator - Enum in com.exasol.sql.expression
-
This enum represents arithmetic operators in an SQL statement.
- BIT_AND - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
- 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
- BooleanExpressionVisitor - Interface in com.exasol.sql.expression
-
Visitor interface for a
BooleanTerm - booleanLiteral(boolean) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a boolean literal.
- BooleanLiteral - Class in com.exasol.sql.expression.literal
-
This class represents boolean literals (read "true" and "false")
- BooleanTerm - Class in com.exasol.sql.expression
- build() - Method in class com.exasol.sql.ColumnsDefinition.Builder
-
Build a new
ColumnsDefinition. - build() - Method in class com.exasol.sql.expression.comparison.LikeComparison.Builder
-
Create a new instance of
LikeComparison. - build() - Method in class com.exasol.sql.expression.predicate.BetweenPredicate.Builder
-
Creates a new instance of
[NOT] BETWEENpredicate class. - build() - Method in class com.exasol.sql.expression.predicate.InPredicate.Builder
-
Creates a new instance of
[NOT] INpredicate class. - build() - Method in class com.exasol.sql.rendering.StringRendererConfig.Builder
-
Create a new instance of a
StringRendererConfig - build() - Method in class com.exasol.sql.ValueTableRow.Builder
-
Build a new
ValueTableRow. - builder - Variable in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
- builder() - Static method in class com.exasol.sql.ColumnsDefinition
-
Create a new builder for
ColumnsDefinition. - builder() - Static method in class com.exasol.sql.expression.comparison.LikeComparison
-
Create a new builder for
LikeComparison. - builder() - Static method in class com.exasol.sql.expression.predicate.BetweenPredicate
-
Creates a new builder for
BetweenPredicate. - builder() - Static method in class com.exasol.sql.expression.predicate.InPredicate
-
Creates a new builder for
InPredicate. - builder() - Static method in class com.exasol.sql.rendering.StringRendererConfig
-
Get a builder for
StringRendererConfig - builder(Fragment) - Static method in class com.exasol.sql.ValueTableRow
-
Get a
ValueTableRow.Builderfor aValueTableRow. - Builder() - Constructor for class com.exasol.sql.ColumnsDefinition.Builder
- Builder() - Constructor for class com.exasol.sql.expression.comparison.LikeComparison.Builder
- Builder(Fragment) - Constructor for class com.exasol.sql.ValueTableRow.Builder
C
- cascade() - Method in class com.exasol.sql.ddl.drop.DropSchema
-
Add
CASCADEclause to aDROP SCHEMAstatement. - 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
Cascadeclass - cascadeConstraints() - Method in class com.exasol.sql.ddl.drop.DropTable
-
Add
CASCADE CONSTRAINTSclause into aDROP TABLEstatement. - 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
CascadeConstraintsclass - CastExasolFunction - Class in com.exasol.sql.expression.function.exasol
-
This class represents the Exasol CAST function.
- 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
Chardata 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.
- 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
ColumnReferencefrom 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.comparison - package com.exasol.sql.expression.comparison
- com.exasol.sql.expression.function - package com.exasol.sql.expression.function
- com.exasol.sql.expression.function.exasol - package com.exasol.sql.expression.function.exasol
- com.exasol.sql.expression.literal - package com.exasol.sql.expression.literal
- com.exasol.sql.expression.predicate - package com.exasol.sql.expression.predicate
- com.exasol.sql.expression.rendering - package com.exasol.sql.expression.rendering
- com.exasol.sql.rendering - package com.exasol.sql.rendering
- com.exasol.util - package com.exasol.util
- compare(ValueExpression, SimpleComparisonOperator, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
- compare(ValueExpression, String, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
- Comparison - Interface in com.exasol.sql.expression.comparison
-
Interface for classes that implement comparisons between two columns.
- ComparisonOperator - Interface in com.exasol.sql.expression.comparison
-
Interface for comparison operators.
- ComparisonVisitor - Interface in com.exasol.sql.expression.comparison
-
Visitor for
Comparison. - CONCAT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
- config - Variable in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
- config - Variable in class com.exasol.sql.rendering.AbstractFragmentRenderer
- 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
CreateSchemaRendererusing the default renderer configuration - create() - Static method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer
-
Create an
CreateTableRendererusing the default renderer configuration - create() - Static method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
-
Create an
DropSchemaRendererusing the default renderer configuration - create() - Static method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer
-
Create an
DropTableRendererusing the default renderer configuration - create() - Static method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
-
Create an
InsertRendererusing the default renderer configuration - create() - Static method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
-
Create a
MergeRendererusing the default renderer configuration. - create() - Static method in class com.exasol.sql.dql.select.rendering.SelectRenderer
-
Create an
SelectRendererusing 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
CreateSchemastatement. - CreateSchema - Class in com.exasol.sql.ddl.create
-
This class implements an SQL
CreateSchemastatement. - CreateSchema(String) - Constructor for class com.exasol.sql.ddl.create.CreateSchema
-
Create a new instance of an
CreateSchemastatement. - 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
CreateSchemaRendererturns SQL statement structures in to SQL strings. - CreateSchemaRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer
-
Create a new
CreateSchemaRendererwith custom render settings. - CreateSchemaVisitor - Interface in com.exasol.sql.ddl.create
- createTable(String) - Method in class com.exasol.sql.StatementFactory
-
Create a
CreateTablestatement. - CreateTable - Class in com.exasol.sql.ddl.create
-
This class implements an SQL
CreateTablestatement - CreateTable(String) - Constructor for class com.exasol.sql.ddl.create.CreateTable
-
Create a new instance of an
CreateTablestatement - 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
CreateTableRendererturns SQL statement structures in to SQL strings. - CreateTableRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.ddl.create.rendering.CreateTableRenderer
-
Create a new
CreateTableRendererwith 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
Decimaldata 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
DefaultValueis 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 - 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.literal
-
This class represents double literals.
- DoublePrecision - Class in com.exasol.datatype.type
-
This class implements a double precision floating point number data type
- DoublePrecision() - Constructor for class com.exasol.datatype.type.DoublePrecision
- doublePrecisionColumn(String) - Method in class com.exasol.sql.ColumnsDefinition.Builder
-
Add double precision column.
- doublePrecisionColumn(String) - Method in class com.exasol.sql.ddl.create.CreateTable
-
Add double precision column
- dropSchema(String) - Method in class com.exasol.sql.StatementFactory
-
Create a
DropSchemastatement. - DropSchema - Class in com.exasol.sql.ddl.drop
-
This class implements an SQL
DropSchemastatement. - DropSchema(String) - Constructor for class com.exasol.sql.ddl.drop.DropSchema
-
Create a new instance of an
DropSchemastatement. - 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
DropSchemaRendererturns SQL statement structures in to SQL strings. - DropSchemaRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
-
Create a new
DropSchemaRendererwith custom render settings. - DropSchemaVisitor - Interface in com.exasol.sql.ddl.drop
- dropTable(String) - Method in class com.exasol.sql.StatementFactory
-
Create a
DropTablestatement. - DropTable - Class in com.exasol.sql.ddl.drop
-
This class implements an SQL
DropTablestatement. - DropTable(String) - Constructor for class com.exasol.sql.ddl.drop.DropTable
-
Create a new instance of an
DropTablestatement. - 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
DropTableRendererturns SQL statement structures in to SQL strings. - DropTableRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.ddl.drop.rendering.DropTableRenderer
-
Create a new
DropTableRendererwith 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
- end(ValueExpression) - Method in class com.exasol.sql.expression.predicate.BetweenPredicate.Builder
-
Adds the end expression of predicate.
- endParenthesis() - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
- 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.comparison.SimpleComparisonOperator
- escape(char) - Method in class com.exasol.sql.expression.comparison.LikeComparison.Builder
-
Add an escape character.
- EVERY - com.exasol.sql.expression.function.exasol.ExasolAnalyticFunction
- ExasolAggregateFunction - Enum in com.exasol.sql.expression.function.exasol
-
This class is a list of Aggregate Functions that the Exasol database supports.
- ExasolAnalyticFunction - 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.
- ExasolFunction(FunctionName, List<ValueExpression>) - Constructor for class com.exasol.sql.expression.function.exasol.ExasolFunction
- 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.
- exists(Select) - Static method in class com.exasol.sql.expression.BooleanTerm
- EXISTS - com.exasol.sql.expression.predicate.ExistsPredicate.ExistsPredicateOperator
- ExistsPredicate - Class in com.exasol.sql.expression.predicate
-
A class that represents a
EXISTSpredicate. - ExistsPredicate(Select) - Constructor for class com.exasol.sql.expression.predicate.ExistsPredicate
-
Creates a new instance of
ExistsPredicate. - ExistsPredicate.ExistsPredicateOperator - Enum in com.exasol.sql.expression.predicate
-
An operator for
ExistsPredicateclass. - EXP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
- expression(ValueExpression) - Method in class com.exasol.sql.expression.predicate.BetweenPredicate.Builder
-
Adds the left expression of predicate.
- expression(ValueExpression) - Method in class com.exasol.sql.expression.predicate.InPredicate.Builder
-
Adds the predicate expression.
- ExpressionTerm - Class in com.exasol.sql.expression
-
Static factory methods for SQL expressions.
F
- field(String...) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Define fields into which should be inserted.
- field(String...) - Method in class com.exasol.sql.dql.select.Select
-
Add one or more named fields.
- FIRST_VALUE - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
- floatLiteral(float) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a float literal.
- FloatLiteral - Class in com.exasol.sql.expression.literal
-
This class represents float literals.
- FLOOR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
- 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
FromClauseof 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
FROMclause of an SQLSELECTstatement. - 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
Jointhat belongs to aFROMclause. - fullOuterJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause
-
Create a new full outer
Jointhat belongs to aFROMclause. - function(Function) - Method in class com.exasol.sql.dql.select.Select
-
Add a function.
- function(FunctionName) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create an Exasol function.
- function(FunctionName, ValueExpression...) - Method in class com.exasol.sql.dql.select.Select
-
Add a function.
- function(FunctionName, ValueExpression...) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create an Exasol function.
- function(FunctionName, String, ValueExpression...) - Method in class com.exasol.sql.dql.select.Select
-
Add a function.
- function(Function, String) - Method in class com.exasol.sql.dql.select.Select
-
Add a function.
- Function - Interface in com.exasol.sql.expression.function
-
This class represents a function in an SQL statement.
- functionName - Variable in class com.exasol.sql.expression.function.AbstractFunction
- FunctionName - Interface in com.exasol.sql.expression.function
- FunctionVisitor - Interface in com.exasol.sql.expression.function
-
Visitor interface for
Function.
G
- ge(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
- 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
- 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 DELETEclause. - getDerivedColumnName() - Method in class com.exasol.sql.DerivedColumn
-
Get a derived column name.
- getDesc() - Method in class com.exasol.sql.dql.select.OrderByClause
-
Get descending.
- getEmitsColumnsDefinition() - Method in class com.exasol.sql.expression.function.exasol.ExasolUdf
-
Get a columns definition for the EMITS.
- getEndExpression() - Method in class com.exasol.sql.expression.predicate.BetweenPredicate
-
Returns the end expression in the
[NOT] BETWEENpredicate. - getEscape() - Method in class com.exasol.sql.expression.comparison.LikeComparison
-
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
- getExpression() - Method in class com.exasol.sql.expression.predicate.BetweenPredicate
-
Returns the left expression in the
[NOT] BETWEENpredicate. - getExpression() - Method in class com.exasol.sql.expression.predicate.InPredicate
-
Returns the left expression in the
[NOT] INpredicate. - 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 INSERTclause. - 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.AbstractComparison
-
Get the left-hand side operator of the comparison
- getLeftOperand() - Method in interface com.exasol.sql.expression.comparison.Comparison
-
Get the left-hand side operator of the comparison
- getLength() - Method in class com.exasol.datatype.type.AbstractStringDataType
- getMatched() - Method in class com.exasol.sql.dml.merge.Merge
-
Get the
WHEN MATCHEDclause. - 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 MATCHEDclause. - getNullsFirst() - Method in class com.exasol.sql.dql.select.OrderByClause
-
Get nulls first.
- getOffset() - Method in class com.exasol.sql.dql.select.LimitClause
-
Get the offset row for the limit
- getOn() - Method in class com.exasol.sql.dml.merge.Merge
-
Get the merge criteria (i.e.
- getOperand() - Method in class com.exasol.sql.expression.Not
-
Get the boolean expression literal to be negated.
- getOperand() - Method in class com.exasol.sql.expression.predicate.IsNullPredicate
-
Returns the value expression to be checked for
null. - getOperands() - Method in class com.exasol.sql.expression.And
-
Get the operands of this AND.
- getOperands() - Method in class com.exasol.sql.expression.Or
-
Get the operands of this OR.
- getOperands() - Method in class com.exasol.sql.expression.predicate.InPredicate
-
Returns the value expressions in the
[NOT] INpredicate. - getOperator() - Method in class com.exasol.sql.expression.comparison.AbstractComparison
-
Get the comparison operator
- getOperator() - Method in interface com.exasol.sql.expression.comparison.Comparison
-
Get the comparison operator
- getOperator() - Method in class com.exasol.sql.expression.predicate.AbstractPredicate
- getOperator() - Method in interface com.exasol.sql.expression.predicate.Predicate
-
Returns the predicate operator.
- getParameters() - Method in class com.exasol.sql.expression.function.AbstractFunction
-
Get the value expressions (parameters of the function)
- getPrecision() - Method in class com.exasol.datatype.type.Decimal
- getRestrict() - Method in class com.exasol.sql.ddl.drop.DropSchema
-
Get the restriction.
- getRight() - Method in class com.exasol.sql.expression.BinaryArithmeticExpression
-
Get a right operand of the arithmetic expression.
- getRightOperand() - Method in class com.exasol.sql.expression.comparison.AbstractComparison
-
Get the right-hand side operator of the comparison
- getRightOperand() - Method in interface com.exasol.sql.expression.comparison.Comparison
-
Get the right-hand side operator of the comparison
- getRoot() - Method in class com.exasol.sql.AbstractFragment
- getRoot() - Method in interface com.exasol.sql.Fragment
-
Get the root statement of this SQL fragment.
- getRows() - Method in class com.exasol.sql.ValueTable
-
Get a list of all rows in the value table.
- getScale() - Method in class com.exasol.datatype.type.Decimal
- getSchemaName() - Method in class com.exasol.sql.ddl.create.CreateSchema
-
Get the schema name.
- getSchemaName() - Method in class com.exasol.sql.ddl.drop.DropSchema
-
Get the schema name.
- getSelectQuery() - Method in class com.exasol.sql.expression.predicate.ExistsPredicate
-
Returns the sub select query in the
EXISTSpredicate. - getSelectQuery() - Method in class com.exasol.sql.expression.predicate.InPredicate
-
Returns the sub select query in the
[NOT] INpredicate. - 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
- getStartExpression() - Method in class com.exasol.sql.expression.predicate.BetweenPredicate
-
Returns the start expression in the
[NOT] BETWEENpredicate. - 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
- getType() - Method in class com.exasol.sql.expression.function.exasol.CastExasolFunction
-
Get the type to cast the value to.
- getUpdate() - Method in class com.exasol.sql.dml.merge.MatchedClause
-
Get the
THEN UPDATEclause. - getUsing() - Method in class com.exasol.sql.dml.merge.Merge
-
Get the
USINGclause of theMERGEstatement. - getValue() - Method in class com.exasol.sql.expression.function.exasol.CastExasolFunction
-
Get the value to cast.
- getValue() - Method in class com.exasol.sql.expression.literal.BigDecimalLiteral
-
Get the value of the
BigDecimalLiteral. - getValue() - Method in class com.exasol.sql.expression.literal.DoubleLiteral
-
Get the value of the
DoubleLiteral - getValue() - Method in class com.exasol.sql.expression.literal.FloatLiteral
-
Get the value of the
FloatLiteral - getValue() - Method in class com.exasol.sql.expression.literal.IntegerLiteral
-
Get the value of the
IntegerLiteral. - getValue() - Method in class com.exasol.sql.expression.literal.LongLiteral
-
Get the value of the
LongLiteral - getValueExpression() - Method in class com.exasol.sql.DerivedColumn
-
Get a value expression that belongs to this derived column.
- getWhere() - Method in class com.exasol.sql.dml.merge.MergeInsertClause
-
Get the
WHEREclause of the insert definition. - getWhere() - Method in class com.exasol.sql.dml.merge.MergeMethodDefinition
-
Get the
WHEREclause 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.comparison.SimpleComparisonOperator
- GREATER_THAN_OR_EQUAL - com.exasol.sql.expression.comparison.SimpleComparisonOperator
- 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 DELETEclause is present. - hasDerivedColumnName() - Method in class com.exasol.sql.DerivedColumn
-
Check if this function has a derived column name.
- hasEmitsColumnsDefinition() - Method in class com.exasol.sql.expression.function.exasol.ExasolUdf
-
Check if the EMITS part is required.
- hasEscape() - Method in class com.exasol.sql.expression.comparison.LikeComparison
-
Check if LIKE predicate has ESCAPE.
- hasFields() - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Check if a insert fields are defined.
- HASH_MD5 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
- 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 EXISTSclause is present. - hasIfExistsModifier() - Method in class com.exasol.sql.ddl.drop.DropTable
-
Check if the
IF EXISTSclause is present. - hasInsert() - Method in class com.exasol.sql.dml.merge.NotMatchedClause
-
Check if the
THEN INSERTclause is present. - hasMatched() - Method in class com.exasol.sql.dml.merge.Merge
-
Check if the
WHEN MATCHEDclause exists. - hasNot() - Method in class com.exasol.sql.expression.comparison.LikeComparison
-
Check if LIKE predicate has NOT.
- hasNotMatched() - Method in class com.exasol.sql.dml.merge.Merge
-
Check if the
WHEN NOT MATCHEDclause 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
ONclause exists. - hasParenthesis() - Method in class com.exasol.sql.expression.function.exasol.CastExasolFunction
- hasParenthesis() - Method in class com.exasol.sql.expression.function.exasol.ExasolFunction
- hasParenthesis() - Method in class com.exasol.sql.expression.function.exasol.ExasolUdf
- hasParenthesis() - Method in interface com.exasol.sql.expression.function.Function
-
Check if function needs parenthesis.
- hasSelectQuery() - Method in class com.exasol.sql.expression.predicate.InPredicate
-
Checks if
InPredicatehas a sub query. - hasSubSelect() - Method in class com.exasol.sql.dql.select.FromClause
-
Check if the
FromClausecontains a sub-select statement. - hasUpdate() - Method in class com.exasol.sql.dml.merge.MatchedClause
-
Check if the
THEN UPDATEclause is present. - hasUsing() - Method in class com.exasol.sql.dml.merge.Merge
-
Check if the
USINGclause 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
WHEREclause exists. - hasWhere() - Method in class com.exasol.sql.dml.merge.MergeMethodDefinition
-
Check if the
WHEREclause 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 EXISTSclause into aDROP SCHEMAstatement. - ifExists() - Method in class com.exasol.sql.ddl.drop.DropTable
-
Add
IF EXISTSclause into aDROP TABLEstatement. - in(ValueExpression, Select) - Static method in class com.exasol.sql.expression.BooleanTerm
- in(ValueExpression, ValueExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm
- IN - com.exasol.sql.expression.predicate.InPredicate.InPredicateOperator
- 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
Jointhat belongs to aFROMclause. - InPredicate - Class in com.exasol.sql.expression.predicate
-
A class that represents a
[NOT] INpredicate. - InPredicate.Builder - Class in com.exasol.sql.expression.predicate
-
A builder for
InPredicate. - InPredicate.InPredicateOperator - Enum in com.exasol.sql.expression.predicate
-
A class that represents
InPredicateoperator. - Insert - Class in com.exasol.sql.dml.insert
-
This class implements an SQL
Insertstatement. - Insert(String) - Constructor for class com.exasol.sql.dml.insert.Insert
-
Create a new instance of an
Insertstatement - 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
Insertstatement. - InsertRenderer - Class in com.exasol.sql.dml.insert.rendering
-
The
InsertRendererturns SQL statement structures in to SQL strings. - InsertRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.dml.insert.rendering.InsertRenderer
-
Create a new
InsertRendererwith 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.literal
-
This class represents integer literals.
- IntervalDayToSecond - Class in com.exasol.datatype.type
-
This class implements the Exasol-proprietary data type interval day to second.
- IntervalDayToSecond - Class in com.exasol.datatype.value
-
This class implements the Exasol-proprietary data type value
INTERVAL DAY(x) TO SECONDS(y). - IntervalDayToSecond(int, int) - Constructor for class com.exasol.datatype.type.IntervalDayToSecond
-
Create a new instance of an
IntervalDayToSeconddata 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
IntervalYearToMonthdata 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_NOT_NULL - com.exasol.sql.expression.predicate.IsNullPredicate.IsNullPredicateOperator
- IS_NULL - com.exasol.sql.expression.predicate.IsNullPredicate.IsNullPredicateOperator
- 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
- isEmpty() - Method in class com.exasol.sql.ValueTable
- isNotNull(ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
- isNull(ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
- IsNullPredicate - Class in com.exasol.sql.expression.predicate
-
A class that represents a
IS [NOT] NULLpredicate. - IsNullPredicate(IsNullPredicate.IsNullPredicateOperator, ValueExpression) - Constructor for class com.exasol.sql.expression.predicate.IsNullPredicate
-
Creates a new instance of
IsNullPredicateforIS [NOT] NULLpredicate. - IsNullPredicate(ValueExpression) - Constructor for class com.exasol.sql.expression.predicate.IsNullPredicate
-
Creates a new instance of
IsNullPredicateforIS NULLpredicate. - IsNullPredicate.IsNullPredicateOperator - Enum in com.exasol.sql.expression.predicate
-
An operator for
IsNullPredicateclass.
J
- join(String, String) - Method in class com.exasol.sql.dql.select.FromClause
-
Create a new
Jointhat belongs to aFROMclause. - Join - Class in com.exasol.sql.dql.select
-
This class implements the
Joinpart of a WHERE clause. - Join(Fragment, JoinType, String, String) - Constructor for class com.exasol.sql.dql.select.Join
-
Create a new
Joininstance - JoinType - Enum in com.exasol.sql.dql.select
-
This class represents the
Jointypes 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(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.comparison.LikeComparison.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
Jointhat belongs to aFROMclause. - leftOperand - Variable in class com.exasol.sql.expression.comparison.AbstractComparison
- leftOuterJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause
-
Create a new left outer
Jointhat belongs to aFROMclause. - LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
- LESS_THAN - com.exasol.sql.expression.comparison.SimpleComparisonOperator
- LESS_THAN_OR_EQUAL - com.exasol.sql.expression.comparison.SimpleComparisonOperator
- 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 - com.exasol.sql.expression.comparison.LikeComparison.LikeComparisonOperator
- LikeComparison - Class in com.exasol.sql.expression.comparison
-
This class represents a LIKE comparison.
- LikeComparison.Builder - Class in com.exasol.sql.expression.comparison
-
A builder for
LikeComparison. - LikeComparison.LikeComparisonOperator - Enum in com.exasol.sql.expression.comparison
- 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.ExasolAnalyticFunction
- Literal - Interface in com.exasol.sql.expression.literal
-
Interface for classes that represent literal values.
- LiteralVisitor - Interface in com.exasol.sql.expression.literal
-
Visitor for
Literal. - LN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
- 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.literal
-
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 MATCHEDpart of an SQLMERGE 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
- 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
MERGEcommand. - 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
MERGEstrategy 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
MERGEstatement. - MergeInsertClause - Class in com.exasol.sql.dml.merge
-
Represents the
MERGEstrategy 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
Mergestatement. - mergeInto(String, String) - Method in class com.exasol.sql.StatementFactory
-
Create a
Mergestatement. - 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
InsertRendererturns SQL statement structures in to SQL strings. - MergeRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.dml.merge.rendering.MergeRenderer
-
Create a new
MergeRendererwith custom render settings. - MergeUpdateClause - Class in com.exasol.sql.dml.merge
-
Represents the
MERGEstrategy 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.comparison.LikeComparison.Builder
-
Set for NOT LIKE expression.
- not() - Method in class com.exasol.sql.expression.predicate.BetweenPredicate.Builder
-
Sets
NOT BETWEENpredicate. - not() - Method in class com.exasol.sql.expression.predicate.InPredicate.Builder
-
Sets
NOT INpredicate. - 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
Notfrom a boolean literal - Not(BooleanExpression) - Constructor for class com.exasol.sql.expression.Not
-
Create a new instance of a unary
Notfrom a boolean expression - Not(String) - Constructor for class com.exasol.sql.expression.Not
-
Create a new instance of a unary
Notfrom a string literal - NOT_BETWEEN - com.exasol.sql.expression.predicate.BetweenPredicate.BetweenPredicateOperator
- NOT_EQUAL - com.exasol.sql.expression.comparison.SimpleComparisonOperator
- NOT_IN - com.exasol.sql.expression.predicate.InPredicate.InPredicateOperator
- NOT_LIKE - com.exasol.sql.expression.comparison.LikeComparison.LikeComparisonOperator
- notBetween(ValueExpression, ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
- notIn(ValueExpression, Select) - Static method in class com.exasol.sql.expression.BooleanTerm
- notIn(ValueExpression, ValueExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm
- 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 MATCHEDpart of an SQLMERGE 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.literal.NullLiteral
- NullLiteral - Class in com.exasol.sql.expression.literal
-
This class represents a null literal.
- nullsFirst() - Method in class com.exasol.sql.dql.select.OrderByClause
-
Add NULLS FIRST option to the
OrderByClause - nullsLast() - Method in class com.exasol.sql.dql.select.OrderByClause
-
Add NULLS LAST option to the
OrderByClause - NUMTODSINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
- 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.literal.BooleanLiteral
- of(char) - Static method in class com.exasol.sql.expression.literal.StringLiteral
-
Create a new
StringLiteralfrom a character. - of(double) - Static method in class com.exasol.sql.expression.literal.DoubleLiteral
-
Create a new
DoubleLiteralfrom a double. - of(float) - Static method in class com.exasol.sql.expression.literal.FloatLiteral
-
Create a new
FloatLiteralfrom a float. - of(int) - Static method in class com.exasol.sql.expression.literal.IntegerLiteral
-
Create a new
IntegerLiteralfrom an integer. - of(long) - Static method in class com.exasol.sql.expression.literal.LongLiteral
-
Create a new
LongLiteralfrom a long. - of(BinaryArithmeticExpression.BinaryArithmeticOperator, ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BinaryArithmeticExpression
-
Create a new
BinaryArithmeticExpressioninstance. - of(FunctionName) - Static method in class com.exasol.sql.expression.function.exasol.ExasolFunction
-
Create a new
ExasolFunctioninstance. - of(FunctionName, ValueExpression...) - Static method in class com.exasol.sql.expression.function.exasol.ExasolFunction
-
Create a new
ExasolFunctioninstance. - of(ValueExpression, DataType) - Static method in class com.exasol.sql.expression.function.exasol.CastExasolFunction
-
Create a new
CastExasolFunctioninstance. - of(String) - Static method in class com.exasol.sql.expression.ColumnReference
-
Create a new
ColumnReferencefrom a column name. - of(String) - Static method in class com.exasol.sql.expression.literal.BooleanLiteral
-
Create a new
BooleanLiteralinstance from a String. - of(String) - Static method in class com.exasol.sql.expression.literal.StringLiteral
-
Create a new
StringLiteralfrom a string. - of(String, ColumnsDefinition, ValueExpression...) - Static method in class com.exasol.sql.expression.function.exasol.ExasolUdf
-
Create a new
ExasolUdfinstance. - of(String, ValueExpression...) - Static method in class com.exasol.sql.expression.function.exasol.ExasolUdf
-
Create a new
ExasolUdfinstance. - of(BigDecimal) - Static method in class com.exasol.sql.expression.literal.BigDecimalLiteral
-
Create a new
BigDecimalLiteralfrom a BigDecimal. - ofMillis(long) - Static method in class com.exasol.datatype.value.IntervalDayToSecond
-
Create an
IntervalDayToSecondfrom a number of milliseconds - ofMonths(long) - Static method in class com.exasol.datatype.value.IntervalYearToMonth
-
Create an
IntervalDayToSecondfrom a number of months - ofSymbol(String) - Static method in enum com.exasol.sql.expression.comparison.SimpleComparisonOperator
-
Get the
SimpleComparisonOperatorfor 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
ONclause of an SQLMERGEstatement. - OnClause(Fragment, BooleanExpression) - Constructor for class com.exasol.sql.dml.merge.OnClause
-
Create a new instance of a
OnClause. - operands(ValueExpression...) - Method in class com.exasol.sql.expression.predicate.InPredicate.Builder
-
Adds the operands.
- operation(String, BooleanExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Create a logical operation from an operator name and a list of operands
- operator - Variable in class com.exasol.sql.expression.comparison.AbstractComparison
- 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
Orinstance - Or(BooleanExpression...) - Constructor for class com.exasol.sql.expression.Or
-
Create a new
Orinstance - 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 BYclause of an SQL statement. - OrderByClause(SqlStatement, ColumnReference...) - Constructor for class com.exasol.sql.dql.select.OrderByClause
-
Create a new instance of a
OrderByClause.
P
- parameters - Variable in class com.exasol.sql.expression.function.AbstractFunction
- parse(String) - Static method in class com.exasol.datatype.value.IntervalDayToSecond
-
Parse an
IntervalDayToSecondfrom a string - parse(String) - Static method in class com.exasol.datatype.value.IntervalYearToMonth
-
Parse an
IntervalDayToSecondfrom 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
- Predicate - Interface in com.exasol.sql.expression.predicate
-
Interface for classes that implement predicate expressions.
- PredicateOperator - Interface in com.exasol.sql.expression.predicate
-
An interface for the predicate operators.
- PredicateVisitor - Interface in com.exasol.sql.expression.predicate
-
An interface for
Predicatevisitor.
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
RESTRICTclause to aDROP SCHEMAstatement. - 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
Restrictclass - REVERSE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
- right(ValueExpression) - Method in class com.exasol.sql.expression.comparison.LikeComparison.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
Jointhat belongs to aFROMclause. - rightOperand - Variable in class com.exasol.sql.expression.comparison.AbstractComparison
- rightOuterJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause
-
Create a new right outer
Jointhat belongs to aFROMclause. - 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
Schemain 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
Selectstatement. - 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
Selectstatement. - Select() - Constructor for class com.exasol.sql.dql.select.Select
-
Create a new instance of a
Select. - SelectFragment - Interface in com.exasol.sql.dql.select
-
This is the common interface for all fragments of a SELECT statement.
- selectQuery(Select) - Method in class com.exasol.sql.expression.predicate.InPredicate.Builder
-
Adds the sub select query.
- SelectRenderer - Class in com.exasol.sql.dql.select.rendering
-
The
SelectRendererturns SQL statement structures in to SQL strings. - SelectRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.dql.select.rendering.SelectRenderer
-
Create a new
SelectRendererwith 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(Fragment) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
- 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
- SimpleComparison - Class in com.exasol.sql.expression.comparison
-
This class implements all simple comparison operators.
- SimpleComparison(SimpleComparisonOperator, ValueExpression, ValueExpression) - Constructor for class com.exasol.sql.expression.comparison.SimpleComparison
-
Create a new instance of SimpleComparison.
- SimpleComparisonOperator - Enum in com.exasol.sql.expression.comparison
-
This enum represents the different types of
SimpleComparisons that can be used inExpressions. - 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
- start(ValueExpression) - Method in class com.exasol.sql.expression.predicate.BetweenPredicate.Builder
-
Adds the start expression of predicate.
- startParenthesis() - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
- startParenthesis() - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
- StatementFactory - Class in com.exasol.sql
-
The
StatementFactoryimplements 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.literal
-
This class represents string literals (or character literals in SQL terms).
- StringRendererConfig - Class in com.exasol.sql.rendering
-
This class implements a parameter object containing the configuration options for the
StatementFactory. - StringRendererConfig.Builder - Class in com.exasol.sql.rendering
-
Builder for
StringRendererConfig - SUBSTR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
- 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
Tablein an SQL Statement. - Table(Fragment, String) - Constructor for class com.exasol.sql.Table
-
Create a new
Tablewith a name and an alias. - Table(Fragment, String, String) - Constructor for class com.exasol.sql.Table
-
Create a new
Tablewith 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.literal.BooleanLiteral
-
Get boolean value this literal represents.
- toBooleanExpressions(boolean[]) - Static method in class com.exasol.sql.expression.literal.BooleanLiteral
-
Map an array of booleans to and array of BooleanExpressions
- toMillis() - Method in class com.exasol.datatype.value.IntervalDayToSecond
-
Get the interval as the total number of milliseconds between two points in time.
- toMonths() - Method in class com.exasol.datatype.value.IntervalYearToMonth
-
Get the interval as the total number of months between two points in time
- toString() - Method in class com.exasol.datatype.value.IntervalDayToSecond
- toString() - Method in class com.exasol.datatype.value.IntervalYearToMonth
- toString() - Method in enum com.exasol.sql.dql.select.JoinType
- toString() - Method in class com.exasol.sql.expression.ColumnReference
- toString() - Method in interface com.exasol.sql.expression.comparison.ComparisonOperator
-
Returns the operator symbol that represents the comparison.
- toString() - Method in enum com.exasol.sql.expression.comparison.LikeComparison.LikeComparisonOperator
- toString() - Method in enum com.exasol.sql.expression.comparison.SimpleComparisonOperator
- toString() - Method in class com.exasol.sql.expression.literal.BigDecimalLiteral
- toString() - Method in class com.exasol.sql.expression.literal.BooleanLiteral
- toString() - Method in class com.exasol.sql.expression.literal.DoubleLiteral
- toString() - Method in class com.exasol.sql.expression.literal.FloatLiteral
- toString() - Method in class com.exasol.sql.expression.literal.IntegerLiteral
- toString() - Method in class com.exasol.sql.expression.literal.LongLiteral
- toString() - Method in class com.exasol.sql.expression.literal.StringLiteral
- toString() - Method in enum com.exasol.sql.expression.predicate.BetweenPredicate.BetweenPredicateOperator
- toString() - Method in enum com.exasol.sql.expression.predicate.ExistsPredicate.ExistsPredicateOperator
- toString() - Method in enum com.exasol.sql.expression.predicate.InPredicate.InPredicateOperator
- toString() - Method in enum com.exasol.sql.expression.predicate.IsNullPredicate.IsNullPredicateOperator
- toString() - Method in interface com.exasol.sql.expression.predicate.PredicateOperator
-
Returns the predicate operator symbol.
- toString() - Method in class com.exasol.sql.UnnamedPlaceholder
- TRANSLATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
- 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
USINGclause of an SQLMERGEstatement. - 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
-
Create a new instance of
ValueExpressionRenderer. - ValueExpressionVisitor - Interface in com.exasol.sql.expression
-
Visitor interface for a
BooleanTerm. - valueOf(String) - Static method in enum com.exasol.sql.dql.select.JoinType
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.comparison.LikeComparison.LikeComparisonOperator
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.comparison.SimpleComparisonOperator
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAnalyticFunction
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.predicate.BetweenPredicate.BetweenPredicateOperator
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.predicate.ExistsPredicate.ExistsPredicateOperator
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.predicate.InPredicate.InPredicateOperator
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.predicate.IsNullPredicate.IsNullPredicateOperator
-
Returns the enum constant of this type with the specified name.
- valuePlaceholder() - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Add an unnamed value placeholder to the value list (this is useful for prepared statements).
- valuePlaceholders(int) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Add a given number unnamed value placeholder to the value list (this is useful for prepared statements).
- values() - Static method in enum com.exasol.sql.dql.select.JoinType
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.comparison.LikeComparison.LikeComparisonOperator
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.comparison.SimpleComparisonOperator
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.function.exasol.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.ExasolAnalyticFunction
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.predicate.BetweenPredicate.BetweenPredicateOperator
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.predicate.ExistsPredicate.ExistsPredicateOperator
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.predicate.InPredicate.InPredicateOperator
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.predicate.IsNullPredicate.IsNullPredicateOperator
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values(int...) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Insert a list of integer values.
- values(ValueExpression...) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Insert a list of value expressions.
- values(String...) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Insert a list of string values.
- valueTable(ValueTable) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Insert a value table.
- valueTable(ValueTable) - Method in class com.exasol.sql.dql.select.FromClause
-
Create a
FromClausefrom 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
FromClausefrom 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
Varchardata 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
MERGEstatements. - 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
MERGEstatement. - 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
MERGEstatement. - 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
WHEREclause. - 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.ValueExpressionRenderer
- 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(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.ValueExpressionRenderer
- visit(LikeComparison) - Method in interface com.exasol.sql.expression.comparison.ComparisonVisitor
- visit(LikeComparison) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(SimpleComparison) - Method in interface com.exasol.sql.expression.comparison.ComparisonVisitor
- visit(SimpleComparison) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(DefaultValue) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(DefaultValue) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
- visit(CastExasolFunction) - Method in interface com.exasol.sql.expression.function.FunctionVisitor
- visit(CastExasolFunction) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(ExasolFunction) - Method in interface com.exasol.sql.expression.function.FunctionVisitor
- visit(ExasolFunction) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
-
Function visitor
- visit(ExasolUdf) - Method in interface com.exasol.sql.expression.function.FunctionVisitor
- visit(ExasolUdf) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(Function) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(Function) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
- visit(BigDecimalLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
- visit(BigDecimalLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(BooleanLiteral) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
- visit(BooleanLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
- visit(BooleanLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(DoubleLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
- visit(DoubleLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(FloatLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
- visit(FloatLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(IntegerLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
- visit(IntegerLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(Literal) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(Literal) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
- visit(LongLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
- visit(LongLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(NullLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
- visit(NullLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(StringLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
- visit(StringLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
-
Literal visitor
- visit(Not) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
- visit(Not) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(Or) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
- visit(Or) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(BetweenPredicate) - Method in interface com.exasol.sql.expression.predicate.PredicateVisitor
- visit(BetweenPredicate) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(ExistsPredicate) - Method in interface com.exasol.sql.expression.predicate.PredicateVisitor
- visit(ExistsPredicate) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(InPredicate) - Method in interface com.exasol.sql.expression.predicate.PredicateVisitor
- visit(InPredicate) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(IsNullPredicate) - Method in interface com.exasol.sql.expression.predicate.PredicateVisitor
- visit(IsNullPredicate) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(Predicate) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
- visit(Predicate) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(ValueExpression...) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- 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
- visit(List<ValueExpression>) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
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
WHEREclause insertion definition. - where(BooleanExpression) - Method in class com.exasol.sql.dml.merge.MergeMethodDefinition
-
Add a
WHEREclauseMERGEdefinition. - 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
All Classes All Packages