A B C D E F G H I J K L M N O P Q R S T U V W Y Z
All Classes All Packages
All Classes All Packages
All Classes All Packages
A
- ABS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Absolute value of a number
- AbstractBooleanExpression - Class in com.exasol.sql.expression
-
Abstract base class for all types of BooleanExpressions.
- AbstractBooleanExpression() - Constructor for class com.exasol.sql.expression.AbstractBooleanExpression
- AbstractComparison - Class in com.exasol.sql.expression.comparison
-
Abstract basis for comparisons.
- AbstractComparison(ComparisonOperator, ValueExpression, ValueExpression) - Constructor for class com.exasol.sql.expression.comparison.AbstractComparison
-
Create a new instance of
AbstractComparison
. - AbstractExpressionRenderer - Class in com.exasol.sql.expression.rendering
-
Common base class for expression renderers.
- AbstractExpressionRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
-
Create a new instance of a
AbstractExpressionRenderer
. - AbstractFragment - Class in com.exasol.sql
-
Common base class for SQL statement fragments
- AbstractFragment(Fragment) - Constructor for class com.exasol.sql.AbstractFragment
-
Create an instance of an SQL fragment
- AbstractFragmentRenderer - Class in com.exasol.sql.rendering
-
Abstract base class for SQL fragment renderers.
- AbstractFragmentRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.rendering.AbstractFragmentRenderer
-
Create a new instance of an
AbstractFragmentRenderer
-based class. - AbstractFunction - Class in com.exasol.sql.expression.function
-
This is a base class for functions.
- AbstractFunction(String, List<ValueExpression>) - Constructor for class com.exasol.sql.expression.function.AbstractFunction
-
Create a new instance using
AbstractFunction
. - AbstractInsertValueTable<T extends AbstractInsertValueTable<T>> - Class in com.exasol.sql.dml.insert
-
Abstract base class for SQL fragments that contain a insert value table (for example
INSERT
,MERGE
). - AbstractInsertValueTable(Fragment) - Constructor for class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Create the abstract base for a fragment containing a value table.
- AbstractInterval - Class in com.exasol.datatype.value
-
Abstract base class for interval types.
- AbstractInterval(long) - Constructor for class com.exasol.datatype.value.AbstractInterval
-
Create an interval from a long integer value.
- AbstractInterval(long, boolean) - Constructor for class com.exasol.datatype.value.AbstractInterval
-
Create an interval from an absolute value and a sign.
- AbstractLiteral - Class in com.exasol.sql.expression.literal
-
Abstract basis for
Literal
s. - AbstractLiteral() - Constructor for class com.exasol.sql.expression.literal.AbstractLiteral
- AbstractPredicate - Class in com.exasol.sql.expression.predicate
-
An abstract basis for predicate classes.
- AbstractPredicate(PredicateOperator) - Constructor for class com.exasol.sql.expression.predicate.AbstractPredicate
-
Creates a new instance of
AbstractPredicate
. - AbstractStringDataType<T extends AbstractStringDataType<T>> - Class in com.exasol.datatype.type
-
Implements common logic for String data types.
- AbstractStringDataType(int, int, String) - Constructor for class com.exasol.datatype.type.AbstractStringDataType
-
Create a new common base for a string type.
- accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Boolean
- accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Char
- accept(ColumnDefinitionVisitor) - Method in interface com.exasol.datatype.type.DataType
- accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Date
- accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Decimal
- accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.DoublePrecision
- accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.IntervalDayToSecond
- accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.IntervalYearToMonth
- accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Timestamp
- accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.TimestampWithLocalTimezone
- accept(ColumnDefinitionVisitor) - Method in class com.exasol.datatype.type.Varchar
- accept(ColumnDefinitionVisitor) - Method in class com.exasol.sql.Column
-
Accept a
ColumnDefinitionVisitor
. - accept(ColumnDefinitionVisitor) - Method in class com.exasol.sql.ColumnsDefinition
-
Accept a
ColumnDefinitionVisitor
. - accept(CreateSchemaVisitor) - Method in class com.exasol.sql.ddl.create.CreateSchema
- accept(CreateSchemaVisitor) - Method in interface com.exasol.sql.ddl.create.CreateSchemaFragment
-
Accept a visitor (e.g.
- accept(CreateSchemaVisitor) - Method in class com.exasol.sql.ddl.Schema
-
Accept a
CreateSchemaVisitor
. - accept(CreateTableVisitor) - Method in class com.exasol.sql.ddl.create.CreateTable
- accept(CreateTableVisitor) - Method in interface com.exasol.sql.ddl.create.CreateTableFragment
-
Accept a visitor (e.g.
- accept(CreateTableVisitor) - Method in class com.exasol.sql.Table
-
Accept a
CreateTableVisitor
. - accept(DropSchemaVisitor) - Method in class com.exasol.sql.ddl.drop.Cascade
- accept(DropSchemaVisitor) - Method in class com.exasol.sql.ddl.drop.DropSchema
- accept(DropSchemaVisitor) - Method in interface com.exasol.sql.ddl.drop.DropSchemaFragment
-
Accept a visitor (e.g.
- accept(DropSchemaVisitor) - Method in class com.exasol.sql.ddl.drop.Restrict
- accept(DropSchemaVisitor) - Method in class com.exasol.sql.ddl.Schema
-
Accept a
DropSchemaVisitor
. - accept(DropTableVisitor) - Method in class com.exasol.sql.ddl.drop.CascadeConstraints
- accept(DropTableVisitor) - Method in class com.exasol.sql.ddl.drop.DropTable
- accept(DropTableVisitor) - Method in interface com.exasol.sql.ddl.drop.DropTableFragment
-
Accept a visitor (e.g.
- accept(DropTableVisitor) - Method in class com.exasol.sql.Table
-
Accept a
DropTableVisitor
. - accept(InsertVisitor) - Method in class com.exasol.sql.DerivedColumn
- accept(InsertVisitor) - Method in class com.exasol.sql.dml.insert.Insert
- accept(InsertVisitor) - Method in class com.exasol.sql.dml.insert.InsertFields
- accept(InsertVisitor) - Method in interface com.exasol.sql.dml.insert.InsertFragment
-
Accept a visitor (e.g.
- accept(InsertVisitor) - Method in class com.exasol.sql.Table
-
Accept an
InsertVisitor
. - accept(MergeVisitor) - Method in class com.exasol.sql.DerivedColumn
- accept(MergeVisitor) - Method in class com.exasol.sql.dml.insert.InsertFields
- accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.MatchedClause
- accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.Merge
- accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.MergeColumnUpdate
- accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.MergeDeleteClause
- accept(MergeVisitor) - Method in interface com.exasol.sql.dml.merge.MergeFragment
-
Accept a visitor (e.g.
- accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.MergeInsertClause
- accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause
- accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.NotMatchedClause
- accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.OnClause
- accept(MergeVisitor) - Method in class com.exasol.sql.dml.merge.UsingClause
- accept(MergeVisitor) - Method in class com.exasol.sql.dql.select.WhereClause
-
Accept a visitor for
MERGE
statements - accept(MergeVisitor) - Method in class com.exasol.sql.Table
-
Accept a
MergeVisitor
. - accept(SelectVisitor) - Method in class com.exasol.sql.DerivedColumn
- accept(SelectVisitor) - Method in class com.exasol.sql.dql.select.FromClause
- accept(SelectVisitor) - Method in class com.exasol.sql.dql.select.GroupByClause
- accept(SelectVisitor) - Method in class com.exasol.sql.dql.select.Join
- accept(SelectVisitor) - Method in class com.exasol.sql.dql.select.LimitClause
- accept(SelectVisitor) - Method in class com.exasol.sql.dql.select.OrderByClause
- accept(SelectVisitor) - Method in class com.exasol.sql.dql.select.Select
- accept(SelectVisitor) - Method in interface com.exasol.sql.dql.select.SelectFragment
-
Accept a visitor (e.g.
- accept(SelectVisitor) - Method in class com.exasol.sql.dql.select.WhereClause
-
Accept a visitor for
SELECT
statements - accept(SelectVisitor) - Method in class com.exasol.sql.Table
-
Accept a
SelectVisitor
. - accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.And
- accept(BooleanExpressionVisitor) - Method in interface com.exasol.sql.expression.BooleanExpression
-
Accept a visitor
- accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.comparison.AbstractComparison
- accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.literal.BooleanLiteral
- accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Not
- accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.Or
- accept(BooleanExpressionVisitor) - Method in class com.exasol.sql.expression.predicate.AbstractPredicate
- accept(ComparisonVisitor) - Method in interface com.exasol.sql.expression.comparison.Comparison
-
Accept
ComparisonVisitor
. - accept(ComparisonVisitor) - Method in class com.exasol.sql.expression.comparison.LikeComparison
- accept(ComparisonVisitor) - Method in class com.exasol.sql.expression.comparison.SimpleComparison
- accept(FunctionVisitor) - Method in class com.exasol.sql.expression.function.exasol.AnalyticFunction
- accept(FunctionVisitor) - Method in class com.exasol.sql.expression.function.exasol.CastExasolFunction
- accept(FunctionVisitor) - Method in class com.exasol.sql.expression.function.exasol.ExasolFunction
- accept(FunctionVisitor) - Method in class com.exasol.sql.expression.function.exasol.ExasolUdf
- accept(FunctionVisitor) - Method in interface com.exasol.sql.expression.function.Function
-
Accept
FunctionVisitor
. - accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.BigDecimalLiteral
- accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.BooleanLiteral
- accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.DoubleLiteral
- accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.FloatLiteral
- accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.IntegerLiteral
- accept(LiteralVisitor) - Method in interface com.exasol.sql.expression.literal.Literal
-
Accept a
LiteralVisitor
. - accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.LongLiteral
- accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.NullLiteral
- accept(LiteralVisitor) - Method in class com.exasol.sql.expression.literal.StringLiteral
- accept(PredicateVisitor) - Method in class com.exasol.sql.expression.predicate.BetweenPredicate
- accept(PredicateVisitor) - Method in class com.exasol.sql.expression.predicate.ExistsPredicate
- accept(PredicateVisitor) - Method in class com.exasol.sql.expression.predicate.InPredicate
- accept(PredicateVisitor) - Method in class com.exasol.sql.expression.predicate.IsNullPredicate
- accept(PredicateVisitor) - Method in interface com.exasol.sql.expression.predicate.Predicate
-
Accepts
PredicateVisitor
. - accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.AbstractBooleanExpression
- accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.BinaryArithmeticExpression
- accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.ColumnReference
- accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.DefaultValue
- accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.function.AbstractFunction
- accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.literal.AbstractLiteral
- accept(ValueExpressionVisitor) - Method in class com.exasol.sql.expression.predicate.AbstractPredicate
- accept(ValueExpressionVisitor) - Method in interface com.exasol.sql.expression.ValueExpression
-
Accept a visitor
- accept(ValueExpressionVisitor) - Method in class com.exasol.sql.UnnamedPlaceholder
- accept(ValueTableVisitor) - Method in class com.exasol.sql.ValueTable
-
Accept a visitor.
- accept(ValueTableVisitor) - Method in class com.exasol.sql.ValueTableRow
-
Accept a visitor.
- ACOS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Arccosine
- add(boolean...) - Method in class com.exasol.sql.ValueTable
-
Add boolean values to the last row of the value table.
- add(boolean...) - Method in class com.exasol.sql.ValueTableRow.Builder
-
Add one or more boolean literals to the row.
- add(char...) - Method in class com.exasol.sql.ValueTable
-
Add character values to the last row of the value table.
- add(char...) - Method in class com.exasol.sql.ValueTableRow.Builder
-
Add one or more char literals to the row.
- add(double...) - Method in class com.exasol.sql.ValueTable
-
Add double values to the last row of the value table.
- add(double...) - Method in class com.exasol.sql.ValueTableRow.Builder
-
Add one or more double literals to the row.
- add(float...) - Method in class com.exasol.sql.ValueTable
-
Add float values to the last row of the value table.
- add(float...) - Method in class com.exasol.sql.ValueTableRow.Builder
-
Add one or more float literals to the row.
- add(int...) - Method in class com.exasol.sql.ValueTable
-
Add integer values to the last row of the value table.
- add(int...) - Method in class com.exasol.sql.ValueTableRow.Builder
-
Add one or more integer literals to the row.
- add(long...) - Method in class com.exasol.sql.ValueTable
-
Add long values to the last row of the value table.
- add(long...) - Method in class com.exasol.sql.ValueTableRow.Builder
-
Add one or more long literals to the row.
- add(ValueExpression...) - Method in class com.exasol.sql.ValueTable
-
Add a list of value expressions to the last row of the value table.
- add(String...) - Method in class com.exasol.sql.ValueTable
-
Add string values to the last row of the value table.
- add(String...) - Method in class com.exasol.sql.ValueTableRow.Builder
-
Add one or more string literals to the row.
- add(String, DataType) - Method in class com.exasol.sql.ColumnsDefinition
-
Add a new column to the
ColumnsDefinition
- add(List<ValueExpression>) - Method in class com.exasol.sql.ValueTableRow.Builder
-
Add a list of expressions to the
ValueTableRow
. - ADD - com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator
-
Addition
- ADD_DAYS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Add days
- ADD_HOURS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Add hours
- ADD_MINUTES - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Add minutes
- ADD_MONTHS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Add months
- ADD_SECONDS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Add seconds
- ADD_WEEKS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Add weeks
- ADD_YEARS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Add years
- addPlaceholder() - Method in class com.exasol.sql.ValueTable
-
Add an unnamed placeholder to the value table.
- addPlaceholder() - Method in class com.exasol.sql.ValueTableRow.Builder
-
Add an
UnnamedPlaceholder
to the row. - alias(String, String...) - Method in class com.exasol.sql.ValueTable
-
Set alias for the value table.
- all() - Method in class com.exasol.sql.dql.select.Select
-
Add a wildcard field for all involved fields.
- ALL - com.exasol.sql.expression.function.exasol.AnalyticFunction.Keyword
-
Function over all values (including duplicates)
- AnalyticFunction - Class in com.exasol.sql.expression.function.exasol
-
This class represents an analytic function in the Exasol database that supports keywords
DISTINCT
andALL
and the over clause. - AnalyticFunction.Keyword - Enum in com.exasol.sql.expression.function.exasol
-
Analytic function keywords
- and(boolean...) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Logical
AND
combination of boolean values. - and(boolean, BooleanExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Logical
AND
combination of boolean value and expression. - and(BooleanExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Logical
AND
combination of boolean expressions. - and(BooleanExpression, boolean) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Logical
AND
combination of boolean expression and value. - And - Class in com.exasol.sql.expression
-
This class represents a logical AND predicate.
- And(boolean...) - Constructor for class com.exasol.sql.expression.And
-
Create a new
And
instance - And(BooleanExpression...) - Constructor for class com.exasol.sql.expression.And
-
Create a new
And
instance - ANY - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- ANY - com.exasol.sql.expression.function.exasol.ExasolAnalyticFunction
-
Deprecated.Any expression true
- append(int) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
-
Append on integer number.
- append(String) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
-
Append a string.
- append(String) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
-
Append a string.
- appendAutoQuoted(String) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
-
Append a SQL identifier with the right form of quotes.
- appendAutoQuoted(String) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
-
Append an auto-quoted SQL identifier.
- appendBooleanLiteral(BooleanLiteral) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
-
Append a boolean literal (i.e.
- appendCommaWhenNeeded(Fragment) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
-
Append a comma where necessary.
- appendKeyword(String) - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
-
Append a SQL keyword (like
SELECT
). - appendKeyWord(String) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
-
Append an unquoted SQL keyword.
- appendListOfValueExpressions(List<? extends ValueExpression>) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
-
Append a list of value expressions.
- appendRenderedValueExpression(ValueExpression) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
-
Append a value expression that has already been rendered.
- appendRow(ValueTableRow) - Method in class com.exasol.sql.ValueTable
-
Append a
ValueTableRow
to 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
-
Append a white space.
- appendValueTableRow(ValueTableRow) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
-
Append a row of a value table (
SELECT ... FROM VALUES
). - APPROXIMATE_COUNT_DISTINCT - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Faster, but only approximate count of distinct values
- APPROXIMATE_COUNT_DISTINCT - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- arithmeticExpression(BinaryArithmeticExpression) - Method in class com.exasol.sql.dql.select.Select
-
Deprecated.please use a
Select.valueExpression(ValueExpression)
valueExpression} method instead. - arithmeticExpression(BinaryArithmeticExpression, String) - Method in class com.exasol.sql.dql.select.Select
-
Deprecated.please use a
Select.valueExpression(ValueExpression, String)
valueExpression} method instead. - asc() - Method in class com.exasol.sql.dql.select.OrderByClause
-
Add ASC option to the
OrderByClause
- ASCII - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
ASCII code of character
- ASIN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Arcsine
- ATAN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Arctangens
- ATAN2 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Arctanges of two numbers (instead of fration)
- AVG - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Average
- AVG - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
B
- between(ValueExpression, ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Check if value is between two other values.
- BETWEEN - com.exasol.sql.expression.predicate.BetweenPredicate.BetweenPredicateOperator
-
Between boundaries
- BetweenPredicate - Class in com.exasol.sql.expression.predicate
-
A class that represents a
[NOT] BETWEEN
predicate. - BetweenPredicate.BetweenPredicateOperator - Enum in com.exasol.sql.expression.predicate
-
A class that represents
BetweenPredicate
operator. - BetweenPredicate.Builder - Class in com.exasol.sql.expression.predicate
-
A builder for
BetweenPredicate
. - BigDecimalLiteral - Class in com.exasol.sql.expression.literal
-
This class represents BigDecimal literals.
- BinaryArithmeticExpression - Class in com.exasol.sql.expression
-
This class represents a binary arithmetic expression.
- BinaryArithmeticExpression.BinaryArithmeticOperator - Enum in com.exasol.sql.expression
-
This enum represents arithmetic operators in an SQL statement.
- BIT_AND - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Bitwise and
- BIT_CHECK - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Check bit set
- BIT_LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
String size in bits
- BIT_LROTATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Rotate left
- BIT_LSHIFT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Shift left
- BIT_NOT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Bitwise not
- BIT_OR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Bitwise or
- BIT_RROTATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Rotate right
- BIT_RSHIFT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Shift right
- BIT_SET - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Set bit
- BIT_TO_NUM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Bitmask to number
- BIT_XOR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Bitwise exclusive or
- Boolean - Class in com.exasol.datatype.type
-
This class implements the SQL data type boolean
- Boolean() - Constructor for class com.exasol.datatype.type.Boolean
- booleanColumn(String) - Method in class com.exasol.sql.ColumnsDefinition.Builder
-
Add boolean column
- booleanColumn(String) - Method in class com.exasol.sql.ddl.create.CreateTable
-
Add boolean column
- BooleanExpression - Interface in com.exasol.sql.expression
-
Common interface for all types of boolean expressions
- BooleanExpressionVisitor - Interface in com.exasol.sql.expression
-
Visitor interface for a
BooleanTerm
- booleanLiteral(boolean) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a boolean literal.
- BooleanLiteral - Class in com.exasol.sql.expression.literal
-
This class represents boolean literals (read "true" and "false")
- BooleanTerm - Class in com.exasol.sql.expression
-
This class represents boolean terms like
AND
orNOT
. - build() - Method in class com.exasol.sql.ColumnsDefinition.Builder
-
Build a new
ColumnsDefinition
. - build() - Method in class com.exasol.sql.expression.comparison.LikeComparison.Builder
-
Create a new instance of
LikeComparison
. - build() - Method in class com.exasol.sql.expression.predicate.BetweenPredicate.Builder
-
Creates a new instance of
[NOT] BETWEEN
predicate class. - build() - Method in class com.exasol.sql.expression.predicate.InPredicate.Builder
-
Creates a new instance of
[NOT] IN
predicate class. - build() - Method in class com.exasol.sql.rendering.StringRendererConfig.Builder
-
Create a new instance of a
StringRendererConfig
- build() - Method in class com.exasol.sql.ValueTableRow.Builder
-
Build a new
ValueTableRow
. - builder - Variable in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
-
Builder that holds the fragments of the rendered string
- builder() - Static method in class com.exasol.sql.ColumnsDefinition
-
Create a new builder for
ColumnsDefinition
. - builder() - Static method in class com.exasol.sql.expression.comparison.LikeComparison
-
Create a new builder for
LikeComparison
. - builder() - Static method in class com.exasol.sql.expression.predicate.BetweenPredicate
-
Creates a new builder for
BetweenPredicate
. - builder() - Static method in class com.exasol.sql.expression.predicate.InPredicate
-
Creates a new builder for
InPredicate
. - builder() - Static method in class com.exasol.sql.rendering.StringRendererConfig
-
Get a builder for
StringRendererConfig
- builder(Fragment) - Static method in class com.exasol.sql.ValueTableRow
-
Get a
ValueTableRow.Builder
for 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
-
Create a new builder for a value table row.
C
- cascade() - Method in class com.exasol.sql.ddl.drop.DropSchema
-
Add
CASCADE
clause to aDROP SCHEMA
statement. - Cascade - Class in com.exasol.sql.ddl.drop
-
This class represents CASCADE clause in DROP SCHEMA SQL statement
- Cascade(Fragment) - Constructor for class com.exasol.sql.ddl.drop.Cascade
-
Create an instance of
Cascade
class - cascadeConstraints() - Method in class com.exasol.sql.ddl.drop.DropTable
-
Add
CASCADE CONSTRAINTS
clause into aDROP TABLE
statement. - CascadeConstraints - Class in com.exasol.sql.ddl.drop
-
This class represents CASCADE CONSTRAINTS clause in the DROP TABLE SQL statement
- CascadeConstraints(Fragment) - Constructor for class com.exasol.sql.ddl.drop.CascadeConstraints
-
Create an instance of
CascadeConstraints
class - CastExasolFunction - Class in com.exasol.sql.expression.function.exasol
-
This class represents the Exasol CAST function.
- CEIL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Ceiling
- Char - Class in com.exasol.datatype.type
-
This class implements the SQL data type char
- Char(int) - Constructor for class com.exasol.datatype.type.Char
-
Create a new instance of an
Char
data type - CHAR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Character for number
- CHARACTER_LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
String size in characters
- charColumn(String, int) - Method in class com.exasol.sql.ColumnsDefinition.Builder
-
Add char column.
- charColumn(String, int) - Method in class com.exasol.sql.ddl.create.CreateTable
-
Add char column.
- COALESCE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
First non-null value
- COLOGNE_PHONETIC - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Phonetic representation of a string
- column(String) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a reference to a table column.
- column(String, String) - Static method in class com.exasol.sql.expression.ColumnReference
-
Create a new
ColumnReference
from a column name and a table name. - column(String, String) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a reference to a column in a specific table.
- Column - Class in com.exasol.sql
-
This class represents a column in an SQL statement
- Column(Fragment, String, DataType) - Constructor for class com.exasol.sql.Column
-
Create a new instance of a
Column
- ColumnDefinitionVisitor - Interface in com.exasol.sql
-
Visit the definition of a column.
- ColumnReference - Class in com.exasol.sql.expression
-
This class represents column reference.
- ColumnsDefinition - Class in com.exasol.sql
-
This class represents a list of column definitions in an SQL statement.
- ColumnsDefinition(SqlStatement) - Constructor for class com.exasol.sql.ColumnsDefinition
-
Create an new instance of
ColumnsDefinition
. - ColumnsDefinition(List<Column>) - Constructor for class com.exasol.sql.ColumnsDefinition
-
Create an new instance of
ColumnsDefinition
. - ColumnsDefinition.Builder - Class in com.exasol.sql
-
A builder for
ColumnsDefinition
. - ColumnsDefinitionRenderer - Class in com.exasol.sql.rendering
-
Renderer for columns definition.
- ColumnsDefinitionRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.rendering.ColumnsDefinitionRenderer
-
Create a new instance of an
AbstractFragmentRenderer
-based class. - com.exasol.datatype.type - package com.exasol.datatype.type
- com.exasol.datatype.value - package com.exasol.datatype.value
- com.exasol.sql - package com.exasol.sql
- com.exasol.sql.ddl - package com.exasol.sql.ddl
- com.exasol.sql.ddl.create - package com.exasol.sql.ddl.create
- com.exasol.sql.ddl.create.rendering - package com.exasol.sql.ddl.create.rendering
- com.exasol.sql.ddl.drop - package com.exasol.sql.ddl.drop
- com.exasol.sql.ddl.drop.rendering - package com.exasol.sql.ddl.drop.rendering
- com.exasol.sql.dml.insert - package com.exasol.sql.dml.insert
- com.exasol.sql.dml.insert.rendering - package com.exasol.sql.dml.insert.rendering
- com.exasol.sql.dml.merge - package com.exasol.sql.dml.merge
- com.exasol.sql.dml.merge.rendering - package com.exasol.sql.dml.merge.rendering
- com.exasol.sql.dql.select - package com.exasol.sql.dql.select
- com.exasol.sql.dql.select.rendering - package com.exasol.sql.dql.select.rendering
- com.exasol.sql.expression - package com.exasol.sql.expression
- com.exasol.sql.expression.comparison - package com.exasol.sql.expression.comparison
- com.exasol.sql.expression.function - package com.exasol.sql.expression.function
- com.exasol.sql.expression.function.exasol - package com.exasol.sql.expression.function.exasol
- com.exasol.sql.expression.literal - package com.exasol.sql.expression.literal
- com.exasol.sql.expression.predicate - package com.exasol.sql.expression.predicate
- com.exasol.sql.expression.rendering - package com.exasol.sql.expression.rendering
- com.exasol.sql.rendering - package com.exasol.sql.rendering
- com.exasol.util - package com.exasol.util
- compare(ValueExpression, SimpleComparisonOperator, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
General comparison with operator enum.
- compare(ValueExpression, String, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
General comparison with operator as string.
- Comparison - Interface in com.exasol.sql.expression.comparison
-
Interface for classes that implement comparisons between two columns.
- ComparisonOperator - Interface in com.exasol.sql.expression.comparison
-
Interface for comparison operators.
- ComparisonVisitor - Interface in com.exasol.sql.expression.comparison
-
Visitor for
Comparison
. - CONCAT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
String concatenation
- config - Variable in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
-
Configuration that controls string rendering options
- config - Variable in class com.exasol.sql.rendering.AbstractFragmentRenderer
-
Configuration that controls string rendering options.
- CONVERT_TZ - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Convert timezone
- CORR - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Correlation coefficient
- CORR - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- COS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Cosine
- COSH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Hyperbolic cosine
- COT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Cotangens
- COUNT - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Precise count
- COUNT - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- COVAR_POP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Population covariance
- COVAR_POP - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- COVAR_SAMP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Sample covariance
- COVAR_SAMP - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- create() - Static method in class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer
-
Create an
CreateSchemaRenderer
using the default renderer configuration - create() - Static method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer
-
Create an
CreateTableRenderer
using the default renderer configuration - create() - Static method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
-
Create an
DropSchemaRenderer
using the default renderer configuration - create() - Static method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer
-
Create an
DropTableRenderer
using the default renderer configuration - create() - Static method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
-
Create an
InsertRenderer
using the default renderer configuration - create() - Static method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
-
Create a
MergeRenderer
using the default renderer configuration. - create() - Static method in class com.exasol.sql.dql.select.rendering.SelectRenderer
-
Create an
SelectRenderer
using the default renderer configuration - create(StringRendererConfig) - Static method in class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer
-
Create an
CreateSchemaRenderer
- create(StringRendererConfig) - Static method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer
-
Create an
CreateTableRenderer
- create(StringRendererConfig) - Static method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
-
Create an
DropSchemaRenderer
- create(StringRendererConfig) - Static method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer
-
Create an
DropTableRenderer
- create(StringRendererConfig) - Static method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
-
Create an
InsertRenderer
- create(StringRendererConfig) - Static method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
-
Create a
MergeRenderer
. - create(StringRendererConfig) - Static method in class com.exasol.sql.dql.select.rendering.SelectRenderer
-
Create an
SelectRenderer
- createDefault() - Static method in class com.exasol.sql.rendering.StringRendererConfig
-
Create the default configuration.
- createInsertValueInstanceIfItDoesNotExist() - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Prepare the value table.
- createSchema(String) - Method in class com.exasol.sql.StatementFactory
-
Create a
CreateSchema
statement. - CreateSchema - Class in com.exasol.sql.ddl.create
-
This class implements an SQL
CreateSchema
statement. - CreateSchema(String) - Constructor for class com.exasol.sql.ddl.create.CreateSchema
-
Create a new instance of an
CreateSchema
statement. - CreateSchemaFragment - Interface in com.exasol.sql.ddl.create
-
This is the common interface for all fragments of a CREATE SCHEMA statement.
- CreateSchemaRenderer - Class in com.exasol.sql.ddl.create.rendering
-
The
CreateSchemaRenderer
turns SQL statement structures in to SQL strings. - CreateSchemaRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer
-
Create a new
CreateSchemaRenderer
with custom render settings. - CreateSchemaVisitor - Interface in com.exasol.sql.ddl.create
-
Visitor for
CREATE SCHEMA
statements. - createTable(String) - Method in class com.exasol.sql.StatementFactory
-
Create a
CreateTable
statement. - CreateTable - Class in com.exasol.sql.ddl.create
-
This class implements an SQL
CreateTable
statement - CreateTable(String) - Constructor for class com.exasol.sql.ddl.create.CreateTable
-
Create a new instance of an
CreateTable
statement - CreateTableFragment - Interface in com.exasol.sql.ddl.create
-
This is the common interface for all fragments of a CREATE TABLE statement.
- CreateTableRenderer - Class in com.exasol.sql.ddl.create.rendering
-
The
CreateTableRenderer
turns SQL statement structures in to SQL strings. - CreateTableRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.ddl.create.rendering.CreateTableRenderer
-
Create a new
CreateTableRenderer
with custom render settings. - CreateTableVisitor - Interface in com.exasol.sql.ddl.create
-
Visitor for
CREATE TABLE
statements. - CUME_DIST - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- CURRENT_DATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Current date
- CURRENT_ROW - com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType
-
Current row
- CURRENT_ROW - com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameExclusionType
-
Current row
- CURRENT_SCHEMA - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Current database schema
- CURRENT_SESSION - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Current session
- CURRENT_STATEMENT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Current statement
- CURRENT_TIMESTAMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Current timestamp
- CURRENT_USER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Current user
D
- DataType - Interface in com.exasol.datatype.type
-
This class represents different SQL data types
- Date - Class in com.exasol.datatype.type
-
This class implements the SQL data type date
- Date() - Constructor for class com.exasol.datatype.type.Date
- dateColumn(String) - Method in class com.exasol.sql.ColumnsDefinition.Builder
-
Add date column.
- dateColumn(String) - Method in class com.exasol.sql.ddl.create.CreateTable
-
Add date column
- DAY - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Day part of date
- DAYS_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Days between two dates
- DBTIMEZONE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Database-wide Timezone
- Decimal - Class in com.exasol.datatype.type
-
This class implements the Exasol-proprietary data type decimal
- Decimal(int, int) - Constructor for class com.exasol.datatype.type.Decimal
-
Create a new instance of an
Decimal
data type - decimalColumn(String, int, int) - Method in class com.exasol.sql.ColumnsDefinition.Builder
-
Add decimal column.
- decimalColumn(String, int, int) - Method in class com.exasol.sql.ddl.create.CreateTable
-
Add decimal column.
- DECODE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
String-based case selection
- DEFAULT - com.exasol.sql.dql.select.JoinType
-
Default join
- defaultValue() - Static method in class com.exasol.sql.expression.DefaultValue
-
Create a default value expression.
- DefaultValue - Class in com.exasol.sql.expression
-
The
DefaultValue
is an expression that tells the database to take the default value for a column (in case it is defined). - DefaultValue() - Constructor for class com.exasol.sql.expression.DefaultValue
- DEGREES - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Radians to degrees
- DENSE_RANK - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- DerivedColumn - Class in com.exasol.sql
-
This class represents a derived column in an SQL query.
- DerivedColumn(Fragment, ValueExpression) - Constructor for class com.exasol.sql.DerivedColumn
-
Create a new instance of a
DerivedColumn
. - DerivedColumn(Fragment, ValueExpression, String) - Constructor for class com.exasol.sql.DerivedColumn
-
Create a new instance of a
DerivedColumn
. - desc() - Method in class com.exasol.sql.dql.select.OrderByClause
-
Add DESC option to the
OrderByClause
- DISTINCT - com.exasol.sql.expression.function.exasol.AnalyticFunction.Keyword
-
Function over distinct values
- DIV - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Integer division
- divide(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a binary arithmetic expression with DIVIDE operator.
- DIVIDE - com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator
-
Division
- doubleLiteral(double) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a double literal.
- DoubleLiteral - Class in com.exasol.sql.expression.literal
-
This class represents double literals.
- DoublePrecision - Class in com.exasol.datatype.type
-
This class implements a double precision floating point number data type
- DoublePrecision() - Constructor for class com.exasol.datatype.type.DoublePrecision
- doublePrecisionColumn(String) - Method in class com.exasol.sql.ColumnsDefinition.Builder
-
Add double precision column.
- doublePrecisionColumn(String) - Method in class com.exasol.sql.ddl.create.CreateTable
-
Add double precision column
- dropSchema(String) - Method in class com.exasol.sql.StatementFactory
-
Create a
DropSchema
statement. - DropSchema - Class in com.exasol.sql.ddl.drop
-
This class implements an SQL
DropSchema
statement. - DropSchema(String) - Constructor for class com.exasol.sql.ddl.drop.DropSchema
-
Create a new instance of an
DropSchema
statement. - DropSchemaFragment - Interface in com.exasol.sql.ddl.drop
-
This is the common interface for all fragments of a DROP SCHEMA statement.
- DropSchemaRenderer - Class in com.exasol.sql.ddl.drop.rendering
-
The
DropSchemaRenderer
turns SQL statement structures in to SQL strings. - DropSchemaRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
-
Create a new
DropSchemaRenderer
with custom render settings. - DropSchemaVisitor - Interface in com.exasol.sql.ddl.drop
-
Visitor for
DROP SCHEMA
statements. - dropTable(String) - Method in class com.exasol.sql.StatementFactory
-
Create a
DropTable
statement. - DropTable - Class in com.exasol.sql.ddl.drop
-
This class implements an SQL
DropTable
statement. - DropTable(String) - Constructor for class com.exasol.sql.ddl.drop.DropTable
-
Create a new instance of an
DropTable
statement. - DropTableFragment - Interface in com.exasol.sql.ddl.drop
-
This is the common interface for all fragments of a DROP TABLE statement.
- DropTableRenderer - Class in com.exasol.sql.ddl.drop.rendering
-
The
DropTableRenderer
turns SQL statement structures in to SQL strings. - DropTableRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.ddl.drop.rendering.DropTableRenderer
-
Create a new
DropTableRenderer
with custom render settings. - DropTableVisitor - Interface in com.exasol.sql.ddl.drop
-
Visitor for
DROP TABLE
statements. - DUMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
String dump in various notations
E
- EDIT_DISTANCE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Edit distance of two strings
- end(ValueExpression) - Method in class com.exasol.sql.expression.predicate.BetweenPredicate.Builder
-
Adds the end expression of predicate.
- endParenthesis() - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
-
End a parenthesis.
- endParenthesis() - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
-
End a parenthesis.
- eq(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Equality comparison.
- EQUAL - com.exasol.sql.expression.comparison.SimpleComparisonOperator
-
Equals comparator
- escape(char) - Method in class com.exasol.sql.expression.comparison.LikeComparison.Builder
-
Add an escape character.
- EVERY - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- EVERY - com.exasol.sql.expression.function.exasol.ExasolAnalyticFunction
-
Deprecated.Every expression true
- ExasolAggregateFunction - Enum in com.exasol.sql.expression.function.exasol
-
Deprecated, for removal: This API element is subject to removal in a future version.Use enum
ExasolAnalyticAggregateFunctions
. - ExasolAnalyticAggregateFunctions - Enum in com.exasol.sql.expression.function.exasol
- ExasolAnalyticFunction - Enum in com.exasol.sql.expression.function.exasol
-
Deprecated, for removal: This API element is subject to removal in a future version.Use enum
ExasolAnalyticAggregateFunctions
. - ExasolFunction - Class in com.exasol.sql.expression.function.exasol
-
This class represents a function in the Exasol database.
- ExasolScalarFunction - Enum in com.exasol.sql.expression.function.exasol
-
This class is a list of Scalar Functions that the Exasol database supports.
- ExasolUdf - Class in com.exasol.sql.expression.function.exasol
-
This class represents a User Defined Function in the Exasol database.
- exclude(WindowFrameClause.WindowFrameExclusionType) - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause
-
Set the exclusion type of this
WindowFrameClause
. - exists(Select) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Check if the sub-select has any result.
- EXISTS - com.exasol.sql.expression.predicate.ExistsPredicate.ExistsPredicateOperator
-
Exists operator
- ExistsPredicate - Class in com.exasol.sql.expression.predicate
-
A class that represents a
EXISTS
predicate. - ExistsPredicate(Select) - Constructor for class com.exasol.sql.expression.predicate.ExistsPredicate
-
Creates a new instance of
ExistsPredicate
. - ExistsPredicate.ExistsPredicateOperator - Enum in com.exasol.sql.expression.predicate
-
An operator for
ExistsPredicate
class. - EXP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Exponent
- expression(ValueExpression) - Method in class com.exasol.sql.expression.predicate.BetweenPredicate.Builder
-
Adds the left expression of predicate.
- expression(ValueExpression) - Method in class com.exasol.sql.expression.predicate.InPredicate.Builder
-
Adds the predicate expression.
- ExpressionTerm - Class in com.exasol.sql.expression
-
Static factory methods for SQL expressions.
F
- field(String...) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Define fields into which should be inserted.
- field(String...) - Method in class com.exasol.sql.dql.select.Select
-
Add one or more named fields.
- FIRST_VALUE - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.First value in set
- FIRST_VALUE - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- floatLiteral(float) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a float literal.
- FloatLiteral - Class in com.exasol.sql.expression.literal
-
This class represents float literals.
- FLOOR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Floor
- FOLLOWING - com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType
-
Following
- Fragment - Interface in com.exasol.sql
-
This is the common interface for all fragments of SQL statements.
- FragmentRenderer - Interface in com.exasol.sql.rendering
-
Common interface for SQL statement fragment renderers.
- from() - Method in class com.exasol.sql.dql.select.Select
-
Get the
FromClause
of this select statement. - FROM_POSIX_TIME - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Posix time to timestamp
- FromClause - Class in com.exasol.sql.dql.select
-
This class represents the
FROM
clause of an SQLSELECT
statement. - FromClause(Fragment) - Constructor for class com.exasol.sql.dql.select.FromClause
-
Create a new instance of a
FromClause
. - FULL - com.exasol.sql.dql.select.JoinType
-
Full join (x(x)x)
- FULL_OUTER - com.exasol.sql.dql.select.JoinType
-
Full outer jon (x( )x)
- fullJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause
-
Create a new full
Join
that belongs to aFROM
clause. - fullOuterJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause
-
Create a new full outer
Join
that belongs to aFROM
clause. - function(Function) - Method in class com.exasol.sql.dql.select.Select
-
Add a function.
- function(FunctionName) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create an Exasol function.
- function(FunctionName, ValueExpression...) - Method in class com.exasol.sql.dql.select.Select
-
Add a function.
- function(FunctionName, ValueExpression...) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create an Exasol function.
- function(FunctionName, String, ValueExpression...) - Method in class com.exasol.sql.dql.select.Select
-
Add a function.
- function(Function, String) - Method in class com.exasol.sql.dql.select.Select
-
Add a function.
- Function - Interface in com.exasol.sql.expression.function
-
This class represents a function in an SQL statement.
- functionName - Variable in class com.exasol.sql.expression.function.AbstractFunction
-
Name of the function
- FunctionName - Interface in com.exasol.sql.expression.function
-
Interface for function names.
- FunctionVisitor - Interface in com.exasol.sql.expression.function
-
Visitor interface for
Function
.
G
- ge(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Greater-than-or-equal comparison.
- getAlias() - Method in class com.exasol.sql.Table
-
Get the correlation name (i.e.
- getAutoQuoted(String) - Method in class com.exasol.util.QuotesApplier
-
Applies quotes if it ie required in the configuration.
- getCascade() - Method in class com.exasol.sql.ddl.drop.DropSchema
-
Get the cascade.
- getCascadeConstraints() - Method in class com.exasol.sql.ddl.drop.DropTable
-
Get the
CASCADE CONSTRAINTS
option. - getColumn() - Method in class com.exasol.sql.dml.merge.MergeColumnUpdate
-
Get the column to be updated.
- getColumnName() - Method in class com.exasol.sql.Column
-
Get the column name
- getColumnName() - Method in class com.exasol.sql.expression.ColumnReference
-
Get the column name.
- getColumnNameAliases() - Method in class com.exasol.sql.ValueTable
-
Get column name aliases.
- getColumnReferences() - Method in class com.exasol.sql.dql.select.GroupByClause
-
Get list of column references.
- getColumnReferences() - Method in class com.exasol.sql.dql.select.OrderByClause
-
Get list of column references.
- getColumns() - Method in class com.exasol.sql.ColumnsDefinition
-
Get a list of columns.
- getColumnsDefinition() - Method in class com.exasol.sql.ddl.create.CreateTable
-
Get columns definition of the table.
- getCondition() - Method in class com.exasol.sql.dml.merge.OnClause
-
Get the merge condition.
- getCount() - Method in class com.exasol.sql.dql.select.LimitClause
-
Get the maximum number of rows to be handed back
- getDataType() - Method in class com.exasol.sql.Column
-
Get the column data type
- getDelete() - Method in class com.exasol.sql.dml.merge.MatchedClause
-
Get the
THEN DELETE
clause. - getDerivedColumnName() - Method in class com.exasol.sql.DerivedColumn
-
Get a derived column name.
- getDesc() - Method in class com.exasol.sql.dql.select.OrderByClause
-
Get descending.
- getEmitsColumnsDefinition() - Method in class com.exasol.sql.expression.function.exasol.ExasolUdf
-
Get a columns definition for the EMITS.
- getEndExpression() - Method in class com.exasol.sql.expression.predicate.BetweenPredicate
-
Returns the end expression in the
[NOT] BETWEEN
predicate. - getEscape() - Method in class com.exasol.sql.expression.comparison.LikeComparison
-
Get an escape character.
- getExclusion() - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause
-
Get the exclusion type.
- getExpression() - Method in class com.exasol.sql.dml.merge.MergeColumnUpdate
-
Get the expression that serves as the value for the update.
- getExpression() - Method in class com.exasol.sql.dql.select.WhereClause
-
Get the boolean expression defining the filter criteria
- getExpression() - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameUnitClause
-
Get the expression.
- getExpression() - Method in class com.exasol.sql.expression.predicate.BetweenPredicate
-
Returns the left expression in the
[NOT] BETWEEN
predicate. - getExpression() - Method in class com.exasol.sql.expression.predicate.InPredicate
-
Returns the left expression in the
[NOT] IN
predicate. - getExpressions() - Method in class com.exasol.sql.ValueTableRow
-
Get the list of expressions the row consists of.
- getFunctionName() - Method in class com.exasol.sql.expression.function.AbstractFunction
- getFunctionName() - Method in interface com.exasol.sql.expression.function.Function
-
Get a function's name.
- getHavingBooleanExpression() - Method in class com.exasol.sql.dql.select.GroupByClause
-
Get the "having" boolean expression.
- getInsert() - Method in class com.exasol.sql.dml.merge.NotMatchedClause
-
Get the
THEN INSERT
clause. - getInstance() - Static method in class com.exasol.sql.StatementFactory
-
Get an instance of a
StatementFactory
. - getKeyword() - Method in class com.exasol.sql.expression.function.exasol.AnalyticFunction
-
Get the keyword for the function call, may be
null
. - getLeft() - Method in class com.exasol.sql.expression.BinaryArithmeticExpression
-
Get a left operand of the arithmetic expression.
- getLeftOperand() - Method in class com.exasol.sql.expression.comparison.AbstractComparison
-
Get the left-hand side operator of the comparison
- getLeftOperand() - Method in interface com.exasol.sql.expression.comparison.Comparison
-
Get the left-hand side operator of the comparison
- getLength() - Method in class com.exasol.datatype.type.AbstractStringDataType
- getMatched() - Method in class com.exasol.sql.dml.merge.Merge
-
Get the
WHEN MATCHED
clause. - getMillisecondPrecision() - Method in class com.exasol.datatype.type.IntervalDayToSecond
- getName() - Method in class com.exasol.datatype.type.AbstractStringDataType
- getName() - Method in class com.exasol.datatype.type.Boolean
- getName() - Method in interface com.exasol.datatype.type.DataType
- getName() - Method in class com.exasol.datatype.type.Date
- getName() - Method in class com.exasol.datatype.type.Decimal
- getName() - Method in class com.exasol.datatype.type.DoublePrecision
- getName() - Method in class com.exasol.datatype.type.IntervalDayToSecond
- getName() - Method in class com.exasol.datatype.type.IntervalYearToMonth
- getName() - Method in class com.exasol.datatype.type.Timestamp
- getName() - Method in class com.exasol.datatype.type.TimestampWithLocalTimezone
- getName() - Method in class com.exasol.sql.ddl.Schema
-
Get the schema name
- getName() - Method in class com.exasol.sql.dql.select.Join
-
Get the name of the joined table
- getName() - Method in class com.exasol.sql.Table
-
Get the name of the table
- getNotMatched() - Method in class com.exasol.sql.dml.merge.Merge
-
Get the
WHEN NOT MATCHED
clause. - getNullsFirst() - Method in class com.exasol.sql.dql.select.OrderByClause
-
Get nulls first.
- getOffset() - Method in class com.exasol.sql.dql.select.LimitClause
-
Get the offset row for the limit
- getOn() - Method in class com.exasol.sql.dml.merge.Merge
-
Get the merge criteria (i.e.
- getOperand() - Method in class com.exasol.sql.expression.Not
-
Get the boolean expression literal to be negated.
- getOperand() - Method in class com.exasol.sql.expression.predicate.IsNullPredicate
-
Returns the value expression to be checked for
null
. - getOperands() - Method in class com.exasol.sql.expression.And
-
Get the operands of this AND.
- getOperands() - Method in class com.exasol.sql.expression.Or
-
Get the operands of this OR.
- getOperands() - Method in class com.exasol.sql.expression.predicate.InPredicate
-
Returns the value expressions in the
[NOT] IN
predicate. - getOperator() - Method in class com.exasol.sql.expression.comparison.AbstractComparison
-
Get the comparison operator
- getOperator() - Method in interface com.exasol.sql.expression.comparison.Comparison
-
Get the comparison operator
- getOperator() - Method in class com.exasol.sql.expression.predicate.AbstractPredicate
- getOperator() - Method in interface com.exasol.sql.expression.predicate.Predicate
-
Returns the predicate operator.
- getOrderByClause() - Method in class com.exasol.sql.expression.function.exasol.OverClause
-
Get the order by clause of this
OverClause
. - getOverClause() - Method in class com.exasol.sql.expression.function.exasol.AnalyticFunction
-
Get the "over clause" appended to the function call, may be
null
. - getParameters() - Method in class com.exasol.sql.expression.function.AbstractFunction
-
Get the value expressions (parameters of the function)
- getPartitionByColumns() - Method in class com.exasol.sql.expression.function.exasol.OverClause
-
Get the columns of the partition by clause of this
OverClause
. - getPrecision() - Method in class com.exasol.datatype.type.Decimal
- getRestrict() - Method in class com.exasol.sql.ddl.drop.DropSchema
-
Get the restriction.
- getRight() - Method in class com.exasol.sql.expression.BinaryArithmeticExpression
-
Get a right operand of the arithmetic expression.
- getRightOperand() - Method in class com.exasol.sql.expression.comparison.AbstractComparison
-
Get the right-hand side operator of the comparison
- getRightOperand() - Method in interface com.exasol.sql.expression.comparison.Comparison
-
Get the right-hand side operator of the comparison
- getRoot() - Method in class com.exasol.sql.AbstractFragment
- getRoot() - Method in interface com.exasol.sql.Fragment
-
Get the root statement of this SQL fragment.
- getRows() - Method in class com.exasol.sql.ValueTable
-
Get a list of all rows in the value table.
- getScale() - Method in class com.exasol.datatype.type.Decimal
- getSchemaName() - Method in class com.exasol.sql.ddl.create.CreateSchema
-
Get the schema name.
- getSchemaName() - Method in class com.exasol.sql.ddl.drop.DropSchema
-
Get the schema name.
- getSelectQuery() - Method in class com.exasol.sql.expression.predicate.ExistsPredicate
-
Returns the sub select query in the
EXISTS
predicate. - getSelectQuery() - Method in class com.exasol.sql.expression.predicate.InPredicate
-
Returns the sub select query in the
[NOT] IN
predicate. - getSign() - Method in class com.exasol.datatype.value.AbstractInterval
-
Produce the sign of the interval.
- getSignedValue() - Method in class com.exasol.datatype.value.AbstractInterval
-
Get the signed long integer value.
- getSpecification() - Method in class com.exasol.sql.dql.select.Join
-
Get the join specification
- getSqlKeyword() - Method in enum com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType
-
Get the keyword for rendering to SQL.
- getSqlKeyword() - Method in enum com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameExclusionType
-
Get the keyword for rendering to SQL.
- getStartExpression() - Method in class com.exasol.sql.expression.predicate.BetweenPredicate
-
Returns the start expression in the
[NOT] BETWEEN
predicate. - getStringOperatorRepresentation() - Method in class com.exasol.sql.expression.BinaryArithmeticExpression
-
Get a string representation of a member of this enum class.
- getTableName() - Method in class com.exasol.sql.ddl.create.CreateTable
-
Get the table name
- getTableName() - Method in class com.exasol.sql.ddl.drop.DropTable
-
Get the table name.
- getTableName() - Method in class com.exasol.sql.dml.insert.Insert
-
Get the name of the table into which data should be inserted
- getTableName() - Method in class com.exasol.sql.expression.ColumnReference
-
Get the table name.
- getTableNameAlias() - Method in class com.exasol.sql.ValueTable
-
Get a table name alias.
- getType() - Method in class com.exasol.sql.dql.select.Join
-
Get the type of the join
- getType() - Method in class com.exasol.sql.expression.function.exasol.CastExasolFunction
-
Get the type to cast the value to.
- getType() - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause
-
Get the window frame type.
- getType() - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameUnitClause
-
Get the type.
- getUnit1() - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause
-
Get the
BETWEEN
unit. - getUnit2() - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause
-
Get the
AND
unit. - getUpdate() - Method in class com.exasol.sql.dml.merge.MatchedClause
-
Get the
THEN UPDATE
clause. - getUsing() - Method in class com.exasol.sql.dml.merge.Merge
-
Get the
USING
clause of theMERGE
statement. - getValue() - Method in class com.exasol.sql.expression.function.exasol.CastExasolFunction
-
Get the value to cast.
- getValue() - Method in class com.exasol.sql.expression.literal.BigDecimalLiteral
-
Get the value of the
BigDecimalLiteral
. - getValue() - Method in class com.exasol.sql.expression.literal.DoubleLiteral
-
Get the value of the
DoubleLiteral
- getValue() - Method in class com.exasol.sql.expression.literal.FloatLiteral
-
Get the value of the
FloatLiteral
- getValue() - Method in class com.exasol.sql.expression.literal.IntegerLiteral
-
Get the value of the
IntegerLiteral
. - getValue() - Method in class com.exasol.sql.expression.literal.LongLiteral
-
Get the value of the
LongLiteral
- getValueExpression() - Method in class com.exasol.sql.DerivedColumn
-
Get a value expression that belongs to this derived column.
- getWhere() - Method in class com.exasol.sql.dml.merge.MergeInsertClause
-
Get the
WHERE
clause of the insert definition. - getWhere() - Method in class com.exasol.sql.dml.merge.MergeMethodDefinition
-
Get the
WHERE
clause of the merge method definition. - getWindowFrameClause() - Method in class com.exasol.sql.expression.function.exasol.OverClause
-
Get the window frame clause of this
OverClause
. - getWindowName() - Method in class com.exasol.sql.expression.function.exasol.OverClause
-
Get the window name of this
OverClause
. - getYearPrecision() - Method in class com.exasol.datatype.type.IntervalDayToSecond
- getYearPrecision() - Method in class com.exasol.datatype.type.IntervalYearToMonth
- GREATER_THAN - com.exasol.sql.expression.comparison.SimpleComparisonOperator
-
Greater-than comparator
- GREATER_THAN_OR_EQUAL - com.exasol.sql.expression.comparison.SimpleComparisonOperator
-
Greater-than-or-equal comparator
- GREATEST - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Greatest value
- GROUP - com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameExclusionType
-
Group
- GROUP_CONCAT - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Group concatenation
- GROUP_CONCAT - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- groupBy(ColumnReference...) - Method in class com.exasol.sql.dql.select.Select
-
Create a new
GroupByClause
. - GroupByClause - Class in com.exasol.sql.dql.select
-
This class represents the GROUP BY clause of an SQL statement.
- GroupByClause(SqlStatement, ColumnReference...) - Constructor for class com.exasol.sql.dql.select.GroupByClause
-
Create a new instance of a
GroupByClause
. - GROUPING - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- GROUPING_ID - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- GROUPS - com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameType
-
Groups frame
- gt(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Greater-than comparison.
H
- hasAlias() - Method in class com.exasol.sql.Table
-
Check if a correlation name (i.a.
- hasAlias() - Method in class com.exasol.sql.ValueTable
-
CHeck if the value table has an alias.
- hasDelete() - Method in class com.exasol.sql.dml.merge.MatchedClause
-
Check if the
THEN DELETE
clause is present. - hasDerivedColumnName() - Method in class com.exasol.sql.DerivedColumn
-
Check if this function has a derived column name.
- hasEmitsColumnsDefinition() - Method in class com.exasol.sql.expression.function.exasol.ExasolUdf
-
Check if the EMITS part is required.
- hasEscape() - Method in class com.exasol.sql.expression.comparison.LikeComparison
-
Check if LIKE predicate has ESCAPE.
- hasFields() - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Check if a insert fields are defined.
- HASH_MD5 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
MD5 hash
- HASH_SHA - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
SHA1 hash
- HASH_SHA256 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
SHA256 hash
- HASH_SHA512 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
SHA512 hash
- HASH_TIGER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Tiger hash
- hasIfExistsModifier() - Method in class com.exasol.sql.ddl.drop.DropSchema
-
Check whether the
IF EXISTS
clause is present. - hasIfExistsModifier() - Method in class com.exasol.sql.ddl.drop.DropTable
-
Check if the
IF EXISTS
clause is present. - hasInsert() - Method in class com.exasol.sql.dml.merge.NotMatchedClause
-
Check if the
THEN INSERT
clause is present. - hasMatched() - Method in class com.exasol.sql.dml.merge.Merge
-
Check if the
WHEN MATCHED
clause exists. - hasNot() - Method in class com.exasol.sql.expression.comparison.LikeComparison
-
Check if LIKE predicate has NOT.
- hasNotMatched() - Method in class com.exasol.sql.dml.merge.Merge
-
Check if the
WHEN NOT MATCHED
clause exists. - hasOffset() - Method in class com.exasol.sql.dql.select.LimitClause
-
Check if the limit clause has an offset
- hasOn() - Method in class com.exasol.sql.dml.merge.Merge
-
Check if the
ON
clause exists. - hasParenthesis() - Method in class com.exasol.sql.expression.function.exasol.AnalyticFunction
- hasParenthesis() - Method in class com.exasol.sql.expression.function.exasol.CastExasolFunction
- hasParenthesis() - Method in class com.exasol.sql.expression.function.exasol.ExasolFunction
- hasParenthesis() - Method in class com.exasol.sql.expression.function.exasol.ExasolUdf
- hasParenthesis() - Method in interface com.exasol.sql.expression.function.Function
-
Check if function needs parenthesis.
- hasSelectQuery() - Method in class com.exasol.sql.expression.predicate.InPredicate
-
Checks if
InPredicate
has a sub query. - hasSubSelect() - Method in class com.exasol.sql.dql.select.FromClause
-
Check if the
FromClause
contains a sub-select statement. - hasUpdate() - Method in class com.exasol.sql.dml.merge.MatchedClause
-
Check if the
THEN UPDATE
clause is present. - hasUsing() - Method in class com.exasol.sql.dml.merge.Merge
-
Check if the
USING
clause exists. - hasValues() - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Check if a value table is present.
- hasWhere() - Method in class com.exasol.sql.dml.merge.MergeInsertClause
-
Check if the
WHERE
clause exists. - hasWhere() - Method in class com.exasol.sql.dml.merge.MergeMethodDefinition
-
Check if the
WHERE
clause exists. - having(BooleanExpression) - Method in class com.exasol.sql.dql.select.GroupByClause
-
Add having statement to the SQL query.
- HOUR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Hour part of a date / time
- HOURS_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Hours between
I
- ifExists() - Method in class com.exasol.sql.ddl.drop.DropSchema
-
Add
IF EXISTS
clause into aDROP SCHEMA
statement. - ifExists() - Method in class com.exasol.sql.ddl.drop.DropTable
-
Add
IF EXISTS
clause into aDROP TABLE
statement. - in(ValueExpression, Select) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Check for value sub-select.
- in(ValueExpression, ValueExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Check for value in list.
- IN - com.exasol.sql.expression.predicate.InPredicate.InPredicateOperator
-
In-list operator
- INITCAP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Capitalize first letter of each word
- INNER - com.exasol.sql.dql.select.JoinType
-
Inner join ( (x) )
- innerJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause
-
Create a new inner
Join
that belongs to aFROM
clause. - InPredicate - Class in com.exasol.sql.expression.predicate
-
A class that represents a
[NOT] IN
predicate. - InPredicate.Builder - Class in com.exasol.sql.expression.predicate
-
A builder for
InPredicate
. - InPredicate.InPredicateOperator - Enum in com.exasol.sql.expression.predicate
-
A class that represents
InPredicate
operator. - Insert - Class in com.exasol.sql.dml.insert
-
This class implements an SQL
Insert
statement. - Insert(String) - Constructor for class com.exasol.sql.dml.insert.Insert
-
Create a new instance of an
Insert
statement - INSERT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Insert string into other string
- insertFields - Variable in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Fields to insert
- InsertFields - Class in com.exasol.sql.dml.insert
-
Field list that defines the fields data is being inserted into.
- InsertFields(Fragment) - Constructor for class com.exasol.sql.dml.insert.InsertFields
-
Create an new instance of
InsertFields
- InsertFragment - Interface in com.exasol.sql.dml.insert
-
This is the common interface for all fragments of a INSERT statement.
- insertInto(String) - Method in class com.exasol.sql.StatementFactory
-
Create an
Insert
statement. - InsertRenderer - Class in com.exasol.sql.dml.insert.rendering
-
The
InsertRenderer
turns SQL statement structures in to SQL strings. - InsertRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.dml.insert.rendering.InsertRenderer
-
Create a new
InsertRenderer
with custom render settings. - insertValueTable - Variable in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Table with values used in the
INSERT
statement - InsertVisitor - Interface in com.exasol.sql.dml.insert
-
Visitor for
INSERT
statements. - INSTR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Find occurrence in string
- integerLiteral(int) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create an integer literal.
- IntegerLiteral - Class in com.exasol.sql.expression.literal
-
This class represents integer literals.
- IntervalDayToSecond - Class in com.exasol.datatype.type
-
This class implements the Exasol-proprietary data type interval day to second.
- IntervalDayToSecond - Class in com.exasol.datatype.value
-
This class implements the Exasol-proprietary data type value
INTERVAL DAY(x) TO SECONDS(y)
. - IntervalDayToSecond(int, int) - Constructor for class com.exasol.datatype.type.IntervalDayToSecond
-
Create a new instance of an
IntervalDayToSecond
data type - intervalDayToSecondColumn(String, int, int) - Method in class com.exasol.sql.ColumnsDefinition.Builder
-
Add interval day to second column.
- intervalDayToSecondColumn(String, int, int) - Method in class com.exasol.sql.ddl.create.CreateTable
-
Add interval day to second column.
- IntervalYearToMonth - Class in com.exasol.datatype.type
-
This class implements the Exasol-proprietary data type interval year to month
- IntervalYearToMonth - Class in com.exasol.datatype.value
-
This class implements the Exasol-proprietary data type value
INTERVAL YEAR(x) TO MONTH(y)
. - IntervalYearToMonth(int) - Constructor for class com.exasol.datatype.type.IntervalYearToMonth
-
Create a new instance of an
IntervalYearToMonth
data type - intervalYearToMonthColumn(String, int) - Method in class com.exasol.sql.ColumnsDefinition.Builder
-
Add interval year to month column.
- intervalYearToMonthColumn(String, int) - Method in class com.exasol.sql.ddl.create.CreateTable
-
Add interval year to month column.
- IPROC - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Data node number
- IS_BOOLEAN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Is a boolean
- IS_DATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Is a date
- IS_DSINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Is an interval with second precision
- IS_NOT_NULL - com.exasol.sql.expression.predicate.IsNullPredicate.IsNullPredicateOperator
-
Is-not-null operator
- IS_NULL - com.exasol.sql.expression.predicate.IsNullPredicate.IsNullPredicateOperator
-
Is-null operator
- IS_NUMBER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Is a number
- IS_TIMESTAMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Is a timestamp
- IS_YMINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Is an interval with month precision
- isEmpty() - Method in class com.exasol.sql.ValueTable
-
Check if the value table is empty.
- isNotNull(ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Check for not null.
- isNull(ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Check for null.
- IsNullPredicate - Class in com.exasol.sql.expression.predicate
-
A class that represents a
IS [NOT] NULL
predicate. - IsNullPredicate(IsNullPredicate.IsNullPredicateOperator, ValueExpression) - Constructor for class com.exasol.sql.expression.predicate.IsNullPredicate
-
Creates a new instance of
IsNullPredicate
forIS [NOT] NULL
predicate. - IsNullPredicate(ValueExpression) - Constructor for class com.exasol.sql.expression.predicate.IsNullPredicate
-
Creates a new instance of
IsNullPredicate
forIS NULL
predicate. - IsNullPredicate.IsNullPredicateOperator - Enum in com.exasol.sql.expression.predicate
-
An operator for
IsNullPredicate
class.
J
- join(String, String) - Method in class com.exasol.sql.dql.select.FromClause
-
Create a new
Join
that belongs to aFROM
clause. - Join - Class in com.exasol.sql.dql.select
-
This class implements the
Join
part of a WHERE clause. - Join(Fragment, JoinType, String, String) - Constructor for class com.exasol.sql.dql.select.Join
-
Create a new
Join
instance - JoinType - Enum in com.exasol.sql.dql.select
-
This class represents the
Join
types supported by SQL.
K
- keywordAll() - Method in class com.exasol.sql.expression.function.exasol.AnalyticFunction
-
Add keyword
ALL
to the function call - keywordDistinct() - Method in class com.exasol.sql.expression.function.exasol.AnalyticFunction
-
Add keyword
DISTINCT
to the function call
L
- LAG - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- LAST_VALUE - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Last value in set
- LAST_VALUE - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- LCASE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Lower case
- le(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Less-than-or-equal comparison.
- LEAD - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- LEAST - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Least value
- leave(CreateTable) - Method in interface com.exasol.sql.ddl.create.CreateTableVisitor
-
Leave a
CREATE TABLE
statement. - leave(CreateTable) - Method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer
- leave(InsertFields) - Method in interface com.exasol.sql.dml.insert.InsertVisitor
-
Leave the list of fields to insert into.
- leave(InsertFields) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
- leave(InsertFields) - Method in interface com.exasol.sql.dml.merge.MergeVisitor
-
Leave the insert field list.
- leave(InsertFields) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- leave(FromClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
- leave(FromClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor
-
Leave the
FROM
clause. - leave(ValueTable) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
- leave(ValueTable) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- leave(ValueTable) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
- leave(ValueTable) - Method in interface com.exasol.sql.ValueTableVisitor
-
Leave a value table.
- leave(ValueTableRow) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
- leave(ValueTableRow) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- leave(ValueTableRow) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
- leave(ValueTableRow) - Method in interface com.exasol.sql.ValueTableVisitor
-
Leave a row in a value table.
- left(ValueExpression) - Method in class com.exasol.sql.expression.comparison.LikeComparison.Builder
-
Add the left operand.
- LEFT - com.exasol.sql.dql.select.JoinType
-
Left join (x(x) )
- LEFT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Left part of string
- LEFT_OUTER - com.exasol.sql.dql.select.JoinType
-
Left outer join (x( ) )
- leftJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause
-
Create a new left
Join
that belongs to aFROM
clause. - leftOperand - Variable in class com.exasol.sql.expression.comparison.AbstractComparison
-
left part of the comparison
- leftOuterJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause
-
Create a new left outer
Join
that belongs to aFROM
clause. - LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
String length in characters (differs from bytes for UTF)
- LESS_THAN - com.exasol.sql.expression.comparison.SimpleComparisonOperator
-
Less-than comparator
- LESS_THAN_OR_EQUAL - com.exasol.sql.expression.comparison.SimpleComparisonOperator
-
Less-than-or-equal comparator
- like(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Comparison with
LIKE
operator. - like(ValueExpression, ValueExpression, char) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Comparison with
LIKE
operator. - LIKE - com.exasol.sql.expression.comparison.LikeComparison.LikeComparisonOperator
-
LIKE
comparator - LikeComparison - Class in com.exasol.sql.expression.comparison
-
This class represents a LIKE comparison.
- LikeComparison.Builder - Class in com.exasol.sql.expression.comparison
-
A builder for
LikeComparison
. - LikeComparison.LikeComparisonOperator - Enum in com.exasol.sql.expression.comparison
-
Fuzzy string comparators.
- limit(int) - Method in class com.exasol.sql.dql.select.Select
-
Create a new full outer
LimitClause
. - limit(int, int) - Method in class com.exasol.sql.dql.select.Select
-
Create a new full outer
LimitClause
. - LimitClause - Class in com.exasol.sql.dql.select
-
This class represents the limit clause of an SQL statement.
- LimitClause(SqlStatement, int) - Constructor for class com.exasol.sql.dql.select.LimitClause
-
Create a new instance of a
LimitClause
- LimitClause(SqlStatement, int, int) - Constructor for class com.exasol.sql.dql.select.LimitClause
-
Create a new instance of a
LimitClause
- LISTAGG - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- LISTAGG - com.exasol.sql.expression.function.exasol.ExasolAnalyticFunction
-
Deprecated.Concatenated string of values of expression from all rows in the window or group
- Literal - Interface in com.exasol.sql.expression.literal
-
Interface for classes that represent literal values.
- LiteralVisitor - Interface in com.exasol.sql.expression.literal
-
Visitor for
Literal
. - LN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Logarithm to base e
- LOCALTIMESTAMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Timestamp in local time
- LOCATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Find position in string
- LOG - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Logarithm with user-defined base
- LOG10 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Logarithm to base 10
- LOG2 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Logrithm to base 2
- longLiteral(long) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create an long literal.
- LongLiteral - Class in com.exasol.sql.expression.literal
-
This class represents long literals.
- LOWER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Lower case
- lowerCase(boolean) - Method in class com.exasol.sql.rendering.StringRendererConfig.Builder
-
Define whether the statement should be produced in lower case
- LPAD - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Pad left
- lt(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Less-than comparison.
- LTRIM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Trim left
M
- MatchedClause - Class in com.exasol.sql.dml.merge
-
Representation of the
WHEN MATCHED
part of an 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
-
Deprecated.Maximum value
- MAX - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- MEDIAN - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Median
- MEDIAN - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- Merge - Class in com.exasol.sql.dml.merge
- Merge(String) - Constructor for class com.exasol.sql.dml.merge.Merge
-
Create a new instance of a
Merge
. - Merge(String, String) - Constructor for class com.exasol.sql.dml.merge.Merge
-
Create a new instance of a
Merge
. - MergeColumnUpdate - Class in com.exasol.sql.dml.merge
-
Update of a value in a column caused by a
MERGE
command. - MergeColumnUpdate(Fragment, String, ValueExpression) - Constructor for class com.exasol.sql.dml.merge.MergeColumnUpdate
-
Create a new instance of a
MergeColumnUpdate
. - MergeDeleteClause - Class in com.exasol.sql.dml.merge
-
This class represents the
MERGE
strategy of deleting matched rows. - MergeDeleteClause(Fragment) - Constructor for class com.exasol.sql.dml.merge.MergeDeleteClause
-
Create a new instance of a
MergeDeleteClause
. - MergeFragment - Interface in com.exasol.sql.dml.merge
-
This is the common interface for all fragments of a
MERGE
statement. - MergeInsertClause - Class in com.exasol.sql.dml.merge
-
Represents the
MERGE
strategy of inserting rows from the source that do not match any row in the destination. - MergeInsertClause(Fragment) - Constructor for class com.exasol.sql.dml.merge.MergeInsertClause
-
Create a new instance of a
MergeInsertClause
. - mergeInto(String) - Method in class com.exasol.sql.StatementFactory
-
Create a
Merge
statement. - mergeInto(String, String) - Method in class com.exasol.sql.StatementFactory
-
Create a
Merge
statement. - MergeMethodDefinition - Class in com.exasol.sql.dml.merge
-
Abstract base class for merge method definitions like
WHEN MATCHED THEN UPDATE
. - MergeMethodDefinition(Fragment) - Constructor for class com.exasol.sql.dml.merge.MergeMethodDefinition
-
Create the abstract base for a merge method definition.
- MergeRenderer - Class in com.exasol.sql.dml.merge.rendering
-
The
InsertRenderer
turns SQL statement structures in to SQL strings. - MergeRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.dml.merge.rendering.MergeRenderer
-
Create a new
MergeRenderer
with custom render settings. - MergeUpdateClause - Class in com.exasol.sql.dml.merge
-
Represents the
MERGE
strategy of updating matched rows. - MergeUpdateClause(Fragment) - Constructor for class com.exasol.sql.dml.merge.MergeUpdateClause
-
Create a new instance of a
MergeUpdateClause
. - MergeVisitor - Interface in com.exasol.sql.dml.merge
-
Visitor for value tables.
- MID - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Take a part from the mid of the string
- MIN - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Minimum Value
- MIN - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- minus(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a binary arithmetic expression with SUBTRACT operator.
- MINUTE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Minute part of a date / time
- MINUTES_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Minutes between
- MOD - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Modulo
- MONTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Month part of a date
- MONTHS_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Months between two dates
- MUL - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- multiply(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a binary arithmetic expression with DIVIDE operator.
- MULTIPLY - com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator
-
Multiplication
N
- name() - Method in interface com.exasol.sql.expression.function.FunctionName
-
Function name.
- ne(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Not-equal comparison.
- NO_OTHERS - com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameExclusionType
-
No others
- not() - Method in class com.exasol.sql.expression.comparison.LikeComparison.Builder
-
Set for NOT LIKE expression.
- not() - Method in class com.exasol.sql.expression.predicate.BetweenPredicate.Builder
-
Sets
NOT BETWEEN
predicate. - not() - Method in class com.exasol.sql.expression.predicate.InPredicate.Builder
-
Sets
NOT IN
predicate. - not(boolean) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Unary
NOT
of boolean value. - not(BooleanExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Unary
NOT
of boolean expression. - Not - Class in com.exasol.sql.expression
-
This class implements the logical unary NOT predicate.
- Not(boolean) - Constructor for class com.exasol.sql.expression.Not
-
Create a new instance of a unary
Not
from a boolean literal - Not(BooleanExpression) - Constructor for class com.exasol.sql.expression.Not
-
Create a new instance of a unary
Not
from a boolean expression - Not(String) - Constructor for class com.exasol.sql.expression.Not
-
Create a new instance of a unary
Not
from a string literal - NOT_BETWEEN - com.exasol.sql.expression.predicate.BetweenPredicate.BetweenPredicateOperator
-
Outside boundaries
- NOT_EQUAL - com.exasol.sql.expression.comparison.SimpleComparisonOperator
-
Not equals comparator
- NOT_IN - com.exasol.sql.expression.predicate.InPredicate.InPredicateOperator
-
Not-in-list operator
- NOT_LIKE - com.exasol.sql.expression.comparison.LikeComparison.LikeComparisonOperator
-
NOT_LIKE
comparator - notBetween(ValueExpression, ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Check if value is not between two other values.
- notIn(ValueExpression, Select) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Check if value not in sub-select.
- notIn(ValueExpression, ValueExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Check if value not in list.
- notLike(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Comparison with inverted
LIKE
operator. - notLike(ValueExpression, ValueExpression, char) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Comparison with inverted
LIKE
operator. - NotMatchedClause - Class in com.exasol.sql.dml.merge
-
Representation of the
WHEN NOT MATCHED
part of an 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
-
Current timestamp
- NPROC - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Number of cluster nodes
- NTH_VALUE - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- NTILE - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- NULLIF - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Null if
- NULLIFZERO - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Null if zero
- nullLiteral() - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a NULL literal.
- nullLiteral() - Static method in class com.exasol.sql.expression.literal.NullLiteral
-
Create a NULL literal.
- NullLiteral - Class in com.exasol.sql.expression.literal
-
This class represents a null literal.
- nullsFirst() - Method in class com.exasol.sql.dql.select.OrderByClause
-
Add NULLS FIRST option to the
OrderByClause
- nullsLast() - Method in class com.exasol.sql.dql.select.OrderByClause
-
Add NULLS LAST option to the
OrderByClause
- NUMTODSINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Number to days-to-second interval
- NUMTOYMINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Number to years-to-month interval
- NVL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Replace null with expression
- NVL2 - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Replace null with expression.
O
- OCTET_LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
String length in bytes
- of(boolean) - Static method in class com.exasol.sql.expression.literal.BooleanLiteral
-
Create a boolean literal from a boolean value
- of(char) - Static method in class com.exasol.sql.expression.literal.StringLiteral
-
Create a new
StringLiteral
from a character. - of(double) - Static method in class com.exasol.sql.expression.literal.DoubleLiteral
-
Create a new
DoubleLiteral
from a double. - of(float) - Static method in class com.exasol.sql.expression.literal.FloatLiteral
-
Create a new
FloatLiteral
from a float. - of(int) - Static method in class com.exasol.sql.expression.literal.IntegerLiteral
-
Create a new
IntegerLiteral
from an integer. - of(long) - Static method in class com.exasol.sql.expression.literal.LongLiteral
-
Create a new
LongLiteral
from a long. - of(BinaryArithmeticExpression.BinaryArithmeticOperator, ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.BinaryArithmeticExpression
-
Create a new
BinaryArithmeticExpression
instance. - of(ExasolAnalyticAggregateFunctions, ValueExpression...) - Static method in class com.exasol.sql.expression.function.exasol.AnalyticFunction
-
Create a new
AnalyticFunction
instance. - of(FunctionName) - Static method in class com.exasol.sql.expression.function.exasol.ExasolFunction
-
Create a new
ExasolFunction
instance. - of(FunctionName, ValueExpression...) - Static method in class com.exasol.sql.expression.function.exasol.ExasolFunction
-
Create a new
ExasolFunction
instance. - of(ValueExpression, DataType) - Static method in class com.exasol.sql.expression.function.exasol.CastExasolFunction
-
Create a new
CastExasolFunction
instance. - of(String) - Static method in class com.exasol.sql.expression.ColumnReference
-
Create a new
ColumnReference
from a column name. - of(String) - Static method in class com.exasol.sql.expression.function.exasol.OverClause
-
Create a new
OverClause
with the given window name. - of(String) - Static method in class com.exasol.sql.expression.literal.BooleanLiteral
-
Create a new
BooleanLiteral
instance from a String. - of(String) - Static method in class com.exasol.sql.expression.literal.StringLiteral
-
Create a new
StringLiteral
from a string. - of(String, ColumnsDefinition, ValueExpression...) - Static method in class com.exasol.sql.expression.function.exasol.ExasolUdf
-
Create a new
ExasolUdf
instance. - of(String, ValueExpression...) - Static method in class com.exasol.sql.expression.function.exasol.ExasolUdf
-
Create a new
ExasolUdf
instance. - of(BigDecimal) - Static method in class com.exasol.sql.expression.literal.BigDecimalLiteral
-
Create a new
BigDecimalLiteral
from a BigDecimal. - ofMillis(long) - Static method in class com.exasol.datatype.value.IntervalDayToSecond
-
Create an
IntervalDayToSecond
from a number of milliseconds - ofMonths(long) - Static method in class com.exasol.datatype.value.IntervalYearToMonth
-
Create an
IntervalDayToSecond
from a number of months - ofSymbol(String) - Static method in enum com.exasol.sql.expression.comparison.SimpleComparisonOperator
-
Get the
SimpleComparisonOperator
for the provided symbol - on(BooleanExpression) - Method in class com.exasol.sql.dml.merge.Merge
-
Define the merge criteria.
- OnClause - Class in com.exasol.sql.dml.merge
-
The
ON
clause of an SQLMERGE
statement. - OnClause(Fragment, BooleanExpression) - Constructor for class com.exasol.sql.dml.merge.OnClause
-
Create a new instance of a
OnClause
. - operands(ValueExpression...) - Method in class com.exasol.sql.expression.predicate.InPredicate.Builder
-
Adds the operands.
- operation(String, BooleanExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Create a logical operation from an operator name and a list of operands
- operator - Variable in class com.exasol.sql.expression.comparison.AbstractComparison
-
comparison operator
- or(boolean...) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Logical
OR
combination of boolean values. - or(boolean, BooleanExpression) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Logical
OR
combination of boolean value and expression. - or(BooleanExpression...) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Logical
OR
combination of boolean expressions. - or(BooleanExpression, boolean) - Static method in class com.exasol.sql.expression.BooleanTerm
-
Logical
OR
combination of boolean expression and value. - Or - Class in com.exasol.sql.expression
-
This class represents a logical OR predicate.
- Or(boolean...) - Constructor for class com.exasol.sql.expression.Or
-
Create a new
Or
instance - Or(BooleanExpression...) - Constructor for class com.exasol.sql.expression.Or
-
Create a new
Or
instance - orderBy(OrderByClause) - Method in class com.exasol.sql.expression.function.exasol.OverClause
-
Set the
OrderByClause
for thisOverClause
. - orderBy(ColumnReference...) - Method in class com.exasol.sql.dql.select.Select
-
Create a new
OrderByClause
. - OrderByClause - Class in com.exasol.sql.dql.select
-
This class represents the
ORDER BY
clause of an SQL statement. - OrderByClause(SqlStatement, ColumnReference...) - Constructor for class com.exasol.sql.dql.select.OrderByClause
-
Create a new instance of a
OrderByClause
. - over(OverClause) - Method in class com.exasol.sql.expression.function.exasol.AnalyticFunction
-
Add the given over clause to the function call.
- over(UnaryOperator<OverClause>) - Method in class com.exasol.sql.expression.function.exasol.AnalyticFunction
-
Add an
OVER
clause to the function call. - OverClause - Class in com.exasol.sql.expression.function.exasol
-
This represents an
OVER
clause of an analytic function in Exasol. - OverClause() - Constructor for class com.exasol.sql.expression.function.exasol.OverClause
P
- parameters - Variable in class com.exasol.sql.expression.function.AbstractFunction
-
Function parameters
- parse(String) - Static method in class com.exasol.datatype.value.IntervalDayToSecond
-
Parse an
IntervalDayToSecond
from a string - parse(String) - Static method in class com.exasol.datatype.value.IntervalYearToMonth
-
Parse an
IntervalDayToSecond
from a string - parseMatchingGroupToLong(Matcher, int) - Static method in class com.exasol.datatype.value.AbstractInterval
-
Parse a group that came out of a string match to an interval.
- partitionBy(ValueExpression...) - Method in class com.exasol.sql.expression.function.exasol.OverClause
-
Set the columns for the
PARTITION BY
clause of thisOverClause
. - PERCENT_RANK - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- PERCENTILE_CONT - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- PERCENTILE_DISC - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- PI - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Pi
- plus(ValueExpression, ValueExpression) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a binary arithmetic expression with ADD operator.
- positive - Variable in class com.exasol.datatype.value.AbstractInterval
-
Cache that remembers if the interval is positive
- POSIX_TIME - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Seconds since Epoch
- POWER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Power
- PRECEDING - com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType
-
Preceding
- Predicate - Interface in com.exasol.sql.expression.predicate
-
Interface for classes that implement predicate expressions.
- PredicateOperator - Interface in com.exasol.sql.expression.predicate
-
An interface for the predicate operators.
- PredicateVisitor - Interface in com.exasol.sql.expression.predicate
-
An interface for
Predicate
visitor.
Q
- quoteIdentifiers(boolean) - Method in class com.exasol.sql.rendering.StringRendererConfig.Builder
-
Define whether schema, table and field identifiers should be enclosed in double quotation marks.
- QuotesApplier - Class in com.exasol.util
-
This class handles quotes in a string identifier.
- QuotesApplier(StringRendererConfig) - Constructor for class com.exasol.util.QuotesApplier
-
Create a new instance of a
QuotesApplier
.
R
- RADIANS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Degrees to radians
- RANDOM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Random number
- RANGE - com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameType
-
Range frame
- RANK - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- RATIO_TO_REPORT - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- REGEXP_INSTR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Find occurrence of regular expression in string
- REGEXP_REPLACE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Replace occurrence of regular expression in string
- REGEXP_SUBSTR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Return substring that matches regular expression
- REGR_AVGX - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Average of the independent values (x values)
- REGR_AVGX - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- REGR_AVGY - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Average of the independent values (y values)
- REGR_AVGY - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- REGR_COUNT - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Number of non-null number pairs
- REGR_COUNT - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- REGR_INTERCEPT - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.y-Intercept of the regression line
- REGR_INTERCEPT - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- REGR_R2 - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Coefficient of determination (goodness of fit)
- REGR_R2 - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- REGR_SLOPE - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Slope of the regression line
- REGR_SLOPE - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- REGR_SXX - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Auxiliary function SXX
- REGR_SXX - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- REGR_SXY - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Auxiliary function SXY
- REGR_SXY - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- REGR_SYY - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Auxiliary function SYY
- REGR_SYY - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- render() - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
-
Render expression to a string
- render() - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
- render() - Method in interface com.exasol.sql.rendering.FragmentRenderer
-
Render an SQL statement to a string.
- REPEAT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Repeat string sequence
- REPLACE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Replace substring
- restrict() - Method in class com.exasol.sql.ddl.drop.DropSchema
-
Add
RESTRICT
clause to aDROP SCHEMA
statement. - Restrict - Class in com.exasol.sql.ddl.drop
-
This class represents RESTRICT clause in DROP SCHEMA SQL statement
- Restrict(Fragment) - Constructor for class com.exasol.sql.ddl.drop.Restrict
-
Create an instance of
Restrict
class - REVERSE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Reverse string
- right(ValueExpression) - Method in class com.exasol.sql.expression.comparison.LikeComparison.Builder
-
Add the right operand.
- RIGHT - com.exasol.sql.dql.select.JoinType
-
Right join ( (x)x)
- RIGHT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Right part of a string
- RIGHT_OUTER - com.exasol.sql.dql.select.JoinType
-
Right outer join ( ( )x)
- rightJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause
-
Create a new right
Join
that belongs to aFROM
clause. - rightOperand - Variable in class com.exasol.sql.expression.comparison.AbstractComparison
-
right part of the comparison
- rightOuterJoin(String, String) - Method in class com.exasol.sql.dql.select.FromClause
-
Create a new right outer
Join
that belongs to aFROM
clause. - root - Variable in class com.exasol.sql.AbstractFragment
-
Root fragment of the statement fragment tree.
- ROUND - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Round
- ROW_NUMBER - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- ROWID - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Row ID
- ROWNUM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Row counter
- ROWS - com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameType
-
Rows frame
- RPAD - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Pad right
- RTRIM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Trim right
S
- Schema - Class in com.exasol.sql.ddl
-
This class represents a
Schema
in an SQL Statement - Schema(Fragment, String) - Constructor for class com.exasol.sql.ddl.Schema
-
Create a new
Schema
- SCOPE_USER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Scope user
- SECOND - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Second part of a date / time
- SECONDS_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Seconds between two dates / times
- select() - Method in class com.exasol.sql.StatementFactory
-
Create a
Select
statement. - select(Select) - Method in class com.exasol.sql.dql.select.FromClause
-
Add a select to the
FromClause
. - Select - Class in com.exasol.sql.dql.select
-
This class implements an SQL
Select
statement. - Select() - Constructor for class com.exasol.sql.dql.select.Select
-
Create a new instance of a
Select
. - SelectFragment - Interface in com.exasol.sql.dql.select
-
This is the common interface for all fragments of a SELECT statement.
- selectQuery(Select) - Method in class com.exasol.sql.expression.predicate.InPredicate.Builder
-
Adds the sub select query.
- SelectRenderer - Class in com.exasol.sql.dql.select.rendering
-
The
SelectRenderer
turns SQL statement structures in to SQL strings. - SelectRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.dql.select.rendering.SelectRenderer
-
Create a new
SelectRenderer
with custom render settings. - SelectVisitor - Interface in com.exasol.sql.dql.select
-
Visitor for
SELECT
SQL statements. - self() - Method in class com.exasol.datatype.type.AbstractStringDataType
-
Get the generic self pointer.
- self() - Method in class com.exasol.datatype.type.Char
- self() - Method in class com.exasol.datatype.type.Varchar
- self() - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Generic self pointer.
- self() - Method in class com.exasol.sql.dml.insert.Insert
- self() - Method in class com.exasol.sql.dml.merge.MergeInsertClause
- SESSIONTIMEZONE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Session timezone
- set(String, boolean) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause
-
Update a column with a boolean value.
- set(String, char) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause
-
Update a column with a char value.
- set(String, double) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause
-
Update a column with a double value.
- set(String, float) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause
-
Update a column with a float value.
- set(String, int) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause
-
Update a column with an integer value.
- set(String, long) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause
-
Update a column with a long value.
- set(String, ValueExpression) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause
-
Update a column with a value expression.
- set(String, String) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause
-
Update a column with a string value.
- setLastVisited(Fragment) - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
-
Set the last statement fragment that was visited.
- setToDefault(String) - Method in class com.exasol.sql.dml.merge.MergeUpdateClause
-
Update a column with the default value defined for that column.
- SIGN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Sign
- SimpleComparison - Class in com.exasol.sql.expression.comparison
-
This class implements all simple comparison operators.
- SimpleComparison(SimpleComparisonOperator, ValueExpression, ValueExpression) - Constructor for class com.exasol.sql.expression.comparison.SimpleComparison
-
Create a new instance of SimpleComparison.
- SimpleComparisonOperator - Enum in com.exasol.sql.expression.comparison
-
This enum represents the different types of
SimpleComparison
s that can be used inExpression
s. - SIN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Sine
- SINH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Hyperbolic sine
- SOME - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
This is an alias for
ExasolAnalyticAggregateFunctions.ANY
. - SOUNDEX - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Sounds like
- SqlStatement - Interface in com.exasol.sql
-
This interface represents an SQL statement.
- SQRT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Square root
- ST_AREA - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Area of (multi-)polygon
- ST_BOUNDARY - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Geometric boundary
- ST_BUFFER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Points of maximal distance
- ST_CENTROID - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Center of mass
- ST_CONTAINS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Object fully contains another object
- ST_CONVEXHULL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Convex hull
- ST_CROSSES - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Object crosses another object
- ST_DIFFERENCE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Difference
- ST_DIMENSION - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Dimmension of object: Points / Lines / Poligons
- ST_DISJOINT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Object disjoint of another object
- ST_DISTANCE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Minimal distance between two objects
- ST_ENDPOINT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Endpoint of line
- ST_ENVELOPE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Smallest rectangle containing object
- ST_EQUALS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Objects equal
- ST_EXTERIORRING - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Outer ring of object
- ST_FORCE2D - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Turn to 2D object
- ST_GEOMETRYN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
The n-th object of a GeometryCollection
- ST_GEOMETRYTYPE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Type as string
- ST_INTERIORRINGN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Inner ring
- ST_INTERSECTION - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Intersection of two objects
- ST_INTERSECTS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Objects intersect
- ST_ISCLOSED - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Object is closed
- ST_ISEMPTY - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Empty set
- ST_ISRING - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Start point = end point
- ST_ISSIMPLE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Simple object
- ST_LENGTH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Length
- ST_NUMGEOMETRIES - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Number of objects in collection of geometry objects
- ST_NUMINTERIORRINGS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Number of holes within a Polygon
- ST_NUMPOINTS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Points in line string
- ST_OVERLAPS - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Objects overlap
- ST_POINTN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
n-th point
- ST_SETSRID - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Set SRID
- ST_STARTPOINT - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Start point
- ST_SYMDIFFERENCE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Symmetric difference
- ST_TOUCHES - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Object touches another object
- ST_TRANSFORM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Coordinate transformation
- ST_UNION - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Union of two objects
- ST_WITHIN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Object fully contained in another object
- ST_X - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
X coordinate of point
- ST_Y - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Y coordinate of point
- start(ValueExpression) - Method in class com.exasol.sql.expression.predicate.BetweenPredicate.Builder
-
Adds the start expression of predicate.
- startParenthesis() - Method in class com.exasol.sql.expression.rendering.AbstractExpressionRenderer
-
Start a parenthesis.
- startParenthesis() - Method in class com.exasol.sql.rendering.AbstractFragmentRenderer
-
Start a parenthesis.
- StatementFactory - Class in com.exasol.sql
-
The
StatementFactory
implements an factory for SQL statements. - STDDEV - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Standard deviation
- STDDEV - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- STDDEV_POP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Standard deviation of expr within a window or group of rows
- STDDEV_POP - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- STDDEV_SAMP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Standard deviation of expr within a window or group of rows
- STDDEV_SAMP - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- stringLiteral(char) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a string literal from a character.
- stringLiteral(String) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a string literal.
- StringLiteral - Class in com.exasol.sql.expression.literal
-
This class represents string literals (or character literals in SQL terms).
- StringRendererConfig - Class in com.exasol.sql.rendering
-
This class implements a parameter object containing the configuration options for the
StatementFactory
. - StringRendererConfig.Builder - Class in com.exasol.sql.rendering
-
Builder for
StringRendererConfig
- SUBSTR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Substring
- SUBTRACT - com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator
-
Subtraction
- SUM - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Sum
- SUM - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- SYS_GUID - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Unique system wide ID
- SYSDATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Current date
- SYSTIMESTAMP - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Current timestamp
T
- table(String) - Method in class com.exasol.sql.dql.select.FromClause
-
Add a table name to the
FromClause
. - Table - Class in com.exasol.sql
-
Represents a
Table
in an SQL Statement. - Table(Fragment, String) - Constructor for class com.exasol.sql.Table
-
Create a new
Table
with a name and an alias. - Table(Fragment, String, String) - Constructor for class com.exasol.sql.Table
-
Create a new
Table
with a name and an alias. - tableAs(String, String) - Method in class com.exasol.sql.dql.select.FromClause
-
Add a table name with an alias to the
FromClause
. - TAN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Tangens
- TANH - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Hyperbolic tangens
- thenDelete() - Method in class com.exasol.sql.dml.merge.MatchedClause
-
Select deleting as merge strategy for rows where that are considered matches between source and destination.
- thenInsert() - Method in class com.exasol.sql.dml.merge.NotMatchedClause
-
Select inserting as merge strategy for rows from the source for which no match in the destination exists.
- thenUpdate() - Method in class com.exasol.sql.dml.merge.MatchedClause
-
Select updating as merge strategy for rows where that are considered matches between source and destination.
- TIES - com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameExclusionType
-
Ties
- Timestamp - Class in com.exasol.datatype.type
-
This class implements the SQl data type timestamp
- Timestamp() - Constructor for class com.exasol.datatype.type.Timestamp
- timestampColumn(String) - Method in class com.exasol.sql.ColumnsDefinition.Builder
-
Add timestamp column.
- timestampColumn(String) - Method in class com.exasol.sql.ddl.create.CreateTable
-
Add timestamp column
- TimestampWithLocalTimezone - Class in com.exasol.datatype.type
-
This class implements the Exasol-proprietary data type timestamp with local timezone data
- TimestampWithLocalTimezone() - Constructor for class com.exasol.datatype.type.TimestampWithLocalTimezone
- timestampWithLocalTimeZoneColumn(String) - Method in class com.exasol.sql.ColumnsDefinition.Builder
-
Add timestamp with local time zone column.
- timestampWithLocalTimeZoneColumn(String) - Method in class com.exasol.sql.ddl.create.CreateTable
-
Add timestamp with local time zone column
- TO_CHAR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Convert to character string
- TO_DATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Convert to date
- TO_DSINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Convert to interval with second precision
- TO_NUMBER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Convert to number
- TO_YMINTERVAL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Convert to timestamp +/ TO_TIMESTAMP, /** Convert to interval with month precision
- toBoolean() - Method in class com.exasol.sql.expression.literal.BooleanLiteral
-
Get boolean value this literal represents.
- toBooleanExpressions(boolean[]) - Static method in class com.exasol.sql.expression.literal.BooleanLiteral
-
Map an array of booleans to and array of BooleanExpressions
- toMillis() - Method in class com.exasol.datatype.value.IntervalDayToSecond
-
Get the interval as the total number of milliseconds between two points in time.
- toMonths() - Method in class com.exasol.datatype.value.IntervalYearToMonth
-
Get the interval as the total number of months between two points in time
- toString() - Method in class com.exasol.datatype.value.IntervalDayToSecond
- toString() - Method in class com.exasol.datatype.value.IntervalYearToMonth
- toString() - Method in enum com.exasol.sql.dql.select.JoinType
- toString() - Method in class com.exasol.sql.expression.ColumnReference
- toString() - Method in interface com.exasol.sql.expression.comparison.ComparisonOperator
-
Returns the operator symbol that represents the comparison.
- toString() - Method in enum com.exasol.sql.expression.comparison.LikeComparison.LikeComparisonOperator
- toString() - Method in enum com.exasol.sql.expression.comparison.SimpleComparisonOperator
- toString() - Method in class com.exasol.sql.expression.literal.BigDecimalLiteral
- toString() - Method in class com.exasol.sql.expression.literal.BooleanLiteral
- toString() - Method in class com.exasol.sql.expression.literal.DoubleLiteral
- toString() - Method in class com.exasol.sql.expression.literal.FloatLiteral
- toString() - Method in class com.exasol.sql.expression.literal.IntegerLiteral
- toString() - Method in class com.exasol.sql.expression.literal.LongLiteral
- toString() - Method in class com.exasol.sql.expression.literal.StringLiteral
- toString() - Method in enum com.exasol.sql.expression.predicate.BetweenPredicate.BetweenPredicateOperator
- toString() - Method in enum com.exasol.sql.expression.predicate.ExistsPredicate.ExistsPredicateOperator
- toString() - Method in enum com.exasol.sql.expression.predicate.InPredicate.InPredicateOperator
- toString() - Method in enum com.exasol.sql.expression.predicate.IsNullPredicate.IsNullPredicateOperator
- toString() - Method in interface com.exasol.sql.expression.predicate.PredicateOperator
-
Returns the predicate operator symbol.
- toString() - Method in class com.exasol.sql.UnnamedPlaceholder
- TRANSLATE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Replace characters in string
- TRIM - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Remove surrounding white spaces
- TRUNC - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Trim decimal places
- type(WindowFrameClause.WindowFrameType) - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause
-
Set the type of this
WindowFrameClause
.
U
- UCASE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Upper case
- udf(String, ColumnsDefinition, ValueExpression...) - Method in class com.exasol.sql.dql.select.Select
-
Add a User Defined Function.
- udf(String, ColumnsDefinition, ValueExpression...) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a User Defined Function.
- udf(String, ValueExpression...) - Method in class com.exasol.sql.dql.select.Select
-
Add a User Defined Function.
- udf(String, ValueExpression...) - Static method in class com.exasol.sql.expression.ExpressionTerm
-
Create a User Defined Function.
- UNBOUNDED_FOLLOWING - com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType
-
Unbounded following
- UNBOUNDED_PRECEDING - com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType
-
Unbounded preceding
- UNICODE - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Numeric unicode representation of character
- UNICODECHR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Character for numeric unicode
- unit(WindowFrameClause.UnitType) - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause
-
Set the unit type of this
WindowFrameClause
. - unit(ValueExpression, WindowFrameClause.UnitType) - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause
-
Set the unit type of this
WindowFrameClause
. - unitBetween(WindowFrameClause.UnitType, WindowFrameClause.UnitType) - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause
-
Set the unit type of this
WindowFrameClause
toBETWEEN ... AND ...
. - unitBetween(ValueExpression, WindowFrameClause.UnitType, ValueExpression, WindowFrameClause.UnitType) - Method in class com.exasol.sql.expression.function.exasol.WindowFrameClause
-
Set the unit type of this
WindowFrameClause
toBETWEEN ... AND ...
. - UnnamedPlaceholder - Class in com.exasol.sql
-
This class implements a nameless placeholder ("?") in an SQL statement
- UnnamedPlaceholder() - Constructor for class com.exasol.sql.UnnamedPlaceholder
- UPPER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Upper case
- useLowerCase() - Method in class com.exasol.sql.rendering.StringRendererConfig
-
Get whether the statements should be produced in lower case.
- useQuotes() - Method in class com.exasol.sql.rendering.StringRendererConfig
-
Get whether identifiers should be enclosed in double quotation marks.
- USER - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Current user
- using(String) - Method in class com.exasol.sql.dml.merge.Merge
-
Define the data source.
- using(String, String) - Method in class com.exasol.sql.dml.merge.Merge
-
Define the data source.
- UsingClause - Class in com.exasol.sql.dml.merge
-
The
USING
clause of an SQLMERGE
statement. - UsingClause(Fragment, String) - Constructor for class com.exasol.sql.dml.merge.UsingClause
-
Create a new instance of a
UsingClause
. - UsingClause(Fragment, String, String) - Constructor for class com.exasol.sql.dml.merge.UsingClause
-
Create a new instance of a
UsingClause
.
V
- value - Variable in class com.exasol.datatype.value.AbstractInterval
-
Interval value
- VALUE2PROC - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Number of the node a value is on
- valueExpression(ValueExpression) - Method in class com.exasol.sql.dql.select.Select
-
Add a value expression.
- valueExpression(ValueExpression, String) - Method in class com.exasol.sql.dql.select.Select
-
Add a value expression expression.
- ValueExpression - Interface in com.exasol.sql.expression
-
Common interface for all types of value expressions
- ValueExpressionRenderer - Class in com.exasol.sql.expression.rendering
-
Renderer for common value expressions.
- ValueExpressionRenderer(StringRendererConfig) - Constructor for class com.exasol.sql.expression.rendering.ValueExpressionRenderer
-
Create a new instance of
ValueExpressionRenderer
. - ValueExpressionVisitor - Interface in com.exasol.sql.expression
-
Visitor interface for a
BooleanTerm
. - valueOf(String) - Static method in enum com.exasol.sql.dql.select.JoinType
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.comparison.LikeComparison.LikeComparisonOperator
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.comparison.SimpleComparisonOperator
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.AnalyticFunction.Keyword
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAnalyticFunction
-
Deprecated.Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameExclusionType
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameType
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.predicate.BetweenPredicate.BetweenPredicateOperator
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.predicate.ExistsPredicate.ExistsPredicateOperator
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.predicate.InPredicate.InPredicateOperator
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum com.exasol.sql.expression.predicate.IsNullPredicate.IsNullPredicateOperator
-
Returns the enum constant of this type with the specified name.
- valuePlaceholder() - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Add an unnamed value placeholder to the value list (this is useful for prepared statements).
- valuePlaceholders(int) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Add a given number unnamed value placeholder to the value list (this is useful for prepared statements).
- values() - Static method in enum com.exasol.sql.dql.select.JoinType
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.BinaryArithmeticExpression.BinaryArithmeticOperator
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.comparison.LikeComparison.LikeComparisonOperator
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.comparison.SimpleComparisonOperator
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.function.exasol.AnalyticFunction.Keyword
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.function.exasol.ExasolAnalyticFunction
-
Deprecated.Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.function.exasol.WindowFrameClause.UnitType
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameExclusionType
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.function.exasol.WindowFrameClause.WindowFrameType
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.predicate.BetweenPredicate.BetweenPredicateOperator
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.predicate.ExistsPredicate.ExistsPredicateOperator
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.predicate.InPredicate.InPredicateOperator
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum com.exasol.sql.expression.predicate.IsNullPredicate.IsNullPredicateOperator
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values(int...) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Insert a list of integer values.
- values(ValueExpression...) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Insert a list of value expressions.
- values(String...) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Insert a list of string values.
- valueTable(ValueTable) - Method in class com.exasol.sql.dml.insert.AbstractInsertValueTable
-
Insert a value table.
- valueTable(ValueTable) - Method in class com.exasol.sql.dql.select.FromClause
-
Create a
FromClause
from a value table. - ValueTable - Class in com.exasol.sql
-
Value tables are pseudo-tables constructed from rows and columns of expressions (e.g.
- ValueTable(Fragment) - Constructor for class com.exasol.sql.ValueTable
-
Create a new
ValueTable
. - valueTableAs(ValueTable, String, String...) - Method in class com.exasol.sql.dql.select.FromClause
-
Create a
FromClause
from a value table and an alias. - ValueTableRow - Class in com.exasol.sql
-
This class represents a row in a
ValueTable
. - ValueTableRow(Fragment, ValueExpression...) - Constructor for class com.exasol.sql.ValueTableRow
-
Create a value table row from a list of expressions.
- ValueTableRow(Fragment, String...) - Constructor for class com.exasol.sql.ValueTableRow
-
Create a value table row from a list of string literals.
- ValueTableRow.Builder - Class in com.exasol.sql
-
Builder for
ValueTableRow
s - ValueTableVisitor - Interface in com.exasol.sql
-
Visitor for
ValueTable
. - VAR_POP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Variance of expr within a window or group of rows
- VAR_POP - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- VAR_SAMP - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Variance of expr within a window or group of rows
- VAR_SAMP - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- Varchar - Class in com.exasol.datatype.type
-
This class implements the Exasol-proprietary data type varchar
- Varchar(int) - Constructor for class com.exasol.datatype.type.Varchar
-
Create a new instance of an
Varchar
data type - varcharColumn(String, int) - Method in class com.exasol.sql.ColumnsDefinition.Builder
-
Add varchar column.
- varcharColumn(String, int) - Method in class com.exasol.sql.ddl.create.CreateTable
-
Add varchar column.
- VARIANCE - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction
-
Deprecated.Variance
- VARIANCE - com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions
-
See documentation.
- visit(Boolean) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
-
Visit a boolean column.
- visit(Boolean) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
- visit(Char) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
-
Visit a character column.
- visit(Char) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
- visit(Date) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
-
Visit a date column.
- visit(Date) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
- visit(Decimal) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
-
Visit a decimal column.
- visit(Decimal) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
- visit(DoublePrecision) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
-
Visit a double-precision floating point column.
- visit(DoublePrecision) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
- visit(IntervalDayToSecond) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
-
Visit an interval column with second precision.
- visit(IntervalDayToSecond) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
- visit(IntervalYearToMonth) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
-
Visit an interval column with month precision.
- visit(IntervalYearToMonth) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
- visit(Timestamp) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
-
Visit a timestamp column.
- visit(Timestamp) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
- visit(TimestampWithLocalTimezone) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
-
Visit a timestamp-with-local-timezone column.
- visit(TimestampWithLocalTimezone) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
- visit(Varchar) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
-
Visit a variable-length character column.
- visit(Varchar) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
- visit(Column) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
-
Visit a single column.
- visit(Column) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
- visit(ColumnsDefinition) - Method in interface com.exasol.sql.ColumnDefinitionVisitor
-
Visit a set of column definitions.
- visit(ColumnsDefinition) - Method in class com.exasol.sql.rendering.ColumnsDefinitionRenderer
- visit(CreateSchema) - Method in interface com.exasol.sql.ddl.create.CreateSchemaVisitor
-
Visit a
CREATE SCHEMA
statement. - visit(CreateSchema) - Method in class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer
- visit(CreateTable) - Method in interface com.exasol.sql.ddl.create.CreateTableVisitor
-
Visit a
CREATE TABLE
statement. - visit(CreateTable) - Method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer
- visit(Cascade) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor
-
Visit the
CASCADE
option. - visit(Cascade) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
- visit(CascadeConstraints) - Method in interface com.exasol.sql.ddl.drop.DropTableVisitor
-
Visit the
CASCADE CONSTRAINTS
option. - visit(CascadeConstraints) - Method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer
- visit(DropSchema) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor
-
Visit a
DROP SCHEMA
statement. - visit(DropSchema) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
- visit(DropTable) - Method in interface com.exasol.sql.ddl.drop.DropTableVisitor
-
Visit a
DROP TABLE
statement. - visit(DropTable) - Method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer
- visit(Restrict) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor
-
Visit the
RESTRICT
option. - visit(Restrict) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
- visit(Schema) - Method in interface com.exasol.sql.ddl.create.CreateSchemaVisitor
-
Visit the schema to be created.
- visit(Schema) - Method in class com.exasol.sql.ddl.create.rendering.CreateSchemaRenderer
- visit(Schema) - Method in interface com.exasol.sql.ddl.drop.DropSchemaVisitor
-
Visit the name of the schema to drop.
- visit(Schema) - Method in class com.exasol.sql.ddl.drop.rendering.DropSchemaRenderer
- visit(DerivedColumn) - Method in interface com.exasol.sql.dml.insert.InsertVisitor
-
Visit a derived column.
- visit(DerivedColumn) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
- visit(DerivedColumn) - Method in interface com.exasol.sql.dml.merge.MergeVisitor
-
Visit a derived column reference.
- visit(DerivedColumn) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- visit(DerivedColumn) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
- visit(DerivedColumn) - Method in interface com.exasol.sql.dql.select.SelectVisitor
-
Visit a derived column.
- visit(InsertFields) - Method in interface com.exasol.sql.dml.insert.InsertVisitor
-
Visit the list of fields to insert into.
- visit(InsertFields) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
- visit(InsertFields) - Method in interface com.exasol.sql.dml.merge.MergeVisitor
-
Visit the insert field list.
- visit(InsertFields) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- visit(MatchedClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor
-
Visit the definition of the merge strategy in case of matching rows.
- visit(MatchedClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- visit(Merge) - Method in interface com.exasol.sql.dml.merge.MergeVisitor
-
Visit
MERGE
statements. - visit(Merge) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- visit(MergeColumnUpdate) - Method in interface com.exasol.sql.dml.merge.MergeVisitor
-
Visit the update of a single column inside a
MERGE
statement. - visit(MergeColumnUpdate) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- visit(MergeDeleteClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor
-
Visit the deletion definition.
- visit(MergeDeleteClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- visit(MergeInsertClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor
-
Visit the insert definition.
- visit(MergeInsertClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- visit(MergeUpdateClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor
-
Visit the update definition.
- visit(MergeUpdateClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- visit(NotMatchedClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor
-
Visit the merge strategy in case of rows that have no match in the destination table.
- visit(NotMatchedClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- visit(OnClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor
-
Visit the merge condition definition.
- visit(OnClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- visit(UsingClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor
-
Visit the source definition of a
MERGE
statement. - visit(UsingClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- visit(FromClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
- visit(FromClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor
-
Visit the
FROM
clause. - visit(GroupByClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
- visit(GroupByClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor
-
Visit the
GROUP BY
clause. - visit(Join) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
- visit(Join) - Method in interface com.exasol.sql.dql.select.SelectVisitor
-
Visit the
JOIN
clause. - visit(LimitClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
- visit(LimitClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor
-
Visit the
LIMIT
clause. - visit(OrderByClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
- visit(OrderByClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor
-
Visit the
ORDER BY
clause. - visit(Select) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
- visit(Select) - Method in interface com.exasol.sql.dql.select.SelectVisitor
-
Visit the
SELECT
part of the statement. - visit(WhereClause) - Method in interface com.exasol.sql.dml.merge.MergeVisitor
-
Visit a
WHERE
clause. - visit(WhereClause) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- visit(WhereClause) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
- visit(WhereClause) - Method in interface com.exasol.sql.dql.select.SelectVisitor
-
Visit the
WHERE
clause. - visit(And) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
-
Visit a logical
AND
expression. - visit(And) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(BinaryArithmeticExpression) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(BinaryArithmeticExpression) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
-
Visit a binary arithmetic expression.
- visit(BooleanExpression) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(BooleanExpression) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
-
Visit a boolean expression.
- visit(ColumnReference) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(ColumnReference) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
-
Visit a column reference.
- visit(Comparison) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
-
Visit a comparison.
- visit(Comparison) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(LikeComparison) - Method in interface com.exasol.sql.expression.comparison.ComparisonVisitor
-
Visit a
LIKE
comparison. - visit(LikeComparison) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(SimpleComparison) - Method in interface com.exasol.sql.expression.comparison.ComparisonVisitor
-
Visit a simple comparison (e.g.
- visit(SimpleComparison) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(DefaultValue) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(DefaultValue) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
-
Visit a default value.
- visit(AnalyticFunction) - Method in interface com.exasol.sql.expression.function.FunctionVisitor
-
Visit an analytic function.
- visit(AnalyticFunction) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(CastExasolFunction) - Method in interface com.exasol.sql.expression.function.FunctionVisitor
-
Visit an explicit cast.
- visit(CastExasolFunction) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(ExasolFunction) - Method in interface com.exasol.sql.expression.function.FunctionVisitor
-
Visit a built-in Exasol function.
- visit(ExasolFunction) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
-
Function visitor
- visit(ExasolUdf) - Method in interface com.exasol.sql.expression.function.FunctionVisitor
-
Visit an Exasol user-defined function (UDF).
- visit(ExasolUdf) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(Function) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(Function) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
-
Visit a function.
- visit(BigDecimalLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
-
Visit a big decimal literal.
- visit(BigDecimalLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(BooleanLiteral) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
-
Visit a boolean literal.
- visit(BooleanLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
-
Visit a boolean literal.
- visit(BooleanLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(DoubleLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
-
Visit a double-precision floating point literal.
- visit(DoubleLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(FloatLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
-
Visit a single-precision floating point literal.
- visit(FloatLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(IntegerLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
-
Visit an integer literal.
- visit(IntegerLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(Literal) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(Literal) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
-
Visit a literal.
- visit(LongLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
-
Visit a long integer literal.
- visit(LongLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(NullLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
-
Visit a literal null.
- visit(NullLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(StringLiteral) - Method in interface com.exasol.sql.expression.literal.LiteralVisitor
-
Visit a string literal.
- visit(StringLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
-
Literal visitor
- visit(Not) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
-
Visit a unary
NOT
expression. - visit(Not) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(Or) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
-
Visit a logical
OR
expression. - visit(Or) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(BetweenPredicate) - Method in interface com.exasol.sql.expression.predicate.PredicateVisitor
-
Visit a value-between predicate.
- visit(BetweenPredicate) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(ExistsPredicate) - Method in interface com.exasol.sql.expression.predicate.PredicateVisitor
-
Visit a value-exists predicate.
- visit(ExistsPredicate) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(InPredicate) - Method in interface com.exasol.sql.expression.predicate.PredicateVisitor
-
Visit a value-in-constant-list predicate.
- visit(InPredicate) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(IsNullPredicate) - Method in interface com.exasol.sql.expression.predicate.PredicateVisitor
-
Visit an is-null predicate.
- visit(IsNullPredicate) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(Predicate) - Method in interface com.exasol.sql.expression.BooleanExpressionVisitor
-
Visit a predicate.
- visit(Predicate) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(ValueExpression...) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
-
Visit a value expression.
- visit(SqlStatement) - Method in interface com.exasol.sql.dml.insert.InsertVisitor
-
Visit an
INSERT
statement. - visit(SqlStatement) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
- visit(Table) - Method in interface com.exasol.sql.ddl.create.CreateTableVisitor
-
Visit the table to be created.
- visit(Table) - Method in class com.exasol.sql.ddl.create.rendering.CreateTableRenderer
- visit(Table) - Method in interface com.exasol.sql.ddl.drop.DropTableVisitor
-
Visit the
TABLE
to be dropped. - visit(Table) - Method in class com.exasol.sql.ddl.drop.rendering.DropTableRenderer
- visit(Table) - Method in interface com.exasol.sql.dml.insert.InsertVisitor
-
Visit the table to insert into.
- visit(Table) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
- visit(Table) - Method in interface com.exasol.sql.dml.merge.MergeVisitor
-
Visit database tables.
- visit(Table) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- visit(Table) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
- visit(Table) - Method in interface com.exasol.sql.dql.select.SelectVisitor
-
Visit a table.
- visit(UnnamedPlaceholder) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
- visit(UnnamedPlaceholder) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor
-
Visit an unnamed placeholder.
- visit(ValueTable) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
- visit(ValueTable) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- visit(ValueTable) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
- visit(ValueTable) - Method in interface com.exasol.sql.ValueTableVisitor
-
Visit a value table.
- visit(ValueTableRow) - Method in class com.exasol.sql.dml.insert.rendering.InsertRenderer
- visit(ValueTableRow) - Method in class com.exasol.sql.dml.merge.rendering.MergeRenderer
- visit(ValueTableRow) - Method in class com.exasol.sql.dql.select.rendering.SelectRenderer
- visit(ValueTableRow) - Method in interface com.exasol.sql.ValueTableVisitor
-
Visit a row in a value table.
- visit(List<ValueExpression>) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer
-
Visit expressions.
W
- WEEK - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Week part of a date
- whenMatched() - Method in class com.exasol.sql.dml.merge.Merge
-
Define the merge strategy if the match criteria is met.
- whenNotMatched() - Method in class com.exasol.sql.dml.merge.Merge
-
Define the merge strategy if the match criteria is not met.
- where - Variable in class com.exasol.sql.dml.merge.MergeInsertClause
-
WHERE
clause - where - Variable in class com.exasol.sql.dml.merge.MergeMethodDefinition
-
WHERE
clause - where(BooleanExpression) - Method in class com.exasol.sql.dml.merge.MergeInsertClause
-
Add a
WHERE
clause insertion definition. - where(BooleanExpression) - Method in class com.exasol.sql.dml.merge.MergeMethodDefinition
-
Add a
WHERE
clauseMERGE
definition. - where(BooleanExpression) - Method in class com.exasol.sql.dql.select.Select
-
Create a new
WhereClause
. - WhereClause - Class in com.exasol.sql.dql.select
-
This class represents the where clause of an SQL statement.
- WhereClause(SqlStatement, BooleanExpression) - Constructor for class com.exasol.sql.dql.select.WhereClause
-
Create a new instance of a
WhereClause
- windowFrame(UnaryOperator<WindowFrameClause>) - Method in class com.exasol.sql.expression.function.exasol.OverClause
-
Set and configure the
WindowFrameClause
for thisOverClause
. - WindowFrameClause - Class in com.exasol.sql.expression.function.exasol
-
This represents a window frame clause of an analytic function in Exasol.
- WindowFrameClause.UnitType - Enum in com.exasol.sql.expression.function.exasol
-
Represents a unit type.
- WindowFrameClause.WindowFrameExclusionType - Enum in com.exasol.sql.expression.function.exasol
-
Represents the type of a window frame exclusion.
- WindowFrameClause.WindowFrameType - Enum in com.exasol.sql.expression.function.exasol
-
Window frame clause
- WindowFrameClause.WindowFrameUnitClause - Class in com.exasol.sql.expression.function.exasol
-
Represents a window frame unit.
- windowName(String) - Method in class com.exasol.sql.expression.function.exasol.OverClause
-
Set the window name for this
OverClause
.
Y
- YEAR - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Year part of a date
- YEARS_BETWEEN - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Years between two dates
Z
- ZEROIFNULL - com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
Zero if null
All Classes All Packages