Package org.jooq.impl

Class DSL

  • Direct Known Subclasses:
    AccessDSL, ASEDSL, CUBRIDDSL, DB2DSL, DerbyDSL, FirebirdDSL, H2DSL, HanaDSL, HSQLDBDSL, InformixDSL, IngresDSL, MariaDBDSL, MySQLDSL, OracleDSL, PostgresDSL, RedshiftDSL, SQLiteDSL, SQLServerDSL, SybaseDSL, VerticaDSL

    public class DSL
    extends java.lang.Object
    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:
    DSLContext
    • Constructor Summary

      Constructors 
      Modifier Constructor Description
      protected DSL()
      No instances.
    • Method Summary

      All Methods Static Methods Concrete Methods Deprecated Methods 
      Modifier and Type Method Description
      static <T extends java.lang.Number>
      Field<T>
      abs​(Field<T> field)
      Get the absolute value of a numeric field: abs(field).
      static <T extends java.lang.Number>
      Field<T>
      abs​(T value)
      Get the absolute value of a numeric field: abs(field).
      static Field<java.math.BigDecimal> acos​(java.lang.Number value)
      Get the arc cosine(field) function.
      static Field<java.math.BigDecimal> acos​(Field<? extends java.lang.Number> field)
      Get the arc cosine(field) function.
      static <T> QuantifiedSelect<Record1<T>> all​(Field<T[]> array)
      Create an ALL quantified select to be used in quantified comparison predicate expressions.
      static <T> QuantifiedSelect<Record1<T>> all​(Field<T>... fields)
      Create an ALL quantified select to be used in quantified comparison predicate expressions.
      static <R extends Record>
      QuantifiedSelect<R>
      all​(Select<R> select)
      Create an ALL quantified select to be used in quantified comparison predicate expressions.
      static <T> QuantifiedSelect<Record1<T>> all​(T... array)
      Create an ALL quantified select to be used in quantified comparison predicate expressions.
      static AlterIndexOnStep alterIndex​(java.lang.String index)
      Create a new DSL ALTER INDEX statement.
      static AlterIndexOnStep alterIndex​(Index index)
      Create a new DSL ALTER INDEX statement.
      static AlterIndexOnStep alterIndex​(Name index)
      Create a new DSL ALTER INDEX statement.
      static AlterIndexStep alterIndexIfExists​(java.lang.String index)
      Create a new DSL ALTER INDEX statement.
      static AlterIndexStep alterIndexIfExists​(Index index)
      Create a new DSL ALTER INDEX statement.
      static AlterIndexStep alterIndexIfExists​(Name index)
      Create a new DSL ALTER INDEX statement.
      static AlterSchemaStep alterSchema​(java.lang.String schema)
      Create a new DSL ALTER SCHEMA statement.
      static AlterSchemaStep alterSchema​(Name schema)
      Create a new DSL ALTER SCHEMA statement.
      static AlterSchemaStep alterSchema​(Schema schema)
      Create a new DSL ALTER SCHEMA statement.
      static AlterSchemaStep alterSchemaIfExists​(java.lang.String schema)
      Create a new DSL ALTER SCHEMA statement.
      static AlterSchemaStep alterSchemaIfExists​(Name schema)
      Create a new DSL ALTER SCHEMA statement.
      static AlterSchemaStep alterSchemaIfExists​(Schema schema)
      Create a new DSL ALTER SCHEMA statement.
      static AlterSequenceStep<java.math.BigInteger> alterSequence​(java.lang.String sequence)
      Create a new DSL ALTER SEQUENCE statement.
      static AlterSequenceStep<java.math.BigInteger> alterSequence​(Name sequence)
      Create a new DSL ALTER SEQUENCE statement.
      static <T extends java.lang.Number>
      AlterSequenceStep<T>
      alterSequence​(Sequence<T> sequence)
      Create a new DSL ALTER SEQUENCE statement.
      static AlterSequenceStep<java.math.BigInteger> alterSequenceIfExists​(java.lang.String sequence)
      Create a new DSL ALTER SEQUENCE statement.
      static AlterSequenceStep<java.math.BigInteger> alterSequenceIfExists​(Name sequence)
      Create a new DSL ALTER SEQUENCE statement.
      static <T extends java.lang.Number>
      AlterSequenceStep<T>
      alterSequenceIfExists​(Sequence<T> sequence)
      Create a new DSL ALTER SEQUENCE statement.
      static AlterTableStep alterTable​(java.lang.String table)
      Create a new DSL ALTER TABLE statement.
      static AlterTableStep alterTable​(Name table)
      Create a new DSL ALTER TABLE statement.
      static AlterTableStep alterTable​(Table<?> table)
      Create a new DSL ALTER TABLE statement.
      static AlterTableStep alterTableIfExists​(java.lang.String table)
      Create a new DSL ALTER TABLE statement.
      static AlterTableStep alterTableIfExists​(Name table)
      Create a new DSL ALTER TABLE statement.
      static AlterTableStep alterTableIfExists​(Table<?> table)
      Create a new DSL ALTER TABLE statement.
      static AlterViewStep alterView​(java.lang.String view)
      Create a new DSL ALTER VIEW statement.
      static AlterViewStep alterView​(Name view)
      Create a new DSL ALTER VIEW statement.
      static AlterViewStep alterView​(Table<?> view)
      Create a new DSL ALTER VIEW statement.
      static AlterViewStep alterViewIfExists​(java.lang.String view)
      Create a new DSL ALTER VIEW statement.
      static AlterViewStep alterViewIfExists​(Name view)
      Create a new DSL ALTER VIEW statement.
      static AlterViewStep alterViewIfExists​(Table<?> view)
      Create a new DSL ALTER VIEW statement.
      static Condition and​(java.util.Collection<? extends Condition> conditions)
      Return a Condition that connects all argument conditions with Operator.AND.
      static Condition and​(Condition... conditions)
      Return a Condition that connects all argument conditions with Operator.AND.
      static Condition and​(Condition left, Condition right)
      Return a Condition that connects all argument conditions with Operator.AND.
      static <T> QuantifiedSelect<Record1<T>> any​(Field<T[]> array)
      Create an ANY quantified select to be used in quantified comparison predicate expressions.
      static <T> QuantifiedSelect<Record1<T>> any​(Field<T>... fields)
      Create an ANY quantified select to be used in quantified comparison predicate expressions.
      static <R extends Record>
      QuantifiedSelect<R>
      any​(Select<R> select)
      Create an ANY quantified select to be used in quantified comparison predicate expressions.
      static <T> QuantifiedSelect<Record1<T>> any​(T... array)
      Create an ANY quantified select to be used in quantified comparison predicate expressions.
      static <T> Field<T[]> array​(java.util.Collection<? extends Field<T>> fields)
      Create an array literal.
      static <T> Field<T[]> array​(Field<T>... fields)
      Create an array literal.
      static <T> Field<T[]> array​(T... values)
      Create an array literal.
      static <T> ArrayAggOrderByStep<T[]> arrayAgg​(Field<T> field)
      Get the array_agg() aggregate function.
      static <T> ArrayAggOrderByStep<T[]> arrayAggDistinct​(Field<T> field)
      Get the array_agg() aggregate function.
      static Field<java.lang.Integer> ascii​(java.lang.String field)
      Get the ascii(field) function.
      static Field<java.lang.Integer> ascii​(Field<java.lang.String> field)
      Get the ascii(field) function.
      static Field<java.math.BigDecimal> asin​(java.lang.Number value)
      Get the arc sine(field) function.
      static Field<java.math.BigDecimal> asin​(Field<? extends java.lang.Number> field)
      Get the arc sine(field) function.
      static Asterisk asterisk()
      The asterisk (*) to be used in SELECT clauses.
      static Field<java.math.BigDecimal> atan​(java.lang.Number value)
      Get the arc tangent(field) function.
      static Field<java.math.BigDecimal> atan​(Field<? extends java.lang.Number> field)
      Get the arc tangent(field) function.
      static Field<java.math.BigDecimal> atan2​(java.lang.Number x, java.lang.Number y)
      Get the atan2(field, y) function.
      static Field<java.math.BigDecimal> atan2​(java.lang.Number x, Field<? extends java.lang.Number> y)
      Get the atan2(field, y) function.
      static Field<java.math.BigDecimal> atan2​(Field<? extends java.lang.Number> x, java.lang.Number y)
      Get the atan2(field, y) function.
      static Field<java.math.BigDecimal> atan2​(Field<? extends java.lang.Number> x, Field<? extends java.lang.Number> y)
      Get the atan2(field, y) function.
      static AggregateFunction<java.math.BigDecimal> avg​(Field<? extends java.lang.Number> field)
      Get the average over a numeric field: avg(field).
      static AggregateFunction<java.math.BigDecimal> avgDistinct​(Field<? extends java.lang.Number> field)
      Get the average over a numeric field: avg(distinct field).
      static Block begin​(java.util.Collection<? extends Statement> statements)
      Wrap a collection of statements in an anonymous procedural block.
      static Block begin​(Statement... statements)
      Wrap a collection of statements in an anonymous procedural block.
      static <T extends java.lang.Number>
      Field<T>
      bitAnd​(Field<T> field1, Field<T> field2)
      The bitwise and operator.
      static <T extends java.lang.Number>
      Field<T>
      bitAnd​(Field<T> value1, T value2)
      The bitwise and operator.
      static <T extends java.lang.Number>
      Field<T>
      bitAnd​(T value1, Field<T> value2)
      The bitwise and operator.
      static <T extends java.lang.Number>
      Field<T>
      bitAnd​(T value1, T value2)
      The bitwise and operator.
      static Field<java.lang.Integer> bitCount​(java.lang.Number value)
      The MySQL BIT_COUNT(field) function, counting the number of bits that are set in this number.
      static Field<java.lang.Integer> bitCount​(Field<? extends java.lang.Number> field)
      The MySQL BIT_COUNT(field) function, counting the number of bits that are set in this number.
      static Field<java.lang.Integer> bitLength​(java.lang.String value)
      Get the bit_length(field) function.
      static Field<java.lang.Integer> bitLength​(Field<java.lang.String> field)
      Get the bit_length(field) function.
      static <T extends java.lang.Number>
      Field<T>
      bitNand​(Field<T> field1, Field<T> field2)
      The bitwise not and operator.
      static <T extends java.lang.Number>
      Field<T>
      bitNand​(Field<T> value1, T value2)
      The bitwise not and operator.
      static <T extends java.lang.Number>
      Field<T>
      bitNand​(T value1, Field<T> value2)
      The bitwise not and operator.
      static <T extends java.lang.Number>
      Field<T>
      bitNand​(T value1, T value2)
      The bitwise not and operator.
      static <T extends java.lang.Number>
      Field<T>
      bitNor​(Field<T> field1, Field<T> field2)
      The bitwise not or operator.
      static <T extends java.lang.Number>
      Field<T>
      bitNor​(Field<T> value1, T value2)
      The bitwise not or operator.
      static <T extends java.lang.Number>
      Field<T>
      bitNor​(T value1, Field<T> value2)
      The bitwise not or operator.
      static <T extends java.lang.Number>
      Field<T>
      bitNor​(T value1, T value2)
      The bitwise not or operator.
      static <T extends java.lang.Number>
      Field<T>
      bitNot​(Field<T> field)
      The bitwise not operator.
      static <T extends java.lang.Number>
      Field<T>
      bitNot​(T value)
      The bitwise not operator.
      static <T extends java.lang.Number>
      Field<T>
      bitOr​(Field<T> field1, Field<T> field2)
      The bitwise or operator.
      static <T extends java.lang.Number>
      Field<T>
      bitOr​(Field<T> value1, T value2)
      The bitwise or operator.
      static <T extends java.lang.Number>
      Field<T>
      bitOr​(T value1, Field<T> value2)
      The bitwise or operator.
      static <T extends java.lang.Number>
      Field<T>
      bitOr​(T value1, T value2)
      The bitwise or operator.
      static <T extends java.lang.Number>
      Field<T>
      bitXNor​(Field<T> field1, Field<T> field2)
      The bitwise not xor operator.
      static <T extends java.lang.Number>
      Field<T>
      bitXNor​(Field<T> value1, T value2)
      The bitwise not xor operator.
      static <T extends java.lang.Number>
      Field<T>
      bitXNor​(T value1, Field<T> value2)
      The bitwise not xor operator.
      static <T extends java.lang.Number>
      Field<T>
      bitXNor​(T value1, T value2)
      The bitwise not xor operator.
      static <T extends java.lang.Number>
      Field<T>
      bitXor​(Field<T> field1, Field<T> field2)
      The bitwise xor operator.
      static <T extends java.lang.Number>
      Field<T>
      bitXor​(Field<T> value1, T value2)
      The bitwise xor operator.
      static <T extends java.lang.Number>
      Field<T>
      bitXor​(T value1, Field<T> value2)
      The bitwise xor operator.
      static <T extends java.lang.Number>
      Field<T>
      bitXor​(T value1, T value2)
      The bitwise xor operator.
      static AggregateFunction<java.lang.Boolean> boolAnd​(Condition condition)
      Get the every value over a condition: bool_and(condition).
      static AggregateFunction<java.lang.Boolean> boolAnd​(Field<java.lang.Boolean> field)
      Get the every value over a field: bool_and(field).
      static AggregateFunction<java.lang.Boolean> boolOr​(Condition condition)
      Get the every value over a condition: bool_and(condition).
      static AggregateFunction<java.lang.Boolean> boolOr​(Field<java.lang.Boolean> field)
      Get the every value over a field: bool_and(field).
      static Case case_()
      Initialise a Case statement.
      static <V> CaseValueStep<V> case_​(Field<V> value)
      Initialise a Case statement.
      static <V> CaseValueStep<V> case_​(V value)
      Initialise a Case statement.
      static <T> Field<T> cast​(java.lang.Object value, java.lang.Class<T> type)
      Cast a value to another type.
      static <T> Field<T> cast​(java.lang.Object value, DataType<T> type)
      Cast a value to another type.
      static <T> Field<T> cast​(java.lang.Object value, Field<T> as)
      Cast a value to the type of another field.
      static <T> Field<T> cast​(Field<?> field, java.lang.Class<T> type)
      Cast a field to another type.
      static <T> Field<T> cast​(Field<?> field, DataType<T> type)
      Cast a field to another type.
      static <T> Field<T> cast​(Field<?> field, Field<T> as)
      Cast a field to the type of another field.
      static <T> Field<T> castNull​(java.lang.Class<T> type)
      Cast null to a type.
      static <T> Field<T> castNull​(DataType<T> type)
      Cast null to a type.
      static <T> Field<T> castNull​(Field<T> as)
      Cast null to the type of another field.
      static Catalog catalog​(Name name)
      Create a qualified catalog, given its catalog name.
      static <T extends java.lang.Number>
      Field<T>
      ceil​(Field<T> field)
      Get the smallest integer value not less than [field].
      static <T extends java.lang.Number>
      Field<T>
      ceil​(T value)
      Get the smallest integer value not less than [this].
      static Field<java.lang.Integer> century​(java.time.temporal.Temporal value)
      Get the century of a date.
      static Field<java.lang.Integer> century​(java.util.Date value)
      Get the century of a date.
      static Field<java.lang.Integer> century​(Field<?> field)
      Get the century of a date.
      static CharacterSet characterSet​(java.lang.String characterSet)
      Create a character set by its unqualified name.
      static CharacterSet characterSet​(Name characterSet)
      Create a character set by its qualified name.
      static Field<java.lang.Integer> charLength​(java.lang.String value)
      Get the char_length(field) function.
      static Field<java.lang.Integer> charLength​(Field<java.lang.String> field)
      Get the char_length(field) function.
      static ConstraintFinalStep check​(Condition condition)
      Create an unnamed (system named) CHECK constraint.
      static Case choose()
      Initialise a Case statement.
      static <T> Field<T> choose​(int index, Field<T>... values)
      The T-SQL CHOOSE() function.
      static <T> Field<T> choose​(int index, T... values)
      The T-SQL CHOOSE() function.
      static <T> Field<T> choose​(Field<java.lang.Integer> index, Field<T>... values)
      The T-SQL CHOOSE() function.
      static <T> Field<T> choose​(Field<java.lang.Integer> index, T... values)
      The T-SQL CHOOSE() function.
      static <V> CaseValueStep<V> choose​(Field<V> value)
      Initialise a Case statement.
      static <V> CaseValueStep<V> choose​(V value)
      Initialise a Case statement.
      static <T> Field<T> coalesce​(Field<T> field, Field<?>... fields)
      The COALESCE(field1, field2, ... , field n) function.
      static <T> Field<T> coalesce​(Field<T> field, T value)
      The COALESCE(field, value) function.
      static <T> Field<T> coalesce​(T value, T... values)
      The COALESCE(value1, value2, ... , value n) function.
      static <T> Field<T> coerce​(java.lang.Object value, java.lang.Class<T> as)
      Coerce this field to another type.
      static <T> Field<T> coerce​(java.lang.Object value, DataType<T> as)
      Coerce a field to another type.
      static <T> Field<T> coerce​(java.lang.Object value, Field<T> as)
      Coerce this field to the type of another field.
      static <T> Field<T> coerce​(Field<?> field, java.lang.Class<T> as)
      Coerce this field to another type.
      static <T> Field<T> coerce​(Field<?> field, DataType<T> as)
      Coerce a field to another type.
      static <T> Field<T> coerce​(Field<?> field, Field<T> as)
      Coerce this field to the type of another field.
      static Collation collation​(java.lang.String collation)
      Create a collation by its unqualified name.
      static Collation collation​(Name collation)
      Create a collation by its qualified name.
      static <T,​A extends ArrayRecord<T>>
      ArrayAggOrderByStep<A>
      collect​(Field<T> field, java.lang.Class<A> type)
      Get the collect() aggregate function.
      static <T,​A extends ArrayRecord<T>>
      ArrayAggOrderByStep<A>
      collect​(Field<T> field, DataType<A> type)
      Get the collect() aggregate function.
      static <T,​A extends ArrayRecord<T>>
      ArrayAggOrderByStep<A>
      collectDistinct​(Field<T> field, java.lang.Class<A> type)
      Get the collect() aggregate function.
      static <T,​A extends ArrayRecord<T>>
      ArrayAggOrderByStep<A>
      collectDistinct​(Field<T> field, DataType<A> type)
      Get the collect() aggregate function.
      static Comment comment​(java.lang.String comment)
      Create a comment.
      static CommentOnIsStep commentOnColumn​(Field<?> field)
      Create a new DSL COMMENT ON COLUMN statement.
      static CommentOnIsStep commentOnColumn​(Name columnName)
      Create a new DSL COMMENT ON COLUMN statement.
      static CommentOnIsStep commentOnTable​(java.lang.String tableName)
      Create a new DSL COMMENT ON TABLE statement.
      static CommentOnIsStep commentOnTable​(Name tableName)
      Create a new DSL COMMENT ON TABLE statement.
      static CommentOnIsStep commentOnTable​(Table<?> table)
      Create a new DSL COMMENT ON TABLE statement.
      static CommentOnIsStep commentOnView​(java.lang.String viewName)
      Create a new DSL COMMENT ON VIEW statement.
      static CommentOnIsStep commentOnView​(Name viewName)
      Create a new DSL COMMENT ON VIEW statement.
      static CommentOnIsStep commentOnView​(Table<?> view)
      Create a new DSL COMMENT ON VIEW statement.
      static Field<java.lang.String> concat​(java.lang.String... values)
      Get the concat(value[, value, ...]) function.
      static Field<java.lang.String> concat​(java.lang.String value, Field<java.lang.String> field)
      Get the concat(value, field) function.
      static Field<java.lang.String> concat​(Field<?>... fields)
      Get the concat(field[, field, ...]) function.
      static Field<java.lang.String> concat​(Field<java.lang.String> field, java.lang.String value)
      Get the concat(field, value) function.
      static Condition condition​(java.lang.Boolean value)
      Create a condition from a boolean field.
      static Condition condition​(java.lang.String sql)
      Create a new condition holding plain SQL.
      static Condition condition​(java.lang.String sql, java.lang.Object... bindings)
      Create a new condition holding plain SQL.
      static Condition condition​(java.lang.String sql, QueryPart... parts)
      A custom SQL clause that can render arbitrary SQL elements.
      static Condition condition​(java.util.Map<Field<?>,​?> map)
      Create a condition from a map.
      static Condition condition​(Field<java.lang.Boolean> field)
      Create a condition from a boolean field.
      static Condition condition​(Operator operator, java.util.Collection<? extends Condition> conditions)
      Return a Condition that connects all argument conditions with Operator.
      static Condition condition​(Operator operator, Condition... conditions)
      Return a Condition that connects all argument conditions with Operator.
      static Condition condition​(Operator operator, Condition left, Condition right)
      Return a Condition that connects all argument conditions with Operator.
      static Condition condition​(Record record)
      Create a "Query By Example" (QBE) Condition from a Record .
      static Condition condition​(SQL sql)
      Create a new condition holding plain SQL.
      static Field<java.lang.Boolean> connectByIsCycle()
      Retrieve the Oracle-specific CONNECT_BY_ISCYCLE pseudo-field (to be used along with CONNECT BY clauses).
      static Field<java.lang.Boolean> connectByIsLeaf()
      Retrieve the Oracle-specific CONNECT_BY_ISLEAF pseudo-field (to be used along with CONNECT BY clauses).
      static <T> Field<T> connectByRoot​(Field<T> field)
      Retrieve the Oracle-specific CONNECT_BY_ROOT pseudo-column (to be used along with CONNECT BY clauses).
      static ConstraintTypeStep constraint()
      Create an unnamed (system named) CONSTRAINT specification.
      static ConstraintTypeStep constraint​(java.lang.String name)
      Create a CONSTRAINT specification.
      static ConstraintTypeStep constraint​(Name name)
      Create a CONSTRAINT specification.
      static ContinueWhenStep continue_()
      Create an CONTINUE statement for use in procedural code.
      static ContinueWhenStep continue_​(Label label)
      Create an CONTINUE statement for use in procedural code.
      static Statement continueWhen​(Condition condition)
      Create an CONTINUE statement for use in procedural code.
      static <T> Field<T> convert​(DataType<T> type, java.lang.Object value, int style)
      Convert a date time value to a string value using the SQL Server style CONVERT() function.
      static <T> Field<T> convert​(DataType<T> type, Field<?> value, int style)
      Convert a date time value to a string value using the SQL Server style CONVERT() function.
      static Field<java.math.BigDecimal> cos​(java.lang.Number value)
      Get the cosine(field) function.
      static Field<java.math.BigDecimal> cos​(Field<? extends java.lang.Number> field)
      Get the cosine(field) function.
      static Field<java.math.BigDecimal> cosh​(java.lang.Number value)
      Get the hyperbolic cosine function: cosh(field).
      static Field<java.math.BigDecimal> cosh​(Field<? extends java.lang.Number> field)
      Get the hyperbolic cosine function: cosh(field).
      static Field<java.math.BigDecimal> cot​(java.lang.Number value)
      Get the cotangent(field) function.
      static Field<java.math.BigDecimal> cot​(Field<? extends java.lang.Number> field)
      Get the cotangent(field) function.
      static Field<java.math.BigDecimal> coth​(java.lang.Number value)
      Get the hyperbolic cotangent function: coth(field).
      static Field<java.math.BigDecimal> coth​(Field<? extends java.lang.Number> field)
      Get the hyperbolic cotangent function: coth(field).
      static AggregateFunction<java.lang.Integer> count()
      Get the count(*) function.
      static AggregateFunction<java.lang.Integer> count​(Field<?> field)
      Get the count(field) function.
      static AggregateFunction<java.lang.Integer> count​(SelectFieldOrAsterisk field)
      Get the count(field) function.
      static AggregateFunction<java.lang.Integer> count​(Table<?> table)
      Get the count(table) function.
      static AggregateFunction<java.lang.Integer> countDistinct​(Field<?> field)
      Get the count(distinct field) function.
      static AggregateFunction<java.lang.Integer> countDistinct​(Field<?>... fields)
      Get the count(distinct field1, field2) function.
      static AggregateFunction<java.lang.Integer> countDistinct​(SelectFieldOrAsterisk field)
      Get the count(distinct field) function.
      static AggregateFunction<java.lang.Integer> countDistinct​(Table<?> table)
      Get the count(distinct table) function.
      static CreateTableColumnStep createGlobalTemporaryTable​(java.lang.String table)
      Create a new DSL CREATE GLOBAL TEMPORARY TABLE statement.
      static CreateTableColumnStep createGlobalTemporaryTable​(Name table)
      Create a new DSL CREATE GLOBAL TEMPORARY TABLE statement.
      static CreateTableColumnStep createGlobalTemporaryTable​(Table<?> table)
      Create a new DSL CREATE GLOBAL TEMPORARY TABLE statement.
      static CreateIndexStep createIndex()
      Create a new DSL CREATE INDEX statement.
      static CreateIndexStep createIndex​(java.lang.String index)
      Create a new DSL CREATE INDEX statement.
      static CreateIndexStep createIndex​(Index index)
      Create a new DSL CREATE INDEX statement.
      static CreateIndexStep createIndex​(Name index)
      Create a new DSL CREATE INDEX statement.
      static CreateIndexStep createIndexIfNotExists​(java.lang.String index)
      Create a new DSL CREATE INDEX IF NOT EXISTS statement.
      static CreateIndexStep createIndexIfNotExists​(Index index)
      Create a new DSL CREATE INDEX IF NOT EXISTS statement.
      static CreateIndexStep createIndexIfNotExists​(Name index)
      Create a new DSL CREATE INDEX IF NOT EXISTS statement.
      static CreateViewAsStep createOrReplaceView​(java.lang.String view, java.lang.String... fields)
      Create a new DSL CREATE OR REPLACE VIEW statement.
      static CreateViewAsStep createOrReplaceView​(java.lang.String view, java.util.function.Function<? super Field<?>,​? extends java.lang.String> fieldNameFunction)
      Create a new DSL CREATE OR REPLACE VIEW statement.
      static CreateViewAsStep createOrReplaceView​(Name view, java.util.function.Function<? super Field<?>,​? extends Name> fieldNameFunction)
      Create a new DSL CREATE OR REPLACE VIEW statement.
      static CreateViewAsStep createOrReplaceView​(Name view, Name... fields)
      Create a new DSL CREATE OR REPLACE VIEW statement.
      static CreateViewAsStep createOrReplaceView​(Table<?> view, java.util.function.Function<? super Field<?>,​? extends Field<?>> fieldNameFunction)
      Create a new DSL CREATE OR REPLACE VIEW statement.
      static CreateViewAsStep createOrReplaceView​(Table<?> view, Field<?>... fields)
      Create a new DSL CREATE OR REPLACE VIEW statement.
      static CreateSchemaFinalStep createSchema​(java.lang.String schema)
      Create a new DSL CREATE SCHEMA statement.
      static CreateSchemaFinalStep createSchema​(Name schema)
      Create a new DSL CREATE SCHEMA statement.
      static CreateSchemaFinalStep createSchema​(Schema schema)
      Create a new DSL CREATE SCHEMA statement.
      static CreateSchemaFinalStep createSchemaIfNotExists​(java.lang.String schema)
      Create a new DSL CREATE SCHEMA statement.
      static CreateSchemaFinalStep createSchemaIfNotExists​(Name table)
      Create a new DSL CREATE SCHEMA statement.
      static CreateSchemaFinalStep createSchemaIfNotExists​(Schema schema)
      Create a new DSL CREATE SCHEMA statement.
      static CreateSequenceFlagsStep createSequence​(java.lang.String sequence)
      Create a new DSL CREATE SEQUENCE statement.
      static CreateSequenceFlagsStep createSequence​(Name sequence)
      Create a new DSL CREATE SEQUENCE statement.
      static CreateSequenceFlagsStep createSequence​(Sequence<?> sequence)
      Create a new DSL CREATE SEQUENCE statement.
      static CreateSequenceFlagsStep createSequenceIfNotExists​(java.lang.String sequence)
      Create a new DSL CREATE SEQUENCE IF NOT EXISTS statement.
      static CreateSequenceFlagsStep createSequenceIfNotExists​(Name sequence)
      Create a new DSL CREATE SEQUENCE IF NOT EXISTS statement.
      static CreateSequenceFlagsStep createSequenceIfNotExists​(Sequence<?> sequence)
      Create a new DSL CREATE SEQUENCE IF NOT EXISTS statement.
      static CreateTableColumnStep createTable​(java.lang.String table)
      Create a new DSL CREATE TABLE statement.
      static CreateTableColumnStep createTable​(Name table)
      Create a new DSL CREATE TABLE statement.
      static CreateTableColumnStep createTable​(Table<?> table)
      Create a new DSL CREATE TABLE statement.
      static CreateTableColumnStep createTableIfNotExists​(java.lang.String table)
      Create a new DSL CREATE TABLE statement.
      static CreateTableColumnStep createTableIfNotExists​(Name table)
      Create a new DSL CREATE TABLE statement.
      static CreateTableColumnStep createTableIfNotExists​(Table<?> table)
      Create a new DSL CREATE TABLE statement.
      static CreateTableColumnStep createTemporaryTable​(java.lang.String table)
      Create a new DSL CREATE GLOBAL TEMPORARY TABLE statement.
      static CreateTableColumnStep createTemporaryTable​(Name table)
      Create a new DSL CREATE GLOBAL TEMPORARY TABLE statement.
      static CreateTableColumnStep createTemporaryTable​(Table<?> table)
      Create a new DSL CREATE GLOBAL TEMPORARY TABLE statement.
      static CreateTypeStep createType​(java.lang.String type)
      Create a new DSL CREATE TYPE statement.
      static CreateTypeStep createType​(Name type)
      Create a new DSL CREATE TYPE statement.
      static CreateIndexStep createUniqueIndex()
      Create a new DSL CREATE UNIQUE INDEX statement.
      static CreateIndexStep createUniqueIndex​(java.lang.String index)
      Create a new DSL CREATE UNIQUE INDEX statement.
      static CreateIndexStep createUniqueIndex​(Index index)
      Create a new DSL CREATE UNIQUE INDEX statement.
      static CreateIndexStep createUniqueIndex​(Name index)
      Create a new DSL CREATE UNIQUE INDEX statement.
      static CreateIndexStep createUniqueIndexIfNotExists​(java.lang.String index)
      Create a new DSL CREATE UNIQUE INDEX IF NOT EXISTS statement.
      static CreateIndexStep createUniqueIndexIfNotExists​(Index index)
      Create a new DSL CREATE UNIQUE INDEX IF NOT EXISTS statement.
      static CreateIndexStep createUniqueIndexIfNotExists​(Name index)
      Create a new DSL CREATE UNIQUE INDEX IF NOT EXISTS statement.
      static CreateViewAsStep createView​(java.lang.String view, java.lang.String... fields)
      Create a new DSL CREATE VIEW statement.
      static CreateViewAsStep createView​(java.lang.String view, java.util.function.Function<? super Field<?>,​? extends java.lang.String> fieldNameFunction)
      Create a new DSL CREATE VIEW statement.
      static CreateViewAsStep createView​(Name view, java.util.function.Function<? super Field<?>,​? extends Name> fieldNameFunction)
      Create a new DSL CREATE VIEW statement.
      static CreateViewAsStep createView​(Name view, Name... fields)
      Create a new DSL CREATE VIEW statement.
      static CreateViewAsStep createView​(Table<?> view, java.util.function.Function<? super Field<?>,​? extends Field<?>> fieldNameFunction)
      Create a new DSL CREATE VIEW statement.
      static CreateViewAsStep createView​(Table<?> view, Field<?>... fields)
      Create a new DSL CREATE VIEW statement.
      static CreateViewAsStep createViewIfNotExists​(java.lang.String view, java.lang.String... fields)
      Create a new DSL CREATE VIEW IF NOT EXISTS statement.
      static CreateViewAsStep createViewIfNotExists​(java.lang.String view, java.util.function.Function<? super Field<?>,​? extends java.lang.String> fieldNameFunction)
      Create a new DSL CREATE VIEW IF NOT EXISTS statement.
      static CreateViewAsStep createViewIfNotExists​(Name view, java.util.function.Function<? super Field<?>,​? extends Name> fieldNameFunction)
      Create a new DSL CREATE VIEW IF NOT EXISTS statement.
      static CreateViewAsStep createViewIfNotExists​(Name view, Name... fields)
      Create a new DSL CREATE VIEW IF NOT EXISTS statement.
      static CreateViewAsStep createViewIfNotExists​(Table<?> view, java.util.function.Function<? super Field<?>,​? extends Field<?>> fieldNameFunction)
      Create a new DSL CREATE VIEW IF NOT EXISTS statement.
      static CreateViewAsStep createViewIfNotExists​(Table<?> view, Field<?>... fields)
      Create a new DSL CREATE VIEW IF NOT EXISTS statement.
      static GroupField cube​(Field<?>... fields)
      Create a CUBE(field1, field2, .., fieldn) grouping field.
      static GroupField cube​(FieldOrRow... fields)
      Create a CUBE(field1, field2, .., fieldn) grouping field.
      static WindowOverStep<java.math.BigDecimal> cumeDist()
      The cume_dist() over ([analytic clause]) function.
      static OrderedAggregateFunction<java.math.BigDecimal> cumeDist​(java.util.Collection<? extends Field<?>> fields)
      The cume_dist(expr) within group (order by [order clause]) ordered-set aggregate function.
      static OrderedAggregateFunction<java.math.BigDecimal> cumeDist​(Field<?>... fields)
      The cume_dist(expr) within group (order by [order clause]) ordered-set aggregate function.
      static Field<java.sql.Date> currentDate()
      Get the current_date() function returning a SQL standard SQLDataType.DATE type.
      static Field<java.time.Instant> currentInstant()
      Get the current_timestamp() function.
      static Field<java.time.LocalDate> currentLocalDate()
      Get the current_date() function returning a SQL standard SQLDataType.DATE type.
      static Field<java.time.LocalDateTime> currentLocalDateTime()
      Get the current_timestamp() function returning a SQL standard SQLDataType.TIMESTAMP type.
      static Field<java.time.LocalTime> currentLocalTime()
      Get the current_time() function returning a SQL standard SQLDataType.TIME type.
      static Field<java.time.OffsetDateTime> currentOffsetDateTime()
      Get the current_timestamp() function.
      static Field<java.time.OffsetTime> currentOffsetTime()
      Get the current_time() function.
      static Field<java.lang.String> currentSchema()
      Get the current_schema() function.
      static Field<java.sql.Time> currentTime()
      Get the current_time() function returning a SQL standard SQLDataType.TIME type.
      static Field<java.sql.Timestamp> currentTimestamp()
      Get the current_timestamp() function returning a SQL standard SQLDataType.TIMESTAMP type.
      static Field<java.sql.Timestamp> currentTimestamp​(Field<java.lang.Integer> precision)
      Get the current_timestamp() function returning a SQL standard SQLDataType.TIMESTAMP type with the specified fractional seconds precision.
      static Field<java.lang.String> currentUser()
      Get the current_user() function.
      static Field<java.sql.Date> date​(java.lang.String value)
      Convert a string value to a DATE.
      static Field<java.sql.Date> date​(java.util.Date value)
      Convert a temporal value to a DATE.
      static Field<java.sql.Date> date​(Field<? extends java.util.Date> field)
      Convert a temporal value to a DATE.
      static Field<java.sql.Date> dateAdd​(java.sql.Date date, java.lang.Number interval)
      Add an interval to a date.
      static Field<java.sql.Date> dateAdd​(java.sql.Date date, java.lang.Number interval, DatePart datePart)
      Add an interval to a date, given a date part.
      static Field<java.sql.Date> dateAdd​(java.sql.Date date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Add an interval to a date, given a date part.
      static Field<java.sql.Date> dateAdd​(Field<java.sql.Date> date, java.lang.Number interval, DatePart datePart)
      Add an interval to a date, given a date part.
      static Field<java.sql.Date> dateAdd​(Field<java.sql.Date> date, Field<? extends java.lang.Number> interval)
      Add an interval to a date.
      static Field<java.sql.Date> dateAdd​(Field<java.sql.Date> date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Add an interval to a date, given a date part.
      static Field<java.lang.Integer> dateDiff​(java.sql.Date date1, java.sql.Date date2)
      Get the date difference in number of days.
      static Field<java.lang.Integer> dateDiff​(java.sql.Date date1, Field<java.sql.Date> date2)
      Get the date difference in number of days.
      static Field<java.lang.Integer> dateDiff​(Field<java.sql.Date> date1, java.sql.Date date2)
      Get the date difference in number of days.
      static Field<java.lang.Integer> dateDiff​(Field<java.sql.Date> date1, Field<java.sql.Date> date2)
      Get the date difference in number of days.
      static Field<java.sql.Date> dateSub​(java.sql.Date date, java.lang.Number interval)
      Subtract an interval from a date.
      static Field<java.sql.Date> dateSub​(java.sql.Date date, java.lang.Number interval, DatePart datePart)
      Subtract an interval from a date, given a date part.
      static Field<java.sql.Date> dateSub​(java.sql.Date date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Subtract an interval from a date, given a date part.
      static Field<java.sql.Date> dateSub​(Field<java.sql.Date> date, java.lang.Number interval, DatePart datePart)
      Subtract an interval from a date, given a date part.
      static Field<java.sql.Date> dateSub​(Field<java.sql.Date> date, Field<? extends java.lang.Number> interval)
      Subtract an interval from a date.
      static Field<java.sql.Date> dateSub​(Field<java.sql.Date> date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Subtract an interval from a date, given a date part.
      static Field<java.lang.Integer> day​(java.time.temporal.Temporal value)
      Get the day part of a date.
      static Field<java.lang.Integer> day​(java.util.Date value)
      Get the day part of a date.
      static Field<java.lang.Integer> day​(Field<?> field)
      Get the day part of a date.
      static Field<java.lang.Integer> dayOfWeek​(java.time.temporal.Temporal value)
      Get the day of week part of a date.
      static Field<java.lang.Integer> dayOfWeek​(java.util.Date value)
      Get the day of week part of a date.
      static Field<java.lang.Integer> dayOfWeek​(Field<?> field)
      Get the day of week part of a date.
      static Field<java.lang.Integer> dayOfYear​(java.time.temporal.Temporal value)
      Get the day of week part of a date.
      static Field<java.lang.Integer> dayOfYear​(java.util.Date value)
      Get the day of week part of a date.
      static Field<java.lang.Integer> dayOfYear​(Field<?> field)
      Get the day of week part of a date.
      static Field<java.lang.Integer> decade​(java.time.temporal.Temporal value)
      Get the decade of a date.
      static Field<java.lang.Integer> decade​(java.util.Date value)
      Get the decade of a date.
      static Field<java.lang.Integer> decade​(Field<?> field)
      Get the decade of a date.
      static <T> Declaration<T> declare​(Variable<T> variable)
      Create a local variable declaration for use in procedural code.
      static Case decode()
      Initialise a Case statement.
      static <Z,​T>
      Field<Z>
      decode​(Field<T> value, Field<T> search, Field<Z> result)
      Gets the Oracle-style DECODE(expression, search, result[, search , result]... [, default]) function.
      static <Z,​T>
      Field<Z>
      decode​(Field<T> value, Field<T> search, Field<Z> result, Field<?>... more)
      Gets the Oracle-style DECODE(expression, search, result[, search , result]... [, default]) function.
      static <Z,​T>
      Field<Z>
      decode​(T value, T search, Z result)
      Gets the Oracle-style DECODE(expression, search, result[, search , result]... [, default]) function.
      static <Z,​T>
      Field<Z>
      decode​(T value, T search, Z result, java.lang.Object... more)
      Gets the Oracle-style DECODE(expression, search, result[, search , result]... [, default]) function.
      static Field<java.lang.Object> default_()
      Create a DEFAULT keyword for use with INSERT, UPDATE, or MERGE statements.
      static <T> Field<T> default_​(java.lang.Class<T> type)
      Create a DEFAULT keyword for use with INSERT, UPDATE, or MERGE statements.
      static <T> Field<T> default_​(DataType<T> type)
      Create a DEFAULT keyword for use with INSERT, UPDATE, or MERGE statements.
      static <T> Field<T> default_​(Field<T> field)
      Create a DEFAULT keyword for use with INSERT, UPDATE, or MERGE statements.
      static Field<java.lang.Object> defaultValue()
      Create a DEFAULT keyword for use with INSERT, UPDATE, or MERGE statements.
      static <T> Field<T> defaultValue​(java.lang.Class<T> type)
      Create a DEFAULT keyword for use with INSERT, UPDATE, or MERGE statements.
      static <T> Field<T> defaultValue​(DataType<T> type)
      Create a DEFAULT keyword for use with INSERT, UPDATE, or MERGE statements.
      static <T> Field<T> defaultValue​(Field<T> field)
      Create a DEFAULT keyword for use with INSERT, UPDATE, or MERGE statements.
      static Field<java.math.BigDecimal> deg​(java.lang.Number value)
      Calculate degrees from radians from this field.
      static Field<java.math.BigDecimal> deg​(Field<? extends java.lang.Number> field)
      Calculate degrees from radians from this field.
      static <R extends Record>
      DeleteWhereStep<R>
      delete​(Table<R> table)
      Create a new DSL delete statement.
      static <R extends Record>
      DeleteWhereStep<R>
      deleteFrom​(Table<R> table)
      Create a new DSL delete statement.
      static WindowOverStep<java.lang.Integer> denseRank()
      The dense_rank() over ([analytic clause]) function.
      static OrderedAggregateFunction<java.lang.Integer> denseRank​(java.util.Collection<? extends Field<?>> fields)
      The dense_rank(expr) within group (order by [order clause]) ordered-set aggregate function.
      static OrderedAggregateFunction<java.lang.Integer> denseRank​(Field<?>... fields)
      The dense_rank(expr) within group (order by [order clause]) ordered-set aggregate function.
      static DropIndexOnStep dropIndex​(java.lang.String index)
      Create a new DSL DROP INDEX statement.
      static DropIndexOnStep dropIndex​(Index index)
      Create a new DSL DROP INDEX statement.
      static DropIndexOnStep dropIndex​(Name index)
      Create a new DSL DROP INDEX statement.
      static DropIndexOnStep dropIndexIfExists​(java.lang.String index)
      Create a new DSL DROP INDEX IF EXISTS statement.
      static DropIndexOnStep dropIndexIfExists​(Index index)
      Create a new DSL DROP INDEX IF EXISTS statement.
      static DropIndexOnStep dropIndexIfExists​(Name index)
      Create a new DSL DROP INDEX IF EXISTS statement.
      static DropSchemaStep dropSchema​(java.lang.String schema)
      Create a new DSL DROP SCHEMA statement.
      static DropSchemaStep dropSchema​(Name schema)
      Create a new DSL DROP SCHEMA statement.
      static DropSchemaStep dropSchema​(Schema schema)
      Create a new DSL DROP SCHEMA statement.
      static DropSchemaStep dropSchemaIfExists​(java.lang.String schema)
      Create a new DSL DROP SCHEMA statement.
      static DropSchemaStep dropSchemaIfExists​(Name schema)
      Create a new DSL DROP SCHEMA statement.
      static DropSchemaStep dropSchemaIfExists​(Schema schema)
      Create a new DSL DROP SCHEMA statement.
      static <T extends java.lang.Number>
      DropSequenceFinalStep
      dropSequence​(java.lang.String sequence)
      Create a new DSL DROP SEQUENCE statement.
      static <T extends java.lang.Number>
      DropSequenceFinalStep
      dropSequence​(Name sequence)
      Create a new DSL DROP SEQUENCE statement.
      static <T extends java.lang.Number>
      DropSequenceFinalStep
      dropSequence​(Sequence<?> sequence)
      Create a new DSL DROP SEQUENCE statement.
      static <T extends java.lang.Number>
      DropSequenceFinalStep
      dropSequenceIfExists​(java.lang.String sequence)
      Create a new DSL DROP SEQUENCE IF EXISTS statement.
      static <T extends java.lang.Number>
      DropSequenceFinalStep
      dropSequenceIfExists​(Name sequence)
      Create a new DSL DROP SEQUENCE IF EXISTS statement.
      static <T extends java.lang.Number>
      DropSequenceFinalStep
      dropSequenceIfExists​(Sequence<?> sequence)
      Create a new DSL DROP SEQUENCE IF EXISTS statement.
      static DropTableStep dropTable​(java.lang.String table)
      Create a new DSL DROP TABLE statement.
      static DropTableStep dropTable​(Name table)
      Create a new DSL DROP TABLE statement.
      static DropTableStep dropTable​(Table<?> table)
      Create a new DSL DROP TABLE statement.
      static DropTableStep dropTableIfExists​(java.lang.String table)
      Create a new DSL DROP TABLE IF EXISTS statement.
      static DropTableStep dropTableIfExists​(Name table)
      Create a new DSL DROP TABLE IF EXISTS statement.
      static DropTableStep dropTableIfExists​(Table<?> table)
      Create a new DSL DROP TABLE IF EXISTS statement.
      static DropTableStep dropTemporaryTable​(java.lang.String table)
      Create a new DSL DROP TEMPORARY TABLE statement.
      static DropTableStep dropTemporaryTable​(Name table)
      Create a new DSL DROP TEMPORARY TABLE statement.
      static DropTableStep dropTemporaryTable​(Table<?> table)
      Create a new DSL DROP TEMPORARY TABLE statement.
      static DropTypeStep dropType​(java.lang.String type)
      Create a new DSL DROP TYPE statement.
      static DropTypeStep dropType​(java.lang.String... type)
      Create a new DSL DROP TYPE statement.
      static DropTypeStep dropType​(java.util.Collection<?> type)
      Create a new DSL DROP TYPE statement.
      static DropTypeStep dropType​(Name type)
      Create a new DSL DROP TYPE statement.
      static DropTypeStep dropType​(Name... type)
      Create a new DSL DROP TYPE statement.
      static DropTypeStep dropTypeIfExists​(java.lang.String type)
      Create a new DSL DROP TYPE statement.
      static DropTypeStep dropTypeIfExists​(java.lang.String... type)
      Create a new DSL DROP TYPE statement.
      static DropTypeStep dropTypeIfExists​(java.util.Collection<?> type)
      Create a new DSL DROP TYPE statement.
      static DropTypeStep dropTypeIfExists​(Name type)
      Create a new DSL DROP TYPE statement.
      static DropTypeStep dropTypeIfExists​(Name... type)
      Create a new DSL DROP TYPE statement.
      static DropViewFinalStep dropView​(java.lang.String view)
      Create a new DSL DROP VIEW statement.
      static DropViewFinalStep dropView​(Name view)
      Create a new DSL DROP VIEW statement.
      static DropViewFinalStep dropView​(Table<?> view)
      Create a new DSL DROP VIEW statement.
      static DropViewFinalStep dropViewIfExists​(java.lang.String view)
      Create a new DSL DROP VIEW IF EXISTS statement.
      static DropViewFinalStep dropViewIfExists​(Name view)
      Create a new DSL DROP VIEW IF EXISTS statement.
      static DropViewFinalStep dropViewIfExists​(Table<?> view)
      Create a new DSL DROP VIEW IF EXISTS statement.
      static Table<Record> dual()
      The DUAL table to be used for syntactic completeness.
      static Field<java.math.BigDecimal> e()
      The E literal (Euler number).
      static Field<java.lang.Integer> epoch​(java.time.temporal.Temporal value)
      Get the epoch of a date.
      static Field<java.lang.Integer> epoch​(java.util.Date value)
      Get the epoch of a date.
      static Field<java.lang.Integer> epoch​(Field<?> field)
      Get the epoch of a date.
      static java.lang.String escape​(java.lang.String value, char escape)
      Convenience method for replace(Field, String, String) to escape data for use with Field.like(Field, char).
      static Field<java.lang.String> escape​(Field<java.lang.String> field, char escape)
      Convenience method for replace(Field, String, String) to escape data for use with Field.like(Field, char).
      static AggregateFunction<java.lang.Boolean> every​(Condition condition)
      Get the every value over a condition: every(condition).
      static AggregateFunction<java.lang.Boolean> every​(Field<java.lang.Boolean> field)
      Get the every value over a field: every(field).
      static Statement execute​(java.lang.String sql)  
      static Statement execute​(Field<java.lang.String> sql)  
      static Condition exists​(Select<?> query)
      Create an exists condition.
      static ExitWhenStep exit()
      Create an EXIT statement for use in procedural code.
      static ExitWhenStep exit​(Label label)
      Create an EXIT statement for use in procedural code.
      static Statement exitWhen​(Condition condition)
      Create an EXIT statement for use in procedural code.
      static Field<java.math.BigDecimal> exp​(java.lang.Number value)
      Get the exp(field) function, taking this field as the power of e.
      static Field<java.math.BigDecimal> exp​(Field<? extends java.lang.Number> field)
      Get the exp(field) function, taking this field as the power of e.
      static Field<java.lang.Integer> extract​(java.time.temporal.Temporal value, DatePart datePart)
      Get the extract(field, datePart) function.
      static Field<java.lang.Integer> extract​(java.util.Date value, DatePart datePart)
      Get the extract(field, datePart) function.
      static Field<java.lang.Integer> extract​(Field<?> field, DatePart datePart)
      Get the extract(field, datePart) function.
      static False falseCondition()
      Return a Condition that will always evaluate to false.
      static Field<java.lang.Object> field​(java.lang.String sql)
      Create a "plain SQL" field.
      static <T> Field<T> field​(java.lang.String sql, java.lang.Class<T> type)
      Create a "plain SQL" field.
      static <T> Field<T> field​(java.lang.String sql, java.lang.Class<T> type, java.lang.Object... bindings)
      Create a "plain SQL" field.
      static <T> Field<T> field​(java.lang.String sql, java.lang.Class<T> type, QueryPart... parts)
      A custom SQL clause that can render arbitrary SQL elements.
      static Field<java.lang.Object> field​(java.lang.String sql, java.lang.Object... bindings)
      Create a "plain SQL" field.
      static <T> Field<T> field​(java.lang.String sql, DataType<T> type)
      Create a "plain SQL" field.
      static <T> Field<T> field​(java.lang.String sql, DataType<T> type, java.lang.Object... bindings)
      Create a "plain SQL" field.
      static <T> Field<T> field​(java.lang.String sql, DataType<T> type, QueryPart... parts)
      Create a "plain SQL" field.
      static Field<java.lang.Object> field​(java.lang.String sql, QueryPart... parts)
      A custom SQL clause that can render arbitrary SQL elements.
      static Field<java.lang.Boolean> field​(Condition condition)
      Transform a condition into a boolean field.
      static Field<java.lang.Object> field​(Name name)
      Create a qualified field, given its (qualified) field name.
      static <T> Field<T> field​(Name name, java.lang.Class<T> type)
      Create a qualified field, given its (qualified) field name.
      static <T> Field<T> field​(Name name, DataType<T> type)
      Create a qualified field, given its (qualified) field name.
      static <T> Field<T> field​(Name name, DataType<T> type, Comment comment)
      Create a qualified field, given its (qualified) field name.
      static <T> Field<T> field​(Select<? extends Record1<T>> select)
      Transform a subquery into a correlated subquery.
      static <T> Field<T> field​(SelectField<T> field)
      Wrap a SelectField in a general-purpose Field
      static Field<java.lang.Object> field​(SQL sql)
      Create a "plain SQL" field.
      static <T> Field<T> field​(SQL sql, java.lang.Class<T> type)
      Create a "plain SQL" field.
      static <T> Field<T> field​(SQL sql, DataType<T> type)
      Create a "plain SQL" field.
      static <T> Field<T> fieldByName​(java.lang.Class<T> type, java.lang.String... qualifiedName)
      Deprecated.
      - [#3843] - 3.6.0 - use field(Name, Class) instead
      static Field<java.lang.Object> fieldByName​(java.lang.String... qualifiedName)
      Deprecated.
      - [#3843] - 3.6.0 - use field(Name) instead
      static <T> Field<T> fieldByName​(DataType<T> type, java.lang.String... qualifiedName)
      Deprecated.
      - [#3843] - 3.6.0 - use field(Name, DataType) instead
      static <T> WindowIgnoreNullsStep<T> firstValue​(Field<T> field)
      The first_value(field) over ([analytic clause]) function.
      static <T extends java.lang.Number>
      Field<T>
      floor​(Field<T> field)
      Get the largest integer value not greater than [this].
      static <T extends java.lang.Number>
      Field<T>
      floor​(T value)
      Get the largest integer value not greater than [this].
      static <T> ForInStep<T> for_​(Variable<T> index)
      Create a FOR loop for use in procedural code.
      static ConstraintForeignKeyReferencesStep1<?> foreignKey​(java.lang.String field1)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStepN foreignKey​(java.lang.String... fields)
      Add a FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep2<?,​?> foreignKey​(java.lang.String field1, java.lang.String field2)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep3<?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep4<?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep5<?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep6<?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep7<?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep8<?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7, java.lang.String field8)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep9<?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7, java.lang.String field8, java.lang.String field9)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep10<?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7, java.lang.String field8, java.lang.String field9, java.lang.String field10)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep11<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7, java.lang.String field8, java.lang.String field9, java.lang.String field10, java.lang.String field11)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep12<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7, java.lang.String field8, java.lang.String field9, java.lang.String field10, java.lang.String field11, java.lang.String field12)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep13<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7, java.lang.String field8, java.lang.String field9, java.lang.String field10, java.lang.String field11, java.lang.String field12, java.lang.String field13)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep14<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7, java.lang.String field8, java.lang.String field9, java.lang.String field10, java.lang.String field11, java.lang.String field12, java.lang.String field13, java.lang.String field14)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep15<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7, java.lang.String field8, java.lang.String field9, java.lang.String field10, java.lang.String field11, java.lang.String field12, java.lang.String field13, java.lang.String field14, java.lang.String field15)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep16<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7, java.lang.String field8, java.lang.String field9, java.lang.String field10, java.lang.String field11, java.lang.String field12, java.lang.String field13, java.lang.String field14, java.lang.String field15, java.lang.String field16)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep17<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7, java.lang.String field8, java.lang.String field9, java.lang.String field10, java.lang.String field11, java.lang.String field12, java.lang.String field13, java.lang.String field14, java.lang.String field15, java.lang.String field16, java.lang.String field17)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep18<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7, java.lang.String field8, java.lang.String field9, java.lang.String field10, java.lang.String field11, java.lang.String field12, java.lang.String field13, java.lang.String field14, java.lang.String field15, java.lang.String field16, java.lang.String field17, java.lang.String field18)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep19<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7, java.lang.String field8, java.lang.String field9, java.lang.String field10, java.lang.String field11, java.lang.String field12, java.lang.String field13, java.lang.String field14, java.lang.String field15, java.lang.String field16, java.lang.String field17, java.lang.String field18, java.lang.String field19)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep20<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7, java.lang.String field8, java.lang.String field9, java.lang.String field10, java.lang.String field11, java.lang.String field12, java.lang.String field13, java.lang.String field14, java.lang.String field15, java.lang.String field16, java.lang.String field17, java.lang.String field18, java.lang.String field19, java.lang.String field20)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep21<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7, java.lang.String field8, java.lang.String field9, java.lang.String field10, java.lang.String field11, java.lang.String field12, java.lang.String field13, java.lang.String field14, java.lang.String field15, java.lang.String field16, java.lang.String field17, java.lang.String field18, java.lang.String field19, java.lang.String field20, java.lang.String field21)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep22<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(java.lang.String field1, java.lang.String field2, java.lang.String field3, java.lang.String field4, java.lang.String field5, java.lang.String field6, java.lang.String field7, java.lang.String field8, java.lang.String field9, java.lang.String field10, java.lang.String field11, java.lang.String field12, java.lang.String field13, java.lang.String field14, java.lang.String field15, java.lang.String field16, java.lang.String field17, java.lang.String field18, java.lang.String field19, java.lang.String field20, java.lang.String field21, java.lang.String field22)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStepN foreignKey​(Field<?>... fields)
      Add a FOREIGN KEY clause to the CONSTRAINT.
      static <T1> ConstraintForeignKeyReferencesStep1<T1> foreignKey​(Field<T1> field1)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2>
      ConstraintForeignKeyReferencesStep2<T1,​T2>
      foreignKey​(Field<T1> field1, Field<T2> field2)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3>
      ConstraintForeignKeyReferencesStep3<T1,​T2,​T3>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4>
      ConstraintForeignKeyReferencesStep4<T1,​T2,​T3,​T4>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5>
      ConstraintForeignKeyReferencesStep5<T1,​T2,​T3,​T4,​T5>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6>
      ConstraintForeignKeyReferencesStep6<T1,​T2,​T3,​T4,​T5,​T6>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7>
      ConstraintForeignKeyReferencesStep7<T1,​T2,​T3,​T4,​T5,​T6,​T7>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>
      ConstraintForeignKeyReferencesStep8<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>
      ConstraintForeignKeyReferencesStep9<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>
      ConstraintForeignKeyReferencesStep10<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>
      ConstraintForeignKeyReferencesStep11<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
      ConstraintForeignKeyReferencesStep12<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>
      ConstraintForeignKeyReferencesStep13<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>
      ConstraintForeignKeyReferencesStep14<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>
      ConstraintForeignKeyReferencesStep15<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>
      ConstraintForeignKeyReferencesStep16<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>
      ConstraintForeignKeyReferencesStep17<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>
      ConstraintForeignKeyReferencesStep18<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>
      ConstraintForeignKeyReferencesStep19<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>
      ConstraintForeignKeyReferencesStep20<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>
      ConstraintForeignKeyReferencesStep21<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>
      ConstraintForeignKeyReferencesStep22<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>
      foreignKey​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep1<?> foreignKey​(Name field1)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStepN foreignKey​(Name... fields)
      Add a FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep2<?,​?> foreignKey​(Name field1, Name field2)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep3<?,​?,​?> foreignKey​(Name field1, Name field2, Name field3)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep4<?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep5<?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep6<?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep7<?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep8<?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep9<?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep10<?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep11<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep12<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep13<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep14<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep15<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep16<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep17<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep18<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep19<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep20<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19, Name field20)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep21<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19, Name field20, Name field21)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static ConstraintForeignKeyReferencesStep22<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?> foreignKey​(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19, Name field20, Name field21, Name field22)
      Add an unnamed (system named) FOREIGN KEY clause to the CONSTRAINT.
      static <T> Field<T> function​(java.lang.String name, java.lang.Class<T> type, Field<?>... arguments)
      function() can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.
      static <T> Field<T> function​(java.lang.String name, DataType<T> type, Field<?>... arguments)
      function() can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.
      static <T> Field<T> function​(Name name, java.lang.Class<T> type, Field<?>... arguments)
      function() can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.
      static <T> Field<T> function​(Name name, DataType<T> type, Field<?>... arguments)
      function() can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.
      static Table<Record1<java.lang.Integer>> generateSeries​(int from, int to)
      A table function generating a series of values from from to to (inclusive).
      static Table<Record1<java.lang.Integer>> generateSeries​(int from, int to, int step)
      A table function generating a series of values from from to to (inclusive), increasing values by step.
      static Table<Record1<java.lang.Integer>> generateSeries​(int from, int to, Field<java.lang.Integer> step)
      A table function generating a series of values from from to to (inclusive), increasing values by step.
      static Table<Record1<java.lang.Integer>> generateSeries​(int from, Field<java.lang.Integer> to)
      A table function generating a series of values from from to to (inclusive).
      static Table<Record1<java.lang.Integer>> generateSeries​(int from, Field<java.lang.Integer> to, int step)
      A table function generating a series of values from from to to (inclusive), increasing values by step.
      static Table<Record1<java.lang.Integer>> generateSeries​(int from, Field<java.lang.Integer> to, Field<java.lang.Integer> step)
      A table function generating a series of values from from to to (inclusive), increasing values by step.
      static Table<Record1<java.lang.Integer>> generateSeries​(Field<java.lang.Integer> from, int to)
      A table function generating a series of values from from to to (inclusive).
      static Table<Record1<java.lang.Integer>> generateSeries​(Field<java.lang.Integer> from, int to, int step)
      A table function generating a series of values from from to to (inclusive), increasing values by step.
      static Table<Record1<java.lang.Integer>> generateSeries​(Field<java.lang.Integer> from, int to, Field<java.lang.Integer> step)
      A table function generating a series of values from from to to (inclusive), increasing values by step.
      static Table<Record1<java.lang.Integer>> generateSeries​(Field<java.lang.Integer> from, Field<java.lang.Integer> to)
      A table function generating a series of values from from to to (inclusive).
      static Table<Record1<java.lang.Integer>> generateSeries​(Field<java.lang.Integer> from, Field<java.lang.Integer> to, int step)
      A table function generating a series of values from from to to (inclusive), increasing values by step.
      static Table<Record1<java.lang.Integer>> generateSeries​(Field<java.lang.Integer> from, Field<java.lang.Integer> to, Field<java.lang.Integer> step)
      A table function generating a series of values from from to to (inclusive), increasing values by step.
      static <T> DataType<T> getDataType​(java.lang.Class<T> type)
      Deprecated.
      - 3.11.0 - [#7483] - The (indirect) use of the internal static data type registry is not recommended.
      static Statement goto_​(Label label)
      Create an GOTO statement for use in procedural code.
      static GrantOnStep grant​(java.util.Collection<? extends Privilege> privileges)
      Grant privileges on table to user or role.
      static GrantOnStep grant​(Privilege privilege)
      Grant a privilege on table to user or role.
      static GrantOnStep grant​(Privilege... privileges)
      Grant privileges on table to user or role.
      static <T> Field<T> greatest​(Field<T> field, Field<?>... others)
      Find the greatest among all values.
      static <T> Field<T> greatest​(T value, T... values)
      Find the greatest among all values.
      static GroupConcatOrderByStep groupConcat​(Field<?> field)
      Get the aggregated concatenation for a field.
      static AggregateFunction<java.lang.String> groupConcat​(Field<?> field, java.lang.String separator)
      Deprecated.
      static GroupConcatOrderByStep groupConcatDistinct​(Field<?> field)
      Get the aggregated concatenation for a field.
      static Field<java.lang.Integer> groupId()
      Create a GROUP_ID() aggregation function to be used along with CUBE, ROLLUP, and GROUPING SETS groupings.
      static Field<java.lang.Integer> grouping​(Field<?> field)
      Create a GROUPING(field) aggregation field to be used along with CUBE, ROLLUP, and GROUPING SETS groupings.
      static Field<java.lang.Integer> groupingId​(Field<?>... fields)
      Create a GROUPING_ID(field1, field2, .., fieldn) aggregation field to be used along with CUBE, ROLLUP, and GROUPING SETS groupings.
      static GroupField groupingSets​(java.util.Collection<? extends Field<?>>... fieldSets)
      Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna, fieldnb)) grouping field.
      static GroupField groupingSets​(Field<?>... fields)
      Create a GROUPING SETS(field1, field2, .., fieldn) grouping field where each grouping set only consists of a single field.
      static GroupField groupingSets​(Field<?>[]... fieldSets)
      Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna, fieldnb)) grouping field.
      static WindowSpecificationRowsAndStep groupsBetweenCurrentRow()
      Create a WindowSpecification with a GROUPS clause.
      static WindowSpecificationRowsAndStep groupsBetweenFollowing​(int number)
      Create a WindowSpecification with a GROUPS clause.
      static WindowSpecificationRowsAndStep groupsBetweenPreceding​(int number)
      Create a WindowSpecification with a GROUPS clause.
      static WindowSpecificationRowsAndStep groupsBetweenUnboundedFollowing()
      Create a WindowSpecification with a GROUPS clause.
      static WindowSpecificationRowsAndStep groupsBetweenUnboundedPreceding()
      Create a WindowSpecification with a GROUPS clause.
      static WindowSpecificationExcludeStep groupsCurrentRow()
      Create a WindowSpecification with a GROUPS clause.
      static WindowSpecificationExcludeStep groupsFollowing​(int number)
      Create a WindowSpecification with a GROUPS clause.
      static WindowSpecificationExcludeStep groupsPreceding​(int number)
      Create a WindowSpecification with a GROUPS clause.
      static WindowSpecificationExcludeStep groupsUnboundedFollowing()
      Create a WindowSpecification with a GROUPS clause.
      static WindowSpecificationExcludeStep groupsUnboundedPreceding()
      Create a WindowSpecification with a GROUPS clause.
      static Field<java.lang.Integer> hour​(java.time.temporal.Temporal value)
      Get the hour part of a date.
      static Field<java.lang.Integer> hour​(java.util.Date value)
      Get the hour part of a date.
      static Field<java.lang.Integer> hour​(Field<?> field)
      Get the hour part of a date.
      static IfThenStep if_​(Condition condition)
      Create an IF statement for use in procedural code.
      static <T> Field<T> ifnull​(Field<T> value, Field<T> defaultValue)
      The IFNULL() function, a synonym of NVL().
      static <T> Field<T> ifnull​(Field<T> value, T defaultValue)
      The IFNULL() function, a synonym of NVL().
      static <T> Field<T> ifnull​(T value, Field<T> defaultValue)
      The IFNULL() function, a synonym of NVL().
      static <T> Field<T> ifnull​(T value, T defaultValue)
      The IFNULL() function, a synonym of NVL().
      static <T> Field<T> iif​(Condition condition, Field<T> ifTrue, Field<T> ifFalse)
      Gets the SQL Server style IIF(condition, ifTrue, ifFalse) function.
      static <T> Field<T> iif​(Condition condition, Field<T> ifTrue, T ifFalse)
      Gets the SQL Server style IIF(condition, ifTrue, ifFalse) function.
      static <T> Field<T> iif​(Condition condition, T ifTrue, Field<T> ifFalse)
      Gets the SQL Server style IIF(condition, ifTrue, ifFalse) function.
      static <T> Field<T> iif​(Condition condition, T ifTrue, T ifFalse)
      Gets the SQL Server style IIF(condition, ifTrue, ifFalse) function.
      static Index index​(Name name)
      Create a qualified index reference by name.
      static Param<java.lang.Boolean> inline​(boolean value)
      Create a bind value that is always inlined.
      static Param<java.lang.Byte> inline​(byte value)
      Create a bind value that is always inlined.
      static Param<byte[]> inline​(byte[] value)
      Create a bind value that is always inlined.
      static Param<java.lang.String> inline​(char character)
      Create a bind value, that is always inlined.
      static Param<java.lang.Double> inline​(double value)
      Create a bind value that is always inlined.
      static Param<java.lang.Float> inline​(float value)
      Create a bind value that is always inlined.
      static Param<java.lang.Integer> inline​(int value)
      Create a bind value that is always inlined.
      static Param<java.lang.Long> inline​(long value)
      Create a bind value that is always inlined.
      static Param<java.lang.Short> inline​(short value)
      Create a bind value that is always inlined.
      static Param<java.lang.Boolean> inline​(java.lang.Boolean value)
      Create a bind value that is always inlined.
      static Param<java.lang.Byte> inline​(java.lang.Byte value)
      Create a bind value that is always inlined.
      static Param<java.lang.String> inline​(java.lang.Character character)
      Create a bind value, that is always inlined.
      static Param<java.lang.String> inline​(java.lang.CharSequence character)
      Create a bind value, that is always inlined.
      static Param<java.lang.Double> inline​(java.lang.Double value)
      Create a bind value that is always inlined.
      static Param<java.lang.Float> inline​(java.lang.Float value)
      Create a bind value that is always inlined.
      static Param<java.lang.Integer> inline​(java.lang.Integer value)
      Create a bind value that is always inlined.
      static Param<java.lang.Long> inline​(java.lang.Long value)
      Create a bind value that is always inlined.
      static <T> Param<T> inline​(java.lang.Object value, java.lang.Class<T> type)
      Create a bind value, that is always inlined.
      static <T> Param<T> inline​(java.lang.Object value, DataType<T> type)
      Create a bind value, that is always inlined.
      static <T> Param<T> inline​(java.lang.Object value, Field<T> field)
      Create a bind value, that is always inlined.
      static Param<java.lang.Short> inline​(java.lang.Short value)
      Create a bind value that is always inlined.
      static Param<java.lang.String> inline​(java.lang.String value)
      Create a bind value that is always inlined.
      static Param<java.math.BigDecimal> inline​(java.math.BigDecimal value)
      Create a bind value that is always inlined.
      static Param<java.math.BigInteger> inline​(java.math.BigInteger value)
      Create a bind value that is always inlined.
      static Param<java.sql.Date> inline​(java.sql.Date value)
      Create a bind value that is always inlined.
      static Param<java.sql.Time> inline​(java.sql.Time value)
      Create a bind value that is always inlined.
      static Param<java.sql.Timestamp> inline​(java.sql.Timestamp value)
      Create a bind value that is always inlined.
      static Param<java.time.Instant> inline​(java.time.Instant value)
      Create a bind value that is always inlined.
      static Param<java.time.LocalDate> inline​(java.time.LocalDate value)
      Create a bind value that is always inlined.
      static Param<java.time.LocalDateTime> inline​(java.time.LocalDateTime value)
      Create a bind value that is always inlined.
      static Param<java.time.LocalTime> inline​(java.time.LocalTime value)
      Create a bind value that is always inlined.
      static Param<java.time.OffsetDateTime> inline​(java.time.OffsetDateTime value)
      Create a bind value that is always inlined.
      static Param<java.time.OffsetTime> inline​(java.time.OffsetTime value)
      Create a bind value that is always inlined.
      static Param<java.util.UUID> inline​(java.util.UUID value)
      Create a bind value that is always inlined.
      static Param<UByte> inline​(UByte value)
      Create a bind value that is always inlined.
      static Param<UInteger> inline​(UInteger value)
      Create a bind value that is always inlined.
      static Param<ULong> inline​(ULong value)
      Create a bind value that is always inlined.
      static Param<UShort> inline​(UShort value)
      Create a bind value that is always inlined.
      static <T> Param<T> inline​(T value)
      Create a bind value, that is always inlined.
      static <R extends Record>
      InsertSetStep<R>
      insertInto​(Table<R> into)
      Create a new DSL insert statement.
      static <R extends Record>
      InsertValuesStepN<R>
      insertInto​(Table<R> into, java.util.Collection<? extends Field<?>> fields)
      Create a new DSL insert statement.
      static <R extends Record>
      InsertValuesStepN<R>
      insertInto​(Table<R> into, Field<?>... fields)
      Create a new DSL insert statement.
      static <R extends Record,​T1>
      InsertValuesStep1<R,​T1>
      insertInto​(Table<R> into, Field<T1> field1)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2>
      InsertValuesStep2<R,​T1,​T2>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3>
      InsertValuesStep3<R,​T1,​T2,​T3>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4>
      InsertValuesStep4<R,​T1,​T2,​T3,​T4>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5>
      InsertValuesStep5<R,​T1,​T2,​T3,​T4,​T5>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6>
      InsertValuesStep6<R,​T1,​T2,​T3,​T4,​T5,​T6>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7>
      InsertValuesStep7<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>
      InsertValuesStep8<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>
      InsertValuesStep9<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>
      InsertValuesStep10<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>
      InsertValuesStep11<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
      InsertValuesStep12<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>
      InsertValuesStep13<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>
      InsertValuesStep14<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>
      InsertValuesStep15<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>
      InsertValuesStep16<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>
      InsertValuesStep17<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>
      InsertValuesStep18<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>
      InsertValuesStep19<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>
      InsertValuesStep20<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>
      InsertValuesStep21<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)
      Create a new DSL insert statement.
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>
      InsertValuesStep22<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>
      insertInto​(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)
      Create a new DSL insert statement.
      static Field<java.time.Instant> instant​(java.lang.String value)
      Convert a string value to a TIMESTAMP WITH TIME ZONE.
      static Field<java.time.Instant> instant​(java.time.Instant value)
      Convert a temporal value to a TIMESTAMP WITH TIME ZONE.
      static Field<java.time.Instant> instant​(Field<java.time.Instant> field)
      Convert a temporal value to a TIMESTAMP WITH TIME ZONE.
      static <T> Field<T> isnull​(Field<T> value, Field<T> defaultValue)
      Gets the SQL Server-style ISNULL(value, defaultValue) function.
      static <T> Field<T> isnull​(Field<T> value, T defaultValue)
      Gets the SQL Server-style ISNULL(value, defaultValue) function.
      static <T> Field<T> isnull​(T value, Field<T> defaultValue)
      Gets the SQL Server-style ISNULL(value, defaultValue) function.
      static <T> Field<T> isnull​(T value, T defaultValue)
      Gets the SQL Server-style ISNULL(value, defaultValue) function.
      static Field<java.lang.Integer> isoDayOfWeek​(java.time.temporal.Temporal value)
      Get the ISO day of week part of a date.
      static Field<java.lang.Integer> isoDayOfWeek​(java.util.Date value)
      Get the ISO day of week part of a date.
      static Field<java.lang.Integer> isoDayOfWeek​(Field<?> field)
      Get the ISO day of week part of a date.
      static Field<JSON> jsonArray​(java.util.Collection<? extends Field<?>> fields)
      The JSON array constructor.
      static Field<JSON> jsonArray​(Field<?>... fields)
      The JSON array constructor.
      static Field<JSONB> jsonbArray​(java.util.Collection<? extends Field<?>> fields)
      The JSONB array constructor.
      static Field<JSONB> jsonbArray​(Field<?>... fields)
      The JSONB array constructor.
      static Field<JSONB> jsonbObject​(java.util.Collection<? extends JSONEntry<?>> entries)
      The JSONB object constructor.
      static Field<JSONB> jsonbObject​(JSONEntry<?>... entries)
      The JSONB object constructor.
      static <T> JSONEntry<T> jsonEntry​(Field<java.lang.String> key, Field<T> value)
      A constructor for JSON entries to be used with jsonObject(JSONEntry...).
      static Field<JSON> jsonObject​(java.util.Collection<? extends JSONEntry<?>> entries)
      The JSON object constructor.
      static Field<JSON> jsonObject​(Field<java.lang.String> key, Field<?> value)
      The JSON object constructor.
      static Field<JSON> jsonObject​(JSONEntry<?>... entries)
      The JSON object constructor.
      static Keyword keyword​(java.lang.String keyword)
      Create a SQL keyword.
      static Label label​(java.lang.String label)
      Create a label reference for use in procedural code.
      static Label label​(Name label)
      Create a label reference for use in procedural code.
      static <T> WindowIgnoreNullsStep<T> lag​(Field<T> field)
      The lag(field) over ([analytic clause]) function.
      static <T> WindowIgnoreNullsStep<T> lag​(Field<T> field, int offset)
      The lag(field, offset) over ([analytic clause]) function.
      static <T> WindowIgnoreNullsStep<T> lag​(Field<T> field, int offset, Field<T> defaultValue)
      The lag(field, offset, defaultValue) over ([analytic clause]) function.
      static <T> WindowIgnoreNullsStep<T> lag​(Field<T> field, int offset, T defaultValue)
      The lag(field, offset, defaultValue) over ([analytic clause]) function.
      static <T> WindowIgnoreNullsStep<T> lastValue​(Field<T> field)
      The last_value(field) over ([analytic clause]) function.
      static <R extends Record>
      Table<R>
      lateral​(TableLike<R> table)
      Create a LATERAL joined table.
      static <T> WindowIgnoreNullsStep<T> lead​(Field<T> field)
      The lead(field) over ([analytic clause]) function.
      static <T> WindowIgnoreNullsStep<T> lead​(Field<T> field, int offset)
      The lead(field, offset) over ([analytic clause]) function.
      static <T> WindowIgnoreNullsStep<T> lead​(Field<T> field, int offset, Field<T> defaultValue)
      The lead(field, offset, defaultValue) over ([analytic clause]) function.
      static <T> WindowIgnoreNullsStep<T> lead​(Field<T> field, int offset, T defaultValue)
      The lead(field, offset, defaultValue) over ([analytic clause]) function.
      static <T> Field<T> least​(Field<T> field, Field<?>... others)
      Find the least among all values.
      static <T> Field<T> least​(T value, T... values)
      Find the least among all values.
      static Field<java.lang.String> left​(java.lang.String field, int length)
      Get the left outermost characters from a string.
      static Field<java.lang.String> left​(java.lang.String field, Field<? extends java.lang.Number> length)
      Get the left outermost characters from a string.
      static Field<java.lang.String> left​(Field<java.lang.String> field, int length)
      Get the left outermost characters from a string.
      static Field<java.lang.String> left​(Field<java.lang.String> field, Field<? extends java.lang.Number> length)
      Get the left outermost characters from a string.
      static Field<java.lang.Integer> length​(java.lang.String value)
      Get the length of a VARCHAR type.
      static Field<java.lang.Integer> length​(Field<java.lang.String> field)
      Get the length of a VARCHAR type.
      static Field<java.lang.Integer> level()
      Retrieve the Oracle-specific LEVEL pseudo-field (to be used along with CONNECT BY clauses).
      static Link link​(java.lang.String name)
      Create a database link reference.
      static Link link​(java.lang.String name, Schema schema)
      Create a database link reference.
      static Link link​(Name name)
      Create a database link reference.
      static QueryPart list​(java.util.Collection<? extends QueryPart> parts)
      Compose a list of QueryParts into a new QueryPart, with individual parts being comma-separated.
      static QueryPart list​(QueryPart... parts)
      Compose a list of QueryParts into a new QueryPart, with individual parts being comma-separated.
      static OrderedAggregateFunction<java.lang.String> listAgg​(Field<?> field)
      Get the aggregated concatenation for a field.
      static OrderedAggregateFunction<java.lang.String> listAgg​(Field<?> field, java.lang.String separator)
      Get the aggregated concatenation for a field.
      static Field<java.math.BigDecimal> ln​(java.lang.Number value)
      Get the ln(field) function, taking the natural logarithm of this field.
      static Field<java.math.BigDecimal> ln​(Field<? extends java.lang.Number> field)
      Get the ln(field) function, taking the natural logarithm of this field.
      static Field<java.time.LocalDate> localDate​(java.lang.String value)
      Convert a string value to a DATE.
      static Field<java.time.LocalDate> localDate​(java.time.LocalDate value)
      Convert a temporal value to a DATE.
      static Field<java.time.LocalDate> localDate​(Field<java.time.LocalDate> field)
      Convert a temporal value to a DATE.
      static Field<java.time.LocalDate> localDateAdd​(java.time.LocalDate date, java.lang.Number interval)
      Add an interval to a date.
      static Field<java.time.LocalDate> localDateAdd​(java.time.LocalDate date, java.lang.Number interval, DatePart datePart)
      Add an interval to a date, given a date part.
      static Field<java.time.LocalDate> localDateAdd​(java.time.LocalDate date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Add an interval to a date, given a date part.
      static Field<java.time.LocalDate> localDateAdd​(Field<java.time.LocalDate> date, java.lang.Number interval, DatePart datePart)
      Add an interval to a date, given a date part.
      static Field<java.time.LocalDate> localDateAdd​(Field<java.time.LocalDate> date, Field<? extends java.lang.Number> interval)
      Add an interval to a date.
      static Field<java.time.LocalDate> localDateAdd​(Field<java.time.LocalDate> date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Add an interval to a date, given a date part.
      static Field<java.lang.Integer> localDateDiff​(java.time.LocalDate date1, java.time.LocalDate date2)
      Get the date difference in number of days.
      static Field<java.lang.Integer> localDateDiff​(java.time.LocalDate date1, Field<java.time.LocalDate> date2)
      Get the date difference in number of days.
      static Field<java.lang.Integer> localDateDiff​(Field<java.time.LocalDate> date1, java.time.LocalDate date2)
      Get the date difference in number of days.
      static Field<java.lang.Integer> localDateDiff​(Field<java.time.LocalDate> date1, Field<java.time.LocalDate> date2)
      Get the date difference in number of days.
      static Field<java.time.LocalDate> localDateSub​(java.time.LocalDate date, java.lang.Number interval)
      Subtract an interval from a date.
      static Field<java.time.LocalDate> localDateSub​(java.time.LocalDate date, java.lang.Number interval, DatePart datePart)
      Subtract an interval from a date, given a date part.
      static Field<java.time.LocalDate> localDateSub​(java.time.LocalDate date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Subtract an interval from a date, given a date part.
      static Field<java.time.LocalDate> localDateSub​(Field<java.time.LocalDate> date, java.lang.Number interval, DatePart datePart)
      Subtract an interval from a date, given a date part.
      static Field<java.time.LocalDate> localDateSub​(Field<java.time.LocalDate> date, Field<? extends java.lang.Number> interval)
      Subtract an interval from a date.
      static Field<java.time.LocalDate> localDateSub​(Field<java.time.LocalDate> date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Subtract an interval from a date, given a date part.
      static Field<java.time.LocalDateTime> localDateTime​(java.lang.String value)
      Convert a string value to a TIMESTAMP.
      static Field<java.time.LocalDateTime> localDateTime​(java.time.LocalDateTime value)
      Convert a temporal value to a TIMESTAMP.
      static Field<java.time.LocalDateTime> localDateTime​(Field<java.time.LocalDateTime> field)
      Convert a temporal value to a TIMESTAMP.
      static Field<java.time.LocalDateTime> localDateTimeAdd​(java.time.LocalDateTime timestamp, java.lang.Number interval)
      Add an interval to a timestamp.
      static Field<java.time.LocalDateTime> localDateTimeAdd​(java.time.LocalDateTime date, java.lang.Number interval, DatePart datePart)
      Add an interval to a timestamp, given a date part.
      static Field<java.time.LocalDateTime> localDateTimeAdd​(java.time.LocalDateTime date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Add an interval to a timestamp, given a date part.
      static Field<java.time.LocalDateTime> localDateTimeAdd​(Field<java.time.LocalDateTime> date, java.lang.Number interval, DatePart datePart)
      Add an interval to a timestamp, given a date part.
      static Field<java.time.LocalDateTime> localDateTimeAdd​(Field<java.time.LocalDateTime> timestamp, Field<? extends java.lang.Number> interval)
      Add an interval to a timestamp.
      static Field<java.time.LocalDateTime> localDateTimeAdd​(Field<java.time.LocalDateTime> date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Add an interval to a timestamp, given a date part.
      static Field<DayToSecond> localDateTimeDiff​(java.time.LocalDateTime timestamp1, java.time.LocalDateTime timestamp2)
      Get the timestamp difference as a INTERVAL DAY TO SECOND type.
      static Field<DayToSecond> localDateTimeDiff​(java.time.LocalDateTime timestamp1, Field<java.time.LocalDateTime> timestamp2)
      Get the timestamp difference as a INTERVAL DAY TO SECOND type.
      static Field<DayToSecond> localDateTimeDiff​(Field<java.time.LocalDateTime> timestamp1, java.time.LocalDateTime timestamp2)
      Get the timestamp difference as a INTERVAL DAY TO SECOND type.
      static Field<DayToSecond> localDateTimeDiff​(Field<java.time.LocalDateTime> timestamp1, Field<java.time.LocalDateTime> timestamp2)
      Get the timestamp difference as a INTERVAL DAY TO SECOND type.
      static Field<java.time.LocalDateTime> localDateTimeSub​(java.time.LocalDateTime timestamp, java.lang.Number interval)
      Subtract an interval from a timestamp.
      static Field<java.time.LocalDateTime> localDateTimeSub​(java.time.LocalDateTime date, java.lang.Number interval, DatePart datePart)
      Subtract an interval from a timestamp, given a date part.
      static Field<java.time.LocalDateTime> localDateTimeSub​(java.time.LocalDateTime date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Subtract an interval from a timestamp, given a date part.
      static Field<java.time.LocalDateTime> localDateTimeSub​(Field<java.time.LocalDateTime> date, java.lang.Number interval, DatePart datePart)
      Subtract an interval from a timestamp, given a date part.
      static Field<java.time.LocalDateTime> localDateTimeSub​(Field<java.time.LocalDateTime> timestamp, Field<? extends java.lang.Number> interval)
      Subtract an interval from a timestamp.
      static Field<java.time.LocalDateTime> localDateTimeSub​(Field<java.time.LocalDateTime> date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Subtract an interval from a timestamp, given a date part.
      static Field<java.time.LocalTime> localTime​(java.lang.String value)
      Convert a string value to a TIME.
      static Field<java.time.LocalTime> localTime​(java.time.LocalTime value)
      Convert a temporal value to a TIME.
      static Field<java.time.LocalTime> localTime​(Field<java.time.LocalTime> field)
      Convert a temporal value to a TIME.
      static Field<java.math.BigDecimal> log​(java.lang.Number value, int base)
      Get the log(field, base) function.
      static Field<java.math.BigDecimal> log​(Field<? extends java.lang.Number> field, int base)
      Get the log(field, base) function.
      static Field<java.math.BigDecimal> log​(Field<? extends java.lang.Number> field, Field<? extends java.lang.Number> base)
      Get the log(field, base) function.
      static Statement loop​(java.util.Collection<? extends Statement> statements)
      Create a LOOP for use in procedural code.
      static Statement loop​(Statement... statements)
      Create a LOOP for use in procedural code.
      static Field<java.lang.String> lower​(java.lang.String value)
      Get the lower(field) function.
      static Field<java.lang.String> lower​(Field<java.lang.String> field)
      Get the lower(field) function.
      static Field<java.lang.String> lpad​(Field<java.lang.String> field, int length)
      Get the lpad(field, length) function.
      static Field<java.lang.String> lpad​(Field<java.lang.String> field, int length, char character)
      Get the lpad(field, length, character) function.
      static Field<java.lang.String> lpad​(Field<java.lang.String> field, int length, java.lang.String character)
      Get the lpad(field, length, character) function.
      static Field<java.lang.String> lpad​(Field<java.lang.String> field, Field<? extends java.lang.Number> length)
      Get the lpad(field, length) function.
      static Field<java.lang.String> lpad​(Field<java.lang.String> field, Field<? extends java.lang.Number> length, Field<java.lang.String> character)
      Get the lpad(field, length, character) function.
      static Field<java.lang.String> ltrim​(java.lang.String value)
      Get the ltrim(field) function.
      static Field<java.lang.String> ltrim​(java.lang.String value, java.lang.String characters)
      Get the ltrim(field, characters) or trim(leading characters from field) function.
      static Field<java.lang.String> ltrim​(Field<java.lang.String> field)
      Get the ltrim(field) function.
      static Field<java.lang.String> ltrim​(Field<java.lang.String> field, Field<java.lang.String> characters)
      Get the ltrim(field, characters) or trim(leading characters from field) function.
      static <T> AggregateFunction<T> max​(Field<T> field)
      Get the max value over a field: max(field).
      static <T> AggregateFunction<T> maxDistinct​(Field<T> field)
      Get the max value over a field: max(distinct field).
      static Field<java.lang.String> md5​(java.lang.String string)
      Get the MySQL-specific MD5() function.
      static Field<java.lang.String> md5​(Field<java.lang.String> string)
      Get the MySQL-specific MD5() function.
      static AggregateFunction<java.math.BigDecimal> median​(Field<? extends java.lang.Number> field)
      Get the median over a numeric field: median(field).
      static <R extends Record>
      MergeUsingStep<R>
      mergeInto​(Table<R> table)
      Create a new DSL SQL standard MERGE statement.
      static <R extends Record>
      MergeKeyStepN<R>
      mergeInto​(Table<R> table, java.util.Collection<? extends Field<?>> fields)
      Create a new DSL merge statement (H2-specific syntax).
      static <R extends Record>
      MergeKeyStepN<R>
      mergeInto​(Table<R> table, Field<?>... fields)
      Create a new DSL merge statement (H2-specific syntax).
      static <R extends Record,​T1>
      MergeKeyStep1<R,​T1>
      mergeInto​(Table<R> table, Field<T1> field1)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2>
      MergeKeyStep2<R,​T1,​T2>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3>
      MergeKeyStep3<R,​T1,​T2,​T3>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4>
      MergeKeyStep4<R,​T1,​T2,​T3,​T4>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5>
      MergeKeyStep5<R,​T1,​T2,​T3,​T4,​T5>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6>
      MergeKeyStep6<R,​T1,​T2,​T3,​T4,​T5,​T6>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7>
      MergeKeyStep7<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>
      MergeKeyStep8<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>
      MergeKeyStep9<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>
      MergeKeyStep10<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>
      MergeKeyStep11<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
      MergeKeyStep12<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>
      MergeKeyStep13<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>
      MergeKeyStep14<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>
      MergeKeyStep15<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>
      MergeKeyStep16<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>
      MergeKeyStep17<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>
      MergeKeyStep18<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>
      MergeKeyStep19<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>
      MergeKeyStep20<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>
      MergeKeyStep21<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static <R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>
      MergeKeyStep22<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>
      mergeInto​(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)
      Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
      static Field<java.lang.Integer> microsecond​(java.time.temporal.Temporal value)
      Get the microsecond part of a date.
      static Field<java.lang.Integer> microsecond​(java.util.Date value)
      Get the microsecond part of a date.
      static Field<java.lang.Integer> microsecond​(Field<?> field)
      Get the microsecond part of a date.
      static Field<java.lang.String> mid​(Field<java.lang.String> field, int startingPosition, int length)
      Get the mid(field, startingPosition, length) function.
      static Field<java.lang.String> mid​(Field<java.lang.String> field, Field<? extends java.lang.Number> startingPosition, Field<? extends java.lang.Number> length)
      Get the mid(field, startingPosition, length) function.
      static Field<java.lang.Integer> millennium​(java.time.temporal.Temporal value)
      Get the millennium of a date.
      static Field<java.lang.Integer> millennium​(java.util.Date value)
      Get the millennium of a date.
      static Field<java.lang.Integer> millennium​(Field<?> field)
      Get the millennium of a date.
      static Field<java.lang.Integer> millisecond​(java.time.temporal.Temporal value)
      Get the millisecond part of a date.
      static Field<java.lang.Integer> millisecond​(java.util.Date value)
      Get the millisecond part of a date.
      static Field<java.lang.Integer> millisecond​(Field<?> field)
      Get the millisecond part of a date.
      static <T> AggregateFunction<T> min​(Field<T> field)
      Get the min value over a field: min(field).
      static <T> AggregateFunction<T> minDistinct​(Field<T> field)
      Get the min value over a field: min(distinct field).
      static <T extends java.lang.Number>
      Field<T>
      minus​(Field<T> field)
      Negate a field to get its negative value.
      static Field<java.lang.Integer> minute​(java.time.temporal.Temporal value)
      Get the minute part of a date.
      static Field<java.lang.Integer> minute​(java.util.Date value)
      Get the minute part of a date.
      static Field<java.lang.Integer> minute​(Field<?> field)
      Get the minute part of a date.
      static OrderedAggregateFunctionOfDeferredType mode()
      The mode() within group (oder by [order clause]) ordered aggregate function.
      static <T> AggregateFunction<T> mode​(Field<T> field)
      The mode(field) aggregate function.
      static Field<java.lang.Integer> month​(java.time.temporal.Temporal value)
      Get the month part of a date.
      static Field<java.lang.Integer> month​(java.util.Date value)
      Get the month part of a date.
      static Field<java.lang.Integer> month​(Field<?> field)
      Get the month part of a date.
      static Name name​(java.lang.String unqualifiedName)
      Create a new SQL identifier using an unqualified name.
      static Name name​(java.lang.String... qualifiedName)
      Create a new SQL identifier using a qualified name.
      static Name name​(java.util.Collection<java.lang.String> qualifiedName)
      Create a new SQL identifier using a qualified name.
      static Name name​(Name... nameParts)
      Create a new SQL identifier using a qualified name.
      static <T extends java.lang.Number>
      Field<T>
      neg​(Field<T> field)
      Negate a field to get its negative value.
      static Condition noCondition()
      Return a Condition that behaves like no condition being present.
      static Field<java.lang.Boolean> not​(java.lang.Boolean value)
      Deprecated.
      - 3.8.0 - [#4763] - Use not(Condition) instead.
      static Condition not​(Condition condition)
      Invert a condition.
      static Field<java.lang.Boolean> not​(Field<java.lang.Boolean> field)
      Invert a boolean value.
      static Condition notExists​(Select<?> query)
      Create a not exists condition.
      static Condition notUnique​(Select<?> query)
      Create a not unique condition.
      static Field<java.sql.Timestamp> now()
      Synonym for currentTimestamp().
      static Field<java.sql.Timestamp> now​(Field<java.lang.Integer> precision)
      static <T> WindowFromFirstLastStep<T> nthValue​(Field<T> field, int nth)
      The nth_value(field) over ([analytic clause]) function.
      static <T> WindowFromFirstLastStep<T> nthValue​(Field<T> field, Field<java.lang.Integer> nth)
      The nth_value(field) over ([analytic clause]) function.
      static WindowOverStep<java.lang.Integer> ntile​(int number)
      The ntile([number]) over ([analytic clause]) function.
      static <T> Field<T> nullif​(Field<T> value, Field<T> other)
      Gets the Oracle-style NULLIF(value, other) function.
      static <T> Field<T> nullif​(Field<T> value, T other)
      Gets the Oracle-style NULLIF(value, other) function.
      static <T> Field<T> nullif​(T value, Field<T> other)
      Gets the Oracle-style NULLIF(value, other) function.
      static <T> Field<T> nullif​(T value, T other)
      Gets the Oracle-style NULLIF(value, other) function.
      protected static Field<?>[] nullSafe​(Field<?>... fields)
      Null-safety of a field.
      protected static <T> Field<T> nullSafe​(Field<T> field)
      Null-safety of a field.
      protected static <T> Field<T> nullSafe​(Field<T> field, DataType<?> type)
      Null-safety of a field.
      protected static <T> DataType<T> nullSafeDataType​(Field<T> field)
      Get a default data type if a field is null.
      static <T> Field<T> nvl​(Field<T> value, Field<T> defaultValue)
      Gets the Oracle-style NVL(value, defaultValue) function.
      static <T> Field<T> nvl​(Field<T> value, T defaultValue)
      Gets the Oracle-style NVL(value, defaultValue) function.
      static <T> Field<T> nvl​(T value, Field<T> defaultValue)
      Gets the Oracle-style NVL(value, defaultValue) function.
      static <T> Field<T> nvl​(T value, T defaultValue)
      Gets the Oracle-style NVL(value, defaultValue) function.
      static <Z> Field<Z> nvl2​(Field<?> value, Field<Z> valueIfNotNull, Field<Z> valueIfNull)
      Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.
      static <Z> Field<Z> nvl2​(Field<?> value, Field<Z> valueIfNotNull, Z valueIfNull)
      Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.
      static <Z> Field<Z> nvl2​(Field<?> value, Z valueIfNotNull, Field<Z> valueIfNull)
      Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.
      static <Z> Field<Z> nvl2​(Field<?> value, Z valueIfNotNull, Z valueIfNull)
      Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.
      static Field<java.lang.Integer> octetLength​(java.lang.String value)
      Get the octet_length(field) function.
      static Field<java.lang.Integer> octetLength​(Field<java.lang.String> field)
      Get the octet_length(field) function.
      static Field<java.time.OffsetDateTime> offsetDateTime​(java.lang.String value)
      Convert a string value to a TIMESTAMP WITH TIME ZONE.
      static Field<java.time.OffsetDateTime> offsetDateTime​(java.time.OffsetDateTime value)
      Convert a temporal value to a TIMESTAMP WITH TIME ZONE.
      static Field<java.time.OffsetDateTime> offsetDateTime​(Field<java.time.OffsetDateTime> field)
      Convert a temporal value to a TIMESTAMP WITH TIME ZONE.
      static Field<java.time.OffsetTime> offsetTime​(java.lang.String value)
      Convert a string value to a TIME WITH TIME ZONE.
      static Field<java.time.OffsetTime> offsetTime​(java.time.OffsetTime value)
      Convert a temporal value to a TIME WITH TIME ZONE.
      static Field<java.time.OffsetTime> offsetTime​(Field<java.time.OffsetTime> field)
      Convert a temporal value to a TIME WITH TIME ZONE.
      static Param<java.lang.Integer> one()
      A 1 literal.
      static Condition or​(java.util.Collection<? extends Condition> conditions)
      Return a Condition that connects all argument conditions with Operator.OR.
      static Condition or​(Condition... conditions)
      Return a Condition that connects all argument conditions with Operator.OR.
      static Condition or​(Condition left, Condition right)
      Return a Condition that connects all argument conditions with Operator.OR.
      static WindowSpecificationRowsStep orderBy​(java.util.Collection<? extends OrderField<?>> fields)
      Create a WindowSpecification with an ORDER BY clause.
      static WindowSpecificationRowsStep orderBy​(Field<?>... fields)
      Create a WindowSpecification with an ORDER BY clause.
      static WindowSpecificationRowsStep orderBy​(OrderField<?>... fields)
      Create a WindowSpecification with an ORDER BY clause.
      static <T> Param<java.lang.Object> param()
      Create an unnamed parameter with a generic type (Object / SQLDataType.OTHER) and no initial value.
      static <T> Param<T> param​(java.lang.Class<T> type)
      Create an unnamed parameter with a defined type and no initial value.
      static Param<java.lang.Object> param​(java.lang.String name)
      Create a named parameter with a generic type (Object / SQLDataType.OTHER) and no initial value.
      static <T> Param<T> param​(java.lang.String name, java.lang.Class<T> type)
      Create a named parameter with a defined type and no initial value.
      static <T> Param<T> param​(java.lang.String name, DataType<T> type)
      Create a named parameter with a defined type and no initial value.
      static <T> Param<T> param​(java.lang.String name, Field<T> type)
      Create a named parameter with a defined type of another field and no initial value.
      static <T> Param<T> param​(java.lang.String name, T value)
      Create a named parameter with an initial value.
      static <T> Param<T> param​(DataType<T> type)
      Create an unnamed parameter with a defined type and no initial value.
      static <T> Param<T> param​(Field<T> field)
      Create an unnamed parameter with the defined type of another field and no initial value.
      static WindowSpecificationOrderByStep partitionBy​(java.util.Collection<? extends Field<?>> fields)
      Create a WindowSpecification with a PARTITION BY clause.
      static WindowSpecificationOrderByStep partitionBy​(Field<?>... fields)
      Create a WindowSpecification with a PARTITION BY clause.
      static OrderedAggregateFunction<java.math.BigDecimal> percentileCont​(java.lang.Number number)
      The percentile_cont([number]) within group (order by [column]) function.
      static OrderedAggregateFunction<java.math.BigDecimal> percentileCont​(Field<? extends java.lang.Number> field)
      The percentile_cont([number]) within group (order by [column]) function.
      static OrderedAggregateFunction<java.math.BigDecimal> percentileDisc​(java.lang.Number number)
      The percentile_disc([number]) within group (order by [column]) function.
      static OrderedAggregateFunction<java.math.BigDecimal> percentileDisc​(Field<? extends java.lang.Number> field)
      The percentile_disc([number]) within group (order by [column]) function.
      static WindowOverStep<java.math.BigDecimal> percentRank()
      The precent_rank() over ([analytic clause]) function.
      static OrderedAggregateFunction<java.lang.Integer> percentRank​(java.util.Collection<? extends Field<?>> fields)
      The percent_rank(expr) within group (order by [order clause]) ordered-set aggregate function.
      static OrderedAggregateFunction<java.lang.Integer> percentRank​(Field<?>... fields)
      The percent_rank(expr) within group (order by [order clause]) ordered-set aggregate function.
      static Field<java.math.BigDecimal> pi()
      The PI literal.
      static Field<java.lang.Integer> position​(java.lang.String in, java.lang.String search)
      Get the position(in, search) function.
      static Field<java.lang.Integer> position​(java.lang.String in, java.lang.String search, int startIndex)
      Get the position(in, search, startindex) function.
      static Field<java.lang.Integer> position​(java.lang.String in, java.lang.String search, Field<? extends java.lang.Number> startIndex)
      Get the position(in, search, startindex) function.
      static Field<java.lang.Integer> position​(java.lang.String in, Field<java.lang.String> search)
      Get the position(in, search) function.
      static Field<java.lang.Integer> position​(java.lang.String in, Field<java.lang.String> search, int startIndex)
      Get the position(in, search, startindex) function.
      static Field<java.lang.Integer> position​(java.lang.String in, Field<java.lang.String> search, Field<? extends java.lang.Number> startIndex)
      Get the position(in, search, startindex) function.
      static Field<java.lang.Integer> position​(Field<java.lang.String> in, java.lang.String search)
      Get the position(in, search) function.
      static Field<java.lang.Integer> position​(Field<java.lang.String> in, java.lang.String search, int startIndex)
      Get the position(in, search, startindex) function.
      static Field<java.lang.Integer> position​(Field<java.lang.String> in, java.lang.String search, Field<? extends java.lang.Number> startIndex)
      Get the position(in, search, startindex) function.
      static Field<java.lang.Integer> position​(Field<java.lang.String> in, Field<java.lang.String> search)
      Get the position(in, search) function.
      static Field<java.lang.Integer> position​(Field<java.lang.String> in, Field<java.lang.String> search, int startIndex)
      Get the position(in, search, startindex) function.
      static Field<java.lang.Integer> position​(Field<java.lang.String> in, Field<java.lang.String> search, Field<? extends java.lang.Number> startIndex)
      Get the position(in, search, startindex) function.
      static Field<java.math.BigDecimal> power​(java.lang.Number value, java.lang.Number exponent)
      Get the power(field, exponent) function.
      static Field<java.math.BigDecimal> power​(java.lang.Number value, Field<? extends java.lang.Number> exponent)
      Get the power(field, exponent) function.
      static Field<java.math.BigDecimal> power​(Field<? extends java.lang.Number> field, java.lang.Number exponent)
      Get the power(field, exponent) function.
      static Field<java.math.BigDecimal> power​(Field<? extends java.lang.Number> field, Field<? extends java.lang.Number> exponent)
      Get the power(field, exponent) function.
      static ConstraintFinalStep primaryKey​(java.lang.String... fields)
      Create an unnamed (system named) PRIMARY KEY constraint.
      static ConstraintFinalStep primaryKey​(Field<?>... fields)
      Create an unnamed (system named) PRIMARY KEY constraint.
      static ConstraintFinalStep primaryKey​(Name... fields)
      Create an unnamed (system named) PRIMARY KEY constraint.
      static <T> Field<T> prior​(Field<T> field)
      Add the Oracle-specific PRIOR unary operator before a field (to be used along with CONNECT BY clauses).
      static Privilege privilege​(java.lang.String privilege)
      Create a new privilege reference.
      static AggregateFunction<java.math.BigDecimal> product​(Field<? extends java.lang.Number> field)
      Get the product over a numeric field: product(field).
      static AggregateFunction<java.math.BigDecimal> productDistinct​(Field<? extends java.lang.Number> field)
      Get the sum over a numeric field: product(distinct field).
      static Field<java.lang.Integer> quarter​(java.time.temporal.Temporal value)
      Get the quarter of a date.
      static Field<java.lang.Integer> quarter​(java.util.Date value)
      Get the quarter of a date.
      static Field<java.lang.Integer> quarter​(Field<?> field)
      Get the quarter of a date.
      static Queries queries​(java.util.Collection<? extends Query> queries)
      Wrap a collection of queries.
      static Queries queries​(Query... queries)
      Wrap a collection of queries.
      static RowCountQuery query​(java.lang.String sql)
      Create a new query holding plain SQL.
      static RowCountQuery query​(java.lang.String sql, java.lang.Object... bindings)
      Create a new query holding plain SQL.
      static RowCountQuery query​(java.lang.String sql, QueryPart... parts)
      Create a new query holding plain SQL.
      static RowCountQuery query​(SQL sql)
      Create a new query holding plain SQL.
      static QueryPart queryPart​(java.lang.String sql)
      Deprecated.
      - 3.6.0 - [#3854] - Use sql(String) instead
      static QueryPart queryPart​(java.lang.String sql, java.lang.Object... bindings)
      Deprecated.
      - 3.6.0 - [#3854] - Use sql(String, Object...) instead
      static QueryPart queryPart​(java.lang.String sql, QueryPart... parts)
      Deprecated.
      - 3.6.0 - [#3854] - Use sql(String, QueryPart...) instead
      static Name quotedName​(java.lang.String unqualifiedName)
      Create a new SQL identifier using an unqualified, quoted name.
      static Name quotedName​(java.lang.String... qualifiedName)
      Create a new SQL identifier using a qualified, quoted name.
      static Name quotedName​(java.util.Collection<java.lang.String> qualifiedName)
      Create a new SQL identifier using a qualified, quoted name.
      static Field<java.math.BigDecimal> rad​(java.lang.Number value)
      Calculate radians from degrees from this field.
      static Field<java.math.BigDecimal> rad​(Field<? extends java.lang.Number> field)
      Calculate radians from degrees from this field.
      static Field<java.math.BigDecimal> rand()
      Get the rand() function.
      static WindowSpecificationRowsAndStep rangeBetweenCurrentRow()
      Create a WindowSpecification with a RANGE clause.
      static WindowSpecificationRowsAndStep rangeBetweenFollowing​(int number)
      Create a WindowSpecification with a RANGE clause.
      static WindowSpecificationRowsAndStep rangeBetweenPreceding​(int number)
      Create a WindowSpecification with a RANGE clause.
      static WindowSpecificationRowsAndStep rangeBetweenUnboundedFollowing()
      Create a WindowSpecification with a RANGE clause.
      static WindowSpecificationRowsAndStep rangeBetweenUnboundedPreceding()
      Create a WindowSpecification with a RANGE clause.
      static WindowSpecificationExcludeStep rangeCurrentRow()
      Create a WindowSpecification with a RANGE clause.
      static WindowSpecificationExcludeStep rangeFollowing​(int number)
      Create a WindowSpecification with a RANGE clause.
      static WindowSpecificationExcludeStep rangePreceding​(int number)
      Create a WindowSpecification with a RANGE clause.
      static WindowSpecificationExcludeStep rangeUnboundedFollowing()
      Create a WindowSpecification with a RANGE clause.
      static WindowSpecificationExcludeStep rangeUnboundedPreceding()
      Create a WindowSpecification with a RANGE clause.
      static WindowOverStep<java.lang.Integer> rank()
      The rank() over ([analytic clause]) function.
      static OrderedAggregateFunction<java.lang.Integer> rank​(java.util.Collection<? extends Field<?>> fields)
      The rank(expr) within group (order by [order clause]) ordered-set aggregate function.
      static OrderedAggregateFunction<java.lang.Integer> rank​(Field<?>... fields)
      The rank(expr) within group (order by [order clause]) ordered-set aggregate function.
      static WindowOverStep<java.math.BigDecimal> ratioToReport​(java.lang.Number number)
      The ratio_to_report([expression]) over ([analytic clause]) function.
      static WindowOverStep<java.math.BigDecimal> ratioToReport​(Field<? extends java.lang.Number> field)
      The ratio_to_report([expression]) over ([analytic clause]) function.
      static <T1> RecordType<Record> recordType​(java.util.Collection<? extends Field<?>> fields)
      Create a RecordType of an arbitrary degree.
      static <T1> RecordType<Record> recordType​(Field<?>[] fields)
      Create a RecordType of an arbitrary degree.
      static <T1> RecordType<Record1<T1>> recordType​(Field<T1> field1)
      Create a RecordType of degree 1.
      static <T1,​T2>
      RecordType<Record2<T1,​T2>>
      recordType​(Field<T1> field1, Field<T2> field2)
      Create a RecordType of degree 2.
      static <T1,​T2,​T3>
      RecordType<Record3<T1,​T2,​T3>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3)
      Create a RecordType of degree 3.
      static <T1,​T2,​T3,​T4>
      RecordType<Record4<T1,​T2,​T3,​T4>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
      Create a RecordType of degree 4.
      static <T1,​T2,​T3,​T4,​T5>
      RecordType<Record5<T1,​T2,​T3,​T4,​T5>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
      Create a RecordType of degree 5.
      static <T1,​T2,​T3,​T4,​T5,​T6>
      RecordType<Record6<T1,​T2,​T3,​T4,​T5,​T6>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
      Create a RecordType of degree 6.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7>
      RecordType<Record7<T1,​T2,​T3,​T4,​T5,​T6,​T7>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
      Create a RecordType of degree 7.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>
      RecordType<Record8<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
      Create a RecordType of degree 8.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>
      RecordType<Record9<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)
      Create a RecordType of degree 9.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>
      RecordType<Record10<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)
      Create a RecordType of degree 10.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>
      RecordType<Record11<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)
      Create a RecordType of degree 11.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
      RecordType<Record12<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)
      Create a RecordType of degree 12.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>
      RecordType<Record13<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)
      Create a RecordType of degree 13.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>
      RecordType<Record14<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)
      Create a RecordType of degree 14.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>
      RecordType<Record15<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)
      Create a RecordType of degree 15.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>
      RecordType<Record16<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)
      Create a RecordType of degree 16.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>
      RecordType<Record17<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)
      Create a RecordType of degree 17.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>
      RecordType<Record18<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)
      Create a RecordType of degree 18.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>
      RecordType<Record19<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)
      Create a RecordType of degree 19.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>
      RecordType<Record20<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)
      Create a RecordType of degree 20.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>
      RecordType<Record21<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)
      Create a RecordType of degree 21.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>
      RecordType<Record22<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>>
      recordType​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)
      Create a RecordType of degree 22.
      static AggregateFunction<java.math.BigDecimal> regrAvgX​(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)
      Get the REGR_AVGX linear regression function.
      static AggregateFunction<java.math.BigDecimal> regrAvgY​(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)
      Get the REGR_AVGY linear regression function.
      static AggregateFunction<java.math.BigDecimal> regrCount​(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)
      Get the REGR_COUNT linear regression function.
      static AggregateFunction<java.math.BigDecimal> regrIntercept​(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)
      Get the REGR_INTERCEPT linear regression function.
      static AggregateFunction<java.math.BigDecimal> regrR2​(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)
      Get the REGR_R2 linear regression function.
      static AggregateFunction<java.math.BigDecimal> regrSlope​(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)
      Get the REGR_SLOPE linear regression function.
      static AggregateFunction<java.math.BigDecimal> regrSXX​(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)
      Get the REGR_SXX linear regression function.
      static AggregateFunction<java.math.BigDecimal> regrSXY​(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)
      Get the REGR_SXY linear regression function.
      static AggregateFunction<java.math.BigDecimal> regrSYY​(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)
      Get the REGR_SYY linear regression function.
      static Field<java.lang.String> repeat​(java.lang.String field, int count)
      Get the repeat(field, count) function.
      static Field<java.lang.String> repeat​(java.lang.String field, Field<? extends java.lang.Number> count)
      Get the repeat(field, count) function.
      static RepeatUntilStep repeat​(java.util.Collection<? extends Statement> statements)
      Create a REPEAT loop for use in procedural code.
      static Field<java.lang.String> repeat​(Field<java.lang.String> field, int count)
      Get the repeat(count) function.
      static Field<java.lang.String> repeat​(Field<java.lang.String> field, Field<? extends java.lang.Number> count)
      Get the repeat(field, count) function.
      static RepeatUntilStep repeat​(Statement... statements)
      Create a REPEAT loop for use in procedural code.
      static Field<java.lang.String> replace​(Field<java.lang.String> field, java.lang.String search)
      Get the replace(field, search) function.
      static Field<java.lang.String> replace​(Field<java.lang.String> field, java.lang.String search, java.lang.String replace)
      Get the replace(field, search, replace) function.
      static Field<java.lang.String> replace​(Field<java.lang.String> field, Field<java.lang.String> search)
      Get the replace(field, search) function.
      static Field<java.lang.String> replace​(Field<java.lang.String> field, Field<java.lang.String> search, Field<java.lang.String> replace)
      Get the replace(field, search, replace) function.
      static ResultQuery<Record> resultQuery​(java.lang.String sql)
      Create a new query holding plain SQL.
      static ResultQuery<Record> resultQuery​(java.lang.String sql, java.lang.Object... bindings)
      Create a new query holding plain SQL.
      static ResultQuery<Record> resultQuery​(java.lang.String sql, QueryPart... parts)
      Create a new query holding plain SQL.
      static ResultQuery<Record> resultQuery​(SQL sql)
      Create a new query holding plain SQL.
      static Field<java.lang.String> reverse​(java.lang.String value)
      Get the reverse(field) function.
      static Field<java.lang.String> reverse​(Field<java.lang.String> field)
      Get the reverse(field) function.
      static RevokeOnStep revoke​(java.util.Collection<? extends Privilege> privileges)
      Revoke privileges on table from user or role.
      static RevokeOnStep revoke​(Privilege privilege)
      Revoke a privilege on table from user or role.
      static RevokeOnStep revoke​(Privilege... privileges)
      Revoke privileges on table from user or role.
      static RevokeOnStep revokeGrantOptionFor​(java.util.Collection<? extends Privilege> privileges)
      Revoke grant option for some privileges on a table from user or role.
      static RevokeOnStep revokeGrantOptionFor​(Privilege privilege)
      Revoke grant option for a privilege on a table from user or role.
      static RevokeOnStep revokeGrantOptionFor​(Privilege... privileges)
      Revoke grant option for some privileges on a table from user or role.
      static Field<java.lang.String> right​(java.lang.String field, int length)
      Get the right outermost characters from a string.
      static Field<java.lang.String> right​(java.lang.String field, Field<? extends java.lang.Number> length)
      Get the right outermost characters from a string.
      static Field<java.lang.String> right​(Field<java.lang.String> field, int length)
      Get the right outermost characters from a string.
      static Field<java.lang.String> right​(Field<java.lang.String> field, Field<? extends java.lang.Number> length)
      Get the right outermost characters from a string.
      static Role role​(java.lang.String name)
      Create a new role reference.
      static Role role​(Name name)
      Create a new role reference.
      static GroupField rollup​(Field<?>... fields)
      Create a ROLLUP(field1, field2, .., fieldn) grouping field.
      static GroupField rollup​(FieldOrRow... fields)
      Create a ROLLUP(field1, field2, .., fieldn) grouping field.
      static <T extends java.lang.Number>
      Field<T>
      round​(Field<T> field)
      Get rounded value of a numeric field: round(field).
      static <T extends java.lang.Number>
      Field<T>
      round​(Field<T> field, int decimals)
      Get rounded value of a numeric field: round(field, decimals).
      static <T extends java.lang.Number>
      Field<T>
      round​(T value)
      Get rounded value of a numeric field: round(field).
      static <T extends java.lang.Number>
      Field<T>
      round​(T value, int decimals)
      Get rounded value of a numeric field: round(field, decimals).
      static RowN row​(java.lang.Object... values)
      Create a row value expression of degree N > 22.
      static RowN row​(java.util.Collection<?> values)
      Create a row value expression of degree N > 22.
      static RowN row​(Field<?>... values)
      Create a row value expression of degree N > 22.
      static <T1> Row1<T1> row​(Field<T1> t1)
      Create a row value expression of degree 1.
      static <T1,​T2>
      Row2<T1,​T2>
      row​(Field<T1> t1, Field<T2> t2)
      Create a row value expression of degree 2.
      static <T1,​T2,​T3>
      Row3<T1,​T2,​T3>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3)
      Create a row value expression of degree 3.
      static <T1,​T2,​T3,​T4>
      Row4<T1,​T2,​T3,​T4>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4)
      Create a row value expression of degree 4.
      static <T1,​T2,​T3,​T4,​T5>
      Row5<T1,​T2,​T3,​T4,​T5>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5)
      Create a row value expression of degree 5.
      static <T1,​T2,​T3,​T4,​T5,​T6>
      Row6<T1,​T2,​T3,​T4,​T5,​T6>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6)
      Create a row value expression of degree 6.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7>
      Row7<T1,​T2,​T3,​T4,​T5,​T6,​T7>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7)
      Create a row value expression of degree 7.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>
      Row8<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8)
      Create a row value expression of degree 8.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>
      Row9<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9)
      Create a row value expression of degree 9.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>
      Row10<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
      Create a row value expression of degree 10.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>
      Row11<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11)
      Create a row value expression of degree 11.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
      Row12<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12)
      Create a row value expression of degree 12.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>
      Row13<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13)
      Create a row value expression of degree 13.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>
      Row14<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14)
      Create a row value expression of degree 14.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>
      Row15<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15)
      Create a row value expression of degree 15.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>
      Row16<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)
      Create a row value expression of degree 16.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>
      Row17<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17)
      Create a row value expression of degree 17.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>
      Row18<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18)
      Create a row value expression of degree 18.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>
      Row19<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)
      Create a row value expression of degree 19.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>
      Row20<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20)
      Create a row value expression of degree 20.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>
      Row21<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20, Field<T21> t21)
      Create a row value expression of degree 21.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>
      Row22<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>
      row​(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20, Field<T21> t21, Field<T22> t22)
      Create a row value expression of degree 22.
      static <T1> Row1<T1> row​(T1 t1)
      Create a row value expression of degree 1.
      static <T1,​T2>
      Row2<T1,​T2>
      row​(T1 t1, T2 t2)
      Create a row value expression of degree 2.
      static <T1,​T2,​T3>
      Row3<T1,​T2,​T3>
      row​(T1 t1, T2 t2, T3 t3)
      Create a row value expression of degree 3.
      static <T1,​T2,​T3,​T4>
      Row4<T1,​T2,​T3,​T4>
      row​(T1 t1, T2 t2, T3 t3, T4 t4)
      Create a row value expression of degree 4.
      static <T1,​T2,​T3,​T4,​T5>
      Row5<T1,​T2,​T3,​T4,​T5>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5)
      Create a row value expression of degree 5.
      static <T1,​T2,​T3,​T4,​T5,​T6>
      Row6<T1,​T2,​T3,​T4,​T5,​T6>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6)
      Create a row value expression of degree 6.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7>
      Row7<T1,​T2,​T3,​T4,​T5,​T6,​T7>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)
      Create a row value expression of degree 7.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>
      Row8<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8)
      Create a row value expression of degree 8.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>
      Row9<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9)
      Create a row value expression of degree 9.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>
      Row10<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
      Create a row value expression of degree 10.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>
      Row11<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11)
      Create a row value expression of degree 11.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
      Row12<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12)
      Create a row value expression of degree 12.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>
      Row13<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13)
      Create a row value expression of degree 13.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>
      Row14<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14)
      Create a row value expression of degree 14.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>
      Row15<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15)
      Create a row value expression of degree 15.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>
      Row16<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)
      Create a row value expression of degree 16.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>
      Row17<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17)
      Create a row value expression of degree 17.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>
      Row18<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18)
      Create a row value expression of degree 18.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>
      Row19<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)
      Create a row value expression of degree 19.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>
      Row20<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19, T20 t20)
      Create a row value expression of degree 20.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>
      Row21<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19, T20 t20, T21 t21)
      Create a row value expression of degree 21.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>
      Row22<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>
      row​(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19, T20 t20, T21 t21, T22 t22)
      Create a row value expression of degree 22.
      static <T1> Field<Record1<T1>> rowField​(Row1<T1> row)
      EXPERIMENTAL: Turn a row value expression of degree 1 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>
      Field<Record10<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>>
      rowField​(Row10<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10> row)
      EXPERIMENTAL: Turn a row value expression of degree 10 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>
      Field<Record11<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>>
      rowField​(Row11<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11> row)
      EXPERIMENTAL: Turn a row value expression of degree 11 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
      Field<Record12<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>>
      rowField​(Row12<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12> row)
      EXPERIMENTAL: Turn a row value expression of degree 12 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>
      Field<Record13<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>>
      rowField​(Row13<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13> row)
      EXPERIMENTAL: Turn a row value expression of degree 13 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>
      Field<Record14<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>>
      rowField​(Row14<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14> row)
      EXPERIMENTAL: Turn a row value expression of degree 14 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>
      Field<Record15<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>>
      rowField​(Row15<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15> row)
      EXPERIMENTAL: Turn a row value expression of degree 15 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>
      Field<Record16<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>>
      rowField​(Row16<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16> row)
      EXPERIMENTAL: Turn a row value expression of degree 16 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>
      Field<Record17<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>>
      rowField​(Row17<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17> row)
      EXPERIMENTAL: Turn a row value expression of degree 17 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>
      Field<Record18<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>>
      rowField​(Row18<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18> row)
      EXPERIMENTAL: Turn a row value expression of degree 18 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>
      Field<Record19<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>>
      rowField​(Row19<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19> row)
      EXPERIMENTAL: Turn a row value expression of degree 19 into a Field.
      static <T1,​T2>
      Field<Record2<T1,​T2>>
      rowField​(Row2<T1,​T2> row)
      EXPERIMENTAL: Turn a row value expression of degree 2 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>
      Field<Record20<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>>
      rowField​(Row20<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20> row)
      EXPERIMENTAL: Turn a row value expression of degree 20 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>
      Field<Record21<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>>
      rowField​(Row21<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21> row)
      EXPERIMENTAL: Turn a row value expression of degree 21 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>
      Field<Record22<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>>
      rowField​(Row22<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22> row)
      EXPERIMENTAL: Turn a row value expression of degree 22 into a Field.
      static <T1,​T2,​T3>
      Field<Record3<T1,​T2,​T3>>
      rowField​(Row3<T1,​T2,​T3> row)
      EXPERIMENTAL: Turn a row value expression of degree 3 into a Field.
      static <T1,​T2,​T3,​T4>
      Field<Record4<T1,​T2,​T3,​T4>>
      rowField​(Row4<T1,​T2,​T3,​T4> row)
      EXPERIMENTAL: Turn a row value expression of degree 4 into a Field.
      static <T1,​T2,​T3,​T4,​T5>
      Field<Record5<T1,​T2,​T3,​T4,​T5>>
      rowField​(Row5<T1,​T2,​T3,​T4,​T5> row)
      EXPERIMENTAL: Turn a row value expression of degree 5 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6>
      Field<Record6<T1,​T2,​T3,​T4,​T5,​T6>>
      rowField​(Row6<T1,​T2,​T3,​T4,​T5,​T6> row)
      EXPERIMENTAL: Turn a row value expression of degree 6 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7>
      Field<Record7<T1,​T2,​T3,​T4,​T5,​T6,​T7>>
      rowField​(Row7<T1,​T2,​T3,​T4,​T5,​T6,​T7> row)
      EXPERIMENTAL: Turn a row value expression of degree 7 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>
      Field<Record8<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>>
      rowField​(Row8<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8> row)
      EXPERIMENTAL: Turn a row value expression of degree 8 into a Field.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>
      Field<Record9<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>>
      rowField​(Row9<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9> row)
      EXPERIMENTAL: Turn a row value expression of degree 9 into a Field.
      static Field<Record> rowField​(RowN row)
      EXPERIMENTAL: Turn a row value expression of arbitrary degree into a Field.
      static Field<java.lang.Integer> rownum()
      Retrieve the Oracle-specific ROWNUM pseudo-field.
      static WindowOverStep<java.lang.Integer> rowNumber()
      The row_number() over ([analytic clause]) function.
      static WindowSpecificationRowsAndStep rowsBetweenCurrentRow()
      Create a WindowSpecification with a ROWS clause.
      static WindowSpecificationRowsAndStep rowsBetweenFollowing​(int number)
      Create a WindowSpecification with a ROWS clause.
      static WindowSpecificationRowsAndStep rowsBetweenPreceding​(int number)
      Create a WindowSpecification with a ROWS clause.
      static WindowSpecificationRowsAndStep rowsBetweenUnboundedFollowing()
      Create a WindowSpecification with a ROWS clause.
      static WindowSpecificationRowsAndStep rowsBetweenUnboundedPreceding()
      Create a WindowSpecification with a ROWS clause.
      static WindowSpecificationExcludeStep rowsCurrentRow()
      Create a WindowSpecification with a ROWS clause.
      static WindowSpecificationExcludeStep rowsFollowing​(int number)
      Create a WindowSpecification with a ROWS clause.
      static Table<Record> rowsFrom​(Table<?>... tables)
      Create a ROWS FROM (tables...) expression.
      static WindowSpecificationExcludeStep rowsPreceding​(int number)
      Create a WindowSpecification with a ROWS clause.
      static WindowSpecificationExcludeStep rowsUnboundedFollowing()
      Create a WindowSpecification with a ROWS clause.
      static WindowSpecificationExcludeStep rowsUnboundedPreceding()
      Create a WindowSpecification with a ROWS clause.
      static Field<java.lang.String> rpad​(Field<java.lang.String> field, int length)
      Get the rpad(field, length) function.
      static Field<java.lang.String> rpad​(Field<java.lang.String> field, int length, char character)
      Get the rpad(field, length, character) function.
      static Field<java.lang.String> rpad​(Field<java.lang.String> field, int length, java.lang.String character)
      Get the rpad(field, length, character) function.
      static Field<java.lang.String> rpad​(Field<java.lang.String> field, Field<? extends java.lang.Number> length)
      Get the rpad(field, length) function.
      static Field<java.lang.String> rpad​(Field<java.lang.String> field, Field<? extends java.lang.Number> length, Field<java.lang.String> character)
      Get the rpad(field, length, character) function.
      static Field<java.lang.String> rtrim​(java.lang.String value)
      Get the rtrim(field) function.
      static Field<java.lang.String> rtrim​(java.lang.String value, java.lang.String characters)
      Get the rtrim(field, characters) or trim(trailing characters from field) function.
      static Field<java.lang.String> rtrim​(Field<java.lang.String> field)
      Get the rtrim(field) function.
      static Field<java.lang.String> rtrim​(Field<java.lang.String> field, Field<java.lang.String> characters)
      Get the rtrim(field, characters) or trim(trailing characters from field) function.
      static Schema schema​(Name name)
      Create a qualified schema, given its schema name.
      static Schema schemaByName​(java.lang.String name)
      Deprecated.
      - [#3843] - 3.6.0 - use schema(Name) instead
      static Field<java.lang.Integer> second​(java.time.temporal.Temporal value)
      Get the second part of a date.
      static Field<java.lang.Integer> second​(java.util.Date value)
      Get the second part of a date.
      static Field<java.lang.Integer> second​(Field<?> field)
      Get the second part of a date.
      static SelectSelectStep<Record> select​(java.util.Collection<? extends SelectFieldOrAsterisk> fields)
      Create a new DSL subselect statement.
      static <T1> SelectSelectStep<Record1<T1>> select​(SelectField<T1> field1)
      Create a new DSL subselect statement.
      static <T1,​T2>
      SelectSelectStep<Record2<T1,​T2>>
      select​(SelectField<T1> field1, SelectField<T2> field2)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3>
      SelectSelectStep<Record3<T1,​T2,​T3>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4>
      SelectSelectStep<Record4<T1,​T2,​T3,​T4>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5>
      SelectSelectStep<Record5<T1,​T2,​T3,​T4,​T5>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6>
      SelectSelectStep<Record6<T1,​T2,​T3,​T4,​T5,​T6>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7>
      SelectSelectStep<Record7<T1,​T2,​T3,​T4,​T5,​T6,​T7>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>
      SelectSelectStep<Record8<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>
      SelectSelectStep<Record9<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>
      SelectSelectStep<Record10<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>
      SelectSelectStep<Record11<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
      SelectSelectStep<Record12<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>
      SelectSelectStep<Record13<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>
      SelectSelectStep<Record14<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>
      SelectSelectStep<Record15<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>
      SelectSelectStep<Record16<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>
      SelectSelectStep<Record17<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>
      SelectSelectStep<Record18<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>
      SelectSelectStep<Record19<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>
      SelectSelectStep<Record20<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>
      SelectSelectStep<Record21<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>
      SelectSelectStep<Record22<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>>
      select​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22)
      Create a new DSL subselect statement.
      static SelectSelectStep<Record> select​(SelectFieldOrAsterisk... fields)
      Create a new DSL subselect statement.
      static SelectSelectStep<Record1<java.lang.Integer>> selectCount()
      Create a new DSL subselect statement for COUNT(*).
      static SelectSelectStep<Record> selectDistinct​(java.util.Collection<? extends SelectFieldOrAsterisk> fields)
      Create a new DSL subselect statement.
      static <T1> SelectSelectStep<Record1<T1>> selectDistinct​(SelectField<T1> field1)
      Create a new DSL subselect statement.
      static <T1,​T2>
      SelectSelectStep<Record2<T1,​T2>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3>
      SelectSelectStep<Record3<T1,​T2,​T3>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4>
      SelectSelectStep<Record4<T1,​T2,​T3,​T4>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5>
      SelectSelectStep<Record5<T1,​T2,​T3,​T4,​T5>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6>
      SelectSelectStep<Record6<T1,​T2,​T3,​T4,​T5,​T6>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7>
      SelectSelectStep<Record7<T1,​T2,​T3,​T4,​T5,​T6,​T7>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>
      SelectSelectStep<Record8<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>
      SelectSelectStep<Record9<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>
      SelectSelectStep<Record10<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>
      SelectSelectStep<Record11<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
      SelectSelectStep<Record12<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>
      SelectSelectStep<Record13<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>
      SelectSelectStep<Record14<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>
      SelectSelectStep<Record15<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>
      SelectSelectStep<Record16<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>
      SelectSelectStep<Record17<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>
      SelectSelectStep<Record18<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>
      SelectSelectStep<Record19<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>
      SelectSelectStep<Record20<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>
      SelectSelectStep<Record21<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21)
      Create a new DSL subselect statement.
      static <T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>
      SelectSelectStep<Record22<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>>
      selectDistinct​(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22)
      Create a new DSL subselect statement.
      static SelectSelectStep<Record> selectDistinct​(SelectFieldOrAsterisk... fields)
      Create a new DSL subselect statement.
      static <R extends Record>
      SelectWhereStep<R>
      selectFrom​(java.lang.String sql)
      Create a new DSL select statement.
      static <R extends Record>
      SelectWhereStep<R>
      selectFrom​(java.lang.String sql, java.lang.Object... bindings)
      Create a new DSL select statement.
      static <R extends Record>
      SelectWhereStep<R>
      selectFrom​(java.lang.String sql, QueryPart... parts)
      Create a new DSL select statement.
      static <R extends Record>
      SelectWhereStep<R>
      selectFrom​(Name table)
      Create a new DSL select statement.
      static <R extends Record>
      SelectWhereStep<R>
      selectFrom​(SQL sql)
      Create a new DSL select statement.
      static <R extends Record>
      SelectWhereStep<R>
      selectFrom​(Table<R> table)
      Create a new DSL select statement.
      static SelectSelectStep<Record1<java.lang.Integer>> selectOne()
      Create a new DSL subselect statement for a constant 1 literal.
      static SelectSelectStep<Record1<java.lang.Integer>> selectZero()
      Create a new DSL subselect statement for a constant 0 literal.
      static Sequence<java.math.BigInteger> sequence​(java.lang.String sql)
      Deprecated.
      - 3.10 - [#6162] - Use sequence(Name) instead.
      static <T extends java.lang.Number>
      Sequence<T>
      sequence​(java.lang.String sql, java.lang.Class<T> type)
      Deprecated.
      - 3.10 - [#6162] - Use sequence(Name, Class) instead.
      static <T extends java.lang.Number>
      Sequence<T>
      sequence​(java.lang.String sql, DataType<T> type)
      Deprecated.
      - 3.10 - [#6162] - Use sequence(Name, DataType) instead.
      static Sequence<java.math.BigInteger> sequence​(Name name)
      Create a qualified sequence, given its sequence name.
      static <T extends java.lang.Number>
      Sequence<T>
      sequence​(Name name, java.lang.Class<T> type)
      Create a qualified sequence, given its sequence name.
      static <T extends java.lang.Number>
      Sequence<T>
      sequence​(Name name, DataType<T> type)
      Create a qualified sequence, given its sequence name.
      static <T extends java.lang.Number>
      Sequence<T>
      sequenceByName​(java.lang.Class<T> type, java.lang.String... qualifiedName)
      Deprecated.
      - [#3843] - 3.6.0 - use sequence(Name, Class) instead
      static Sequence<java.math.BigInteger> sequenceByName​(java.lang.String... qualifiedName)
      Deprecated.
      - [#3843] - 3.6.0 - use sequence(Name) instead
      static <T extends java.lang.Number>
      Sequence<T>
      sequenceByName​(DataType<T> type, java.lang.String... qualifiedName)
      Deprecated.
      - [#3843] - 3.6.0 - use sequence(Name, DataType) instead
      static RowCountQuery setCatalog​(java.lang.String catalog)
      Set the current catalog to a new value.
      static RowCountQuery setCatalog​(Catalog catalog)
      Set the current catalog to a new value.
      static RowCountQuery setCatalog​(Name catalog)
      Set the current catalog to a new value.
      static RowCountQuery setSchema​(java.lang.String schema)
      Set the current schema to a new value.
      static RowCountQuery setSchema​(Name schema)
      Set the current schema to a new value.
      static RowCountQuery setSchema​(Schema schema)
      Set the current schema to a new value.
      static <T extends java.lang.Number>
      Field<T>
      shl​(Field<T> value1, java.lang.Number value2)
      The bitwise left shift operator.
      static <T extends java.lang.Number>
      Field<T>
      shl​(Field<T> field1, Field<? extends java.lang.Number> field2)
      The bitwise left shift operator.
      static <T extends java.lang.Number>
      Field<T>
      shl​(T value1, java.lang.Number value2)
      The bitwise left shift operator.
      static <T extends java.lang.Number>
      Field<T>
      shl​(T value1, Field<? extends java.lang.Number> value2)
      The bitwise left shift operator.
      static <T extends java.lang.Number>
      Field<T>
      shr​(Field<T> value1, java.lang.Number value2)
      The bitwise right shift operator.
      static <T extends java.lang.Number>
      Field<T>
      shr​(Field<T> field1, Field<? extends java.lang.Number> field2)
      The bitwise right shift operator.
      static <T extends java.lang.Number>
      Field<T>
      shr​(T value1, java.lang.Number value2)
      The bitwise right shift operator.
      static <T extends java.lang.Number>
      Field<T>
      shr​(T value1, Field<? extends java.lang.Number> value2)
      The bitwise right shift operator.
      static Field<java.lang.Integer> sign​(java.lang.Number value)
      Get the sign of a numeric field: sign(field).
      static Field<java.lang.Integer> sign​(Field<? extends java.lang.Number> field)
      Get the sign of a numeric field: sign(field).
      static Field<java.math.BigDecimal> sin​(java.lang.Number value)
      Get the sine(field) function.
      static Field<java.math.BigDecimal> sin​(Field<? extends java.lang.Number> field)
      Get the sine(field) function.
      static Field<java.math.BigDecimal> sinh​(java.lang.Number value)
      Get the hyperbolic sine function: sinh(field).
      static Field<java.math.BigDecimal> sinh​(Field<? extends java.lang.Number> field)
      Get the hyperbolic sine function: sinh(field).
      static Field<java.lang.String> space​(int value)
      Get the SQL Server specific SPACE() function.
      static Field<java.lang.String> space​(Field<java.lang.Integer> value)
      Get the SQL Server specific SPACE() function.
      static SQL sql​(java.lang.String sql)
      A custom SQL clause that can render arbitrary expressions.
      static SQL sql​(java.lang.String sql, java.lang.Object... bindings)
      A custom SQL clause that can render arbitrary expressions.
      static SQL sql​(java.lang.String sql, QueryPart... parts)
      A custom SQL clause that can render arbitrary expressions.
      static Field<java.math.BigDecimal> sqrt​(java.lang.Number value)
      Get the sqrt(field) function.
      static Field<java.math.BigDecimal> sqrt​(Field<? extends java.lang.Number> field)
      Get the sqrt(field) function.
      static Block statements​(java.util.Collection<? extends Statement> statements)
      Wrap a collection of statements in an anonymous procedural block that does not wrap in BEGIN ..
      static Block statements​(Statement... statements)
      Wrap a collection of statements in an anonymous procedural block that does not wrap in BEGIN ..
      static AggregateFunction<java.math.BigDecimal> stddevPop​(Field<? extends java.lang.Number> field)
      Get the population standard deviation of a numeric field: stddev_pop(field).
      static AggregateFunction<java.math.BigDecimal> stddevSamp​(Field<? extends java.lang.Number> field)
      Get the sample standard deviation of a numeric field: stddev_samp(field).
      static Field<java.lang.String> substring​(Field<java.lang.String> field, int startingPosition)
      Get the substring(field, startingPosition) function.
      static Field<java.lang.String> substring​(Field<java.lang.String> field, int startingPosition, int length)
      Get the substring(field, startingPosition, length) function.
      static Field<java.lang.String> substring​(Field<java.lang.String> field, Field<? extends java.lang.Number> startingPosition)
      Get the substring(field, startingPosition) function.
      static Field<java.lang.String> substring​(Field<java.lang.String> field, Field<? extends java.lang.Number> startingPosition, Field<? extends java.lang.Number> length)
      Get the substring(field, startingPosition, length) function.
      static AggregateFunction<java.math.BigDecimal> sum​(Field<? extends java.lang.Number> field)
      Get the sum over a numeric field: sum(field).
      static AggregateFunction<java.math.BigDecimal> sumDistinct​(Field<? extends java.lang.Number> field)
      Get the sum over a numeric field: sum(distinct field).
      static Field<java.lang.String> sysConnectByPath​(Field<?> field, java.lang.String separator)
      Retrieve the Oracle-specific SYS_CONNECT_BY_PATH(field, separator) function (to be used along with CONNECT BY clauses).
      static Table<?> table​(java.lang.Object[] array)
      A synonym for unnest(Object[]).
      static Table<Record> table​(java.lang.String sql)
      A custom SQL clause that can render arbitrary table expressions.
      static Table<Record> table​(java.lang.String sql, java.lang.Object... bindings)
      A custom SQL clause that can render arbitrary table expressions.
      static Table<Record> table​(java.lang.String sql, QueryPart... parts)
      A custom SQL clause that can render arbitrary table expressions.
      static Table<?> table​(java.util.Collection<?> list)
      A synonym for unnest(Collection).
      static Table<?> table​(ArrayRecord<?> array)
      A synonym for unnest(ArrayRecord).
      static Table<?> table​(Field<?> cursor)
      A synonym for unnest(Field).
      static Table<Record> table​(Name name)
      Create a qualified table, given its table name.
      static Table<Record> table​(Name name, Comment comment)
      Create a qualified table, given its table name.
      static <R extends Record>
      Table<R>
      table​(Result<R> result)
      Use a previously obtained result as a new Table that can be used in SQL statements through values(RowN...).
      static <R extends Record>
      Table<R>
      table​(Select<R> select)
      A synonym for TableLike.asTable(), which might look a bit more fluent like this, to some users.
      static Table<Record> table​(SQL sql)
      A custom SQL clause that can render arbitrary table expressions.
      static <R extends Record>
      Table<R>
      table​(R record)
      Use a previously obtained record as a new Table
      static <R extends Record>
      Table<R>
      table​(R... records)
      Use a previously obtained set of records as a new Table
      static Table<Record> tableByName​(java.lang.String... qualifiedName)
      Deprecated.
      - [#3843] - 3.6.0 - use table(Name) instead
      static Field<java.math.BigDecimal> tan​(java.lang.Number value)
      Get the tangent(field) function.
      static Field<java.math.BigDecimal> tan​(Field<? extends java.lang.Number> field)
      Get the tangent(field) function.
      static Field<java.math.BigDecimal> tanh​(java.lang.Number value)
      Get the hyperbolic tangent function: tanh(field).
      static Field<java.math.BigDecimal> tanh​(Field<? extends java.lang.Number> field)
      Get the hyperbolic tangent function: tanh(field).
      static Field<java.sql.Time> time​(java.lang.String value)
      Convert a string value to a TIME.
      static Field<java.sql.Time> time​(java.util.Date value)
      Convert a temporal value to a TIME.
      static Field<java.sql.Time> time​(Field<? extends java.util.Date> field)
      Convert a temporal value to a TIME.
      static Field<java.sql.Timestamp> timestamp​(java.lang.String value)
      Convert a string value to a TIMESTAMP.
      static Field<java.sql.Timestamp> timestamp​(java.util.Date value)
      Convert a temporal value to a TIMESTAMP.
      static Field<java.sql.Timestamp> timestamp​(Field<? extends java.util.Date> field)
      Convert a temporal value to a TIMESTAMP.
      static Field<java.sql.Timestamp> timestampAdd​(java.sql.Timestamp timestamp, java.lang.Number interval)
      Add an interval to a timestamp.
      static Field<java.sql.Timestamp> timestampAdd​(java.sql.Timestamp date, java.lang.Number interval, DatePart datePart)
      Add an interval to a timestamp, given a date part.
      static Field<java.sql.Timestamp> timestampAdd​(java.sql.Timestamp date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Add an interval to a timestamp, given a date part.
      static Field<java.sql.Timestamp> timestampAdd​(Field<java.sql.Timestamp> date, java.lang.Number interval, DatePart datePart)
      Add an interval to a timestamp, given a date part.
      static Field<java.sql.Timestamp> timestampAdd​(Field<java.sql.Timestamp> timestamp, Field<? extends java.lang.Number> interval)
      Add an interval to a timestamp.
      static Field<java.sql.Timestamp> timestampAdd​(Field<java.sql.Timestamp> date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Add an interval to a timestamp, given a date part.
      static Field<DayToSecond> timestampDiff​(java.sql.Timestamp timestamp1, java.sql.Timestamp timestamp2)
      Get the timestamp difference as a INTERVAL DAY TO SECOND type.
      static Field<DayToSecond> timestampDiff​(java.sql.Timestamp timestamp1, Field<java.sql.Timestamp> timestamp2)
      Get the timestamp difference as a INTERVAL DAY TO SECOND type.
      static Field<DayToSecond> timestampDiff​(Field<java.sql.Timestamp> timestamp1, java.sql.Timestamp timestamp2)
      Get the timestamp difference as a INTERVAL DAY TO SECOND type.
      static Field<DayToSecond> timestampDiff​(Field<java.sql.Timestamp> timestamp1, Field<java.sql.Timestamp> timestamp2)
      Get the timestamp difference as a INTERVAL DAY TO SECOND type.
      static Field<java.sql.Timestamp> timestampSub​(java.sql.Timestamp timestamp, java.lang.Number interval)
      Subtract an interval from a timestamp.
      static Field<java.sql.Timestamp> timestampSub​(java.sql.Timestamp date, java.lang.Number interval, DatePart datePart)
      Subtract an interval from a timestamp, given a date part.
      static Field<java.sql.Timestamp> timestampSub​(java.sql.Timestamp date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Subtract an interval from a timestamp, given a date part.
      static Field<java.sql.Timestamp> timestampSub​(Field<java.sql.Timestamp> date, java.lang.Number interval, DatePart datePart)
      Subtract an interval from a timestamp, given a date part.
      static Field<java.sql.Timestamp> timestampSub​(Field<java.sql.Timestamp> timestamp, Field<? extends java.lang.Number> interval)
      Subtract an interval from a timestamp.
      static Field<java.sql.Timestamp> timestampSub​(Field<java.sql.Timestamp> date, Field<? extends java.lang.Number> interval, DatePart datePart)
      Subtract an interval from a timestamp, given a date part.
      static Field<java.lang.Integer> timezone​(java.time.temporal.Temporal value)
      Get the timezone part of a date.
      static Field<java.lang.Integer> timezone​(java.util.Date value)
      Get the timezone part of a date.
      static Field<java.lang.Integer> timezone​(Field<?> field)
      Get the timezone part of a date.
      static Field<java.lang.Integer> timezoneHour​(java.time.temporal.Temporal value)
      Get the timezoneHour part of a date.
      static Field<java.lang.Integer> timezoneHour​(java.util.Date value)
      Get the timezoneHour part of a date.
      static Field<java.lang.Integer> timezoneHour​(Field<?> field)
      Get the timezoneHour part of a date.
      static Field<java.lang.Integer> timezoneMinute​(java.time.temporal.Temporal value)
      Get the timezoneMinute part of a date.
      static Field<java.lang.Integer> timezoneMinute​(java.util.Date value)
      Get the timezoneMinute part of a date.
      static Field<java.lang.Integer> timezoneMinute​(Field<?> field)
      Get the timezoneMinute part of a date.
      static Field<java.sql.Date> toDate​(java.lang.String value, java.lang.String format)
      Parse a value to a DATE.
      static Field<java.sql.Date> toDate​(java.lang.String value, Field<java.lang.String> format)
      Parse a value to a DATE.
      static Field<java.sql.Date> toDate​(Field<java.lang.String> value, java.lang.String format)
      Parse a value to a DATE.
      static Field<java.sql.Date> toDate​(Field<java.lang.String> value, Field<java.lang.String> format)
      Parse a value to a DATE.
      static Field<java.time.LocalDate> toLocalDate​(java.lang.String value, java.lang.String format)
      Parse a value to a DATE.
      static Field<java.time.LocalDate> toLocalDate​(java.lang.String value, Field<java.lang.String> format)
      Parse a value to a DATE.
      static Field<java.time.LocalDate> toLocalDate​(Field<java.lang.String> value, java.lang.String format)
      Parse a value to a DATE.
      static Field<java.time.LocalDate> toLocalDate​(Field<java.lang.String> value, Field<java.lang.String> format)
      Parse a value to a DATE.
      static Field<java.time.LocalDateTime> toLocalDateTime​(java.lang.String value, java.lang.String format)
      Parse a value to a TIMESTAMP.
      static Field<java.time.LocalDateTime> toLocalDateTime​(java.lang.String value, Field<java.lang.String> format)
      Parse a value to a TIMESTAMP.
      static Field<java.time.LocalDateTime> toLocalDateTime​(Field<java.lang.String> value, java.lang.String format)
      Parse a value to a TIMESTAMP.
      static Field<java.time.LocalDateTime> toLocalDateTime​(Field<java.lang.String> value, Field<java.lang.String> format)
      Parse a value to a TIMESTAMP.
      static Field<java.sql.Timestamp> toTimestamp​(java.lang.String value, java.lang.String format)
      Parse a value to a TIMESTAMP.
      static Field<java.sql.Timestamp> toTimestamp​(java.lang.String value, Field<java.lang.String> format)
      Parse a value to a TIMESTAMP.
      static Field<java.sql.Timestamp> toTimestamp​(Field<java.lang.String> value, java.lang.String format)
      Parse a value to a TIMESTAMP.
      static Field<java.sql.Timestamp> toTimestamp​(Field<java.lang.String> value, Field<java.lang.String> format)
      Parse a value to a TIMESTAMP.
      static Field<java.lang.String> translate​(Field<java.lang.String> text, java.lang.String from, java.lang.String to)
      Get the translate(field, from, to) function.
      static Field<java.lang.String> translate​(Field<java.lang.String> text, Field<java.lang.String> from, Field<java.lang.String> to)
      Get the translate(field, from, to) function.
      static Field<java.lang.String> trim​(java.lang.String value)
      Get the trim(field) function.
      static Field<java.lang.String> trim​(java.lang.String value, java.lang.String characters)
      Get the trim(field, characters) or trim(both characters from field) function.
      static Field<java.lang.String> trim​(Field<java.lang.String> field)
      Get the trim(field) function.
      static Field<java.lang.String> trim​(Field<java.lang.String> field, Field<java.lang.String> characters)
      Get the trim(field, characters) or trim(both characters from field) function.
      static True trueCondition()
      Return a Condition that will always evaluate to true.
      static Field<java.sql.Date> trunc​(java.sql.Date date)
      Truncate a date to the beginning of the day.
      static Field<java.sql.Date> trunc​(java.sql.Date date, DatePart part)
      Truncate a date to a given datepart.
      static Field<java.sql.Timestamp> trunc​(java.sql.Timestamp timestamp)
      Truncate a timestamp to the beginning of the day.
      static Field<java.sql.Timestamp> trunc​(java.sql.Timestamp timestamp, DatePart part)
      Truncate a timestamp to a given datepart.
      static Field<java.time.LocalDate> trunc​(java.time.LocalDate date)
      Truncate a date to the beginning of the day.
      static Field<java.time.LocalDate> trunc​(java.time.LocalDate date, DatePart part)
      Truncate a date to a given datepart.
      static Field<java.time.LocalDateTime> trunc​(java.time.LocalDateTime timestamp)
      Truncate a timestamp to the beginning of the day.
      static Field<java.time.LocalDateTime> trunc​(java.time.LocalDateTime timestamp, DatePart part)
      Truncate a timestamp to a given datepart.
      static <T> Field<T> trunc​(Field<T> date)
      Truncate a date or a timestamp to the beginning of the day.
      static <T extends java.lang.Number>
      Field<T>
      trunc​(Field<T> number, int decimals)
      Truncate a number to a given number of decimals.
      static <T> Field<T> trunc​(Field<T> date, DatePart part)
      Truncate a date or a timestamp to a given datepart.
      static <T extends java.lang.Number>
      Field<T>
      trunc​(Field<T> number, Field<java.lang.Integer> decimals)
      Truncate a number to a given number of decimals.
      static <T extends java.lang.Number>
      Field<T>
      trunc​(T number)
      Truncate a number to a given number of decimals.
      static <T extends java.lang.Number>
      Field<T>
      trunc​(T number, int decimals)
      Truncate a number to a given number of decimals.
      static <T extends java.lang.Number>
      Field<T>
      trunc​(T number, Field<java.lang.Integer> decimals)
      Truncate a number to a given number of decimals.
      static TruncateIdentityStep<Record> truncate​(java.lang.String table)
      Create a new DSL truncate statement.
      static TruncateIdentityStep<Record> truncate​(Name table)
      Create a new DSL truncate statement.
      static <R extends Record>
      TruncateIdentityStep<R>
      truncate​(Table<R> table)
      Create a new DSL truncate statement.
      static TruncateIdentityStep<Record> truncateTable​(java.lang.String table)
      Create a new DSL truncate statement.
      static TruncateIdentityStep<Record> truncateTable​(Name table)
      Create a new DSL truncate statement.
      static <R extends Record>
      TruncateIdentityStep<R>
      truncateTable​(Table<R> table)
      Create a new DSL truncate statement.
      static Param<java.lang.Integer> two()
      A 2 literal.
      static ConstraintFinalStep unique​(java.lang.String... fields)
      Create an unnamed (system named) UNIQUE constraint.
      static ConstraintFinalStep unique​(Field<?>... fields)
      Create an unnamed (system named) UNIQUE constraint.
      static ConstraintFinalStep unique​(Name... fields)
      Create an unnamed (system named) UNIQUE constraint.
      static Condition unique​(Select<?> query)
      Create a unique condition.
      static Table<?> unnest​(java.lang.Object[] array)
      Create a table from an array of values.
      static Table<?> unnest​(java.util.Collection<?> list)
      Create a table from a list of values.
      static Table<?> unnest​(ArrayRecord<?> array)
      Create a table from an array of values.
      static Table<?> unnest​(Field<?> cursor)
      Create a table from a field.
      static Name unquotedName​(java.lang.String unqualifiedName)
      Create a new SQL identifier using an unqualified, quoted name.
      static Name unquotedName​(java.lang.String... qualifiedName)
      Create a new SQL identifier using a qualified, quoted name.
      static Name unquotedName​(java.util.Collection<java.lang.String> qualifiedName)
      Create a new SQL identifier using a qualified, quoted name.
      static <R extends Record>
      UpdateSetFirstStep<R>
      update​(Table<R> table)
      Create a new DSL update statement.
      static Field<java.lang.String> upper​(java.lang.String value)
      Get the upper(field) function.
      static Field<java.lang.String> upper​(Field<java.lang.String> field)
      Get the upper(field) function.
      static User user​(java.lang.String name)
      Create a new user reference.
      static User user​(Name name)
      Create a new user reference.
      static DSLContext using​(java.lang.String url)
      Create an executor from a JDBC connection URL.
      static DSLContext using​(java.lang.String url, java.lang.String username, java.lang.String password)
      Create an executor from a JDBC connection URL.
      static DSLContext using​(java.lang.String url, java.util.Properties properties)
      Create an executor from a JDBC connection URL.
      static DSLContext using​(java.sql.Connection connection)
      Create an executor with a connection configured.
      static DSLContext using​(java.sql.Connection connection, Settings settings)
      Create an executor with a connection, a dialect and settings configured.
      static DSLContext using​(java.sql.Connection connection, SQLDialect dialect)
      Create an executor with a connection and a dialect configured.
      static DSLContext using​(java.sql.Connection connection, SQLDialect dialect, Settings settings)
      Create an executor with a connection, a dialect and settings configured.
      static DSLContext using​(javax.sql.DataSource datasource, SQLDialect dialect)
      Create an executor with a data source and a dialect configured.
      static DSLContext using​(javax.sql.DataSource datasource, SQLDialect dialect, Settings settings)
      Create an executor with a data source, a dialect and settings configured.
      static DSLContext using​(Configuration configuration)
      Create an executor from a custom configuration.
      static DSLContext using​(ConnectionProvider connectionProvider, SQLDialect dialect)
      Create an executor with a custom connection provider and a dialect configured.
      static DSLContext using​(ConnectionProvider connectionProvider, SQLDialect dialect, Settings settings)
      Create an executor with a custom connection provider, a dialect and settings configured.
      static DSLContext using​(SQLDialect dialect)
      Create an executor with a dialect configured.
      static DSLContext using​(SQLDialect dialect, Settings settings)
      Create an executor with a dialect and settings configured.
      static Param<java.lang.Boolean> val​(boolean value)
      Get a bind value.
      static Param<java.lang.Byte> val​(byte value)
      Get a bind value.
      static Param<byte[]> val​(byte[] value)
      Get a bind value.
      static Param<java.lang.Double> val​(double value)
      Get a bind value.
      static Param<java.lang.Float> val​(float value)
      Get a bind value.
      static Param<java.lang.Integer> val​(int value)
      Get a bind value.
      static Param<java.lang.Long> val​(long value)
      Get a bind value.
      static Param<java.lang.Short> val​(short value)
      Get a bind value.
      static Param<java.lang.Boolean> val​(java.lang.Boolean value)
      Get a bind value.
      static Param<java.lang.Byte> val​(java.lang.Byte value)
      Get a bind value.
      static Param<java.lang.Double> val​(java.lang.Double value)
      Get a bind value.
      static Param<java.lang.Float> val​(java.lang.Float value)
      Get a bind value.
      static Param<java.lang.Integer> val​(java.lang.Integer value)
      Get a bind value.
      static Param<java.lang.Long> val​(java.lang.Long value)
      Get a bind value.
      static <T> Param<T> val​(java.lang.Object value, java.lang.Class<T> type)
      Get a bind value with an associated type, taken from a field.
      static <T> Param<T> val​(java.lang.Object value, DataType<T> type)
      Get a bind value with an associated type.
      static <T> Param<T> val​(java.lang.Object value, Field<T> field)
      Get a bind value with an associated type, taken from a field.
      static Param<java.lang.Short> val​(java.lang.Short value)
      Get a bind value.
      static Param<java.lang.String> val​(java.lang.String value)
      Get a bind value.
      static Param<java.math.BigDecimal> val​(java.math.BigDecimal value)
      Get a bind value.
      static Param<java.math.BigInteger> val​(java.math.BigInteger value)
      Get a bind value.
      static Param<java.sql.Date> val​(java.sql.Date value)
      Get a bind value.
      static Param<java.sql.Time> val​(java.sql.Time value)
      Get a bind value.
      static Param<java.sql.Timestamp> val​(java.sql.Timestamp value)
      Get a bind value.
      static Param<java.time.Instant> val​(java.time.Instant value)
      Get a bind value.
      static Param<java.time.LocalDate> val​(java.time.LocalDate value)
      Get a bind value.
      static Param<java.time.LocalDateTime> val​(java.time.LocalDateTime value)
      Get a bind value.
      static Param<java.time.LocalTime> val​(java.time.LocalTime value)
      Get a bind value.
      static Param<java.time.OffsetDateTime> val​(java.time.OffsetDateTime value)
      Get a bind value.
      static Param<java.time.OffsetTime> val​(java.time.OffsetTime value)
      Get a bind value.
      static Param<java.util.UUID> val​(java.util.UUID value)
      Get a bind value.
      static Param<UByte> val​(UByte value)
      Get a bind value.
      static Param<UInteger> val​(UInteger value)
      Get a bind value.
      static Param<ULong> val​(ULong value)
      Get a bind value.
      static Param<UShort> val​(UShort value)
      Get a bind value.
      static <T> Param<T> val​(T value)
      Get a bind value.
      static Param<java.lang.Boolean> value​(boolean value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.lang.Byte> value​(byte value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<byte[]> value​(byte[] value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.lang.Double> value​(double value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.lang.Float> value​(float value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.lang.Integer> value​(int value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.lang.Long> value​(long value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.lang.Short> value​(short value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.lang.Boolean> value​(java.lang.Boolean value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.lang.Byte> value​(java.lang.Byte value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.lang.Double> value​(java.lang.Double value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.lang.Float> value​(java.lang.Float value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.lang.Integer> value​(java.lang.Integer value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.lang.Long> value​(java.lang.Long value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static <T> Param<T> value​(java.lang.Object value, java.lang.Class<T> type)
      A synonym for val(Object, Class) to be used in Scala and Groovy, where val is a reserved keyword.
      static <T> Param<T> value​(java.lang.Object value, DataType<T> type)
      A synonym for val(Object, DataType) to be used in Scala and Groovy, where val is a reserved keyword.
      static <T> Param<T> value​(java.lang.Object value, Field<T> field)
      A synonym for val(Object, Field) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.lang.Short> value​(java.lang.Short value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.lang.String> value​(java.lang.String value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.math.BigDecimal> value​(java.math.BigDecimal value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.math.BigInteger> value​(java.math.BigInteger value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.sql.Date> value​(java.sql.Date value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.sql.Time> value​(java.sql.Time value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.sql.Timestamp> value​(java.sql.Timestamp value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.time.Instant> value​(java.time.Instant value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.time.LocalDate> value​(java.time.LocalDate value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.time.LocalDateTime> value​(java.time.LocalDateTime value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.time.LocalTime> value​(java.time.LocalTime value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.time.OffsetDateTime> value​(java.time.OffsetDateTime value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.time.OffsetTime> value​(java.time.OffsetTime value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<java.util.UUID> value​(java.util.UUID value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<UByte> value​(UByte value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<UInteger> value​(UInteger value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<ULong> value​(ULong value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static Param<UShort> value​(UShort value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static <T> Param<T> value​(T value)
      A synonym for val(Object) to be used in Scala and Groovy, where val is a reserved keyword.
      static <T1> Table<Record1<T1>> values