Uses of Interface
com.exasol.sql.expression.ValueExpression

Packages that use ValueExpression

Package	Description
com.exasol.sql
com.exasol.sql.dml.insert
com.exasol.sql.dml.merge
com.exasol.sql.dql.select
com.exasol.sql.expression
com.exasol.sql.expression.comparison
com.exasol.sql.expression.function
com.exasol.sql.expression.function.exasol
com.exasol.sql.expression.literal
com.exasol.sql.expression.predicate
com.exasol.sql.expression.rendering
com.exasol.sql.rendering

Uses of ValueExpression in com.exasol.sql

Classes in com.exasol.sql that implement ValueExpression

Modifier and Type	Class	Description
class	UnnamedPlaceholder	This class implements a nameless placeholder ("?") in an SQL statement

Methods in com.exasol.sql that return ValueExpression

Modifier and Type	Method	Description
ValueExpression	DerivedColumn.getValueExpression()	Get a value expression that belongs to this derived column.

Methods in com.exasol.sql that return types with arguments of type ValueExpression

Modifier and Type	Method	Description
List<ValueExpression>	ValueTableRow.getExpressions()	Get the list of expressions the row consists of.

Methods in com.exasol.sql with parameters of type ValueExpression

Modifier and Type	Method	Description
void	ValueTable.add(ValueExpression... expressions)	Add a list of value expressions to the last row of the value table.

Method parameters in com.exasol.sql with type arguments of type ValueExpression

Modifier and Type	Method	Description
ValueTableRow.Builder	ValueTableRow.Builder.add(List<ValueExpression> expressions)	Add a list of expressions to the ValueTableRow.

Constructors in com.exasol.sql with parameters of type ValueExpression

Constructor	Description
DerivedColumn(Fragment root, ValueExpression valueExpression)	Create a new instance of a DerivedColumn.
DerivedColumn(Fragment root, ValueExpression valueExpression, String derivedColumnName)	Create a new instance of a DerivedColumn.
ValueTableRow(Fragment root, ValueExpression... expressions)	Create a value table row from a list of expressions.

Uses of ValueExpression in com.exasol.sql.dml.insert

Methods in com.exasol.sql.dml.insert with parameters of type ValueExpression

Modifier and Type	Method	Description
T	AbstractInsertValueTable.values(ValueExpression... expressions)	Insert a list of value expressions.

Uses of ValueExpression in com.exasol.sql.dml.merge

Methods in com.exasol.sql.dml.merge that return ValueExpression

Modifier and Type	Method	Description
ValueExpression	MergeColumnUpdate.getExpression()	Get the expression that serves as the value for the update.

Methods in com.exasol.sql.dml.merge with parameters of type ValueExpression

Modifier and Type	Method	Description
MergeUpdateClause	MergeUpdateClause.set(String column, ValueExpression expression)	Update a column with a value expression.

Constructors in com.exasol.sql.dml.merge with parameters of type ValueExpression

Constructor	Description
MergeColumnUpdate(Fragment root, String column, ValueExpression expression)	Create a new instance of a MergeColumnUpdate.

Uses of ValueExpression in com.exasol.sql.dql.select

Methods in com.exasol.sql.dql.select with parameters of type ValueExpression

Modifier and Type	Method	Description
Select	Select.function(FunctionName functionName, ValueExpression... valueExpressions)	Add a function.
Select	Select.function(FunctionName functionName, String derivedColumnName, ValueExpression... valueExpressions)	Add a function.
Select	Select.udf(String functionName, ColumnsDefinition emitsColumnsDefinition, ValueExpression... valueExpressions)	Add a User Defined Function.
Select	Select.udf(String functionName, ValueExpression... valueExpressions)	Add a User Defined Function.
Select	Select.valueExpression(ValueExpression valueExpression)	Add a value expression.
Select	Select.valueExpression(ValueExpression valueExpression, String derivedColumnName)	Add a value expression expression.

