Uses of Interface org.jooq.Field (jOOQ 3.16.23 API)

Packages that use Field

Package

Description

org.jooq

This package contains jOOQ's public API.

org.jooq.impl

This package contains jOOQ's implementation classes.

org.jooq.tools

This package contains jOOQ's public utilities.

org.jooq.util.cubrid

This package contains classes related to the SQLDialect.CUBRID dialect family.

org.jooq.util.mariadb

This package contains classes related to the SQLDialect.MARIADB dialect family.

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.sqlite

This package contains classes related to the SQLDialect.SQLITE dialect family.

org.jooq.util.sqlserver

This package contains classes related to the SQLDialect.SQLSERVER dialect family.

Uses of Field in org.jooq

Subinterfaces of Field in org.jooq

Modifier and Type

Interface

Description

interface

AggregateFilterStep<T>

The step in the specification of aggregate functions where the SQL:2003 standard FILTER clause can be added.

interface

AggregateFunction<T>

An aggregate function.

interface

ArrayAggOrderByStep<T>

The SQL standard ARRAY_AGG() function.

interface

CaseConditionStep<T>

The final step in creating a case statement of the type

interface

CaseWhenStep<V,T>

The final step in creating a case statement of the type

interface

GroupConcatOrderByStep

MySQL's GROUP_CONCAT function.

interface

GroupConcatSeparatorStep

MySQL's GROUP_CONCAT function.

interface

JSONArrayAggNullStep<T>

A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the NULL clause can be defined.

interface

JSONArrayAggOrderByStep<J>

A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the ORDER BY clause can be defined.

interface

JSONArrayAggReturningStep<T>

A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the RETURNING clause can be defined.

interface

JSONArrayNullStep<T>

A step in the construction of the JSON ARRAY function.

interface

JSONArrayReturningStep<T>

A step in the construction of the JSON ARRAY function.

interface

JSONObjectAggNullStep<T>

A step in the construction of DSL.jsonObjectAgg(JSONEntry) or DSL.jsonbObjectAgg(JSONEntry) functions where the NULL clause can be defined.

interface

JSONObjectAggReturningStep<T>

A step in the construction of DSL.jsonObjectAgg(JSONEntry) or DSL.jsonbObjectAgg(JSONEntry) functions where the RETURNING clause can be defined.

interface

JSONObjectNullStep<T>

A step in the construction of the JSON OBJECT function.

interface

JSONObjectReturningStep<T>

A step in the construction of the JSON OBJECT function.

interface

JSONValueOnStep<J>

A step in the construction of DSL.jsonValue(Field, Field) or DSL.jsonbValue(Field, Field) functions where the ON EMPTY and ON ERROR clauses can be defined.

interface

JSONValueReturningStep<T>

A step in the construction of the JSON VALUE function.

interface

Param<T>

A named parameter and/or bind value.

interface

Parameter<T>

A parameter to a stored procedure or function.

interface

ParamOrVariable<T>

A common super type of Param and Variable.

interface

TableField<R extends Record,T>

A field contained in a table.

interface

UDTField<R extends UDTRecord<R>,T>

A field contained in a UDT.

interface

Variable<T>

A local variable reference.

interface

WindowBeforeOverStep<T>

This type is used for the window function DSL API.

interface

WindowExcludeStep<T>

This type is used for the window function DSL API.

interface

WindowFinalStep<T>

