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

A

AbstractBooleanExpression - Class in com.exasol.sql.expression

Abstract base class for all types of BooleanExpressions

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

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

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

AbstractBottomUpTreeNode - Class in com.exasol.util

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

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

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

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

Create a new instance of a AbstractBottomUpTreeNode.

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

Create a new instance of a AbstractBottomUpTreeNode.

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

Common base class for expression renderers

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

AbstractFragment - Class in com.exasol.sql

Common base class for SQL statement fragments

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

Create an instance of an SQL fragment

AbstractFragmentRenderer - Class in com.exasol.sql.rendering

Abstract base class for SQL fragment renderers

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

AbstractInterval - Class in com.exasol.datatype.value

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

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

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

Implements common logic for String data types

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

AbstractTreeNode - Class in com.exasol.util

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

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

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

AbstractValueExpression - Class in com.exasol.sql.expression

Abstract base class for all types of value expressions

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

Create a new instance of a AbstractValueExpression

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Accept a visitor (e.g.

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

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

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

Accept a visitor (e.g.

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

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

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

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

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

Accept a visitor (e.g.

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

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

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

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

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

Accept a visitor

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

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

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

Accept a visitor

accept(FragmentVisitor) - Method in class com.exasol.sql.Field

accept(FragmentVisitor) - Method in interface com.exasol.sql.GenericFragment

Accept a generic fragment visitor

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

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

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

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

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

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

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

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

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

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

Add a new column to the ColumnsDefinition

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

Adds values to the last row of the value table

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

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

Add one or more string literals to the row

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

Add one or more integer literals to the row

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

Add a list of expressions to the ValueTableRow

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

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

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

Add a child node below this node.

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

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

Add an UnnamedPlaceholder to the row.

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

Add a wildcard field for all involved fields.

And - Class in com.exasol.sql.expression

This class represents

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

Create a new And instance

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

Create a new And instance

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Append a ValueTableRow to the ValueTable

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

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

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

B

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.ddl.CreateTable

Add boolean column

BooleanExpression - Interface in com.exasol.sql.expression

Common interface for all types of boolean expressions

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

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

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

BooleanExpressionVisitor - Interface in com.exasol.sql.expression

Visitor interface for a BooleanTerm

BooleanLiteral - Class in com.exasol.sql.expression

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

BooleanTerm - Class in com.exasol.sql.expression

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

Build a new ValueTableRow

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

Create a new instance of a StringRendererConfig

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

Get a ValueTableRow.Builder for a ValueTableRow

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

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

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

Get a builder for StringRendererConfig

C

Char - Class in com.exasol.datatype.type

This class implements the SQL data type char

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

Create a new instance of an Char data type

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

Add char column

Column - Class in com.exasol.sql

This class represents a column in an SQL statement.

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

Create a new instance of a Column

ColumnsDefinition - Class in com.exasol.sql.ddl

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

Create an new instance of ColumnsDefinition

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.rendering - package com.exasol.sql.ddl.rendering

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

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

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

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

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

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(String, String, String) - Static method in class com.exasol.sql.expression.BooleanTerm

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

Comparison - Class in com.exasol.sql.expression

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

ComparisonOperator - Enum in com.exasol.sql.expression

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

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

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

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

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

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

Create an CreateTableRenderer using the default renderer configuration

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

Create an CreateTableRenderer

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

Create an InsertRenderer using the default renderer configuration

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

Create an InsertRenderer

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

Create an SelectRenderer using the default renderer configuration

create(StringRendererConfig) - Static method in class com.exasol.sql.dql.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

CreateTable - Class in com.exasol.sql.ddl

This class implements an SQL CreateTable statement

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

Create a new instance of an CreateTable statement

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

Create a CreateTable statement

CreateTableFragment - Interface in com.exasol.sql.ddl

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

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

The CreateTableRenderer turns SQL statement structures in to SQL strings.

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

Create a new CreateTableRenderer with custom render settings.

CreateTableVisitor - Interface in com.exasol.sql.ddl

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.ddl.CreateTable

Add date column

Decimal - Class in com.exasol.datatype.type

This class implements the Exasol-proprietary data type decimal

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

Create a new instance of an Decimal data type

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

Add decimal column

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

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

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

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

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

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

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

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.ddl.CreateTable

Add double precision column

E

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

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

F

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

Define fields into which should be inserted

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

Add one or more named fields.

Field - Class in com.exasol.sql

This class represents a table field in an SQL statement.

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

Create a new instance of a Field

Fragment - Interface in com.exasol.sql

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

FragmentRenderer - Interface in com.exasol.sql.rendering

FragmentVisitor - Interface in com.exasol.sql

This interface represents a visitor for SQL statement fragments.

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

Get the FromClause of this select statement

FromClause - Class in com.exasol.sql.dql

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

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

Create a new instance of a FromClause

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

Create a new full Join that belongs to a FROM clause

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

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

G

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

GenericFragment - Interface in com.exasol.sql

Common interface for all SQL statement fragments which are used in multiple types of statements, like tables and fields.

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

Get the correlation name (i.e.

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

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

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

Get child node by position in the list of siblings.

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

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

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

Get all child nodes of this node

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

Get the column name

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

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

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

Get the maximum number of rows to be handed back

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

Get the column data type

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

Get the boolean expression defining the filter criteria

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

Get the list of expressions the row consists of

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

Get an instance of a StatementFactory

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

Get the left-hand side operator of the comparison

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

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.dql.Join

Get the name of the joined table

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

Get the field name

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

Get the name of the table

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

Get the offset row for the limit

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

Get the comparison operator

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

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

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

Get the parent of this node

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

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

Get the right-hand side operator of the comparison

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

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

Get the root statement of this SQL fragment

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

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

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

Get the root of the tree

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

Get a list of all rows in the value table

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

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

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

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

Get the join specification

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

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

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

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

Get the type of the join

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

Get the value of the IntegerLiteral

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

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

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

H

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

Check if the limit clause has an offset

I

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

Create a new inner Join that belongs to a FROM clause

Insert - Class in com.exasol.sql.dml

This class implements an SQL Select statement

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

Create a new instance of an Insert statement

InsertFields - Class in com.exasol.sql.dml

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

Create an new instance of InsertFields

InsertFragment - Interface in com.exasol.sql.dml

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

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

Create an Insert statement

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

The InsertRenderer turns SQL statement structures in to SQL strings.

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

Create a new InsertRenderer with custom render settings.

InsertVisitor - Interface in com.exasol.sql.dml

IntegerLiteral - Class in com.exasol.sql.expression

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

IntervalDayToSecond - Class in com.exasol.datatype.type

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

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

Create a new instance of an IntervalDayToSecond data type

IntervalDayToSecond - Class in com.exasol.datatype.value

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

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

Add interval day to second column

IntervalYearToMonth - Class in com.exasol.datatype.type

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

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

Create a new instance of an IntervalYearToMonth data type

IntervalYearToMonth - Class in com.exasol.datatype.value

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

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

Add interval year to month column

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

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

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

Check whether this node is a child node

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

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

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

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

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

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

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

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

Check whether this node is the root of the tree.

J

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

Create a new Join that belongs to a FROM clause

Join - Class in com.exasol.sql.dql

This class implements the Join part of a WHERE clause.

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

Create a new Join instance

JoinType - Enum in com.exasol.sql.dql

This class represents the Join types supported by SQL.

L

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Create a new left Join that belongs to a FROM clause

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

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

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

Create a new full outer LimitClause

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

Create a new full outer LimitClause

LimitClause - Class in com.exasol.sql.dql

This class represents the limit clause of an SQL statement.

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

Create a new instance of a LimitClause

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

Create a new instance of a LimitClause

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

Define whether the statement should be produced in lower case

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

N

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

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

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

Not - Class in com.exasol.sql.expression

This class implements the logical unary NOT

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

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

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

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

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

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

O

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

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

Create a new BooleanLiteral instance from a String

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

Create a new IntegerLiteral from an integer

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

Create a new StringLiteral from a string

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

Create an IntervalDayToSecond from a number of milliseconds

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

Create an IntervalDayToSecond from a number of months

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

Get the ComparisonOperator for the provided symbol

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

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

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

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

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

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

Or - Class in com.exasol.sql.expression

This class represents

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

Create a new Or instance

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

Create a new Or instance

P

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

Parse an IntervalDayToSecond from a string

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

Parse an IntervalDayToSecond from a string

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

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

Q

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

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

R

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

Render expression to a string

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

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

Render an SQL statement to a string.

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

Create a new right Join that belongs to a FROM clause

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

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

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

S

Select - Class in com.exasol.sql.dql

This class implements an SQL Select statement

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

Create a new instance of a Select

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

Create a Select statement

SelectFragment - Interface in com.exasol.sql.dql

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

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

The SelectRenderer turns SQL statement structures in to SQL strings.

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

Create a new SelectRenderer with custom render settings.

SelectVisitor - Interface in com.exasol.sql.dql

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

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

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

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

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

Link to a parent node

SqlStatement - Interface in com.exasol.sql

This interface represents an SQL statement.

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

StatementFactory - Class in com.exasol.sql

The StatementFactory implements an factory for SQL statements.

StringLiteral - Class in com.exasol.sql.expression

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

StringRendererConfig - Class in com.exasol.sql.rendering

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

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

Builder for StringRendererConfig

T

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

Add a table name to the FromClause

Table - Class in com.exasol.sql

This class 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.FromClause

Add a table name with an an alias to the FromClause

TableReference - Interface in com.exasol.sql

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.ddl.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.ddl.CreateTable

Add timestamp with local time zone column

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

Get boolean value this literal represents.

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

Map an array of booleans to and array of BooleanExpressions

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

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

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

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

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

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

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

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

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

Returns the operator symbol that represents the comparison.

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

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

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

TreeNode - Interface in com.exasol.util

This class represents a node in a tree structure.

U

UnnamedPlaceholder - Class in com.exasol.sql

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

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

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

Get whether the statements should be produced in lower case.

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

Get whether identifiers should be enclosed in double quotation marks.

V

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

ValueExpression - Interface in com.exasol.sql.expression

Common interface for all types of value expressions

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

Renderer for common value expressions

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

ValueExpressionVisitor - Interface in com.exasol.sql.expression

Visitor interface for a BooleanTerm

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

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

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

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

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

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

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

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

Insert a list of string values

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

Insert a list of integer values

values() - Static method in enum com.exasol.sql.dql.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.ComparisonOperator

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

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

Insert a value table

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

Create a FromClause from a value table

ValueTable - Class in com.exasol.sql.dql

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

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

Create a new ValueTable

ValueTableRow - Class in com.exasol.sql.dql

This class represents a row in a ValueTable.

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

Create a value table row from a list of expressions

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

Create a value table row from a list of string literals

ValueTableRow.Builder - Class in com.exasol.sql.dql

Builder for ValueTableRows

ValueTableVisitor - Interface in com.exasol.sql

Varchar - Class in com.exasol.datatype.type

This class implements the Exasol-proprietary data type varchar

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

Create a new instance of an Varchar data type

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

Add varchar column

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

visit(Insert) - Method in interface com.exasol.sql.dml.InsertVisitor

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

visit(Insert) - Method in class com.exasol.sql.dml.rendering.InsertRenderer

visit(Table) - Method in class com.exasol.sql.dml.rendering.InsertRenderer

visit(Field) - Method in class com.exasol.sql.dml.rendering.InsertRenderer

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

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

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

visit(Select) - Method in class com.exasol.sql.dql.rendering.SelectRenderer

visit(Field) - Method in class com.exasol.sql.dql.rendering.SelectRenderer

visit(FromClause) - Method in class com.exasol.sql.dql.rendering.SelectRenderer

visit(Table) - Method in class com.exasol.sql.dql.rendering.SelectRenderer

visit(Join) - Method in class com.exasol.sql.dql.rendering.SelectRenderer

visit(WhereClause) - Method in class com.exasol.sql.dql.rendering.SelectRenderer

visit(LimitClause) - Method in class com.exasol.sql.dql.rendering.SelectRenderer

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

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

visit(Select) - Method in interface com.exasol.sql.dql.SelectVisitor

visit(FromClause) - Method in interface com.exasol.sql.dql.SelectVisitor

visit(Join) - Method in interface com.exasol.sql.dql.SelectVisitor

visit(LimitClause) - Method in interface com.exasol.sql.dql.SelectVisitor

visit(WhereClause) - Method in interface com.exasol.sql.dql.SelectVisitor

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

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

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

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

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

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

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

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

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

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

visit(StringLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(IntegerLiteral) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(UnnamedPlaceholder) - Method in class com.exasol.sql.expression.rendering.ValueExpressionRenderer

visit(UnnamedPlaceholder) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(StringLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(IntegerLiteral) - Method in interface com.exasol.sql.expression.ValueExpressionVisitor

visit(Field) - Method in interface com.exasol.sql.FragmentVisitor

visit(Table) - Method in interface com.exasol.sql.FragmentVisitor

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

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

W

where(BooleanExpression) - Method in class com.exasol.sql.dql.Select

Create a new WhereClause

WhereClause - Class in com.exasol.sql.dql

This class represents the where clause of an SQL statement.

WhereClause(SqlStatement, BooleanExpression) - Constructor for class com.exasol.sql.dql.WhereClause

Create a new instance of a WhereClause

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