Uses of ValueExpression in com.exasol.sql.expression

Subinterfaces of ValueExpression in com.exasol.sql.expression

Modifier and Type	Interface	Description
interface	BooleanExpression	Common interface for all types of boolean expressions

Classes in com.exasol.sql.expression that implement ValueExpression

Modifier and Type	Class	Description
class	AbstractBooleanExpression	Abstract base class for all types of BooleanExpressions.
class	And	This class represents a logical AND predicate.
class	BinaryArithmeticExpression	This class represents a binary arithmetic expression.
class	BooleanTerm	This class represents boolean terms like AND or NOT.
class	ColumnReference	This class represents column reference.
class	DefaultValue	The DefaultValue is an expression that tells the database to take the default value for a column (in case it is defined).
class	Not	This class implements the logical unary NOT predicate.
class	Or	This class represents a logical OR predicate.

Methods in com.exasol.sql.expression that return ValueExpression

Modifier and Type	Method	Description
static ValueExpression	DefaultValue.defaultValue()	Create a default value expression.
ValueExpression	BinaryArithmeticExpression.getLeft()	Get a left operand of the arithmetic expression.
ValueExpression	BinaryArithmeticExpression.getRight()	Get a right operand of the arithmetic expression.

Methods in com.exasol.sql.expression with parameters of type ValueExpression

Modifier and Type	Method	Description
static BooleanExpression	BooleanTerm.between(ValueExpression expression, ValueExpression start, ValueExpression end)	Check if value is between two other values.
static BooleanExpression	BooleanTerm.compare(ValueExpression left, SimpleComparisonOperator operator, ValueExpression right)	General comparison with operator enum.
static BooleanExpression	BooleanTerm.compare(ValueExpression left, String operatorSymbol, ValueExpression right)	General comparison with operator as string.
static BinaryArithmeticExpression	ExpressionTerm.divide(ValueExpression left, ValueExpression right)	Create a binary arithmetic expression with DIVIDE operator.
static BooleanExpression	BooleanTerm.eq(ValueExpression left, ValueExpression right)	Equality comparison.
static Function	ExpressionTerm.function(FunctionName functionName, ValueExpression... valueExpressions)	Create an Exasol function.
static BooleanExpression	BooleanTerm.ge(ValueExpression left, ValueExpression right)	Greater-than-or-equal comparison.
static BooleanExpression	BooleanTerm.gt(ValueExpression left, ValueExpression right)	Greater-than comparison.
static BooleanExpression	BooleanTerm.in(ValueExpression operand, Select select)	Check for value sub-select.
static BooleanExpression	BooleanTerm.in(ValueExpression toFind, ValueExpression... inList)	Check for value in list.
static BooleanExpression	BooleanTerm.isNotNull(ValueExpression operand)	Check for not null.
static BooleanExpression	BooleanTerm.isNull(ValueExpression operand)	Check for null.
static BooleanExpression	BooleanTerm.le(ValueExpression left, ValueExpression right)	Less-than-or-equal comparison.
static BooleanExpression	BooleanTerm.like(ValueExpression left, ValueExpression right)	Comparison with LIKE operator.
static BooleanExpression	BooleanTerm.like(ValueExpression left, ValueExpression right, char escape)	Comparison with LIKE operator.
static BooleanExpression	BooleanTerm.lt(ValueExpression left, ValueExpression right)	Less-than comparison.
static BinaryArithmeticExpression	ExpressionTerm.minus(ValueExpression left, ValueExpression right)	Create a binary arithmetic expression with SUBTRACT operator.
static BinaryArithmeticExpression	ExpressionTerm.multiply(ValueExpression left, ValueExpression right)	Create a binary arithmetic expression with DIVIDE operator.
static BooleanExpression	BooleanTerm.ne(ValueExpression left, ValueExpression right)	Not-equal comparison.
static BooleanExpression	BooleanTerm.notBetween(ValueExpression expression, ValueExpression start, ValueExpression end)	Check if value is not between two other values.
static BooleanExpression	BooleanTerm.notIn(ValueExpression operand, Select select)	Check if value not in sub-select.
static BooleanExpression	BooleanTerm.notIn(ValueExpression toFind, ValueExpression... inList)	Check if value not in list.
static BooleanExpression	BooleanTerm.notLike(ValueExpression left, ValueExpression right)	Comparison with inverted LIKE operator.
static BooleanExpression	BooleanTerm.notLike(ValueExpression left, ValueExpression right, char escape)	Comparison with inverted LIKE operator.
static BinaryArithmeticExpression	BinaryArithmeticExpression.of(BinaryArithmeticExpression.BinaryArithmeticOperator operator, ValueExpression left, ValueExpression right)	Create a new BinaryArithmeticExpression instance.
static BinaryArithmeticExpression	ExpressionTerm.plus(ValueExpression left, ValueExpression right)	Create a binary arithmetic expression with ADD operator.
static Function	ExpressionTerm.udf(String functionName, ColumnsDefinition emitsColumnsDefinition, ValueExpression... valueExpressions)	Create a User Defined Function.
static Function	ExpressionTerm.udf(String functionName, ValueExpression... valueExpressions)	Create a User Defined Function.