Deprecated, for removal: This API element is subject to removal in a future version.
- [#11329] - 3.15.0 - This type will be removed in the future.

interface

WindowOrderByStep<T>

This type is used for the window function DSL API.

interface

WindowPartitionByStep<T>

This type is used for the window function DSL API.

interface

WindowRowsStep<T>

This type is used for the window function DSL API.

interface

XMLAggOrderByStep<T>

The SQL standard ARRAY_AGG() function.

Methods in org.jooq that return Field

Modifier and Type

Method

Description

@NotNull Field<T>

SortField.$field()

Experimental query object model accessor method, see also QOM.

@NotNull Field<String>

JSONEntry.$key()

Experimental query object model accessor method, see also QOM.

@NotNull Field<?>

JSONEntry.$value()

Experimental query object model accessor method, see also QOM.

@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 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 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 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>

SelectField.as(String alias)

Create an alias for this field.

@NotNull Field<T>

SelectField.as(Field<?> otherField)

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

@NotNull Field<T>

SelectField.as(Name alias)

Create an alias for 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.

<T> @NotNull Field<T>

FieldLike.asField()

The underlying field representation of this object.

<T> @NotNull Field<T>

FieldLike.asField(String alias)

The underlying field representation of this object.

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

@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 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 Field<T>

Field.bitAnd(Field<T> arg2)

The BIT_AND operator.

@NotNull Field<T>

Field.bitAnd(T arg2)

The BIT_AND operator.

@NotNull Field<Integer>

Field.bitLength()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.bitLength(Field) instead.

@NotNull Field<T>

Field.bitNand(Field<T> arg2)

The BIT_NAND operator.

@NotNull Field<T>

Field.bitNand(T arg2)

The BIT_NAND operator.

@NotNull Field<T>

Field.bitNor(Field<T> arg2)

The BIT_NOR operator.

@NotNull Field<T>

Field.bitNor(T arg2)

The BIT_NOR operator.

@NotNull Field<T>

Field.bitNot()

The BIT_NOT operator.

@NotNull Field<T>

Field.bitOr(Field<T> arg2)

The BIT_OR operator.

@NotNull Field<T>

Field.bitOr(T arg2)

The BIT_OR operator.

@NotNull Field<T>

Field.bitXNor(Field<T> arg2)

The BIT_X_NOR operator.

@NotNull Field<T>

Field.bitXNor(T arg2)

The BIT_X_NOR operator.

@NotNull Field<T>

Field.bitXor(Field<T> arg2)

The BIT_XOR operator.

@NotNull Field<T>

Field.bitXor(T arg2)

The BIT_XOR operator.

<Z> @NotNull Field<Z>

Field.cast(Class<Z> type)

Cast this field to another type.

<Z> @NotNull Field<Z>

Field.cast(DataType<Z> type)

Cast this field to a dialect-specific data type.

<Z> @NotNull Field<Z>

Field.cast(Field<Z> field)

Cast this field to the type of another field.

@NotNull Field<T>

Field.ceil()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.ceil(Field) instead.

@NotNull Field<Integer>

Field.charLength()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.charLength(Field) instead.

@NotNull Field<T>

Field.coalesce(Field<T> option, Field<?>... options)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.coalesce(Field, Field...) instead.

@NotNull Field<T>

Field.coalesce(T option, T... options)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.coalesce(Object, Object...) instead.

<Z> @NotNull Field<Z>

Field.coerce(Class<Z> type)

Coerce this field to another type.

<Z> @NotNull Field<Z>

Field.coerce(DataType<Z> type)

Coerce this field to a dialect-specific data type.

<Z> @NotNull Field<Z>

Field.coerce(Field<Z> field)

Coerce this field to the type of another field.

@NotNull Field<String>

Field.collate(String collation)

Apply a collation operator to this column expression.

@NotNull Field<String>

Field.collate(Collation collation)

Apply a collation operator to this column expression.

@NotNull Field<String>

Field.collate(Name collation)

Apply a collation operator to this column expression.

@NotNull Field<String>

Field.concat(char... values)

This method is part of the pre-2.0 API.

@NotNull Field<String>

Field.concat(String... values)

This method is part of the pre-2.0 API.

@NotNull Field<String>

Field.concat(Field<?>... fields)

This method is part of the pre-2.0 API.

 @NotNull Field

Field.convert(Class toType, Function<? super T,? extends U> from, Function<? super U,? extends T> to)

Apply an ad-hoc data type Converter to this field expression.

 @NotNull Field

Field.convert(Binding<T,U> binding)

Apply an ad-hoc data type Binding to this field expression.

 @NotNull Field

Field.convert(Converter<T,U> converter)

Apply an ad-hoc data type Converter to this field expression.

 @NotNull Field

Field.convertFrom(Class toType, Function<? super T,? extends U> from)

Apply an ad-hoc read-only data type Converter to this field expression.

 @NotNull Field

Field.convertFrom(Function<? super T,? extends U> from)

Apply an ad-hoc read-only data type Converter to this field expression.

 @NotNull Field

Field.convertTo(Class toType, Function<? super U,? extends T> to)

Apply an ad-hoc write-only data type Converter to this field expression.

 @NotNull Field

Field.convertTo(Function<? super U,? extends T> to)

Apply an ad-hoc write-only data type Converter to this field expression.

@NotNull Field<BigDecimal>

Field.cos()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.cos(Field) instead.

@NotNull Field<BigDecimal>

Field.cosh()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.cosh(Field) instead.

@NotNull Field<BigDecimal>

Field.cot()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.cot(Field) instead.

@NotNull Field<BigDecimal>

Field.coth()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.coth(Field) instead.

@NotNull Field<Integer>

Field.count()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.count(Field) instead.

@NotNull Field<Integer>

Field.countDistinct()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.countDistinct(Field) instead.

@NotNull Field<T>

Sequence.currval()

An expression to get the current value of this sequence.

<Z> @NotNull Field<Z>

Field.decode(Field<T> search, Field<Z> result)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.decode(Field, Field, Field) instead.

<Z> @NotNull Field<Z>

Field.decode(Field<T> search, Field<Z> result, Field<?>... more)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.decode(Field, Field, Field, Field...) instead.

<Z> @NotNull Field<Z>

Field.decode(T search, Z result)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.decode(Object, Object, Object) instead.

<Z> @NotNull Field<Z>

Field.decode(T search, Z result, Object... more)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.decode(Object, Object, Object, Object...) instead.

@Nullable Field<T>

DataType.default_()

The expression to be applied as the DEFAULT value for this data type.

@Nullable Field<T>

DataType.defaultValue()

The expression to be applied as the DEFAULT value for this data type.

@NotNull Field<BigDecimal>

Field.deg()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.deg(Field) instead.

@NotNull Field<T>

Field.div(Number value)

An arithmetic expression dividing this by value.

@NotNull Field<T>

Field.div(Field<? extends Number> value)

An arithmetic expression dividing this by value.

@NotNull Field<T>

Field.divide(Number value)

An alias for div(Number).

@NotNull Field<T>

Field.divide(Field<? extends Number> value)

An alias for div(Field).

@NotNull Field<T>

CaseConditionStep.else_(Field<T> result)

Add an else clause to the already constructed case statement

@NotNull Field<T>

CaseConditionStep.else_(Select<? extends Record1<T>> result)

Add an else clause to the already constructed case statement

@NotNull Field<T>

CaseConditionStep.else_(T result)

Add an else clause to the already constructed case statement

@NotNull Field<T>

CaseWhenStep.else_(Field<T> result)

Add an else clause to the already constructed case statement

@NotNull Field<T>

CaseWhenStep.else_(T result)

Add an else clause to the already constructed case statement

@NotNull Field<BigDecimal>

Field.exp()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.exp(Field) instead.

@NotNull Field<Integer>

Field.extract(DatePart datePart)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.extract(Field, DatePart) instead.

@NotNull Field

BindingGetResultSetContext.field()

The Field at column index BindingGetResultSetContext.index() whose value is retrieved.

@Nullable Field<T>

Field.field(Record record)

The inverse operation of Fields.field(Field).

@Nullable Field<?>

Fields.field(int index)

Get a field known to this type by index, or null if no field is available at the index.

<T> @Nullable Field<T>

Fields.field(int index, Class<T> type)

Get a field known to this type by index coerced to type, or null if no field is available at the index.

<T> @Nullable Field<T>

Fields.field(int index, DataType<T> dataType)

Get a field known to this type by index coerced to dataType, or null if no field is available at the index.

@Nullable Field<?>

Fields.field(String name)

Get a field known to this type by unqualified name, or null if no field is known to this type by this name.

<T> @Nullable Field<T>

Fields.field(String name, Class<T> type)

Get a field known to this type by unqualified name coerced to type, or null if no field is known to this type by this name.

<T> @Nullable Field<T>

Fields.field(String name, DataType<T> dataType)

Get a field known to this type by unqualified name coerced to dataType, or null if no field is known to this type by this name.

<T> @Nullable Field<T>

Fields.field(Field<T> field)

Get a field known to this type by field reference.

@Nullable Field<?>

Fields.field(Name name)

Get a field known to this type by qualified name, or null if no field is known to this type by this name.

<T> @Nullable Field<T>

Fields.field(Name name, Class<T> type)

Get a field known to this type by qualified name coerced to type, or null if no field is known to this type by this name.

<T> @Nullable Field<T>

Fields.field(Name name, DataType<T> dataType)

Get a field known to this type by qualified name coerced to dataType, or null if no field is known to this type by this name.

Field<?>

LoaderFieldMapper.LoaderFieldContext.field()

The Field of the source data to be mapped.

@NotNull Field<T1>

Record1.field1()

Get the first field.

@NotNull Field<T1>

Record10.field1()

Get the first field.

@NotNull Field<T1>

Record11.field1()

Get the first field.

@NotNull Field<T1>

Record12.field1()

Get the first field.

@NotNull Field<T1>

Record13.field1()

Get the first field.

@NotNull Field<T1>

Record14.field1()

Get the first field.

@NotNull Field<T1>

Record15.field1()

Get the first field.

@NotNull Field<T1>

Record16.field1()

Get the first field.

@NotNull Field<T1>

Record17.field1()

Get the first field.

@NotNull Field<T1>

Record18.field1()

Get the first field.

@NotNull Field<T1>

Record19.field1()

Get the first field.

@NotNull Field<T1>

Record2.field1()

Get the first field.

@NotNull Field<T1>

Record20.field1()

Get the first field.

@NotNull Field<T1>

Record21.field1()

Get the first field.

@NotNull Field<T1>

Record22.field1()

Get the first field.

@NotNull Field<T1>

Record3.field1()

Get the first field.

@NotNull Field<T1>

Record4.field1()

Get the first field.

@NotNull Field<T1>

Record5.field1()

Get the first field.

@NotNull Field<T1>

Record6.field1()

Get the first field.

@NotNull Field<T1>

Record7.field1()

Get the first field.

@NotNull Field<T1>

Record8.field1()

Get the first field.

@NotNull Field<T1>

Record9.field1()

Get the first field.

@NotNull Field<T1>

Row1.field1()

Get the first field.

@NotNull Field<T1>

Row10.field1()

Get the first field.

@NotNull Field<T1>

Row11.field1()

Get the first field.

@NotNull Field<T1>

Row12.field1()

Get the first field.

@NotNull Field<T1>

Row13.field1()

Get the first field.

@NotNull Field<T1>

Row14.field1()

Get the first field.

@NotNull Field<T1>

Row15.field1()

Get the first field.

@NotNull Field<T1>

Row16.field1()

Get the first field.

@NotNull Field<T1>

Row17.field1()

Get the first field.

@NotNull Field<T1>

Row18.field1()

Get the first field.

@NotNull Field<T1>

Row19.field1()

Get the first field.

@NotNull Field<T1>

Row2.field1()

Get the first field.

@NotNull Field<T1>

Row20.field1()

Get the first field.

@NotNull Field<T1>

Row21.field1()

Get the first field.

@NotNull Field<T1>

Row22.field1()

Get the first field.

@NotNull Field<T1>

Row3.field1()

Get the first field.

@NotNull Field<T1>

Row4.field1()

Get the first field.

@NotNull Field<T1>

Row5.field1()

Get the first field.

@NotNull Field<T1>

Row6.field1()

Get the first field.

@NotNull Field<T1>

Row7.field1()

Get the first field.

@NotNull Field<T1>

Row8.field1()

Get the first field.

@NotNull Field<T1>

Row9.field1()

Get the first field.

@NotNull Field<T10>

Record10.field10()

Get the tenth field.

@NotNull Field<T10>

Record11.field10()

Get the tenth field.

@NotNull Field<T10>

Record12.field10()

Get the tenth field.

@NotNull Field<T10>

Record13.field10()

Get the tenth field.

@NotNull Field<T10>

Record14.field10()

Get the tenth field.

@NotNull Field<T10>

Record15.field10()

Get the tenth field.

@NotNull Field<T10>

Record16.field10()

Get the tenth field.

@NotNull Field<T10>

Record17.field10()

Get the tenth field.

@NotNull Field<T10>

Record18.field10()

Get the tenth field.

@NotNull Field<T10>

Record19.field10()

Get the tenth field.

@NotNull Field<T10>

Record20.field10()

Get the tenth field.

@NotNull Field<T10>

Record21.field10()

Get the tenth field.

@NotNull Field<T10>

Record22.field10()

Get the tenth field.

@NotNull Field<T10>

Row10.field10()

Get the tenth field.

@NotNull Field<T10>

Row11.field10()

Get the tenth field.

@NotNull Field<T10>

Row12.field10()

Get the tenth field.

@NotNull Field<T10>

Row13.field10()

Get the tenth field.

@NotNull Field<T10>

Row14.field10()

Get the tenth field.

@NotNull Field<T10>

Row15.field10()

Get the tenth field.

@NotNull Field<T10>

Row16.field10()

Get the tenth field.

@NotNull Field<T10>

Row17.field10()

Get the tenth field.

@NotNull Field<T10>

Row18.field10()

Get the tenth field.

@NotNull Field<T10>

Row19.field10()

Get the tenth field.

@NotNull Field<T10>

Row20.field10()

Get the tenth field.

@NotNull Field<T10>

Row21.field10()

Get the tenth field.

@NotNull Field<T10>

Row22.field10()

Get the tenth field.

@NotNull Field<T11>

Record11.field11()

Get the eleventh field.

@NotNull Field<T11>

Record12.field11()

Get the eleventh field.

@NotNull Field<T11>

Record13.field11()

Get the eleventh field.

@NotNull Field<T11>

Record14.field11()

Get the eleventh field.

@NotNull Field<T11>

Record15.field11()

Get the eleventh field.

@NotNull Field<T11>

Record16.field11()

Get the eleventh field.

@NotNull Field<T11>

Record17.field11()

Get the eleventh field.

@NotNull Field<T11>

Record18.field11()

Get the eleventh field.

@NotNull Field<T11>

Record19.field11()

Get the eleventh field.

@NotNull Field<T11>

Record20.field11()

Get the eleventh field.

@NotNull Field<T11>

Record21.field11()

Get the eleventh field.

@NotNull Field<T11>

Record22.field11()

Get the eleventh field.

@NotNull Field<T11>

Row11.field11()

Get the eleventh field.

@NotNull Field<T11>

Row12.field11()

Get the eleventh field.

@NotNull Field<T11>

Row13.field11()

Get the eleventh field.

@NotNull Field<T11>

Row14.field11()

Get the eleventh field.

@NotNull Field<T11>

Row15.field11()

Get the eleventh field.

@NotNull Field<T11>

Row16.field11()

Get the eleventh field.

@NotNull Field<T11>

Row17.field11()

Get the eleventh field.

@NotNull Field<T11>

Row18.field11()

Get the eleventh field.

@NotNull Field<T11>

Row19.field11()

Get the eleventh field.

@NotNull Field<T11>

Row20.field11()

Get the eleventh field.

@NotNull Field<T11>

Row21.field11()

Get the eleventh field.

@NotNull Field<T11>

Row22.field11()

Get the eleventh field.

@NotNull Field<T12>

Record12.field12()

Get the twelfth field.

@NotNull Field<T12>

Record13.field12()

Get the twelfth field.

@NotNull Field<T12>

Record14.field12()

Get the twelfth field.

@NotNull Field<T12>

Record15.field12()

Get the twelfth field.

@NotNull Field<T12>

Record16.field12()

Get the twelfth field.

@NotNull Field<T12>

Record17.field12()

Get the twelfth field.

@NotNull Field<T12>

Record18.field12()

Get the twelfth field.

@NotNull Field<T12>

Record19.field12()

Get the twelfth field.

@NotNull Field<T12>

Record20.field12()

Get the twelfth field.

@NotNull Field<T12>

Record21.field12()

Get the twelfth field.

@NotNull Field<T12>

Record22.field12()

Get the twelfth field.

@NotNull Field<T12>

Row12.field12()

Get the twelfth field.

@NotNull Field<T12>

Row13.field12()

Get the twelfth field.

@NotNull Field<T12>

Row14.field12()

Get the twelfth field.

@NotNull Field<T12>

Row15.field12()

Get the twelfth field.

@NotNull Field<T12>

Row16.field12()

Get the twelfth field.

@NotNull Field<T12>

Row17.field12()

Get the twelfth field.

@NotNull Field<T12>

Row18.field12()

Get the twelfth field.

@NotNull Field<T12>

Row19.field12()

Get the twelfth field.

@NotNull Field<T12>

Row20.field12()

Get the twelfth field.

@NotNull Field<T12>

Row21.field12()

Get the twelfth field.

@NotNull Field<T12>

Row22.field12()

Get the twelfth field.

@NotNull Field<T13>

Record13.field13()

Get the thirteenth field.

@NotNull Field<T13>

Record14.field13()

Get the thirteenth field.

@NotNull Field<T13>

Record15.field13()

Get the thirteenth field.

@NotNull Field<T13>

Record16.field13()

Get the thirteenth field.

@NotNull Field<T13>

Record17.field13()

Get the thirteenth field.

@NotNull Field<T13>

Record18.field13()

Get the thirteenth field.

@NotNull Field<T13>

Record19.field13()

Get the thirteenth field.

@NotNull Field<T13>

Record20.field13()

Get the thirteenth field.

@NotNull Field<T13>

Record21.field13()

Get the thirteenth field.

@NotNull Field<T13>

Record22.field13()

Get the thirteenth field.

@NotNull Field<T13>

Row13.field13()

Get the thirteenth field.

@NotNull Field<T13>

Row14.field13()

Get the thirteenth field.

@NotNull Field<T13>

Row15.field13()

Get the thirteenth field.

@NotNull Field<T13>

Row16.field13()

Get the thirteenth field.

@NotNull Field<T13>

Row17.field13()

Get the thirteenth field.

@NotNull Field<T13>

Row18.field13()

Get the thirteenth field.

@NotNull Field<T13>

Row19.field13()

Get the thirteenth field.

@NotNull Field<T13>

Row20.field13()

Get the thirteenth field.

@NotNull Field<T13>

Row21.field13()

Get the thirteenth field.

@NotNull Field<T13>

Row22.field13()

Get the thirteenth field.

@NotNull Field<T14>

Record14.field14()

Get the fourteenth field.

@NotNull Field<T14>

Record15.field14()

Get the fourteenth field.

@NotNull Field<T14>

Record16.field14()

Get the fourteenth field.

@NotNull Field<T14>

Record17.field14()

Get the fourteenth field.

@NotNull Field<T14>

Record18.field14()

Get the fourteenth field.

@NotNull Field<T14>

Record19.field14()

Get the fourteenth field.

@NotNull Field<T14>

Record20.field14()

Get the fourteenth field.

@NotNull Field<T14>

Record21.field14()

Get the fourteenth field.

@NotNull Field<T14>

Record22.field14()

Get the fourteenth field.

@NotNull Field<T14>

Row14.field14()

Get the fourteenth field.

@NotNull Field<T14>

Row15.field14()

Get the fourteenth field.

@NotNull Field<T14>

Row16.field14()

Get the fourteenth field.

@NotNull Field<T14>

Row17.field14()

Get the fourteenth field.

@NotNull Field<T14>

Row18.field14()

Get the fourteenth field.

@NotNull Field<T14>

Row19.field14()

Get the fourteenth field.

@NotNull Field<T14>

Row20.field14()

Get the fourteenth field.

@NotNull Field<T14>

Row21.field14()

Get the fourteenth field.

@NotNull Field<T14>

Row22.field14()

Get the fourteenth field.

@NotNull Field<T15>

Record15.field15()

Get the fifteenth field.

@NotNull Field<T15>

Record16.field15()

Get the fifteenth field.

@NotNull Field<T15>

Record17.field15()

Get the fifteenth field.

@NotNull Field<T15>

Record18.field15()

Get the fifteenth field.

@NotNull Field<T15>

Record19.field15()

Get the fifteenth field.

@NotNull Field<T15>

Record20.field15()

Get the fifteenth field.

@NotNull Field<T15>

Record21.field15()

Get the fifteenth field.

@NotNull Field<T15>

Record22.field15()

Get the fifteenth field.

@NotNull Field<T15>

Row15.field15()

Get the fifteenth field.

@NotNull Field<T15>

Row16.field15()

Get the fifteenth field.

@NotNull Field<T15>

Row17.field15()

Get the fifteenth field.

@NotNull Field<T15>

Row18.field15()

Get the fifteenth field.

@NotNull Field<T15>

Row19.field15()

Get the fifteenth field.

@NotNull Field<T15>

Row20.field15()

Get the fifteenth field.

@NotNull Field<T15>

Row21.field15()

Get the fifteenth field.

@NotNull Field<T15>

Row22.field15()

Get the fifteenth field.

@NotNull Field<T16>

Record16.field16()

Get the sixteenth field.

@NotNull Field<T16>

Record17.field16()

Get the sixteenth field.

@NotNull Field<T16>

Record18.field16()

Get the sixteenth field.

@NotNull Field<T16>

Record19.field16()

Get the sixteenth field.

@NotNull Field<T16>

Record20.field16()

Get the sixteenth field.

@NotNull Field<T16>

Record21.field16()

Get the sixteenth field.

@NotNull Field<T16>

Record22.field16()

Get the sixteenth field.

@NotNull Field<T16>

Row16.field16()

Get the sixteenth field.

@NotNull Field<T16>

Row17.field16()

Get the sixteenth field.

@NotNull Field<T16>

Row18.field16()

Get the sixteenth field.

@NotNull Field<T16>

Row19.field16()

Get the sixteenth field.

@NotNull Field<T16>

Row20.field16()

Get the sixteenth field.

@NotNull Field<T16>

Row21.field16()

Get the sixteenth field.

@NotNull Field<T16>

Row22.field16()

Get the sixteenth field.

@NotNull Field<T17>

Record17.field17()

Get the seventeenth field.

@NotNull Field<T17>

Record18.field17()

Get the seventeenth field.

@NotNull Field<T17>

Record19.field17()

Get the seventeenth field.

@NotNull Field<T17>

Record20.field17()

Get the seventeenth field.

@NotNull Field<T17>

Record21.field17()

Get the seventeenth field.

@NotNull Field<T17>

Record22.field17()

Get the seventeenth field.

@NotNull Field<T17>

Row17.field17()

Get the seventeenth field.

@NotNull Field<T17>

Row18.field17()

Get the seventeenth field.

@NotNull Field<T17>

Row19.field17()

Get the seventeenth field.

@NotNull Field<T17>

Row20.field17()

Get the seventeenth field.

@NotNull Field<T17>

Row21.field17()

Get the seventeenth field.

@NotNull Field<T17>

Row22.field17()

Get the seventeenth field.

@NotNull Field<T18>

Record18.field18()

Get the eighteenth field.

@NotNull Field<T18>

Record19.field18()

Get the eighteenth field.

@NotNull Field<T18>

Record20.field18()

Get the eighteenth field.

@NotNull Field<T18>

Record21.field18()

Get the eighteenth field.

@NotNull Field<T18>

Record22.field18()

Get the eighteenth field.

@NotNull Field<T18>

Row18.field18()

Get the eighteenth field.

@NotNull Field<T18>

Row19.field18()

Get the eighteenth field.

@NotNull Field<T18>

Row20.field18()

Get the eighteenth field.

@NotNull Field<T18>

Row21.field18()

Get the eighteenth field.

@NotNull Field<T18>

Row22.field18()

Get the eighteenth field.

@NotNull Field<T19>

Record19.field19()

Get the ninteenth field.

@NotNull Field<T19>

Record20.field19()

Get the ninteenth field.

@NotNull Field<T19>

Record21.field19()

Get the ninteenth field.

@NotNull Field<T19>

Record22.field19()

Get the ninteenth field.

@NotNull Field<T19>

Row19.field19()

Get the ninteenth field.

@NotNull Field<T19>

Row20.field19()

Get the ninteenth field.

@NotNull Field<T19>

Row21.field19()

Get the ninteenth field.

@NotNull Field<T19>

Row22.field19()

Get the ninteenth field.

@NotNull Field<T2>

Record10.field2()

Get the second field.

@NotNull Field<T2>

Record11.field2()

Get the second field.

@NotNull Field<T2>

Record12.field2()

Get the second field.

@NotNull Field<T2>

Record13.field2()

Get the second field.

@NotNull Field<T2>

Record14.field2()

Get the second field.

@NotNull Field<T2>

Record15.field2()

Get the second field.

@NotNull Field<T2>

Record16.field2()

Get the second field.

@NotNull Field<T2>

Record17.field2()

Get the second field.

@NotNull Field<T2>

Record18.field2()

Get the second field.

@NotNull Field<T2>

Record19.field2()

Get the second field.

@NotNull Field<T2>

Record2.field2()

Get the second field.

@NotNull Field<T2>

Record20.field2()

Get the second field.

@NotNull Field<T2>

Record21.field2()

Get the second field.

@NotNull Field<T2>

Record22.field2()

Get the second field.

@NotNull Field<T2>

Record3.field2()

Get the second field.

@NotNull Field<T2>

Record4.field2()

Get the second field.

@NotNull Field<T2>

Record5.field2()

Get the second field.

@NotNull Field<T2>

Record6.field2()

Get the second field.

@NotNull Field<T2>

Record7.field2()

Get the second field.

@NotNull Field<T2>

Record8.field2()

Get the second field.

@NotNull Field<T2>

Record9.field2()

Get the second field.

@NotNull Field<T2>

Row10.field2()

Get the second field.

@NotNull Field<T2>

Row11.field2()

Get the second field.

@NotNull Field<T2>

Row12.field2()

Get the second field.

@NotNull Field<T2>

Row13.field2()

Get the second field.

@NotNull Field<T2>

Row14.field2()

Get the second field.

@NotNull Field<T2>

Row15.field2()

Get the second field.

@NotNull Field<T2>

Row16.field2()

Get the second field.

@NotNull Field<T2>

Row17.field2()

Get the second field.

@NotNull Field<T2>

Row18.field2()

Get the second field.

@NotNull Field<T2>

Row19.field2()

Get the second field.

@NotNull Field<T2>

Row2.field2()

Get the second field.

@NotNull Field<T2>

Row20.field2()

Get the second field.

@NotNull Field<T2>

Row21.field2()

Get the second field.

@NotNull Field<T2>

Row22.field2()

Get the second field.

@NotNull Field<T2>

Row3.field2()

Get the second field.

@NotNull Field<T2>

Row4.field2()

Get the second field.

@NotNull Field<T2>

Row5.field2()

Get the second field.

@NotNull Field<T2>

Row6.field2()

Get the second field.

@NotNull Field<T2>

Row7.field2()

Get the second field.

@NotNull Field<T2>

Row8.field2()

Get the second field.

@NotNull Field<T2>

Row9.field2()

Get the second field.

@NotNull Field<T20>

Record20.field20()

Get the twentieth field.

@NotNull Field<T20>

Record21.field20()

Get the twentieth field.

@NotNull Field<T20>

Record22.field20()

Get the twentieth field.

@NotNull Field<T20>

Row20.field20()

Get the twentieth field.

@NotNull Field<T20>

Row21.field20()

Get the twentieth field.

@NotNull Field<T20>

Row22.field20()

Get the twentieth field.

@NotNull Field<T21>

Record21.field21()

Get the twenty-first field.

@NotNull Field<T21>

Record22.field21()

Get the twenty-first field.

@NotNull Field<T21>

Row21.field21()

Get the twenty-first field.

@NotNull Field<T21>

Row22.field21()

Get the twenty-first field.

@NotNull Field<T22>

Record22.field22()

Get the twenty-second field.

@NotNull Field<T22>

Row22.field22()

Get the twenty-second field.

@NotNull Field<T3>

Record10.field3()

Get the third field.

@NotNull Field<T3>

Record11.field3()

Get the third field.

@NotNull Field<T3>

Record12.field3()

Get the third field.

@NotNull Field<T3>

Record13.field3()

Get the third field.

@NotNull Field<T3>

Record14.field3()

Get the third field.

@NotNull Field<T3>

Record15.field3()

Get the third field.

@NotNull Field<T3>

Record16.field3()

Get the third field.

@NotNull Field<T3>

Record17.field3()

Get the third field.

@NotNull Field<T3>

Record18.field3()

Get the third field.

@NotNull Field<T3>

Record19.field3()

Get the third field.

@NotNull Field<T3>

Record20.field3()

Get the third field.

@NotNull Field<T3>

Record21.field3()

Get the third field.

@NotNull Field<T3>

Record22.field3()

Get the third field.

@NotNull Field<T3>

Record3.field3()

Get the third field.

@NotNull Field<T3>

Record4.field3()

Get the third field.

@NotNull Field<T3>

Record5.field3()

Get the third field.

@NotNull Field<T3>

Record6.field3()

Get the third field.

@NotNull Field<T3>

Record7.field3()

Get the third field.

@NotNull Field<T3>

Record8.field3()

Get the third field.

@NotNull Field<T3>

Record9.field3()

Get the third field.

@NotNull Field<T3>

Row10.field3()

Get the third field.

@NotNull Field<T3>

Row11.field3()

Get the third field.

@NotNull Field<T3>

Row12.field3()

Get the third field.

@NotNull Field<T3>

Row13.field3()

Get the third field.

@NotNull Field<T3>

Row14.field3()

Get the third field.

@NotNull Field<T3>

Row15.field3()

Get the third field.

@NotNull Field<T3>

Row16.field3()

Get the third field.

@NotNull Field<T3>

Row17.field3()

Get the third field.

@NotNull Field<T3>

Row18.field3()

Get the third field.

@NotNull Field<T3>

Row19.field3()

Get the third field.

@NotNull Field<T3>

Row20.field3()

Get the third field.

@NotNull Field<T3>

Row21.field3()

Get the third field.

@NotNull Field<T3>

Row22.field3()

Get the third field.

@NotNull Field<T3>

Row3.field3()

Get the third field.

@NotNull Field<T3>

Row4.field3()

Get the third field.

@NotNull Field<T3>

Row5.field3()

Get the third field.

@NotNull Field<T3>

Row6.field3()

Get the third field.

@NotNull Field<T3>

Row7.field3()

Get the third field.

@NotNull Field<T3>

Row8.field3()

Get the third field.

@NotNull Field<T3>

Row9.field3()

Get the third field.

@NotNull Field<T4>

Record10.field4()

Get the fourth field.

@NotNull Field<T4>

Record11.field4()

Get the fourth field.

@NotNull Field<T4>

Record12.field4()

Get the fourth field.

@NotNull Field<T4>

Record13.field4()

Get the fourth field.

@NotNull Field<T4>

Record14.field4()

Get the fourth field.

@NotNull Field<T4>

Record15.field4()

Get the fourth field.

@NotNull Field<T4>

Record16.field4()

Get the fourth field.

@NotNull Field<T4>

Record17.field4()

Get the fourth field.

@NotNull Field<T4>

Record18.field4()

Get the fourth field.

@NotNull Field<T4>

Record19.field4()

Get the fourth field.

@NotNull Field<T4>

Record20.field4()

Get the fourth field.

@NotNull Field<T4>

Record21.field4()

Get the fourth field.

@NotNull Field<T4>

Record22.field4()

Get the fourth field.

@NotNull Field<T4>

Record4.field4()

Get the fourth field.

@NotNull Field<T4>

Record5.field4()

Get the fourth field.

@NotNull Field<T4>

Record6.field4()

Get the fourth field.

@NotNull Field<T4>

Record7.field4()

Get the fourth field.

@NotNull Field<T4>

Record8.field4()

Get the fourth field.

@NotNull Field<T4>

Record9.field4()

Get the fourth field.

@NotNull Field<T4>

Row10.field4()

Get the fourth field.

@NotNull Field<T4>

Row11.field4()

Get the fourth field.

@NotNull Field<T4>

Row12.field4()

Get the fourth field.

@NotNull Field<T4>

Row13.field4()

Get the fourth field.

@NotNull Field<T4>

Row14.field4()

Get the fourth field.

@NotNull Field<T4>

Row15.field4()

Get the fourth field.

@NotNull Field<T4>

Row16.field4()

Get the fourth field.

@NotNull Field<T4>

Row17.field4()

Get the fourth field.

@NotNull Field<T4>

Row18.field4()

Get the fourth field.

@NotNull Field<T4>

Row19.field4()

Get the fourth field.

@NotNull Field<T4>

Row20.field4()

Get the fourth field.

@NotNull Field<T4>

Row21.field4()

Get the fourth field.

@NotNull Field<T4>

Row22.field4()

Get the fourth field.

@NotNull Field<T4>

Row4.field4()

Get the fourth field.

@NotNull Field<T4>

Row5.field4()

Get the fourth field.

@NotNull Field<T4>

Row6.field4()

Get the fourth field.

@NotNull Field<T4>

Row7.field4()

Get the fourth field.

@NotNull Field<T4>

Row8.field4()

Get the fourth field.

@NotNull Field<T4>

Row9.field4()

Get the fourth field.

@NotNull Field<T5>

Record10.field5()

Get the fifth field.

@NotNull Field<T5>

Record11.field5()

Get the fifth field.

@NotNull Field<T5>

Record12.field5()

Get the fifth field.

@NotNull Field<T5>

Record13.field5()

Get the fifth field.

@NotNull Field<T5>

Record14.field5()

Get the fifth field.

@NotNull Field<T5>

Record15.field5()

Get the fifth field.

@NotNull Field<T5>

Record16.field5()

Get the fifth field.

@NotNull Field<T5>

Record17.field5()

Get the fifth field.

@NotNull Field<T5>

Record18.field5()

Get the fifth field.

@NotNull Field<T5>

Record19.field5()

Get the fifth field.

@NotNull Field<T5>

Record20.field5()

Get the fifth field.

@NotNull Field<T5>

Record21.field5()

Get the fifth field.

@NotNull Field<T5>

Record22.field5()

Get the fifth field.

@NotNull Field<T5>

Record5.field5()

Get the fifth field.

@NotNull Field<T5>

Record6.field5()

Get the fifth field.

@NotNull Field<T5>

Record7.field5()

Get the fifth field.

@NotNull Field<T5>

Record8.field5()

Get the fifth field.

@NotNull Field<T5>

Record9.field5()

Get the fifth field.

@NotNull Field<T5>

Row10.field5()

Get the fifth field.

@NotNull Field<T5>

Row11.field5()

Get the fifth field.

@NotNull Field<T5>

Row12.field5()

Get the fifth field.

@NotNull Field<T5>

Row13.field5()

Get the fifth field.

@NotNull Field<T5>

Row14.field5()

Get the fifth field.

@NotNull Field<T5>

Row15.field5()

Get the fifth field.

@NotNull Field<T5>

Row16.field5()

Get the fifth field.

@NotNull Field<T5>

Row17.field5()

Get the fifth field.

@NotNull Field<T5>

Row18.field5()

Get the fifth field.

@NotNull Field<T5>

Row19.field5()

Get the fifth field.

@NotNull Field<T5>

Row20.field5()

Get the fifth field.

@NotNull Field<T5>

Row21.field5()

Get the fifth field.

@NotNull Field<T5>

Row22.field5()

Get the fifth field.

@NotNull Field<T5>

Row5.field5()

Get the fifth field.

@NotNull Field<T5>

Row6.field5()

Get the fifth field.

@NotNull Field<T5>

Row7.field5()

Get the fifth field.

@NotNull Field<T5>

Row8.field5()

Get the fifth field.

@NotNull Field<T5>

Row9.field5()

Get the fifth field.

@NotNull Field<T6>

Record10.field6()

Get the sixth field.

@NotNull Field<T6>

Record11.field6()

Get the sixth field.

@NotNull Field<T6>

Record12.field6()

Get the sixth field.

@NotNull Field<T6>

Record13.field6()

Get the sixth field.

@NotNull Field<T6>

Record14.field6()

Get the sixth field.

@NotNull Field<T6>

Record15.field6()

Get the sixth field.

@NotNull Field<T6>

Record16.field6()

Get the sixth field.

@NotNull Field<T6>

Record17.field6()

Get the sixth field.

@NotNull Field<T6>

Record18.field6()

Get the sixth field.

@NotNull Field<T6>

Record19.field6()

Get the sixth field.

@NotNull Field<T6>

Record20.field6()

Get the sixth field.

@NotNull Field<T6>

Record21.field6()

Get the sixth field.

@NotNull Field<T6>

Record22.field6()

Get the sixth field.

@NotNull Field<T6>

Record6.field6()

Get the sixth field.

@NotNull Field<T6>

Record7.field6()

Get the sixth field.

@NotNull Field<T6>

Record8.field6()

Get the sixth field.

@NotNull Field<T6>

Record9.field6()

Get the sixth field.

@NotNull Field<T6>

Row10.field6()

Get the sixth field.

@NotNull Field<T6>

Row11.field6()

Get the sixth field.

@NotNull Field<T6>

Row12.field6()

Get the sixth field.

@NotNull Field<T6>

Row13.field6()

Get the sixth field.

@NotNull Field<T6>

Row14.field6()

Get the sixth field.

@NotNull Field<T6>

Row15.field6()

Get the sixth field.

@NotNull Field<T6>

Row16.field6()

Get the sixth field.

@NotNull Field<T6>

Row17.field6()

Get the sixth field.

@NotNull Field<T6>

Row18.field6()

Get the sixth field.

@NotNull Field<T6>

Row19.field6()

Get the sixth field.

@NotNull Field<T6>

Row20.field6()

Get the sixth field.

@NotNull Field<T6>

Row21.field6()

Get the sixth field.

@NotNull Field<T6>

Row22.field6()

Get the sixth field.

@NotNull Field<T6>

Row6.field6()

Get the sixth field.

@NotNull Field<T6>

Row7.field6()

Get the sixth field.

@NotNull Field<T6>

Row8.field6()

Get the sixth field.

@NotNull Field<T6>

Row9.field6()

Get the sixth field.

@NotNull Field<T7>

Record10.field7()

Get the seventh field.

@NotNull Field<T7>

Record11.field7()

Get the seventh field.

@NotNull Field<T7>

Record12.field7()

Get the seventh field.

@NotNull Field<T7>

Record13.field7()

Get the seventh field.

@NotNull Field<T7>

Record14.field7()

Get the seventh field.

@NotNull Field<T7>

Record15.field7()

Get the seventh field.

@NotNull Field<T7>

Record16.field7()

Get the seventh field.

@NotNull Field<T7>

Record17.field7()

Get the seventh field.

@NotNull Field<T7>

Record18.field7()

Get the seventh field.

@NotNull Field<T7>

Record19.field7()

Get the seventh field.

@NotNull Field<T7>

Record20.field7()

Get the seventh field.

@NotNull Field<T7>

Record21.field7()

Get the seventh field.

@NotNull Field<T7>

Record22.field7()

Get the seventh field.

@NotNull Field<T7>

Record7.field7()

Get the seventh field.

@NotNull Field<T7>

Record8.field7()

Get the seventh field.

@NotNull Field<T7>

Record9.field7()

Get the seventh field.

@NotNull Field<T7>

Row10.field7()

Get the seventh field.

@NotNull Field<T7>

Row11.field7()

Get the seventh field.

@NotNull Field<T7>

Row12.field7()

Get the seventh field.

@NotNull Field<T7>

Row13.field7()

Get the seventh field.

@NotNull Field<T7>

Row14.field7()

Get the seventh field.

@NotNull Field<T7>

Row15.field7()

Get the seventh field.

@NotNull Field<T7>

Row16.field7()

Get the seventh field.

@NotNull Field<T7>

Row17.field7()

Get the seventh field.

@NotNull Field<T7>

Row18.field7()

Get the seventh field.

@NotNull Field<T7>

Row19.field7()

Get the seventh field.

@NotNull Field<T7>

Row20.field7()

Get the seventh field.

@NotNull Field<T7>

Row21.field7()

Get the seventh field.

@NotNull Field<T7>

Row22.field7()

Get the seventh field.

@NotNull Field<T7>

Row7.field7()

Get the seventh field.

@NotNull Field<T7>

Row8.field7()

Get the seventh field.

@NotNull Field<T7>

Row9.field7()

Get the seventh field.

@NotNull Field<T8>

Record10.field8()

Get the eighth field.

@NotNull Field<T8>

Record11.field8()

Get the eighth field.

@NotNull Field<T8>

Record12.field8()

Get the eighth field.

@NotNull Field<T8>

Record13.field8()

Get the eighth field.

@NotNull Field<T8>

Record14.field8()

Get the eighth field.

@NotNull Field<T8>

Record15.field8()

Get the eighth field.

@NotNull Field<T8>

Record16.field8()

Get the eighth field.

@NotNull Field<T8>

Record17.field8()

Get the eighth field.

@NotNull Field<T8>

Record18.field8()

Get the eighth field.

@NotNull Field<T8>

Record19.field8()

Get the eighth field.

@NotNull Field<T8>

Record20.field8()

Get the eighth field.

@NotNull Field<T8>

Record21.field8()

Get the eighth field.

@NotNull Field<T8>

Record22.field8()

Get the eighth field.

@NotNull Field<T8>

Record8.field8()

Get the eighth field.

@NotNull Field<T8>

Record9.field8()

Get the eighth field.

@NotNull Field<T8>

Row10.field8()

Get the eighth field.

@NotNull Field<T8>

Row11.field8()

Get the eighth field.

@NotNull Field<T8>

Row12.field8()

Get the eighth field.

@NotNull Field<T8>

Row13.field8()

Get the eighth field.

@NotNull Field<T8>

Row14.field8()

Get the eighth field.

@NotNull Field<T8>

Row15.field8()

Get the eighth field.

@NotNull Field<T8>

Row16.field8()

Get the eighth field.

@NotNull Field<T8>

Row17.field8()

Get the eighth field.

@NotNull Field<T8>

Row18.field8()

Get the eighth field.

@NotNull Field<T8>

Row19.field8()

Get the eighth field.

@NotNull Field<T8>

Row20.field8()

Get the eighth field.

@NotNull Field<T8>

Row21.field8()

Get the eighth field.

@NotNull Field<T8>

Row22.field8()

Get the eighth field.

@NotNull Field<T8>

Row8.field8()

Get the eighth field.

@NotNull Field<T8>

Row9.field8()

Get the eighth field.

@NotNull Field<T9>

Record10.field9()

Get the ninth field.

@NotNull Field<T9>

Record11.field9()

Get the ninth field.

@NotNull Field<T9>

Record12.field9()

Get the ninth field.

@NotNull Field<T9>

Record13.field9()

Get the ninth field.

@NotNull Field<T9>

Record14.field9()

Get the ninth field.

@NotNull Field<T9>

Record15.field9()

Get the ninth field.

@NotNull Field<T9>

Record16.field9()

Get the ninth field.

@NotNull Field<T9>

Record17.field9()

Get the ninth field.

@NotNull Field<T9>

Record18.field9()

Get the ninth field.

@NotNull Field<T9>

Record19.field9()

Get the ninth field.

@NotNull Field<T9>

Record20.field9()

Get the ninth field.

@NotNull Field<T9>

Record21.field9()

Get the ninth field.

@NotNull Field<T9>

Record22.field9()

Get the ninth field.

@NotNull Field<T9>

Record9.field9()

Get the ninth field.

@NotNull Field<T9>

Row10.field9()

Get the ninth field.

@NotNull Field<T9>

Row11.field9()

Get the ninth field.

@NotNull Field<T9>

Row12.field9()

Get the ninth field.

@NotNull Field<T9>

Row13.field9()

Get the ninth field.

@NotNull Field<T9>

Row14.field9()

Get the ninth field.

@NotNull Field<T9>

Row15.field9()

Get the ninth field.

@NotNull Field<T9>

Row16.field9()

Get the ninth field.

@NotNull Field<T9>

Row17.field9()

Get the ninth field.

@NotNull Field<T9>

Row18.field9()

Get the ninth field.

@NotNull Field<T9>

Row19.field9()

Get the ninth field.

@NotNull Field<T9>

Row20.field9()

Get the ninth field.

@NotNull Field<T9>

Row21.field9()

Get the ninth field.

@NotNull Field<T9>

Row22.field9()

Get the ninth field.

@NotNull Field<T9>

Row9.field9()

Get the ninth field.

@NotNull Field<?> @NotNull []

Fields.fields()

Get all fields known to this type.

@Nullable Field<?> @NotNull []

Fields.fields(int... indexes)

Get all fields known to this type, filtering by some field indexes.

@Nullable Field<?> @NotNull []

Fields.fields(String... names)

Get all fields known to this type, filtering by some unqualified field names.

@Nullable Field<?> @NotNull []

Fields.fields(Field<?>... fields)

Get all fields, filtering by some fields.

@Nullable Field<?> @NotNull []

Fields.fields(Name... names)

Get all fields known to this type, filtering by some qualified field names.

@NotNull Field<T>

Field.floor()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.floor(Field) instead.

@Nullable Field<T>

DataType.generatedAlwaysAs()

Get the computed column expression of this data type, if any.

@Nullable Field<T>

Sequence.getCache()

Get the number of sequence values to cache for this sequence or null, if no such value is specified.

@Nullable Field<T>

Period.getEnd()

The expression specifying the end of the period.

@Nullable Field<T>

Sequence.getIncrementBy()

Get the increment for this sequence or null, if no such value is specified.

@Nullable Field<T>

Sequence.getMaxvalue()

Get the maximum value for this sequence or null, if no such value is specified.

@Nullable Field<T>

Sequence.getMinvalue()

Get the minimum value for this sequence or null, if no such value is specified.

@Nullable Field<T>

Period.getStart()

The expression specifying the start of the period.

@Nullable Field<T>

Sequence.getStartWith()

Get the start value for this sequence or null, if no such value is specified.

@NotNull Field<T>

Field.greatest(Field<?>... others)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.greatest(Field, Field...) instead.

@NotNull Field<T>

Field.greatest(T... others)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.greatest(Field, Field...) instead.

@NotNull Field<String>

JSONEntry.key()

The JSON entry key.

@NotNull Field<T>

Field.least(Field<?>... others)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.least(Field, Field...) instead.

@NotNull Field<T>

Field.least(T... others)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.least(Field, Field...) instead.

@NotNull Field<Integer>

Field.length()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.length(Field) instead.

@NotNull Field<BigDecimal>

Field.ln()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.ln(Field) instead.

@NotNull Field<BigDecimal>

Field.log(int base)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.log(Field, int) instead.

@NotNull Field<String>

Field.lower()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.lower(Field) instead.

@NotNull Field<String>

Field.lpad(int length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.lpad(Field, int) instead.

@NotNull Field<String>

Field.lpad(int length, char character)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.lpad(Field, int, char) instead.

@NotNull Field<String>

Field.lpad(Field<? extends Number> length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.lpad(Field, Field) instead.

@NotNull Field<String>

Field.lpad(Field<? extends Number> length, Field<String> character)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.lpad(Field, Field, Field) instead.

@NotNull Field<String>

Field.ltrim()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.ltrim(Field) instead.

Field<?>

LoaderFieldMapper.map(LoaderFieldMapper.LoaderFieldContext ctx)

Map a Field from the loader source onto a target table Field.

@NotNull Field<T>

Field.max()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.max(Field) instead.

@NotNull Field<BigDecimal>

Field.median()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.median(Field) instead.

@NotNull Field<T>

Field.min()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.min(Field) instead.

@NotNull Field<T>

Field.minus(Number value)

An alias for sub(Number).

@NotNull Field<T>

Field.minus(Field<?> value)

An alias for sub(Field).

@NotNull Field<T>

Field.mod(Number divisor)

The MOD operator.

@NotNull Field<T>

Field.mod(Field<? extends Number> divisor)

The MOD operator.

@NotNull Field<T>

Field.modulo(Number divisor)

The MODULO operator, an alias for the MOD operator.

@NotNull Field<T>

Field.modulo(Field<? extends Number> divisor)

The MODULO operator, an alias for the MOD operator.

@NotNull Field<T>

Field.mul(Number value)

An arithmetic expression multiplying this with value.

@NotNull Field<T>

Field.mul(Field<? extends Number> value)

An arithmetic expression multiplying this with value.

@NotNull Field<T>

Field.multiply(Number value)

An alias for mul(Number).

@NotNull Field<T>

Field.multiply(Field<? extends Number> value)

An alias for mul(Field).

@NotNull Field<T>

Field.neg()

Negate this field to get its negative value.

@NotNull Field<T>

Sequence.nextval()

An expression to increment the sequence and get the next value.

@NotNull Field<T>

Field.nullif(Field<T> other)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nullif(Field, Field) instead.

@NotNull Field<T>

Field.nullif(T other)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nullif(Field, Object) instead.

@NotNull Field<T>

Field.nvl(Field<T> defaultValue)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nvl(Field, Field) instead.

@NotNull Field<T>

Field.nvl(T defaultValue)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nvl(Field, Object) instead.

<Z> @NotNull Field<Z>

Field.nvl2(Field<Z> valueIfNotNull, Field<Z> valueIfNull)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nvl2(Field, Field, Field) instead.

<Z> @NotNull Field<Z>

Field.nvl2(Z valueIfNotNull, Z valueIfNull)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nvl2(Field, Object, Object) instead.

@NotNull Field<Integer>

Field.octetLength()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.octetLength(Field) instead.

@NotNull Field<T>

CaseConditionStep.otherwise(Field<T> result)

Add an else clause to the already constructed case statement

@NotNull Field<T>

CaseConditionStep.otherwise(Select<? extends Record1<T>> result)

Add an else clause to the already constructed case statement

@NotNull Field<T>

CaseConditionStep.otherwise(T result)

Add an else clause to the already constructed case statement

@NotNull Field<T>

CaseWhenStep.otherwise(Field<T> result)

Add an else clause to the already constructed case statement

@NotNull Field<T>

CaseWhenStep.otherwise(T result)

Add an else clause to the already constructed case statement

@NotNull Field<?>

ParseContext.parseField()

Parse a Field expression or fail if the current expression is not a field.

@Nullable Field<?>

ParseListener.parseField(ParseContext ctx)

Attempt to parse a Field expression.

@NotNull Field<?>

Parser.parseField(String sql)

Parse a SQL string to a field.

@NotNull Field<?>

Parser.parseField(String sql, Object... bindings)

Parse a SQL string with bind variables to a field.

@NotNull Field<XML>

XMLQueryPassingStep.passing(Field<XML> xml)

Add the PASSING clause to the XMLQUERY expression.

@NotNull Field<XML>

XMLQueryPassingStep.passing(XML xml)

Add the PASSING clause to the XMLQUERY expression.

@NotNull Field<XML>

XMLQueryPassingStep.passingByRef(Field<XML> xml)

Add the PASSING BY REF clause to the XMLQUERY expression.

@NotNull Field<XML>

XMLQueryPassingStep.passingByRef(XML xml)

Add the PASSING BY REF clause to the XMLQUERY expression.

@NotNull Field<XML>

XMLQueryPassingStep.passingByValue(Field<XML> xml)

Add the PASSING BY VALUE clause to the XMLQUERY expression.

@NotNull Field<XML>

XMLQueryPassingStep.passingByValue(XML xml)

Add the PASSING BY VALUE clause to the XMLQUERY expression.

@NotNull Field<T>

Field.plus()

The PLUS operator.

@NotNull Field<T>

Field.plus(Number value)

An alias for add(Number).

@NotNull Field<T>

Field.plus(Field<?> value)

An alias for add(Field).

@NotNull Field<Integer>

Field.position(String search)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.position(Field, String) instead.

@NotNull Field<Integer>

Field.position(Field<String> search)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.position(Field, Field) instead.

@NotNull Field<BigDecimal>

Field.pow(Number exponent)

The POW operator, an alias for the POWER operator.

@NotNull Field<BigDecimal>

Field.pow(Field<? extends Number> exponent)

The POW operator, an alias for the POWER operator.

@NotNull Field<BigDecimal>

Field.power(Number exponent)

The POWER operator.

@NotNull Field<BigDecimal>

Field.power(Field<? extends Number> exponent)

The POWER operator.

@NotNull Field<BigDecimal>

Field.rad()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.rad(Field) instead.

@NotNull Field<T>

Field.rem(Number divisor)

The REM operator, an alias for the MOD operator.

@NotNull Field<T>

Field.rem(Field<? extends Number> divisor)

The REM operator, an alias for the MOD operator.

@NotNull Field<String>

Field.repeat(Number count)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.repeat(Field, int) instead.

@NotNull Field<String>

Field.repeat(Field<? extends Number> count)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.repeat(Field, Field) instead.

@NotNull Field<String>

Field.replace(String search)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.replace(Field, String) instead.

@NotNull Field<String>

Field.replace(String search, String replace)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.replace(Field, String, String) instead.

@NotNull Field<String>

Field.replace(Field<String> search)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.replace(Field, Field) instead.

@NotNull Field<String>

Field.replace(Field<String> search, Field<String> replace)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.replace(Field, Field, Field) instead.

@NotNull Field<T>

JSONArrayReturningStep.returning(DataType<?> returning)

Add the RETURNING clause to the JSON ARRAY function.

@NotNull Field<T>

JSONObjectReturningStep.returning(DataType<?> returning)

Add the RETURNING clause to the JSON OBJECT function.

@NotNull Field<T>

JSONValueReturningStep.returning(DataType<?> returning)

Add the RETURNING clause to the JSON VALUE function.

@NotNull Field<T>

Field.round()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.round(Field) instead.

@NotNull Field<T>

Field.round(int decimals)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.round(Field, int) instead.

@NotNull Field<RowId>

Table.rowid()

The ROWID operator.

@NotNull Field<String>

Field.rpad(int length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.rpad(Field, int) instead.

@NotNull Field<String>

Field.rpad(int length, char character)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.rpad(Field, int, char) instead.

@NotNull Field<String>

Field.rpad(Field<? extends Number> length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.rpad(Field, Field) instead.

@NotNull Field<String>

Field.rpad(Field<? extends Number> length, Field<String> character)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.rpad(Field, Field, Field) instead.

@NotNull Field<String>

Field.rtrim()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.rtrim(Field) instead.

@NotNull Field<T>

Field.shl(Number count)

The SHL operator.

@NotNull Field<T>

Field.shl(Field<? extends Number> count)

The SHL operator.

@NotNull Field<T>

Field.shr(Number count)

The SHR operator.

@NotNull Field<T>

Field.shr(Field<? extends Number> count)

The SHR operator.

@NotNull Field<Integer>

Field.sign()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sign(Field) instead.

@NotNull Field<BigDecimal>

Field.sin()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sin(Field) instead.

@NotNull Field<BigDecimal>

Field.sinh()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sinh(Field) instead.

@NotNull Field<BigDecimal>

Field.sqrt()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sqrt(Field) instead.

@NotNull Field<BigDecimal>

Field.stddevPop()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.stddevPop(Field) instead.

@NotNull Field<BigDecimal>

Field.stddevSamp()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.stddevSamp(Field) instead.

@NotNull Field<T>

Field.sub(Number value)

An arithmetic expression subtracting value from this.

@NotNull Field<T>

Field.sub(Field<?> value)

An arithmetic expression subtracting value from this.

@NotNull Field<String>

Field.substring(int startingPosition)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.substring(Field, int) instead.

@NotNull Field<String>

Field.substring(int startingPosition, int length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.substring(Field, int, int) instead.

@NotNull Field<String>

Field.substring(Field<? extends Number> startingPosition)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.substring(Field, Field) instead.

@NotNull Field<String>

Field.substring(Field<? extends Number> startingPosition, Field<? extends Number> length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.substring(Field, Field, Field) instead.

@NotNull Field<T>

Field.subtract(Number value)

An alias for sub(Number).

@NotNull Field<T>

Field.subtract(Field<?> value)

An alias for sub(Field).

@NotNull Field<BigDecimal>

Field.sum()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sum(Field) instead.

@NotNull Field<BigDecimal>

Field.tan()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.tan(Field) instead.

@NotNull Field<BigDecimal>

Field.tanh()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.tanh(Field) instead.

@NotNull Field<T>

Field.times(Number value)

An alias for mul(Number).

@NotNull Field<T>

Field.times(Field<? extends Number> value)

An alias for mul(Field).

@NotNull Field<String>

Field.trim()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.trim(Field) instead.

@NotNull Field<T>

Field.unaryMinus()

Negate this field to get its negative value.

@NotNull Field<T>

Field.unaryPlus()

Get this field as its positive value (no effect on SQL).

@NotNull Field<String>

Field.upper()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.upper(Field) instead.

@NotNull Field<T>

JSONEntry.value()

The JSON entry value.

@NotNull Field<BigDecimal>

Field.varPop()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.varPop(Field) instead.

@NotNull Field<BigDecimal>

Field.varSamp()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.varSamp(Field) instead.

Methods in org.jooq that return types with arguments of type Field

Modifier and Type

Method

Description

@NotNull QOM.UnmodifiableList<? extends Field<?>>

XMLAttributes.$attributes()

Experimental query object model accessor method, see also QOM.

@NotNull QOM.UnmodifiableList<? extends Field<?>>

Asterisk.$except()

Experimental query object model accessor method, see also QOM.

@NotNull QOM.UnmodifiableList<? extends Field<?>>

QualifiedAsterisk.$except()

Experimental query object model accessor method, see also QOM.

@NotNull QOM.UnmodifiableList<? extends Field<?>>

Row.$fields()

Experimental query object model accessor method, see also QOM.

@NotNull QOM.UnmodifiableList<? extends Field<?>>

WindowSpecification.$partitionBy()

Experimental query object model accessor method, see also QOM.

@NotNull Stream<Field<?>>

Fields.fieldStream()

Get all fields known to this type as a Stream.

@NotNull List<Field<?>>

Select.getSelect()

All fields selected in this query

Methods in org.jooq with parameters of type Field

Modifier and Type

Method

Description

@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 Field<T>

Field.add(Field<?> value)

An arithmetic expression to add value to this.

@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.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.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.

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.addSeekAfter(Field<?>... fields)

Adds seeking fields.

void

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

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

@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.

@NotNull AlterTableFinalStep

AlterTableAddStep.after(Field<?> columnName)

Add a AFTER clause to ALTER TABLE … ADD ….

<T> @NotNull AlterTableAlterStep<T>

AlterTableStep.alter(Field<T> 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 Condition

BetweenAndStep.and(Field<T> field)

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

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

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

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

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

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

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

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

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

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

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

BetweenAndStep2.and(Field<T1> maxValue1, Field<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

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

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

BetweenAndStep3.and(Field<T1> maxValue1, Field<T2> maxValue2, Field<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

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

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

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

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

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

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

Create a condition to check this field against some bounds

@NotNull Condition

Condition.and(Field<Boolean> other)

Combine this condition 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 DivideByOnConditionStep

DivideByOnConditionStep.and(Field<Boolean> condition)

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

@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 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 PeriodSpecification

PeriodSpecificationBetweenAndStep.and(Field<T> to)

Add an upper bound to the period specification range.

@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 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 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 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 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 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 TableOnConditionStep<R>

TableOnConditionStep.and(Field<Boolean> 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 Table<R>

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

Add an AND clause to the flashback versions query clause.

@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(Field<Boolean> 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(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(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(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(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(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(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(Field<Boolean> 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 Query

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

Add the ARGS clause to the CALL statement.

@NotNull Field<T>

SelectField.as(Field<?> otherField)

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

@NotNull Table<R>

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

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

@NotNull CreateTypeFinalStep

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

Add the AS ENUM clause to the CREATE TYPE statement.

@NotNull PeriodSpecification

Period.asOf(Field<T> field)

Create a period specification for a given timestamp.

@NotNull Table<R>

Table.asOfScn(Field<? extends Number> scn)

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(Table<?> alias, Field<?>... fieldAliases)

The underlying aliased table representation of this object.

@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 AlterTableFinalStep

AlterTableAddStep.before(Field<?> columnName)

Add a BEFORE clause to ALTER TABLE … ADD ….

@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 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 BetweenAndStep1<T1>

Row1.between(Field<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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 BetweenAndStepN

RowN.between(Field<?>... minValues)

Check if this row value expression is within a range of two other row value expressions.

@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 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 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 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 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 BetweenAndStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

Row13.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, Field<T13> minValue13)

Check if this row value expression is within a symmetric range of two other row value expressions.

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

Row14.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, Field<T13> minValue13, Field<T14> minValue14)

Check if this row value expression is within a symmetric 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.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, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15)

Check if this row value expression is within a symmetric 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.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, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16)

Check if this row value expression is within a symmetric 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.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, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16, Field<T17> minValue17)

Check if this row value expression is within a symmetric 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.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, 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 symmetric 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.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, 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 symmetric range of two other row value expressions.

@NotNull BetweenAndStep2<T1,T2>

Row2.betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2)

Check if this row value expression is within a symmetric 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.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, 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 symmetric 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.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, 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 symmetric 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.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, 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 symmetric range of two other row value expressions.

@NotNull BetweenAndStep3<T1,T2,T3>

Row3.betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep4<T1,T2,T3,T4>

Row4.betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep5<T1,T2,T3,T4,T5>

Row5.betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep6<T1,T2,T3,T4,T5,T6>

Row6.betweenSymmetric(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 symmetric range of two other row value expressions.

@NotNull BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>

Row7.betweenSymmetric(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 symmetric range of two other row value expressions.

@NotNull BetweenAndStep8<T1,T2,T3,T4,T5,T6,T7,T8>

Row8.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)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9>

Row9.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)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStepN

RowN.betweenSymmetric(Field<?>... minValues)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BindContext

Context.bindValue(Object value, Field<?> field)

Bind a value using a specific type.

@NotNull Field<T>

Field.bitAnd(Field<T> arg2)

The BIT_AND operator.

@NotNull Field<T>

Field.bitNand(Field<T> arg2)

The BIT_NAND operator.

@NotNull Field<T>

Field.bitNor(Field<T> arg2)

The BIT_NOR operator.

@NotNull Field<T>

Field.bitOr(Field<T> arg2)

The BIT_OR operator.

@NotNull Field<T>

Field.bitXNor(Field<T> arg2)

The BIT_X_NOR operator.

@NotNull Field<T>

Field.bitXor(Field<T> arg2)

The BIT_XOR operator.

@NotNull LoopStep

ForByStep.by(Field<T> step)

The loop increment.

@NotNull AlterSequenceFlagsStep<T>

AlterSequenceFlagsStep.cache(Field<T> cache)

Add the CACHE clause to the ALTER SEQUENCE statement.

@NotNull CreateSequenceFlagsStep

CreateSequenceFlagsStep.cache(Field<? extends Number> cache)

Add the CACHE clause to the CREATE SEQUENCE statement.

<Z> @NotNull Field<Z>

Field.cast(Field<Z> field)

Cast this field to the type of another field.

boolean

Record.changed(Field<?> field)

Check if a field's value has been changed from its original as fetched from the database.

void

Record.changed(Field<?> field, boolean changed)

Set this record's internal changed flag to the supplied value for a given field.

@NotNull Field<T>

Field.coalesce(Field<T> option, Field<?>... options)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.coalesce(Field, Field...) instead.

<Z> @NotNull Field<Z>

Field.coerce(Field<Z> field)

Coerce this field to the type of another field.

@NotNull ResultQuery<Record>

ResultQuery.coerce(Field<?>... fields)

Coerce the result record type of this query to that of a set of fields.

<T1> @NotNull ResultQuery<Record1<T1>>

ResultQuery.coerce(Field<T1> field1)

Coerce the result record type of this query to that of a set of fields.

<T1, T2> @NotNull ResultQuery<Record2<T1,T2>>

ResultQuery.coerce(Field<T1> field1, Field<T2> field2)

Coerce the result record type of this query to that of a set of fields.

<T1, T2, T3> @NotNull ResultQuery<Record3<T1,T2,T3>>

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3)

Coerce the result record type of this query to that of a set of fields.

<T1, T2, T3, T4> @NotNull ResultQuery<Record4<T1,T2,T3,T4>>

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Coerce the result record type of this query to that of a set of fields.

<T1, T2, T3, T4, T5> @NotNull ResultQuery<Record5<T1,T2,T3,T4,T5>>

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Coerce the result record type of this query to that of a set of fields.

<T1, T2, T3, T4, T5, T6> @NotNull ResultQuery<Record6<T1,T2,T3,T4,T5,T6>>

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Coerce the result record type of this query to that of a set of fields.

<T1, T2, T3, T4, T5, T6, T7> @NotNull ResultQuery<Record7<T1,T2,T3,T4,T5,T6,T7>>

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Coerce the result record type of this query to that of a set of fields.

<T1, T2, T3, T4, T5, T6, T7, T8> @NotNull ResultQuery<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Coerce the result record type of this query to that of a set of fields.

<T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull ResultQuery<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Coerce the result record type of this query to that of a set of fields.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull ResultQuery<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Coerce the result record type of this query to that of a set of fields.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull ResultQuery<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Coerce the result record type of this query to that of a set of fields.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull ResultQuery<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Coerce the result record type of this query to that of a set of fields.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull ResultQuery<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Coerce the result record type of this query to that of a set of fields.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull ResultQuery<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Coerce the result record type of this query to that of a set of fields.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull ResultQuery<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Coerce the result record type of this query to that of a set of fields.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull ResultQuery<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Coerce the result record type of this query to that of a set of fields.

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

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Coerce the result record type of this query to that of a set of fields.

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

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Coerce the result record type of this query to that of a set of fields.

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

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Coerce the result record type of this query to that of a set of fields.

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

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Coerce the result record type of this query to that of a set of fields.

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

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Coerce the result record type of this query to that of a set of fields.

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

ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Coerce the result record type of this query to that of a set of fields.

@NotNull CreateTableColumnStep

CreateTableColumnStep.column(Field<?> field)

Add a column to the column list of the CREATE TABLE statement.

<T> @NotNull CreateTableColumnStep

CreateTableColumnStep.column(Field<T> field, DataType<T> type)

Add a column to the column list of the CREATE TABLE statement.

@NotNull JSONTableColumnPathStep

JSONTableColumnsFirstStep.column(Field<?> name)

Add a column to the COLUMNS clause of the JSON_TABLE expression.

@NotNull JSONTableColumnPathStep

JSONTableColumnsFirstStep.column(Field<?> name, DataType<?> type)

Add a column to the COLUMNS clause of the JSON_TABLE expression.

@NotNull XMLTableColumnPathStep

XMLTableColumnsFirstStep.column(Field<?> name)

Add a column to the COLUMNS clause of the XMLTABLE expression.

@NotNull XMLTableColumnPathStep

XMLTableColumnsFirstStep.column(Field<?> name, DataType<?> type)

Add a column to the COLUMNS clause of the XMLTABLE expression.

@NotNull CreateTableColumnStep

CreateTableColumnStep.columns(Field<?>... fields)

Add several columns to the column list of the CREATE TABLE statement.

@NotNull InsertValuesStepN<R>

InsertSetStep.columns(Field<?>... fields)

Set the columns for insert.

<T1> @NotNull InsertValuesStep1<R,T1>

InsertSetStep.columns(Field<T1> field1)

Set the columns for insert.

<T1, T2> @NotNull InsertValuesStep2<R,T1,T2>

InsertSetStep.columns(Field<T1> field1, Field<T2> field2)

Set the columns for insert.

<T1, T2, T3> @NotNull InsertValuesStep3<R,T1,T2,T3>

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3)

Set the columns for insert.

<T1, T2, T3, T4> @NotNull InsertValuesStep4<R,T1,T2,T3,T4>

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Set the columns for insert.

<T1, T2, T3, T4, T5> @NotNull InsertValuesStep5<R,T1,T2,T3,T4,T5>

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Set the columns for insert.

<T1, T2, T3, T4, T5, T6> @NotNull InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Set the columns for insert.

<T1, T2, T3, T4, T5, T6, T7> @NotNull InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Set the columns for insert.

<T1, T2, T3, T4, T5, T6, T7, T8> @NotNull InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Set the columns for insert.

<T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Set the columns for insert.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Set the columns for insert.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Set the columns for insert.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Set the columns for insert.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Set the columns for insert.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Set the columns for insert.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Set the columns for insert.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Set the columns for insert.

@NotNull MergeKeyStepN<R>

MergeUsingStep.columns(Field<?>... fields)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1> @NotNull MergeKeyStep1<R,T1>

MergeUsingStep.columns(Field<T1> field1)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1, T2> @NotNull MergeKeyStep2<R,T1,T2>

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1, T2, T3> @NotNull MergeKeyStep3<R,T1,T2,T3>

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1, T2, T3, T4> @NotNull MergeKeyStep4<R,T1,T2,T3,T4>

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1, T2, T3, T4, T5> @NotNull MergeKeyStep5<R,T1,T2,T3,T4,T5>

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1, T2, T3, T4, T5, T6> @NotNull MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1, T2, T3, T4, T5, T6, T7> @NotNull MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1, T2, T3, T4, T5, T6, T7, T8> @NotNull MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

@NotNull CommentOnIsStep

DSLContext.commentOnColumn(Field<?> field)

The COMMENT ON COLUMN statement.

@NotNull Condition

Field.compare(Comparator comparator, Field<T> field)

Compare this field with another field using a dynamic comparator.

@NotNull Condition

Row1.compare(Comparator comparator, Field<T1> t1)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row10.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row11.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row12.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row13.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row14.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row15.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row16.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row17.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row18.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row19.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row2.compare(Comparator comparator, Field<T1> t1, Field<T2> t2)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row20.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row21.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20, Field<T21> t21)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row22.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20, Field<T21> t21, Field<T22> t22)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row3.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row4.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row5.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row6.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row7.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row8.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

Row9.compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

RowN.compare(Comparator comparator, Field<?>... values)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Field<String>

Field.concat(Field<?>... fields)

This method is part of the pre-2.0 API.

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithStep.connectBy(Field<Boolean> condition)

Add an Oracle-specific CONNECT BY clause to the query

@NotNull SelectConnectByConditionStep<R>

SelectConnectByStep.connectBy(Field<Boolean> condition)

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

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithStep.connectByNoCycle(Field<Boolean> condition)

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

@NotNull SelectConnectByConditionStep<R>

SelectConnectByStep.connectByNoCycle(Field<Boolean> condition)

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

@NotNull PeriodSpecification

Period.containedIn(Field<T> start, Field<T> end)

Create a period specification for a given timestamp range containing this period.

@NotNull Condition

Field.contains(Field<T> content)

The CONTAINS operator.

@NotNull Condition

Field.containsIgnoreCase(Field<T> content)

The CONTAINS_IGNORE_CASE operator.

@NotNull CreateViewAsStep<Record>

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

Create a new DSL CREATE OR REPLACE VIEW statement.

@NotNull CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

@NotNull CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

<Z> @NotNull Field<Z>

Field.decode(Field<T> search, Field<Z> result)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.decode(Field, Field, Field) instead.

<Z> @NotNull Field<Z>

Field.decode(Field<T> search, Field<Z> result, Field<?>... more)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.decode(Field, Field, Field, Field...) instead.

@NotNull AlterTableFinalStep

AlterTableAlterStep.default_(Field<T> expression)

Specify a new column DEFAULT.

@NotNull CreateDomainConstraintStep

CreateDomainDefaultStep.default_(Field<T> default_)

Add the DEFAULT_ clause to the CREATE DOMAIN statement.

@NotNull DataType<T>

DataType.default_(Field<T> defaultValue)

Specify an expression to be applied as the DEFAULT value for this data type.

@NotNull JSONValueDefaultStep<J>

JSONValueOnStep.default_(Field<?> defaultValue)

Add an NULL ON EMPTY clause.

@NotNull AlterTableFinalStep

AlterTableAlterStep.defaultValue(Field<T> expression)

Specify a new column DEFAULT.

@NotNull DataType<T>

DataType.defaultValue(Field<T> defaultValue)

Specify an expression to be applied as the DEFAULT value for this data type.

@NotNull MergeMatchedStep<R>

MergeMatchedDeleteStep.deleteWhere(Field<Boolean> condition)

Add an additional DELETE WHERE clause to the preceding WHEN MATCHED THEN UPDATE clause.

@NotNull Field<T>

Field.div(Field<? extends Number> value)

An arithmetic expression dividing this by value.

@NotNull Field<T>

Field.divide(Field<? extends Number> value)

An alias for div(Field).

@NotNull AlterTableDropStep

AlterTableStep.drop(Field<?> field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.drop(Field<?>... fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropColumn(Field<?> field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropColumnIfExists(Field<?> field)

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

@NotNull AlterTableDropStep

AlterTableStep.dropColumns(Field<?>... fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropIfExists(Field<?> field)

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

@NotNull Field<T>

CaseConditionStep.else_(Field<T> result)

Add an else clause to the already constructed case statement

@NotNull Field<T>

CaseWhenStep.else_(Field<T> result)

Add an else clause to the already constructed case statement

@NotNull Condition

Field.endsWith(Field<T> suffix)

The ENDS_WITH operator.

@NotNull Condition

Field.endsWithIgnoreCase(Field<T> suffix)

The ENDS_WITH_IGNORE_CASE operator.

@NotNull Condition

Field.eq(Field<T> arg2)

The EQ operator.

@NotNull Condition

Row1.eq(Field<T1> t1)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row10.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row11.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row12.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row13.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row14.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row15.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row16.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row17.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row18.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row19.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row2.eq(Field<T1> t1, Field<T2> t2)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row20.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row21.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20, Field<T21> t21)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row22.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20, Field<T21> t21, Field<T22> t22)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row3.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row4.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row5.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row6.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row7.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row8.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row9.eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

RowN.eq(Field<?>... values)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Field.equal(Field<T> arg2)

The EQUAL operator, an alias for the EQ operator.

@NotNull Condition

Row1.equal(Field<T1> t1)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row10.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row11.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row12.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row13.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row14.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row15.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row16.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row17.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row18.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row19.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row2.equal(Field<T1> t1, Field<T2> t2)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row20.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row21.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20, Field<T21> t21)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row22.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20, Field<T21> t21, Field<T22> t22)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row3.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row4.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row5.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row6.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row7.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row8.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Row9.equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

RowN.equal(Field<?>... values)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

Field.equalIgnoreCase(Field<String> value)

lower(this) = lower(value).

@NotNull Asterisk

Asterisk.except(Field<?>... fields)

The asterisk (*) to be used in SELECT clauses.

@NotNull QualifiedAsterisk

QualifiedAsterisk.except(Field<?>... fields)

The qualified asterisk (t.* EXCEPT (fields)) expression to be used in SELECT clauses.

<Z> @NotNull List

DAO.fetch(Field<Z> field, Collection<? extends Z> values)

Find records by a given field and a set of values.

<Z> @NotNull List

DAO.fetch(Field<Z> field, Z... values)

Find records by a given field and a set of values.

@NotNull Result<Record>

DSLContext.fetch(ResultSet rs, Field<?>... fields)

Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.

 @NotNull List

ResultQuery.fetch(Field<?> field, Class<? extends U> type)

Execute the query and return all values for a field from the generated result.

<T> @NotNull List<T>

ResultQuery.fetch(Field<T> field)

Execute the query and return all values for a field from the generated result.

<T, U> @NotNull List

ResultQuery.fetch(Field<T> field, Converter<? super T,? extends U> converter)

Execute the query and return all values for a field from the generated result.

 U

ResultQuery.fetchAny(Field<?> field, Class<? extends U> type)

Execute the query and return at most one resulting value for a field from the generated result.

<T> T

ResultQuery.fetchAny(Field<T> field)

Execute the query and return at most one resulting value for a field from the generated result.

<T, U> U

ResultQuery.fetchAny(Field<T> field, Converter<? super T,? extends U> converter)

Execute the query and return at most one resulting value for a field from the generated result.

 U @NotNull []

ResultQuery.fetchArray(Field<?> field, Class<? extends U> type)

Execute the query and return all values for a field from the generated result.

<T> T @NotNull []

ResultQuery.fetchArray(Field<T> field)

Execute the query and return all values for a field from the generated result.

<T, U> U @NotNull []

ResultQuery.fetchArray(Field<T> field, Converter<? super T,? extends U> converter)

Execute the query and return all values for a field from the generated result.

@NotNull CompletionStage<Result<Record>>

DSLContext.fetchAsync(ResultSet rs, Field<?>... fields)

Fetch results in a new CompletionStage.

@NotNull CompletionStage<Result<Record>>

DSLContext.fetchAsync(Executor executor, ResultSet rs, Field<?>... fields)

Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.

@NotNull Map<Record,Result<R>>

ResultQuery.fetchGroups(Field<?>[] keys)

Execute the query and return a Map with the result grouped by the given keys.

<E> @NotNull Map<Record,List<E>>

ResultQuery.fetchGroups(Field<?>[] keys, Class<? extends E> type)

Execute the query and return a Map with results grouped by the given keys and mapped into the given entity type.

@NotNull Map<Record,Result<Record>>

ResultQuery.fetchGroups(Field<?>[] keys, Field<?>[] values)

Execute the query and return a Map with the result grouped by the given keys.

<E> @NotNull Map<Record,List<E>>

ResultQuery.fetchGroups(Field<?>[] keys, RecordMapper<? super R,E> mapper)

Execute the query and return a Map with results grouped by the given keys and mapped by the given mapper.

<K> @NotNull Map<K,Result<R>>

ResultQuery.fetchGroups(Field<K> key)

Execute the query and return a Map with one of the result's columns as key and a list of corresponding records as value.

<K, E> @NotNull Map<K,List<E>>

ResultQuery.fetchGroups(Field<K> key, Class<? extends E> type)

Return a Map with results grouped by the given key and mapped into the given entity type.

<K, V> @NotNull Map<K,List<V>>

ResultQuery.fetchGroups(Field<K> key, Field<V> value)

Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value

<K, E> @NotNull Map<K,List<E>>

ResultQuery.fetchGroups(Field<K> key, RecordMapper<? super R,E> mapper)

Return a Map with results grouped by the given key and mapped by the given mapper.

@NotNull Cursor<Record>

DSLContext.fetchLazy(ResultSet rs, Field<?>... fields)

Wrap a JDBC ResultSet into a jOOQ Cursor.

@NotNull Map<Record,R>

ResultQuery.fetchMap(Field<?>[] keys)

Execute the query and return a Map with keys as a map key and the corresponding record as value.

<E> @NotNull Map<List<?>,E>

ResultQuery.fetchMap(Field<?>[] keys, Class<? extends E> type)

Execute the query and return a Map with results grouped by the given keys and mapped into the given entity type.

@NotNull Map<Record,Record>

ResultQuery.fetchMap(Field<?>[] keys, Field<?>[] values)

Execute the query and return a Map with keys as a map key and the corresponding record as value.

<E> @NotNull Map<List<?>,E>

ResultQuery.fetchMap(Field<?>[] keys, RecordMapper<? super R,E> mapper)

Execute the query and return a Map with results grouped by the given keys and mapped by the given mapper.

<K> @NotNull Map<K,R>

ResultQuery.fetchMap(Field<K> key)

Execute the query and return a Map with one of the result's columns as key and the corresponding records as value.

<K, E> @NotNull Map<K,E>

ResultQuery.fetchMap(Field<K> key, Class<? extends E> type)

Execute the query and return a Map with results grouped by the given key and mapped into the given entity type.

<K, V> @NotNull Map<K,V>

ResultQuery.fetchMap(Field<K> key, Field<V> value)

Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value

<K, E> @NotNull Map<K,E>

ResultQuery.fetchMap(Field<K> key, RecordMapper<? super R,E> mapper)

Execute the query and return a Map with results grouped by the given key and mapped by the given mapper.

<Z> P

DAO.fetchOne(Field<Z> field, Z value)

Uses of Interfaceorg.jooq.Field

Uses of Field in org.jooq

Uses of Interface
org.jooq.Field