Uses of Annotation Interface
org.jooq.Support

Packages that use Support

Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.impl	This package contains jOOQ's implementation classes.
org.jooq.util.mysql	This package contains classes related to the SQLDialect.MYSQL dialect family.
org.jooq.util.oracle	This package contains classes related to the SQLDialect.ORACLE dialect family.
org.jooq.util.postgres	This package contains classes related to the SQLDialect.POSTGRES dialect family.
org.jooq.util.sqlserver	This package contains classes related to the SQLDialect.SQLSERVER dialect family.

Uses of Support in org.jooq

Methods in org.jooq with annotations of type Support

Modifier and Type

Method

Description

@NotNull Field<T>

Field.abs()

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.11 - [#7538] - Use DSL.abs(Field) instead.

@NotNull JSONArrayAggReturningStep<T>

JSONArrayAggNullStep.absentOnNull()

Exclude NULL values in output JSON.

@NotNull JSONArrayReturningStep<T>

JSONArrayNullStep.absentOnNull()

Add the ABSENT ON NULL clause to the JSON ARRAY function.

@NotNull JSONObjectAggReturningStep<T>

JSONObjectAggNullStep.absentOnNull()

Exclude NULL values in output JSON.

@NotNull JSONObjectReturningStep<T>

JSONObjectNullStep.absentOnNull()

Add the ABSENT ON NULL clause to the JSON OBJECT function.

@NotNull Field<BigDecimal>

Field.acos()

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.11 - [#7538] - Use DSL.acos(Field) instead.

@NotNull AlterDomainFinalStep

AlterDomainStep.add(Constraint addConstraint)

Add the ADD clause to the ALTER DOMAIN statement.

@NotNull AlterTableAddStep

AlterTableStep.add(String field, DataType<?> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.add(Collection<? extends TableElement> fields)

Add an ADD clause with multiple columns or constraints to the ALTER TABLE statement.

@NotNull AlterTableUsingIndexStep

AlterTableStep.add(Constraint constraint)

Add an ADD CONSTRAINT clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.add(Field<?> field)

Add an ADD COLUMN clause to the ALTER TABLE statement.

<T> @NotNull AlterTableAddStep

AlterTableStep.add(Field<T> field, DataType<T> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.add(Name field, DataType<?> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.add(TableElement field)

Add an ADD clause with multiple columns or constraints to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.add(TableElement... fields)

Add an ADD clause with multiple columns or constraints to the ALTER TABLE statement.

@NotNull Field<T>

Field.add(Number value)

An arithmetic expression adding this to value.

@NotNull Field<T>

Field.add(Field<?> value)

An arithmetic expression to add value to this.

@NotNull AlterTableAddStep

AlterTableStep.addColumn(String field, DataType<?> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addColumn(Field<?> field)

Add an ADD COLUMN clause to the ALTER TABLE statement.

<T> @NotNull AlterTableAddStep

AlterTableStep.addColumn(Field<T> field, DataType<T> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addColumn(Name field, DataType<?> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addColumnIfNotExists(String field, DataType<?> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addColumnIfNotExists(Field<?> field)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

<T> @NotNull AlterTableAddStep

AlterTableStep.addColumnIfNotExists(Field<T> field, DataType<T> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addColumnIfNotExists(Name field, DataType<?> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

void

ConditionProvider.addConditions(Collection<? extends Condition> conditions)

Deprecated, for removal: This API element is subject to removal in a future version.

Adds new conditions to the query, connecting them to existing conditions with Operator.AND.

void

ConditionProvider.addConditions(Condition condition)

Deprecated, for removal: This API element is subject to removal in a future version.

Adds a new condition to the query, connecting them to existing conditions with Operator.AND.

void

ConditionProvider.addConditions(Condition... conditions)

Deprecated, for removal: This API element is subject to removal in a future version.

Adds new conditions to the query, connecting them to existing conditions with Operator.AND.

void

ConditionProvider.addConditions(Operator operator, Collection<? extends Condition> conditions)

Deprecated, for removal: This API element is subject to removal in a future version.

Adds new conditions to the query, connecting them to existing conditions with the provided operator.

void

ConditionProvider.addConditions(Operator operator, Condition condition)

Deprecated, for removal: This API element is subject to removal in a future version.

Adds a new condition to the query, connecting them to existing conditions with the provided operator.

void

ConditionProvider.addConditions(Operator operator, Condition... conditions)

Deprecated, for removal: This API element is subject to removal in a future version.

Adds new conditions to the query, connecting them to existing conditions with the provided operator.

void

DeleteQuery.addConditions(Collection<? extends Condition> conditions)

void

DeleteQuery.addConditions(Condition condition)

void

DeleteQuery.addConditions(Condition... conditions)

void

DeleteQuery.addConditions(Operator operator, Collection<? extends Condition> conditions)

void

DeleteQuery.addConditions(Operator operator, Condition condition)

void

DeleteQuery.addConditions(Operator operator, Condition... conditions)

void

InsertQuery.addConditions(Collection<? extends Condition> conditions)

Adds new conditions to the query, connecting them to existing conditions with Operator.AND.

void

InsertQuery.addConditions(Condition condition)

Adds a new condition to the query, connecting it to existing conditions with Operator.AND.

void

InsertQuery.addConditions(Condition... conditions)

Adds new conditions to the query, connecting them to existing conditions with Operator.AND.

void

InsertQuery.addConditions(Operator operator, Collection<? extends Condition> conditions)

Adds new conditions to the query, connecting them to existing conditions with the provided operator.

void

InsertQuery.addConditions(Operator operator, Condition condition)

Adds a new condition to the query, connecting it to existing conditions with the provided operator.

void

InsertQuery.addConditions(Operator operator, Condition... conditions)

Adds new conditions to the query, connecting them to existing conditions with the provided operator.

void

SelectQuery.addConditions(Collection<? extends Condition> conditions)

void

SelectQuery.addConditions(Condition condition)

void

SelectQuery.addConditions(Condition... conditions)

void

SelectQuery.addConditions(Operator operator, Collection<? extends Condition> conditions)

void

SelectQuery.addConditions(Operator operator, Condition condition)

void

SelectQuery.addConditions(Operator operator, Condition... conditions)

void

UpdateQuery.addConditions(Collection<? extends Condition> conditions)

void

UpdateQuery.addConditions(Condition condition)

void

UpdateQuery.addConditions(Condition... conditions)

void

UpdateQuery.addConditions(Operator operator, Collection<? extends Condition> conditions)

void

UpdateQuery.addConditions(Operator operator, Condition condition)

void

UpdateQuery.addConditions(Operator operator, Condition... conditions)

void

SelectQuery.addConnectBy(Condition condition)

Add an Oracle-specific CONNECT BY clause to the query.

void

SelectQuery.addConnectByNoCycle(Condition condition)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query.

void

SelectQuery.addDistinctOn(Collection<? extends SelectFieldOrAsterisk> fields)

Add a PostgreSQL-specific DISTINCT ON (fields…) clause.

void

SelectQuery.addDistinctOn(SelectFieldOrAsterisk... fields)

Add a PostgreSQL-specific DISTINCT ON (fields…) clause.

void

SelectQuery.addFrom(Collection<? extends TableLike<?>> from)

Add tables to the table product.

void

SelectQuery.addFrom(TableLike<?> from)

Add tables to the table product.

void

SelectQuery.addFrom(TableLike<?>... from)

Add tables to the table product.

void

UpdateQuery.addFrom(Collection<? extends TableLike<?>> from)

Add tables to the table product.

void

UpdateQuery.addFrom(TableLike<?> from)

Add tables to the table product.

void

UpdateQuery.addFrom(TableLike<?>... from)

Add tables to the table product.

void

SelectQuery.addGroupBy(Collection<? extends GroupField> fields)

Adds grouping fields.

void

SelectQuery.addGroupBy(GroupField... fields)

Adds grouping fields.

void

SelectQuery.addHaving(Collection<? extends Condition> conditions)

Adds new conditions to the having clause of the query, connecting them with each other with Operator.AND.

void

SelectQuery.addHaving(Condition condition)

Adds a new condition to the having clause of the query, connecting it with each other with Operator.AND.

void

SelectQuery.addHaving(Condition... conditions)

Adds new conditions to the having clause of the query, connecting them with each other with Operator.AND.

void

SelectQuery.addHaving(Operator operator, Collection<? extends Condition> conditions)

Adds new conditions to the having clause of query, connecting them with each other with operator.

void

SelectQuery.addHaving(Operator operator, Condition condition)

Adds a new condition to the having clause of query, connecting it with each other with operator.

void

SelectQuery.addHaving(Operator operator, Condition... conditions)

Adds new conditions to the having clause of query, connecting them with each other with operator.

void

SelectQuery.addHint(String hint)

Add an Oracle-style hint to the select clause.

@NotNull AlterTableAddStep

AlterTableStep.addIfNotExists(String field, DataType<?> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addIfNotExists(Field<?> field)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

<T> @NotNull AlterTableAddStep

AlterTableStep.addIfNotExists(Field<T> field, DataType<T> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addIfNotExists(Name field, DataType<?> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

void

SelectQuery.addJoin(TableLike<?> table, Condition condition)

Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.

void

SelectQuery.addJoin(TableLike<?> table, Condition... conditions)

Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.

void

SelectQuery.addJoin(TableLike<?> table, JoinType type, Condition condition)

Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.

void

SelectQuery.addJoin(TableLike<?> table, JoinType type, Condition... conditions)

Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.

void

SelectQuery.addJoin(TableLike<?> table, JoinType type, Condition[] conditions, Field<?>[] partitionBy)

Joins the existing table product to a new table using conditions, connecting them with each other with Operator.AND.

void

SelectQuery.addJoin(TableLike<?> table, JoinType type, Condition conditions, Field<?>[] partitionBy)

Joins the existing table product to a new table using conditions, connecting them with each other with Operator.AND.

void

SelectQuery.addJoin(TableLike<?> table, JoinType type, QOM.JoinHint hint, Condition condition)

Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.

void

SelectQuery.addJoin(TableLike<?> table, JoinType type, QOM.JoinHint hint, Condition... conditions)

Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.

void

SelectQuery.addJoin(TableLike<?> table, JoinType type, QOM.JoinHint hint, Condition[] conditions, Field<?>[] partitionBy)

Joins the existing table product to a new table using conditions, connecting them with each other with Operator.AND.

void

SelectQuery.addJoin(TableLike<?> table, JoinType type, QOM.JoinHint hint, Condition conditions, Field<?>[] partitionBy)

Joins the existing table product to a new table using conditions, connecting them with each other with Operator.AND.

void

SelectQuery.addJoinOnKey(TableLike<?> table, JoinType type)

Joins the existing table product to a new table using a foreign key.

void

SelectQuery.addJoinOnKey(TableLike<?> table, JoinType type, ForeignKey<?,?> key)

Joins the existing table product to a new table using a foreign key.

void

SelectQuery.addJoinOnKey(TableLike<?> table, JoinType type, QOM.JoinHint hint)

Joins the existing table product to a new table using a foreign key.

void

SelectQuery.addJoinOnKey(TableLike<?> table, JoinType type, QOM.JoinHint hint, ForeignKey<?,?> key)

Joins the existing table product to a new table using a foreign key.

void

SelectQuery.addJoinOnKey(TableLike<?> table, JoinType type, QOM.JoinHint hint, TableField<?,?>... keyFields)

Joins the existing table product to a new table using a foreign key.

void

SelectQuery.addJoinOnKey(TableLike<?> table, JoinType type, TableField<?,?>... keyFields)

Joins the existing table product to a new table using a foreign key.

void

SelectQuery.addJoinUsing(TableLike<?> table, Collection<? extends Field<?>> fields)

Joins the existing table product to a new table with a USING clause.

void

SelectQuery.addJoinUsing(TableLike<?> table, JoinType type, Collection<? extends Field<?>> fields)

Joins the existing table product to a new table with a USING clause.

void

SelectQuery.addJoinUsing(TableLike<?> table, JoinType type, QOM.JoinHint hint, Collection<? extends Field<?>> fields)

Joins the existing table product to a new table with a USING clause.

void

DeleteQuery.addLimit(Number numberOfRows)

Limit the results of this select.

void

DeleteQuery.addLimit(Field<? extends Number> numberOfRows)

Limit the results of this select.

void

SelectQuery.addLimit(Number numberOfRows)

Limit the results of this select.

void

SelectQuery.addLimit(Number offset, Number numberOfRows)

Limit the results of this select.

void

SelectQuery.addLimit(Number offset, Field<? extends Number> numberOfRows)

Limit the results of this select.

void

SelectQuery.addLimit(Field<? extends Number> numberOfRows)

Limit the results of this select.

void

SelectQuery.addLimit(Field<? extends Number> offset, Number numberOfRows)

Limit the results of this select.

void

SelectQuery.addLimit(Field<? extends Number> offset, Field<? extends Number> numberOfRows)

Limit the results of this select.

void

UpdateQuery.addLimit(Number numberOfRows)

Limit the results of this select.

void

UpdateQuery.addLimit(Field<? extends Number> numberOfRows)

Limit the results of this select.

void

SelectQuery.addOffset(Number offset)

Add a 0-based OFFSET clause to the query.

void

SelectQuery.addOffset(Field<? extends Number> offset)

Add a 0-based OFFSET clause to the query.

void

SelectQuery.addOption(String option)

Add a SQL Server-style query hint to the select clause.

void

DeleteQuery.addOrderBy(Collection<? extends OrderField<?>> fields)

Adds ordering fields.

void

DeleteQuery.addOrderBy(OrderField<?>... fields)

Adds ordering fields.

void

SelectQuery.addOrderBy(int... fieldIndexes)

Adds ordering fields.

void

SelectQuery.addOrderBy(Collection<? extends OrderField<?>> fields)

Adds ordering fields.

void

SelectQuery.addOrderBy(OrderField<?>... fields)

Adds ordering fields.

void

UpdateQuery.addOrderBy(Collection<? extends OrderField<?>> fields)

Adds ordering fields.

void

UpdateQuery.addOrderBy(OrderField<?>... fields)

Adds ordering fields.

void

SelectQuery.addQualify(Collection<? extends Condition> conditions)

Adds new conditions to the qualify clause of the query, connecting them with each other with Operator.AND.

void

SelectQuery.addQualify(Condition condition)

Adds a new condition to the qualify clause of the query, connecting it with each other with Operator.AND.

void

SelectQuery.addQualify(Condition... conditions)

Adds new conditions to the qualify clause of the query, connecting them with each other with Operator.AND.

void

SelectQuery.addQualify(Operator operator, Collection<? extends Condition> conditions)

Adds new conditions to the qualify clause of query, connecting them with each other with operator.

void

SelectQuery.addQualify(Operator operator, Condition condition)

Adds a new condition to the qualify clause of query, connecting it with each other with operator.

void

SelectQuery.addQualify(Operator operator, Condition... conditions)

Adds new conditions to the qualify clause of query, connecting them with each other with operator.

void

InsertQuery.addRecord(R record)

Short for calling InsertQuery.newRecord() and StoreQuery.setRecord(Record).

void

SelectQuery.addSeekAfter(Collection<? extends Field<?>> fields)

Adds seeking fields.

void

SelectQuery.addSeekAfter(Field<?>... fields)

Adds seeking fields.

void

SelectQuery.addSeekBefore(Collection<? extends Field<?>> fields)

Deprecated.

- [#7461] - SEEK BEFORE is not implemented correctly

void

SelectQuery.addSeekBefore(Field<?>... fields)

Deprecated.

- [#7461] - SEEK BEFORE is not implemented correctly

void

SelectQuery.addSelect(Collection<? extends SelectFieldOrAsterisk> fields)

Add a list of select fields.

void

SelectQuery.addSelect(SelectFieldOrAsterisk... fields)

Add a list of select fields.

void

DeleteQuery.addUsing(Collection<? extends TableLike<?>> tables)

Add tables to the USING clause.

void

DeleteQuery.addUsing(TableLike<?> table)

Add tables to the USING clause.

void

DeleteQuery.addUsing(TableLike<?>... tables)

Add tables to the USING clause.

@NotNull AlterTypeFinalStep

AlterTypeStep.addValue(String addValue)

Add the ADD VALUE clause to the ALTER TYPE statement.

@NotNull AlterTypeFinalStep

AlterTypeStep.addValue(Field<String> addValue)

Add the ADD VALUE clause to the ALTER TYPE statement.

<T> void

StoreQuery.addValue(Field<T> field, Field<T> value)

Add a value to the store statement

<T> void

StoreQuery.addValue(Field<T> field, T value)

Add a value to the store statement

<T> void

InsertQuery.addValueForUpdate(Field<T> field, Field<T> value)

Add a value to the ON DUPLICATE KEY UPDATE clause of this INSERT statement, where this is supported.

<T> void

InsertQuery.addValueForUpdate(Field<T> field, T value)

Add a value to the ON DUPLICATE KEY UPDATE clause of this INSERT statement, where this is supported.

void

StoreQuery.addValues(Map<?,?> map)

Add multiple values to the store statement.

<T1> void

UpdateQuery.addValues(Row1<T1> row, Row1<T1> value)

Specify a multi-column set clause for the UPDATE statement.

<T1> void

UpdateQuery.addValues(Row1<T1> row, Select<? extends Record1<T1>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
void

UpdateQuery.addValues(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
void

UpdateQuery.addValues(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row, Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
void

UpdateQuery.addValues(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> row, Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
void

UpdateQuery.addValues(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> row, Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
void

UpdateQuery.addValues(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> row, Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
void

UpdateQuery.addValues(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> row, Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
void

UpdateQuery.addValues(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> row, Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
void

UpdateQuery.addValues(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> row, Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
void

UpdateQuery.addValues(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> row, Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
void

UpdateQuery.addValues(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> row, Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
void

UpdateQuery.addValues(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> row, Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
void

UpdateQuery.addValues(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> row, Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
void

UpdateQuery.addValues(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row, Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
void

UpdateQuery.addValues(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row, Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
void

UpdateQuery.addValues(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> row, Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
void

UpdateQuery.addValues(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> row, Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
void

UpdateQuery.addValues(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row, Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
void

UpdateQuery.addValues(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row, Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
void

UpdateQuery.addValues(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row, Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
void

UpdateQuery.addValues(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row, Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2> void

UpdateQuery.addValues(Row2<T1,T2> row, Row2<T1,T2> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2> void

UpdateQuery.addValues(Row2<T1,T2> row, Select<? extends Record2<T1,T2>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
void

UpdateQuery.addValues(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> row, Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
void

UpdateQuery.addValues(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> row, Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
void

UpdateQuery.addValues(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> row, Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
void

UpdateQuery.addValues(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> row, Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
void

UpdateQuery.addValues(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> row, Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
void

UpdateQuery.addValues(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> row, Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3>
void

UpdateQuery.addValues(Row3<T1,T2,T3> row, Row3<T1,T2,T3> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3>
void

UpdateQuery.addValues(Row3<T1,T2,T3> row, Select<? extends Record3<T1,T2,T3>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4>
void

UpdateQuery.addValues(Row4<T1,T2,T3,T4> row, Row4<T1,T2,T3,T4> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4>
void

UpdateQuery.addValues(Row4<T1,T2,T3,T4> row, Select<? extends Record4<T1,T2,T3,T4>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5>
void

UpdateQuery.addValues(Row5<T1,T2,T3,T4,T5> row, Row5<T1,T2,T3,T4,T5> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5>
void

UpdateQuery.addValues(Row5<T1,T2,T3,T4,T5> row, Select<? extends Record5<T1,T2,T3,T4,T5>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6>
void

UpdateQuery.addValues(Row6<T1,T2,T3,T4,T5,T6> row, Row6<T1,T2,T3,T4,T5,T6> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6>
void

UpdateQuery.addValues(Row6<T1,T2,T3,T4,T5,T6> row, Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7>
void

UpdateQuery.addValues(Row7<T1,T2,T3,T4,T5,T6,T7> row, Row7<T1,T2,T3,T4,T5,T6,T7> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7>
void

UpdateQuery.addValues(Row7<T1,T2,T3,T4,T5,T6,T7> row, Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8>
void

UpdateQuery.addValues(Row8<T1,T2,T3,T4,T5,T6,T7,T8> row, Row8<T1,T2,T3,T4,T5,T6,T7,T8> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8>
void

UpdateQuery.addValues(Row8<T1,T2,T3,T4,T5,T6,T7,T8> row, Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9>
void

UpdateQuery.addValues(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> row, Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> value)

Specify a multi-column set clause for the UPDATE statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9>
void

UpdateQuery.addValues(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> row, Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)

Specify a multi-column set clause for the UPDATE statement.

void

UpdateQuery.addValues(RowN row, RowN value)

Specify a multi-column set clause for the UPDATE statement.

void

UpdateQuery.addValues(RowN row, Select<? extends Record> select)

Specify a multi-column set clause for the UPDATE statement.

void

InsertQuery.addValuesForUpdate(Map<?,?> map)

Add multiple values to the ON DUPLICATE KEY UPDATE clause of this INSERT statement, where this is supported.

void

SelectQuery.addWindow(Collection<? extends WindowDefinition> definitions)

Adds new window definitions to the window clause of the query.

void

SelectQuery.addWindow(WindowDefinition... definitions)

Adds new window definitions to the window clause of the query.

@NotNull AlterTableFinalStep

AlterTableAddStep.after(String columnName)

Add a AFTER clause to ALTER TABLE … ADD ….

@NotNull AlterTableFinalStep

AlterTableAddStep.after(Field<?> columnName)

Add a AFTER clause to ALTER TABLE … ADD ….

@NotNull AlterTableFinalStep

AlterTableAddStep.after(Name columnName)

Add a AFTER clause to ALTER TABLE … ADD ….

@NotNull CreateTriggerEventOrStep

CreateTriggerEventStep.afterDelete()

Add the AFTER DELETE clause to the CREATE TRIGGER statement.

@NotNull CreateTriggerEventOrStep

CreateTriggerEventStep.afterInsert()

Add the AFTER INSERT clause to the CREATE TRIGGER statement.

@NotNull CreateTriggerEventOfStep

CreateTriggerEventStep.afterUpdate()

Add the AFTER UPDATE clause to the CREATE TRIGGER statement.

@NotNull PeriodSpecification

Period.all()

Create a period specification for all timestamps.

@NotNull AlterTableAlterStep<Object>

AlterTableStep.alter(String field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAlterConstraintStep

AlterTableStep.alter(Constraint constraint)

Add an ALTER CONSTRAINT clause to the ALTER TABLE statement.

<T> @NotNull AlterTableAlterStep<T>

AlterTableStep.alter(Field<T> field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAlterStep<Object>

AlterTableStep.alter(Name field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAlterStep<Object>

AlterTableStep.alterColumn(String field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

<T> @NotNull AlterTableAlterStep<T>

AlterTableStep.alterColumn(Field<T> field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAlterStep<Object>

AlterTableStep.alterColumn(Name field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAlterConstraintStep

AlterTableStep.alterConstraint(String constraint)

Add an ALTER CONSTRAINT clause to the ALTER TABLE statement.

@NotNull AlterTableAlterConstraintStep

AlterTableStep.alterConstraint(Constraint constraint)

Add an ALTER CONSTRAINT clause to the ALTER TABLE statement.

@NotNull AlterTableAlterConstraintStep

AlterTableStep.alterConstraint(Name constraint)

Add an ALTER CONSTRAINT clause to the ALTER TABLE statement.

@NotNull AlterDatabaseStep

DSLContext.alterDatabase(String database)

The ALTER DATABASE statement.

@NotNull AlterDatabaseStep

DSLContext.alterDatabase(Catalog database)

The ALTER DATABASE statement.

@NotNull AlterDatabaseStep

DSLContext.alterDatabase(Name database)

The ALTER DATABASE statement.

@NotNull AlterDatabaseStep

DSLContext.alterDatabaseIfExists(String database)

The ALTER DATABASE IF EXISTS statement.

@NotNull AlterDatabaseStep

DSLContext.alterDatabaseIfExists(Catalog database)

The ALTER DATABASE IF EXISTS statement.

@NotNull AlterDatabaseStep

DSLContext.alterDatabaseIfExists(Name database)

The ALTER DATABASE IF EXISTS statement.

<T> @NotNull AlterDomainStep<T>

DSLContext.alterDomain(String domain)

The ALTER DOMAIN statement.

<T> @NotNull AlterDomainStep<T>

DSLContext.alterDomain(Domain<T> domain)

The ALTER DOMAIN statement.

<T> @NotNull AlterDomainStep<T>

DSLContext.alterDomain(Name domain)

The ALTER DOMAIN statement.

<T> @NotNull AlterDomainStep<T>

DSLContext.alterDomainIfExists(String domain)

The ALTER DOMAIN IF EXISTS statement.

<T> @NotNull AlterDomainStep<T>

DSLContext.alterDomainIfExists(Domain<T> domain)

The ALTER DOMAIN IF EXISTS statement.

<T> @NotNull AlterDomainStep<T>

DSLContext.alterDomainIfExists(Name domain)

The ALTER DOMAIN IF EXISTS statement.

@NotNull AlterIndexOnStep

DSLContext.alterIndex(String index)

The ALTER INDEX statement.

@NotNull AlterIndexOnStep

DSLContext.alterIndex(Index index)

The ALTER INDEX statement.

@NotNull AlterIndexOnStep

DSLContext.alterIndex(Name index)

The ALTER INDEX statement.

@NotNull AlterIndexOnStep

DSLContext.alterIndexIfExists(String index)

The ALTER INDEX IF EXISTS statement.

@NotNull AlterIndexOnStep

DSLContext.alterIndexIfExists(Index index)

The ALTER INDEX IF EXISTS statement.

@NotNull AlterIndexOnStep

DSLContext.alterIndexIfExists(Name index)

The ALTER INDEX IF EXISTS statement.

@NotNull AlterViewStep

DSLContext.alterMaterializedView(String view)

The ALTER MATERIALIZED VIEW statement.

@NotNull AlterViewStep

DSLContext.alterMaterializedView(Name view)

The ALTER MATERIALIZED VIEW statement.

@NotNull AlterViewStep

DSLContext.alterMaterializedView(Table<?> view)

The ALTER MATERIALIZED VIEW statement.

@NotNull AlterViewStep

DSLContext.alterMaterializedViewIfExists(String view)

The ALTER MATERIALIZED VIEW IF EXISTS statement.

@NotNull AlterViewStep

DSLContext.alterMaterializedViewIfExists(Name view)

The ALTER MATERIALIZED VIEW IF EXISTS statement.

@NotNull AlterViewStep

DSLContext.alterMaterializedViewIfExists(Table<?> view)

The ALTER MATERIALIZED VIEW IF EXISTS statement.

@NotNull AlterSchemaStep

DSLContext.alterSchema(String schema)

The ALTER SCHEMA statement.

@NotNull AlterSchemaStep

DSLContext.alterSchema(Name schema)

The ALTER SCHEMA statement.

@NotNull AlterSchemaStep

DSLContext.alterSchema(Schema schema)

The ALTER SCHEMA statement.

@NotNull AlterSchemaStep

DSLContext.alterSchemaIfExists(String schema)

The ALTER SCHEMA IF EXISTS statement.

@NotNull AlterSchemaStep

DSLContext.alterSchemaIfExists(Name schema)

The ALTER SCHEMA IF EXISTS statement.

@NotNull AlterSchemaStep

DSLContext.alterSchemaIfExists(Schema schema)

The ALTER SCHEMA IF EXISTS statement.

@NotNull AlterSequenceStep<Number>

DSLContext.alterSequence(String sequence)

The ALTER SEQUENCE statement.

@NotNull AlterSequenceStep<Number>

DSLContext.alterSequence(Name sequence)

The ALTER SEQUENCE statement.

<T extends Number>
@NotNull AlterSequenceStep<T>

DSLContext.alterSequence(Sequence<T> sequence)

The ALTER SEQUENCE statement.

@NotNull AlterSequenceStep<Number>

DSLContext.alterSequenceIfExists(String sequence)

The ALTER SEQUENCE IF EXISTS statement.

@NotNull AlterSequenceStep<Number>

DSLContext.alterSequenceIfExists(Name sequence)

The ALTER SEQUENCE IF EXISTS statement.

<T extends Number>
@NotNull AlterSequenceStep<T>

DSLContext.alterSequenceIfExists(Sequence<T> sequence)

The ALTER SEQUENCE IF EXISTS statement.

@NotNull AlterTableStep

DSLContext.alterTable(String table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

DSLContext.alterTable(Name table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

DSLContext.alterTable(Table<?> table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

DSLContext.alterTableIfExists(String table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

DSLContext.alterTableIfExists(Name table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

DSLContext.alterTableIfExists(Table<?> table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTypeStep

DSLContext.alterType(String type)

The ALTER TYPE statement.

@NotNull AlterTypeStep

DSLContext.alterType(Name type)

The ALTER TYPE statement.

@NotNull AlterTypeStep

DSLContext.alterTypeIfExists(String type)

The ALTER TYPE IF EXISTS statement.

@NotNull AlterTypeStep

DSLContext.alterTypeIfExists(Name type)

The ALTER TYPE IF EXISTS statement.

@NotNull AlterViewStep

DSLContext.alterView(String view)

The ALTER VIEW statement.

@NotNull AlterViewStep

DSLContext.alterView(Name view)

The ALTER VIEW statement.

@NotNull AlterViewStep

DSLContext.alterView(Table<?> view)

The ALTER VIEW statement.

@NotNull AlterViewStep

DSLContext.alterView(Table<?> view, Collection<? extends Field<?>> fields)

The ALTER VIEW statement.

@NotNull AlterViewStep

DSLContext.alterView(Table<?> view, Field<?>... fields)

The ALTER VIEW statement.

@NotNull AlterViewStep

DSLContext.alterViewIfExists(String view)

The ALTER VIEW IF EXISTS statement.

@NotNull AlterViewStep

DSLContext.alterViewIfExists(Name view)

The ALTER VIEW IF EXISTS statement.

@NotNull AlterViewStep

DSLContext.alterViewIfExists(Table<?> view)

The ALTER VIEW IF EXISTS statement.

@NotNull Condition

BetweenAndStep.and(Field<T> field)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep.and(T value)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep1.and(Field<T1> maxValue1)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep1.and(Record1<T1> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep1.and(Row1<T1> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep1.and(T1 maxValue1)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep10.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7, Field<T8> maxValue8, Field<T9> maxValue9, Field<T10> maxValue10)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep10.and(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep10.and(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep10.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7, T8 maxValue8, T9 maxValue9, T10 maxValue10)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep11.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7, Field<T8> maxValue8, Field<T9> maxValue9, Field<T10> maxValue10, Field<T11> maxValue11)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep11.and(Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep11.and(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep11.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7, T8 maxValue8, T9 maxValue9, T10 maxValue10, T11 maxValue11)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep12.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7, Field<T8> maxValue8, Field<T9> maxValue9, Field<T10> maxValue10, Field<T11> maxValue11, Field<T12> maxValue12)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep12.and(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep12.and(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep12.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7, T8 maxValue8, T9 maxValue9, T10 maxValue10, T11 maxValue11, T12 maxValue12)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep13.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7, Field<T8> maxValue8, Field<T9> maxValue9, Field<T10> maxValue10, Field<T11> maxValue11, Field<T12> maxValue12, Field<T13> maxValue13)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep13.and(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep13.and(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep13.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7, T8 maxValue8, T9 maxValue9, T10 maxValue10, T11 maxValue11, T12 maxValue12, T13 maxValue13)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep14.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7, Field<T8> maxValue8, Field<T9> maxValue9, Field<T10> maxValue10, Field<T11> maxValue11, Field<T12> maxValue12, Field<T13> maxValue13, Field<T14> maxValue14)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep14.and(Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep14.and(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep14.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7, T8 maxValue8, T9 maxValue9, T10 maxValue10, T11 maxValue11, T12 maxValue12, T13 maxValue13, T14 maxValue14)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep15.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7, Field<T8> maxValue8, Field<T9> maxValue9, Field<T10> maxValue10, Field<T11> maxValue11, Field<T12> maxValue12, Field<T13> maxValue13, Field<T14> maxValue14, Field<T15> maxValue15)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep15.and(Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep15.and(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep15.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7, T8 maxValue8, T9 maxValue9, T10 maxValue10, T11 maxValue11, T12 maxValue12, T13 maxValue13, T14 maxValue14, T15 maxValue15)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep16.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7, Field<T8> maxValue8, Field<T9> maxValue9, Field<T10> maxValue10, Field<T11> maxValue11, Field<T12> maxValue12, Field<T13> maxValue13, Field<T14> maxValue14, Field<T15> maxValue15, Field<T16> maxValue16)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep16.and(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep16.and(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep16.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7, T8 maxValue8, T9 maxValue9, T10 maxValue10, T11 maxValue11, T12 maxValue12, T13 maxValue13, T14 maxValue14, T15 maxValue15, T16 maxValue16)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep17.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7, Field<T8> maxValue8, Field<T9> maxValue9, Field<T10> maxValue10, Field<T11> maxValue11, Field<T12> maxValue12, Field<T13> maxValue13, Field<T14> maxValue14, Field<T15> maxValue15, Field<T16> maxValue16, Field<T17> maxValue17)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep17.and(Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep17.and(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep17.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7, T8 maxValue8, T9 maxValue9, T10 maxValue10, T11 maxValue11, T12 maxValue12, T13 maxValue13, T14 maxValue14, T15 maxValue15, T16 maxValue16, T17 maxValue17)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep18.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7, Field<T8> maxValue8, Field<T9> maxValue9, Field<T10> maxValue10, Field<T11> maxValue11, Field<T12> maxValue12, Field<T13> maxValue13, Field<T14> maxValue14, Field<T15> maxValue15, Field<T16> maxValue16, Field<T17> maxValue17, Field<T18> maxValue18)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep18.and(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep18.and(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep18.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7, T8 maxValue8, T9 maxValue9, T10 maxValue10, T11 maxValue11, T12 maxValue12, T13 maxValue13, T14 maxValue14, T15 maxValue15, T16 maxValue16, T17 maxValue17, T18 maxValue18)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep19.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7, Field<T8> maxValue8, Field<T9> maxValue9, Field<T10> maxValue10, Field<T11> maxValue11, Field<T12> maxValue12, Field<T13> maxValue13, Field<T14> maxValue14, Field<T15> maxValue15, Field<T16> maxValue16, Field<T17> maxValue17, Field<T18> maxValue18, Field<T19> maxValue19)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep19.and(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep19.and(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep19.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7, T8 maxValue8, T9 maxValue9, T10 maxValue10, T11 maxValue11, T12 maxValue12, T13 maxValue13, T14 maxValue14, T15 maxValue15, T16 maxValue16, T17 maxValue17, T18 maxValue18, T19 maxValue19)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep2.and(Field<T1> maxValue1, Field<T2> maxValue2)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep2.and(Record2<T1,T2> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep2.and(Row2<T1,T2> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep2.and(T1 maxValue1, T2 maxValue2)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep20.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7, Field<T8> maxValue8, Field<T9> maxValue9, Field<T10> maxValue10, Field<T11> maxValue11, Field<T12> maxValue12, Field<T13> maxValue13, Field<T14> maxValue14, Field<T15> maxValue15, Field<T16> maxValue16, Field<T17> maxValue17, Field<T18> maxValue18, Field<T19> maxValue19, Field<T20> maxValue20)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep20.and(Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep20.and(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep20.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7, T8 maxValue8, T9 maxValue9, T10 maxValue10, T11 maxValue11, T12 maxValue12, T13 maxValue13, T14 maxValue14, T15 maxValue15, T16 maxValue16, T17 maxValue17, T18 maxValue18, T19 maxValue19, T20 maxValue20)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep21.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7, Field<T8> maxValue8, Field<T9> maxValue9, Field<T10> maxValue10, Field<T11> maxValue11, Field<T12> maxValue12, Field<T13> maxValue13, Field<T14> maxValue14, Field<T15> maxValue15, Field<T16> maxValue16, Field<T17> maxValue17, Field<T18> maxValue18, Field<T19> maxValue19, Field<T20> maxValue20, Field<T21> maxValue21)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep21.and(Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep21.and(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep21.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7, T8 maxValue8, T9 maxValue9, T10 maxValue10, T11 maxValue11, T12 maxValue12, T13 maxValue13, T14 maxValue14, T15 maxValue15, T16 maxValue16, T17 maxValue17, T18 maxValue18, T19 maxValue19, T20 maxValue20, T21 maxValue21)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep22.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7, Field<T8> maxValue8, Field<T9> maxValue9, Field<T10> maxValue10, Field<T11> maxValue11, Field<T12> maxValue12, Field<T13> maxValue13, Field<T14> maxValue14, Field<T15> maxValue15, Field<T16> maxValue16, Field<T17> maxValue17, Field<T18> maxValue18, Field<T19> maxValue19, Field<T20> maxValue20, Field<T21> maxValue21, Field<T22> maxValue22)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep22.and(Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep22.and(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep22.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7, T8 maxValue8, T9 maxValue9, T10 maxValue10, T11 maxValue11, T12 maxValue12, T13 maxValue13, T14 maxValue14, T15 maxValue15, T16 maxValue16, T17 maxValue17, T18 maxValue18, T19 maxValue19, T20 maxValue20, T21 maxValue21, T22 maxValue22)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep3.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep3.and(Record3<T1,T2,T3> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep3.and(Row3<T1,T2,T3> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep3.and(T1 maxValue1, T2 maxValue2, T3 maxValue3)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep4.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep4.and(Record4<T1,T2,T3,T4> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep4.and(Row4<T1,T2,T3,T4> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep4.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep5.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep5.and(Record5<T1,T2,T3,T4,T5> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep5.and(Row5<T1,T2,T3,T4,T5> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep5.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep6.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep6.and(Record6<T1,T2,T3,T4,T5,T6> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep6.and(Row6<T1,T2,T3,T4,T5,T6> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep6.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep7.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep7.and(Record7<T1,T2,T3,T4,T5,T6,T7> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep7.and(Row7<T1,T2,T3,T4,T5,T6,T7> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep7.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep8.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7, Field<T8> maxValue8)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep8.and(Record8<T1,T2,T3,T4,T5,T6,T7,T8> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep8.and(Row8<T1,T2,T3,T4,T5,T6,T7,T8> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep8.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7, T8 maxValue8)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep9.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<T3> maxValue3, Field<T4> maxValue4, Field<T5> maxValue5, Field<T6> maxValue6, Field<T7> maxValue7, Field<T8> maxValue8, Field<T9> maxValue9)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep9.and(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep9.and(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStep9.and(T1 maxValue1, T2 maxValue2, T3 maxValue3, T4 maxValue4, T5 maxValue5, T6 maxValue6, T7 maxValue7, T8 maxValue8, T9 maxValue9)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStepN.and(Object... maxValues)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStepN.and(Field<?>... maxValues)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStepN.and(Record maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStepN.and(RowN maxValue)

Create a condition to check this field against some bounds

@NotNull Condition

BetweenAndStepR.and(R value)

Create a condition to check this field against some bounds.

@NotNull Condition

Condition.and(String sql)

Combine this condition with another one using the Operator.AND operator.

@NotNull Condition

Condition.and(String sql, Object... bindings)

Combine this condition with another one using the Operator.AND operator.

@NotNull Condition

Condition.and(String sql, QueryPart... parts)

Combine this condition with another one using the Operator.AND operator.

@NotNull Condition

Condition.and(Condition arg2)

The AND operator.

@NotNull Condition

Condition.and(Field<Boolean> other)

Combine this condition with another one using the Operator.AND operator.

@NotNull Condition

Condition.and(SQL sql)

Combine this condition with another one using the Operator.AND operator.

@NotNull DeleteConditionStep<R>

DeleteConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull DeleteConditionStep<R>

DeleteConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull DeleteConditionStep<R>

DeleteConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull DeleteConditionStep<R>

DeleteConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull DeleteConditionStep<R>

DeleteConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull DeleteConditionStep<R>

DeleteConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull DivideByOnConditionStep

DivideByOnConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator.

@NotNull DivideByOnConditionStep

DivideByOnConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator.

@NotNull DivideByOnConditionStep

DivideByOnConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator.

@NotNull DivideByOnConditionStep

DivideByOnConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator.

@NotNull DivideByOnConditionStep

DivideByOnConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator.

@NotNull DivideByOnConditionStep

DivideByOnConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull PeriodSpecification

PeriodSpecificationBetweenAndStep.and(Field<T> to)

Add an upper bound to the period specification range.

@NotNull PeriodSpecification

PeriodSpecificationBetweenAndStep.and(T to)

Add an upper bound to the period specification range.

@NotNull SelectConditionStep<R>

SelectConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull TableOnConditionStep<R>

TableOnConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator.

@NotNull TableOnConditionStep<R>

TableOnConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator.

@NotNull TableOnConditionStep<R>

TableOnConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator.

@NotNull TableOnConditionStep<R>

TableOnConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator.

@NotNull TableOnConditionStep<R>

TableOnConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator.

@NotNull TableOnConditionStep<R>

TableOnConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator.

@NotNull UpdateConditionStep<R>

UpdateConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull UpdateConditionStep<R>

UpdateConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull UpdateConditionStep<R>

UpdateConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull UpdateConditionStep<R>

UpdateConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull UpdateConditionStep<R>

UpdateConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull UpdateConditionStep<R>

UpdateConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull Table<R>

VersionsBetweenAndStep.and(Field<? extends T> scn)

Add an AND clause to the flashback versions query clause.

@NotNull Table<R>

VersionsBetweenAndStep.and(T scn)

Add an AND clause to the flashback versions query clause.

@NotNull WindowExcludeStep<T>

WindowRowsAndStep.andCurrentRow()

Add a … AND CURRENT ROW frame clause to the window function.

@NotNull WindowSpecificationExcludeStep

WindowSpecificationRowsAndStep.andCurrentRow()

Add a … AND CURRENT ROW frame clause to the window specification.

@NotNull Condition

Condition.andExists(Select<?> select)

Combine this condition with an EXISTS clause using the Operator.AND operator.

@NotNull DeleteConditionStep<R>

DeleteConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator

@NotNull DivideByOnConditionStep

DivideByOnConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull TableOnConditionStep<R>

TableOnConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator.

@NotNull UpdateConditionStep<R>

UpdateConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator

@NotNull WindowExcludeStep<T>

WindowRowsAndStep.andFollowing(int number)

Add a … AND [number] FOLLOWING frame clause to the window function.

@NotNull WindowSpecificationExcludeStep

WindowSpecificationRowsAndStep.andFollowing(int number)

Add a … AND [number] FOLLOWING frame clause to the window specification.

@NotNull Table<R>

VersionsBetweenAndStep.andMaxvalue()

Add an AND MAXVALUE clause to the flashback versions query clause.

@NotNull Condition

Condition.andNot(Condition other)

Combine this condition with a negated other one using the Operator.AND operator.

@NotNull Condition

Condition.andNot(Field<Boolean> other)

Combine this condition with a negated other one using the Operator.AND operator.

@NotNull DeleteConditionStep<R>

DeleteConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator

@NotNull DeleteConditionStep<R>

DeleteConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator

@NotNull DivideByOnConditionStep

DivideByOnConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator.

@NotNull DivideByOnConditionStep

DivideByOnConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull TableOnConditionStep<R>

TableOnConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator.

@NotNull TableOnConditionStep<R>

TableOnConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator.

@NotNull UpdateConditionStep<R>

UpdateConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator

@NotNull UpdateConditionStep<R>

UpdateConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator

@NotNull Condition

Condition.andNotExists(Select<?> select)

Combine this condition with a NOT EXIST clause using the Operator.AND operator.

@NotNull DeleteConditionStep<R>

DeleteConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator

@NotNull DivideByOnConditionStep

DivideByOnConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull TableOnConditionStep<R>

TableOnConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator.

@NotNull UpdateConditionStep<R>

UpdateConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator

@NotNull WindowExcludeStep<T>

WindowRowsAndStep.andPreceding(int number)

Add a … AND [number] PRECEDING frame clause to the window function.

@NotNull WindowSpecificationExcludeStep

WindowSpecificationRowsAndStep.andPreceding(int number)

Add a … AND [number] PRECEDING frame clause to the window specification.

@NotNull WindowExcludeStep<T>

WindowRowsAndStep.andUnboundedFollowing()

Add a … AND UNBOUNDED FOLLOWING frame clause to the window function.

@NotNull WindowSpecificationExcludeStep

WindowSpecificationRowsAndStep.andUnboundedFollowing()

Add a … AND UNBOUNDED FOLLOWING frame clause to the window specification.

@NotNull WindowExcludeStep<T>

WindowRowsAndStep.andUnboundedPreceding()

Add a … AND UNBOUNDED PRECEDING frame clause to the window function.

@NotNull WindowSpecificationExcludeStep

WindowSpecificationRowsAndStep.andUnboundedPreceding()

Add a … AND UNBOUNDED PRECEDING frame clause to the window specification.

@NotNull Query

CallArgsStep.args(Collection<? extends Field<?>> args)

Add the ARGS clause to the CALL statement.

@NotNull Query

CallArgsStep.args(Field<?>... args)

Add the ARGS clause to the CALL statement.

@NotNull DataType<T[]>

DataType.array()

A convenient short for form DataType.getArrayDataType() for DSL usage

@NotNull AlterViewFinalStep

AlterViewStep.as(Select<?> as)

Add the AS clause to the ALTER VIEW statement.

<T> @NotNull CreateDomainDefaultStep<T>

CreateDomainAsStep.as(Class<T> dataType)

Add the AS clause to the CREATE DOMAIN statement.

<T> @NotNull CreateDomainDefaultStep<T>

CreateDomainAsStep.as(DataType<T> dataType)

Add the AS clause to the CREATE DOMAIN statement.

@NotNull DDLQuery

CreateFunctionAsStep.as(Collection<? extends Statement> body)

Add the AS clause to the CREATE FUNCTION statement.

@NotNull DDLQuery

CreateFunctionAsStep.as(Statement body)

Add the AS clause to the CREATE FUNCTION statement.

@NotNull DDLQuery

CreateFunctionAsStep.as(Statement... body)

Add the AS clause to the CREATE FUNCTION statement.

@NotNull DDLQuery

CreateProcedureAsStep.as(Collection<? extends Statement> body)

Add the AS clause to the CREATE PROCEDURE statement.

@NotNull DDLQuery

CreateProcedureAsStep.as(Statement body)

Add the AS clause to the CREATE PROCEDURE statement.

@NotNull DDLQuery

CreateProcedureAsStep.as(Statement... body)

Add the AS clause to the CREATE PROCEDURE statement.

<T extends Number>
@NotNull CreateSequenceFlagsStep<T>

CreateSequenceAsStep.as(Class<T> dataType)

Add the AS clause to the CREATE SEQUENCE statement.

<T extends Number>
@NotNull CreateSequenceFlagsStep<T>

CreateSequenceAsStep.as(DataType<T> dataType)

Add the AS clause to the CREATE SEQUENCE statement.

@NotNull CreateTableWithDataStep

CreateTableAsStep.as(Select<?> select)

Add the AS clause to the CREATE TABLE statement.

@NotNull DDLQuery

CreateTriggerActionStep.as(Collection<? extends Statement> body)

Add the AS clause to the CREATE TRIGGER statement.

@NotNull DDLQuery

CreateTriggerActionStep.as(Statement body)

Add the AS clause to the CREATE TRIGGER statement.

@NotNull DDLQuery

CreateTriggerActionStep.as(Statement... body)

Add the AS clause to the CREATE TRIGGER statement.

@NotNull CreateTypeFinalStep

CreateTypeStep.as(Collection<? extends Field<?>> attributes)

Add the AS clause to the CREATE TYPE statement.

@NotNull CreateTypeFinalStep

CreateTypeStep.as(Field<?>... attributes)

Add the AS clause to the CREATE TYPE statement.

@NotNull CreateViewFinalStep

CreateViewAsStep.as(String query)

Add the AS clause to the CREATE VIEW statement.

@NotNull CreateViewFinalStep

CreateViewAsStep.as(String query, Object... bindings)

Add the AS clause to the CREATE VIEW statement.

@NotNull CreateViewFinalStep

CreateViewAsStep.as(String query, QueryPart... parts)

Add the AS clause to the CREATE VIEW statement.

@NotNull CreateViewFinalStep

CreateViewAsStep.as(ResultQuery<? extends R> query)

Add the AS clause to the CREATE VIEW statement.

@NotNull CreateViewFinalStep

CreateViewAsStep.as(SQL query)

Add the AS clause to the CREATE VIEW statement.

<R extends Record>
@NotNull CommonTableExpression<R>

DerivedColumnList.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record1<?>>
@NotNull CommonTableExpression<R>

DerivedColumnList1.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList10.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList11.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList12.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList13.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList14.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList15.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList16.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList17.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList18.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList19.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record2<?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList2.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList20.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList21.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record22<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList22.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record3<?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList3.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record4<?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList4.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record5<?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList5.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record6<?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList6.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record7<?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList7.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record8<?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList8.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record9<?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList9.as(ResultQuery<R> query)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

@NotNull Field<T>

Field.as(String alias)

@NotNull Field<T>

Field.as(Function<? super Field<T>,? extends String> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Field<T>

Field.as(Field<?> otherField)

@NotNull Field<T>

Field.as(Name alias)

@NotNull WindowDefinition

Name.as()

Create an empty WindowDefinition from this name.

<R extends Record>
@NotNull CommonTableExpression<R>

Name.as(ResultQuery<R> query)

Specify a subselect to refer to by the Name to form a common table expression.

@NotNull WindowDefinition

Name.as(WindowSpecification window)

Create a WindowDefinition from this name.

@NotNull SelectField<T>

SelectField.as(String alias)

Create an alias for this field.

@NotNull SelectField<T>

SelectField.as(Field<?> otherField)

Create an alias for this field based on another field's name.

@NotNull SelectField<T>

SelectField.as(Name alias)

Create an alias for this field.

@NotNull Table<R>

Table.as(String alias)

Create an alias for this table.

@NotNull Table<R>

Table.as(String alias, String... fieldAliases)

Create an alias for this table and its fields.

@NotNull Table<R>

Table.as(String alias, Collection<? extends String> fieldAliases)

Create an alias for this table and its fields.

@NotNull Table<R>

Table.as(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

Table.as(String alias, Function<? super Field<?>,? extends String> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

Table.as(Name alias)

Create an alias for this table.

@NotNull Table<R>

Table.as(Name alias, Collection<? extends Name> fieldAliases)

Create an alias for this table and its fields.

@NotNull Table<R>

Table.as(Name alias, BiFunction<? super Field<?>,? super Integer,? extends Name> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

Table.as(Name alias, Function<? super Field<?>,? extends Name> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

Table.as(Name alias, Name... fieldAliases)

Create an alias for this table and its fields.

@NotNull Table<R>

Table.as(Table<?> otherTable)

Create an alias for this table based on another table's name.

@NotNull Table<R>

Table.as(Table<?> otherTable, Collection<? extends Field<?>> otherFields)

Create an alias for this table based on another table's name.

@NotNull Table<R>

Table.as(Table<?> otherTable, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

Table.as(Table<?> otherTable, Function<? super Field<?>,? extends Field<?>> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

Table.as(Table<?> otherTable, Field<?>... otherFields)

Create an alias for this table based on another table's name.

@NotNull WithStep

WithAsStep.as(ResultQuery<?> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep1.as(ResultQuery<? extends Record1<?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep10.as(ResultQuery<? extends Record10<?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep11.as(ResultQuery<? extends Record11<?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep12.as(ResultQuery<? extends Record12<?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep13.as(ResultQuery<? extends Record13<?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep14.as(ResultQuery<? extends Record14<?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep15.as(ResultQuery<? extends Record15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep16.as(ResultQuery<? extends Record16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep17.as(ResultQuery<? extends Record17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep18.as(ResultQuery<? extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep19.as(ResultQuery<? extends Record19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep2.as(ResultQuery<? extends Record2<?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep20.as(ResultQuery<? extends Record20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep21.as(ResultQuery<? extends Record21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep22.as(ResultQuery<? extends Record22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep3.as(ResultQuery<? extends Record3<?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep4.as(ResultQuery<? extends Record4<?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep5.as(ResultQuery<? extends Record5<?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep6.as(ResultQuery<? extends Record6<?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep7.as(ResultQuery<? extends Record7<?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep8.as(ResultQuery<? extends Record8<?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep9.as(ResultQuery<? extends Record9<?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull SortField<T>

Field.asc()

Create an ascending sort field from this field.

@NotNull Field<Integer>

Field.ascii()

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.13 - [#9407] - Use DSL.ascii(Field) instead.

@NotNull CreateTypeFinalStep

CreateTypeStep.asEnum()

Add the AS ENUM clause to the CREATE TYPE statement.

@NotNull CreateTypeFinalStep

CreateTypeStep.asEnum(String... values)

Add the AS ENUM clause to the CREATE TYPE statement.

@NotNull CreateTypeFinalStep

CreateTypeStep.asEnum(Collection<? extends Field<String>> values)

Add the AS ENUM clause to the CREATE TYPE statement.

@NotNull CreateTypeFinalStep

CreateTypeStep.asEnum(Field<String>... values)

Add the AS ENUM clause to the CREATE TYPE statement.

<T> @NotNull Field<T>

FieldLike.asField(Function<? super Field<T>,? extends String> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Field<BigDecimal>

Field.asin()

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.11 - [#7538] - Use DSL.asin(Field) instead.

<R extends Record>
@NotNull CommonTableExpression<R>

DerivedColumnList.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record1<?>>
@NotNull CommonTableExpression<R>

DerivedColumnList1.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList10.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList11.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList12.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList13.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList14.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList15.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList16.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList17.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList18.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList19.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record2<?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList2.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList20.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList21.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record22<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList22.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record3<?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList3.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record4<?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList4.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record5<?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList5.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record6<?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList6.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record7<?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList7.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record8<?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList8.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record9<?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList9.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record>
@NotNull CommonTableExpression<R>

Name.asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the Name to form a common table expression.

@NotNull WithStep

WithAsStep.asMaterialized(ResultQuery<?> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep1.asMaterialized(ResultQuery<? extends Record1<?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep10.asMaterialized(ResultQuery<? extends Record10<?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep11.asMaterialized(ResultQuery<? extends Record11<?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep12.asMaterialized(ResultQuery<? extends Record12<?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep13.asMaterialized(ResultQuery<? extends Record13<?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep14.asMaterialized(ResultQuery<? extends Record14<?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep15.asMaterialized(ResultQuery<? extends Record15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep16.asMaterialized(ResultQuery<? extends Record16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep17.asMaterialized(ResultQuery<? extends Record17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep18.asMaterialized(ResultQuery<? extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep19.asMaterialized(ResultQuery<? extends Record19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep2.asMaterialized(ResultQuery<? extends Record2<?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep20.asMaterialized(ResultQuery<? extends Record20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep21.asMaterialized(ResultQuery<? extends Record21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep22.asMaterialized(ResultQuery<? extends Record22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep3.asMaterialized(ResultQuery<? extends Record3<?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep4.asMaterialized(ResultQuery<? extends Record4<?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep5.asMaterialized(ResultQuery<? extends Record5<?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep6.asMaterialized(ResultQuery<? extends Record6<?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep7.asMaterialized(ResultQuery<? extends Record7<?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep8.asMaterialized(ResultQuery<? extends Record8<?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep9.asMaterialized(ResultQuery<? extends Record9<?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull Field<Result<R>>

TableLike.asMultiset()

Turn this TableLike expression into a DSL.multiset(TableLike).

@NotNull Field<Result<R>>

TableLike.asMultiset(String alias)

Turn this TableLike expression into a DSL.multiset(TableLike).

@NotNull Field<Result<R>>

TableLike.asMultiset(Field<?> alias)

Turn this TableLike expression into a DSL.multiset(TableLike).

@NotNull Field<Result<R>>

TableLike.asMultiset(Name alias)

Turn this TableLike expression into a DSL.multiset(TableLike).

<R extends Record>
@NotNull CommonTableExpression<R>

DerivedColumnList.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record1<?>>
@NotNull CommonTableExpression<R>

DerivedColumnList1.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList10.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList11.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList12.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList13.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList14.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList15.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList16.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList17.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList18.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList19.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record2<?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList2.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList20.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList21.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record22<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList22.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record3<?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList3.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record4<?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList4.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record5<?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList5.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record6<?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList6.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record7<?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList7.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record8<?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList8.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record9<?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>

DerivedColumnList9.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

<R extends Record>
@NotNull CommonTableExpression<R>

Name.asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the Name to form a common table expression.

@NotNull WithStep

WithAsStep.asNotMaterialized(ResultQuery<?> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep1.asNotMaterialized(ResultQuery<? extends Record1<?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep10.asNotMaterialized(ResultQuery<? extends Record10<?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep11.asNotMaterialized(ResultQuery<? extends Record11<?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep12.asNotMaterialized(ResultQuery<? extends Record12<?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep13.asNotMaterialized(ResultQuery<? extends Record13<?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep14.asNotMaterialized(ResultQuery<? extends Record14<?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep15.asNotMaterialized(ResultQuery<? extends Record15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep16.asNotMaterialized(ResultQuery<? extends Record16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep17.asNotMaterialized(ResultQuery<? extends Record17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep18.asNotMaterialized(ResultQuery<? extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep19.asNotMaterialized(ResultQuery<? extends Record19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep2.asNotMaterialized(ResultQuery<? extends Record2<?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep20.asNotMaterialized(ResultQuery<? extends Record20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep21.asNotMaterialized(ResultQuery<? extends Record21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep22.asNotMaterialized(ResultQuery<? extends Record22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep3.asNotMaterialized(ResultQuery<? extends Record3<?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep4.asNotMaterialized(ResultQuery<? extends Record4<?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep5.asNotMaterialized(ResultQuery<? extends Record5<?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep6.asNotMaterialized(ResultQuery<? extends Record6<?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep7.asNotMaterialized(ResultQuery<? extends Record7<?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep8.asNotMaterialized(ResultQuery<? extends Record8<?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep9.asNotMaterialized(ResultQuery<? extends Record9<?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull PeriodSpecification

Period.asOf(Field<T> field)

Create a period specification for a given timestamp.

@NotNull PeriodSpecification

Period.asOf(T value)

Create a period specification for a given timestamp.

@NotNull Table<R>

Table.asOfScn(Number scn)

Create an SQLDialect.ORACLE flashback query clause from this table.

@NotNull Table<R>

Table.asOfScn(Field<? extends Number> scn)

Create an SQLDialect.ORACLE flashback query clause from this table.

@NotNull Table<R>

Table.asOfTimestamp(Timestamp timestamp)

Create an SQLDialect.ORACLE flashback query clause from this table.

@NotNull Table<R>

Table.asOfTimestamp(Field<Timestamp> timestamp)

Create an SQLDialect.ORACLE flashback query clause from this table.

@NotNull Table<R>

TableLike.asTable()

The underlying table representation of this object.

@NotNull Table<R>

TableLike.asTable(String alias)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(String alias, String... fieldAliases)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(String alias, Collection<? extends String> fieldAliases)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

TableLike.asTable(String alias, Function<? super Field<?>,? extends String> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

TableLike.asTable(Name alias)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(Name alias, Collection<? extends Name> fieldAliases)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(Name alias, Name... fieldAliases)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(Table<?> alias)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(Table<?> alias, Collection<? extends Field<?>> fieldAliases)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(Table<?> alias, Field<?>... fieldAliases)

The underlying aliased table representation of this object.

@NotNull QualifiedAsterisk

Table.asterisk()

Create a qualified asterisk expression from this table (table.*) for use with SELECT.

@NotNull Table<R>

Table.at(String link)

A table reference of this table at a given Link.

@NotNull Table<R>

Table.at(Link link)

A table reference of this table at a given Link.

@NotNull Table<R>

Table.at(Name link)

A table reference of this table at a given Link.

@NotNull Field<BigDecimal>

Field.atan()

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.11 - [#7538] - Use DSL.atan(Field) instead.

@NotNull Field<BigDecimal>

Field.atan2(Number y)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.11 - [#7538] - Use DSL.atan2(Field, Number) instead.

@NotNull Field<BigDecimal>

Field.atan2(Field<? extends Number> y)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.11 - [#7538] - Use DSL.atan2(Field, Field) instead.

@NotNull SelectForJSONCommonDirectivesStep<R>

SelectForJSONStep.auto()

Add a SQL Server-style FOR JSON AUTO clause.

@NotNull SelectForXMLRawDirectivesStep<R>

SelectForXMLStep.auto()

Add a SQL Server-style FOR XML AUTO clause.

@NotNull DataType<T>

DataType.autoIncrement()

Return a new data type like this, with the DataType.identity(boolean) flag set to true.

@NotNull Field<BigDecimal>

Field.avg()

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.11 - [#7538] - Use DSL.avg(Field) instead.

@NotNull WindowPartitionByStep<BigDecimal>

Field.avgOver()

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.11 - [#7538] - Use DSL.avg(Field) instead.

@NotNull BatchBindStep

DSLContext.batch(String sql)

Create a batch statement to execute a set of queries in batch mode (with bind values).

@NotNull Batch

DSLContext.batch(String... queries)

Create a batch statement to execute a set of queries in batch mode (without bind values).

@NotNull Batch

DSLContext.batch(String sql, Object[]... bindings)

Create a batch statement to execute a set of queries in batch mode (with bind values).

@NotNull Batch

DSLContext.batch(Collection<? extends Query> queries)

Create a batch statement to execute a set of queries in batch mode (without bind values).

@NotNull Batch

DSLContext.batch(Queries queries)

Create a batch statement to execute a set of queries in batch mode (without bind values).

@NotNull BatchBindStep

DSLContext.batch(Query query)

Create a batch statement to execute a set of queries in batch mode (with bind values).

@NotNull Batch

DSLContext.batch(Query... queries)

Create a batch statement to execute a set of queries in batch mode (without bind values).

@NotNull Batch

DSLContext.batch(Query query, Object[]... bindings)

Create a batch statement to execute a set of queries in batch mode (with bind values).

@NotNull LoaderOptionsStep<R>

LoaderOptionsStep.batchAfter(int number)

Batch a given number of bulk statements together.

@NotNull LoaderOptionsStep<R>

LoaderOptionsStep.batchAll()

Batch all bulk statements in one JDBC batch statement.

@NotNull Batch

DSLContext.batchDelete(Collection<? extends UpdatableRecord<?>> records)

Create a batch statement to execute a set of DELETE queries in batch mode (with bind values) according to UpdatableRecord.delete() sematics.

@NotNull Batch

DSLContext.batchDelete(UpdatableRecord<?>... records)

Create a batch statement to execute a set of DELETE queries in batch mode (with bind values) according to UpdatableRecord.delete() sematics.

@NotNull Batch

DSLContext.batchInsert(Collection<? extends TableRecord<?>> records)

Create a batch statement to execute a set of INSERT queries in batch mode (with bind values) according to TableRecord.insert() semantics.

@NotNull Batch

DSLContext.batchInsert(TableRecord<?>... records)

Create a batch statement to execute a set of INSERT queries in batch mode (with bind values) according to TableRecord.insert() semantics.

@NotNull Batch

DSLContext.batchMerge(Collection<? extends UpdatableRecord<?>> records)

Create a batch statement to execute a set of MERGE queries in batch mode (with bind values) according to UpdatableRecord.merge() semantics.

@NotNull Batch

DSLContext.batchMerge(UpdatableRecord<?>... records)

Create a batch statement to execute a set of MERGE queries in batch mode (with bind values) according to UpdatableRecord.merge() semantics.

@NotNull LoaderOptionsStep<R>

LoaderOptionsStep.batchNone()

Do not batch bulk statements together.

@NotNull Batch

DSLContext.batchStore(Collection<? extends UpdatableRecord<?>> records)

Create a batch statement to execute a set of INSERT and UPDATE queries in batch mode (with bind values) according to UpdatableRecord.store() semantics.

@NotNull Batch

DSLContext.batchStore(UpdatableRecord<?>... records)

Create a batch statement to execute a set of INSERT and UPDATE queries in batch mode (with bind values) according to UpdatableRecord.store() semantics.

@NotNull Batch

DSLContext.batchUpdate(Collection<? extends UpdatableRecord<?>> records)

Create a batch statement to execute a set of UPDATE queries in batch mode (with bind values) according to UpdatableRecord.update() semantics.

@NotNull Batch

DSLContext.batchUpdate(UpdatableRecord<?>... records)

Create a batch statement to execute a set of UPDATE queries in batch mode (with bind values) according to UpdatableRecord.update() semantics.

@NotNull AlterTableFinalStep

AlterTableAddStep.before(String columnName)

Add a BEFORE clause to ALTER TABLE … ADD ….

@NotNull AlterTableFinalStep

AlterTableAddStep.before(Field<?> columnName)

Add a BEFORE clause to ALTER TABLE … ADD ….

@NotNull AlterTableFinalStep

AlterTableAddStep.before(Name columnName)

Add a BEFORE clause to ALTER TABLE … ADD ….

@NotNull CreateTriggerEventOrStep

CreateTriggerEventStep.beforeDelete()

Add the BEFORE DELETE clause to the CREATE TRIGGER statement.

@NotNull CreateTriggerEventOrStep

CreateTriggerEventStep.beforeInsert()

Add the BEFORE INSERT clause to the CREATE TRIGGER statement.

@NotNull CreateTriggerEventOfStep

CreateTriggerEventStep.beforeUpdate()

Add the BEFORE UPDATE clause to the CREATE TRIGGER statement.

@NotNull Block

DSLContext.begin(Collection<? extends Statement> statements)

Wrap a collection of statements in an anoymous procedural block.

@NotNull Block

DSLContext.begin(Statement... statements)

Wrap a collection of statements in an anonymous procedural block.

@NotNull BetweenAndStep<T>

Field.between(Field<T> minValue)

Create a condition to check this field against some bounds.

@NotNull Condition

Field.between(Field<T> minValue, Field<T> maxValue)

Create a condition to check this field against some bounds.

@NotNull BetweenAndStep<T>

Field.between(T minValue)

Create a condition to check this field against some bounds.

@NotNull Condition

Field.between(T minValue, T maxValue)

Create a condition to check this field against some bounds.

@NotNull PeriodSpecificationBetweenAndStep<T>

Period.between(Field<T> start)

Create a period specification for a given timestamp range overlapping with this period, including the end value.

@NotNull PeriodSpecification

Period.between(Field<T> start, Field<T> end)

Create a period specification for a given timestamp range overlapping with this period, including the end value.

@NotNull PeriodSpecificationBetweenAndStep<T>

Period.between(T start)

Create a period specification for a given timestamp range overlapping with this period, including the end value.

@NotNull PeriodSpecification

Period.between(T start, T end)

Create a period specification for a given timestamp range overlapping with this period, including the end value.

@NotNull BetweenAndStep1<T1>

Row1.between(Field<T1> minValue1)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep1<T1>

Row1.between(Record1<T1> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row1.between(Record1<T1> minValue, Record1<T1> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep1<T1>

Row1.between(Row1<T1> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row1.between(Row1<T1> minValue, Row1<T1> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep1<T1>

Row1.between(T1 minValue1)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

Row10.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

Row10.between(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row10.between(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

Row10.between(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row10.between(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

Row10.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

Row11.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

Row11.between(Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row11.between(Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> minValue, Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

Row11.between(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row11.between(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> minValue, Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

Row11.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

Row12.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

Row12.between(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row12.between(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue, Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

Row12.between(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row12.between(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue, Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

Row12.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

Row13.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

Row13.between(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row13.between(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue, Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

Row13.between(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row13.between(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue, Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

Row13.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

Row14.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

Row14.between(Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row14.between(Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> minValue, Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

Row14.between(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row14.between(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> minValue, Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

Row14.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

Row15.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

Row15.between(Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row15.between(Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> minValue, Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

Row15.between(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row15.between(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> minValue, Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

Row15.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

Row16.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

Row16.between(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row16.between(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue, Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

Row16.between(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row16.between(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue, Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

Row16.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

Row17.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16, Field<T17> minValue17)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

Row17.between(Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row17.between(Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> minValue, Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

Row17.between(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row17.between(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> minValue, Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

Row17.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

Row18.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16, Field<T17> minValue17, Field<T18> minValue18)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

Row18.between(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row18.between(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue, Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

Row18.between(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row18.between(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue, Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

Row18.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

Row19.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16, Field<T17> minValue17, Field<T18> minValue18, Field<T19> minValue19)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

Row19.between(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row19.between(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

Row19.between(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row19.between(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

Row19.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18, T19 minValue19)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep2<T1,T2>

Row2.between(Field<T1> minValue1, Field<T2> minValue2)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep2<T1,T2>

Row2.between(Record2<T1,T2> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row2.between(Record2<T1,T2> minValue, Record2<T1,T2> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep2<T1,T2>

Row2.between(Row2<T1,T2> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row2.between(Row2<T1,T2> minValue, Row2<T1,T2> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep2<T1,T2>

Row2.between(T1 minValue1, T2 minValue2)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

Row20.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16, Field<T17> minValue17, Field<T18> minValue18, Field<T19> minValue19, Field<T20> minValue20)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

Row20.between(Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row20.between(Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> minValue, Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

Row20.between(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row20.between(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> minValue, Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

Row20.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18, T19 minValue19, T20 minValue20)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

Row21.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16, Field<T17> minValue17, Field<T18> minValue18, Field<T19> minValue19, Field<T20> minValue20, Field<T21> minValue21)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

Row21.between(Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row21.between(Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> minValue, Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

Row21.between(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row21.between(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> minValue, Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

Row21.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18, T19 minValue19, T20 minValue20, T21 minValue21)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

Row22.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16, Field<T17> minValue17, Field<T18> minValue18, Field<T19> minValue19, Field<T20> minValue20, Field<T21> minValue21, Field<T22> minValue22)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

Row22.between(Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row22.between(Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> minValue, Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

Row22.between(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row22.between(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> minValue, Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

Row22.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18, T19 minValue19, T20 minValue20, T21 minValue21, T22 minValue22)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep3<T1,T2,T3>

Row3.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep3<T1,T2,T3>

Row3.between(Record3<T1,T2,T3> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row3.between(Record3<T1,T2,T3> minValue, Record3<T1,T2,T3> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep3<T1,T2,T3>

Row3.between(Row3<T1,T2,T3> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row3.between(Row3<T1,T2,T3> minValue, Row3<T1,T2,T3> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep3<T1,T2,T3>

Row3.between(T1 minValue1, T2 minValue2, T3 minValue3)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep4<T1,T2,T3,T4>

Row4.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep4<T1,T2,T3,T4>

Row4.between(Record4<T1,T2,T3,T4> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row4.between(Record4<T1,T2,T3,T4> minValue, Record4<T1,T2,T3,T4> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep4<T1,T2,T3,T4>

Row4.between(Row4<T1,T2,T3,T4> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row4.between(Row4<T1,T2,T3,T4> minValue, Row4<T1,T2,T3,T4> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep4<T1,T2,T3,T4>

Row4.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep5<T1,T2,T3,T4,T5>

Row5.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep5<T1,T2,T3,T4,T5>

Row5.between(Record5<T1,T2,T3,T4,T5> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row5.between(Record5<T1,T2,T3,T4,T5> minValue, Record5<T1,T2,T3,T4,T5> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep5<T1,T2,T3,T4,T5>

Row5.between(Row5<T1,T2,T3,T4,T5> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row5.between(Row5<T1,T2,T3,T4,T5> minValue, Row5<T1,T2,T3,T4,T5> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep5<T1,T2,T3,T4,T5>

Row5.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep6<T1,T2,T3,T4,T5,T6>

Row6.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep6<T1,T2,T3,T4,T5,T6>

Row6.between(Record6<T1,T2,T3,T4,T5,T6> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row6.between(Record6<T1,T2,T3,T4,T5,T6> minValue, Record6<T1,T2,T3,T4,T5,T6> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep6<T1,T2,T3,T4,T5,T6>

Row6.between(Row6<T1,T2,T3,T4,T5,T6> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row6.between(Row6<T1,T2,T3,T4,T5,T6> minValue, Row6<T1,T2,T3,T4,T5,T6> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep6<T1,T2,T3,T4,T5,T6>

Row6.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>

Row7.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>

Row7.between(Record7<T1,T2,T3,T4,T5,T6,T7> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row7.between(Record7<T1,T2,T3,T4,T5,T6,T7> minValue, Record7<T1,T2,T3,T4,T5,T6,T7> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>

Row7.between(Row7<T1,T2,T3,T4,T5,T6,T7> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row7.between(Row7<T1,T2,T3,T4,T5,T6,T7> minValue, Row7<T1,T2,T3,T4,T5,T6,T7> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>

Row7.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep8<T1,T2,T3,T4,T5,T6,T7,T8>

Row8.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep8<T1,T2,T3,T4,T5,T6,T7,T8>

Row8.between(Record8<T1,T2,T3,T4,T5,T6,T7,T8> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row8.between(Record8<T1,T2,T3,T4,T5,T6,T7,T8> minValue, Record8<T1,T2,T3,T4,T5,T6,T7,T8> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep8<T1,T2,T3,T4,T5,T6,T7,T8>

Row8.between(Row8<T1,T2,T3,T4,T5,T6,T7,T8> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row8.between(Row8<T1,T2,T3,T4,T5,T6,T7,T8> minValue, Row8<T1,T2,T3,T4,T5,T6,T7,T8> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep8<T1,T2,T3,T4,T5,T6,T7,T8>

Row8.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9>

Row9.between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9>

Row9.between(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

Row9.between(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> minValue, Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9>

Row9.between(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

Row9.between(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> minValue, Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9>

Row9.between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStepN

RowN.between(Object... minValues)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStepN

RowN.between(Field<?>... minValues)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStepN

RowN.between(Record minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

RowN.between(Record minValue, Record maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStepN

RowN.between(RowN minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

RowN.between(RowN minValue, RowN maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep<R>

SelectCorrelatedSubqueryStep.between(Select<? extends R> minValue)

Check if this subquery is within a range of two subqueries.

@NotNull Condition

SelectCorrelatedSubqueryStep.between(Select<? extends R> minValue, Select<? extends R> maxValue)

Check if this subquery is within a range of two subqueries.

@NotNull BetweenAndStep<R>

SelectCorrelatedSubqueryStep.between(R minValue)

Check if this subquery is within a range of two records.

@NotNull Condition

SelectCorrelatedSubqueryStep.between(R minValue, R maxValue)

Check if this subquery is within a range of two records.

@NotNull BetweenAndStep<T>

Field.betweenSymmetric(Field<T> minValue)

Create a condition to check this field against some bounds.

@NotNull Condition

Field.betweenSymmetric(Field<T> minValue, Field<T> maxValue)

Create a condition to check this field against some bounds.

@NotNull BetweenAndStep<T>

Field.betweenSymmetric(T minValue)

Create a condition to check this field against some bounds.

@NotNull Condition

Field.betweenSymmetric(T minValue, T maxValue)

Create a condition to check this field against some bounds.

@NotNull BetweenAndStep1<T1>

Row1.betweenSymmetric(Field<T1> minValue1)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep1<T1>

Row1.betweenSymmetric(Record1<T1> minValue)

Check if this row value expression is within a symmetric range of two records.

@NotNull Condition

Row1.betweenSymmetric(Record1<T1> minValue, Record1<T1> maxValue)

Check if this row value expression is within a symmetric range of two records.

@NotNull BetweenAndStep1<T1>

Row1.betweenSymmetric(Row1<T1> minValue)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull Condition

Row1.betweenSymmetric(Row1<T1> minValue, Row1<T1> maxValue)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep1<T1>

Row1.betweenSymmetric(T1 minValue1)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

Row10.betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

Row10.betweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)

Check if this row value expression is within a symmetric range of two records.

@NotNull Condition

Row10.betweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)

Check if this row value expression is within a symmetric range of two records.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

Row10.betweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull Condition

Row10.betweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

Row10.betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

Row11.betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

Row11.betweenSymmetric(Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> minValue)

Check if this row value expression is within a symmetric range of two records.

@NotNull Condition

Row11.betweenSymmetric(Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> minValue, Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> maxValue)

Check if this row value expression is within a symmetric range of two records.

@NotNull BetweenAndStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

Row11.betweenSymmetric(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> minValue)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull Condition

Row11.betweenSymmetric(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> minValue, Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> maxValue)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

Row11.betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

Row12.betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

Row12.betweenSymmetric(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue)

Check if this row value expression is within a symmetric range of two records.

@NotNull Condition

Row12.betweenSymmetric(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue, Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> maxValue)

Check if this row value expression is within a symmetric range of two records.

@NotNull BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>