Uses of ValueExpression in com.exasol.sql.expression.comparison

Subinterfaces of ValueExpression in com.exasol.sql.expression.comparison

Modifier and Type	Interface	Description
interface	Comparison	Interface for classes that implement comparisons between two columns.

Classes in com.exasol.sql.expression.comparison that implement ValueExpression

Modifier and Type	Class	Description
class	AbstractComparison	Abstract basis for comparisons.
class	LikeComparison	This class represents a LIKE comparison.
class	SimpleComparison	This class implements all simple comparison operators.

Fields in com.exasol.sql.expression.comparison declared as ValueExpression

Modifier and Type	Field	Description
protected ValueExpression	AbstractComparison.leftOperand	left part of the comparison
protected ValueExpression	AbstractComparison.rightOperand	right part of the comparison

Methods in com.exasol.sql.expression.comparison that return ValueExpression

Modifier and Type	Method	Description
ValueExpression	AbstractComparison.getLeftOperand()	Get the left-hand side operator of the comparison
ValueExpression	Comparison.getLeftOperand()	Get the left-hand side operator of the comparison
ValueExpression	AbstractComparison.getRightOperand()	Get the right-hand side operator of the comparison
ValueExpression	Comparison.getRightOperand()	Get the right-hand side operator of the comparison

Methods in com.exasol.sql.expression.comparison with parameters of type ValueExpression

Modifier and Type	Method	Description
LikeComparison.Builder	LikeComparison.Builder.left(ValueExpression left)	Add the left operand.
LikeComparison.Builder	LikeComparison.Builder.right(ValueExpression right)	Add the right operand.

Constructors in com.exasol.sql.expression.comparison with parameters of type ValueExpression

Constructor	Description
AbstractComparison(ComparisonOperator comparisonOperator, ValueExpression leftOperand, ValueExpression rightOperand)	Create a new instance of AbstractComparison.
SimpleComparison(SimpleComparisonOperator comparisonOperator, ValueExpression leftOperand, ValueExpression rightOperand)	Create a new instance of SimpleComparison.

Uses of ValueExpression in com.exasol.sql.expression.function

Subinterfaces of ValueExpression in com.exasol.sql.expression.function

Modifier and Type	Interface	Description
interface	Function	This class represents a function in an SQL statement.

Classes in com.exasol.sql.expression.function that implement ValueExpression

Modifier and Type	Class	Description
class	AbstractFunction	This is a base class for functions.

Fields in com.exasol.sql.expression.function with type parameters of type ValueExpression

