- java.lang.Object
-
- org.jooq.impl.DSL
-
- Direct Known Subclasses:
AccessDSL
,ASEDSL
,CUBRIDDSL
,DB2DSL
,DerbyDSL
,FirebirdDSL
,H2DSL
,HanaDSL
,HSQLDBDSL
,InformixDSL
,IngresDSL
,MariaDBDSL
,MySQLDSL
,OracleDSL
,PostgresDSL
,RedshiftDSL
,SQLiteDSL
,SQLServerDSL
,SybaseDSL
,VerticaDSL
public class DSL extends Object
A DSL "entry point" providing implementations to theorg.jooq
interfaces.The
DSLContext
and thisDSL
are the main entry point for client code, to access jOOQ classes and functionality. Here, you can instantiate all of those objects that cannot be accessed through other objects. For example, to create aField
representing a constant value, you can write:Field<String> field = DSL.val("Hello World")
Another example is the
EXISTS
clause, which you can apply to anySELECT
to form aCondition
:Condition condition = DSL.exists(DSL.select(...));
DSL and static imports
For increased fluency and readability of your jOOQ client code, it is recommended that you static import all methods from the
DSL
. For example:import static org.jooq.impl.DSL.*; public class Main { public static void main(String[] args) { DSL.select(val("Hello"), inline("World")); // DSL.val ^^^ ^^^^^^ DSL.inline } }
In order to use the "contextual DSL", call one of the various overloaded
using(Configuration)
methods:// Create and immediately execute a SELECT statement: DSL.using(connection, dialect) .selectOne() .fetch();
- Author:
- Lukas Eder
- See Also:
DSLContext
-
-
Constructor Summary
Constructors Modifier Constructor Description protected
DSL()
No instances.
-
Method Summary
All Methods Static Methods Concrete Methods Deprecated Methods Modifier and Type Method Description static <T extends Number>
Field<T>abs(Field<T> field)
Get the absolute value of a numeric field: abs(field).static <T extends Number>
Field<T>abs(T value)
Get the absolute value of a numeric field: abs(field).static Field<BigDecimal>
acos(Number value)
Get the arc cosine(field) function.static Field<BigDecimal>
acos(Field<? extends Number> field)
Get the arc cosine(field) function.static <T> QuantifiedSelect<Record1<T>>
all(Field<T[]> array)
Create anALL
quantified select to be used in quantified comparison predicate expressions.static <T> QuantifiedSelect<Record1<T>>
all(Field<T>... fields)
Create anALL
quantified select to be used in quantified comparison predicate expressions.static <R extends Record>
QuantifiedSelect<R>all(Select<R> select)
Create anALL
quantified select to be used in quantified comparison predicate expressions.static <T> QuantifiedSelect<Record1<T>>
all(T... array)
Create anALL
quantified select to be used in quantified comparison predicate expressions.static AlterIndexOnStep
alterIndex(String index)
Create a new DSLALTER INDEX
statement.static AlterIndexOnStep
alterIndex(Index index)
Create a new DSLALTER INDEX
statement.static AlterIndexOnStep
alterIndex(Name index)
Create a new DSLALTER INDEX
statement.static AlterIndexStep
alterIndexIfExists(String index)
Create a new DSLALTER INDEX
statement.static AlterIndexStep
alterIndexIfExists(Index index)
Create a new DSLALTER INDEX
statement.static AlterIndexStep
alterIndexIfExists(Name index)
Create a new DSLALTER INDEX
statement.static AlterSchemaStep
alterSchema(String schema)
Create a new DSLALTER SCHEMA
statement.static AlterSchemaStep
alterSchema(Name schema)
Create a new DSLALTER SCHEMA
statement.static AlterSchemaStep
alterSchema(Schema schema)
Create a new DSLALTER SCHEMA
statement.static AlterSchemaStep
alterSchemaIfExists(String schema)
Create a new DSLALTER SCHEMA
statement.static AlterSchemaStep
alterSchemaIfExists(Name schema)
Create a new DSLALTER SCHEMA
statement.static AlterSchemaStep
alterSchemaIfExists(Schema schema)
Create a new DSLALTER SCHEMA
statement.static AlterSequenceStep<BigInteger>
alterSequence(String sequence)
Create a new DSLALTER SEQUENCE
statement.static AlterSequenceStep<BigInteger>
alterSequence(Name sequence)
Create a new DSLALTER SEQUENCE
statement.static <T extends Number>
AlterSequenceStep<T>alterSequence(Sequence<T> sequence)
Create a new DSLALTER SEQUENCE
statement.static AlterSequenceStep<BigInteger>
alterSequenceIfExists(String sequence)
Create a new DSLALTER SEQUENCE
statement.static AlterSequenceStep<BigInteger>
alterSequenceIfExists(Name sequence)
Create a new DSLALTER SEQUENCE
statement.static <T extends Number>
AlterSequenceStep<T>alterSequenceIfExists(Sequence<T> sequence)
Create a new DSLALTER SEQUENCE
statement.static AlterTableStep
alterTable(String table)
Create a new DSLALTER TABLE
statement.static AlterTableStep
alterTable(Name table)
Create a new DSLALTER TABLE
statement.static AlterTableStep
alterTable(Table<?> table)
Create a new DSLALTER TABLE
statement.static AlterTableStep
alterTableIfExists(String table)
Create a new DSLALTER TABLE
statement.static AlterTableStep
alterTableIfExists(Name table)
Create a new DSLALTER TABLE
statement.static AlterTableStep
alterTableIfExists(Table<?> table)
Create a new DSLALTER TABLE
statement.static AlterViewStep
alterView(String view)
Create a new DSLALTER VIEW
statement.static AlterViewStep
alterView(Name view)
Create a new DSLALTER VIEW
statement.static AlterViewStep
alterView(Table<?> view)
Create a new DSLALTER VIEW
statement.static AlterViewStep
alterViewIfExists(String view)
Create a new DSLALTER VIEW
statement.static AlterViewStep
alterViewIfExists(Name view)
Create a new DSLALTER VIEW
statement.static AlterViewStep
alterViewIfExists(Table<?> view)
Create a new DSLALTER VIEW
statement.static Condition
and(Collection<? extends Condition> conditions)
static Condition
and(Condition... conditions)
static Condition
and(Condition left, Condition right)
static <T> QuantifiedSelect<Record1<T>>
any(Field<T[]> array)
Create anANY
quantified select to be used in quantified comparison predicate expressions.static <T> QuantifiedSelect<Record1<T>>
any(Field<T>... fields)
Create anANY
quantified select to be used in quantified comparison predicate expressions.static <R extends Record>
QuantifiedSelect<R>any(Select<R> select)
Create anANY
quantified select to be used in quantified comparison predicate expressions.static <T> QuantifiedSelect<Record1<T>>
any(T... array)
Create anANY
quantified select to be used in quantified comparison predicate expressions.static <T> Field<T[]>
array(Collection<? extends Field<T>> fields)
Create an array literal.static <T> Field<T[]>
array(Field<T>... fields)
Create an array literal.static <T> Field<T[]>
array(T... values)
Create an array literal.static <T> ArrayAggOrderByStep<T[]>
arrayAgg(Field<T> field)
Get thearray_agg()
aggregate function.static <T> ArrayAggOrderByStep<T[]>
arrayAggDistinct(Field<T> field)
Get thearray_agg()
aggregate function.static Field<Integer>
ascii(String field)
Get the ascii(field) function.static Field<Integer>
ascii(Field<String> field)
Get the ascii(field) function.static Field<BigDecimal>
asin(Number value)
Get the arc sine(field) function.static Field<BigDecimal>
asin(Field<? extends Number> field)
Get the arc sine(field) function.static Asterisk
asterisk()
The asterisk (*
) to be used inSELECT
clauses.static Field<BigDecimal>
atan(Number value)
Get the arc tangent(field) function.static Field<BigDecimal>
atan(Field<? extends Number> field)
Get the arc tangent(field) function.static Field<BigDecimal>
atan2(Number x, Number y)
Get the atan2(field, y) function.static Field<BigDecimal>
atan2(Number x, Field<? extends Number> y)
Get the atan2(field, y) function.static Field<BigDecimal>
atan2(Field<? extends Number> x, Number y)
Get the atan2(field, y) function.static Field<BigDecimal>
atan2(Field<? extends Number> x, Field<? extends Number> y)
Get the atan2(field, y) function.static AggregateFunction<BigDecimal>
avg(Field<? extends Number> field)
Get the average over a numeric field: avg(field).static AggregateFunction<BigDecimal>
avgDistinct(Field<? extends Number> field)
Get the average over a numeric field: avg(distinct field).static Block
begin(Collection<? extends Statement> statements)
Wrap a collection of statements in an anonymous procedural block.static Block
begin(Statement... statements)
Wrap a collection of statements in an anonymous procedural block.static <T extends Number>
Field<T>bitAnd(Field<T> field1, Field<T> field2)
The bitwise and operator.static <T extends Number>
Field<T>bitAnd(Field<T> value1, T value2)
The bitwise and operator.static <T extends Number>
Field<T>bitAnd(T value1, Field<T> value2)
The bitwise and operator.static <T extends Number>
Field<T>bitAnd(T value1, T value2)
The bitwise and operator.static Field<Integer>
bitCount(Number value)
The MySQLBIT_COUNT(field)
function, counting the number of bits that are set in this number.static Field<Integer>
bitCount(Field<? extends Number> field)
The MySQLBIT_COUNT(field)
function, counting the number of bits that are set in this number.static Field<Integer>
bitLength(String value)
Get the bit_length(field) function.static Field<Integer>
bitLength(Field<String> field)
Get the bit_length(field) function.static <T extends Number>
Field<T>bitNand(Field<T> field1, Field<T> field2)
The bitwise not and operator.static <T extends Number>
Field<T>bitNand(Field<T> value1, T value2)
The bitwise not and operator.static <T extends Number>
Field<T>bitNand(T value1, Field<T> value2)
The bitwise not and operator.static <T extends Number>
Field<T>bitNand(T value1, T value2)
The bitwise not and operator.static <T extends Number>
Field<T>bitNor(Field<T> field1, Field<T> field2)
The bitwise not or operator.static <T extends Number>
Field<T>bitNor(Field<T> value1, T value2)
The bitwise not or operator.static <T extends Number>
Field<T>bitNor(T value1, Field<T> value2)
The bitwise not or operator.static <T extends Number>
Field<T>bitNor(T value1, T value2)
The bitwise not or operator.static <T extends Number>
Field<T>bitNot(Field<T> field)
The bitwise not operator.static <T extends Number>
Field<T>bitNot(T value)
The bitwise not operator.static <T extends Number>
Field<T>bitOr(Field<T> field1, Field<T> field2)
The bitwise or operator.static <T extends Number>
Field<T>bitOr(Field<T> value1, T value2)
The bitwise or operator.static <T extends Number>
Field<T>bitOr(T value1, Field<T> value2)
The bitwise or operator.static <T extends Number>
Field<T>bitOr(T value1, T value2)
The bitwise or operator.static <T extends Number>
Field<T>bitXNor(Field<T> field1, Field<T> field2)
The bitwise not xor operator.static <T extends Number>
Field<T>bitXNor(Field<T> value1, T value2)
The bitwise not xor operator.static <T extends Number>
Field<T>bitXNor(T value1, Field<T> value2)
The bitwise not xor operator.static <T extends Number>
Field<T>bitXNor(T value1, T value2)
The bitwise not xor operator.static <T extends Number>
Field<T>bitXor(Field<T> field1, Field<T> field2)
The bitwise xor operator.static <T extends Number>
Field<T>bitXor(Field<T> value1, T value2)
The bitwise xor operator.static <T extends Number>
Field<T>bitXor(T value1, Field<T> value2)
The bitwise xor operator.static <T extends Number>
Field<T>bitXor(T value1, T value2)
The bitwise xor operator.static AggregateFunction<Boolean>
boolAnd(Condition condition)
Get the every value over a condition: bool_and(condition).static AggregateFunction<Boolean>
boolAnd(Field<Boolean> field)
Get the every value over a field: bool_and(field).static AggregateFunction<Boolean>
boolOr(Condition condition)
Get the every value over a condition: bool_and(condition).static AggregateFunction<Boolean>
boolOr(Field<Boolean> field)
Get the every value over a field: bool_and(field).static Case
case_()
Initialise aCase
statement.static <V> CaseValueStep<V>
case_(Field<V> value)
Initialise aCase
statement.static <V> CaseValueStep<V>
case_(V value)
Initialise aCase
statement.static <T> Field<T>
cast(Object value, Class<T> type)
Cast a value to another type.static <T> Field<T>
cast(Object value, DataType<T> type)
Cast a value to another type.static <T> Field<T>
cast(Object value, Field<T> as)
Cast a value to the type of another field.static <T> Field<T>
cast(Field<?> field, Class<T> type)
Cast a field to another type.static <T> Field<T>
cast(Field<?> field, DataType<T> type)
Cast a field to another type.static <T> Field<T>
cast(Field<?> field, Field<T> as)
Cast a field to the type of another field.static <T> Field<T>
castNull(Class<T> type)
Cast null to a type.static <T> Field<T>
castNull(DataType<T> type)
Cast null to a type.static <T> Field<T>
castNull(Field<T> as)
Cast null to the type of another field.static Catalog
catalog(Name name)
Create a qualified catalog, given its catalog name.static <T extends Number>
Field<T>ceil(Field<T> field)
Get the smallest integer value not less than [field].static <T extends Number>
Field<T>ceil(T value)
Get the smallest integer value not less than [this].static Field<Integer>
century(Temporal value)
Get the century of a date.static Field<Integer>
century(Date value)
Get the century of a date.static Field<Integer>
century(Field<?> field)
Get the century of a date.static CharacterSet
characterSet(String characterSet)
Create a character set by its unqualified name.static CharacterSet
characterSet(Name characterSet)
Create a character set by its qualified name.static Field<Integer>
charLength(String value)
Get the char_length(field) function.static Field<Integer>
charLength(Field<String> field)
Get the char_length(field) function.static ConstraintFinalStep
check(Condition condition)
Create an unnamed (system named)CHECK
constraint.static Case
choose()
Initialise aCase
statement.static <T> Field<T>
choose(int index, Field<T>... values)
The T-SQLCHOOSE()
function.static <T> Field<T>
choose(int index, T... values)
The T-SQLCHOOSE()
function.static <T> Field<T>
choose(Field<Integer> index, Field<T>... values)
The T-SQLCHOOSE()
function.static <T> Field<T>
choose(Field<Integer> index, T... values)
The T-SQLCHOOSE()
function.static <V> CaseValueStep<V>
choose(Field<V> value)
Initialise aCase
statement.static <V> CaseValueStep<V>
choose(V value)
Initialise aCase
statement.static <T> Field<T>
coalesce(Field<T> field, Field<?>... fields)
TheCOALESCE(field1, field2, ...
static <T> Field<T>
coalesce(Field<T> field, T value)
TheCOALESCE(field, value)
function.static <T> Field<T>
coalesce(T value, T... values)
TheCOALESCE(value1, value2, ...
static <T> Field<T>
coerce(Object value, Class<T> as)
Coerce this field to another type.static <T> Field<T>
coerce(Object value, DataType<T> as)
Coerce a field to another type.static <T> Field<T>
coerce(Object value, Field<T> as)
Coerce this field to the type of another field.static <T> Field<T>
coerce(Field<?> field, Class<T> as)
Coerce this field to another type.static <T> Field<T>
coerce(Field<?> field, DataType<T> as)
Coerce a field to another type.static <T> Field<T>
coerce(Field<?> field, Field<T> as)
Coerce this field to the type of another field.static Collation
collation(String collation)
Create a collation by its unqualified name.static Collation
collation(Name collation)
Create a collation by its qualified name.static <T,A extends ArrayRecord<T>>
ArrayAggOrderByStep<A>collect(Field<T> field, Class<A> type)
Get thecollect()
aggregate function.static <T,A extends ArrayRecord<T>>
ArrayAggOrderByStep<A>collect(Field<T> field, DataType<A> type)
Get thecollect()
aggregate function.static <T,A extends ArrayRecord<T>>
ArrayAggOrderByStep<A>collectDistinct(Field<T> field, Class<A> type)
Get thecollect()
aggregate function.static <T,A extends ArrayRecord<T>>
ArrayAggOrderByStep<A>collectDistinct(Field<T> field, DataType<A> type)
Get thecollect()
aggregate function.static Comment
comment(String comment)
Create a comment.static CommentOnIsStep
commentOnColumn(Field<?> field)
Create a new DSLCOMMENT ON COLUMN
statement.static CommentOnIsStep
commentOnColumn(Name columnName)
Create a new DSLCOMMENT ON COLUMN
statement.static CommentOnIsStep
commentOnTable(String tableName)
Create a new DSLCOMMENT ON TABLE
statement.static CommentOnIsStep
commentOnTable(Name tableName)
Create a new DSLCOMMENT ON TABLE
statement.static CommentOnIsStep
commentOnTable(Table<?> table)
Create a new DSLCOMMENT ON TABLE
statement.static CommentOnIsStep
commentOnView(String viewName)
Create a new DSLCOMMENT ON VIEW
statement.static CommentOnIsStep
commentOnView(Name viewName)
Create a new DSLCOMMENT ON VIEW
statement.static CommentOnIsStep
commentOnView(Table<?> view)
Create a new DSLCOMMENT ON VIEW
statement.static Field<String>
concat(String... values)
Get the concat(value[, value, ...]) function.static Field<String>
concat(String value, Field<String> field)
Get theconcat(value, field)
function.static Field<String>
concat(Field<?>... fields)
Get the concat(field[, field, ...]) function.static Field<String>
concat(Field<String> field, String value)
Get theconcat(field, value)
function.static Condition
condition(Boolean value)
Create a condition from a boolean field.static Condition
condition(String sql)
Create a new condition holding plain SQL.static Condition
condition(String sql, Object... bindings)
Create a new condition holding plain SQL.static Condition
condition(String sql, QueryPart... parts)
A custom SQL clause that can render arbitrary SQL elements.static Condition
condition(Map<Field<?>,?> map)
Create a condition from a map.static Condition
condition(Field<Boolean> field)
Create a condition from a boolean field.static Condition
condition(Operator operator, Collection<? extends Condition> conditions)
Return aCondition
that connects all argumentconditions
withOperator
.static Condition
condition(Operator operator, Condition... conditions)
Return aCondition
that connects all argumentconditions
withOperator
.static Condition
condition(Operator operator, Condition left, Condition right)
Return aCondition
that connects all argumentconditions
withOperator
.static Condition
condition(Record record)
static Condition
condition(SQL sql)
Create a new condition holding plain SQL.static Field<Boolean>
connectByIsCycle()
Retrieve the Oracle-specificCONNECT_BY_ISCYCLE
pseudo-field (to be used along withCONNECT BY
clauses).static Field<Boolean>
connectByIsLeaf()
Retrieve the Oracle-specificCONNECT_BY_ISLEAF
pseudo-field (to be used along withCONNECT BY
clauses).static <T> Field<T>
connectByRoot(Field<T> field)
Retrieve the Oracle-specificCONNECT_BY_ROOT
pseudo-column (to be used along withCONNECT BY
clauses).static ConstraintTypeStep
constraint()
Create an unnamed (system named)CONSTRAINT
specification.static ConstraintTypeStep
constraint(String name)
Create aCONSTRAINT
specification.static ConstraintTypeStep
constraint(Name name)
Create aCONSTRAINT
specification.static ContinueWhenStep
continue_()
Create anCONTINUE
statement for use in procedural code.static ContinueWhenStep
continue_(Label label)
Create anCONTINUE
statement for use in procedural code.static Statement
continueWhen(Condition condition)
Create anCONTINUE
statement for use in procedural code.static <T> Field<T>
convert(DataType<T> type, Object value, int style)
Convert a date time value to a string value using the SQL Server styleCONVERT()
function.static <T> Field<T>
convert(DataType<T> type, Field<?> value, int style)
Convert a date time value to a string value using the SQL Server styleCONVERT()
function.static Field<BigDecimal>
cos(Number value)
Get the cosine(field) function.static Field<BigDecimal>
cos(Field<? extends Number> field)
Get the cosine(field) function.static Field<BigDecimal>
cosh(Number value)
Get the hyperbolic cosine function: cosh(field).static Field<BigDecimal>
cosh(Field<? extends Number> field)
Get the hyperbolic cosine function: cosh(field).static Field<BigDecimal>
cot(Number value)
Get the cotangent(field) function.static Field<BigDecimal>
cot(Field<? extends Number> field)
Get the cotangent(field) function.static Field<BigDecimal>
coth(Number value)
Get the hyperbolic cotangent function: coth(field).static Field<BigDecimal>
coth(Field<? extends Number> field)
Get the hyperbolic cotangent function: coth(field).static AggregateFunction<Integer>
count()
Get the count(*) function.static AggregateFunction<Integer>
count(Field<?> field)
Get the count(field) function.static AggregateFunction<Integer>
count(SelectFieldOrAsterisk field)
Get the count(field) function.static AggregateFunction<Integer>
count(Table<?> table)
Get the count(table) function.static AggregateFunction<Integer>
countDistinct(Field<?> field)
Get the count(distinct field) function.static AggregateFunction<Integer>
countDistinct(Field<?>... fields)
Get the count(distinct field1, field2) function.static AggregateFunction<Integer>
countDistinct(SelectFieldOrAsterisk field)
Get the count(distinct field) function.static AggregateFunction<Integer>
countDistinct(Table<?> table)
Get the count(distinct table) function.static CreateTableColumnStep
createGlobalTemporaryTable(String table)
Create a new DSLCREATE GLOBAL TEMPORARY TABLE
statement.static CreateTableColumnStep
createGlobalTemporaryTable(Name table)
Create a new DSLCREATE GLOBAL TEMPORARY TABLE
statement.static CreateTableColumnStep
createGlobalTemporaryTable(Table<?> table)
Create a new DSLCREATE GLOBAL TEMPORARY TABLE
statement.static CreateIndexStep
createIndex()
Create a new DSLCREATE INDEX
statement.static CreateIndexStep
createIndex(String index)
Create a new DSLCREATE INDEX
statement.static CreateIndexStep
createIndex(Index index)
Create a new DSLCREATE INDEX
statement.static CreateIndexStep
createIndex(Name index)
Create a new DSLCREATE INDEX
statement.static CreateIndexStep
createIndexIfNotExists(String index)
Create a new DSLCREATE INDEX IF NOT EXISTS
statement.static CreateIndexStep
createIndexIfNotExists(Index index)
Create a new DSLCREATE INDEX IF NOT EXISTS
statement.static CreateIndexStep
createIndexIfNotExists(Name index)
Create a new DSLCREATE INDEX IF NOT EXISTS
statement.static CreateViewAsStep
createOrReplaceView(String view, String... fields)
Create a new DSLCREATE OR REPLACE VIEW
statement.static CreateViewAsStep
createOrReplaceView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.static CreateViewAsStep
createOrReplaceView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.static CreateViewAsStep
createOrReplaceView(Name view, Name... fields)
Create a new DSLCREATE OR REPLACE VIEW
statement.static CreateViewAsStep
createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.static CreateViewAsStep
createOrReplaceView(Table<?> view, Field<?>... fields)
Create a new DSLCREATE OR REPLACE VIEW
statement.static CreateSchemaFinalStep
createSchema(String schema)
Create a new DSLCREATE SCHEMA
statement.static CreateSchemaFinalStep
createSchema(Name schema)
Create a new DSLCREATE SCHEMA
statement.static CreateSchemaFinalStep
createSchema(Schema schema)
Create a new DSLCREATE SCHEMA
statement.static CreateSchemaFinalStep
createSchemaIfNotExists(String schema)
Create a new DSLCREATE SCHEMA
statement.static CreateSchemaFinalStep
createSchemaIfNotExists(Name table)
Create a new DSLCREATE SCHEMA
statement.static CreateSchemaFinalStep
createSchemaIfNotExists(Schema schema)
Create a new DSLCREATE SCHEMA
statement.static CreateSequenceFlagsStep
createSequence(String sequence)
Create a new DSLCREATE SEQUENCE
statement.static CreateSequenceFlagsStep
createSequence(Name sequence)
Create a new DSLCREATE SEQUENCE
statement.static CreateSequenceFlagsStep
createSequence(Sequence<?> sequence)
Create a new DSLCREATE SEQUENCE
statement.static CreateSequenceFlagsStep
createSequenceIfNotExists(String sequence)
Create a new DSLCREATE SEQUENCE IF NOT EXISTS
statement.static CreateSequenceFlagsStep
createSequenceIfNotExists(Name sequence)
Create a new DSLCREATE SEQUENCE IF NOT EXISTS
statement.static CreateSequenceFlagsStep
createSequenceIfNotExists(Sequence<?> sequence)
Create a new DSLCREATE SEQUENCE IF NOT EXISTS
statement.static CreateTableColumnStep
createTable(String table)
Create a new DSLCREATE TABLE
statement.static CreateTableColumnStep
createTable(Name table)
Create a new DSLCREATE TABLE
statement.static CreateTableColumnStep
createTable(Table<?> table)
Create a new DSLCREATE TABLE
statement.static CreateTableColumnStep
createTableIfNotExists(String table)
Create a new DSLCREATE TABLE
statement.static CreateTableColumnStep
createTableIfNotExists(Name table)
Create a new DSLCREATE TABLE
statement.static CreateTableColumnStep
createTableIfNotExists(Table<?> table)
Create a new DSLCREATE TABLE
statement.static CreateTableColumnStep
createTemporaryTable(String table)
Create a new DSLCREATE GLOBAL TEMPORARY TABLE
statement.static CreateTableColumnStep
createTemporaryTable(Name table)
Create a new DSLCREATE GLOBAL TEMPORARY TABLE
statement.static CreateTableColumnStep
createTemporaryTable(Table<?> table)
Create a new DSLCREATE GLOBAL TEMPORARY TABLE
statement.static CreateTypeStep
createType(String type)
Create a new DSLCREATE TYPE
statement.static CreateTypeStep
createType(Name type)
Create a new DSLCREATE TYPE
statement.static CreateIndexStep
createUniqueIndex()
Create a new DSLCREATE UNIQUE INDEX
statement.static CreateIndexStep
createUniqueIndex(String index)
Create a new DSLCREATE UNIQUE INDEX
statement.static CreateIndexStep
createUniqueIndex(Index index)
Create a new DSLCREATE UNIQUE INDEX
statement.static CreateIndexStep
createUniqueIndex(Name index)
Create a new DSLCREATE UNIQUE INDEX
statement.static CreateIndexStep
createUniqueIndexIfNotExists(String index)
Create a new DSLCREATE UNIQUE INDEX IF NOT EXISTS
statement.static CreateIndexStep
createUniqueIndexIfNotExists(Index index)
Create a new DSLCREATE UNIQUE INDEX IF NOT EXISTS
statement.static CreateIndexStep
createUniqueIndexIfNotExists(Name index)
Create a new DSLCREATE UNIQUE INDEX IF NOT EXISTS
statement.static CreateViewAsStep
createView(String view, String... fields)
Create a new DSLCREATE VIEW
statement.static CreateViewAsStep
createView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.static CreateViewAsStep
createView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.static CreateViewAsStep
createView(Name view, Name... fields)
Create a new DSLCREATE VIEW
statement.static CreateViewAsStep
createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.static CreateViewAsStep
createView(Table<?> view, Field<?>... fields)
Create a new DSLCREATE VIEW
statement.static CreateViewAsStep
createViewIfNotExists(String view, String... fields)
Create a new DSLCREATE VIEW IF NOT EXISTS
statement.static CreateViewAsStep
createViewIfNotExists(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSLCREATE VIEW IF NOT EXISTS
statement.static CreateViewAsStep
createViewIfNotExists(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSLCREATE VIEW IF NOT EXISTS
statement.static CreateViewAsStep
createViewIfNotExists(Name view, Name... fields)
Create a new DSLCREATE VIEW IF NOT EXISTS
statement.static CreateViewAsStep
createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW IF NOT EXISTS
statement.static CreateViewAsStep
createViewIfNotExists(Table<?> view, Field<?>... fields)
Create a new DSLCREATE VIEW IF NOT EXISTS
statement.static GroupField
cube(Field<?>... fields)
Create a CUBE(field1, field2, .., fieldn) grouping field.static GroupField
cube(FieldOrRow... fields)
Create a CUBE(field1, field2, .., fieldn) grouping field.static WindowOverStep<BigDecimal>
cumeDist()
Thecume_dist() over ([analytic clause])
function.static OrderedAggregateFunction<BigDecimal>
cumeDist(Collection<? extends Field<?>> fields)
Thecume_dist(expr) within group (order by [order clause])
ordered-set aggregate function.static OrderedAggregateFunction<BigDecimal>
cumeDist(Field<?>... fields)
Thecume_dist(expr) within group (order by [order clause])
ordered-set aggregate function.static Field<Date>
currentDate()
Get the current_date() function returning a SQL standardSQLDataType.DATE
type.static Field<Instant>
currentInstant()
Get the current_timestamp() function.static Field<LocalDate>
currentLocalDate()
Get the current_date() function returning a SQL standardSQLDataType.DATE
type.static Field<LocalDateTime>
currentLocalDateTime()
Get the current_timestamp() function returning a SQL standardSQLDataType.TIMESTAMP
type.static Field<LocalTime>
currentLocalTime()
Get the current_time() function returning a SQL standardSQLDataType.TIME
type.static Field<OffsetDateTime>
currentOffsetDateTime()
Get the current_timestamp() function.static Field<OffsetTime>
currentOffsetTime()
Get the current_time() function.static Field<String>
currentSchema()
Get thecurrent_schema()
function.static Field<Time>
currentTime()
Get the current_time() function returning a SQL standardSQLDataType.TIME
type.static Field<Timestamp>
currentTimestamp()
Get the current_timestamp() function returning a SQL standardSQLDataType.TIMESTAMP
type.static Field<Timestamp>
currentTimestamp(Field<Integer> precision)
Get the current_timestamp() function returning a SQL standardSQLDataType.TIMESTAMP
type with the specified fractional seconds precision.static Field<String>
currentUser()
Get thecurrent_user()
function.static Field<Date>
date(String value)
Convert a string value to aDATE
.static Field<Date>
date(Date value)
Convert a temporal value to aDATE
.static Field<Date>
date(Field<? extends Date> field)
Convert a temporal value to aDATE
.static Field<Date>
dateAdd(Date date, Number interval)
Add an interval to a date.static Field<Date>
dateAdd(Date date, Number interval, DatePart datePart)
Add an interval to a date, given a date part.static Field<Date>
dateAdd(Date date, Field<? extends Number> interval, DatePart datePart)
Add an interval to a date, given a date part.static Field<Date>
dateAdd(Field<Date> date, Number interval, DatePart datePart)
Add an interval to a date, given a date part.static Field<Date>
dateAdd(Field<Date> date, Field<? extends Number> interval)
Add an interval to a date.static Field<Date>
dateAdd(Field<Date> date, Field<? extends Number> interval, DatePart datePart)
Add an interval to a date, given a date part.static Field<Integer>
dateDiff(Date date1, Date date2)
Get the date difference in number of days.static Field<Integer>
dateDiff(Date date1, Field<Date> date2)
Get the date difference in number of days.static Field<Integer>
dateDiff(Field<Date> date1, Date date2)
Get the date difference in number of days.static Field<Integer>
dateDiff(Field<Date> date1, Field<Date> date2)
Get the date difference in number of days.static Field<Date>
dateSub(Date date, Number interval)
Subtract an interval from a date.static Field<Date>
dateSub(Date date, Number interval, DatePart datePart)
Subtract an interval from a date, given a date part.static Field<Date>
dateSub(Date date, Field<? extends Number> interval, DatePart datePart)
Subtract an interval from a date, given a date part.static Field<Date>
dateSub(Field<Date> date, Number interval, DatePart datePart)
Subtract an interval from a date, given a date part.static Field<Date>
dateSub(Field<Date> date, Field<? extends Number> interval)
Subtract an interval from a date.static Field<Date>
dateSub(Field<Date> date, Field<? extends Number> interval, DatePart datePart)
Subtract an interval from a date, given a date part.static Field<Integer>
day(Temporal value)
Get the day part of a date.static Field<Integer>
day(Date value)
Get the day part of a date.static Field<Integer>
day(Field<?> field)
Get the day part of a date.static Field<Integer>
dayOfWeek(Temporal value)
Get the day of week part of a date.static Field<Integer>
dayOfWeek(Date value)
Get the day of week part of a date.static Field<Integer>
dayOfWeek(Field<?> field)
Get the day of week part of a date.static Field<Integer>
dayOfYear(Temporal value)
Get the day of week part of a date.static Field<Integer>
dayOfYear(Date value)
Get the day of week part of a date.static Field<Integer>
dayOfYear(Field<?> field)
Get the day of week part of a date.static Field<Integer>
decade(Temporal value)
Get the decade of a date.static Field<Integer>
decade(Date value)
Get the decade of a date.static Field<Integer>
decade(Field<?> field)
Get the decade of a date.static <T> Declaration<T>
declare(Variable<T> variable)
Create a local variable declaration for use in procedural code.static Case
decode()
Initialise aCase
statement.static <Z,T>
Field<Z>decode(Field<T> value, Field<T> search, Field<Z> result)
Gets the Oracle-styleDECODE(expression, search, result[, search , result]...
static <Z,T>
Field<Z>decode(Field<T> value, Field<T> search, Field<Z> result, Field<?>... more)
Gets the Oracle-styleDECODE(expression, search, result[, search , result]...
static <Z,T>
Field<Z>decode(T value, T search, Z result)
Gets the Oracle-styleDECODE(expression, search, result[, search , result]...
static <Z,T>
Field<Z>decode(T value, T search, Z result, Object... more)
Gets the Oracle-styleDECODE(expression, search, result[, search , result]...
static Field<Object>
default_()
Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.static <T> Field<T>
default_(Class<T> type)
Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.static <T> Field<T>
default_(DataType<T> type)
Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.static <T> Field<T>
default_(Field<T> field)
Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.static Field<Object>
defaultValue()
Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.static <T> Field<T>
defaultValue(Class<T> type)
Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.static <T> Field<T>
defaultValue(DataType<T> type)
Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.static <T> Field<T>
defaultValue(Field<T> field)
Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.static Field<BigDecimal>
deg(Number value)
Calculate degrees from radians from this field.static Field<BigDecimal>
deg(Field<? extends Number> field)
Calculate degrees from radians from this field.static <R extends Record>
DeleteWhereStep<R>delete(Table<R> table)
Create a new DSL delete statement.static <R extends Record>
DeleteWhereStep<R>deleteFrom(Table<R> table)
Create a new DSL delete statement.static WindowOverStep<Integer>
denseRank()
Thedense_rank() over ([analytic clause])
function.static OrderedAggregateFunction<Integer>
denseRank(Collection<? extends Field<?>> fields)
Thedense_rank(expr) within group (order by [order clause])
ordered-set aggregate function.static OrderedAggregateFunction<Integer>
denseRank(Field<?>... fields)
Thedense_rank(expr) within group (order by [order clause])
ordered-set aggregate function.static DropIndexOnStep
dropIndex(String index)
Create a new DSLDROP INDEX
statement.static DropIndexOnStep
dropIndex(Index index)
Create a new DSLDROP INDEX
statement.static DropIndexOnStep
dropIndex(Name index)
Create a new DSLDROP INDEX
statement.static DropIndexOnStep
dropIndexIfExists(String index)
Create a new DSLDROP INDEX IF EXISTS
statement.static DropIndexOnStep
dropIndexIfExists(Index index)
Create a new DSLDROP INDEX IF EXISTS
statement.static DropIndexOnStep
dropIndexIfExists(Name index)
Create a new DSLDROP INDEX IF EXISTS
statement.static DropSchemaStep
dropSchema(String schema)
Create a new DSLDROP SCHEMA
statement.static DropSchemaStep
dropSchema(Name schema)
Create a new DSLDROP SCHEMA
statement.static DropSchemaStep
dropSchema(Schema schema)
Create a new DSLDROP SCHEMA
statement.static DropSchemaStep
dropSchemaIfExists(String schema)
Create a new DSLDROP SCHEMA
statement.static DropSchemaStep
dropSchemaIfExists(Name schema)
Create a new DSLDROP SCHEMA
statement.static DropSchemaStep
dropSchemaIfExists(Schema schema)
Create a new DSLDROP SCHEMA
statement.static <T extends Number>
DropSequenceFinalStepdropSequence(String sequence)
Create a new DSLDROP SEQUENCE
statement.static <T extends Number>
DropSequenceFinalStepdropSequence(Name sequence)
Create a new DSLDROP SEQUENCE
statement.static <T extends Number>
DropSequenceFinalStepdropSequence(Sequence<?> sequence)
Create a new DSLDROP SEQUENCE
statement.static <T extends Number>
DropSequenceFinalStepdropSequenceIfExists(String sequence)
Create a new DSLDROP SEQUENCE IF EXISTS
statement.static <T extends Number>
DropSequenceFinalStepdropSequenceIfExists(Name sequence)
Create a new DSLDROP SEQUENCE IF EXISTS
statement.static <T extends Number>
DropSequenceFinalStepdropSequenceIfExists(Sequence<?> sequence)
Create a new DSLDROP SEQUENCE IF EXISTS
statement.static DropTableStep
dropTable(String table)
Create a new DSLDROP TABLE
statement.static DropTableStep
dropTable(Name table)
Create a new DSLDROP TABLE
statement.static DropTableStep
dropTable(Table<?> table)
Create a new DSLDROP TABLE
statement.static DropTableStep
dropTableIfExists(String table)
Create a new DSLDROP TABLE IF EXISTS
statement.static DropTableStep
dropTableIfExists(Name table)
Create a new DSLDROP TABLE IF EXISTS
statement.static DropTableStep
dropTableIfExists(Table<?> table)
Create a new DSLDROP TABLE IF EXISTS
statement.static DropTableStep
dropTemporaryTable(String table)
Create a new DSLDROP TEMPORARY TABLE
statement.static DropTableStep
dropTemporaryTable(Name table)
Create a new DSLDROP TEMPORARY TABLE
statement.static DropTableStep
dropTemporaryTable(Table<?> table)
Create a new DSLDROP TEMPORARY TABLE
statement.static DropTypeStep
dropType(String type)
Create a new DSLDROP TYPE
statement.static DropTypeStep
dropType(String... type)
Create a new DSLDROP TYPE
statement.static DropTypeStep
dropType(Collection<?> type)
Create a new DSLDROP TYPE
statement.static DropTypeStep
dropType(Name type)
Create a new DSLDROP TYPE
statement.static DropTypeStep
dropType(Name... type)
Create a new DSLDROP TYPE
statement.static DropTypeStep
dropTypeIfExists(String type)
Create a new DSLDROP TYPE
statement.static DropTypeStep
dropTypeIfExists(String... type)
Create a new DSLDROP TYPE
statement.static DropTypeStep
dropTypeIfExists(Collection<?> type)
Create a new DSLDROP TYPE
statement.static DropTypeStep
dropTypeIfExists(Name type)
Create a new DSLDROP TYPE
statement.static DropTypeStep
dropTypeIfExists(Name... type)
Create a new DSLDROP TYPE
statement.static DropViewFinalStep
dropView(String view)
Create a new DSLDROP VIEW
statement.static DropViewFinalStep
dropView(Name view)
Create a new DSLDROP VIEW
statement.static DropViewFinalStep
dropView(Table<?> view)
Create a new DSLDROP VIEW
statement.static DropViewFinalStep
dropViewIfExists(String view)
Create a new DSLDROP VIEW IF EXISTS
statement.static DropViewFinalStep
dropViewIfExists(Name view)
Create a new DSLDROP VIEW IF EXISTS
statement.static DropViewFinalStep
dropViewIfExists(Table<?> view)
Create a new DSLDROP VIEW IF EXISTS
statement.static Table<Record>
dual()
TheDUAL
table to be used for syntactic completeness.static Field<BigDecimal>
e()
TheE
literal (Euler number).static Field<Integer>
epoch(Temporal value)
Get the epoch of a date.static Field<Integer>
epoch(Date value)
Get the epoch of a date.static Field<Integer>
epoch(Field<?> field)
Get the epoch of a date.static String
escape(String value, char escape)
Convenience method forreplace(Field, String, String)
to escape data for use withField.like(Field, char)
.static Field<String>
escape(Field<String> field, char escape)
Convenience method forreplace(Field, String, String)
to escape data for use withField.like(Field, char)
.static AggregateFunction<Boolean>
every(Condition condition)
Get the every value over a condition: every(condition).static AggregateFunction<Boolean>
every(Field<Boolean> field)
Get the every value over a field: every(field).static Statement
execute(String sql)
Execute a statement dynamically from within procedural code.static Statement
execute(Field<String> sql)
Execute a statement dynamically from within procedural code.static Condition
exists(Select<?> query)
Create an exists condition.static ExitWhenStep
exit()
Create anEXIT
statement for use in procedural code.static ExitWhenStep
exit(Label label)
Create anEXIT
statement for use in procedural code.static Statement
exitWhen(Condition condition)
Create anEXIT
statement for use in procedural code.static Field<BigDecimal>
exp(Number value)
Get the exp(field) function, taking this field as the power of e.static Field<BigDecimal>
exp(Field<? extends Number> field)
Get the exp(field) function, taking this field as the power of e.static Field<Integer>
extract(Temporal value, DatePart datePart)
Get the extract(field, datePart) function.static Field<Integer>
extract(Date value, DatePart datePart)
Get the extract(field, datePart) function.static Field<Integer>
extract(Field<?> field, DatePart datePart)
Get the extract(field, datePart) function.static False
falseCondition()
Return aCondition
that will always evaluate to false.static Field<Object>
field(String sql)
Create a "plain SQL" field.static <T> Field<T>
field(String sql, Class<T> type)
Create a "plain SQL" field.static <T> Field<T>
field(String sql, Class<T> type, Object... bindings)
Create a "plain SQL" field.static <T> Field<T>
field(String sql, Class<T> type, QueryPart... parts)
A custom SQL clause that can render arbitrary SQL elements.static Field<Object>
field(String sql, Object... bindings)
Create a "plain SQL" field.static <T> Field<T>
field(String sql, DataType<T> type)
Create a "plain SQL" field.static <T> Field<T>
field(String sql, DataType<T> type, Object... bindings)
Create a "plain SQL" field.static <T> Field<T>
field(String sql, DataType<T> type, QueryPart... parts)
Create a "plain SQL" field.static Field<Object>
field(String sql, QueryPart... parts)
A custom SQL clause that can render arbitrary SQL elements.static Field<Boolean>
field(Condition condition)
Transform a condition into a boolean field.static Field<Object>
field(Name name)
Create a qualified field, given its (qualified) field name.static <T> Field<T>
field(Name name, Class<T> type)
Create a qualified field, given its (qualified) field name.static <T> Field<T>
field(Name name, DataType<T> type)
Create a qualified field, given its (qualified) field name.static <T> Field<T>
field(Name name, DataType<T> type, Comment comment)
Create a qualified field, given its (qualified) field name.static <T> Field<T>
field(Select<? extends Record1<T>> select)
Transform a subquery into a correlated subquery.static <T> Field<T>
field(SelectField<T> field)
Wrap aSelectField
in a general-purposeField
static Field<Object>
field(SQL sql)
Create a "plain SQL" field.static <T> Field<T>
field(SQL sql, Class<T> type)
Create a "plain SQL" field.static <T> Field<T>
field(SQL sql, DataType<T> type)
Create a "plain SQL" field.static <T> Field<T>
fieldByName(Class<T> type, String... qualifiedName)
Deprecated.- [#3843] - 3.6.0 - usefield(Name, Class)
insteadstatic Field<Object>
fieldByName(String... qualifiedName)
Deprecated.- [#3843] - 3.6.0 - usefield(Name)
insteadstatic <T> Field<T>
fieldByName(DataType<T> type, String... qualifiedName)
Deprecated.- [#3843] - 3.6.0 - usefield(Name, DataType)
insteadstatic <T> WindowIgnoreNullsStep<T>
firstValue(Field<T> field)
Thefirst_value(field) over ([analytic clause])
function.static <T extends Number>
Field<T>floor(Field<T> field)
Get the largest integer value not greater than [this].static <T extends Number>
Field<T>floor(T value)
Get the largest integer value not greater than [this].static <T> ForInStep<T>
for_(Variable<T> index)
Create aFOR
loop for use in procedural code.static ConstraintForeignKeyReferencesStep1<?>
foreignKey(String field1)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStepN
foreignKey(String... fields)
Add aFOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep2<?,?>
foreignKey(String field1, String field2)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep3<?,?,?>
foreignKey(String field1, String field2, String field3)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep4<?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep5<?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep6<?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep7<?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep8<?,?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7, String field8)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep9<?,?,?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7, String field8, String field9)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep10<?,?,?,?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7, String field8, String field9, String field10)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep11<?,?,?,?,?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7, String field8, String field9, String field10, String field11)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep12<?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7, String field8, String field9, String field10, String field11, String field12)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep13<?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7, String field8, String field9, String field10, String field11, String field12, String field13)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep14<?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7, String field8, String field9, String field10, String field11, String field12, String field13, String field14)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7, String field8, String field9, String field10, String field11, String field12, String field13, String field14, String field15)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7, String field8, String field9, String field10, String field11, String field12, String field13, String field14, String field15, String field16)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7, String field8, String field9, String field10, String field11, String field12, String field13, String field14, String field15, String field16, String field17)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7, String field8, String field9, String field10, String field11, String field12, String field13, String field14, String field15, String field16, String field17, String field18)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7, String field8, String field9, String field10, String field11, String field12, String field13, String field14, String field15, String field16, String field17, String field18, String field19)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7, String field8, String field9, String field10, String field11, String field12, String field13, String field14, String field15, String field16, String field17, String field18, String field19, String field20)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7, String field8, String field9, String field10, String field11, String field12, String field13, String field14, String field15, String field16, String field17, String field18, String field19, String field20, String field21)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(String field1, String field2, String field3, String field4, String field5, String field6, String field7, String field8, String field9, String field10, String field11, String field12, String field13, String field14, String field15, String field16, String field17, String field18, String field19, String field20, String field21, String field22)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStepN
foreignKey(Field<?>... fields)
Add aFOREIGN KEY
clause to theCONSTRAINT
.static <T1> ConstraintForeignKeyReferencesStep1<T1>
foreignKey(Field<T1> field1)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2>
ConstraintForeignKeyReferencesStep2<T1,T2>foreignKey(Field<T1> field1, Field<T2> field2)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3>
ConstraintForeignKeyReferencesStep3<T1,T2,T3>foreignKey(Field<T1> field1, Field<T2> field2, Field<T3> field3)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4>
ConstraintForeignKeyReferencesStep4<T1,T2,T3,T4>foreignKey(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5>
ConstraintForeignKeyReferencesStep5<T1,T2,T3,T4,T5>foreignKey(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6>
ConstraintForeignKeyReferencesStep6<T1,T2,T3,T4,T5,T6>foreignKey(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7>
ConstraintForeignKeyReferencesStep7<T1,T2,T3,T4,T5,T6,T7>foreignKey(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7,T8>
ConstraintForeignKeyReferencesStep8<T1,T2,T3,T4,T5,T6,T7,T8>foreignKey(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9>
ConstraintForeignKeyReferencesStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9>foreignKey(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)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
ConstraintForeignKeyReferencesStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>foreignKey(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)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
ConstraintForeignKeyReferencesStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>foreignKey(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)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
ConstraintForeignKeyReferencesStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>foreignKey(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)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
ConstraintForeignKeyReferencesStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>foreignKey(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)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
ConstraintForeignKeyReferencesStep14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>foreignKey(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)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
ConstraintForeignKeyReferencesStep15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>foreignKey(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)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
ConstraintForeignKeyReferencesStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>foreignKey(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)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
ConstraintForeignKeyReferencesStep17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>foreignKey(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)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
ConstraintForeignKeyReferencesStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>foreignKey(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)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
ConstraintForeignKeyReferencesStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>foreignKey(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)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
ConstraintForeignKeyReferencesStep20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>foreignKey(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)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
ConstraintForeignKeyReferencesStep21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>foreignKey(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)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
ConstraintForeignKeyReferencesStep22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>foreignKey(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)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep1<?>
foreignKey(Name field1)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStepN
foreignKey(Name... fields)
Add aFOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep2<?,?>
foreignKey(Name field1, Name field2)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep3<?,?,?>
foreignKey(Name field1, Name field2, Name field3)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep4<?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep5<?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep6<?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep7<?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep8<?,?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep9<?,?,?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep10<?,?,?,?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep11<?,?,?,?,?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep12<?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep13<?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep14<?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19, Name field20)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19, Name field20, Name field21)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static ConstraintForeignKeyReferencesStep22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>
foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19, Name field20, Name field21, Name field22)
Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T> Field<T>
function(String name, Class<T> type, Field<?>... arguments)
function()
can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.static <T> Field<T>
function(String name, DataType<T> type, Field<?>... arguments)
function()
can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.static <T> Field<T>
function(Name name, Class<T> type, Field<?>... arguments)
function()
can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.static <T> Field<T>
function(Name name, DataType<T> type, Field<?>... arguments)
function()
can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.static Table<Record1<Integer>>
generateSeries(int from, int to)
A table function generating a series of values fromfrom
toto
(inclusive).static Table<Record1<Integer>>
generateSeries(int from, int to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static Table<Record1<Integer>>
generateSeries(int from, int to, Field<Integer> step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static Table<Record1<Integer>>
generateSeries(int from, Field<Integer> to)
A table function generating a series of values fromfrom
toto
(inclusive).static Table<Record1<Integer>>
generateSeries(int from, Field<Integer> to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static Table<Record1<Integer>>
generateSeries(int from, Field<Integer> to, Field<Integer> step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static Table<Record1<Integer>>
generateSeries(Field<Integer> from, int to)
A table function generating a series of values fromfrom
toto
(inclusive).static Table<Record1<Integer>>
generateSeries(Field<Integer> from, int to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static Table<Record1<Integer>>
generateSeries(Field<Integer> from, int to, Field<Integer> step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static Table<Record1<Integer>>
generateSeries(Field<Integer> from, Field<Integer> to)
A table function generating a series of values fromfrom
toto
(inclusive).static Table<Record1<Integer>>
generateSeries(Field<Integer> from, Field<Integer> to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static Table<Record1<Integer>>
generateSeries(Field<Integer> from, Field<Integer> to, Field<Integer> step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static <T> DataType<T>
getDataType(Class<T> type)
Deprecated.- 3.11.0 - [#7483] - The (indirect) use of the internal static data type registry is not recommended.static Statement
goto_(Label label)
Create anGOTO
statement for use in procedural code.static GrantOnStep
grant(Collection<? extends Privilege> privileges)
Grant privileges on table to user or role.static GrantOnStep
grant(Privilege privilege)
Grant a privilege on table to user or role.static GrantOnStep
grant(Privilege... privileges)
Grant privileges on table to user or role.static <T> Field<T>
greatest(Field<T> field, Field<?>... others)
Find the greatest among all values.static <T> Field<T>
greatest(T value, T... values)
Find the greatest among all values.static GroupConcatOrderByStep
groupConcat(Field<?> field)
Get the aggregated concatenation for a field.static AggregateFunction<String>
groupConcat(Field<?> field, String separator)
Deprecated.- [#7956] - 3.12.0 - UsegroupConcat(Field)
andGroupConcatSeparatorStep.separator(String)
instead.static GroupConcatOrderByStep
groupConcatDistinct(Field<?> field)
Get the aggregated concatenation for a field.static Field<Integer>
groupId()
Create aGROUP_ID()
aggregation function to be used along withCUBE
,ROLLUP
, andGROUPING SETS
groupings.static Field<Integer>
grouping(Field<?> field)
Create a GROUPING(field) aggregation field to be used along withCUBE
,ROLLUP
, andGROUPING SETS
groupings.static Field<Integer>
groupingId(Field<?>... fields)
Create a GROUPING_ID(field1, field2, .., fieldn) aggregation field to be used along withCUBE
,ROLLUP
, andGROUPING SETS
groupings.static GroupField
groupingSets(Collection<? extends Field<?>>... fieldSets)
Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna, fieldnb)) grouping field.static GroupField
groupingSets(Field<?>... fields)
Create a GROUPING SETS(field1, field2, .., fieldn) grouping field where each grouping set only consists of a single field.static GroupField
groupingSets(Field<?>[]... fieldSets)
Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna, fieldnb)) grouping field.static WindowSpecificationRowsAndStep
groupsBetweenCurrentRow()
Create aWindowSpecification
with aGROUPS
clause.static WindowSpecificationRowsAndStep
groupsBetweenFollowing(int number)
Create aWindowSpecification
with aGROUPS
clause.static WindowSpecificationRowsAndStep
groupsBetweenPreceding(int number)
Create aWindowSpecification
with aGROUPS
clause.static WindowSpecificationRowsAndStep
groupsBetweenUnboundedFollowing()
Create aWindowSpecification
with aGROUPS
clause.static WindowSpecificationRowsAndStep
groupsBetweenUnboundedPreceding()
Create aWindowSpecification
with aGROUPS
clause.static WindowSpecificationExcludeStep
groupsCurrentRow()
Create aWindowSpecification
with aGROUPS
clause.static WindowSpecificationExcludeStep
groupsFollowing(int number)
Create aWindowSpecification
with aGROUPS
clause.static WindowSpecificationExcludeStep
groupsPreceding(int number)
Create aWindowSpecification
with aGROUPS
clause.static WindowSpecificationExcludeStep
groupsUnboundedFollowing()
Create aWindowSpecification
with aGROUPS
clause.static WindowSpecificationExcludeStep
groupsUnboundedPreceding()
Create aWindowSpecification
with aGROUPS
clause.static Field<Integer>
hour(Temporal value)
Get the hour part of a date.static Field<Integer>
hour(Date value)
Get the hour part of a date.static Field<Integer>
hour(Field<?> field)
Get the hour part of a date.static IfThenStep
if_(Condition condition)
Create anIF
statement for use in procedural code.static <T> Field<T>
ifnull(Field<T> value, Field<T> defaultValue)
TheIFNULL()
function, a synonym ofNVL()
.static <T> Field<T>
ifnull(Field<T> value, T defaultValue)
TheIFNULL()
function, a synonym ofNVL()
.static <T> Field<T>
ifnull(T value, Field<T> defaultValue)
TheIFNULL()
function, a synonym ofNVL()
.static <T> Field<T>
ifnull(T value, T defaultValue)
TheIFNULL()
function, a synonym ofNVL()
.static <T> Field<T>
iif(Condition condition, Field<T> ifTrue, Field<T> ifFalse)
Gets the SQL Server style IIF(condition, ifTrue, ifFalse) function.static <T> Field<T>
iif(Condition condition, Field<T> ifTrue, T ifFalse)
Gets the SQL Server style IIF(condition, ifTrue, ifFalse) function.static <T> Field<T>
iif(Condition condition, T ifTrue, Field<T> ifFalse)
Gets the SQL Server style IIF(condition, ifTrue, ifFalse) function.static <T> Field<T>
iif(Condition condition, T ifTrue, T ifFalse)
Gets the SQL Server style IIF(condition, ifTrue, ifFalse) function.static Index
index(Name name)
Create a qualified index reference by name.static Param<Boolean>
inline(boolean value)
Create a bind value that is always inlined.static Param<Byte>
inline(byte value)
Create a bind value that is always inlined.static Param<byte[]>
inline(byte[] value)
Create a bind value that is always inlined.static Param<String>
inline(char character)
Create a bind value, that is always inlined.static Param<Double>
inline(double value)
Create a bind value that is always inlined.static Param<Float>
inline(float value)
Create a bind value that is always inlined.static Param<Integer>
inline(int value)
Create a bind value that is always inlined.static Param<Long>
inline(long value)
Create a bind value that is always inlined.static Param<Short>
inline(short value)
Create a bind value that is always inlined.static Param<Boolean>
inline(Boolean value)
Create a bind value that is always inlined.static Param<Byte>
inline(Byte value)
Create a bind value that is always inlined.static Param<String>
inline(Character character)
Create a bind value, that is always inlined.static Param<String>
inline(CharSequence character)
Create a bind value, that is always inlined.static Param<Double>
inline(Double value)
Create a bind value that is always inlined.static Param<Float>
inline(Float value)
Create a bind value that is always inlined.static Param<Integer>
inline(Integer value)
Create a bind value that is always inlined.static Param<Long>
inline(Long value)
Create a bind value that is always inlined.static <T> Param<T>
inline(Object value, Class<T> type)
Create a bind value, that is always inlined.static <T> Param<T>
inline(Object value, DataType<T> type)
Create a bind value, that is always inlined.static <T> Param<T>
inline(Object value, Field<T> field)
Create a bind value, that is always inlined.static Param<Short>
inline(Short value)
Create a bind value that is always inlined.static Param<String>
inline(String value)
Create a bind value that is always inlined.static Param<BigDecimal>
inline(BigDecimal value)
Create a bind value that is always inlined.static Param<BigInteger>
inline(BigInteger value)
Create a bind value that is always inlined.static Param<Date>
inline(Date value)
Create a bind value that is always inlined.static Param<Time>
inline(Time value)
Create a bind value that is always inlined.static Param<Timestamp>
inline(Timestamp value)
Create a bind value that is always inlined.static Param<Instant>
inline(Instant value)
Create a bind value that is always inlined.static Param<LocalDate>
inline(LocalDate value)
Create a bind value that is always inlined.static Param<LocalDateTime>
inline(LocalDateTime value)
Create a bind value that is always inlined.static Param<LocalTime>
inline(LocalTime value)
Create a bind value that is always inlined.static Param<OffsetDateTime>
inline(OffsetDateTime value)
Create a bind value that is always inlined.static Param<OffsetTime>
inline(OffsetTime value)
Create a bind value that is always inlined.static Param<UUID>
inline(UUID value)
Create a bind value that is always inlined.static Param<UByte>
inline(UByte value)
Create a bind value that is always inlined.static Param<UInteger>
inline(UInteger value)
Create a bind value that is always inlined.static Param<ULong>
inline(ULong value)
Create a bind value that is always inlined.static Param<UShort>
inline(UShort value)
Create a bind value that is always inlined.static <T> Param<T>
inline(T value)
Create a bind value, that is always inlined.static <R extends Record>
InsertSetStep<R>insertInto(Table<R> into)
Create a new DSL insert statement.static <R extends Record>
InsertValuesStepN<R>insertInto(Table<R> into, Collection<? extends Field<?>> fields)
Create a new DSL insert statement.static <R extends Record>
InsertValuesStepN<R>insertInto(Table<R> into, Field<?>... fields)
Create a new DSL insert statement.static <R extends Record,T1>
InsertValuesStep1<R,T1>insertInto(Table<R> into, Field<T1> field1)
Create a new DSL insert statement.static <R extends Record,T1,T2>
InsertValuesStep2<R,T1,T2>insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3>
InsertValuesStep3<R,T1,T2,T3>insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4>
InsertValuesStep4<R,T1,T2,T3,T4>insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5>
InsertValuesStep5<R,T1,T2,T3,T4,T5>insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6>
InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7>
InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>insertInto(Table<R> into, 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)
Create a new DSL insert statement.static Field<Instant>
instant(String value)
Convert a string value to aTIMESTAMP WITH TIME ZONE
.static Field<Instant>
instant(Instant value)
Convert a temporal value to aTIMESTAMP WITH TIME ZONE
.static Field<Instant>
instant(Field<Instant> field)
Convert a temporal value to aTIMESTAMP WITH TIME ZONE
.static <T> Field<T>
isnull(Field<T> value, Field<T> defaultValue)
Gets the SQL Server-style ISNULL(value, defaultValue) function.static <T> Field<T>
isnull(Field<T> value, T defaultValue)
Gets the SQL Server-style ISNULL(value, defaultValue) function.static <T> Field<T>
isnull(T value, Field<T> defaultValue)
Gets the SQL Server-style ISNULL(value, defaultValue) function.static <T> Field<T>
isnull(T value, T defaultValue)
Gets the SQL Server-style ISNULL(value, defaultValue) function.static Field<Integer>
isoDayOfWeek(Temporal value)
Get the ISO day of week part of a date.static Field<Integer>
isoDayOfWeek(Date value)
Get the ISO day of week part of a date.static Field<Integer>
isoDayOfWeek(Field<?> field)
Get the ISO day of week part of a date.static Field<JSON>
jsonArray(Collection<? extends Field<?>> fields)
The JSON array constructor.static Field<JSON>
jsonArray(Field<?>... fields)
The JSON array constructor.static Field<JSONB>
jsonbArray(Collection<? extends Field<?>> fields)
The JSONB array constructor.static Field<JSONB>
jsonbArray(Field<?>... fields)
The JSONB array constructor.static Field<JSONB>
jsonbObject(Collection<? extends JSONEntry<?>> entries)
The JSONB object constructor.static Field<JSONB>
jsonbObject(JSONEntry<?>... entries)
The JSONB object constructor.static <T> JSONEntry<T>
jsonEntry(Field<String> key, Field<T> value)
A constructor for JSON entries to be used withjsonObject(JSONEntry...)
.static Field<JSON>
jsonObject(Collection<? extends JSONEntry<?>> entries)
The JSON object constructor.static Field<JSON>
jsonObject(Field<String> key, Field<?> value)
The JSON object constructor.static Field<JSON>
jsonObject(JSONEntry<?>... entries)
The JSON object constructor.static Keyword
keyword(String keyword)
Create a SQL keyword.static Label
label(String label)
Create a label reference for use in procedural code.static Label
label(Name label)
Create a label reference for use in procedural code.static <T> WindowIgnoreNullsStep<T>
lag(Field<T> field)
Thelag(field) over ([analytic clause])
function.static <T> WindowIgnoreNullsStep<T>
lag(Field<T> field, int offset)
Thelag(field, offset) over ([analytic clause])
function.static <T> WindowIgnoreNullsStep<T>
lag(Field<T> field, int offset, Field<T> defaultValue)
Thelag(field, offset, defaultValue) over ([analytic clause])
function.static <T> WindowIgnoreNullsStep<T>
lag(Field<T> field, int offset, T defaultValue)
Thelag(field, offset, defaultValue) over ([analytic clause])
function.static <T> WindowIgnoreNullsStep<T>
lastValue(Field<T> field)
Thelast_value(field) over ([analytic clause])
function.static <R extends Record>
Table<R>lateral(TableLike<R> table)
Create aLATERAL
joined table.static <T> WindowIgnoreNullsStep<T>
lead(Field<T> field)
Thelead(field) over ([analytic clause])
function.static <T> WindowIgnoreNullsStep<T>
lead(Field<T> field, int offset)
Thelead(field, offset) over ([analytic clause])
function.static <T> WindowIgnoreNullsStep<T>
lead(Field<T> field, int offset, Field<T> defaultValue)
Thelead(field, offset, defaultValue) over ([analytic clause])
function.static <T> WindowIgnoreNullsStep<T>
lead(Field<T> field, int offset, T defaultValue)
Thelead(field, offset, defaultValue) over ([analytic clause])
function.static <T> Field<T>
least(Field<T> field, Field<?>... others)
Find the least among all values.static <T> Field<T>
least(T value, T... values)
Find the least among all values.static Field<String>
left(String field, int length)
Get the left outermost characters from a string.static Field<String>
left(String field, Field<? extends Number> length)
Get the left outermost characters from a string.static Field<String>
left(Field<String> field, int length)
Get the left outermost characters from a string.static Field<String>
left(Field<String> field, Field<? extends Number> length)
Get the left outermost characters from a string.static Field<Integer>
length(String value)
Get the length of aVARCHAR
type.static Field<Integer>
length(Field<String> field)
Get the length of aVARCHAR
type.static Field<Integer>
level()
Retrieve the Oracle-specificLEVEL
pseudo-field (to be used along withCONNECT BY
clauses).static Link
link(String name)
Create a database link reference.static Link
link(String name, Schema schema)
Create a database link reference.static Link
link(Name name)
Create a database link reference.static QueryPart
list(Collection<? extends QueryPart> parts)
Compose a list ofQueryParts
into a newQueryPart
, with individual parts being comma-separated.static QueryPart
list(QueryPart... parts)
Compose a list ofQueryParts
into a newQueryPart
, with individual parts being comma-separated.static OrderedAggregateFunction<String>
listAgg(Field<?> field)
Get the aggregated concatenation for a field.static OrderedAggregateFunction<String>
listAgg(Field<?> field, String separator)
Get the aggregated concatenation for a field.static Field<BigDecimal>
ln(Number value)
Get the ln(field) function, taking the natural logarithm of this field.static Field<BigDecimal>
ln(Field<? extends Number> field)
Get the ln(field) function, taking the natural logarithm of this field.static Field<LocalDate>
localDate(String value)
Convert a string value to aDATE
.static Field<LocalDate>
localDate(LocalDate value)
Convert a temporal value to aDATE
.static Field<LocalDate>
localDate(Field<LocalDate> field)
Convert a temporal value to aDATE
.static Field<LocalDate>
localDateAdd(LocalDate date, Number interval)
Add an interval to a date.static Field<LocalDate>
localDateAdd(LocalDate date, Number interval, DatePart datePart)
Add an interval to a date, given a date part.static Field<LocalDate>
localDateAdd(LocalDate date, Field<? extends Number> interval, DatePart datePart)
Add an interval to a date, given a date part.static Field<LocalDate>
localDateAdd(Field<LocalDate> date, Number interval, DatePart datePart)
Add an interval to a date, given a date part.static Field<LocalDate>
localDateAdd(Field<LocalDate> date, Field<? extends Number> interval)
Add an interval to a date.static Field<LocalDate>
localDateAdd(Field<LocalDate> date, Field<? extends Number> interval, DatePart datePart)
Add an interval to a date, given a date part.static Field<Integer>
localDateDiff(LocalDate date1, LocalDate date2)
Get the date difference in number of days.static Field<Integer>
localDateDiff(LocalDate date1, Field<LocalDate> date2)
Get the date difference in number of days.static Field<Integer>
localDateDiff(Field<LocalDate> date1, LocalDate date2)
Get the date difference in number of days.static Field<Integer>
localDateDiff(Field<LocalDate> date1, Field<LocalDate> date2)
Get the date difference in number of days.static Field<LocalDate>
localDateSub(LocalDate date, Number interval)
Subtract an interval from a date.static Field<LocalDate>
localDateSub(LocalDate date, Number interval, DatePart datePart)
Subtract an interval from a date, given a date part.static Field<LocalDate>
localDateSub(LocalDate date, Field<? extends Number> interval, DatePart datePart)
Subtract an interval from a date, given a date part.static Field<LocalDate>
localDateSub(Field<LocalDate> date, Number interval, DatePart datePart)
Subtract an interval from a date, given a date part.static Field<LocalDate>
localDateSub(Field<LocalDate> date, Field<? extends Number> interval)
Subtract an interval from a date.static Field<LocalDate>
localDateSub(Field<LocalDate> date, Field<? extends Number> interval, DatePart datePart)
Subtract an interval from a date, given a date part.static Field<LocalDateTime>
localDateTime(String value)
Convert a string value to aTIMESTAMP
.static Field<LocalDateTime>
localDateTime(LocalDateTime value)
Convert a temporal value to aTIMESTAMP
.static Field<LocalDateTime>
localDateTime(Field<LocalDateTime> field)
Convert a temporal value to aTIMESTAMP
.static Field<LocalDateTime>
localDateTimeAdd(LocalDateTime timestamp, Number interval)
Add an interval to a timestamp.static Field<LocalDateTime>
localDateTimeAdd(LocalDateTime date, Number interval, DatePart datePart)
Add an interval to a timestamp, given a date part.static Field<LocalDateTime>
localDateTimeAdd(LocalDateTime date, Field<? extends Number> interval, DatePart datePart)
Add an interval to a timestamp, given a date part.static Field<LocalDateTime>
localDateTimeAdd(Field<LocalDateTime> date, Number interval, DatePart datePart)
Add an interval to a timestamp, given a date part.static Field<LocalDateTime>
localDateTimeAdd(Field<LocalDateTime> timestamp, Field<? extends Number> interval)
Add an interval to a timestamp.static Field<LocalDateTime>
localDateTimeAdd(Field<LocalDateTime> date, Field<? extends Number> interval, DatePart datePart)
Add an interval to a timestamp, given a date part.static Field<DayToSecond>
localDateTimeDiff(LocalDateTime timestamp1, LocalDateTime timestamp2)
Get the timestamp difference as aINTERVAL DAY TO SECOND
type.static Field<DayToSecond>
localDateTimeDiff(LocalDateTime timestamp1, Field<LocalDateTime> timestamp2)
Get the timestamp difference as aINTERVAL DAY TO SECOND
type.static Field<DayToSecond>
localDateTimeDiff(Field<LocalDateTime> timestamp1, LocalDateTime timestamp2)
Get the timestamp difference as aINTERVAL DAY TO SECOND
type.static Field<DayToSecond>
localDateTimeDiff(Field<LocalDateTime> timestamp1, Field<LocalDateTime> timestamp2)
Get the timestamp difference as aINTERVAL DAY TO SECOND
type.static Field<LocalDateTime>
localDateTimeSub(LocalDateTime timestamp, Number interval)
Subtract an interval from a timestamp.static Field<LocalDateTime>
localDateTimeSub(LocalDateTime date, Number interval, DatePart datePart)
Subtract an interval from a timestamp, given a date part.static Field<LocalDateTime>
localDateTimeSub(LocalDateTime date, Field<? extends Number> interval, DatePart datePart)
Subtract an interval from a timestamp, given a date part.static Field<LocalDateTime>
localDateTimeSub(Field<LocalDateTime> date, Number interval, DatePart datePart)
Subtract an interval from a timestamp, given a date part.static Field<LocalDateTime>
localDateTimeSub(Field<LocalDateTime> timestamp, Field<? extends Number> interval)
Subtract an interval from a timestamp.static Field<LocalDateTime>
localDateTimeSub(Field<LocalDateTime> date, Field<? extends Number> interval, DatePart datePart)
Subtract an interval from a timestamp, given a date part.static Field<LocalTime>
localTime(String value)
Convert a string value to aTIME
.static Field<LocalTime>
localTime(LocalTime value)
Convert a temporal value to aTIME
.static Field<LocalTime>
localTime(Field<LocalTime> field)
Convert a temporal value to aTIME
.static Field<BigDecimal>
log(Number value, int base)
Get the log(field, base) function.static Field<BigDecimal>
log(Field<? extends Number> field, int base)
Get the log(field, base) function.static Field<BigDecimal>
log(Field<? extends Number> field, Field<? extends Number> base)
Get the log(field, base) function.static Statement
loop(Collection<? extends Statement> statements)
Create aLOOP
for use in procedural code.static Statement
loop(Statement... statements)
Create aLOOP
for use in procedural code.static Field<String>
lower(String value)
Get the lower(field) function.static Field<String>
lower(Field<String> field)
Get the lower(field) function.static Field<String>
lpad(Field<String> field, int length)
Get the lpad(field, length) function.static Field<String>
lpad(Field<String> field, int length, char character)
Get the lpad(field, length, character) function.static Field<String>
lpad(Field<String> field, int length, String character)
Get the lpad(field, length, character) function.static Field<String>
lpad(Field<String> field, Field<? extends Number> length)
Get the lpad(field, length) function.static Field<String>
lpad(Field<String> field, Field<? extends Number> length, Field<String> character)
Get the lpad(field, length, character) function.static Field<String>
ltrim(String value)
Get the ltrim(field) function.static Field<String>
ltrim(String value, String characters)
Get theltrim(field, characters)
ortrim(leading characters from field)
function.static Field<String>
ltrim(Field<String> field)
Get the ltrim(field) function.static Field<String>
ltrim(Field<String> field, Field<String> characters)
Get theltrim(field, characters)
ortrim(leading characters from field)
function.static <T> AggregateFunction<T>
max(Field<T> field)
Get the max value over a field: max(field).static <T> AggregateFunction<T>
maxDistinct(Field<T> field)
Get the max value over a field: max(distinct field).static Field<String>
md5(String string)
Get the MySQL-specificMD5()
function.static Field<String>
md5(Field<String> string)
Get the MySQL-specificMD5()
function.static AggregateFunction<BigDecimal>
median(Field<? extends Number> field)
Get the median over a numeric field: median(field).static <R extends Record>
MergeUsingStep<R>mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.static <R extends Record>
MergeKeyStepN<R>mergeInto(Table<R> table, Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax).static <R extends Record>
MergeKeyStepN<R>mergeInto(Table<R> table, Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax).static <R extends Record,T1>
MergeKeyStep1<R,T1>mergeInto(Table<R> table, Field<T1> field1)
static <R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)
static <R extends Record,T1,T2,T3>
MergeKeyStep3<R,T1,T2,T3>mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
static <R extends Record,T1,T2,T3,T4>
MergeKeyStep4<R,T1,T2,T3,T4>mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
static <R extends Record,T1,T2,T3,T4,T5>
MergeKeyStep5<R,T1,T2,T3,T4,T5>mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
static <R extends Record,T1,T2,T3,T4,T5,T6>
MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7>
MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>mergeInto(Table<R> table, 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)
static Field<Integer>
microsecond(Temporal value)
Get the microsecond part of a date.static Field<Integer>
microsecond(Date value)
Get the microsecond part of a date.static Field<Integer>
microsecond(Field<?> field)
Get the microsecond part of a date.static Field<String>
mid(Field<String> field, int startingPosition, int length)
Get the mid(field, startingPosition, length) function.static Field<String>
mid(Field<String> field, Field<? extends Number> startingPosition, Field<? extends Number> length)
Get the mid(field, startingPosition, length) function.static Field<Integer>
millennium(Temporal value)
Get the millennium of a date.static Field<Integer>
millennium(Date value)
Get the millennium of a date.static Field<Integer>
millennium(Field<?> field)
Get the millennium of a date.static Field<Integer>
millisecond(Temporal value)
Get the millisecond part of a date.static Field<Integer>
millisecond(Date value)
Get the millisecond part of a date.static Field<Integer>
millisecond(Field<?> field)
Get the millisecond part of a date.static <T> AggregateFunction<T>
min(Field<T> field)
Get the min value over a field: min(field).static <T> AggregateFunction<T>
minDistinct(Field<T> field)
Get the min value over a field: min(distinct field).static <T extends Number>
Field<T>minus(Field<T> field)
Negate a field to get its negative value.static Field<Integer>
minute(Temporal value)
Get the minute part of a date.static Field<Integer>
minute(Date value)
Get the minute part of a date.static Field<Integer>
minute(Field<?> field)
Get the minute part of a date.static OrderedAggregateFunctionOfDeferredType
mode()
Themode() within group (oder by [order clause])
ordered aggregate function.static <T> AggregateFunction<T>
mode(Field<T> field)
Themode(field)
aggregate function.static Field<Integer>
month(Temporal value)
Get the month part of a date.static Field<Integer>
month(Date value)
Get the month part of a date.static Field<Integer>
month(Field<?> field)
Get the month part of a date.static Name
name(String unqualifiedName)
Create a new SQL identifier using an unqualified name.static Name
name(String... qualifiedName)
Create a new SQL identifier using a qualified name.static Name
name(Collection<String> qualifiedName)
Create a new SQL identifier using a qualified name.static Name
name(Name... nameParts)
Create a new SQL identifier using a qualified name.static <T extends Number>
Field<T>neg(Field<T> field)
Negate a field to get its negative value.static Condition
noCondition()
Return aCondition
that behaves like no condition being present.static Field<Boolean>
not(Boolean value)
Deprecated.- 3.8.0 - [#4763] - Usenot(Condition)
instead.static Condition
not(Condition condition)
Invert a condition.static Field<Boolean>
not(Field<Boolean> field)
Invert a boolean value.static Condition
notExists(Select<?> query)
Create a not exists condition.static Condition
notUnique(Select<?> query)
Create a not unique condition.static Field<Timestamp>
now()
Synonym forcurrentTimestamp()
.static Field<Timestamp>
now(Field<Integer> precision)
Synonym forcurrentTimestamp(Field)
.static <T> WindowFromFirstLastStep<T>
nthValue(Field<T> field, int nth)
Thenth_value(field) over ([analytic clause])
function.static <T> WindowFromFirstLastStep<T>
nthValue(Field<T> field, Field<Integer> nth)
Thenth_value(field) over ([analytic clause])
function.static WindowOverStep<Integer>
ntile(int number)
Thentile([number]) over ([analytic clause])
function.static <T> Field<T>
nullif(Field<T> value, Field<T> other)
Gets the Oracle-style NULLIF(value, other) function.static <T> Field<T>
nullif(Field<T> value, T other)
Gets the Oracle-style NULLIF(value, other) function.static <T> Field<T>
nullif(T value, Field<T> other)
Gets the Oracle-style NULLIF(value, other) function.static <T> Field<T>
nullif(T value, T other)
Gets the Oracle-style NULLIF(value, other) function.protected static Field<?>[]
nullSafe(Field<?>... fields)
Null-safety of a field.protected static <T> Field<T>
nullSafe(Field<T> field)
Null-safety of a field.protected static <T> Field<T>
nullSafe(Field<T> field, DataType<?> type)
Null-safety of a field.protected static <T> DataType<T>
nullSafeDataType(Field<T> field)
Get a default data type if a field is null.static <T> Field<T>
nvl(Field<T> value, Field<T> defaultValue)
Gets the Oracle-style NVL(value, defaultValue) function.static <T> Field<T>
nvl(Field<T> value, T defaultValue)
Gets the Oracle-style NVL(value, defaultValue) function.static <T> Field<T>
nvl(T value, Field<T> defaultValue)
Gets the Oracle-style NVL(value, defaultValue) function.static <T> Field<T>
nvl(T value, T defaultValue)
Gets the Oracle-style NVL(value, defaultValue) function.static <Z> Field<Z>
nvl2(Field<?> value, Field<Z> valueIfNotNull, Field<Z> valueIfNull)
Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.static <Z> Field<Z>
nvl2(Field<?> value, Field<Z> valueIfNotNull, Z valueIfNull)
Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.static <Z> Field<Z>
nvl2(Field<?> value, Z valueIfNotNull, Field<Z> valueIfNull)
Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.static <Z> Field<Z>
nvl2(Field<?> value, Z valueIfNotNull, Z valueIfNull)
Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.static Field<Integer>
octetLength(String value)
Get the octet_length(field) function.static Field<Integer>
octetLength(Field<String> field)
Get the octet_length(field) function.static Field<OffsetDateTime>
offsetDateTime(String value)
Convert a string value to aTIMESTAMP WITH TIME ZONE
.static Field<OffsetDateTime>
offsetDateTime(OffsetDateTime value)
Convert a temporal value to aTIMESTAMP WITH TIME ZONE
.static Field<OffsetDateTime>
offsetDateTime(Field<OffsetDateTime> field)
Convert a temporal value to aTIMESTAMP WITH TIME ZONE
.static Field<OffsetTime>
offsetTime(String value)
Convert a string value to aTIME WITH TIME ZONE
.static Field<OffsetTime>
offsetTime(OffsetTime value)
Convert a temporal value to aTIME WITH TIME ZONE
.static Field<OffsetTime>
offsetTime(Field<OffsetTime> field)
Convert a temporal value to aTIME WITH TIME ZONE
.static Param<Integer>
one()
A1
literal.static Condition
or(Collection<? extends Condition> conditions)
static Condition
or(Condition... conditions)
static Condition
or(Condition left, Condition right)
static WindowSpecificationRowsStep
orderBy(Collection<? extends OrderField<?>> fields)
Create aWindowSpecification
with anORDER BY
clause.static WindowSpecificationRowsStep
orderBy(Field<?>... fields)
Create aWindowSpecification
with anORDER BY
clause.static WindowSpecificationRowsStep
orderBy(OrderField<?>... fields)
Create aWindowSpecification
with anORDER BY
clause.static <T> Param<Object>
param()
Create an unnamed parameter with a generic type (Object
/SQLDataType.OTHER
) and no initial value.static <T> Param<T>
param(Class<T> type)
Create an unnamed parameter with a defined type and no initial value.static Param<Object>
param(String name)
Create a named parameter with a generic type (Object
/SQLDataType.OTHER
) and no initial value.static <T> Param<T>
param(String name, Class<T> type)
Create a named parameter with a defined type and no initial value.static <T> Param<T>
param(String name, DataType<T> type)
Create a named parameter with a defined type and no initial value.static <T> Param<T>
param(String name, Field<T> type)
Create a named parameter with a defined type of another field and no initial value.static <T> Param<T>
param(String name, T value)
Create a named parameter with an initial value.static <T> Param<T>
param(DataType<T> type)
Create an unnamed parameter with a defined type and no initial value.static <T> Param<T>
param(Field<T> field)
Create an unnamed parameter with the defined type of another field and no initial value.static WindowSpecificationOrderByStep
partitionBy(Collection<? extends Field<?>> fields)
Create aWindowSpecification
with aPARTITION BY
clause.static WindowSpecificationOrderByStep
partitionBy(Field<?>... fields)
Create aWindowSpecification
with aPARTITION BY
clause.static OrderedAggregateFunction<BigDecimal>
percentileCont(Number number)
Thepercentile_cont([number]) within group (order by [column])
function.static OrderedAggregateFunction<BigDecimal>
percentileCont(Field<? extends Number> field)
Thepercentile_cont([number]) within group (order by [column])
function.static OrderedAggregateFunction<BigDecimal>
percentileDisc(Number number)
Thepercentile_disc([number]) within group (order by [column])
function.static OrderedAggregateFunction<BigDecimal>
percentileDisc(Field<? extends Number> field)
Thepercentile_disc([number]) within group (order by [column])
function.static WindowOverStep<BigDecimal>
percentRank()
Theprecent_rank() over ([analytic clause])
function.static OrderedAggregateFunction<Integer>
percentRank(Collection<? extends Field<?>> fields)
Thepercent_rank(expr) within group (order by [order clause])
ordered-set aggregate function.static OrderedAggregateFunction<Integer>
percentRank(Field<?>... fields)
Thepercent_rank(expr) within group (order by [order clause])
ordered-set aggregate function.static Field<BigDecimal>
pi()
ThePI
literal.static Field<Integer>
position(String in, String search)
Get the position(in, search) function.static Field<Integer>
position(String in, String search, int startIndex)
Get the position(in, search, startindex) function.static Field<Integer>
position(String in, String search, Field<? extends Number> startIndex)
Get the position(in, search, startindex) function.static Field<Integer>
position(String in, Field<String> search)
Get the position(in, search) function.static Field<Integer>
position(String in, Field<String> search, int startIndex)
Get the position(in, search, startindex) function.static Field<Integer>
position(String in, Field<String> search, Field<? extends Number> startIndex)
Get the position(in, search, startindex) function.static Field<Integer>
position(Field<String> in, String search)
Get the position(in, search) function.static Field<Integer>
position(Field<String> in, String search, int startIndex)
Get the position(in, search, startindex) function.static Field<Integer>
position(Field<String> in, String search, Field<? extends Number> startIndex)
Get the position(in, search, startindex) function.static Field<Integer>
position(Field<String> in, Field<String> search)
Get the position(in, search) function.static Field<Integer>
position(Field<String> in, Field<String> search, int startIndex)
Get the position(in, search, startindex) function.static Field<Integer>
position(Field<String> in, Field<String> search, Field<? extends Number> startIndex)
Get the position(in, search, startindex) function.static Field<BigDecimal>
power(Number value, Number exponent)
Get the power(field, exponent) function.static Field<BigDecimal>
power(Number value, Field<? extends Number> exponent)
Get the power(field, exponent) function.static Field<BigDecimal>
power(Field<? extends Number> field, Number exponent)
Get the power(field, exponent) function.static Field<BigDecimal>
power(Field<? extends Number> field, Field<? extends Number> exponent)
Get the power(field, exponent) function.static ConstraintFinalStep
primaryKey(String... fields)
Create an unnamed (system named)PRIMARY KEY
constraint.static ConstraintFinalStep
primaryKey(Field<?>... fields)
Create an unnamed (system named)PRIMARY KEY
constraint.static ConstraintFinalStep
primaryKey(Name... fields)
Create an unnamed (system named)PRIMARY KEY
constraint.static <T> Field<T>
prior(Field<T> field)
Add the Oracle-specificPRIOR
unary operator before a field (to be used along withCONNECT BY
clauses).static Privilege
privilege(String privilege)
Create a new privilege reference.static AggregateFunction<BigDecimal>
product(Field<? extends Number> field)
Get the product over a numeric field: product(field).static AggregateFunction<BigDecimal>
productDistinct(Field<? extends Number> field)
Get the sum over a numeric field: product(distinct field).static Field<Integer>
quarter(Temporal value)
Get the quarter of a date.static Field<Integer>
quarter(Date value)
Get the quarter of a date.static Field<Integer>
quarter(Field<?> field)
Get the quarter of a date.static Queries
queries(Collection<? extends Query> queries)
Wrap a collection of queries.static Queries
queries(Query... queries)
Wrap a collection of queries.static RowCountQuery
query(String sql)
Create a new query holding plain SQL.static RowCountQuery
query(String sql, Object... bindings)
Create a new query holding plain SQL.static RowCountQuery
query(String sql, QueryPart... parts)
Create a new query holding plain SQL.static RowCountQuery
query(SQL sql)
Create a new query holding plain SQL.static QueryPart
queryPart(String sql)
Deprecated.- 3.6.0 - [#3854] - Usesql(String)
insteadstatic QueryPart
queryPart(String sql, Object... bindings)
Deprecated.- 3.6.0 - [#3854] - Usesql(String, Object...)
insteadstatic QueryPart
queryPart(String sql, QueryPart... parts)
Deprecated.- 3.6.0 - [#3854] - Usesql(String, QueryPart...)
insteadstatic Name
quotedName(String unqualifiedName)
Create a new SQL identifier using an unqualified, quoted name.static Name
quotedName(String... qualifiedName)
Create a new SQL identifier using a qualified, quoted name.static Name
quotedName(Collection<String> qualifiedName)
Create a new SQL identifier using a qualified, quoted name.static Field<BigDecimal>
rad(Number value)
Calculate radians from degrees from this field.static Field<BigDecimal>
rad(Field<? extends Number> field)
Calculate radians from degrees from this field.static Field<BigDecimal>
rand()
Get the rand() function.static WindowSpecificationRowsAndStep
rangeBetweenCurrentRow()
Create aWindowSpecification
with aRANGE
clause.static WindowSpecificationRowsAndStep
rangeBetweenFollowing(int number)
Create aWindowSpecification
with aRANGE
clause.static WindowSpecificationRowsAndStep
rangeBetweenPreceding(int number)
Create aWindowSpecification
with aRANGE
clause.static WindowSpecificationRowsAndStep
rangeBetweenUnboundedFollowing()
Create aWindowSpecification
with aRANGE
clause.static WindowSpecificationRowsAndStep
rangeBetweenUnboundedPreceding()
Create aWindowSpecification
with aRANGE
clause.static WindowSpecificationExcludeStep
rangeCurrentRow()
Create aWindowSpecification
with aRANGE
clause.static WindowSpecificationExcludeStep
rangeFollowing(int number)
Create aWindowSpecification
with aRANGE
clause.static WindowSpecificationExcludeStep
rangePreceding(int number)
Create aWindowSpecification
with aRANGE
clause.static WindowSpecificationExcludeStep
rangeUnboundedFollowing()
Create aWindowSpecification
with aRANGE
clause.static WindowSpecificationExcludeStep
rangeUnboundedPreceding()
Create aWindowSpecification
with aRANGE
clause.static WindowOverStep<Integer>
rank()
Therank() over ([analytic clause])
function.static OrderedAggregateFunction<Integer>
rank(Collection<? extends Field<?>> fields)
Therank(expr) within group (order by [order clause])
ordered-set aggregate function.static OrderedAggregateFunction<Integer>
rank(Field<?>... fields)
Therank(expr) within group (order by [order clause])
ordered-set aggregate function.static WindowOverStep<BigDecimal>
ratioToReport(Number number)
Theratio_to_report([expression]) over ([analytic clause])
function.static WindowOverStep<BigDecimal>
ratioToReport(Field<? extends Number> field)
Theratio_to_report([expression]) over ([analytic clause])
function.static <T1> RecordType<Record>
recordType(Collection<? extends Field<?>> fields)
Create aRecordType
of an arbitrary degree.static <T1> RecordType<Record>
recordType(Field<?>[] fields)
Create aRecordType
of an arbitrary degree.static <T1> RecordType<Record1<T1>>
recordType(Field<T1> field1)
Create aRecordType
of degree1
.static <T1,T2>
RecordType<Record2<T1,T2>>recordType(Field<T1> field1, Field<T2> field2)
Create aRecordType
of degree2
.static <T1,T2,T3>
RecordType<Record3<T1,T2,T3>>recordType(Field<T1> field1, Field<T2> field2, Field<T3> field3)
Create aRecordType
of degree3
.static <T1,T2,T3,T4>
RecordType<Record4<T1,T2,T3,T4>>recordType(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Create aRecordType
of degree4
.static <T1,T2,T3,T4,T5>
RecordType<Record5<T1,T2,T3,T4,T5>>recordType(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
Create aRecordType
of degree5
.static <T1,T2,T3,T4,T5,T6>
RecordType<Record6<T1,T2,T3,T4,T5,T6>>recordType(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Create aRecordType
of degree6
.static <T1,T2,T3,T4,T5,T6,T7>
RecordType<Record7<T1,T2,T3,T4,T5,T6,T7>>recordType(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
Create aRecordType
of degree7
.static <T1,T2,T3,T4,T5,T6,T7,T8>
RecordType<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>recordType(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
Create aRecordType
of degree8
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9>
RecordType<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>recordType(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)
Create aRecordType
of degree9
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
RecordType<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>recordType(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)
Create aRecordType
of degree10
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
RecordType<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>recordType(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)
Create aRecordType
of degree11
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
RecordType<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>recordType(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)
Create aRecordType
of degree12
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
RecordType<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>recordType(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)
Create aRecordType
of degree13
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
RecordType<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>recordType(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)
Create aRecordType
of degree14
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
RecordType<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>recordType(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)
Create aRecordType
of degree15
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
RecordType<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>recordType(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)
Create aRecordType
of degree16
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
RecordType<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>recordType(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)
Create aRecordType
of degree17
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
RecordType<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>recordType(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)
Create aRecordType
of degree18
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
RecordType<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>recordType(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)
Create aRecordType
of degree19
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
RecordType<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>recordType(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)
Create aRecordType
of degree20
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
RecordType<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>recordType(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)
Create aRecordType
of degree21
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
RecordType<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>recordType(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)
Create aRecordType
of degree22
.static AggregateFunction<BigDecimal>
regrAvgX(Field<? extends Number> y, Field<? extends Number> x)
Get theREGR_AVGX
linear regression function.static AggregateFunction<BigDecimal>
regrAvgY(Field<? extends Number> y, Field<? extends Number> x)
Get theREGR_AVGY
linear regression function.static AggregateFunction<BigDecimal>
regrCount(Field<? extends Number> y, Field<? extends Number> x)
Get theREGR_COUNT
linear regression function.static AggregateFunction<BigDecimal>
regrIntercept(Field<? extends Number> y, Field<? extends Number> x)
Get theREGR_INTERCEPT
linear regression function.static AggregateFunction<BigDecimal>
regrR2(Field<? extends Number> y, Field<? extends Number> x)
Get theREGR_R2
linear regression function.static AggregateFunction<BigDecimal>
regrSlope(Field<? extends Number> y, Field<? extends Number> x)
Get theREGR_SLOPE
linear regression function.static AggregateFunction<BigDecimal>
regrSXX(Field<? extends Number> y, Field<? extends Number> x)
Get theREGR_SXX
linear regression function.static AggregateFunction<BigDecimal>
regrSXY(Field<? extends Number> y, Field<? extends Number> x)
Get theREGR_SXY
linear regression function.static AggregateFunction<BigDecimal>
regrSYY(Field<? extends Number> y, Field<? extends Number> x)
Get theREGR_SYY
linear regression function.static Field<String>
repeat(String field, int count)
Get the repeat(field, count) function.static Field<String>
repeat(String field, Field<? extends Number> count)
Get the repeat(field, count) function.static RepeatUntilStep
repeat(Collection<? extends Statement> statements)
Create aREPEAT
loop for use in procedural code.static Field<String>
repeat(Field<String> field, int count)
Get the repeat(count) function.static Field<String>
repeat(Field<String> field, Field<? extends Number> count)
Get the repeat(field, count) function.static RepeatUntilStep
repeat(Statement... statements)
Create aREPEAT
loop for use in procedural code.static Field<String>
replace(Field<String> field, String search)
Get the replace(field, search) function.static Field<String>
replace(Field<String> field, String search, String replace)
Get the replace(field, search, replace) function.static Field<String>
replace(Field<String> field, Field<String> search)
Get the replace(field, search) function.static Field<String>
replace(Field<String> field, Field<String> search, Field<String> replace)
Get the replace(field, search, replace) function.static ResultQuery<Record>
resultQuery(String sql)
Create a new query holding plain SQL.static ResultQuery<Record>
resultQuery(String sql, Object... bindings)
Create a new query holding plain SQL.static ResultQuery<Record>
resultQuery(String sql, QueryPart... parts)
Create a new query holding plain SQL.static ResultQuery<Record>
resultQuery(SQL sql)
Create a new query holding plain SQL.static Field<String>
reverse(String value)
Get thereverse(field)
function.static Field<String>
reverse(Field<String> field)
Get thereverse(field)
function.static RevokeOnStep
revoke(Collection<? extends Privilege> privileges)
Revoke privileges on table from user or role.static RevokeOnStep
revoke(Privilege privilege)
Revoke a privilege on table from user or role.static RevokeOnStep
revoke(Privilege... privileges)
Revoke privileges on table from user or role.static RevokeOnStep
revokeGrantOptionFor(Collection<? extends Privilege> privileges)
Revoke grant option for some privileges on a table from user or role.static RevokeOnStep
revokeGrantOptionFor(Privilege privilege)
Revoke grant option for a privilege on a table from user or role.static RevokeOnStep
revokeGrantOptionFor(Privilege... privileges)
Revoke grant option for some privileges on a table from user or role.static Field<String>
right(String field, int length)
Get the right outermost characters from a string.static Field<String>
right(String field, Field<? extends Number> length)
Get the right outermost characters from a string.static Field<String>
right(Field<String> field, int length)
Get the right outermost characters from a string.static Field<String>
right(Field<String> field, Field<? extends Number> length)
Get the right outermost characters from a string.static Role
role(String name)
Create a new role reference.static Role
role(Name name)
Create a new role reference.static GroupField
rollup(Field<?>... fields)
Create a ROLLUP(field1, field2, .., fieldn) grouping field.static GroupField
rollup(FieldOrRow... fields)
Create a ROLLUP(field1, field2, .., fieldn) grouping field.static <T extends Number>
Field<T>round(Field<T> field)
Get rounded value of a numeric field: round(field).static <T extends Number>
Field<T>round(Field<T> field, int decimals)
Get rounded value of a numeric field: round(field, decimals).static <T extends Number>
Field<T>round(T value)
Get rounded value of a numeric field: round(field).static <T extends Number>
Field<T>round(T value, int decimals)
Get rounded value of a numeric field: round(field, decimals).static RowN
row(Object... values)
Create a row value expression of degreeN > 22
.static RowN
row(Collection<?> values)
Create a row value expression of degreeN > 22
.static RowN
row(Field<?>... values)
Create a row value expression of degreeN > 22
.static <T1> Row1<T1>
row(Field<T1> t1)
Create a row value expression of degree1
.static <T1,T2>
Row2<T1,T2>row(Field<T1> t1, Field<T2> t2)
Create a row value expression of degree2
.static <T1,T2,T3>
Row3<T1,T2,T3>row(Field<T1> t1, Field<T2> t2, Field<T3> t3)
Create a row value expression of degree3
.static <T1,T2,T3,T4>
Row4<T1,T2,T3,T4>row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4)
Create a row value expression of degree4
.static <T1,T2,T3,T4,T5>
Row5<T1,T2,T3,T4,T5>row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5)
Create a row value expression of degree5
.static <T1,T2,T3,T4,T5,T6>
Row6<T1,T2,T3,T4,T5,T6>row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6)
Create a row value expression of degree6
.static <T1,T2,T3,T4,T5,T6,T7>
Row7<T1,T2,T3,T4,T5,T6,T7>row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7)
Create a row value expression of degree7
.static <T1,T2,T3,T4,T5,T6,T7,T8>
Row8<T1,T2,T3,T4,T5,T6,T7,T8>row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8)
Create a row value expression of degree8
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9>
Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>row(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)
Create a row value expression of degree9
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>row(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)
Create a row value expression of degree10
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>row(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)
Create a row value expression of degree11
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>row(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)
Create a row value expression of degree12
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>row(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)
Create a row value expression of degree13
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>row(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)
Create a row value expression of degree14
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>row(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)
Create a row value expression of degree15
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>row(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)
Create a row value expression of degree16
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>row(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)
Create a row value expression of degree17
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>row(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)
Create a row value expression of degree18
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>row(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)
Create a row value expression of degree19
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>row(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)
Create a row value expression of degree20
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>row(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)
Create a row value expression of degree21
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>row(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)
Create a row value expression of degree22
.static <T1> Row1<T1>
row(T1 t1)
Create a row value expression of degree1
.static <T1,T2>
Row2<T1,T2>row(T1 t1, T2 t2)
Create a row value expression of degree2
.static <T1,T2,T3>
Row3<T1,T2,T3>row(T1 t1, T2 t2, T3 t3)
Create a row value expression of degree3
.static <T1,T2,T3,T4>
Row4<T1,T2,T3,T4>row(T1 t1, T2 t2, T3 t3, T4 t4)
Create a row value expression of degree4
.static <T1,T2,T3,T4,T5>
Row5<T1,T2,T3,T4,T5>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5)
Create a row value expression of degree5
.static <T1,T2,T3,T4,T5,T6>
Row6<T1,T2,T3,T4,T5,T6>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6)
Create a row value expression of degree6
.static <T1,T2,T3,T4,T5,T6,T7>
Row7<T1,T2,T3,T4,T5,T6,T7>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)
Create a row value expression of degree7
.static <T1,T2,T3,T4,T5,T6,T7,T8>
Row8<T1,T2,T3,T4,T5,T6,T7,T8>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8)
Create a row value expression of degree8
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9>
Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9)
Create a row value expression of degree9
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
Create a row value expression of degree10
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11)
Create a row value expression of degree11
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12)
Create a row value expression of degree12
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13)
Create a row value expression of degree13
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14)
Create a row value expression of degree14
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15)
Create a row value expression of degree15
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)
Create a row value expression of degree16
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17)
Create a row value expression of degree17
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18)
Create a row value expression of degree18
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)
Create a row value expression of degree19
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19, T20 t20)
Create a row value expression of degree20
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19, T20 t20, T21 t21)
Create a row value expression of degree21
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19, T20 t20, T21 t21, T22 t22)
Create a row value expression of degree22
.static <T1> Field<Record1<T1>>
rowField(Row1<T1> row)
EXPERIMENTAL: Turn a row value expression of degree1
into aField
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
Field<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>rowField(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
EXPERIMENTAL: Turn a row value expression of degree10
into aField
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
Field<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>rowField(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> row)
EXPERIMENTAL: Turn a row value expression of degree11
into aField
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
Field<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>rowField(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> row)
EXPERIMENTAL: Turn a row value expression of degree12
into aField
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
Field<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>rowField(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> row)
EXPERIMENTAL: Turn a row value expression of degree13
into aField
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
Field<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>rowField(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> row)
EXPERIMENTAL: Turn a row value expression of degree14
into aField
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
Field<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>rowField(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> row)
EXPERIMENTAL: Turn a row value expression of degree15
into aField
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
Field<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>rowField(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)
EXPERIMENTAL: Turn a row value expression of degree16
into aField
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
Field<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>rowField(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> row)
EXPERIMENTAL: Turn a row value expression of degree17
into aField
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
Field<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>rowField(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
EXPERIMENTAL: Turn a row value expression of degree18
into aField
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
Field<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>rowField(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)
EXPERIMENTAL: Turn a row value expression of degree19
into aField
.static <T1,T2>
Field<Record2<T1,T2>>rowField(Row2<T1,T2> row)
EXPERIMENTAL: Turn a row value expression of degree2
into aField
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
Field<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>rowField(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> row)
EXPERIMENTAL: Turn a row value expression of degree20
into aField
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
Field<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>rowField(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> row)
EXPERIMENTAL: Turn a row value expression of degree21
into aField
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
Field<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>rowField(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> row)
EXPERIMENTAL: Turn a row value expression of degree22
into aField
.static <T1,T2,T3>
Field<Record3<T1,T2,T3>>rowField(Row3<T1,T2,T3> row)
EXPERIMENTAL: Turn a row value expression of degree3
into aField
.static <T1,T2,T3,T4>
Field<Record4<T1,T2,T3,T4>>rowField(Row4<T1,T2,T3,T4> row)
EXPERIMENTAL: Turn a row value expression of degree4
into aField
.static <T1,T2,T3,T4,T5>
Field<Record5<T1,T2,T3,T4,T5>>rowField(Row5<T1,T2,T3,T4,T5> row)
EXPERIMENTAL: Turn a row value expression of degree5
into aField
.static <T1,T2,T3,T4,T5,T6>
Field<Record6<T1,T2,T3,T4,T5,T6>>rowField(Row6<T1,T2,T3,T4,T5,T6> row)
EXPERIMENTAL: Turn a row value expression of degree6
into aField
.static <T1,T2,T3,T4,T5,T6,T7>
Field<Record7<T1,T2,T3,T4,T5,T6,T7>>rowField(Row7<T1,T2,T3,T4,T5,T6,T7> row)
EXPERIMENTAL: Turn a row value expression of degree7
into aField
.static <T1,T2,T3,T4,T5,T6,T7,T8>
Field<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>rowField(Row8<T1,T2,T3,T4,T5,T6,T7,T8> row)
EXPERIMENTAL: Turn a row value expression of degree8
into aField
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9>
Field<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>rowField(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> row)
EXPERIMENTAL: Turn a row value expression of degree9
into aField
.static Field<Record>
rowField(RowN row)
EXPERIMENTAL: Turn a row value expression of arbitrary degree into aField
.static Field<Integer>
rownum()
Retrieve the Oracle-specificROWNUM
pseudo-field.static WindowOverStep<Integer>
rowNumber()
Therow_number() over ([analytic clause])
function.static WindowSpecificationRowsAndStep
rowsBetweenCurrentRow()
Create aWindowSpecification
with aROWS
clause.static WindowSpecificationRowsAndStep
rowsBetweenFollowing(int number)
Create aWindowSpecification
with aROWS
clause.static WindowSpecificationRowsAndStep
rowsBetweenPreceding(int number)
Create aWindowSpecification
with aROWS
clause.static WindowSpecificationRowsAndStep
rowsBetweenUnboundedFollowing()
Create aWindowSpecification
with aROWS
clause.static WindowSpecificationRowsAndStep
rowsBetweenUnboundedPreceding()
Create aWindowSpecification
with aROWS
clause.static WindowSpecificationExcludeStep
rowsCurrentRow()
Create aWindowSpecification
with aROWS
clause.static WindowSpecificationExcludeStep
rowsFollowing(int number)
Create aWindowSpecification
with aROWS
clause.static Table<Record>
rowsFrom(Table<?>... tables)
Create aROWS FROM (tables...)
expression.static WindowSpecificationExcludeStep
rowsPreceding(int number)
Create aWindowSpecification
with aROWS
clause.static WindowSpecificationExcludeStep
rowsUnboundedFollowing()
Create aWindowSpecification
with aROWS
clause.static WindowSpecificationExcludeStep
rowsUnboundedPreceding()
Create aWindowSpecification
with aROWS
clause.static Field<String>
rpad(Field<String> field, int length)
Get the rpad(field, length) function.static Field<String>
rpad(Field<String> field, int length, char character)
Get the rpad(field, length, character) function.static Field<String>
rpad(Field<String> field, int length, String character)
Get the rpad(field, length, character) function.static Field<String>
rpad(Field<String> field, Field<? extends Number> length)
Get the rpad(field, length) function.static Field<String>
rpad(Field<String> field, Field<? extends Number> length, Field<String> character)
Get the rpad(field, length, character) function.static Field<String>
rtrim(String value)
Get the rtrim(field) function.static Field<String>
rtrim(String value, String characters)
Get thertrim(field, characters)
ortrim(trailing characters from field)
function.static Field<String>
rtrim(Field<String> field)
Get the rtrim(field) function.static Field<String>
rtrim(Field<String> field, Field<String> characters)
Get thertrim(field, characters)
ortrim(trailing characters from field)
function.static Schema
schema(Name name)
Create a qualified schema, given its schema name.static Schema
schemaByName(String name)
Deprecated.- [#3843] - 3.6.0 - useschema(Name)
insteadstatic Field<Integer>
second(Temporal value)
Get the second part of a date.static Field<Integer>
second(Date value)
Get the second part of a date.static Field<Integer>
second(Field<?> field)
Get the second part of a date.static SelectSelectStep<Record>
select(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL subselect statement.static <T1> SelectSelectStep<Record1<T1>>
select(SelectField<T1> field1)
Create a new DSL subselect statement.static <T1,T2>
SelectSelectStep<Record2<T1,T2>>select(SelectField<T1> field1, SelectField<T2> field2)
Create a new DSL subselect statement.static <T1,T2,T3>
SelectSelectStep<Record3<T1,T2,T3>>select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)
Create a new DSL subselect statement.static <T1,T2,T3,T4>
SelectSelectStep<Record4<T1,T2,T3,T4>>select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)
Create a new DSL subselect statement.static <T1,T2,T3,T4,T5>
SelectSelectStep<Record5<T1,T2,T3,T4,T5>>select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)
Create a new DSL subselect statement.static <T1,T2,T3,T4,T5,T6>
SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
Create a new DSL subselect statement.static <T1,T2,T3,T4,T5,T6,T7>
SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>>select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7)
Create a new DSL subselect statement.static <T1,T2,T3,T4,T5,T6,T7,T8>
SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8)
Create a new DSL subselect statement.static <T1,T2,T3,T4,T5,T6,T7,T8,T9>
SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9)
Create a new DSL subselect statement.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10)
Create a new DSL subselect statement.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
SelectSelectStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11)
Create a new DSL subselect statement.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
SelectSelectStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12)
Create a new DSL subselect statement.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
SelectSelectStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13)
Create a new DSL subselect statement.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
SelectSelectStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14)
Create a new DSL subselect statement.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
SelectSelectStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15)
Create a new DSL subselect statement.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
SelectSelectStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16)
Create a new DSL subselect statement.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
SelectSelectStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T1
-