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
A DSL "entry point" providing implementations to the
org.jooq
interfaces.
The DSLContext
and this DSL
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 a Field
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 any
SELECT
to form a Condition
:
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:
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionTheABS
function.abs
(T value) TheABS
function.static @NotNull Field
<BigDecimal> TheACOS
function.static @NotNull Field
<BigDecimal> TheACOS
function.static @NotNull Field
<BigDecimal> TheACOSH
function.static @NotNull Field
<BigDecimal> TheACOSH
function.static @NotNull Field
<BigDecimal> TheACOTH
function.static @NotNull Field
<BigDecimal> TheACOTH
function.static <T> @NotNull AggregateFunction
<T> aggregate()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction
<T> aggregate()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction
<T> aggregate()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction
<T> aggregate()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction
<T> aggregateDistinct
(String name, Class<T> type, Field<?>... arguments) aggregateDistinct()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction
<T> aggregateDistinct
(String name, DataType<T> type, Field<?>... arguments) aggregateDistinct()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction
<T> aggregateDistinct
(Name name, Class<T> type, Field<?>... arguments) aggregateDistinct()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction
<T> aggregateDistinct
(Name name, DataType<T> type, Field<?>... arguments) aggregateDistinct()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull QuantifiedSelect
<Record1<T>> Create anALL
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect
<Record1<T>> Create anALL
quantified select to be used in quantified comparison predicate expressions.static <R extends Record>
@NotNull QuantifiedSelect<R> Create anALL
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect
<Record1<T>> all
(T... array) Create anALL
quantified select to be used in quantified comparison predicate expressions.static AlterDatabaseStep
alterDatabase
(String database) TheALTER DATABASE
statement.static AlterDatabaseStep
alterDatabase
(Catalog database) TheALTER DATABASE
statement.static AlterDatabaseStep
alterDatabase
(Name database) TheALTER DATABASE
statement.static AlterDatabaseStep
alterDatabaseIfExists
(String database) TheALTER DATABASE IF EXISTS
statement.static AlterDatabaseStep
alterDatabaseIfExists
(Catalog database) TheALTER DATABASE IF EXISTS
statement.static AlterDatabaseStep
alterDatabaseIfExists
(Name database) TheALTER DATABASE IF EXISTS
statement.static <T> AlterDomainStep
<T> alterDomain
(String domain) TheALTER DOMAIN
statement.static <T> AlterDomainStep
<T> alterDomain
(Domain<T> domain) TheALTER DOMAIN
statement.static <T> AlterDomainStep
<T> alterDomain
(Name domain) TheALTER DOMAIN
statement.static <T> AlterDomainStep
<T> alterDomainIfExists
(String domain) TheALTER DOMAIN IF EXISTS
statement.static <T> AlterDomainStep
<T> alterDomainIfExists
(Domain<T> domain) TheALTER DOMAIN IF EXISTS
statement.static <T> AlterDomainStep
<T> alterDomainIfExists
(Name domain) TheALTER DOMAIN IF EXISTS
statement.static AlterIndexOnStep
alterIndex
(String index) TheALTER INDEX
statement.static AlterIndexOnStep
alterIndex
(Index index) TheALTER INDEX
statement.static AlterIndexOnStep
alterIndex
(Name index) TheALTER INDEX
statement.static AlterIndexOnStep
alterIndexIfExists
(String index) TheALTER INDEX IF EXISTS
statement.static AlterIndexOnStep
alterIndexIfExists
(Index index) TheALTER INDEX IF EXISTS
statement.static AlterIndexOnStep
alterIndexIfExists
(Name index) TheALTER INDEX IF EXISTS
statement.static AlterViewStep
alterMaterializedView
(String view) TheALTER MATERIALIZED VIEW
statement.static AlterViewStep
alterMaterializedView
(Name view) TheALTER MATERIALIZED VIEW
statement.static AlterViewStep
alterMaterializedView
(Table<?> view) TheALTER MATERIALIZED VIEW
statement.static AlterViewStep
TheALTER MATERIALIZED VIEW IF EXISTS
statement.static AlterViewStep
TheALTER MATERIALIZED VIEW IF EXISTS
statement.static AlterViewStep
alterMaterializedViewIfExists
(Table<?> view) TheALTER MATERIALIZED VIEW IF EXISTS
statement.static AlterSchemaStep
alterSchema
(String schema) TheALTER SCHEMA
statement.static AlterSchemaStep
alterSchema
(Name schema) TheALTER SCHEMA
statement.static AlterSchemaStep
alterSchema
(Schema schema) TheALTER SCHEMA
statement.static AlterSchemaStep
alterSchemaIfExists
(String schema) TheALTER SCHEMA IF EXISTS
statement.static AlterSchemaStep
alterSchemaIfExists
(Name schema) TheALTER SCHEMA IF EXISTS
statement.static AlterSchemaStep
alterSchemaIfExists
(Schema schema) TheALTER SCHEMA IF EXISTS
statement.static AlterSequenceStep
<Number> alterSequence
(String sequence) TheALTER SEQUENCE
statement.static AlterSequenceStep
<Number> alterSequence
(Name sequence) TheALTER SEQUENCE
statement.static <T extends Number>
AlterSequenceStep<T> alterSequence
(Sequence<T> sequence) TheALTER SEQUENCE
statement.static AlterSequenceStep
<Number> alterSequenceIfExists
(String sequence) TheALTER SEQUENCE IF EXISTS
statement.static AlterSequenceStep
<Number> alterSequenceIfExists
(Name sequence) TheALTER SEQUENCE IF EXISTS
statement.static <T extends Number>
AlterSequenceStep<T> alterSequenceIfExists
(Sequence<T> sequence) TheALTER SEQUENCE IF EXISTS
statement.static @NotNull AlterTableStep
alterTable
(String table) Create a new DSLALTER TABLE
statement.static @NotNull AlterTableStep
alterTable
(Name table) Create a new DSLALTER TABLE
statement.static @NotNull AlterTableStep
alterTable
(Table<?> table) Create a new DSLALTER TABLE
statement.static @NotNull AlterTableStep
alterTableIfExists
(String table) Create a new DSLALTER TABLE
statement.static @NotNull AlterTableStep
alterTableIfExists
(Name table) Create a new DSLALTER TABLE
statement.static @NotNull AlterTableStep
alterTableIfExists
(Table<?> table) Create a new DSLALTER TABLE
statement.static AlterTypeStep
TheALTER TYPE
statement.static AlterTypeStep
TheALTER TYPE
statement.static AlterTypeStep
alterTypeIfExists
(String type) TheALTER TYPE IF EXISTS
statement.static AlterTypeStep
alterTypeIfExists
(Name type) TheALTER TYPE IF EXISTS
statement.static AlterViewStep
TheALTER VIEW
statement.static AlterViewStep
TheALTER VIEW
statement.static AlterViewStep
TheALTER VIEW
statement.static AlterViewStep
alterView
(Table<?> view, Collection<? extends Field<?>> fields) TheALTER VIEW
statement.static AlterViewStep
TheALTER VIEW
statement.static AlterViewStep
alterViewIfExists
(String view) TheALTER VIEW IF EXISTS
statement.static AlterViewStep
alterViewIfExists
(Name view) TheALTER VIEW IF EXISTS
statement.static AlterViewStep
alterViewIfExists
(Table<?> view) TheALTER VIEW IF EXISTS
statement.static @NotNull Condition
and
(Collection<? extends Condition> conditions) static @NotNull Condition
static @NotNull Condition
static <T> @NotNull QuantifiedSelect
<Record1<T>> Create anANY
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect
<Record1<T>> Create anANY
quantified select to be used in quantified comparison predicate expressions.static <R extends Record>
@NotNull QuantifiedSelect<R> Create anANY
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect
<Record1<T>> any
(T... array) Create anANY
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull AggregateFunction
<T> TheANY_VALUE
function.static <T> @NotNull Field
<T[]> array
(Collection<? extends Field<T>> fields) Create an array literal.static <T> @NotNull Field
<T[]> Create an array literal.static <T> @NotNull Field
<T[]> The PostgreSQLarray(select)
function.static <T> @NotNull Field
<T[]> array
(T... values) Create an array literal.static <T> @NotNull ArrayAggOrderByStep
<T[]> Get thearray_agg()
aggregate function.static <T> @NotNull ArrayAggOrderByStep
<T[]> arrayAggDistinct
(Field<T> field) Get thearray_agg()
aggregate function.static <T> @NotNull Field
<T[]> arrayAppend
(Field<T[]> arg1, Field<T> arg2) TheARRAY_APPEND
function.static <T> @NotNull Field
<T[]> arrayAppend
(Field<T[]> arg1, T arg2) TheARRAY_APPEND
function.static <T> @NotNull Field
<T[]> arrayAppend
(T[] arg1, Field<T> arg2) TheARRAY_APPEND
function.static <T> @NotNull Field
<T[]> arrayAppend
(T[] arg1, T arg2) TheARRAY_APPEND
function.static <T> @NotNull Field
<T[]> arrayConcat
(Field<T[]> arg1, Field<T[]> arg2) TheARRAY_CONCAT
function.static <T> @NotNull Field
<T[]> arrayConcat
(Field<T[]> arg1, T[] arg2) TheARRAY_CONCAT
function.static <T> @NotNull Field
<T[]> arrayConcat
(T[] arg1, Field<T[]> arg2) TheARRAY_CONCAT
function.static <T> @NotNull Field
<T[]> arrayConcat
(T[] arg1, T[] arg2) TheARRAY_CONCAT
function.static <T> @NotNull Field
<T> TheARRAY_GET
function.static <T> @NotNull Field
<T> TheARRAY_GET
function.static <T> @NotNull Condition
arrayOverlap
(Field<T[]> arg1, Field<T[]> arg2) TheARRAY_OVERLAP
function.static <T> @NotNull Condition
arrayOverlap
(Field<T[]> arg1, T[] arg2) TheARRAY_OVERLAP
function.static <T> @NotNull Condition
arrayOverlap
(T[] arg1, Field<T[]> arg2) TheARRAY_OVERLAP
function.static <T> @NotNull Condition
arrayOverlap
(T[] arg1, T[] arg2) TheARRAY_OVERLAP
function.static <T> @NotNull Field
<T[]> arrayPrepend
(Field<T> arg1, Field<T[]> arg2) TheARRAY_PREPEND
function.static <T> @NotNull Field
<T[]> arrayPrepend
(Field<T> arg1, T[] arg2) TheARRAY_PREPEND
function.static <T> @NotNull Field
<T[]> arrayPrepend
(T arg1, Field<T[]> arg2) TheARRAY_PREPEND
function.static <T> @NotNull Field
<T[]> arrayPrepend
(T arg1, T[] arg2) TheARRAY_PREPEND
function.static <T> @NotNull Field
<T[]> arrayRemove
(Field<T[]> arg1, Field<T> arg2) TheARRAY_REMOVE
function.static <T> @NotNull Field
<T[]> arrayRemove
(Field<T[]> arg1, T arg2) TheARRAY_REMOVE
function.static <T> @NotNull Field
<T[]> arrayRemove
(T[] arg1, Field<T> arg2) TheARRAY_REMOVE
function.static <T> @NotNull Field
<T[]> arrayRemove
(T[] arg1, T arg2) TheARRAY_REMOVE
function.static <T> @NotNull Field
<T[]> arrayReplace
(Field<T[]> arg1, Field<T> arg2, Field<T> arg3) TheARRAY_REPLACE
function.static <T> @NotNull Field
<T[]> arrayReplace
(T[] arg1, T arg2, T arg3) TheARRAY_REPLACE
function.TheASCII
function.TheASCII
function.static @NotNull Field
<BigDecimal> TheASIN
function.static @NotNull Field
<BigDecimal> TheASIN
function.static @NotNull Field
<BigDecimal> TheASINH
function.static @NotNull Field
<BigDecimal> TheASINH
function.static @NotNull Asterisk
asterisk()
The asterisk (*
) to be used inSELECT
clauses.static @NotNull Field
<BigDecimal> TheATAN
function.static @NotNull Field
<BigDecimal> TheATAN
function.static @NotNull Field
<BigDecimal> TheATAN2
function.static @NotNull Field
<BigDecimal> TheATAN2
function.static @NotNull Field
<BigDecimal> TheATAN2
function.static @NotNull Field
<BigDecimal> TheATAN2
function.static @NotNull Field
<BigDecimal> TheATANH
function.static @NotNull Field
<BigDecimal> TheATANH
function.static @NotNull AggregateFunction
<BigDecimal> TheAVG
function.static @NotNull AggregateFunction
<BigDecimal> avgDistinct
(Field<? extends Number> field) TheAVG_DISTINCT
function.static @NotNull Block
begin
(Collection<? extends Statement> statements) Wrap a collection of statements in an anonymous procedural block.static @NotNull Block
Wrap a collection of statements in an anonymous procedural block.TheBIT_AND
function.TheBIT_AND
function.TheBIT_AND
function.bitAnd
(T arg1, T arg2) TheBIT_AND
function.static <T extends Number>
@NotNull AggregateFunction<T> TheBIT_AND_AGG
function.TheBIT_COUNT
function.TheBIT_COUNT
function.TheBIT_GET
function.TheBIT_GET
function.TheBIT_LENGTH
function.TheBIT_LENGTH
function.TheBIT_NAND
function.TheBIT_NAND
function.TheBIT_NAND
function.bitNand
(T arg1, T arg2) TheBIT_NAND
function.static <T extends Number>
@NotNull AggregateFunction<T> bitNandAgg
(Field<T> value) TheBIT_NAND_AGG
function.TheBIT_NOR
function.TheBIT_NOR
function.TheBIT_NOR
function.bitNor
(T arg1, T arg2) TheBIT_NOR
function.static <T extends Number>
@NotNull AggregateFunction<T> TheBIT_NOR_AGG
function.TheBIT_NOT
function.bitNot
(T arg1) TheBIT_NOT
function.TheBIT_OR
function.TheBIT_OR
function.TheBIT_OR
function.bitOr
(T arg1, T arg2) TheBIT_OR
function.static <T extends Number>
@NotNull AggregateFunction<T> TheBIT_OR_AGG
function.TheBIT_SET
function.TheBIT_SET
function.TheBIT_SET
function.TheBIT_SET
function.TheBIT_SET
function.TheBIT_SET
function.TheBIT_XNOR
function.TheBIT_XNOR
function.TheBIT_XNOR
function.bitXNor
(T arg1, T arg2) TheBIT_XNOR
function.static <T extends Number>
@NotNull AggregateFunction<T> bitXNorAgg
(Field<T> value) TheBIT_XNOR_AGG
function.TheBIT_XOR
function.TheBIT_XOR
function.TheBIT_XOR
function.bitXor
(T arg1, T arg2) TheBIT_XOR
function.static <T extends Number>
@NotNull AggregateFunction<T> TheBIT_XOR_AGG
function.static @NotNull AggregateFunction
<Boolean> TheBOOL_AND
function.static @NotNull AggregateFunction
<Boolean> TheBOOL_AND
function.static @NotNull AggregateFunction
<Boolean> TheBOOL_OR
function.static @NotNull AggregateFunction
<Boolean> TheBOOL_OR
function.static CallArgsStep
TheCALL
statement.static CallArgsStep
TheCALL
statement.cardinality
(Field<? extends Object[]> array) TheCARDINALITY
function.static @NotNull Case
case_()
Initialise aCase
statement.static <V> @NotNull CaseValueStep
<V> Initialise aCase
statement.static <V> @NotNull CaseValueStep
<V> case_
(V value) Initialise aCase
statement.static <T> @NotNull Field
<T> Cast a value to another type.static <T> @NotNull Field
<T> Cast a value to another type.static <T> @NotNull Field
<T> Cast a value to the type of another field.static <T> @NotNull Field
<T> Cast a field to another type.static <T> @NotNull Field
<T> Cast a field to another type.static <T> @NotNull Field
<T> Cast a field to the type of another field.static <T> @NotNull Field
<T> Cast null to a type.static <T> @NotNull Field
<T> Cast null to a type.static <T> @NotNull Field
<T> Cast null to the type of another field.static @NotNull Catalog
Create a qualified catalog, given its catalog name.static @NotNull Catalog
Create a qualified catalog, given its catalog name.TheCEIL
function.ceil
(T value) TheCEIL
function.Get the century of a date.Get the century of a date.Get the century of a date.static @NotNull CharacterSet
characterSet
(String characterSet) Create a character set by its unqualified name.static @NotNull CharacterSet
characterSet
(Name characterSet) Create a character set by its qualified name.charLength
(String string) TheCHAR_LENGTH
function.charLength
(Field<String> string) TheCHAR_LENGTH
function.static @NotNull ConstraintEnforcementStep
Create an unnamed (system named)CHECK
constraint.static @NotNull Case
choose()
Initialise aCase
statement.static <T> @NotNull Field
<T> The T-SQLCHOOSE()
function.static <T> @NotNull Field
<T> choose
(int index, T... values) The T-SQLCHOOSE()
function.static <T> @NotNull Field
<T> The T-SQLCHOOSE()
function.static <T> @NotNull Field
<T> The T-SQLCHOOSE()
function.static <V> @NotNull CaseValueStep
<V> Initialise aCase
statement.static <V> @NotNull CaseValueStep
<V> choose
(V value) Initialise aCase
statement.TheCHR
function.TheCHR
function.static <T> @NotNull Field
<T> TheCOALESCE(field1, field2, … , field n)
function.static <T> @NotNull Field
<T> TheCOALESCE(field, value)
function.static <T> @NotNull Field
<T> coalesce
(T value, T... values) TheCOALESCE(value1, value2, … , value n)
function.static <T> @NotNull Field
<T> Coerce this field to another type.static <T> @NotNull Field
<T> Coerce a field to another type.static <T> @NotNull Field
<T> Coerce this field to the type of another field.static <T> @NotNull Field
<T> Coerce this field to another type.static <T> @NotNull Field
<T> Coerce a field to another type.static <T> @NotNull Field
<T> Coerce this field to the type of another field.static @NotNull Collation
Create a collation by its unqualified name.static @NotNull Collation
Create a collation by its qualified name.static <T,
A extends ArrayRecord<T>>
@NotNull ArrayAggOrderByStep<A> Get thecollect()
aggregate function.static <T,
A extends ArrayRecord<T>>
@NotNull ArrayAggOrderByStep<A> Get thecollect()
aggregate function.static <T,
A extends ArrayRecord<T>>
@NotNull ArrayAggOrderByStep<A> collectDistinct
(Field<T> field, Class<A> type) Get thecollect()
aggregate function.static <T,
A extends ArrayRecord<T>>
@NotNull ArrayAggOrderByStep<A> collectDistinct
(Field<T> field, DataType<A> type) Get thecollect()
aggregate function.static @NotNull Comment
Create a comment.static CommentOnIsStep
commentOnColumn
(String field) TheCOMMENT ON COLUMN
statement.static CommentOnIsStep
commentOnColumn
(Field<?> field) TheCOMMENT ON COLUMN
statement.static CommentOnIsStep
commentOnColumn
(Name field) TheCOMMENT ON COLUMN
statement.static CommentOnIsStep
TheCOMMENT ON MATERIALIZED VIEW
statement.static CommentOnIsStep
TheCOMMENT ON MATERIALIZED VIEW
statement.static CommentOnIsStep
commentOnMaterializedView
(Table<?> view) TheCOMMENT ON MATERIALIZED VIEW
statement.static CommentOnIsStep
commentOnTable
(String table) TheCOMMENT ON TABLE
statement.static CommentOnIsStep
commentOnTable
(Name table) TheCOMMENT ON TABLE
statement.static CommentOnIsStep
commentOnTable
(Table<?> table) TheCOMMENT ON TABLE
statement.static CommentOnIsStep
commentOnView
(String view) TheCOMMENT ON VIEW
statement.static CommentOnIsStep
commentOnView
(Name view) TheCOMMENT ON VIEW
statement.static CommentOnIsStep
commentOnView
(Table<?> view) TheCOMMENT ON VIEW
statement.static Query
commit()
TheCOMMIT
statement.Get the concat(value[, value, ...]) function.Get theconcat(value, field)
function.Get the concat(field[, field, ...]) function.Get theconcat(field, value)
function.static @NotNull Condition
Create a condition from a boolean field.static @NotNull Condition
Create a new condition holding plain SQL.static @NotNull Condition
Create a new condition holding plain SQL.static @NotNull Condition
A custom SQL clause that can render arbitrary SQL elements.static @NotNull Condition
Create a condition from a map.static @NotNull Condition
TheCONDITION
function.static @NotNull Condition
condition
(Operator operator, Collection<? extends Condition> conditions) Return aCondition
that connects all argumentconditions
withOperator
.static @NotNull Condition
Return aCondition
that connects all argumentconditions
withOperator
.static @NotNull Condition
Return aCondition
that connects all argumentconditions
withOperator
.static @NotNull Condition
static @NotNull Condition
Create a new condition holding plain SQL.TheCONNECT_BY_ISCYCLE
function.TheCONNECT_BY_ISLEAF
function.static <T> @NotNull Field
<T> connectByRoot
(Field<T> field) TheCONNECT_BY_ROOT
function.static @NotNull ConstraintTypeStep
Create an unnamed (system named)CONSTRAINT
specification.static @NotNull ConstraintTypeStep
constraint
(String name) Create aCONSTRAINT
specification.static @NotNull ConstraintTypeStep
constraint
(Name name) Create aCONSTRAINT
specification.static @NotNull ContinueWhenStep
Create anCONTINUE
statement for use in procedural code.static @NotNull ContinueWhenStep
Create anCONTINUE
statement for use in procedural code.static @NotNull Statement
continueWhen
(Condition condition) Create anCONTINUE
statement for use in procedural code.static @NotNull Statement
continueWhen
(Field<Boolean> condition) Create anCONTINUE
statement for use in procedural code.static <T> @NotNull Field
<T> Convert a date time value to a string value using the SQL Server styleCONVERT()
function.static <T> @NotNull Field
<T> Convert a date time value to a string value using the SQL Server styleCONVERT()
function.static @NotNull AggregateFunction
<BigDecimal> TheCORR
function.static @NotNull Field
<BigDecimal> TheCOS
function.static @NotNull Field
<BigDecimal> TheCOS
function.static @NotNull Field
<BigDecimal> TheCOSH
function.static @NotNull Field
<BigDecimal> TheCOSH
function.static @NotNull Field
<BigDecimal> TheCOT
function.static @NotNull Field
<BigDecimal> TheCOT
function.static @NotNull Field
<BigDecimal> TheCOTH
function.static @NotNull Field
<BigDecimal> TheCOTH
function.static @NotNull AggregateFunction
<Integer> count()
Get the count(*) function.static @NotNull AggregateFunction
<Integer> TheCOUNT
function.static @NotNull AggregateFunction
<Integer> count
(SelectFieldOrAsterisk field) Get the count(field) function.static @NotNull AggregateFunction
<Integer> Get the count(table) function.static @NotNull AggregateFunction
<Integer> countDistinct
(Field<?> field) TheCOUNT_DISTINCT
function.static @NotNull AggregateFunction
<Integer> countDistinct
(Field<?>... fields) Get the count(distinct field1, field2) function.static @NotNull AggregateFunction
<Integer> Get the count(distinct field) function.static @NotNull AggregateFunction
<Integer> countDistinct
(Table<?> table) Get the count(distinct table) function.static @NotNull AggregateFunction
<BigDecimal> TheCOVAR_POP
function.static @NotNull AggregateFunction
<BigDecimal> TheCOVAR_SAMP
function.static CreateDatabaseFinalStep
createDatabase
(String database) TheCREATE DATABASE
statement.static CreateDatabaseFinalStep
createDatabase
(Catalog database) TheCREATE DATABASE
statement.static CreateDatabaseFinalStep
createDatabase
(Name database) TheCREATE DATABASE
statement.static CreateDatabaseFinalStep
createDatabaseIfNotExists
(String database) TheCREATE DATABASE IF NOT EXISTS
statement.static CreateDatabaseFinalStep
createDatabaseIfNotExists
(Catalog database) TheCREATE DATABASE IF NOT EXISTS
statement.static CreateDatabaseFinalStep
createDatabaseIfNotExists
(Name database) TheCREATE DATABASE IF NOT EXISTS
statement.static CreateDomainAsStep
createDomain
(String domain) TheCREATE DOMAIN
statement.static CreateDomainAsStep
createDomain
(Domain<?> domain) TheCREATE DOMAIN
statement.static CreateDomainAsStep
createDomain
(Name domain) TheCREATE DOMAIN
statement.static CreateDomainAsStep
createDomainIfNotExists
(String domain) TheCREATE DOMAIN IF NOT EXISTS
statement.static CreateDomainAsStep
createDomainIfNotExists
(Domain<?> domain) TheCREATE DOMAIN IF NOT EXISTS
statement.static CreateDomainAsStep
createDomainIfNotExists
(Name domain) TheCREATE DOMAIN IF NOT EXISTS
statement.static CreateFunctionParametersStep
createFunction
(String function) TheCREATE FUNCTION
statement.static CreateFunctionParametersStep
createFunction
(Name function) TheCREATE FUNCTION
statement.static CreateTableElementListStep
createGlobalTemporaryTable
(String table) TheCREATE GLOBAL TEMPORARY TABLE
statement.static CreateTableElementListStep
createGlobalTemporaryTable
(Name table) TheCREATE GLOBAL TEMPORARY TABLE
statement.static CreateTableElementListStep
createGlobalTemporaryTable
(Table<?> table) TheCREATE GLOBAL TEMPORARY TABLE
statement.static CreateTableElementListStep
TheCREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS
statement.static CreateTableElementListStep
TheCREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS
statement.static CreateTableElementListStep
createGlobalTemporaryTableIfNotExists
(Table<?> table) TheCREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS
statement.static CreateIndexStep
TheCREATE INDEX
statement.static CreateIndexStep
createIndex
(String index) TheCREATE INDEX
statement.static CreateIndexStep
createIndex
(Index index) TheCREATE INDEX
statement.static CreateIndexStep
createIndex
(Name index) TheCREATE INDEX
statement.static CreateIndexStep
TheCREATE INDEX IF NOT EXISTS
statement.static CreateIndexStep
createIndexIfNotExists
(String index) TheCREATE INDEX IF NOT EXISTS
statement.static CreateIndexStep
createIndexIfNotExists
(Index index) TheCREATE INDEX IF NOT EXISTS
statement.static CreateIndexStep
createIndexIfNotExists
(Name index) TheCREATE INDEX IF NOT EXISTS
statement.static CreateViewAsStep
<Record> createMaterializedView
(String view, String... fields) TheCREATE MATERIALIZED VIEW
statement.static CreateViewAsStep
<Record> createMaterializedView
(String view, Collection<? extends String> fields) TheCREATE MATERIALIZED VIEW
statement.static CreateViewAsStep
<Record> createMaterializedView
(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW
statement.static CreateViewAsStep
<Record> createMaterializedView
(Name view, Name... fields) TheCREATE MATERIALIZED VIEW
statement.static CreateViewAsStep
<Record> createMaterializedView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE MATERIALIZED VIEW
statement.static CreateViewAsStep
<Record> createMaterializedView
(Table<?> view, Field<?>... fields) TheCREATE MATERIALIZED VIEW
statement.static CreateViewAsStep
<Record> createMaterializedViewIfNotExists
(String view, String... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.static CreateViewAsStep
<Record> createMaterializedViewIfNotExists
(String view, Collection<? extends String> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.static CreateViewAsStep
<Record> createMaterializedViewIfNotExists
(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.static CreateViewAsStep
<Record> createMaterializedViewIfNotExists
(Name view, Name... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.static CreateViewAsStep
<Record> createMaterializedViewIfNotExists
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.static CreateViewAsStep
<Record> createMaterializedViewIfNotExists
(Table<?> view, Field<?>... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.static CreateFunctionParametersStep
createOrReplaceFunction
(String function) TheCREATE OR REPLACE FUNCTION
statement.static CreateFunctionParametersStep
createOrReplaceFunction
(Name function) TheCREATE OR REPLACE FUNCTION
statement.static CreateViewAsStep
<Record> createOrReplaceMaterializedView
(String view, String... fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.static CreateViewAsStep
<Record> createOrReplaceMaterializedView
(String view, Collection<? extends String> fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.static CreateViewAsStep
<Record> createOrReplaceMaterializedView
(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.static CreateViewAsStep
<Record> createOrReplaceMaterializedView
(Name view, Name... fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.static CreateViewAsStep
<Record> createOrReplaceMaterializedView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.static CreateViewAsStep
<Record> createOrReplaceMaterializedView
(Table<?> view, Field<?>... fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.createOrReplaceProcedure
(String procedure) TheCREATE OR REPLACE PROCEDURE
statement.createOrReplaceProcedure
(Name procedure) TheCREATE OR REPLACE PROCEDURE
statement.static CreateTriggerEventStep
createOrReplaceTrigger
(String trigger) TheCREATE OR REPLACE TRIGGER
statement.static CreateTriggerEventStep
createOrReplaceTrigger
(Name trigger) TheCREATE OR REPLACE TRIGGER
statement.static CreateTriggerEventStep
createOrReplaceTrigger
(Trigger trigger) TheCREATE OR REPLACE TRIGGER
statement.static CreateViewAsStep
<Record> createOrReplaceView
(String view, String... fields) TheCREATE OR REPLACE VIEW
statement.static CreateViewAsStep
<Record> createOrReplaceView
(String view, Collection<? extends String> fields) TheCREATE OR REPLACE VIEW
statement.static @NotNull CreateViewAsStep
<Record> createOrReplaceView
(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.static CreateViewAsStep
<Record> createOrReplaceView
(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE VIEW
statement.static @NotNull CreateViewAsStep
<Record> createOrReplaceView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.static CreateViewAsStep
<Record> createOrReplaceView
(Name view, Name... fields) TheCREATE OR REPLACE VIEW
statement.static CreateViewAsStep
<Record> createOrReplaceView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE OR REPLACE VIEW
statement.static @NotNull CreateViewAsStep
<Record> createOrReplaceView
(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.static CreateViewAsStep
<Record> createOrReplaceView
(Table<?> view, Field<?>... fields) TheCREATE OR REPLACE VIEW
statement.createProcedure
(String procedure) TheCREATE PROCEDURE
statement.createProcedure
(Name procedure) TheCREATE PROCEDURE
statement.static CreateSchemaFinalStep
createSchema
(String schema) TheCREATE SCHEMA
statement.static CreateSchemaFinalStep
createSchema
(Name schema) TheCREATE SCHEMA
statement.static CreateSchemaFinalStep
createSchema
(Schema schema) TheCREATE SCHEMA
statement.static CreateSchemaFinalStep
createSchemaIfNotExists
(String schema) TheCREATE SCHEMA IF NOT EXISTS
statement.static CreateSchemaFinalStep
createSchemaIfNotExists
(Name schema) TheCREATE SCHEMA IF NOT EXISTS
statement.static CreateSchemaFinalStep
createSchemaIfNotExists
(Schema schema) TheCREATE SCHEMA IF NOT EXISTS
statement.static CreateSequenceFlagsStep
createSequence
(String sequence) TheCREATE SEQUENCE
statement.static CreateSequenceFlagsStep
createSequence
(Name sequence) TheCREATE SEQUENCE
statement.static CreateSequenceFlagsStep
createSequence
(Sequence<?> sequence) TheCREATE SEQUENCE
statement.static CreateSequenceFlagsStep
createSequenceIfNotExists
(String sequence) TheCREATE SEQUENCE IF NOT EXISTS
statement.static CreateSequenceFlagsStep
createSequenceIfNotExists
(Name sequence) TheCREATE SEQUENCE IF NOT EXISTS
statement.static CreateSequenceFlagsStep
createSequenceIfNotExists
(Sequence<?> sequence) TheCREATE SEQUENCE IF NOT EXISTS
statement.static CreateTableElementListStep
createTable
(String table) TheCREATE TABLE
statement.static CreateTableElementListStep
createTable
(Name table) TheCREATE TABLE
statement.static CreateTableElementListStep
createTable
(Table<?> table) TheCREATE TABLE
statement.static CreateTableElementListStep
createTableIfNotExists
(String table) TheCREATE TABLE IF NOT EXISTS
statement.static CreateTableElementListStep
createTableIfNotExists
(Name table) TheCREATE TABLE IF NOT EXISTS
statement.static CreateTableElementListStep
createTableIfNotExists
(Table<?> table) TheCREATE TABLE IF NOT EXISTS
statement.static CreateTableElementListStep
createTemporaryTable
(String table) TheCREATE TEMPORARY TABLE
statement.static CreateTableElementListStep
createTemporaryTable
(Name table) TheCREATE TEMPORARY TABLE
statement.static CreateTableElementListStep
createTemporaryTable
(Table<?> table) TheCREATE TEMPORARY TABLE
statement.static CreateTableElementListStep
TheCREATE TEMPORARY TABLE IF NOT EXISTS
statement.static CreateTableElementListStep
TheCREATE TEMPORARY TABLE IF NOT EXISTS
statement.static CreateTableElementListStep
createTemporaryTableIfNotExists
(Table<?> table) TheCREATE TEMPORARY TABLE IF NOT EXISTS
statement.static CreateTriggerEventStep
createTrigger
(String trigger) TheCREATE TRIGGER
statement.static CreateTriggerEventStep
createTrigger
(Name trigger) TheCREATE TRIGGER
statement.static CreateTriggerEventStep
createTrigger
(Trigger trigger) TheCREATE TRIGGER
statement.static CreateTypeStep
createType
(String type) TheCREATE TYPE
statement.static CreateTypeStep
createType
(Name type) TheCREATE TYPE
statement.static CreateTypeStep
createType
(Type<?> type) TheCREATE TYPE
statement.static CreateTypeStep
createTypeIfNotExists
(String type) TheCREATE TYPE IF NOT EXISTS
statement.static CreateTypeStep
createTypeIfNotExists
(Name type) TheCREATE TYPE IF NOT EXISTS
statement.static CreateTypeStep
createTypeIfNotExists
(Type<?> type) TheCREATE TYPE IF NOT EXISTS
statement.static CreateIndexStep
TheCREATE UNIQUE INDEX
statement.static CreateIndexStep
createUniqueIndex
(String index) TheCREATE UNIQUE INDEX
statement.static CreateIndexStep
createUniqueIndex
(Index index) TheCREATE UNIQUE INDEX
statement.static CreateIndexStep
createUniqueIndex
(Name index) TheCREATE UNIQUE INDEX
statement.static CreateIndexStep
TheCREATE UNIQUE INDEX IF NOT EXISTS
statement.static CreateIndexStep
TheCREATE UNIQUE INDEX IF NOT EXISTS
statement.static CreateIndexStep
TheCREATE UNIQUE INDEX IF NOT EXISTS
statement.static CreateIndexStep
createUniqueIndexIfNotExists
(Name index) TheCREATE UNIQUE INDEX IF NOT EXISTS
statement.static CreateViewAsStep
<Record> createView
(String view, String... fields) TheCREATE VIEW
statement.static CreateViewAsStep
<Record> createView
(String view, Collection<? extends String> fields) TheCREATE VIEW
statement.static @NotNull CreateViewAsStep
<Record> createView
(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.static CreateViewAsStep
<Record> createView
(Name view, Collection<? extends Name> fields) TheCREATE VIEW
statement.static @NotNull CreateViewAsStep
<Record> createView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.static CreateViewAsStep
<Record> createView
(Name view, Name... fields) TheCREATE VIEW
statement.static CreateViewAsStep
<Record> createView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE VIEW
statement.static @NotNull CreateViewAsStep
<Record> createView
(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.static CreateViewAsStep
<Record> createView
(Table<?> view, Field<?>... fields) TheCREATE VIEW
statement.static CreateViewAsStep
<Record> createViewIfNotExists
(String view, String... fields) TheCREATE VIEW IF NOT EXISTS
statement.static CreateViewAsStep
<Record> createViewIfNotExists
(String view, Collection<? extends String> fields) TheCREATE VIEW IF NOT EXISTS
statement.static @NotNull CreateViewAsStep
<Record> createViewIfNotExists
(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.static CreateViewAsStep
<Record> createViewIfNotExists
(Name view, Collection<? extends Name> fields) TheCREATE VIEW IF NOT EXISTS
statement.static @NotNull CreateViewAsStep
<Record> createViewIfNotExists
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.static CreateViewAsStep
<Record> createViewIfNotExists
(Name view, Name... fields) TheCREATE VIEW IF NOT EXISTS
statement.static CreateViewAsStep
<Record> createViewIfNotExists
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE VIEW IF NOT EXISTS
statement.static @NotNull CreateViewAsStep
<Record> createViewIfNotExists
(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.static CreateViewAsStep
<Record> createViewIfNotExists
(Table<?> view, Field<?>... fields) TheCREATE VIEW IF NOT EXISTS
statement.static @NotNull GroupField
Create a CUBE(field1, field2, .., fieldn) grouping field.static @NotNull GroupField
cube
(FieldOrRow... fields) Create a CUBE(field1, field2, .., fieldn) grouping field.static @NotNull WindowOverStep
<BigDecimal> cumeDist()
Thecume_dist() over ([analytic clause])
function.static @NotNull OrderedAggregateFunction
<BigDecimal> cumeDist
(Collection<? extends Field<?>> fields) Thecume_dist(expr) within group (order by [order clause])
ordered-set aggregate function.static @NotNull OrderedAggregateFunction
<BigDecimal> Thecume_dist(expr) within group (order by [order clause])
ordered-set aggregate function.TheCURRENT_CATALOG
function.Get the current_date() function returning a SQL standardSQLDataType.DATE
type.Get the current_timestamp() function.Get the current_date() function returning a SQL standardSQLDataType.DATE
type.static @NotNull Field
<LocalDateTime> Get the current_timestamp() function returning a SQL standardSQLDataType.TIMESTAMP
type.static @NotNull Field
<LocalDateTime> currentLocalDateTime
(int precision) Get the current_timestamp() function returning a SQL standardSQLDataType.TIMESTAMP
type with the specified fractional seconds precision.static @NotNull Field
<LocalDateTime> currentLocalDateTime
(Field<Integer> precision) Get the current_timestamp() function returning a SQL standardSQLDataType.TIMESTAMP
type with the specified fractional seconds precision.Get the current_time() function returning a SQL standardSQLDataType.TIME
type.static @NotNull Field
<OffsetDateTime> Get the current_timestamp() function.static @NotNull Field
<OffsetTime> Get the current_time() function.TheCURRENT_SCHEMA
function.Get the current_time() function returning a SQL standardSQLDataType.TIME
type.Get the current_timestamp() function returning a SQL standardSQLDataType.TIMESTAMP
type.currentTimestamp
(int precision) Get the current_timestamp() function returning a SQL standardSQLDataType.TIMESTAMP
type with the specified fractional seconds precision.currentTimestamp
(Field<Integer> precision) Get the current_timestamp() function returning a SQL standardSQLDataType.TIMESTAMP
type with the specified fractional seconds precision.TheCURRENT_USER
function.Convert a string value to aDATE
.Convert a temporal value to aDATE
.Convert a temporal value to aDATE
.TheDATE_ADD
function.TheDATE_ADD
function.TheDATE_ADD
function.TheDATE_ADD
function.TheDATE_ADD
function.TheDATE_ADD
function.TheDATE_ADD
function.TheDATE_ADD
function.Get the date difference betweenendDate - startDate
in number of days.Get the date difference betweenendDate - startDate
in number of days.Get the date difference betweenendDate - startDate
in terms ofpart
.Get the date difference betweenendDate - startDate
in terms ofpart
.Get the date difference betweenendDate - startDate
in terms ofpart
.Get the date difference betweenendDate - startDate
in terms ofpart
.Get the date difference betweenendDate - startDate
in number of days.Get the date difference betweenendDate - startDate
in number of days.Subtract an interval from a date.Subtract an interval from a date, given a date part.Subtract an interval from a date.Subtract an interval from a date, given a date part.Subtract an interval from a date.Subtract an interval from a date, given a date part.Subtract an interval from a date.Subtract an interval from a date, given a date part.Get the day part of a date.Get the day part of a date.Get the day part of a date.Get the day of week part of a date.Get the day of week part of a date.Get the day of week part of a date.Get the day of week part of a date.Get the day of week part of a date.Get the day of week part of a date.Get the decade of a date.Get the decade of a date.Get the decade of a date.static @NotNull Statement
declare
(Collection<? extends Variable<?>> variables) Create a local variable declaration for use in procedural code.static @NotNull Statement
Create a local variable declaration for use in procedural code.static <T> @NotNull Declaration
<T> Create a local variable declaration for use in procedural code.static @NotNull Case
decode()
Initialise aCase
statement.static <Z,
T> @NotNull Field <Z> Gets the Oracle-styleDECODE(expression, search, result[, search , result]… [, default])
function.static <Z,
T> @NotNull Field <Z> Gets the Oracle-styleDECODE(expression, search, result[, search , result]… [, default])
function.static <Z,
T> @NotNull Field <Z> decode
(T value, T search, Z result) Gets the Oracle-styleDECODE(expression, search, result[, search , result]… [, default])
function.static <Z,
T> @NotNull Field <Z> Gets the Oracle-styleDECODE(expression, search, result[, search , result]… [, default])
function.default_()
Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.static <T> @NotNull Field
<T> Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.static <T> @NotNull Field
<T> Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.static <T> @NotNull Field
<T> Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.static <T> @NotNull Field
<T> defaultValue
(Class<T> type) Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.static <T> @NotNull Field
<T> defaultValue
(DataType<T> type) Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.static <T> @NotNull Field
<T> defaultValue
(Field<T> field) Create aDEFAULT
keyword for use withINSERT
,UPDATE
, orMERGE
statements.static @NotNull Field
<BigDecimal> TheDEGREES
function.static @NotNull Field
<BigDecimal> TheDEGREES
function.static <R extends Record>
@NotNull DeleteUsingStep<R> Create a new DSL delete statement.static <R extends Record>
@NotNull DeleteUsingStep<R> deleteFrom
(Table<R> table) Create a new DSL delete statement.static @NotNull Condition
deleting()
TheDELETING
function.static @NotNull WindowOverStep
<Integer> Thedense_rank() over ([analytic clause])
function.static @NotNull OrderedAggregateFunction
<Integer> denseRank
(Collection<? extends Field<?>> fields) Thedense_rank(expr) within group (order by [order clause])
ordered-set aggregate function.static @NotNull OrderedAggregateFunction
<Integer> Thedense_rank(expr) within group (order by [order clause])
ordered-set aggregate function.TheDIGITS
function.TheDIGITS
function.static @NotNull Domain
<?> Create aDOMAIN
reference.static <T> @NotNull Domain
<T> Create aDOMAIN
reference.static <T> @NotNull Domain
<T> Create aDOMAIN
reference.static @NotNull Domain
<?> Create aDOMAIN
reference.static <T> @NotNull Domain
<T> Create aDOMAIN
reference.static <T> @NotNull Domain
<T> Create aDOMAIN
reference.static DropDatabaseFinalStep
dropDatabase
(String database) TheDROP DATABASE
statement.static DropDatabaseFinalStep
dropDatabase
(Catalog database) TheDROP DATABASE
statement.static DropDatabaseFinalStep
dropDatabase
(Name database) TheDROP DATABASE
statement.static DropDatabaseFinalStep
dropDatabaseIfExists
(String database) TheDROP DATABASE IF EXISTS
statement.static DropDatabaseFinalStep
dropDatabaseIfExists
(Catalog database) TheDROP DATABASE IF EXISTS
statement.static DropDatabaseFinalStep
dropDatabaseIfExists
(Name database) TheDROP DATABASE IF EXISTS
statement.static DropDomainCascadeStep
dropDomain
(String domain) TheDROP DOMAIN
statement.static DropDomainCascadeStep
dropDomain
(Domain<?> domain) TheDROP DOMAIN
statement.static DropDomainCascadeStep
dropDomain
(Name domain) TheDROP DOMAIN
statement.static DropDomainCascadeStep
dropDomainIfExists
(String domain) TheDROP DOMAIN IF EXISTS
statement.static DropDomainCascadeStep
dropDomainIfExists
(Domain<?> domain) TheDROP DOMAIN IF EXISTS
statement.static DropDomainCascadeStep
dropDomainIfExists
(Name domain) TheDROP DOMAIN IF EXISTS
statement.static DDLQuery
dropFunction
(String function) TheDROP FUNCTION
statement.static DDLQuery
dropFunction
(Name function) TheDROP FUNCTION
statement.static DDLQuery
dropFunctionIfExists
(String function) TheDROP FUNCTION IF EXISTS
statement.static DDLQuery
dropFunctionIfExists
(Name function) TheDROP FUNCTION IF EXISTS
statement.static DropIndexOnStep
TheDROP INDEX
statement.static DropIndexOnStep
TheDROP INDEX
statement.static DropIndexOnStep
TheDROP INDEX
statement.static DropIndexOnStep
dropIndexIfExists
(String index) TheDROP INDEX IF EXISTS
statement.static DropIndexOnStep
dropIndexIfExists
(Index index) TheDROP INDEX IF EXISTS
statement.static DropIndexOnStep
dropIndexIfExists
(Name index) TheDROP INDEX IF EXISTS
statement.static DropViewFinalStep
dropMaterializedView
(String view) TheDROP MATERIALIZED VIEW
statement.static DropViewFinalStep
dropMaterializedView
(Name view) TheDROP MATERIALIZED VIEW
statement.static DropViewFinalStep
dropMaterializedView
(Table<?> view) TheDROP MATERIALIZED VIEW
statement.static DropViewFinalStep
TheDROP MATERIALIZED VIEW IF EXISTS
statement.static DropViewFinalStep
TheDROP MATERIALIZED VIEW IF EXISTS
statement.static DropViewFinalStep
dropMaterializedViewIfExists
(Table<?> view) TheDROP MATERIALIZED VIEW IF EXISTS
statement.static DDLQuery
dropProcedure
(String procedure) TheDROP PROCEDURE
statement.static DDLQuery
dropProcedure
(Name procedure) TheDROP PROCEDURE
statement.static DDLQuery
dropProcedureIfExists
(String procedure) TheDROP PROCEDURE IF EXISTS
statement.static DDLQuery
dropProcedureIfExists
(Name procedure) TheDROP PROCEDURE IF EXISTS
statement.static DropSchemaStep
dropSchema
(String schema) TheDROP SCHEMA
statement.static DropSchemaStep
dropSchema
(Name schema) TheDROP SCHEMA
statement.static DropSchemaStep
dropSchema
(Schema schema) TheDROP SCHEMA
statement.static DropSchemaStep
dropSchemaIfExists
(String schema) TheDROP SCHEMA IF EXISTS
statement.static DropSchemaStep
dropSchemaIfExists
(Name schema) TheDROP SCHEMA IF EXISTS
statement.static DropSchemaStep
dropSchemaIfExists
(Schema schema) TheDROP SCHEMA IF EXISTS
statement.static DropSequenceFinalStep
dropSequence
(String sequence) TheDROP SEQUENCE
statement.static DropSequenceFinalStep
dropSequence
(Name sequence) TheDROP SEQUENCE
statement.static DropSequenceFinalStep
dropSequence
(Sequence<?> sequence) TheDROP SEQUENCE
statement.static DropSequenceFinalStep
dropSequenceIfExists
(String sequence) TheDROP SEQUENCE IF EXISTS
statement.static DropSequenceFinalStep
dropSequenceIfExists
(Name sequence) TheDROP SEQUENCE IF EXISTS
statement.static DropSequenceFinalStep
dropSequenceIfExists
(Sequence<?> sequence) TheDROP SEQUENCE IF EXISTS
statement.static DropTableStep
TheDROP TABLE
statement.static DropTableStep
TheDROP TABLE
statement.static DropTableStep
TheDROP TABLE
statement.static DropTableStep
dropTableIfExists
(String table) TheDROP TABLE IF EXISTS
statement.static DropTableStep
dropTableIfExists
(Name table) TheDROP TABLE IF EXISTS
statement.static DropTableStep
dropTableIfExists
(Table<?> table) TheDROP TABLE IF EXISTS
statement.static DropTableStep
dropTemporaryTable
(String table) TheDROP TEMPORARY TABLE
statement.static DropTableStep
dropTemporaryTable
(Name table) TheDROP TEMPORARY TABLE
statement.static DropTableStep
dropTemporaryTable
(Table<?> table) TheDROP TEMPORARY TABLE
statement.static DropTableStep
dropTemporaryTableIfExists
(String table) TheDROP TEMPORARY TABLE IF EXISTS
statement.static DropTableStep
dropTemporaryTableIfExists
(Name table) TheDROP TEMPORARY TABLE IF EXISTS
statement.static DropTableStep
dropTemporaryTableIfExists
(Table<?> table) TheDROP TEMPORARY TABLE IF EXISTS
statement.static DropTriggerOnStep
dropTrigger
(String trigger) TheDROP TRIGGER
statement.static DropTriggerOnStep
dropTrigger
(Name trigger) TheDROP TRIGGER
statement.static DropTriggerOnStep
dropTrigger
(Trigger trigger) TheDROP TRIGGER
statement.static DropTriggerOnStep
dropTriggerIfExists
(String trigger) TheDROP TRIGGER IF EXISTS
statement.static DropTriggerOnStep
dropTriggerIfExists
(Name trigger) TheDROP TRIGGER IF EXISTS
statement.static DropTriggerOnStep
dropTriggerIfExists
(Trigger trigger) TheDROP TRIGGER IF EXISTS
statement.static DropTypeStep
TheDROP TYPE
statement.static DropTypeStep
TheDROP TYPE
statement.static DropTypeStep
dropType
(Collection<? extends Type<?>> types) TheDROP TYPE
statement.static DropTypeStep
TheDROP TYPE
statement.static DropTypeStep
TheDROP TYPE
statement.static DropTypeStep
TheDROP TYPE
statement.static DropTypeStep
TheDROP TYPE
statement.static DropTypeStep
dropTypeIfExists
(String types) TheDROP TYPE IF EXISTS
statement.static DropTypeStep
dropTypeIfExists
(String... types) TheDROP TYPE IF EXISTS
statement.static DropTypeStep
dropTypeIfExists
(Collection<? extends Type<?>> types) TheDROP TYPE IF EXISTS
statement.static DropTypeStep
dropTypeIfExists
(Name types) TheDROP TYPE IF EXISTS
statement.static DropTypeStep
dropTypeIfExists
(Name... types) TheDROP TYPE IF EXISTS
statement.static DropTypeStep
dropTypeIfExists
(Type<?> types) TheDROP TYPE IF EXISTS
statement.static DropTypeStep
dropTypeIfExists
(Type<?>... types) TheDROP TYPE IF EXISTS
statement.static DropViewFinalStep
TheDROP VIEW
statement.static DropViewFinalStep
TheDROP VIEW
statement.static DropViewFinalStep
TheDROP VIEW
statement.static DropViewFinalStep
dropViewIfExists
(String view) TheDROP VIEW IF EXISTS
statement.static DropViewFinalStep
dropViewIfExists
(Name view) TheDROP VIEW IF EXISTS
statement.static DropViewFinalStep
dropViewIfExists
(Table<?> view) TheDROP VIEW IF EXISTS
statement.dual()
TheDUAL
table to be used for syntactic completeness.static @NotNull Field
<BigDecimal> e()
TheE
function.static @NotNull GroupField
Create a GROUPING SETS(field1, field2, .., fieldn) grouping field where each grouping set only consists of a single field.Get the epoch of a date.Get the epoch of a date.Get the epoch of a date.static @NotNull String
Convenience method forreplace(Field, String, String)
to escape data for use withField.like(Field, char)
.Convenience method forreplace(Field, String, String)
to escape data for use withField.like(Field, char)
.static @NotNull AggregateFunction
<Boolean> TheEVERY
function, an alias for theBOOL_AND
function.static @NotNull AggregateFunction
<Boolean> TheEVERY
function, an alias for theBOOL_AND
function.static <T> @NotNull Field
<T> TheEXCLUDED
function.static @NotNull Statement
TheEXECUTE
function.static @NotNull Statement
TheEXECUTE
function.static @NotNull Statement
Execute a statement dynamically from within procedural code.static @NotNull Condition
TheEXISTS
function.static @NotNull ExitWhenStep
exit()
Create anEXIT
statement for use in procedural code.static @NotNull ExitWhenStep
Create anEXIT
statement for use in procedural code.static @NotNull Statement
Create anEXIT
statement for use in procedural code.static @NotNull Statement
Create anEXIT
statement for use in procedural code.static @NotNull Field
<BigDecimal> TheEXP
function.static @NotNull Field
<BigDecimal> TheEXP
function.Get the extract(field, datePart) function.Get the extract(field, datePart) function.Get the extract(field, datePart) function.static @NotNull False
Return aCondition
that will always evaluate toFALSE
.Create a "plain SQL" field.static <T> @NotNull Field
<T> Create a "plain SQL" field.static <T> @NotNull Field
<T> Create a "plain SQL" field.static <T> @NotNull Field
<T> A custom SQL clause that can render arbitrary SQL elements.Create a "plain SQL" field.static <T> @NotNull Field
<T> Create a "plain SQL" field.static <T> @NotNull Field
<T> Create a "plain SQL" field.static <T> @NotNull Field
<T> Create a "plain SQL" field.A custom SQL clause that can render arbitrary SQL elements.TheFIELD
function.Get the MySQLFIELD(expr, expr1, expr2, …)
function.Get the MySQLFIELD(expr, expr1, expr2, …)
function.Create a qualified field, given its (qualified) field name.static <T> @NotNull Field
<T> Create a qualified field, given its (qualified) field name.static <T> @NotNull Field
<T> Create a qualified field, given its (qualified) field name.static <T> @NotNull Field
<T> Create a qualified field, given its (qualified) field name.static <T> @NotNull Field
<T> Transform a subquery into a correlated subquery.static <T> @NotNull Field
<T> field
(SelectField<T> field) Wrap aSelectField
in a general-purposeField
Create a "plain SQL" field.static <T> @NotNull Field
<T> Create a "plain SQL" field.static <T> @NotNull Field
<T> Create a "plain SQL" field.finalTable
(Insert<R> query) finalTable
(Merge<R> query) finalTable
(Update<R> query) static <T> @NotNull WindowIgnoreNullsStep
<T> firstValue
(Field<T> field) Thefirst_value(field) over ([analytic clause])
function.TheFLOOR
function.floor
(T value) TheFLOOR
function.static <T> @NotNull ForInStep
<T> Create aFOR
loop for use in procedural code.static @NotNull ConstraintForeignKeyReferencesStep1
<?> foreignKey
(String field1) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStepN
foreignKey
(String... fields) Add aFOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep2
<?, ?> foreignKey
(String field1, String field2) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep3
<?, ?, ?> foreignKey
(String field1, String field2, String field3) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep4
<?, ?, ?, ?> foreignKey
(String field1, String field2, String field3, String field4) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep5
<?, ?, ?, ?, ?> Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull ConstraintForeignKeyReferencesStepN
foreignKey
(Collection<? extends Field<?>> fields) Add aFOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStepN
foreignKey
(Field<?>... fields) Add aFOREIGN KEY
clause to theCONSTRAINT
.static <T1> @NotNull ConstraintForeignKeyReferencesStep1
<T1> foreignKey
(Field<T1> field1) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,
T2> @NotNull ConstraintForeignKeyReferencesStep2 <T1, T2> foreignKey
(Field<T1> field1, Field<T2> field2) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T1,
T2, T3>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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 @NotNull ConstraintForeignKeyReferencesStep1
<?> foreignKey
(Name field1) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStepN
foreignKey
(Name... fields) Add aFOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep2
<?, ?> foreignKey
(Name field1, Name field2) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep3
<?, ?, ?> foreignKey
(Name field1, Name field2, Name field3) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep4
<?, ?, ?, ?> foreignKey
(Name field1, Name field2, Name field3, Name field4) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep5
<?, ?, ?, ?, ?> Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep6
<?, ?, ?, ?, ?, ?> Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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> @NotNull Field
<T> function()
can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull Field
<T> function()
can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull Field
<T> function()
can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull Field
<T> function()
can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.generateSeries
(int from, int to) A table function generating a series of values fromfrom
toto
(inclusive).generateSeries
(int from, int to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.generateSeries
(int from, int to, Field<Integer> step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.generateSeries
(int from, Field<Integer> to) A table function generating a series of values fromfrom
toto
(inclusive).generateSeries
(int from, Field<Integer> to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.generateSeries
(int from, Field<Integer> to, Field<Integer> step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.generateSeries
(Field<Integer> from, int to) A table function generating a series of values fromfrom
toto
(inclusive).generateSeries
(Field<Integer> from, int to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.generateSeries
(Field<Integer> from, int to, Field<Integer> step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.generateSeries
(Field<Integer> from, Field<Integer> to) A table function generating a series of values fromfrom
toto
(inclusive).generateSeries
(Field<Integer> from, Field<Integer> to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static <T> @NotNull DataType
<T> getDataType
(Class<T> type) Deprecated, for removal: This API element is subject to removal in a future version.- 3.11.0 - [#7483] - The (indirect) use of the internal static data type registry is not recommended.static @NotNull Statement
TheGOTO
function.static GrantOnStep
grant
(Collection<? extends Privilege> privileges) TheGRANT
statement.static GrantOnStep
TheGRANT
statement.static GrantOnStep
TheGRANT
statement.static <T> @NotNull Field
<T> Find the greatest among all values.static <T> @NotNull Field
<T> greatest
(T value, T... values) Find the greatest among all values.static @NotNull GroupConcatOrderByStep
groupConcat
(Field<?> field) Get the aggregated concatenation for a field.static @NotNull AggregateFunction
<String> groupConcat
(Field<?> field, String separator) Deprecated, for removal: This API element is subject to removal in a future version.- [#7956] - 3.12.0 - UsegroupConcat(Field)
andGroupConcatSeparatorStep.separator(String)
instead.static @NotNull GroupConcatOrderByStep
groupConcatDistinct
(Field<?> field) Get the aggregated concatenation for a field.groupId()
Create aGROUP_ID()
aggregation function to be used along withCUBE
,ROLLUP
, andGROUPING SETS
groupings.Create a GROUPING(field) aggregation field to be used along withCUBE
,ROLLUP
, andGROUPING SETS
groupings.groupingId
(Field<?>... fields) Create a GROUPING_ID(field1, field2, .., fieldn) aggregation field to be used along withCUBE
,ROLLUP
, andGROUPING SETS
groupings.static @NotNull GroupField
groupingSets
(Collection<? extends Field<?>>... fieldSets) Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna, fieldnb)) grouping field.static @NotNull GroupField
groupingSets
(Field<?>... fields) Create a GROUPING SETS(field1, field2, .., fieldn) grouping field where each grouping set only consists of a single field.static @NotNull GroupField
groupingSets
(Field<?>[]... fieldSets) Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna, fieldnb)) grouping field.static @NotNull WindowSpecificationRowsAndStep
Create aWindowSpecification
with aGROUPS
clause.static @NotNull WindowSpecificationRowsAndStep
groupsBetweenFollowing
(int number) Create aWindowSpecification
with aGROUPS
clause.static @NotNull WindowSpecificationRowsAndStep
groupsBetweenPreceding
(int number) Create aWindowSpecification
with aGROUPS
clause.static @NotNull WindowSpecificationRowsAndStep
Create aWindowSpecification
with aGROUPS
clause.static @NotNull WindowSpecificationRowsAndStep
Create aWindowSpecification
with aGROUPS
clause.static @NotNull WindowSpecificationExcludeStep
Create aWindowSpecification
with aGROUPS
clause.static @NotNull WindowSpecificationExcludeStep
groupsFollowing
(int number) Create aWindowSpecification
with aGROUPS
clause.static @NotNull WindowSpecificationExcludeStep
groupsPreceding
(int number) Create aWindowSpecification
with aGROUPS
clause.static @NotNull WindowSpecificationExcludeStep
Create aWindowSpecification
with aGROUPS
clause.static @NotNull WindowSpecificationExcludeStep
Create aWindowSpecification
with aGROUPS
clause.Get the hour part of a date.Get the hour part of a date.Get the hour part of a date.static @NotNull IfThenStep
Create anIF
statement for use in procedural code.static <T> @NotNull Field
<T> Create a MySQL styleIF(condition, ifTrue, ifFalse)
function.static <T> @NotNull Field
<T> Create a MySQL styleIF(condition, ifTrue, ifFalse)
function.static <T> @NotNull Field
<T> Create a MySQL styleIF(condition, ifTrue, ifFalse)
function.static <T> @NotNull Field
<T> Create a MySQL styleIF(condition, ifTrue, ifFalse)
function.static <T> @NotNull Field
<T> TheIFNULL
function, an alias for theNVL
function.static <T> @NotNull Field
<T> TheIFNULL
function, an alias for theNVL
function.static <T> @NotNull Field
<T> TheIFNULL
function, an alias for theNVL
function.static <T> @NotNull Field
<T> ifnull
(T value, T defaultValue) TheIFNULL
function, an alias for theNVL
function.static <T> @NotNull Field
<T> Gets the SQL Server style IIF(condition, ifTrue, ifFalse) function.static <T> @NotNull Field
<T> Gets the SQL Server style IIF(condition, ifTrue, ifFalse) function.static <T> @NotNull Field
<T> Gets the SQL Server style IIF(condition, ifTrue, ifFalse) function.static <T> @NotNull Field
<T> Gets the SQL Server style IIF(condition, ifTrue, ifFalse) function.static <T> @NotNull Parameter
<T> Create anIN
parameter.static <T> @NotNull Parameter
<T> Create anIN
parameter.static @NotNull Index
Create a qualified index reference by name.inline
(boolean value) Create a bind value that is always inlined.inline
(byte value) Create a bind value that is always inlined.static @NotNull Param
<byte[]> inline
(byte[] value) Create a bind value that is always inlined.inline
(char character) Create a bind value, that is always inlined.inline
(double value) Create a bind value that is always inlined.inline
(float value) Create a bind value that is always inlined.inline
(int value) Create a bind value that is always inlined.inline
(long value) Create a bind value that is always inlined.inline
(short value) Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value, that is always inlined.inline
(CharSequence character) Create a bind value, that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.static <T> @NotNull Param
<T> Create a bind value, that is always inlined.static <T> @NotNull Param
<T> Create a bind value, that is always inlined.static <T> @NotNull Param
<T> Create a bind value, that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.static @NotNull Param
<BigDecimal> inline
(BigDecimal value) Create a bind value that is always inlined.static @NotNull Param
<BigInteger> inline
(BigInteger value) Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.static @NotNull Param
<LocalDateTime> inline
(LocalDateTime value) Create a bind value that is always inlined.Create a bind value that is always inlined.static @NotNull Param
<OffsetDateTime> inline
(OffsetDateTime value) Create a bind value that is always inlined.static @NotNull Param
<OffsetTime> inline
(OffsetTime value) Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.Create a bind value that is always inlined.static <T> @NotNull Param
<T> inline
(T value) Create a bind value, that is always inlined.static @NotNull Condition
Inline all bind variables produced by the argumentCondition
.static <T> @NotNull Field
<T> Inline all bind variables produced by the argumentField
.static @NotNull QueryPart
Inline all bind variables produced by the argumentQueryPart
.static @NotNull Statement
Inline all bind variables produced by the argumentStatement
.static <T> @NotNull Parameter
<T> Create anIN OUT
parameter.static <T> @NotNull Parameter
<T> Create anIN OUT
parameter.Get the insert(in, startIndex, length, placing) function.insert
(Field<String> in, Field<? extends Number> startIndex, Field<? extends Number> length, Field<String> placing) Get the insert(in, startIndex, length, placing) function.static @NotNull Condition
TheINSERTING
function.static <R extends Record>
@NotNull InsertSetStep<R> insertInto
(Table<R> into) Create a new DSL insert statement.static <R extends Record>
@NotNull InsertValuesStepN<R> insertInto
(Table<R> into, Collection<? extends Field<?>> fields) Create a new DSL insert statement.static <R extends Record>
@NotNull InsertValuesStepN<R> insertInto
(Table<R> into, Field<?>... fields) Create a new DSL insert statement.static <R extends Record,
T1>
@NotNull InsertValuesStep1<R, T1> insertInto
(Table<R> into, Field<T1> field1) Create a new DSL insert statement.static <R extends Record,
T1, T2>
@NotNull 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>
@NotNull 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>
@NotNull InsertValuesStep4<R, T1, T2, T3, T4> Create a new DSL insert statement.static <R extends Record,
T1, T2, T3, T4, T5>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull InsertValuesStep22<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> 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.Convert a string value to aTIMESTAMP WITH TIME ZONE
.Convert a temporal value to aTIMESTAMP WITH TIME ZONE
.Convert a temporal value to aTIMESTAMP WITH TIME ZONE
.static <T> @NotNull Field
<T> TheISNULL
function, an alias for theNVL
function.static <T> @NotNull Field
<T> TheISNULL
function, an alias for theNVL
function.static <T> @NotNull Field
<T> TheISNULL
function, an alias for theNVL
function.static <T> @NotNull Field
<T> isnull
(T value, T defaultValue) TheISNULL
function, an alias for theNVL
function.isoDayOfWeek
(Temporal value) Get the ISO day of week part of a date.isoDayOfWeek
(Date value) Get the ISO day of week part of a date.isoDayOfWeek
(Field<?> field) Get the ISO day of week part of a date.static @NotNull JSONArrayNullStep
<JSON> jsonArray
(Collection<? extends Field<?>> fields) TheJSON_ARRAY
function.static @NotNull JSONArrayNullStep
<JSON> TheJSON_ARRAY
function.static @NotNull JSONArrayAggOrderByStep
<JSON> jsonArrayAgg
(Field<?> value) The JSON array aggregate function.static @NotNull JSONArrayAggOrderByStep
<JSON> jsonArrayAggDistinct
(Field<?> value) The JSON array aggregate function.static @NotNull JSONArrayNullStep
<JSONB> jsonbArray
(Collection<? extends Field<?>> fields) TheJSONB_ARRAY
function.static @NotNull JSONArrayNullStep
<JSONB> jsonbArray
(Field<?>... fields) TheJSONB_ARRAY
function.static @NotNull JSONArrayAggOrderByStep
<JSONB> jsonbArrayAgg
(Field<?> value) The JSON array aggregate function.static @NotNull JSONArrayAggOrderByStep
<JSONB> jsonbArrayAggDistinct
(Field<?> value) The JSON array aggregate function.static @NotNull JSONExistsOnStep
jsonbExists
(Field<JSONB> field, String path) The JSONB exists predicate.static @NotNull JSONExistsOnStep
jsonbExists
(Field<JSONB> field, Field<String> path) The JSONB exists predicate.jsonbGetAttribute
(Field<JSONB> field, String attribute) TheJSONB_GET_ATTRIBUTE
function.jsonbGetAttribute
(Field<JSONB> field, Field<String> attribute) TheJSONB_GET_ATTRIBUTE
function.jsonbGetAttribute
(JSONB field, String attribute) TheJSONB_GET_ATTRIBUTE
function.jsonbGetAttribute
(JSONB field, Field<String> attribute) TheJSONB_GET_ATTRIBUTE
function.jsonbGetAttributeAsText
(Field<JSONB> field, String attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXT
function.jsonbGetAttributeAsText
(Field<JSONB> field, Field<String> attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXT
function.jsonbGetAttributeAsText
(JSONB field, String attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXT
function.jsonbGetAttributeAsText
(JSONB field, Field<String> attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXT
function.jsonbGetElement
(Field<JSONB> field, int index) TheJSONB_GET_ELEMENT
function.jsonbGetElement
(Field<JSONB> field, Field<Integer> index) TheJSONB_GET_ELEMENT
function.jsonbGetElement
(JSONB field, int index) TheJSONB_GET_ELEMENT
function.jsonbGetElement
(JSONB field, Field<Integer> index) TheJSONB_GET_ELEMENT
function.jsonbGetElementAsText
(Field<JSONB> field, int index) TheJSONB_GET_ELEMENT_AS_TEXT
function.jsonbGetElementAsText
(Field<JSONB> field, Field<Integer> index) TheJSONB_GET_ELEMENT_AS_TEXT
function.jsonbGetElementAsText
(JSONB field, int index) TheJSONB_GET_ELEMENT_AS_TEXT
function.jsonbGetElementAsText
(JSONB field, Field<Integer> index) TheJSONB_GET_ELEMENT_AS_TEXT
function.jsonbInsert
(Field<JSONB> field, String path, Object value) TheJSONB_INSERT
function.jsonbInsert
(Field<JSONB> field, String path, Field<?> value) TheJSONB_INSERT
function.TheJSONB_INSERT
function.TheJSONB_INSERT
function.TheJSONB_KEYS
function.TheJSONB_KEYS
function.static @NotNull JSONObjectNullStep
<JSONB> The JSON object constructor.static @NotNull JSONObjectNullStep
<JSONB> jsonbObject
(String key, Field<?> value) The JSON object constructor.static @NotNull JSONObjectNullStep
<JSONB> jsonbObject
(Collection<? extends JSONEntry<?>> entries) TheJSONB_OBJECT
function.static @NotNull JSONObjectNullStep
<JSONB> jsonbObject
(Field<?>... entries) Deprecated, for removal: This API element is subject to removal in a future version.- [#15196] - 3.19.0 - The semantics of theField
arguments in this method is inconsistent with that of other overloads, such asjsonbObject(Field, Field)
, which can lead to subtle bugs.static @NotNull JSONObjectNullStep
<JSONB> jsonbObject
(Field<String> key, Field<?> value) The JSON object constructor.static @NotNull JSONObjectNullStep
<JSONB> jsonbObject
(Field<String> key, Select<? extends Record1<?>> value) The JSON object constructor.static @NotNull JSONObjectNullStep
<JSONB> jsonbObject
(JSONEntry<?>... entries) TheJSONB_OBJECT
function.static @NotNull JSONObjectAggNullStep
<JSONB> jsonbObjectAgg
(String key, Field<?> value) The JSONB object aggregate function.static @NotNull JSONObjectAggNullStep
<JSONB> jsonbObjectAgg
(Field<?> field) The JSONB object aggregate function.static @NotNull JSONObjectAggNullStep
<JSONB> jsonbObjectAgg
(Field<String> key, Field<?> value) The JSONB object aggregate function.static @NotNull JSONObjectAggNullStep
<JSONB> jsonbObjectAgg
(JSONEntry<?> entry) The JSONB object aggregate function.jsonbRemove
(Field<JSONB> field, String path) TheJSONB_REMOVE
function.jsonbRemove
(Field<JSONB> field, Field<String> path) TheJSONB_REMOVE
function.jsonbReplace
(Field<JSONB> field, String path, Object value) TheJSONB_REPLACE
function.jsonbReplace
(Field<JSONB> field, String path, Field<?> value) TheJSONB_REPLACE
function.TheJSONB_REPLACE
function.TheJSONB_REPLACE
function.TheJSONB_SET
function.TheJSONB_SET
function.TheJSONB_SET
function.TheJSONB_SET
function.static @NotNull JSONTableColumnsFirstStep
jsonbTable
(Field<JSONB> json, Field<String> path) The JSON table function.static @NotNull JSONTableColumnsFirstStep
jsonbTable
(JSONB json, String path) The JSON table function.static @NotNull JSONValueOnStep
<JSONB> jsonbValue
(Field<JSONB> json, String path) The JSON value extractor function.static @NotNull JSONValueOnStep
<JSONB> jsonbValue
(Field<JSONB> json, Field<String> path) The JSON value extractor function.static <T> @NotNull JSONEntry
<T> A constructor for JSON entries to be used withjsonObject(JSONEntry...)
.static <T> @NotNull JSONEntry
<T> A constructor for JSON entries to be used withjsonObject(JSONEntry...)
.static <T> @NotNull JSONEntry
<T> A constructor for JSON entries to be used withjsonObject(JSONEntry...)
.static <T> @NotNull JSONEntry
<T> A constructor for JSON entries to be used withjsonObject(JSONEntry...)
.static <T> @NotNull JSONEntry
<T> A constructor for JSON entries to be used withjsonObject(JSONEntry...)
.static <T> @NotNull JSONEntry
<T> A constructor for JSON entries to be used withjsonObject(JSONEntry...)
.static <T> @NotNull JSONEntry
<T> A constructor for JSON entries to be used withjsonObject(JSONEntry...)
.static @NotNull JSONExistsOnStep
jsonExists
(Field<JSON> field, String path) The JSON exists predicate.static @NotNull JSONExistsOnStep
jsonExists
(Field<JSON> field, Field<String> path) The JSON exists predicate.jsonGetAttribute
(Field<JSON> field, String attribute) TheJSON_GET_ATTRIBUTE
function.jsonGetAttribute
(Field<JSON> field, Field<String> attribute) TheJSON_GET_ATTRIBUTE
function.jsonGetAttribute
(JSON field, String attribute) TheJSON_GET_ATTRIBUTE
function.jsonGetAttribute
(JSON field, Field<String> attribute) TheJSON_GET_ATTRIBUTE
function.jsonGetAttributeAsText
(Field<JSON> field, String attribute) TheJSON_GET_ATTRIBUTE_AS_TEXT
function.jsonGetAttributeAsText
(Field<JSON> field, Field<String> attribute) TheJSON_GET_ATTRIBUTE_AS_TEXT
function.jsonGetAttributeAsText
(JSON field, String attribute) TheJSON_GET_ATTRIBUTE_AS_TEXT
function.jsonGetAttributeAsText
(JSON field, Field<String> attribute) TheJSON_GET_ATTRIBUTE_AS_TEXT
function.jsonGetElement
(Field<JSON> field, int index) TheJSON_GET_ELEMENT
function.jsonGetElement
(Field<JSON> field, Field<Integer> index) TheJSON_GET_ELEMENT
function.jsonGetElement
(JSON field, int index) TheJSON_GET_ELEMENT
function.jsonGetElement
(JSON field, Field<Integer> index) TheJSON_GET_ELEMENT
function.jsonGetElementAsText
(Field<JSON> field, int index) TheJSON_GET_ELEMENT_AS_TEXT
function.jsonGetElementAsText
(Field<JSON> field, Field<Integer> index) TheJSON_GET_ELEMENT_AS_TEXT
function.jsonGetElementAsText
(JSON field, int index) TheJSON_GET_ELEMENT_AS_TEXT
function.jsonGetElementAsText
(JSON field, Field<Integer> index) TheJSON_GET_ELEMENT_AS_TEXT
function.jsonInsert
(Field<JSON> field, String path, Object value) TheJSON_INSERT
function.jsonInsert
(Field<JSON> field, String path, Field<?> value) TheJSON_INSERT
function.TheJSON_INSERT
function.TheJSON_INSERT
function.TheJSON_KEYS
function.TheJSON_KEYS
function.static @NotNull JSONObjectNullStep
<JSON> The JSON object constructor.static @NotNull JSONObjectNullStep
<JSON> jsonObject
(String key, Field<?> value) The JSON object constructor.static @NotNull JSONObjectNullStep
<JSON> jsonObject
(Collection<? extends JSONEntry<?>> entries) TheJSON_OBJECT
function.static @NotNull JSONObjectNullStep
<JSON> jsonObject
(Field<?>... entries) Deprecated, for removal: This API element is subject to removal in a future version.- [#15196] - 3.19.0 - The semantics of theField
arguments in this method is inconsistent with that of other overloads, such asjsonbObject(Field, Field)
, which can lead to subtle bugs.static @NotNull JSONObjectNullStep
<JSON> jsonObject
(Field<String> key, Field<?> value) The JSON object constructor.static @NotNull JSONObjectNullStep
<JSON> jsonObject
(Field<String> key, Select<? extends Record1<?>> value) The JSON object constructor.static @NotNull JSONObjectNullStep
<JSON> jsonObject
(JSONEntry<?>... entries) TheJSON_OBJECT
function.static @NotNull JSONObjectAggNullStep
<JSON> jsonObjectAgg
(String key, Field<?> value) The JSON object aggregate function.static @NotNull JSONObjectAggNullStep
<JSON> jsonObjectAgg
(Field<?> value) The JSON object aggregate function.static @NotNull JSONObjectAggNullStep
<JSON> jsonObjectAgg
(Field<String> key, Field<?> value) The JSON object aggregate function.static @NotNull JSONObjectAggNullStep
<JSON> jsonObjectAgg
(JSONEntry<?> entry) The JSON object aggregate function.jsonRemove
(Field<JSON> field, String path) TheJSON_REMOVE
function.jsonRemove
(Field<JSON> field, Field<String> path) TheJSON_REMOVE
function.jsonReplace
(Field<JSON> field, String path, Object value) TheJSON_REPLACE
function.jsonReplace
(Field<JSON> field, String path, Field<?> value) TheJSON_REPLACE
function.TheJSON_REPLACE
function.TheJSON_REPLACE
function.TheJSON_SET
function.TheJSON_SET
function.TheJSON_SET
function.TheJSON_SET
function.static @NotNull JSONTableColumnsFirstStep
The JSON table function.static @NotNull JSONTableColumnsFirstStep
The JSON table function.static @NotNull JSONValueOnStep
<JSON> The JSON value extractor function.static @NotNull JSONValueOnStep
<JSON> The JSON value extractor function.static @NotNull JSONEntryValueStep
A constructor for JSON entries to be used withjsonObject(JSONEntry...)
.static @NotNull JSONEntryValueStep
A constructor for JSON entries to be used withjsonObject(JSONEntry...)
.static @NotNull Keyword
Create a SQL keyword.static @NotNull Label
Create a label reference for use in procedural code.static @NotNull Label
Create a label reference for use in procedural code.static <T> @NotNull WindowIgnoreNullsStep
<T> Thelag(field) over ([analytic clause])
function.static <T> @NotNull WindowIgnoreNullsStep
<T> Thelag(field, offset) over ([analytic clause])
function.static <T> @NotNull WindowIgnoreNullsStep
<T> Thelag(field, offset, defaultValue) over ([analytic clause])
function.static <T> @NotNull WindowIgnoreNullsStep
<T> Thelag(field, offset, defaultValue) over ([analytic clause])
function.static <T> @NotNull WindowIgnoreNullsStep
<T> Thelag(field, offset) over ([analytic clause])
function.static <T> @NotNull WindowIgnoreNullsStep
<T> Thelag(field, offset, defaultValue) over ([analytic clause])
function.static <T> @NotNull WindowIgnoreNullsStep
<T> Thelag(field, offset, defaultValue) over ([analytic clause])
function.static <T> @NotNull WindowIgnoreNullsStep
<T> Thelast_value(field) over ([analytic clause])
function.Create aLATERAL
joined table.static <T> @NotNull WindowIgnoreNullsStep
<T> Thelead(field) over ([analytic clause])
function.static <T> @NotNull WindowIgnoreNullsStep
<T> Thelead(field, offset) over ([analytic clause])
function.static <T> @NotNull WindowIgnoreNullsStep
<T> Thelead(field, offset, defaultValue) over ([analytic clause])
function.static <T> @NotNull WindowIgnoreNullsStep
<T> Thelead(field, offset, defaultValue) over ([analytic clause])
function.static <T> @NotNull WindowIgnoreNullsStep
<T> Thelead(field, offset) over ([analytic clause])
function.static <T> @NotNull WindowIgnoreNullsStep
<T> Thelead(field, offset, defaultValue) over ([analytic clause])
function.static <T> @NotNull WindowIgnoreNullsStep
<T> Thelead(field, offset, defaultValue) over ([analytic clause])
function.static <T> @NotNull Field
<T> Find the least among all values.static <T> @NotNull Field
<T> least
(T value, T... values) Find the least among all values.TheLEFT
function.TheLEFT
function.TheLEFT
function.TheLEFT
function.TheLENGTH
function, an alias for theCHAR_LENGTH
function.TheLENGTH
function, an alias for theCHAR_LENGTH
function.level()
TheLEVEL
function.static @NotNull Link
Create a database link reference.static @NotNull Link
Create a database link reference.static @NotNull Link
Create a database link reference.static @NotNull QueryPart
list
(Collection<? extends QueryPart> parts) Compose a list ofQueryParts
into a newQueryPart
, with individual parts being comma-separated.static @NotNull QueryPa