Modifier and Type	Field	Description
protected List<ValueExpression>	AbstractFunction.parameters	Function parameters

Methods in com.exasol.sql.expression.function that return types with arguments of type ValueExpression

Modifier and Type	Method	Description
List<ValueExpression>	AbstractFunction.getParameters()	Get the value expressions (parameters of the function)

Constructor parameters in com.exasol.sql.expression.function with type arguments of type ValueExpression

Constructor	Description
AbstractFunction(String functionName, List<ValueExpression> parameters)	Create a new instance using AbstractFunction.

Uses of ValueExpression in com.exasol.sql.expression.function.exasol

Classes in com.exasol.sql.expression.function.exasol that implement ValueExpression

Modifier and Type	Class	Description
class	AnalyticFunction	This class represents an analytic function in the Exasol database that supports keywords DISTINCT and ALL and the over clause.
class	CastExasolFunction	This class represents the Exasol CAST function.
class	ExasolFunction	This class represents a function in the Exasol database.
class	ExasolUdf	This class represents a User Defined Function in the Exasol database.

Methods in com.exasol.sql.expression.function.exasol that return ValueExpression

Modifier and Type	Method	Description
ValueExpression	WindowFrameClause.WindowFrameUnitClause.getExpression()	Get the expression.
ValueExpression	CastExasolFunction.getValue()	Get the value to cast.

Methods in com.exasol.sql.expression.function.exasol that return types with arguments of type ValueExpression

Modifier and Type	Method	Description
List<ValueExpression>	OverClause.getPartitionByColumns()	Get the columns of the partition by clause of this OverClause.

Methods in com.exasol.sql.expression.function.exasol with parameters of type ValueExpression

Modifier and Type	Method	Description
static AnalyticFunction	AnalyticFunction.of(ExasolAnalyticAggregateFunctions functionName, ValueExpression... valueExpressions)	Create a new AnalyticFunction instance.
static CastExasolFunction	CastExasolFunction.of(ValueExpression valueExpression, DataType type)	Create a new CastExasolFunction instance.
static ExasolFunction	ExasolFunction.of(FunctionName functionName, ValueExpression... valueExpressions)	Create a new ExasolFunction instance.
static ExasolUdf	ExasolUdf.of(String functionName, ColumnsDefinition emitsColumnsDefinition, ValueExpression... valueExpressions)	Create a new ExasolUdf instance.
static ExasolUdf	ExasolUdf.of(String functionName, ValueExpression... valueExpressions)	Create a new ExasolUdf instance.
OverClause	OverClause.partitionBy(ValueExpression... columns)	Set the columns for the PARTITION BY clause of this OverClause.
WindowFrameClause	WindowFrameClause.unit(ValueExpression expression, WindowFrameClause.UnitType unitType)	Set the unit type of this WindowFrameClause.
WindowFrameClause	WindowFrameClause.unitBetween(ValueExpression expression1, WindowFrameClause.UnitType unitType1, ValueExpression expression2, WindowFrameClause.UnitType unitType2)	Set the unit type of this WindowFrameClause to BETWEEN ... AND ....

Uses of ValueExpression in com.exasol.sql.expression.literal

Subinterfaces of ValueExpression in com.exasol.sql.expression.literal

Modifier and Type	Interface	Description
interface	Literal	Interface for classes that represent literal values.

Classes in com.exasol.sql.expression.literal that implement ValueExpression

Modifier and Type	Class	Description
class	AbstractLiteral	Abstract basis for Literals.
class	BigDecimalLiteral	This class represents BigDecimal literals.
class	BooleanLiteral	This class represents boolean literals (read "true" and "false")
class	DoubleLiteral	This class represents double literals.
class	FloatLiteral	This class represents float literals.
class	IntegerLiteral	This class represents integer literals.
class	LongLiteral	This class represents long literals.
class	NullLiteral	This class represents a null literal.
class	StringLiteral	This class represents string literals (or character literals in SQL terms).

