public class DSL extends Object
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(...));
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();
DSLContext
Modifier | Constructor and Description |
---|---|
protected |
DSL()
No instances.
|
Modifier and Type | Method and Description |
---|---|
static <T extends Number> |
abs(Field<T> field)
Get the absolute value of a numeric field: abs(field).
|
static <T extends Number> |
abs(T value)
Get the absolute value of a numeric field: abs(field).
|
static Field<BigDecimal> |
acos(Field<? extends Number> field)
Get the arc cosine(field) function.
|
static Field<BigDecimal> |
acos(Number value)
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 <R extends Record> |
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 AlterIndexStep |
alterIndex(Name index)
Create a new DSL
ALTER INDEX statement. |
static AlterIndexStep |
alterIndex(String index)
Create a new DSL
ALTER INDEX statement. |
static AlterIndexStep |
alterIndexIfExists(Name index)
Create a new DSL
ALTER INDEX statement. |
static AlterIndexStep |
alterIndexIfExists(String index)
Create a new DSL
ALTER INDEX 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 |
alterSchema(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 AlterSchemaStep |
alterSchemaIfExists(String schema)
Create a new DSL
ALTER SCHEMA statement. |
static AlterSequenceStep<BigInteger> |
alterSequence(Name sequence)
Create a new DSL
ALTER SEQUENCE statement. |
static <T extends Number> |
alterSequence(Sequence<T> sequence)
Create a new DSL
ALTER SEQUENCE statement. |
static AlterSequenceStep<BigInteger> |
alterSequence(String sequence)
Create a new DSL
ALTER SEQUENCE statement. |
static AlterSequenceStep<BigInteger> |
alterSequenceIfExists(Name sequence)
Create a new DSL
ALTER SEQUENCE statement. |
static <T extends Number> |
alterSequenceIfExists(Sequence<T> sequence)
Create a new DSL
ALTER SEQUENCE statement. |
static AlterSequenceStep<BigInteger> |
alterSequenceIfExists(String sequence)
Create a new DSL
ALTER SEQUENCE statement. |
static AlterTableStep |
alterTable(Name table)
Create a new DSL
ALTER TABLE statement. |
static AlterTableStep |
alterTable(String table)
Create a new DSL
ALTER TABLE statement. |
static AlterTableStep |
alterTable(Table<?> table)
Create a new DSL
ALTER TABLE statement. |
static AlterTableStep |
alterTableIfExists(Name table)
Create a new DSL
ALTER TABLE statement. |
static AlterTableStep |
alterTableIfExists(String table)
Create a new DSL
ALTER TABLE statement. |
static AlterTableStep |
alterTableIfExists(Table<?> table)
Create a new DSL
ALTER TABLE statement. |
static AlterViewStep |
alterView(Name view)
Create a new DSL
ALTER VIEW statement. |
static AlterViewStep |
alterView(String view)
Create a new DSL
ALTER VIEW statement. |
static AlterViewStep |
alterView(Table<?> view)
Create a new DSL
ALTER VIEW statement. |
static AlterViewStep |
alterViewIfExists(Name view)
Create a new DSL
ALTER VIEW statement. |
static AlterViewStep |
alterViewIfExists(String view)
Create a new DSL
ALTER VIEW statement. |
static AlterViewStep |
alterViewIfExists(Table<?> view)
Create a new DSL
ALTER VIEW statement. |
static Condition |
and(Collection<? extends Condition> conditions)
|
static Condition |
and(Condition... conditions)
|
static <T> QuantifiedSelect<Record1<T>> |
any(Field<T[]> array)
Create an
ANY quantified select to be used in quantified
comparison predicate expressions. |
static <R extends Record> |
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(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 Field<Integer> |
ascii(Field<String> field)
Get the ascii(field) function.
|
static Field<Integer> |
ascii(String field)
Get the ascii(field) function.
|
static Field<BigDecimal> |
asin(Field<? extends Number> field)
Get the arc sine(field) function.
|
static Field<BigDecimal> |
asin(Number value)
Get the arc sine(field) function.
|
static Field<BigDecimal> |
atan(Field<? extends Number> field)
Get the arc tangent(field) function.
|
static Field<BigDecimal> |
atan(Number value)
Get the arc tangent(field) function.
|
static Field<BigDecimal> |
atan2(Field<? extends Number> x,
Field<? extends Number> y)
Get the atan2(field, y) function.
|
static Field<BigDecimal> |
atan2(Field<? extends Number> x,
Number y)
Get the atan2(field, y) function.
|
static Field<BigDecimal> |
atan2(Number x,
Field<? extends Number> y)
Get the atan2(field, y) function.
|
static Field<BigDecimal> |
atan2(Number x,
Number y)
Get the atan2(field, y) function.
|
static AggregateFunction<BigDecimal> |
avg(Field<? extends Number> field)
Get the average over a numeric field: avg(field).
|
static AggregateFunction<BigDecimal> |
avgDistinct(Field<? extends Number> field)
Get the average over a numeric field: avg(distinct field).
|
static <T extends Number> |
bitAnd(Field<T> field1,
Field<T> field2)
The bitwise and operator.
|
static <T extends Number> |
bitAnd(Field<T> value1,
T value2)
The bitwise and operator.
|
static <T extends Number> |
bitAnd(T value1,
Field<T> value2)
The bitwise and operator.
|
static <T extends Number> |
bitAnd(T value1,
T value2)
The bitwise and operator.
|
static Field<Integer> |
bitCount(Field<? extends Number> field)
The MySQL
BIT_COUNT(field) function, counting the number of
bits that are set in this number. |
static Field<Integer> |
bitCount(Number value)
The MySQL
BIT_COUNT(field) function, counting the number of
bits that are set in this number. |
static Field<Integer> |
bitLength(Field<String> field)
Get the bit_length(field) function.
|
static Field<Integer> |
bitLength(String value)
Get the bit_length(field) function.
|
static <T extends Number> |
bitNand(Field<T> field1,
Field<T> field2)
The bitwise not and operator.
|
static <T extends Number> |
bitNand(Field<T> value1,
T value2)
The bitwise not and operator.
|
static <T extends Number> |
bitNand(T value1,
Field<T> value2)
The bitwise not and operator.
|
static <T extends Number> |
bitNand(T value1,
T value2)
The bitwise not and operator.
|
static <T extends Number> |
bitNor(Field<T> field1,
Field<T> field2)
The bitwise not or operator.
|
static <T extends Number> |
bitNor(Field<T> value1,
T value2)
The bitwise not or operator.
|
static <T extends Number> |
bitNor(T value1,
Field<T> value2)
The bitwise not or operator.
|
static <T extends Number> |
bitNor(T value1,
T value2)
The bitwise not or operator.
|
static <T extends Number> |
bitNot(Field<T> field)
The bitwise not operator.
|
static <T extends Number> |
bitNot(T value)
The bitwise not operator.
|
static <T extends Number> |
bitOr(Field<T> field1,
Field<T> field2)
The bitwise or operator.
|
static <T extends Number> |
bitOr(Field<T> value1,
T value2)
The bitwise or operator.
|
static <T extends Number> |
bitOr(T value1,
Field<T> value2)
The bitwise or operator.
|
static <T extends Number> |
bitOr(T value1,
T value2)
The bitwise or operator.
|
static <T extends Number> |
bitXNor(Field<T> field1,
Field<T> field2)
The bitwise not xor operator.
|
static <T extends Number> |
bitXNor(Field<T> value1,
T value2)
The bitwise not xor operator.
|
static <T extends Number> |
bitXNor(T value1,
Field<T> value2)
The bitwise not xor operator.
|
static <T extends Number> |
bitXNor(T value1,
T value2)
The bitwise not xor operator.
|
static <T extends Number> |
bitXor(Field<T> field1,
Field<T> field2)
The bitwise xor operator.
|
static <T extends Number> |
bitXor(Field<T> value1,
T value2)
The bitwise xor operator.
|
static <T extends Number> |
bitXor(T value1,
Field<T> value2)
The bitwise xor operator.
|
static <T extends Number> |
bitXor(T value1,
T value2)
The bitwise xor operator.
|
static AggregateFunction<Boolean> |
boolAnd(Condition condition)
Get the every value over a condition: bool_and(condition).
|
static AggregateFunction<Boolean> |
boolAnd(Field<Boolean> field)
Get the every value over a field: bool_and(field).
|
static AggregateFunction<Boolean> |
boolOr(Condition condition)
Get the every value over a condition: bool_and(condition).
|
static AggregateFunction<Boolean> |
boolOr(Field<Boolean> field)
Get the every value over a field: bool_and(field).
|
static <T> Field<T> |
cast(Field<?> field,
Class<T> type)
Cast a field to another type.
|
static <T> Field<T> |
cast(Field<?> field,
DataType<T> type)
Cast a field to another type.
|
static <T> Field<T> |
cast(Field<?> field,
Field<T> as)
Cast a field to the type of another field.
|
static <T> Field<T> |
cast(Object value,
Class<T> type)
Cast a value to another type.
|
static <T> Field<T> |
cast(Object value,
DataType<T> type)
Cast a value to another type.
|
static <T> Field<T> |
cast(Object value,
Field<T> as)
Cast a value to the type of another field.
|
static <T> Field<T> |
castNull(Class<T> type)
Cast null to a type.
|
static <T> Field<T> |
castNull(DataType<T> type)
Cast null to a type.
|
static <T> Field<T> |
castNull(Field<T> as)
Cast null to the type of another field.
|
static Catalog |
catalog(Name name)
Create a qualified catalog, given its catalog name.
|
static <T extends Number> |
ceil(Field<T> field)
Get the smallest integer value not less than [field].
|
static <T extends Number> |
ceil(T value)
Get the smallest integer value not less than [this].
|
static Field<Integer> |
charLength(Field<String> field)
Get the char_length(field) function.
|
static Field<Integer> |
charLength(String value)
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 <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(Field<?> field,
Class<T> as)
Coerce this field to another type.
|
static <T> Field<T> |
coerce(Field<?> field,
DataType<T> as)
Coerce a field to another type.
|
static <T> Field<T> |
coerce(Field<?> field,
Field<T> as)
Coerce this field to the type of another field.
|
static <T> Field<T> |
coerce(Object value,
Class<T> as)
Coerce this field to another type.
|
static <T> Field<T> |
coerce(Object value,
DataType<T> as)
Coerce a field to another type.
|
static <T> Field<T> |
coerce(Object value,
Field<T> as)
Coerce this field to the type of another field.
|
static <T,A extends ArrayRecord<T>> |
collect(Field<T> field,
Class<A> type)
Get the
collect() aggregate function. |
static <T,A extends ArrayRecord<T>> |
collect(Field<T> field,
DataType<A> type)
Get the
collect() aggregate function. |
static <T,A extends ArrayRecord<T>> |
collectDistinct(Field<T> field,
Class<A> type)
Get the
collect() aggregate function. |
static <T,A extends ArrayRecord<T>> |
collectDistinct(Field<T> field,
DataType<A> type)
Get the
collect() aggregate function. |
static Field<String> |
concat(Field<?>... fields)
Get the concat(field[, field, ...]) function.
|
static Field<String> |
concat(Field<String> field,
String value)
Get the
concat(field, value) function. |
static Field<String> |
concat(String... values)
Get the concat(value[, value, ...]) function.
|
static Field<String> |
concat(String value,
Field<String> field)
Get the
concat(value, field) function. |
static Condition |
condition(Boolean value)
Create a condition from a boolean field.
|
static Condition |
condition(Field<Boolean> field)
Create a condition from a boolean field.
|
static Condition |
condition(Map<Field<?>,?> map)
Create a condition from a map.
|
static Condition |
condition(Operator operator,
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(Record record)
|
static Condition |
condition(SQL sql)
Create a new condition holding plain SQL.
|
static Condition |
condition(String sql)
Create a new condition holding plain SQL.
|
static Condition |
condition(String sql,
Object... bindings)
Create a new condition holding plain SQL.
|
static Condition |
condition(String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary SQL elements.
|
static Field<Boolean> |
connectByIsCycle()
Retrieve the Oracle-specific
CONNECT_BY_ISCYCLE pseudo-field
(to be used along with CONNECT BY clauses). |
static Field<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(Name name)
Create a
CONSTRAINT specification. |
static ConstraintTypeStep |
constraint(String name)
Create a
CONSTRAINT specification. |
static Field<BigDecimal> |
cos(Field<? extends Number> field)
Get the cosine(field) function.
|
static Field<BigDecimal> |
cos(Number value)
Get the cosine(field) function.
|
static Field<BigDecimal> |
cosh(Field<? extends Number> field)
Get the hyperbolic cosine function: cosh(field).
|
static Field<BigDecimal> |
cosh(Number value)
Get the hyperbolic cosine function: cosh(field).
|
static Field<BigDecimal> |
cot(Field<? extends Number> field)
Get the cotangent(field) function.
|
static Field<BigDecimal> |
cot(Number value)
Get the cotangent(field) function.
|
static Field<BigDecimal> |
coth(Field<? extends Number> field)
Get the hyperbolic cotangent function: coth(field).
|
static Field<BigDecimal> |
coth(Number value)
Get the hyperbolic cotangent function: coth(field).
|
static AggregateFunction<Integer> |
count()
Get the count(*) function.
|
static AggregateFunction<Integer> |
count(Field<?> field)
Get the count(field) function.
|
static AggregateFunction<Integer> |
count(Table<?> table)
Get the count(table) function.
|
static AggregateFunction<Integer> |
countDistinct(Field<?>... fields)
Get the count(distinct field1, field2) function.
|
static AggregateFunction<Integer> |
countDistinct(Field<?> field)
Get the count(distinct field) function.
|
static AggregateFunction<Integer> |
countDistinct(Table<?> table)
Get the count(distinct table) function.
|
static CreateTableAsStep<Record> |
createGlobalTemporaryTable(Name table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
static CreateTableAsStep<Record> |
createGlobalTemporaryTable(String table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
static CreateTableAsStep<Record> |
createGlobalTemporaryTable(Table<?> table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
static CreateIndexStep |
createIndex(Name index)
Create a new DSL
CREATE INDEX statement. |
static CreateIndexStep |
createIndex(String index)
Create a new DSL
CREATE INDEX statement. |
static CreateIndexStep |
createIndexIfNotExists(Name index)
Create a new DSL
CREATE INDEX IF NOT EXISTS statement. |
static CreateIndexStep |
createIndexIfNotExists(String index)
Create a new DSL
CREATE INDEX IF NOT EXISTS statement. |
static CreateSchemaFinalStep |
createSchema(Name table)
Create a new DSL
CREATE SCHEMA statement. |
static CreateSchemaFinalStep |
createSchema(Schema schema)
Create a new DSL
CREATE SCHEMA statement. |
static CreateSchemaFinalStep |
createSchema(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 CreateSchemaFinalStep |
createSchemaIfNotExists(String schema)
Create a new DSL
CREATE SCHEMA statement. |
static CreateSequenceFinalStep |
createSequence(Name sequence)
Create a new DSL
CREATE SEQUENCE statement. |
static CreateSequenceFinalStep |
createSequence(Sequence<?> sequence)
Create a new DSL
CREATE SEQUENCE statement. |
static CreateSequenceFinalStep |
createSequence(String sequence)
Create a new DSL
CREATE SEQUENCE statement. |
static CreateSequenceFinalStep |
createSequenceIfNotExists(Name sequence)
Create a new DSL
CREATE SEQUENCE IF NOT EXISTS statement. |
static CreateSequenceFinalStep |
createSequenceIfNotExists(Sequence<?> sequence)
Create a new DSL
CREATE SEQUENCE IF NOT EXISTS statement. |
static CreateSequenceFinalStep |
createSequenceIfNotExists(String sequence)
Create a new DSL
CREATE SEQUENCE IF NOT EXISTS statement. |
static CreateTableAsStep<Record> |
createTable(Name table)
Create a new DSL
CREATE TABLE statement. |
static CreateTableAsStep<Record> |
createTable(String table)
Create a new DSL
CREATE TABLE statement. |
static CreateTableAsStep<Record> |
createTable(Table<?> table)
Create a new DSL
CREATE TABLE statement. |
static CreateTableAsStep<Record> |
createTableIfNotExists(Name table)
Create a new DSL
CREATE TABLE statement. |
static CreateTableAsStep<Record> |
createTableIfNotExists(String table)
Create a new DSL
CREATE TABLE statement. |
static CreateTableAsStep<Record> |
createTableIfNotExists(Table<?> table)
Create a new DSL
CREATE TABLE statement. |
static CreateTableAsStep<Record> |
createTemporaryTable(Name table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
static CreateTableAsStep<Record> |
createTemporaryTable(String table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
static CreateTableAsStep<Record> |
createTemporaryTable(Table<?> table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
static CreateIndexStep |
createUniqueIndex(Name index)
Create a new DSL
CREATE UNIQUE INDEX statement. |
static CreateIndexStep |
createUniqueIndex(String index)
Create a new DSL
CREATE UNIQUE INDEX statement. |
static CreateIndexStep |
createUniqueIndexIfNotExists(Name index)
Create a new DSL
CREATE UNIQUE INDEX IF NOT EXISTS statement. |
static CreateIndexStep |
createUniqueIndexIfNotExists(String index)
Create a new DSL
CREATE UNIQUE INDEX IF NOT EXISTS 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(String view,
java.util.function.Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
static CreateViewAsStep |
createView(String view,
String... fields)
Create a new DSL
CREATE VIEW statement. |
static CreateViewAsStep |
createView(Table<?> view,
Field<?>... 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 |
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(String view,
java.util.function.Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSL
CREATE VIEW IF NOT EXISTS statement. |
static CreateViewAsStep |
createViewIfNotExists(String view,
String... fields)
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 CreateViewAsStep |
createViewIfNotExists(Table<?> view,
java.util.function.Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
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<BigDecimal> |
cumeDist()
The
cume_dist() over ([analytic clause]) function. |
static OrderedAggregateFunction<BigDecimal> |
cumeDist(Field<?>... fields)
The
cume_dist(expr) within group (order by [order clause])
ordered-set aggregate function. |
static Field<Date> |
currentDate()
Get the current_date() function.
|
static Field<java.time.LocalDate> |
currentLocalDate()
Get the current_date() function.
|
static Field<java.time.LocalDateTime> |
currentLocalDateTime()
Get the current_timestamp() function.
|
static Field<java.time.LocalTime> |
currentLocalTime()
Get the current_time() function.
|
static Field<java.time.OffsetDateTime> |
currentOffsetDateTime()
Get the current_timestamp() function.
|
static Field<java.time.OffsetTime> |
currentOffsetTime()
Get the current_time() function.
|
static Field<String> |
currentSchema()
Get the
current_schema() function. |
static Field<Time> |
currentTime()
Get the current_time() function.
|
static Field<Timestamp> |
currentTimestamp()
Get the current_timestamp() function.
|
static Field<String> |
currentUser()
Get the
current_user() function. |
static Field<Date> |
date(Date value)
Convert a temporal value to a
DATE . |
static Field<Date> |
date(Field<? extends Date> field)
Convert a temporal value to a
DATE . |
static Field<Date> |
date(String value)
Convert a string value to a
DATE . |
static Field<Date> |
dateAdd(Date date,
Field<? extends Number> interval,
DatePart datePart)
Add an interval to a date, given a date part.
|
static Field<Date> |
dateAdd(Date date,
Number interval)
Add an interval to a date.
|
static Field<Date> |
dateAdd(Date date,
Number interval,
DatePart datePart)
Add an interval to a date, given a date part.
|
static Field<Date> |
dateAdd(Field<Date> date,
Field<? extends Number> interval)
Add an interval to a date.
|
static Field<Date> |
dateAdd(Field<Date> date,
Field<? extends Number> interval,
DatePart datePart)
Add an interval to a date, given a date part.
|
static Field<Date> |
dateAdd(Field<Date> date,
Number interval,
DatePart datePart)
Add an interval to a date, given a date part.
|
static Field<Integer> |
dateDiff(Date date1,
Date date2)
Get the date difference in number of days.
|
static Field<Integer> |
dateDiff(Date date1,
Field<Date> date2)
Get the date difference in number of days.
|
static Field<Integer> |
dateDiff(Field<Date> date1,
Date date2)
Get the date difference in number of days.
|
static Field<Integer> |
dateDiff(Field<Date> date1,
Field<Date> date2)
Get the date difference in number of days.
|
static Field<Date> |
dateSub(Date date,
Field<? extends Number> interval,
DatePart datePart)
Subtract an interval from a date, given a date part.
|
static Field<Date> |
dateSub(Date date,
Number interval)
Subtract an interval from a date.
|
static Field<Date> |
dateSub(Date date,
Number interval,
DatePart datePart)
Subtract an interval from a date, given a date part.
|
static Field<Date> |
dateSub(Field<Date> date,
Field<? extends Number> interval)
Subtract an interval from a date.
|
static Field<Date> |
dateSub(Field<Date> date,
Field<? extends Number> interval,
DatePart datePart)
Subtract an interval from a date, given a date part.
|
static Field<Date> |
dateSub(Field<Date> date,
Number interval,
DatePart datePart)
Subtract an interval from a date, given a date part.
|
static Field<Integer> |
day(Date value)
Get the day part of a date.
|
static Field<Integer> |
day(Field<?> field)
Get the day part of a date.
|
static Field<Integer> |
day(java.time.temporal.Temporal value)
Get the day part of a date.
|
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,
Object... more)
Gets the Oracle-style
DECODE(expression, search, result[, search , result]... [, default])
function. |
static Field<Object> |
defaultValue()
Create a
DEFAULT keyword for use with INSERT ,
UPDATE , or MERGE statements. |
static <T> Field<T> |
defaultValue(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<BigDecimal> |
deg(Field<? extends Number> field)
Calculate degrees from radians from this field.
|
static Field<BigDecimal> |
deg(Number value)
Calculate degrees from radians from this field.
|
static <R extends Record> |
delete(Table<R> table)
Create a new DSL delete statement.
|
static <R extends Record> |
deleteFrom(Table<R> table)
Create a new DSL delete statement.
|
static WindowOverStep<Integer> |
denseRank()
The
dense_rank() over ([analytic clause]) function. |
static OrderedAggregateFunction<Integer> |
denseRank(Field<?>... fields)
The
dense_rank(expr) within group (order by [order clause])
ordered-set aggregate function. |
static DropIndexOnStep |
dropIndex(Name index)
Create a new DSL
DROP INDEX statement. |
static DropIndexOnStep |
dropIndex(String index)
Create a new DSL
DROP INDEX statement. |
static DropIndexOnStep |
dropIndexIfExists(Name index)
Create a new DSL
DROP INDEX IF EXISTS statement. |
static DropIndexOnStep |
dropIndexIfExists(String index)
Create a new DSL
DROP INDEX IF EXISTS 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 |
dropSchema(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 DropSchemaStep |
dropSchemaIfExists(String schema)
Create a new DSL
DROP SCHEMA statement. |
static <T extends Number> |
dropSequence(Name sequence)
Create a new DSL
DROP SEQUENCE statement. |
static <T extends Number> |
dropSequence(Sequence<?> sequence)
Create a new DSL
DROP SEQUENCE statement. |
static <T extends Number> |
dropSequence(String sequence)
Create a new DSL
DROP SEQUENCE statement. |
static <T extends Number> |
dropSequenceIfExists(Name sequence)
Create a new DSL
DROP SEQUENCE IF EXISTS statement. |
static <T extends Number> |
dropSequenceIfExists(Sequence<?> sequence)
Create a new DSL
DROP SEQUENCE IF EXISTS statement. |
static <T extends Number> |
dropSequenceIfExists(String sequence)
Create a new DSL
DROP SEQUENCE IF EXISTS statement. |
static DropTableStep |
dropTable(Name table)
Create a new DSL
DROP TABLE statement. |
static DropTableStep |
dropTable(String table)
Create a new DSL
DROP TABLE statement. |
static DropTableStep |
dropTable(Table<?> table)
Create a new DSL
DROP TABLE statement. |
static DropTableStep |
dropTableIfExists(Name table)
Create a new DSL
DROP TABLE IF EXISTS statement. |
static DropTableStep |
dropTableIfExists(String 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 DropViewFinalStep |
dropView(Name view)
Create a new DSL
DROP VIEW statement. |
static DropViewFinalStep |
dropView(String view)
Create a new DSL
DROP VIEW statement. |
static DropViewFinalStep |
dropView(Table<?> view)
Create a new DSL
DROP VIEW statement. |
static DropViewFinalStep |
dropViewIfExists(Name view)
Create a new DSL
DROP VIEW IF EXISTS statement. |
static DropViewFinalStep |
dropViewIfExists(String 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<BigDecimal> |
e()
The
E literal (Euler number). |
static Field<String> |
escape(Field<String> field,
char escape)
Convenience method for
replace(Field, String, String) to escape
data for use with Field.like(Field, char) . |
static String |
escape(String value,
char escape)
Convenience method for
replace(Field, String, String) to escape
data for use with Field.like(Field, char) . |
static AggregateFunction<Boolean> |
every(Condition condition)
Get the every value over a condition: every(condition).
|
static AggregateFunction<Boolean> |
every(Field<Boolean> field)
Get the every value over a field: every(field).
|
static Condition |
exists(Select<?> query)
Create an exists condition.
|
static Field<BigDecimal> |
exp(Field<? extends Number> field)
Get the exp(field) function, taking this field as the power of e.
|
static Field<BigDecimal> |
exp(Number value)
Get the exp(field) function, taking this field as the power of e.
|
static Field<Integer> |
extract(Date value,
DatePart datePart)
Get the extract(field, datePart) function.
|
static Field<Integer> |
extract(Field<?> field,
DatePart datePart)
Get the extract(field, datePart) function.
|
static Field<Integer> |
extract(java.time.temporal.Temporal value,
DatePart datePart)
Get the extract(field, datePart) function.
|
static Condition |
falseCondition()
Return a
Condition that will always evaluate to false. |
static Field<Boolean> |
field(Condition condition)
Transform a condition into a boolean field.
|
static Field<Object> |
field(Name name)
Create a qualified field, given its (qualified) field name.
|
static <T> Field<T> |
field(Name name,
Class<T> type)
Create a qualified field, given its (qualified) field name.
|
static <T> Field<T> |
field(Name name,
DataType<T> type)
Create a qualified field, given its (qualified) field name.
|
static <T> Field<T> |
field(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<Object> |
field(SQL sql)
Create a "plain SQL" field.
|
static <T> Field<T> |
field(SQL sql,
Class<T> type)
Create a "plain SQL" field.
|
static <T> Field<T> |
field(SQL sql,
DataType<T> type)
Create a "plain SQL" field.
|
static Field<Object> |
field(String sql)
Create a "plain SQL" field.
|
static <T> Field<T> |
field(String sql,
Class<T> type)
Create a "plain SQL" field.
|
static <T> Field<T> |
field(String sql,
Class<T> type,
Object... bindings)
Create a "plain SQL" field.
|
static <T> Field<T> |
field(String sql,
Class<T> type,
QueryPart... parts)
A custom SQL clause that can render arbitrary SQL elements.
|
static <T> Field<T> |
field(String sql,
DataType<T> type)
Create a "plain SQL" field.
|
static <T> Field<T> |
field(String sql,
DataType<T> type,
Object... bindings)
Create a "plain SQL" field.
|
static <T> Field<T> |
field(String sql,
DataType<T> type,
QueryPart... parts)
Create a "plain SQL" field.
|
static Field<Object> |
field(String sql,
Object... bindings)
Create a "plain SQL" field.
|
static Field<Object> |
field(String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary SQL elements.
|
static <T> Field<T> |
fieldByName(Class<T> type,
String... qualifiedName)
Deprecated.
- [#3843] - 3.6.0 - use
field(Name, Class) instead |
static <T> Field<T> |
fieldByName(DataType<T> type,
String... qualifiedName)
Deprecated.
- [#3843] - 3.6.0 - use
field(Name, DataType) instead |
static Field<Object> |
fieldByName(String... qualifiedName)
Deprecated.
- [#3843] - 3.6.0 - use
field(Name) instead |
static <T> WindowIgnoreNullsStep<T> |
firstValue(Field<T> field)
The
first_value(field) over ([analytic clause]) function. |
static <T extends Number> |
floor(Field<T> field)
Get the largest integer value not greater than [this].
|
static <T extends Number> |
floor(T value)
Get the largest integer value not greater than [this].
|
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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 ConstraintForeignKeyReferencesStepN |
foreignKey(String... fields)
Add a
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep1<?> |
foreignKey(String field1)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep2<?,?> |
foreignKey(String field1,
String field2)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep3<?,?,?> |
foreignKey(String field1,
String field2,
String field3)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep4<?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep5<?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep6<?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep7<?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep8<?,?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7,
String field8)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep9<?,?,?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7,
String field8,
String field9)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep10<?,?,?,?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7,
String field8,
String field9,
String field10)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep11<?,?,?,?,?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7,
String field8,
String field9,
String field10,
String field11)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep12<?,?,?,?,?,?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7,
String field8,
String field9,
String field10,
String field11,
String field12)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep13<?,?,?,?,?,?,?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7,
String field8,
String field9,
String field10,
String field11,
String field12,
String field13)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep14<?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7,
String field8,
String field9,
String field10,
String field11,
String field12,
String field13,
String field14)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7,
String field8,
String field9,
String field10,
String field11,
String field12,
String field13,
String field14,
String field15)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7,
String field8,
String field9,
String field10,
String field11,
String field12,
String field13,
String field14,
String field15,
String field16)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7,
String field8,
String field9,
String field10,
String field11,
String field12,
String field13,
String field14,
String field15,
String field16,
String field17)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7,
String field8,
String field9,
String field10,
String field11,
String field12,
String field13,
String field14,
String field15,
String field16,
String field17,
String field18)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7,
String field8,
String field9,
String field10,
String field11,
String field12,
String field13,
String field14,
String field15,
String field16,
String field17,
String field18,
String field19)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7,
String field8,
String field9,
String field10,
String field11,
String field12,
String field13,
String field14,
String field15,
String field16,
String field17,
String field18,
String field19,
String field20)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7,
String field8,
String field9,
String field10,
String field11,
String field12,
String field13,
String field14,
String field15,
String field16,
String field17,
String field18,
String field19,
String field20,
String field21)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static ConstraintForeignKeyReferencesStep22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
foreignKey(String field1,
String field2,
String field3,
String field4,
String field5,
String field6,
String field7,
String field8,
String field9,
String field10,
String field11,
String field12,
String field13,
String field14,
String field15,
String field16,
String field17,
String field18,
String field19,
String field20,
String field21,
String field22)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT . |
static <T> Field<T> |
function(Name name,
Class<T> type,
Field<?>... arguments)
function() can be used to access native or user-defined
functions that are not yet or insufficiently supported by jOOQ. |
static <T> Field<T> |
function(Name name,
DataType<T> type,
Field<?>... arguments)
function() can be used to access native or user-defined
functions that are not yet or insufficiently supported by jOOQ. |
static <T> Field<T> |
function(String name,
Class<T> type,
Field<?>... arguments)
function() can be used to access native or user-defined
functions that are not yet or insufficiently supported by jOOQ. |
static <T> Field<T> |
function(String name,
DataType<T> type,
Field<?>... arguments)
function() can be used to access native or user-defined
functions that are not yet or insufficiently supported by jOOQ. |
static Table<Record1<Integer>> |
generateSeries(Field<Integer> from,
Field<Integer> to)
A table function generating a series of values from
from to
to (inclusive). |
static Table<Record1<Integer>> |
generateSeries(Field<Integer> from,
int to)
A table function generating a series of values from
from to
to (inclusive). |
static Table<Record1<Integer>> |
generateSeries(int from,
Field<Integer> to)
A table function generating a series of values from
from to
to (inclusive). |
static Table<Record1<Integer>> |
generateSeries(int from,
int to)
A table function generating a series of values from
from to
to (inclusive). |
static <T> DataType<T> |
getDataType(Class<T> type)
Get the default data type for the
DSLContext 's underlying
SQLDialect and a given Java type. |
static <T> Field<T> |
greatest(Field<T> field,
Field<?>... others)
Find the greatest among all values.
|
static <T> Field<T> |
greatest(T value,
T... values)
Find the greatest among all values.
|
static GroupConcatOrderByStep |
groupConcat(Field<?> field)
Get the aggregated concatenation for a field.
|
static AggregateFunction<String> |
groupConcat(Field<?> field,
String separator)
Get the aggregated concatenation for a field.
|
static GroupConcatOrderByStep |
groupConcatDistinct(Field<?> field)
Get the aggregated concatenation for a field.
|
static Field<Integer> |
grouping(Field<?> field)
Create a GROUPING(field) aggregation field to be used along with
CUBE , ROLLUP , and GROUPING SETS
groupings. |
static Field<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(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 Field<Integer> |
hour(Date value)
Get the hour part of a date.
|
static Field<Integer> |
hour(Field<?> field)
Get the hour part of a date.
|
static Field<Integer> |
hour(java.time.temporal.Temporal value)
Get the hour part of a date.
|
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 Param<BigDecimal> |
inline(BigDecimal value)
Create a bind value that is always inlined.
|
static Param<BigInteger> |
inline(BigInteger value)
Create a bind value that is always inlined.
|
static Param<Boolean> |
inline(boolean value)
Create a bind value that is always inlined.
|
static Param<Boolean> |
inline(Boolean value)
Create a bind value that is always inlined.
|
static Param<Byte> |
inline(byte value)
Create a bind value that is always inlined.
|
static Param<Byte> |
inline(Byte value)
Create a bind value that is always inlined.
|
static Param<byte[]> |
inline(byte[] value)
Create a bind value that is always inlined.
|
static Param<String> |
inline(char character)
Create a bind value, that is always inlined.
|
static Param<String> |
inline(Character character)
Create a bind value, that is always inlined.
|
static Param<String> |
inline(CharSequence character)
Create a bind value, that is always inlined.
|
static Param<Date> |
inline(Date value)
Create a bind value that is always inlined.
|
static Param<Double> |
inline(double value)
Create a bind value that is always inlined.
|
static Param<Double> |
inline(Double value)
Create a bind value that is always inlined.
|
static Param<Float> |
inline(float value)
Create a bind value that is always inlined.
|
static Param<Float> |
inline(Float value)
Create a bind value that is always inlined.
|
static Param<Integer> |
inline(int value)
Create a bind value that is always inlined.
|
static Param<Integer> |
inline(Integer 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<Long> |
inline(long value)
Create a bind value that is always inlined.
|
static Param<Long> |
inline(Long value)
Create a bind value that is always inlined.
|
static <T> Param<T> |
inline(Object value,
Class<T> type)
Create a bind value, that is always inlined.
|
static <T> Param<T> |
inline(Object value,
DataType<T> type)
Create a bind value, that is always inlined.
|
static <T> Param<T> |
inline(Object value,
Field<T> field)
Create a bind value, that is always inlined.
|
static Param<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<Short> |
inline(short value)
Create a bind value that is always inlined.
|
static Param<Short> |
inline(Short value)
Create a bind value that is always inlined.
|
static Param<String> |
inline(String 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 Param<Time> |
inline(Time value)
Create a bind value that is always inlined.
|
static Param<Timestamp> |
inline(Timestamp value)
Create a bind value that is always inlined.
|
static Param<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 Param<UUID> |
inline(UUID value)
Create a bind value that is always inlined.
|
static <R extends Record> |
insertInto(Table<R> into)
Create a new DSL insert statement.
|
static <R extends Record> |
insertInto(Table<R> into,
Collection<? extends Field<?>> fields)
Create a new DSL insert statement.
|
static <R extends Record> |
insertInto(Table<R> into,
Field<?>... fields)
Create a new DSL insert statement.
|
static <R extends Record,T1> |
insertInto(Table<R> into,
Field<T1> field1)
Create a new DSL insert statement.
|
static <R extends Record,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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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 <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 Keyword |
keyword(String keyword)
Create a SQL keyword.
|
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> |
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<String> |
left(Field<String> field,
Field<? extends Number> length)
Get the left outermost characters from a string.
|
static Field<String> |
left(Field<String> field,
int length)
Get the left outermost characters from a string.
|
static Field<String> |
left(String field,
Field<? extends Number> length)
Get the left outermost characters from a string.
|
static Field<String> |
left(String field,
int length)
Get the left outermost characters from a string.
|
static Field<Integer> |
length(Field<String> field)
Get the length of a
VARCHAR type. |
static Field<Integer> |
length(String value)
Get the length of a
VARCHAR type. |
static Field<Integer> |
level()
Retrieve the Oracle-specific
LEVEL pseudo-field (to be used
along with CONNECT BY clauses). |
static Link |
link(Name name)
Create a database link reference.
|
static Link |
link(String name)
Create a database link reference.
|
static Link |
link(String name,
Schema schema)
Create a database link reference.
|
static QueryPart |
list(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<String> |
listAgg(Field<?> field)
Get the aggregated concatenation for a field.
|
static OrderedAggregateFunction<String> |
listAgg(Field<?> field,
String separator)
Get the aggregated concatenation for a field.
|
static Field<BigDecimal> |
ln(Field<? extends Number> field)
Get the ln(field) function, taking the natural logarithm of this field.
|
static Field<BigDecimal> |
ln(Number value)
Get the ln(field) function, taking the natural logarithm of this field.
|
static Field<java.time.LocalDate> |
localDate(Field<java.time.LocalDate> field)
Convert a temporal 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(String value)
Convert a string value to a
DATE . |
static Field<java.time.LocalDateTime> |
localDateTime(Field<java.time.LocalDateTime> field)
Convert a temporal 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(String value)
Convert a string value to a
TIMESTAMP . |
static Field<java.time.LocalTime> |
localTime(Field<java.time.LocalTime> field)
Convert a temporal 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(String value)
Convert a string value to a
TIME . |
static Field<BigDecimal> |
log(Field<? extends Number> field,
int base)
Get the log(field, base) function.
|
static Field<BigDecimal> |
log(Number value,
int base)
Get the log(field, base) function.
|
static Field<String> |
lower(Field<String> field)
Get the lower(field) function.
|
static Field<String> |
lower(String value)
Get the lower(field) function.
|
static Field<String> |
lpad(Field<String> field,
Field<? extends Number> length)
Get the lpad(field, length) function.
|
static Field<String> |
lpad(Field<String> field,
Field<? extends Number> length,
Field<String> character)
Get the lpad(field, length, character) function.
|
static Field<String> |
lpad(Field<String> field,
int length)
Get the lpad(field, length) function.
|
static Field<String> |
lpad(Field<String> field,
int length,
char character)
Get the lpad(field, length, character) function.
|
static Field<String> |
lpad(Field<String> field,
int length,
String character)
Get the lpad(field, length, character) function.
|
static Field<String> |
ltrim(Field<String> field)
Get the ltrim(field) function.
|
static Field<String> |
ltrim(String value)
Get the ltrim(field) function.
|
static <T> AggregateFunction<T> |
max(Field<T> field)
Get the max value over a field: max(field).
|
static <T> AggregateFunction<T> |
maxDistinct(Field<T> field)
Get the max value over a field: max(distinct field).
|
static Field<String> |
md5(Field<String> string)
Get the MySQL-specific
MD5() function. |
static Field<String> |
md5(String string)
Get the MySQL-specific
MD5() function. |
static AggregateFunction<BigDecimal> |
median(Field<? extends Number> field)
Get the median over a numeric field: median(field).
|
static <R extends Record> |
mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.
|
static <R extends Record> |
mergeInto(Table<R> table,
Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax).
|
static <R extends Record> |
mergeInto(Table<R> table,
Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax).
|
static <R extends Record,T1> |
mergeInto(Table<R> table,
Field<T1> field1)
|
static <R extends Record,T1,T2> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2)
|
static <R extends Record,T1,T2,T3> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
|
static <R extends Record,T1,T2,T3,T4> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
|
static <R extends Record,T1,T2,T3,T4,T5> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
|
static <R extends Record,T1,T2,T3,T4,T5,T6> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21)
|
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21,
Field<T22> field22)
|
static Field<String> |
mid(Field<String> field,
Field<? extends Number> startingPosition,
Field<? extends Number> length)
Get the mid(field, startingPosition, length) function.
|
static Field<String> |
mid(Field<String> field,
int startingPosition,
int length)
Get the mid(field, startingPosition, length) function.
|
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 Field<Integer> |
minute(Date value)
Get the minute part of a date.
|
static Field<Integer> |
minute(Field<?> field)
Get the minute part of a date.
|
static Field<Integer> |
minute(java.time.temporal.Temporal value)
Get the minute part of a date.
|
static OrderedAggregateFunctionOfDeferredType |
mode()
The
mode() within group (oder by [order clause]) ordered
aggregate function. |
static Field<Integer> |
month(Date value)
Get the month part of a date.
|
static Field<Integer> |
month(Field<?> field)
Get the month part of a date.
|
static Field<Integer> |
month(java.time.temporal.Temporal value)
Get the month part of a date.
|
static Name |
name(Collection<String> qualifiedName)
Create a new SQL identifier using a qualified name.
|
static Name |
name(String... qualifiedName)
Create a new SQL identifier using a qualified name.
|
static Field<Boolean> |
not(Boolean value)
Deprecated.
- 3.8.0 - [#4763] - Use
not(Condition) instead. Due
to ambiguity between calling this method using
Field.equals(Object) argument, vs. calling the other
method via a Field.equal(Object) argument, this
method will be removed in the future. |
static Condition |
not(Condition condition)
Invert a condition.
|
static Field<Boolean> |
not(Field<Boolean> field)
Invert a boolean value.
|
static Condition |
notExists(Select<?> query)
Create a not exists condition.
|
static <T> WindowIgnoreNullsStep<T> |
nthValue(Field<T> field,
Field<Integer> nth)
The
nth_value(field) over ([analytic clause]) function. |
static <T> WindowIgnoreNullsStep<T> |
nthValue(Field<T> field,
int nth)
The
nth_value(field) over ([analytic clause]) function. |
static WindowOverStep<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<Integer> |
octetLength(Field<String> field)
Get the octet_length(field) function.
|
static Field<Integer> |
octetLength(String value)
Get the octet_length(field) function.
|
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.OffsetDateTime> |
offsetDateTime(java.time.OffsetDateTime value)
Convert a temporal value to a
TIMESTAMP WITH TIME ZONE . |
static Field<java.time.OffsetDateTime> |
offsetDateTime(String value)
Convert a string value to a
TIMESTAMP 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 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(String value)
Convert a string value to a
TIME WITH TIME ZONE . |
static Param<Integer> |
one()
A
1 literal. |
static Condition |
or(Collection<? extends Condition> conditions)
|
static Condition |
or(Condition... conditions)
|
static WindowSpecificationRowsStep |
orderBy(Collection<? extends SortField<?>> 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(SortField<?>... fields)
Create a
WindowSpecification with an ORDER BY clause. |
static <T> Param<Object> |
param()
Create an unnamed parameter with a generic type (
Object /
SQLDataType.OTHER ) and no initial value. |
static <T> Param<T> |
param(Class<T> type)
Create an unnamed parameter with a defined type and no initial value.
|
static <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 Param<Object> |
param(String name)
Create a named parameter with a generic type (
Object /
SQLDataType.OTHER ) and no initial value. |
static <T> Param<T> |
param(String name,
Class<T> type)
Create a named parameter with a defined type and no initial value.
|
static <T> Param<T> |
param(String name,
DataType<T> type)
Create a named parameter with a defined type and no initial value.
|
static <T> Param<T> |
param(String name,
Field<T> type)
Create a named parameter with a defined type of another field and no
initial value.
|
static <T> Param<T> |
param(String name,
T value)
Create a named parameter with an initial value.
|
static WindowSpecificationOrderByStep |
partitionBy(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<BigDecimal> |
percentileCont(Field<? extends Number> field)
The
percentile_cont([number]) within group (order by [column])
function. |
static OrderedAggregateFunction<BigDecimal> |
percentileCont(Number number)
The
percentile_cont([number]) within group (order by [column])
function. |
static OrderedAggregateFunction<BigDecimal> |
percentileDisc(Field<? extends Number> field)
The
percentile_disc([number]) within group (order by [column])
function. |
static OrderedAggregateFunction<BigDecimal> |
percentileDisc(Number number)
The
percentile_disc([number]) within group (order by [column])
function. |
static WindowOverStep<BigDecimal> |
percentRank()
The
precent_rank() over ([analytic clause]) function. |
static OrderedAggregateFunction<Integer> |
percentRank(Field<?>... fields)
The
percent_rank(expr) within group (order by [order clause])
ordered-set aggregate function. |
static Field<BigDecimal> |
pi()
The
PI literal. |
static Field<Integer> |
position(Field<String> in,
Field<String> search)
Get the position(in, search) function.
|
static Field<Integer> |
position(Field<String> in,
Field<String> search,
Field<? extends Number> startIndex)
Get the position(in, search, startindex) function.
|
static Field<Integer> |
position(Field<String> in,
Field<String> search,
int startIndex)
Get the position(in, search, startindex) function.
|
static Field<Integer> |
position(Field<String> in,
String search)
Get the position(in, search) function.
|
static Field<Integer> |
position(Field<String> in,
String search,
Field<? extends Number> startIndex)
Get the position(in, search, startindex) function.
|
static Field<Integer> |
position(Field<String> in,
String search,
int startIndex)
Get the position(in, search, startindex) function.
|
static Field<Integer> |
position(String in,
Field<String> search)
Get the position(in, search) function.
|
static Field<Integer> |
position(String in,
Field<String> search,
Field<? extends Number> startIndex)
Get the position(in, search, startindex) function.
|
static Field<Integer> |
position(String in,
Field<String> search,
int startIndex)
Get the position(in, search, startindex) function.
|
static Field<Integer> |
position(String in,
String search)
Get the position(in, search) function.
|
static Field<Integer> |
position(String in,
String search,
Field<? extends Number> startIndex)
Get the position(in, search, startindex) function.
|
static Field<Integer> |
position(String in,
String search,
int startIndex)
Get the position(in, search, startindex) function.
|
static Field<BigDecimal> |
power(Field<? extends Number> field,
Field<? extends Number> exponent)
Get the power(field, exponent) function.
|
static Field<BigDecimal> |
power(Field<? extends Number> field,
Number exponent)
Get the power(field, exponent) function.
|
static Field<BigDecimal> |
power(Number value,
Field<? extends Number> exponent)
Get the power(field, exponent) function.
|
static Field<BigDecimal> |
power(Number value,
Number exponent)
Get the power(field, exponent) function.
|
static ConstraintFinalStep |
primaryKey(Field<?>... fields)
Create an unnamed (system named)
PRIMARY KEY constraint. |
static ConstraintFinalStep |
primaryKey(String... 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 Queries |
queries(Collection<? extends Query> queries)
Wrap a collection of queries.
|
static Queries |
queries(Query... queries)
Wrap a collection of queries.
|
static Query |
query(SQL sql)
Create a new query holding plain SQL.
|
static Query |
query(String sql)
Create a new query holding plain SQL.
|
static Query |
query(String sql,
Object... bindings)
Create a new query holding plain SQL.
|
static Query |
query(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
static QueryPart |
queryPart(String sql)
Deprecated.
- 3.6.0 - [#3854] - Use
sql(String) instead |
static QueryPart |
queryPart(String sql,
Object... bindings)
Deprecated.
- 3.6.0 - [#3854] - Use
sql(String, Object...) instead |
static QueryPart |
queryPart(String sql,
QueryPart... parts)
Deprecated.
- 3.6.0 - [#3854] - Use
sql(String, QueryPart...) instead |
static Field<BigDecimal> |
rad(Field<? extends Number> field)
Calculate radians from degrees from this field.
|
static Field<BigDecimal> |
rad(Number value)
Calculate radians from degrees from this field.
|
static Field<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 WindowSpecificationFinalStep |
rangeCurrentRow()
Create a
WindowSpecification with a RANGE clause. |
static WindowSpecificationFinalStep |
rangeFollowing(int number)
Create a
WindowSpecification with a RANGE clause. |
static WindowSpecificationFinalStep |
rangePreceding(int number)
Create a
WindowSpecification with a RANGE clause. |
static WindowSpecificationFinalStep |
rangeUnboundedFollowing()
Create a
WindowSpecification with a RANGE clause. |
static WindowSpecificationFinalStep |
rangeUnboundedPreceding()
Create a
WindowSpecification with a RANGE clause. |
static WindowOverStep<Integer> |
rank()
The
rank() over ([analytic clause]) function. |
static OrderedAggregateFunction<Integer> |
rank(Field<?>... fields)
The
rank(expr) within group (order by [order clause])
ordered-set aggregate function. |
static WindowOverStep<BigDecimal> |
ratioToReport(Field<? extends Number> field)
The
ratio_to_report([expression]) over ([analytic clause]) function. |
static WindowOverStep<BigDecimal> |
ratioToReport(Number number)
The
ratio_to_report([expression]) over ([analytic clause]) function. |
static <T1> RecordType<Record> |
recordType(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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<BigDecimal> |
regrAvgX(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_AVGX linear regression function. |
static AggregateFunction<BigDecimal> |
regrAvgY(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_AVGY linear regression function. |
static AggregateFunction<BigDecimal> |
regrCount(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_COUNT linear regression function. |
static AggregateFunction<BigDecimal> |
regrIntercept(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_INTERCEPT linear regression function. |
static AggregateFunction<BigDecimal> |
regrR2(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_R2 linear regression function. |
static AggregateFunction<BigDecimal> |
regrSlope(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_SLOPE linear regression function. |
static AggregateFunction<BigDecimal> |
regrSXX(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_SXX linear regression function. |
static AggregateFunction<BigDecimal> |
regrSXY(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_SXY linear regression function. |
static AggregateFunction<BigDecimal> |
regrSYY(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_SYY linear regression function. |
static Field<String> |
repeat(Field<String> field,
Field<? extends Number> count)
Get the repeat(field, count) function.
|
static Field<String> |
repeat(Field<String> field,
int count)
Get the repeat(count) function.
|
static Field<String> |
repeat(String field,
Field<? extends Number> count)
Get the repeat(field, count) function.
|
static Field<String> |
repeat(String field,
int count)
Get the repeat(field, count) function.
|
static Field<String> |
replace(Field<String> field,
Field<String> search)
Get the replace(field, search) function.
|
static Field<String> |
replace(Field<String> field,
Field<String> search,
Field<String> replace)
Get the replace(field, search, replace) function.
|
static Field<String> |
replace(Field<String> field,
String search)
Get the replace(field, search) function.
|
static Field<String> |
replace(Field<String> field,
String search,
String replace)
Get the replace(field, search, replace) function.
|
static ResultQuery<Record> |
resultQuery(SQL sql)
Create a new query holding plain SQL.
|
static ResultQuery<Record> |
resultQuery(String sql)
Create a new query holding plain SQL.
|
static ResultQuery<Record> |
resultQuery(String sql,
Object... bindings)
Create a new query holding plain SQL.
|
static ResultQuery<Record> |
resultQuery(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
static Field<String> |
reverse(Field<String> field)
Get the
reverse(field) function. |
static Field<String> |
reverse(String value)
Get the
reverse(field) function. |
static Field<String> |
right(Field<String> field,
Field<? extends Number> length)
Get the right outermost characters from a string.
|
static Field<String> |
right(Field<String> field,
int length)
Get the right outermost characters from a string.
|
static Field<String> |
right(String field,
Field<? extends Number> length)
Get the right outermost characters from a string.
|
static Field<String> |
right(String field,
int length)
Get the right outermost characters from a string.
|
static GroupField |
rollup(Field<?>... fields)
Create a ROLLUP(field1, field2, .., fieldn) grouping field.
|
static GroupField |
rollup(FieldOrRow... fields)
Create a ROLLUP(field1, field2, .., fieldn) grouping field.
|
static <T extends Number> |
round(Field<T> field)
Get rounded value of a numeric field: round(field).
|
static <T extends Number> |
round(Field<T> field,
int decimals)
Get rounded value of a numeric field: round(field, decimals).
|
static <T extends Number> |
round(T value)
Get rounded value of a numeric field: round(field).
|
static <T extends Number> |
round(T value,
int decimals)
Get rounded value of a numeric field: round(field, decimals).
|
static RowN |
row(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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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 RowN |
row(Object... values)
Create a row value expression of degree
N > 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> |
row(T1 t1,
T2 t2,
T3 t3,
T4 t4)
Create a row value expression of degree
4 . |
static <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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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<Integer> |
rownum()
Retrieve the Oracle-specific
ROWNUM pseudo-field. |
static WindowOverStep<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 WindowSpecificationFinalStep |
rowsCurrentRow()
Create a
WindowSpecification with a ROWS clause. |
static WindowSpecificationFinalStep |
rowsFollowing(int number)
Create a
WindowSpecification with a ROWS clause. |
static Table<Record> |
rowsFrom(Table<?>... tables)
Create a
ROWS FROM (tables...) |
static WindowSpecificationFinalStep |
rowsPreceding(int number)
Create a
WindowSpecification with a ROWS clause. |
static WindowSpecificationFinalStep |
rowsUnboundedFollowing()
Create a
WindowSpecification with a ROWS clause. |
static WindowSpecificationFinalStep |
rowsUnboundedPreceding()
Create a
WindowSpecification with a ROWS clause. |
static Field<String> |
rpad(Field<String> field,
Field<? extends Number> length)
Get the rpad(field, length) function.
|
static Field<String> |
rpad(Field<String> field,
Field<? extends Number> length,
Field<String> character)
Get the rpad(field, length, character) function.
|
static Field<String> |
rpad(Field<String> field,
int length)
Get the rpad(field, length) function.
|
static Field<String> |
rpad(Field<String> field,
int length,
char character)
Get the rpad(field, length, character) function.
|
static Field<String> |
rpad(Field<String> field,
int length,
String character)
Get the rpad(field, length, character) function.
|
static Field<String> |
rtrim(Field<String> field)
Get the rtrim(field) function.
|
static Field<String> |
rtrim(String value)
Get the rtrim(field) function.
|
static Schema |
schema(Name name)
Create a qualified schema, given its schema name.
|
static Schema |
schemaByName(String name)
Deprecated.
- [#3843] - 3.6.0 - use
schema(Name) instead |
static Field<Integer> |
second(Date value)
Get the second part of a date.
|
static Field<Integer> |
second(Field<?> field)
Get the second part of a date.
|
static Field<Integer> |
second(java.time.temporal.Temporal value)
Get the second part of a date.
|
static SelectSelectStep<Record> |
select(Collection<? extends SelectField<?>> fields)
Create a new DSL subselect statement.
|
static SelectSelectStep<Record> |
select(SelectField<?>... 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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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<Record1<Integer>> |
selectCount()
Create a new DSL subselect statement for
COUNT(*) . |
static SelectSelectStep<Record> |
selectDistinct(Collection<? extends SelectField<?>> fields)
Create a new DSL subselect statement.
|
static SelectSelectStep<Record> |
selectDistinct(SelectField<?>... 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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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 <R extends Record> |
selectFrom(Table<R> table)
Create a new DSL select statement.
|
static SelectSelectStep<Record1<Integer>> |
selectOne()
Create a new DSL subselect statement for a constant
1
literal. |
static SelectSelectStep<Record1<Integer>> |
selectZero()
Create a new DSL subselect statement for a constant
0
literal. |
static Sequence<BigInteger> |
sequence(Name name)
Create a qualified sequence, given its sequence name.
|
static <T extends Number> |
sequence(Name name,
Class<T> type)
Create a qualified sequence, given its sequence name.
|
static <T extends Number> |
sequence(Name name,
DataType<T> type)
Create a qualified sequence, given its sequence name.
|
static Sequence<BigInteger> |
sequence(String sql)
Create a "plain SQL" sequence.
|
static <T extends Number> |
sequence(String sql,
Class<T> type)
Create a "plain SQL" sequence.
|
static <T extends Number> |
sequence(String sql,
DataType<T> type)
Create a "plain SQL" sequence.
|
static <T extends Number> |
sequenceByName(Class<T> type,
String... qualifiedName)
Deprecated.
- [#3843] - 3.6.0 - use
sequence(Name, Class) instead |
static <T extends Number> |
sequenceByName(DataType<T> type,
String... qualifiedName)
Deprecated.
- [#3843] - 3.6.0 - use
sequence(Name, DataType) instead |
static Sequence<BigInteger> |
sequenceByName(String... qualifiedName)
Deprecated.
- [#3843] - 3.6.0 - use
sequence(Name) instead |
static <T extends Number> |
shl(Field<T> field1,
Field<? extends Number> field2)
The bitwise left shift operator.
|
static <T extends Number> |
shl(Field<T> value1,
Number value2)
The bitwise left shift operator.
|
static <T extends Number> |
shl(T value1,
Field<? extends Number> value2)
The bitwise left shift operator.
|
static <T extends Number> |
shl(T value1,
Number value2)
The bitwise left shift operator.
|
static <T extends Number> |
shr(Field<T> field1,
Field<? extends Number> field2)
The bitwise right shift operator.
|
static <T extends Number> |
shr(Field<T> value1,
Number value2)
The bitwise right shift operator.
|
static <T extends Number> |
shr(T value1,
Field<? extends Number> value2)
The bitwise right shift operator.
|
static <T extends Number> |
shr(T value1,
Number value2)
The bitwise right shift operator.
|
static Field<Integer> |
sign(Field<? extends Number> field)
Get the sign of a numeric field: sign(field).
|
static Field<Integer> |
sign(Number value)
Get the sign of a numeric field: sign(field).
|
static Field<BigDecimal> |
sin(Field<? extends Number> field)
Get the sine(field) function.
|
static Field<BigDecimal> |
sin(Number value)
Get the sine(field) function.
|
static Field<BigDecimal> |
sinh(Field<? extends Number> field)
Get the hyperbolic sine function: sinh(field).
|
static Field<BigDecimal> |
sinh(Number value)
Get the hyperbolic sine function: sinh(field).
|
static Field<String> |
space(Field<Integer> value)
Get the SQL Server specific
SPACE() function. |
static Field<String> |
space(int value)
Get the SQL Server specific
SPACE() function. |
static SQL |
sql(String sql)
A custom SQL clause that can render arbitrary expressions.
|
static SQL |
sql(String sql,
Object... bindings)
A custom SQL clause that can render arbitrary expressions.
|
static SQL |
sql(String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary expressions.
|
static Field<BigDecimal> |
sqrt(Field<? extends Number> field)
Get the sqrt(field) function.
|
static Field<BigDecimal> |
sqrt(Number value)
Get the sqrt(field) function.
|
static AggregateFunction<BigDecimal> |
stddevPop(Field<? extends Number> field)
Get the population standard deviation of a numeric field: stddev_pop(field).
|
static AggregateFunction<BigDecimal> |
stddevSamp(Field<? extends Number> field)
Get the sample standard deviation of a numeric field: stddev_samp(field).
|
static Field<String> |
substring(Field<String> field,
Field<? extends Number> startingPosition)
Get the substring(field, startingPosition) function.
|
static Field<String> |
substring(Field<String> field,
Field<? extends Number> startingPosition,
Field<? extends Number> length)
Get the substring(field, startingPosition, length) function.
|
static Field<String> |
substring(Field<String> field,
int startingPosition)
Get the substring(field, startingPosition) function.
|
static Field<String> |
substring(Field<String> field,
int startingPosition,
int length)
Get the substring(field, startingPosition, length) function.
|
static AggregateFunction<BigDecimal> |
sum(Field<? extends Number> field)
Get the sum over a numeric field: sum(field).
|
static AggregateFunction<BigDecimal> |
sumDistinct(Field<? extends Number> field)
Get the sum over a numeric field: sum(distinct field).
|
static Field<String> |
sysConnectByPath(Field<?> field,
String separator)
Retrieve the Oracle-specific
SYS_CONNECT_BY_PATH(field, separator) function (to be used
along with CONNECT BY clauses). |
static Table<?> |
table(ArrayRecord<?> array)
A synonym for
unnest(ArrayRecord) . |
static Table<?> |
table(Field<?> cursor)
A synonym for
unnest(Field) . |
static Table<?> |
table(List<?> list)
A synonym for
unnest(List) . |
static Table<Record> |
table(Name name)
Create a qualified table, given its table name.
|
static Table<?> |
table(Object[] array)
A synonym for
unnest(Object[]) . |
static <R extends Record> |
table(R... records)
Use a previously obtained set of records as a new Table
|
static <R extends Record> |
table(R record)
Use a previously obtained record as a new Table
|
static <R extends Record> |
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(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 Table<Record> |
table(String sql)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
table(String sql,
Object... bindings)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
table(String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
tableByName(String... qualifiedName)
Deprecated.
- [#3843] - 3.6.0 - use
table(Name) instead |
static Field<BigDecimal> |
tan(Field<? extends Number> field)
Get the tangent(field) function.
|
static Field<BigDecimal> |
tan(Number value)
Get the tangent(field) function.
|
static Field<BigDecimal> |
tanh(Field<? extends Number> field)
Get the hyperbolic tangent function: tanh(field).
|
static Field<BigDecimal> |
tanh(Number value)
Get the hyperbolic tangent function: tanh(field).
|
static Field<Time> |
time(Date value)
Convert a temporal value to a
TIME . |
static Field<Time> |
time(Field<? extends Date> field)
Convert a temporal value to a
TIME . |
static Field<Time> |
time(String value)
Convert a string value to a
TIME . |
static Field<Timestamp> |
timestamp(Date value)
Convert a temporal value to a
TIMESTAMP . |
static Field<Timestamp> |
timestamp(Field<? extends Date> field)
Convert a temporal value to a
TIMESTAMP . |
static Field<Timestamp> |
timestamp(String value)
Convert a string value to a
TIMESTAMP . |
static Field<Timestamp> |
timestampAdd(Field<Timestamp> timestamp,
Field<? extends Number> interval)
Add an interval to a timestamp.
|
static Field<Timestamp> |
timestampAdd(Field<Timestamp> date,
Field<? extends Number> interval,
DatePart datePart)
Add an interval to a timestamp, given a date part.
|
static Field<Timestamp> |
timestampAdd(Field<Timestamp> date,
Number interval,
DatePart datePart)
Add an interval to a timestamp, given a date part.
|
static Field<Timestamp> |
timestampAdd(Timestamp date,
Field<? extends Number> interval,
DatePart datePart)
Add an interval to a timestamp, given a date part.
|
static Field<Timestamp> |
timestampAdd(Timestamp timestamp,
Number interval)
Add an interval to a timestamp.
|
static Field<Timestamp> |
timestampAdd(Timestamp date,
Number interval,
DatePart datePart)
Add an interval to a timestamp, given a date part.
|
static Field<DayToSecond> |
timestampDiff(Field<Timestamp> timestamp1,
Field<Timestamp> timestamp2)
Get the timestamp difference as a
INTERVAL DAY TO SECOND
type. |
static Field<DayToSecond> |
timestampDiff(Field<Timestamp> timestamp1,
Timestamp timestamp2)
Get the timestamp difference as a
INTERVAL DAY TO SECOND
type. |
static Field<DayToSecond> |
timestampDiff(Timestamp timestamp1,
Field<Timestamp> timestamp2)
Get the timestamp difference as a
INTERVAL DAY TO SECOND
type. |
static Field<DayToSecond> |
timestampDiff(Timestamp timestamp1,
Timestamp timestamp2)
Get the timestamp difference as a
INTERVAL DAY TO SECOND
type. |
static Field<Date> |
toDate(Field<String> value,
Field<String> format)
Parse a value to a
DATE . |
static Field<Date> |
toDate(Field<String> value,
String format)
Parse a value to a
DATE . |
static Field<Date> |
toDate(String value,
Field<String> format)
Parse a value to a
DATE . |
static Field<Date> |
toDate(String value,
String format)
Parse a value to a
DATE . |
static Field<java.time.LocalDate> |
toLocalDate(Field<String> value,
Field<String> format)
Parse a value to a
DATE . |
static Field<java.time.LocalDate> |
toLocalDate(Field<String> value,
String format)
Parse a value to a
DATE . |
static Field<java.time.LocalDate> |
toLocalDate(String value,
Field<String> format)
Parse a value to a
DATE . |
static Field<java.time.LocalDate> |
toLocalDate(String value,
String format)
Parse a value to a
DATE . |
static Field<java.time.LocalDateTime> |
toLocalDateTime(Field<String> value,
Field<String> format)
Parse a value to a
TIMESTAMP . |
static Field<java.time.LocalDateTime> |
toLocalDateTime(Field<String> value,
String format)
Parse a value to a
TIMESTAMP . |
static Field<java.time.LocalDateTime> |
toLocalDateTime(String value,
Field<String> format)
Parse a value to a
TIMESTAMP . |
static Field<java.time.LocalDateTime> |
toLocalDateTime(String value,
String format)
Parse a value to a
TIMESTAMP . |
static Field<Timestamp> |
toTimestamp(Field<String> value,
Field<String> format)
Parse a value to a
TIMESTAMP . |
static Field<Timestamp> |
toTimestamp(Field<String> value,
String format)
Parse a value to a
TIMESTAMP . |
static Field<Timestamp> |
toTimestamp(String value,
Field<String> format)
Parse a value to a
TIMESTAMP . |
static Field<Timestamp> |
toTimestamp(String value,
String format)
Parse a value to a
TIMESTAMP . |
static Field<String> |
trim(Field<String> field)
Get the trim(field) function.
|
static Field<String> |
trim(String value)
Get the trim(field) function.
|
static Condition |
trueCondition()
Return a
Condition that will always evaluate to true. |
static Field<Date> |
trunc(Date date)
Truncate a date to the beginning of the day.
|
static Field<Date> |
trunc(Date date,
DatePart part)
Truncate a date 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> Field<T> |
trunc(Field<T> date,
DatePart part)
Truncate a date or a timestamp to a given datepart.
|
static <T extends Number> |
trunc(Field<T> number,
Field<Integer> decimals)
Truncate a number to a given number of decimals.
|
static <T extends Number> |
trunc(Field<T> number,
int decimals)
Truncate a number to a given number of decimals.
|
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 extends Number> |
trunc(T number)
Truncate a number to a given number of decimals.
|
static <T extends Number> |
trunc(T number,
Field<Integer> decimals)
Truncate a number to a given number of decimals.
|
static Field<Timestamp> |
trunc(Timestamp timestamp)
Truncate a timestamp to the beginning of the day.
|
static Field<Timestamp> |
trunc(Timestamp timestamp,
DatePart part)
Truncate a timestamp to a given datepart.
|
static <T extends Number> |
trunc(T number,
int decimals)
Truncate a number to a given number of decimals.
|
static TruncateIdentityStep<Record> |
truncate(Name table)
Create a new DSL truncate statement.
|
static <R extends Record> |
truncate(Table<R> table)
Create a new DSL truncate statement.
|
static Param<Integer> |
two()
A
2 literal. |
static ConstraintFinalStep |
unique(Field<?>... fields)
Create an unnamed (system named)
UNIQUE constraint. |
static ConstraintFinalStep |
unique(String... fields)
Create an unnamed (system named)
UNIQUE constraint. |
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 Table<?> |
unnest(List<?> list)
Create a table from a list of values.
|
static Table<?> |
unnest(Object[] array)
Create a table from an array of values.
|
static <R extends Record> |
update(Table<R> table)
Create a new DSL update statement.
|
static Field<String> |
upper(Field<String> field)
Get the upper(field) function.
|
static Field<String> |
upper(String value)
Get the upper(field) function.
|
static DSLContext |
using(Configuration configuration)
Create an executor from a custom configuration.
|
static DSLContext |
using(Connection connection)
Create an executor with a connection configured.
|
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(Connection connection,
Settings settings)
Create an executor with a connection, a dialect and settings configured.
|
static DSLContext |
using(Connection connection,
SQLDialect dialect)
Create an executor with a connection and a dialect configured.
|
static DSLContext |
using(Connection connection,
SQLDialect dialect,
Settings settings)
Create an executor with a connection, a dialect and settings configured.
|
static DSLContext |
using(DataSource datasource,
SQLDialect dialect)
Create an executor with a data source and a dialect configured.
|
static DSLContext |
using(DataSource datasource,
SQLDialect dialect,
Settings settings)
Create an executor with a data source, 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 DSLContext |
using(String url)
Create an executor from a JDBC connection URL.
|
static DSLContext |
using(String url,
Properties properties)
Create an executor from a JDBC connection URL.
|
static DSLContext |
using(String url,
String username,
String password)
Create an executor from a JDBC connection URL.
|
static Param<BigDecimal> |
val(BigDecimal value)
Get a bind value.
|
static Param<BigInteger> |
val(BigInteger value)
Get a bind value.
|
static Param<Boolean> |
val(boolean value)
Get a bind value.
|
static Param<Boolean> |
val(Boolean value)
Get a bind value.
|
static Param<Byte> |
val(byte value)
Get a bind value.
|
static Param<Byte> |
val(Byte value)
Get a bind value.
|
static Param<byte[]> |
val(byte[] value)
Get a bind value.
|
static Param<Date> |
val(Date value)
Get a bind value.
|
static Param<Double> |
val(double value)
Get a bind value.
|
static Param<Double> |
val(Double value)
Get a bind value.
|
static Param<Float> |
val(float value)
Get a bind value.
|
static Param<Float> |
val(Float value)
Get a bind value.
|
static Param<Integer> |
val(int value)
Get a bind value.
|
static Param<Integer> |
val(Integer 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<Long> |
val(long value)
Get a bind value.
|
static Param<Long> |
val(Long value)
Get a bind value.
|
static <T> Param<T> |
val(Object value,
Class<T> type)
Get a bind value with an associated type, taken from a field.
|
static <T> Param<T> |
val(Object value,
DataType<T> type)
Get a bind value with an associated type.
|
static <T> Param<T> |
val(Object value,
Field<T> field)
Get a bind value with an associated type, taken from a field.
|
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<Short> |
val(short value)
Get a bind value.
|
static Param<Short> |
val(Short value)
Get a bind value.
|
static Param<String> |
val(String value)
Get a bind value.
|
static <T> Param<T> |
val(T value)
Get a bind value.
|
static Param<Time> |
val(Time value)
Get a bind value.
|
static Param<Timestamp> |
val(Timestamp 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 Param<UUID> |
val(UUID value)
Get a bind value.
|
static Param<BigDecimal> |
value(BigDecimal value)
A synonym for
val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<BigInteger> |
value(BigInteger value)
A synonym for
val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Boolean> |
value(boolean value)
A synonym for
val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Boolean> |
value(Boolean 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<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<Date> |
value(Date value)
A synonym for
val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Double> |
value(double value)
A synonym for
val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Double> |
value(Double value)
A synonym for
val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Float> |
value(float value)
A synonym for
val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Float> |
value(Float value)
A synonym for
val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Integer> |
value(int value)
A synonym for
val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Integer> |
value(Integer 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<Long> |
value(long value)
A synonym for
val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Long> |
value(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(Object value,
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(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(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.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<Short> |
value(short value)
A synonym for
val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Short> |
value(Short value)
A synonym for
val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<String> |
value(String 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 Param<Time> |
value(Time value)
A synonym for
val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Timestamp> |
value(Timestamp 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 Param<UUID> |
value(UUID 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(Row1<T1>... rows)
Create a
VALUES() expression of degree 1 . |
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
values(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... rows)
Create a
VALUES() expression of degree 10 . |
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
values(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>... rows)
Create a
VALUES() expression of degree 11 . |
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
values(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>... rows)
Create a
VALUES() expression of degree 12 . |
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
values(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>... rows)
Create a
VALUES() expression of degree 13 . |
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
values(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>... rows)
Create a
VALUES() expression of degree 14 . |
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
values(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>... rows)
Create a
VALUES() expression of degree 15 . |
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
values(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>... rows)
Create a
VALUES() expression of degree 16 . |
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
values(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>... rows)
Create a
VALUES() expression of degree 17 . |
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
values(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>... rows)
Create a
VALUES() expression of degree 18 . |
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
values(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>... rows)
Create a
VALUES() expression of degree 19 . |
static <T1,T2> Table<Record2<T1,T2>> |
values(Row2<T1,T2>... rows)
Create a
VALUES() expression of degree 2 . |
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
values(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>... rows)
Create a
VALUES() 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> |
values(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>... rows)
Create a
VALUES() 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> |
values(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>... rows)
Create a
VALUES() expression of degree 22 . |
static <T1,T2,T3> Table<Record3<T1,T2,T3>> |
values(Row3<T1,T2,T3>... rows)
Create a
VALUES() expression of degree 3 . |
static <T1,T2,T3,T4> |
values(Row4<T1,T2,T3,T4>... rows)
Create a
VALUES() expression of degree 4 . |
static <T1,T2,T3,T4,T5> |
values(Row5<T1,T2,T3,T4,T5>... rows)
Create a
VALUES() expression of degree 5 . |
static <T1,T2,T3,T4,T5,T6> |
values(Row6<T1,T2,T3,T4,T5,T6>... rows)
Create a
VALUES() expression of degree 6 . |
static <T1,T2,T3,T4,T5,T6,T7> |
values(Row7<T1,T2,T3,T4,T5,T6,T7>... rows)
Create a
VALUES() expression of degree 7 . |
static <T1,T2,T3,T4,T5,T6,T7,T8> |
values(Row8<T1,T2,T3,T4,T5,T6,T7,T8>... rows)
Create a
VALUES() expression of degree 8 . |
static <T1,T2,T3,T4,T5,T6,T7,T8,T9> |
values(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>... rows)
Create a
VALUES() expression of degree 9 . |
static Table<Record> |
values(RowN... rows)
Create a
VALUES() expression of arbitrary degree. |
static AggregateFunction<BigDecimal> |
varPop(Field<? extends Number> field)
Get the population variance of a numeric field: var_pop(field).
|
static AggregateFunction<BigDecimal> |
varSamp(Field<? extends Number> field)
Get the sample variance of a numeric field: var_samp(field).
|
static <T> CaseConditionStep<T> |
when(Condition condition,
Field<T> result)
Initialise a
Case statement. |
static <T> CaseConditionStep<T> |
when(Condition condition,
Select<? extends Record1<T>> result)
Initialise a
Case statement. |
static <T> CaseConditionStep<T> |
when(Condition condition,
T result)
Initialise a
Case statement. |
static WithStep |
with(CommonTableExpression<?>... tables)
Create a
WITH clause to supply subsequent
SELECT , UPDATE , INSERT ,
DELETE , and MERGE statements with
CommonTableExpression s. |
static WithAsStep |
with(String alias)
Create a
WITH clause to supply subsequent
SELECT , UPDATE , INSERT ,
DELETE , and MERGE statements with
CommonTableExpression s. |
static WithAsStep |
with(String alias,
java.util.function.Function<? super Field<?>,? extends String> fieldNameFunction)
Create a
WITH clause to supply subsequent
SELECT , UPDATE , INSERT ,
DELETE , and MERGE statements with
CommonTableExpression s. |
static WithAsStep |
with(String alias,
String... fieldAliases)
Create a
WITH clause to supply subsequent
SELECT , UPDATE , INSERT ,
DELETE , and MERGE statements with
CommonTableExpression s. |
static WithAsStep1 |
with(String alias,
String fieldAlias1)
Create a
WITH clause to supply subsequent
SELECT , UPDATE , INSERT ,
DELETE , and MERGE statements with
CommonTableExpression s. |
static WithAsStep2 |
with |