Uses of ValueExpression in com.exasol.sql.expression.predicate

Subinterfaces of ValueExpression in com.exasol.sql.expression.predicate

Modifier and Type	Interface	Description
interface	Predicate	Interface for classes that implement predicate expressions.

Classes in com.exasol.sql.expression.predicate that implement ValueExpression

Modifier and Type	Class	Description
class	AbstractPredicate	An abstract basis for predicate classes.
class	BetweenPredicate	A class that represents a [NOT] BETWEEN predicate.
class	ExistsPredicate	A class that represents a EXISTS predicate.
class	InPredicate	A class that represents a [NOT] IN predicate.
class	IsNullPredicate	A class that represents a IS [NOT] NULL predicate.

Methods in com.exasol.sql.expression.predicate that return ValueExpression

Modifier and Type	Method	Description
ValueExpression	BetweenPredicate.getEndExpression()	Returns the end expression in the [NOT] BETWEEN predicate.
ValueExpression	BetweenPredicate.getExpression()	Returns the left expression in the [NOT] BETWEEN predicate.
ValueExpression	InPredicate.getExpression()	Returns the left expression in the [NOT] IN predicate.
ValueExpression	IsNullPredicate.getOperand()	Returns the value expression to be checked for null.
ValueExpression	BetweenPredicate.getStartExpression()	Returns the start expression in the [NOT] BETWEEN predicate.

Methods in com.exasol.sql.expression.predicate that return types with arguments of type ValueExpression

Modifier and Type	Method	Description
List<ValueExpression>	InPredicate.getOperands()	Returns the value expressions in the [NOT] IN predicate.

Methods in com.exasol.sql.expression.predicate with parameters of type ValueExpression

Modifier and Type	Method	Description
BetweenPredicate.Builder	BetweenPredicate.Builder.end(ValueExpression end)	Adds the end expression of predicate.
BetweenPredicate.Builder	BetweenPredicate.Builder.expression(ValueExpression expression)	Adds the left expression of predicate.
InPredicate.Builder	InPredicate.Builder.expression(ValueExpression expression)	Adds the predicate expression.
InPredicate.Builder	InPredicate.Builder.operands(ValueExpression... operands)	Adds the operands.
BetweenPredicate.Builder	BetweenPredicate.Builder.start(ValueExpression start)	Adds the start expression of predicate.

Constructors in com.exasol.sql.expression.predicate with parameters of type ValueExpression

Constructor	Description
IsNullPredicate(IsNullPredicate.IsNullPredicateOperator operator, ValueExpression operand)	Creates a new instance of IsNullPredicate for IS [NOT] NULL predicate.
IsNullPredicate(ValueExpression operand)	Creates a new instance of IsNullPredicate for IS NULL predicate.

Uses of ValueExpression in com.exasol.sql.expression.rendering

Methods in com.exasol.sql.expression.rendering with parameters of type ValueExpression

Modifier and Type	Method	Description
void	ValueExpressionRenderer.visit(ValueExpression... valueExpressions)	Visit a value expression.

Method parameters in com.exasol.sql.expression.rendering with type arguments of type ValueExpression

Modifier and Type	Method	Description
void	ValueExpressionRenderer.visit(List<ValueExpression> valueExpressions)	Visit expressions.

Uses of ValueExpression in com.exasol.sql.rendering

Methods in com.exasol.sql.rendering with parameters of type ValueExpression

Modifier and Type	Method	Description
protected void	AbstractFragmentRenderer.appendRenderedValueExpression(ValueExpression expression)	Append a value expression that has already been rendered.

Method parameters in com.exasol.sql.rendering with type arguments of type ValueExpression

Modifier and Type	Method	Description
protected void	AbstractFragmentRenderer.appendListOfValueExpressions(List<? extends ValueExpression> valueExpressions)	Append a list of value expressions.