| Package | Description |
|---|---|
| org.jooq |
The
org.jooq package contains jOOQ's public API. |
| org.jooq.impl |
The
org.jooq.impl package contains jOOQ's implementation classes. |
| Modifier and Type | Method and Description |
|---|---|
Field<T> |
Field.add(Field<?> value)
An arithmetic expression to add value to this.
|
Field<T> |
Field.add(Number value)
An arithmetic expression adding this to value.
|
Condition |
Condition.and(Condition other)
Combine this condition with another one using the
Operator.AND
operator. |
Table<R> |
VersionsBetweenAndStep.and(Field<? extends T> scn)
Add an
AND clause to the flashback versions query clause. |
Condition |
Condition.and(Field<Boolean> other)
Combine this condition with another one using the
Operator.AND
operator. |
Condition |
BetweenAndStep.and(Field<T> field)
Create a condition to check this field against some bounds
|
Table<R> |
VersionsBetweenAndStep.and(T scn)
Add an
AND clause to the flashback versions query clause. |
Condition |
BetweenAndStep.and(T value)
Create a condition to check this field against some bounds
|
WindowFinalStep<T> |
WindowRowsAndStep.andCurrentRow()
Add a
... |
Condition |
Condition.andExists(Select<?> select)
Combine this condition with an EXISTS clause using the
Operator.AND operator. |
WindowFinalStep<T> |
WindowRowsAndStep.andFollowing(int number)
Add a
... |
Table<R> |
VersionsBetweenAndStep.andMaxvalue()
Add an
AND MAXVALUE clause to the flashback versions query
clause. |
Condition |
Condition.andNot(Condition other)
Combine this condition with a negated other one using the
Operator.AND operator. |
Condition |
Condition.andNot(Field<Boolean> other)
Combine this condition with a negated other one using the
Operator.AND operator. |
Condition |
Condition.andNotExists(Select<?> select)
Combine this condition with a NOT EXIST clause using the
Operator.AND operator. |
WindowFinalStep<T> |
WindowRowsAndStep.andPreceding(int number)
Add a
... |
WindowFinalStep<T> |
WindowRowsAndStep.andUnboundedFollowing()
Add a
... |
WindowFinalStep<T> |
WindowRowsAndStep.andUnboundedPreceding()
Add a
... |
Table<R> |
Table.as(String alias)
Create an alias for this table.
|
Field<T> |
Field.as(String alias)
Create an alias for this field.
|
Table<R> |
Table.as(String alias,
String... fieldAliases)
Create an alias for this table and its fields
Note that the case-sensitivity of the returned table and columns depends
on
Settings.getRenderNameStyle(). |
SortField<T> |
Field.asc()
Create an ascending sort field from this field.
|
Table<R> |
Table.asOfScn(Field<? extends Number> scn)
Create an
SQLDialect.ORACLE flashback query clause from this
table. |
Table<R> |
Table.asOfScn(Number scn)
Create an
SQLDialect.ORACLE flashback query clause from this
table. |
Table<R> |
Table.asOfTimestamp(Field<Timestamp> timestamp)
Create an
SQLDialect.ORACLE flashback query clause from this
table. |
Table<R> |
Table.asOfTimestamp(Timestamp timestamp)
Create an
SQLDialect.ORACLE flashback query clause from this
table. |
BetweenAndStep<T> |
Field.between(Field<T> minValue)
Create a condition to check this field against some bounds.
|
Condition |
Field.between(Field<T> minValue,
Field<T> maxValue)
Create a condition to check this field against some bounds.
|
BetweenAndStep<T> |
Field.between(T minValue)
Create a condition to check this field against some bounds.
|
Condition |
Field.between(T minValue,
T maxValue)
Create a condition to check this field against some bounds.
|
BetweenAndStep<T> |
Field.betweenSymmetric(Field<T> minValue)
Create a condition to check this field against some bounds.
|
Condition |
Field.betweenSymmetric(Field<T> minValue,
Field<T> maxValue)
Create a condition to check this field against some bounds.
|
BetweenAndStep<T> |
Field.betweenSymmetric(T minValue)
Create a condition to check this field against some bounds.
|
Condition |
Field.betweenSymmetric(T minValue,
T maxValue)
Create a condition to check this field against some bounds.
|
TruncateFinalStep<R> |
TruncateCascadeStep.cascade()
Add the
CASCADE clause to the TRUNCATE
statement. |
SelectConnectByConditionStep<R> |
SelectConnectByStep.connectBy(Condition condition)
Add an Oracle-specific
CONNECT BY clause to the query |
SelectConnectByConditionStep<R> |
SelectConnectByStep.connectBy(Field<Boolean> condition)
Add an Oracle-specific
CONNECT BY clause to the query |
SelectConnectByConditionStep<R> |
SelectConnectByStep.connectByNoCycle(Condition condition)
Add an Oracle-specific
CONNECT BY NOCYCLE clause to the
query |
SelectConnectByConditionStep<R> |
SelectConnectByStep.connectByNoCycle(Field<Boolean> condition)
Add an Oracle-specific
CONNECT BY NOCYCLE clause to the
query |
Condition |
Field.contains(Field<T> value)
Convenience method for
Field.like(String, char) including proper
adding of wildcards and escaping. |
Condition |
Field.contains(T value)
Convenience method for
Field.like(String, char) including proper
adding of wildcards and escaping. |
TruncateCascadeStep<R> |
TruncateIdentityStep.continueIdentity()
Add the
CONTINUE IDENTITY clause to the
TRUNCATE statement. |
Table<Record> |
Table.crossApply(String sql)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossApply(String sql,
Object... bindings)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossApply(String sql,
QueryPart... parts)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossApply(TableLike<?> table)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossJoin(String sql)
CROSS JOIN a table to this table. |
Table<Record> |
Table.crossJoin(String sql,
Object... bindings)
CROSS JOIN a table to this table. |
Table<Record> |
Table.crossJoin(String sql,
QueryPart... parts)
CROSS JOIN a table to this table. |
Table<Record> |
Table.crossJoin(TableLike<?> table)
CROSS JOIN a table to this table. |
<R extends Record> |
DSLContext.delete(Table<R> table)
Create a new DSL delete statement.
|
MergeNotMatchedStep<R> |
MergeMatchedDeleteStep.deleteWhere(Condition condition)
Add an additional
DELETE WHERE clause to the preceding
WHEN MATCHED THEN UPDATE clause. |
MergeNotMatchedStep<R> |
MergeMatchedDeleteStep.deleteWhere(Field<Boolean> condition)
Add an additional
DELETE WHERE clause to the preceding
WHEN MATCHED THEN UPDATE clause. |
SortField<T> |
Field.desc()
Create a descending sort field from this field.
|
Field<T> |
Field.div(Field<? extends Number> value)
An arithmetic expression dividing this by value.
|
Field<T> |
Field.div(Number value)
An arithmetic expression dividing this by value.
|
Field<T> |
Field.divide(Field<? extends Number> value)
An alias for
Field.div(Field). |
Field<T> |
Field.divide(Number value)
An alias for
Field.div(Number). |
DivideByOnStep |
Table.divideBy(Table<?> divisor)
Create a new
TABLE reference from this table, applying
relational division. |
Condition |
Field.endsWith(Field<T> value)
Convenience method for
Field.like(String, char) including proper
adding of wildcards and escaping. |
Condition |
Field.endsWith(T value)
Convenience method for
Field.like(String, char) including proper
adding of wildcards and escaping. |
Condition |
Field.eq(Field<T> field)
this = field. |
Condition |
Field.eq(QuantifiedSelect<? extends Record1<T>> query)
this = [quantifier] (Select
|
Condition |
Field.eq(Select<? extends Record1<T>> query)
this = (Select
|
Condition |
Field.eq(T value)
this = value. |
Condition |
Field.equal(Field<T> field)
this = field. |
Condition |
Field.equal(QuantifiedSelect<? extends Record1<T>> query)
this = [quantifier] (Select
|
Condition |
Field.equal(Select<? extends Record1<T>> query)
this = (Select
|
Condition |
Field.equal(T value)
this = value. |
SelectOptionStep<R> |
SelectForUpdateStep.forShare()
Add a
FOR SHARE clause to the end of the query. |
SelectForUpdateOfStep<R> |
SelectForUpdateStep.forUpdate()
Add a
FOR UPDATE clause to the end of the query. |
UpdateWhereStep<R> |
UpdateFromStep.from(Collection<? extends TableLike<?>> tables)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(Collection<? extends TableLike<?>> tables)
Add a
FROM clause to the query. |
UpdateWhereStep<R> |
UpdateFromStep.from(TableLike<?>... table)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(TableLike<?>... table)
Add a
FROM clause to the query. |
TableOnStep |
Table.fullOuterJoin(String sql)
FULL OUTER JOIN a table to this table. |
TableOnStep |
Table.fullOuterJoin(String sql,
Object... bindings)
FULL OUTER JOIN a table to this table. |
TableOnStep |
Table.fullOuterJoin(String sql,
QueryPart... parts)
FULL OUTER JOIN a table to this table. |
TableOnStep |
Table.fullOuterJoin(TableLike<?> table)
FULL OUTER JOIN a table to this table. |
SelectHavingStep<R> |
SelectGroupByStep.groupBy(Collection<? extends GroupField> fields)
Add a
GROUP BY clause to the query
Calling this with an empty argument list will result in an empty
GROUP BY () clause being rendered. |
SelectHavingStep<R> |
SelectGroupByStep.groupBy(GroupField... fields)
Add a
GROUP BY clause to the query
Calling this with an empty argument list will result in an empty
GROUP BY () clause being rendered. |
SelectHavingConditionStep<R> |
SelectHavingStep.having(Collection<? extends Condition> conditions)
Add a
HAVING clause to the query. |
SelectHavingConditionStep<R> |
SelectHavingStep.having(Condition... conditions)
Add a
HAVING clause to the query. |
SelectHavingConditionStep<R> |
SelectHavingStep.having(Field<Boolean> condition)
Add a
HAVING clause to the query. |
WindowOverStep<T> |
WindowIgnoreNullsStep.ignoreNulls()
Add an
IGNORE NULLS clause to the window function. |
Condition |
Field.in(Collection<T> values)
Create a condition to check this field against several values.
|
Table<Record> |
PivotInStep.in(Field<?>... fields)
Specify the acceptable values for pivoting
This clause is generally only supported by
SQLDialect.ORACLE. |
Condition |
Field.in(Field<?>... values)
Create a condition to check this field against several values.
|
Condition |
Field.in(Select<? extends Record1<T>> query)
Create a condition to check this field against a subquery.
|
Condition |
Field.in(T... values)
Create a condition to check this field against several values.
|
Condition |
Field.isDistinctFrom(Field<T> field)
Create a condition to check if this field is
DISTINCT from
another field. |
Condition |
Field.isDistinctFrom(T value)
Create a condition to check if this field is
DISTINCT from
another value. |
Condition |
Field.isNotDistinctFrom(Field<T> field)
Create a condition to check if this field is
NOT DISTINCT
from another field. |
Condition |
Field.isNotDistinctFrom(T value)
Create a condition to check if this field is
NOT DISTINCT
from another value. |
Condition |
Row.isNotNull()
Check if this row value expression contains no
NULL values. |
Condition |
Field.isNotNull()
Create a condition to check this field against
null. |
Condition |
Row.isNull()
Check if this row value expression contains only
NULL
values. |
Condition |
Field.isNull()
Create a condition to check this field against
null. |
TableOnStep |
Table.join(String sql)
INNER JOIN a table to this table. |
TableOnStep |
Table.join(String sql,
Object... bindings)
INNER JOIN a table to this table. |
TableOnStep |
Table.join(String sql,
QueryPart... parts)
INNER JOIN a table to this table. |
TableOnStep |
Table.join(TableLike<?> table)
INNER JOIN a table to this table. |
WindowBeforeOverStep<T> |
AggregateFunction.keepDenseRankFirstOrderBy(Collection<? extends SortField<?>> fields)
Restrict this aggregate function to
FIRST values
An example:
MAX(id) KEEP (DENSE_RANK FIRST ORDER BY 1)
This clause is only available on
MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions. |
WindowBeforeOverStep<T> |
AggregateFunction.keepDenseRankFirstOrderBy(Field<?>... fields)
Restrict this aggregate function to
FIRST values
An example:
MAX(id) KEEP (DENSE_RANK FIRST ORDER BY 1)
This clause is only available on
MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions. |
WindowBeforeOverStep<T> |
AggregateFunction.keepDenseRankFirstOrderBy(SortField<?>... fields)
Restrict this aggregate function to
FIRST values
An example:
MAX(id) KEEP (DENSE_RANK FIRST ORDER BY 1)
This clause is only available on
MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions. |
WindowBeforeOverStep<T> |
AggregateFunction.keepDenseRankLastOrderBy(Collection<? extends SortField<?>> fields)
Restrict this aggregate function to
FIRST values
An example:
MAX(id) KEEP (DENSE_RANK LAST ORDER BY 1)
This clause is only available on
MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions. |
WindowBeforeOverStep<T> |
AggregateFunction.keepDenseRankLastOrderBy(Field<?>... fields)
Restrict this aggregate function to
FIRST values
An example:
MAX(id) KEEP (DENSE_RANK LAST ORDER BY 1)
This clause is only available on
MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions. |
WindowBeforeOverStep<T> |
AggregateFunction.keepDenseRankLastOrderBy(SortField<?>... fields)
Restrict this aggregate function to
FIRST values
An example:
MAX(id) KEEP (DENSE_RANK LAST ORDER BY 1)
This clause is only available on
MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions. |
MergeValuesStepN<R> |
MergeKeyStepN.key(Collection<? extends Field<?>> keys)
Specify an optional
KEY clause. |
MergeValuesStepN<R> |
MergeKeyStepN.key(Field<?>... keys)
Specify an optional
KEY clause. |
TablePartitionByStep |
Table.leftOuterJoin(String sql)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep |
Table.leftOuterJoin(String sql,
Object... bindings)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep |
Table.leftOuterJoin(String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep |
Table.leftOuterJoin(TableLike<?> table)
LEFT OUTER JOIN a table to this table. |
Condition |
Field.like(Field<String> value)
Create a condition to pattern-check this field against a value.
|
Condition |
Field.like(Field<String> value,
char escape)
Create a condition to pattern-check this field against a value.
|
Condition |
Field.like(String value)
Create a condition to pattern-check this field against a value.
|
Condition |
Field.like(String value,
char escape)
Create a condition to pattern-check this field against a value.
|
Condition |
Field.likeIgnoreCase(Field<String> field)
Create a condition to case-insensitively pattern-check this field against
a field.
|
Condition |
Field.likeIgnoreCase(Field<String> field,
char escape)
Create a condition to case-insensitively pattern-check this field against
a field.
|
Condition |
Field.likeIgnoreCase(String value)
Create a condition to case-insensitively pattern-check this field against
a value.
|
Condition |
Field.likeIgnoreCase(String value,
char escape)
Create a condition to case-insensitively pattern-check this field against
a value.
|
Condition |
Field.likeRegex(Field<String> pattern)
Create a condition to regex-pattern-check this field against a pattern.
|
Condition |
Field.likeRegex(String pattern)
Create a condition to regex-pattern-check this field against a pattern.
|
SelectForUpdateStep<R> |
SelectSeekLimitStep.limit(int numberOfRows)
Add a
LIMIT clause to the query. |
SelectOffsetStep<R> |
SelectLimitStep.limit(int numberOfRows)
Add a
LIMIT clause to the query
If there is no LIMIT or TOP clause in your
RDBMS, this may be simulated with a ROW_NUMBER() window
function and nested SELECT statements. |
SelectForUpdateStep<R> |
SelectLimitStep.limit(int offset,
int numberOfRows)
Add a
LIMIT clause to the query
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses! |
Field<String> |
Field.lower()
This method is part of the pre-2.0 API.
|
<R extends Record> |
DSLContext.mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.
|
Field<T> |
Field.minus(Field<?> value)
An alias for
Field.sub(Field). |
Field<T> |
Field.minus(Number value)
An alias for
Field.sub(Number). |
Field<T> |
Field.mod(Field<? extends Number> value)
An arithmetic expression getting the modulo of this divided by value.
|
Field<T> |
Field.mod(Number value)
An arithmetic expression getting the modulo of this divided by value.
|
Field<T> |
Field.modulo(Field<? extends Number> value)
An alias for
Field.mod(Field). |
Field<T> |
Field.modulo(Number value)
An alias for
Field.mod(Number). |
Field<T> |
Field.mul(Field<? extends Number> value)
An arithmetic expression multiplying this with value.
|
Field<T> |
Field.mul(Number value)
An arithmetic expression multiplying this with value.
|
Field<T> |
Field.multiply(Field<? extends Number> value)
An alias for
Field.mul(Field). |
Field<T> |
Field.multiply(Number value)
An alias for
Field.mul(Number). |
Table<Record> |
Table.naturalJoin(String sql)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalJoin(String sql,
Object... bindings)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalJoin(String sql,
QueryPart... parts)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalJoin(TableLike<?> table)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(String sql)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(String sql,
Object... bindings)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(String sql,
QueryPart... parts)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(TableLike<?> table)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(String sql)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(String sql,
Object... bindings)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(String sql,
QueryPart... parts)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(TableLike<?> table)
NATURAL RIGHT OUTER JOIN a table to this table. |
Condition |
Field.ne(Field<T> field)
this ! |
Field<T> |
Field.neg()
Negate this field to get its negative value.
|
Condition |
Condition.not()
Invert this condition
This is the same as calling
DSL.not(Condition) |
BetweenAndStep<T> |
Field.notBetween(Field<T> minValue)
Create a condition to check this field against some bounds.
|
Condition |
Field.notBetween(Field<T> minValue,
Field<T> maxValue)
Create a condition to check this field against some bounds.
|
BetweenAndStep<T> |
Field.notBetween(T minValue)
Create a condition to check this field against some bounds.
|
Condition |
Field.notBetween(T minValue,
T maxValue)
Create a condition to check this field against some bounds.
|
BetweenAndStep<T> |
Field.notBetweenSymmetric(Field<T> minValue)
Create a condition to check this field against some bounds.
|
Condition |
Field.notBetweenSymmetric(Field<T> minValue,
Field<T> maxValue)
Create a condition to check this field against some bounds.
|
BetweenAndStep<T> |
Field.notBetweenSymmetric(T minValue)
Create a condition to check this field against some bounds.
|
Condition |
Field.notBetweenSymmetric(T minValue,
T maxValue)
Create a condition to check this field against some bounds.
|
Condition |
Field.notIn(Collection<T> values)
Create a condition to check this field against several values.
|
Condition |
Field.notIn(Field<?>... values)
Create a condition to check this field against several values.
|
Condition |
Field.notIn(Select<? extends Record1<T>> query)
Create a condition to check this field against a subquery.
|
Condition |
Field.notIn(T... values)
Create a condition to check this field against several values.
|
Condition |
Field.notLike(Field<String> field)
Create a condition to pattern-check this field against a field.
|
Condition |
Field.notLike(Field<String> field,
char escape)
Create a condition to pattern-check this field against a field.
|
Condition |
Field.notLike(String value)
Create a condition to pattern-check this field against a value.
|
Condition |
Field.notLike(String value,
char escape)
Create a condition to pattern-check this field against a value.
|
Condition |
Field.notLikeIgnoreCase(Field<String> field)
Create a condition to case-insensitively pattern-check this field against
a field.
|
Condition |
Field.notLikeIgnoreCase(Field<String> field,
char escape)
Create a condition to case-insensitively pattern-check this field against
a field.
|
Condition |
Field.notLikeIgnoreCase(String value)
Create a condition to case-insensitively pattern-check this field against
a value.
|
Condition |
Field.notLikeIgnoreCase(String value,
char escape)
Create a condition to case-insensitively pattern-check this field against
a value.
|
Condition |
Field.notLikeRegex(Field<String> pattern)
Create a condition to regex-pattern-check this field against a pattern.
|
Condition |
Field.notLikeRegex(String pattern)
Create a condition to regex-pattern-check this field against a pattern.
|
SelectOptionStep<R> |
SelectForUpdateWaitStep.noWait()
Add a
NOWAIT clause to the FOR UPDATE clause at
the end of the query. |
SortField<T> |
SortField.nullsFirst()
Add a
NULLS FIRST clause to this sort field |
SortField<T> |
SortField.nullsLast()
Add a
NULLS LAST clause to this sort field |
SelectForUpdateWaitStep<R> |
SelectForUpdateOfStep.of(Collection<? extends Field<?>> fields)
Add an
OF clause to the FOR UPDATE clause at
the end of the query. |
SelectForUpdateWaitStep<R> |
SelectForUpdateOfStep.of(Field<?>... fields)
Add an
OF clause to the FOR UPDATE clause at
the end of the query. |
SelectForUpdateWaitStep<R> |
SelectForUpdateOfStep.of(Table<?>... tables)
Add an
OF clause to the FOR UPDATE clause at
the end of the query. |
SelectForUpdateStep<R> |
SelectOffsetStep.offset(int offset)
Add an
OFFSET clause to the query
If there is no LIMIT .. |
TableOnConditionStep |
TableOnStep.on(Condition... conditions)
Add an
ON clause to the JOIN. |
SelectOnConditionStep<R> |
SelectOnStep.on(Condition... conditions)
Add an
ON clause to the previous JOIN. |
MergeOnConditionStep<R> |
MergeOnStep.on(Condition... conditions)
Provide join conditions and proceed to the next step
|
DivideByOnConditionStep |
DivideByOnStep.on(Condition... conditions)
Add a division condition to the
DIVIDE BY clause |
TableOnConditionStep |
TableOnStep.on(Field<Boolean> condition)
Add an
ON clause to the JOIN. |
SelectOnConditionStep<R> |
SelectOnStep.on(Field<Boolean> condition)
Add an
ON clause to the previous JOIN. |
MergeOnConditionStep<R> |
MergeOnStep.on(Field<Boolean> condition)
Provide join conditions and proceed to the next step
|
DivideByOnConditionStep |
DivideByOnStep.on(Field<Boolean> condition)
Add a division condition to the
DIVIDE BY clause |
<T> PivotInStep<T> |
PivotForStep.on(Field<T> field)
Add a list of fields to the
PIVOT clause. |
Condition |
Condition.or(Condition other)
Combine this condition with another one using the
Operator.OR
operator. |
Condition |
Condition.or(Field<Boolean> other)
Combine this condition with another one using the
Operator.OR
operator. |
WindowRowsStep<T> |
WindowOrderByStep.orderBy(Collection<? extends SortField<?>> fields)
Add an
ORDER BY clause to the window function. |
SelectSeekStepN<R> |
SelectOrderByStep.orderBy(Collection<? extends SortField<?>> fields)
Add an
ORDER BY clause to the query |
GroupConcatSeparatorStep |
GroupConcatOrderByStep.orderBy(Collection<? extends SortField<?>> fields)
Add an
ORDER BY clause to the query |
WindowRowsStep<T> |
WindowOrderByStep.orderBy(Field<?>... fields)
Add an
ORDER BY clause to the window function. |
SelectSeekStepN<R> |
SelectOrderByStep.orderBy(Field<?>... fields)
Add an
ORDER BY clause to the query |
GroupConcatSeparatorStep |
GroupConcatOrderByStep.orderBy(Field<?>... fields)
Add an
ORDER BY clause to the query |
SelectLimitStep<R> |
SelectOrderByStep.orderBy(int... fieldIndexes)
Add an
ORDER BY clause to the query
Indexes start at 1 in SQL! |
WindowRowsStep<T> |
WindowOrderByStep.orderBy(SortField<?>... fields)
Add an
ORDER BY clause to the window function. |
SelectSeekStepN<R> |
SelectOrderByStep.orderBy(SortField<?>... fields)
Add an
ORDER BY clause to the query |
GroupConcatSeparatorStep |
GroupConcatOrderByStep.orderBy(SortField<?>... fields)
Add an
ORDER BY clause to the query |
SelectLimitStep<R> |
SelectOrderByStep.orderSiblingsBy(Collection<? extends SortField<?>> fields)
Add an
ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves. |
SelectLimitStep<R> |
SelectOrderByStep.orderSiblingsBy(Field<?>... fields)
Add an
ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves. |
SelectLimitStep<R> |
SelectOrderByStep.orderSiblingsBy(int... fieldIndexes)
Add an
ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves. |
SelectLimitStep<R> |
SelectOrderByStep.orderSiblingsBy(SortField<?>... fields)
Add an
ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves. |
Condition |
Condition.orExists(Select<?> select)
Combine this condition with an EXISTS clause using the
Operator.OR operator. |
Condition |
Condition.orNot(Condition other)
Combine this condition with a negated other one using the
Operator.OR operator. |
Condition |
Condition.orNot(Field<Boolean> other)
Combine this condition with a negated other one using the
Operator.OR operator. |
Condition |
Condition.orNotExists(Select<?> select)
Combine this condition with a NOT EXIST clause using the
Operator.OR operator. |
Table<Record> |
Table.outerApply(String sql)
OUTER APPLY a table to this table. |
Table<Record> |
Table.outerApply(String sql,
Object... bindings)
OUTER APPLY a table to this table. |
Table<Record> |
Table.outerApply(String sql,
QueryPart... parts)
OUTER APPLY a table to this table. |
Table<Record> |
Table.outerApply(TableLike<?> table)
OUTER APPLY a table to this table. |
WindowPartitionByStep<T> |
WindowOverStep.over()
Turn this aggregate function into a window function.
|
WindowPartitionByStep<T> |
WindowBeforeOverStep.over()
Add an
OVER clause |
WindowPartitionByStep<T> |
AggregateFunction.over()
Turn this aggregate function into a window function.
|
WindowFinalStep<T> |
WindowOverStep.over(Name name)
Turn this aggregate function into a window function referencing a window
name.
|
WindowFinalStep<T> |
AggregateFunction.over(Name name)
Turn this aggregate function into a window function referencing a window
name.
|
WindowFinalStep<T> |
WindowOverStep.over(String name)
Turn this aggregate function into a window function referencing a window
name.
|
WindowFinalStep<T> |
AggregateFunction.over(String name)
Turn this aggregate function into a window function referencing a window
name.
|
WindowFinalStep<T> |
WindowOverStep.over(WindowDefinition definition)
Turn this aggregate function into a window function referencing a window
definition.
|
WindowFinalStep<T> |
AggregateFunction.over(WindowDefinition definition)
Turn this aggregate function into a window function referencing a window
definition.
|
WindowFinalStep<T> |
WindowOverStep.over(WindowSpecification specification)
Turn this aggregate function into a window function.
|
WindowFinalStep<T> |
AggregateFunction.over(WindowSpecification specification)
Turn this aggregate function into a window function.
|
TableOnStep |
TablePartitionByStep.partitionBy(Collection<? extends Field<?>> fields)
Add a
PARTITION BY clause to the right hand side of the
OUTER JOIN keywords |
WindowOrderByStep<T> |
WindowPartitionByStep.partitionBy(Field<?>... fields)
Add a
PARTITION BY clause to the window functions. |
TableOnStep |
TablePartitionByStep.partitionBy(Field<?>... fields)
Add a
PARTITION BY clause to the right hand side of the
OUTER JOIN keywords |
WindowOrderByStep<T> |
WindowPartitionByStep.partitionByOne()
Add a
PARTITION BY 1 clause to the window functions, where
such a clause is required by the syntax of an RDBMS. |
PivotForStep |
Table.pivot(Collection<? extends Field<?>> aggregateFunctions)
Create a new
TABLE reference from this table, pivoting it
into another form
For more details, see Table.pivot(Field...) |
PivotForStep |
Table.pivot(Field<?>... aggregateFunctions)
Create a new
TABLE reference from this table, pivoting it
into another form
This has been observed to work with
SQLDialect.ORACLE11G upwards
SQLDialect.SQLSERVER (not yet officially supported)
Other dialects by using some means of simulation (not yet officially
supported)
|
Field<T> |
Field.plus(Field<?> value)
An alias for
Field.add(Field). |
Field<T> |
Field.plus(Number value)
An alias for
Field.add(Number). |
WindowOverStep<T> |
WindowIgnoreNullsStep.respectNulls()
Add a
RESPECT NULLS clause to the window function. |
TruncateCascadeStep<R> |
TruncateIdentityStep.restartIdentity()
Add the
RESTART IDENTITY clause to the TRUNCATE
statement. |
TruncateFinalStep<R> |
TruncateCascadeStep.restrict()
Add the
RESTRICT clause to the TRUNCATE
statement. |
Table<Record> |
DivideByReturningStep.returning(Collection<? extends Field<?>> fields)
Specify the fields that you want the division to return from the dividend
|
Table<Record> |
DivideByReturningStep.returning(Field<?>... fields)
Specify the fields that you want the division to return from the dividend
|
TablePartitionByStep |
Table.rightOuterJoin(String sql)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep |
Table.rightOuterJoin(String sql,
Object... bindings)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep |
Table.rightOuterJoin(String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep |
Table.rightOuterJoin(TableLike<?> table)
RIGHT OUTER JOIN a table to this table. |
WindowRowsAndStep<T> |
WindowRowsStep.rowsBetweenCurrentRow()
Add a
ROWS BETWEEN CURRENT ROW ... |
WindowRowsAndStep<T> |
WindowRowsStep.rowsBetweenFollowing(int number)
Add a
ROWS BETWEEN [number] FOLLOWING ... |
WindowRowsAndStep<T> |
WindowRowsStep.rowsBetweenPreceding(int number)
Add a
ROWS BETWEEN [number] PRECEDING ... |
WindowRowsAndStep<T> |
WindowRowsStep.rowsBetweenUnboundedFollowing()
Add a
ROWS BETWEEN UNBOUNDED FOLLOWING ... |
WindowRowsAndStep<T> |
WindowRowsStep.rowsBetweenUnboundedPreceding()
Add a
ROWS BETWEEN UNBOUNDED PRECEDING ... |
WindowFinalStep<T> |
WindowRowsStep.rowsCurrentRow()
Add a
ROWS CURRENT ROW frame clause to the window function. |
WindowFinalStep<T> |
WindowRowsStep.rowsFollowing(int number)
Add a
ROWS [number] FOLLOWING frame clause to the window
function. |
WindowFinalStep<T> |
WindowRowsStep.rowsPreceding(int number)
Add a
ROWS [number] PRECEDING frame clause to the window
function. |
WindowFinalStep<T> |
WindowRowsStep.rowsUnboundedFollowing()
Add a
ROWS UNBOUNDED FOLLOWING frame clause to the window
function. |
WindowFinalStep<T> |
WindowRowsStep.rowsUnboundedPreceding()
Add a
ROWS UNBOUNDED PRECEDING frame clause to the window
function. |
<T1> SelectSelectStep<Record1<T1>> |
DSLContext.select(Field<T1> field1)
Create a new DSL select statement.
|
<T1,T2> SelectSelectStep<Record2<T1,T2>> |
DSLContext.select(Field<T1> field1,
Field<T2> field2)
Create a new DSL select statement.
|
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> |
DSLContext.select(Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Create a new DSL select statement.
|
<T1,T2,T3,T4> |
DSLContext.select(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5> |
DSLContext.select(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6> |
DSLContext.select(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
DSLContext.select(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 select statement.
|
Merge<R> |
MergeValuesStepN.select(Select<?> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
SelectSelectStep<Record1<Integer>> |
DSLContext.selectCount()
Create a new DSL select statement for
COUNT(*). |
<T1> SelectSelectStep<Record1<T1>> |
DSLContext.selectDistinct(Field<T1> field1)
Create a new DSL select statement.
|
<T1,T2> SelectSelectStep<Record2<T1,T2>> |
DSLContext.selectDistinct(Field<T1> field1,
Field<T2> field2)
Create a new DSL select statement.
|
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> |
DSLContext.selectDistinct(Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Create a new DSL select statement.
|
<T1,T2,T3,T4> |
DSLContext.selectDistinct(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5> |
DSLContext.selectDistinct(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6> |
DSLContext.selectDistinct(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7> |
DSLContext.selectDistinct(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8> |
DSLContext.selectDistinct(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
DSLContext.selectDistinct(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
DSLContext.selectDistinct(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
DSLContext.selectDistinct(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
DSLContext.selectDistinct(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSLContext.selectDistinct(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
DSLContext.selectDistinct(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
DSLContext.selectDistinct(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
DSLContext.selectDistinct(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
DSLContext.selectDistinct(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
DSLContext.selectDistinct(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
DSLContext.selectDistinct(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
DSLContext.selectDistinct(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
DSLContext.selectDistinct(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
DSLContext.selectDistinct(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 select statement.
|
SelectSelectStep<Record1<Integer>> |
DSLContext.selectOne()
Create a new DSL select statement for a constant
1 literal. |
SelectSelectStep<Record1<Integer>> |
DSLContext.selectZero()
Create a new DSL select statement for a constant
0 literal. |
AggregateFunction<String> |
GroupConcatSeparatorStep.separator(String separator)
Specify the separator on the
GROUP_CONCAT function |
<T> UpdateSetMoreStep<R> |
UpdateSetStep.set(Field<T> field,
Field<T> value)
Set a value for a field in the
UPDATE statement. |
<T> MergeNotMatchedSetMoreStep<R> |
MergeNotMatchedSetStep.set(Field<T> field,
Field<T> value)
Set values for
INSERT in the MERGE statement's
WHEN NOT MATCHED clause. |
<T> MergeMatchedSetMoreStep<R> |
MergeMatchedSetStep.set(Field<T> field,
Field<T> value)
Set values for
UPDATE in the MERGE statement's
WHEN MATCHED clause. |
<T> UpdateSetMoreStep<R> |
UpdateSetStep.set(Field<T> field,
Select<? extends Record1<T>> value)
Set a value for a field in the
UPDATE statement. |
<T> MergeNotMatchedSetMoreStep<R> |
MergeNotMatchedSetStep.set(Field<T> field,
Select<? extends Record1<T>> value)
Set values for
INSERT in the MERGE statement's
WHEN NOT MATCHED clause. |
<T> MergeMatchedSetMoreStep<R> |
MergeMatchedSetStep.set(Field<T> field,
Select<? extends Record1<T>> value)
Set values for
UPDATE in the MERGE statement's
WHEN MATCHED clause. |
<T> UpdateSetMoreStep<R> |
UpdateSetStep.set(Field<T> field,
T value)
Set a value for a field in the
UPDATE statement. |
<T> MergeNotMatchedSetMoreStep<R> |
MergeNotMatchedSetStep.set(Field<T> field,
T value)
Set values for
INSERT in the MERGE statement's
WHEN NOT MATCHED clause. |
<T> MergeMatchedSetMoreStep<R> |
MergeMatchedSetStep.set(Field<T> field,
T value)
Set values for
UPDATE in the MERGE statement's
WHEN MATCHED clause. |
<T1> UpdateFromStep<R> |
UpdateSetFirstStep.set(Row1<T1> row,
Row1<T1> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1> UpdateFromStep<R> |
UpdateSetFirstStep.set(Row1<T1> row,
Select<? extends Record1<T1>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
UpdateSetFirstStep.set(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row,
Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
UpdateSetFirstStep.set(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row,
Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
UpdateSetFirstStep.set(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> row,
Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
UpdateSetFirstStep.set(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> row,
Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
UpdateSetFirstStep.set(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> row,
Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
UpdateSetFirstStep.set(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> row,
Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
UpdateSetFirstStep.set(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> row,
Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
UpdateSetFirstStep.set(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> row,
Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
UpdateSetFirstStep.set(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> row,
Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
UpdateSetFirstStep.set(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> row,
Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
UpdateSetFirstStep.set(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> row,
Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
UpdateSetFirstStep.set(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> row,
Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
UpdateSetFirstStep.set(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row,
Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
UpdateSetFirstStep.set(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row,
Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
UpdateSetFirstStep.set(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> row,
Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
UpdateSetFirstStep.set(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> row,
Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
UpdateSetFirstStep.set(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row,
Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
UpdateSetFirstStep.set(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row,
Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
UpdateSetFirstStep.set(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row,
Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
UpdateSetFirstStep.set(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row,
Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2> UpdateFromStep<R> |
UpdateSetFirstStep.set(Row2<T1,T2> row,
Row2<T1,T2> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2> UpdateFromStep<R> |
UpdateSetFirstStep.set(Row2<T1,T2> row,
Select<? extends Record2<T1,T2>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
UpdateSetFirstStep.set(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> row,
Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
UpdateSetFirstStep.set(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> row,
Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
UpdateSetFirstStep.set(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> row,
Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
UpdateSetFirstStep.set(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> row,
Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
UpdateSetFirstStep.set(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> row,
Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
UpdateSetFirstStep.set(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> row,
Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3> UpdateFromStep<R> |
UpdateSetFirstStep.set(Row3<T1,T2,T3> row,
Row3<T1,T2,T3> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3> UpdateFromStep<R> |
UpdateSetFirstStep.set(Row3<T1,T2,T3> row,
Select<? extends Record3<T1,T2,T3>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4> |
UpdateSetFirstStep.set(Row4<T1,T2,T3,T4> row,
Row4<T1,T2,T3,T4> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4> |
UpdateSetFirstStep.set(Row4<T1,T2,T3,T4> row,
Select<? extends Record4<T1,T2,T3,T4>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5> |
UpdateSetFirstStep.set(Row5<T1,T2,T3,T4,T5> row,
Row5<T1,T2,T3,T4,T5> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5> |
UpdateSetFirstStep.set(Row5<T1,T2,T3,T4,T5> row,
Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6> |
UpdateSetFirstStep.set(Row6<T1,T2,T3,T4,T5,T6> row,
Row6<T1,T2,T3,T4,T5,T6> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6> |
UpdateSetFirstStep.set(Row6<T1,T2,T3,T4,T5,T6> row,
Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7> |
UpdateSetFirstStep.set(Row7<T1,T2,T3,T4,T5,T6,T7> row,
Row7<T1,T2,T3,T4,T5,T6,T7> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7> |
UpdateSetFirstStep.set(Row7<T1,T2,T3,T4,T5,T6,T7> row,
Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8> |
UpdateSetFirstStep.set(Row8<T1,T2,T3,T4,T5,T6,T7,T8> row,
Row8<T1,T2,T3,T4,T5,T6,T7,T8> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8> |
UpdateSetFirstStep.set(Row8<T1,T2,T3,T4,T5,T6,T7,T8> row,
Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
UpdateSetFirstStep.set(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> row,
Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
UpdateSetFirstStep.set(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> row,
Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Specify a multi-column set clause for the
UPDATE statement. |
SelectOptionStep<R> |
SelectForUpdateWaitStep.skipLocked()
Add a
WAIT clause to the FOR UPDATE clause at
the end of the query. |
Condition |
Field.startsWith(Field<T> value)
Convenience method for
Field.like(String, char) including proper
adding of wildcards and escaping. |
Condition |
Field.startsWith(T value)
Convenience method for
Field.like(String, char) including proper
adding of wildcards and escaping. |
SelectGroupByStep<R> |
SelectStartWithStep.startWith(Condition condition)
Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause. |
SelectGroupByStep<R> |
SelectStartWithStep.startWith(Field<Boolean> condition)
Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause. |
Field<T> |
Field.sub(Field<?> value)
An arithmetic expression subtracting value from this.
|
Field<T> |
Field.sub(Number value)
An arithmetic expression subtracting value from this.
|
Field<T> |
Field.subtract(Field<?> value)
An alias for
Field.sub(Field). |
Field<T> |
Field.subtract(Number value)
An alias for
Field.sub(Number). |
<R extends Record> |
DSLContext.truncate(Table<R> table)
Create a new DSL truncate statement.
|
<R extends Record> |
DSLContext.update(Table<R> table)
Create a new DSL update statement.
|
Field<String> |
Field.upper()
This method is part of the pre-2.0 API.
|
Table<Record> |
TableOnStep.using(Field<?>... fields)
Join a table with the
USING(column [, column...]) |
SelectJoinStep<R> |
SelectOnStep.using(Field<?>... fields)
Join the previous table with the
USING(column [, column...]) |
MergeOnStep<R> |
MergeUsingStep.using(TableLike<?> table)
Add the
USING clause to the SQL standard MERGE
statement |
MergeOnStep<R> |
MergeUsingStep.usingDual()
Add a dummy
USING clause to the SQL standard
MERGE statement
This results in USING(SELECT 1 FROM DUAL) for most RDBMS, or
in USING(SELECT 1) AS [dummy_table(dummy_field)] in SQL
Server, where derived tables need to be aliased. |
Merge<R> |
MergeValuesStepN.values(Collection<?> values)
Specify a
VALUES clause |
MergeNotMatchedWhereStep<R> |
MergeNotMatchedValuesStepN.values(Collection<?> values)
Set
VALUES for INSERT in the MERGE
statement's WHEN NOT MATCHED THEN INSERT clause. |
Merge<R> |
MergeValuesStepN.values(Field<?>... values)
Specify a
VALUES clause |
MergeNotMatchedWhereStep<R> |
MergeNotMatchedValuesStepN.values(Field<?>... values)
Set
VALUES for INSERT in the MERGE
statement's WHEN NOT MATCHED THEN INSERT clause. |
Merge<R> |
MergeValuesStepN.values(Object... values)
Specify a
VALUES clause |
MergeNotMatchedWhereStep<R> |
MergeNotMatchedValuesStepN.values(Object... values)
Set
VALUES for INSERT in the MERGE
statement's WHEN NOT MATCHED THEN INSERT clause. |
VersionsBetweenAndStep<R,Number> |
Table.versionsBetweenScn(Field<? extends Number> scn)
Create an
SQLDialect.ORACLE flashback versions query clause from
this table. |
VersionsBetweenAndStep<R,Number> |
Table.versionsBetweenScn(Number scn)
Create an
SQLDialect.ORACLE flashback versions query clause from
this table. |
VersionsBetweenAndStep<R,Number> |
Table.versionsBetweenScnMinvalue()
Create an
SQLDialect.ORACLE flashback versions query clause from
this table. |
VersionsBetweenAndStep<R,Timestamp> |
Table.versionsBetweenTimestamp(Field<Timestamp> timestamp)
Create an
SQLDialect.ORACLE flashback versions query clause from
this table. |
VersionsBetweenAndStep<R,Timestamp> |
Table.versionsBetweenTimestamp(Timestamp timestamp)
Create an
SQLDialect.ORACLE flashback versions query clause from
this table. |
VersionsBetweenAndStep<R,Timestamp> |
Table.versionsBetweenTimestampMinvalue()
Create an
SQLDialect.ORACLE flashback versions query clause from
this table. |
SelectOptionStep<R> |
SelectForUpdateWaitStep.wait(int seconds)
Add a
WAIT clause to the FOR UPDATE clause at
the end of the query. |
MergeMatchedSetStep<R> |
MergeMatchedStep.whenMatchedThenUpdate()
Add the
WHEN MATCHED THEN UPDATE clause to the
MERGE statement |
MergeNotMatchedSetStep<R> |
MergeNotMatchedStep.whenNotMatchedThenInsert()
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement. |
MergeNotMatchedValuesStepN<R> |
MergeNotMatchedStep.whenNotMatchedThenInsert(Collection<? extends Field<?>> fields)
Add the
WHEN MATCHED THEN UPDATE clause to the
MERGE statement |
MergeNotMatchedValuesStepN<R> |
MergeNotMatchedStep.whenNotMatchedThenInsert(Field<?>... fields)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
UpdateConditionStep<R> |
UpdateWhereStep.where(Collection<? extends Condition> conditions)
Add conditions to the query
|
SelectConditionStep<R> |
SelectWhereStep.where(Collection<? extends Condition> conditions)
Add a
WHERE clause to the query. |
DeleteConditionStep<R> |
DeleteWhereStep.where(Collection<? extends Condition> conditions)
Add conditions to the query.
|
UpdateConditionStep<R> |
UpdateWhereStep.where(Condition... conditions)
Add conditions to the query
|
SelectConditionStep<R> |
SelectWhereStep.where(Condition... conditions)
Add a
WHERE clause to the query. |
DeleteConditionStep<R> |
DeleteWhereStep.where(Condition... conditions)
Add conditions to the query.
|
MergeFinalStep<R> |
MergeNotMatchedWhereStep.where(Condition condition)
Add an additional
WHERE clause to the preceding
WHEN NOT MATCHED THEN INSERT clause. |
MergeMatchedDeleteStep<R> |
MergeMatchedWhereStep.where(Condition condition)
Add an additional
WHERE clause to the preceding
WHEN MATCHED THEN UPDATE clause. |
UpdateConditionStep<R> |
UpdateWhereStep.where(Field<Boolean> condition)
Add conditions to the query
|
SelectConditionStep<R> |
SelectWhereStep.where(Field<Boolean> field)
Add a
WHERE clause to the query. |
MergeFinalStep<R> |
MergeNotMatchedWhereStep.where(Field<Boolean> condition)
Add an additional
WHERE clause to the preceding
WHEN NOT MATCHED THEN INSERT clause. |
MergeMatchedDeleteStep<R> |
MergeMatchedWhereStep.where(Field<Boolean> condition)
Add an additional
WHERE clause to the preceding
WHEN MATCHED THEN UPDATE clause. |
DeleteConditionStep<R> |
DeleteWhereStep.where(Field<Boolean> condition)
Add conditions to the query.
|
Table<R> |
Table.with(String hint)
Specify a SQL Server style table hint for query optimisation
This makes sense only on an actual database table or view, not on other
composed table sources.
|
AggregateFunction<T> |
OrderedAggregateFunction.withinGroupOrderBy(Collection<? extends SortField<?>> fields)
Add an
WITHIN GROUP (ORDER BY ..) |
AggregateFunction<T> |
OrderedAggregateFunction.withinGroupOrderBy(Field<?>... fields)
Add an
WITHIN GROUP (ORDER BY ..) |
AggregateFunction<T> |
OrderedAggregateFunction.withinGroupOrderBy(SortField<?>... fields)
Add an
WITHIN GROUP (ORDER BY ..) |
| Modifier and Type | Method and Description |
|---|---|
static <T extends Number> |
DSL.abs(Field<T> field)
Get the absolute value of a numeric field: abs(field).
|
static <T extends Number> |
DSL.abs(T value)
Get the absolute value of a numeric field: abs(field).
|
static Field<BigDecimal> |
DSL.acos(Field<? extends Number> field)
Get the arc cosine(field) function.
|
static Field<BigDecimal> |
DSL.acos(Number value)
Get the arc cosine(field) function.
|
static <T> QuantifiedSelect<Record1<T>> |
DSL.all(Field<T[]> array)
Create an
ALL quantified select to be used in quantified
comparison predicate expressions. |
static <R extends Record> |
DSL.all(Select<R> select)
Create an
ALL quantified select to be used in quantified
comparison predicate expressions. |
static <T> QuantifiedSelect<Record1<T>> |
DSL.all(T... array)
Create an
ALL quantified select to be used in quantified
comparison predicate expressions. |
static <T> QuantifiedSelect<Record1<T>> |
DSL.any(Field<T[]> array)
Create an
ANY quantified select to be used in quantified
comparison predicate expressions. |
static <R extends Record> |
DSL.any(Select<R> select)
Create an
ANY quantified select to be used in quantified
comparison predicate expressions. |
static <T> QuantifiedSelect<Record1<T>> |
DSL.any(T... array)
Create an
ANY quantified select to be used in quantified
comparison predicate expressions. |
static Field<BigDecimal> |
DSL.asin(Field<? extends Number> field)
Get the arc sine(field) function.
|
static Field<BigDecimal> |
DSL.asin(Number value)
Get the arc sine(field) function.
|
static Field<BigDecimal> |
DSL.atan(Field<? extends Number> field)
Get the arc tangent(field) function.
|
static Field<BigDecimal> |
DSL.atan(Number value)
Get the arc tangent(field) function.
|
static Field<BigDecimal> |
DSL.atan2(Field<? extends Number> x,
Field<? extends Number> y)
Get the atan2(field, y) function.
|
static Field<BigDecimal> |
DSL.atan2(Field<? extends Number> x,
Number y)
Get the atan2(field, y) function.
|
static Field<BigDecimal> |
DSL.atan2(Number x,
Field<? extends Number> y)
Get the atan2(field, y) function.
|
static Field<BigDecimal> |
DSL.atan2(Number x,
Number y)
Get the atan2(field, y) function.
|
static AggregateFunction<BigDecimal> |
DSL.avg(Field<? extends Number> field)
Get the average over a numeric field: avg(field).
|
static AggregateFunction<BigDecimal> |
DSL.avgDistinct(Field<? extends Number> field)
Get the average over a numeric field: avg(distinct field).
|
static <T extends Number> |
DSL.bitAnd(Field<T> field1,
Field<T> field2)
The bitwise and operator.
|
static <T extends Number> |
DSL.bitAnd(Field<T> value1,
T value2)
The bitwise and operator.
|
static <T extends Number> |
DSL.bitAnd(T value1,
Field<T> value2)
The bitwise and operator.
|
static <T extends Number> |
DSL.bitAnd(T value1,
T value2)
The bitwise and operator.
|
static Field<Integer> |
DSL.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> |
DSL.bitCount(Number value)
The MySQL
BIT_COUNT(field) function, counting the number of
bits that are set in this number. |
static <T extends Number> |
DSL.bitNand(Field<T> field1,
Field<T> field2)
The bitwise not and operator.
|
static <T extends Number> |
DSL.bitNand(Field<T> value1,
T value2)
The bitwise not and operator.
|
static <T extends Number> |
DSL.bitNand(T value1,
Field<T> value2)
The bitwise not and operator.
|
static <T extends Number> |
DSL.bitNand(T value1,
T value2)
The bitwise not and operator.
|
static <T extends Number> |
DSL.bitNor(Field<T> field1,
Field<T> field2)
The bitwise not or operator.
|
static <T extends Number> |
DSL.bitNor(Field<T> value1,
T value2)
The bitwise not or operator.
|
static <T extends Number> |
DSL.bitNor(T value1,
Field<T> value2)
The bitwise not or operator.
|
static <T extends Number> |
DSL.bitNor(T value1,
T value2)
The bitwise not or operator.
|
static <T extends Number> |
DSL.bitNot(Field<T> field)
The bitwise not operator.
|
static <T extends Number> |
DSL.bitNot(T value)
The bitwise not operator.
|
static <T extends Number> |
DSL.bitOr(Field<T> field1,
Field<T> field2)
The bitwise or operator.
|
static <T extends Number> |
DSL.bitOr(Field<T> value1,
T value2)
The bitwise or operator.
|
static <T extends Number> |
DSL.bitOr(T value1,
Field<T> value2)
The bitwise or operator.
|
static <T extends Number> |
DSL.bitOr(T value1,
T value2)
The bitwise or operator.
|
static <T extends Number> |
DSL.bitXNor(Field<T> field1,
Field<T> field2)
The bitwise not xor operator.
|
static <T extends Number> |
DSL.bitXNor(Field<T> value1,
T value2)
The bitwise not xor operator.
|
static <T extends Number> |
DSL.bitXNor(T value1,
Field<T> value2)
The bitwise not xor operator.
|
static <T extends Number> |
DSL.bitXNor(T value1,
T value2)
The bitwise not xor operator.
|
static <T extends Number> |
DSL.bitXor(Field<T> field1,
Field<T> field2)
The bitwise xor operator.
|
static <T extends Number> |
DSL.bitXor(Field<T> value1,
T value2)
The bitwise xor operator.
|
static <T extends Number> |
DSL.bitXor(T value1,
Field<T> value2)
The bitwise xor operator.
|
static <T extends Number> |
DSL.bitXor(T value1,
T value2)
The bitwise xor operator.
|
static <T extends Number> |
DSL.ceil(Field<T> field)
Get the smallest integer value not less than [field].
|
static <T extends Number> |
DSL.ceil(T value)
Get the smallest integer value not less than [this].
|
static <T> Field<T> |
DSL.coalesce(Field<T> field,
Field<?>... fields)
Gets the Oracle-style
COALESCE(field1, field2, ... , field n)
function. |
static <T> Field<T> |
DSL.coalesce(T value,
T... values)
Gets the Oracle-style
COALESCE(value1, value2, ... , value n)
function. |
static Field<Boolean> |
DSL.connectByIsCycle()
Retrieve the Oracle-specific
CONNECT_BY_ISCYCLE pseudo-field
(to be used along with CONNECT BY clauses). |
static Field<Boolean> |
DSL.connectByIsLeaf()
Retrieve the Oracle-specific
CONNECT_BY_ISLEAF pseudo-field
(to be used along with CONNECT BY clauses). |
static <T> Field<T> |
DSL.connectByRoot(Field<T> field)
Retrieve the Oracle-specific
CONNECT_BY_ROOT pseudo-column
(to be used along with CONNECT BY clauses). |
static Field<BigDecimal> |
DSL.cos(Field<? extends Number> field)
Get the cosine(field) function.
|
static Field<BigDecimal> |
DSL.cos(Number value)
Get the cosine(field) function.
|
static Field<BigDecimal> |
DSL.cosh(Field<? extends Number> field)
Get the hyperbolic cosine function: cosh(field).
|
static Field<BigDecimal> |
DSL.cosh(Number value)
Get the hyperbolic cosine function: cosh(field).
|
static Field<BigDecimal> |
DSL.cot(Field<? extends Number> field)
Get the cotangent(field) function.
|
static Field<BigDecimal> |
DSL.cot(Number value)
Get the cotangent(field) function.
|
static Field<BigDecimal> |
DSL.coth(Field<? extends Number> field)
Get the hyperbolic cotangent function: coth(field).
|
static Field<BigDecimal> |
DSL.coth(Number value)
Get the hyperbolic cotangent function: coth(field).
|
static AggregateFunction<Integer> |
DSL.count()
Get the count(*) function.
|
static AggregateFunction<Integer> |
DSL.count(Field<?> field)
Get the count(field) function.
|
static AggregateFunction<Integer> |
DSL.countDistinct(Field<?>... fields)
Get the count(distinct field1, field2) function.
|
static AggregateFunction<Integer> |
DSL.countDistinct(Field<?> field)
Get the count(distinct field) function.
|
static GroupField |
DSL.cube(Field<?>... fields)
Create a CUBE(field1, field2, .., fieldn) grouping field.
|
static WindowOverStep<BigDecimal> |
DSL.cumeDist()
The
cume_dist() over ([analytic clause]) function. |
static Field<Date> |
DSL.currentDate()
Get the current_date() function.
|
static Field<Time> |
DSL.currentTime()
Get the current_time() function.
|
static Field<Timestamp> |
DSL.currentTimestamp()
Get the current_timestamp() function.
|
static Field<String> |
DSL.currentUser()
Get the current_user() function.
|
static Field<Date> |
DSL.dateAdd(Date date,
Number interval)
Add an interval to a date.
|
static Field<Date> |
DSL.dateAdd(Field<Date> date,
Field<? extends Number> interval)
Add an interval to a date.
|
static Field<Integer> |
DSL.dateDiff(Date date1,
Date date2)
Get the date difference in number of days.
|
static Field<Integer> |
DSL.dateDiff(Date date1,
Field<Date> date2)
Get the date difference in number of days.
|
static Field<Integer> |
DSL.dateDiff(Field<Date> date1,
Date date2)
Get the date difference in number of days.
|
static Field<Integer> |
DSL.dateDiff(Field<Date> date1,
Field<Date> date2)
Get the date difference in number of days.
|
static Field<Integer> |
DSL.day(Date value)
Get the day part of a date.
|
static Field<Integer> |
DSL.day(Field<? extends Date> field)
Get the day part of a date.
|
static Field<BigDecimal> |
DSL.deg(Field<? extends Number> field)
Calculate degrees from radians from this field.
|
static Field<BigDecimal> |
DSL.deg(Number value)
Calculate degrees from radians from this field.
|
static <R extends Record> |
DSL.delete(Table<R> table)
Create a new DSL delete statement.
|
static WindowOverStep<Integer> |
DSL.denseRank()
The
dense_rank() over ([analytic clause]) function. |
static Field<BigDecimal> |
DSL.e()
The
E literal (Euler number). |
static Condition |
DSL.exists(Select<?> query)
Create an exists condition.
|
static Field<BigDecimal> |
DSL.exp(Field<? extends Number> field)
Get the exp(field) function, taking this field as the power of e.
|
static Field<BigDecimal> |
DSL.exp(Number value)
Get the exp(field) function, taking this field as the power of e.
|
static Field<Integer> |
DSL.extract(Date value,
DatePart datePart)
Get the extract(field, datePart) function.
|
static Field<Integer> |
DSL.extract(Field<? extends Date> field,
DatePart datePart)
Get the extract(field, datePart) function.
|
static Condition |
DSL.falseCondition()
Return a
Condition that will always evaluate to false. |
static <T> WindowIgnoreNullsStep<T> |
DSL.firstValue(Field<T> field)
The
first_value(field) over ([analytic clause]) function. |
static <T extends Number> |
DSL.floor(Field<T> field)
Get the largest integer value not greater than [this].
|
static <T extends Number> |
DSL.floor(T value)
Get the largest integer value not greater than [this].
|
static <T> Field<T> |
DSL.greatest(Field<T> field,
Field<?>... others)
Find the greatest among all values.
|
static <T> Field<T> |
DSL.greatest(T value,
T... values)
Find the greatest among all values.
|
static GroupConcatOrderByStep |
DSL.groupConcat(Field<?> field)
Get the aggregated concatenation for a field.
|
static AggregateFunction<String> |
DSL.groupConcat(Field<?> field,
String separator)
Get the aggregated concatenation for a field.
|
static GroupConcatOrderByStep |
DSL.groupConcatDistinct(Field<?> field)
Get the aggregated concatenation for a field.
|
static Field<Integer> |
DSL.grouping(Field<?> field)
Create a GROUPING(field) aggregation field to be used along with
CUBE, ROLLUP, and GROUPING SETS
groupings. |
static Field<Integer> |
DSL.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 |
DSL.groupingSets(Collection<? extends Field<?>>... fieldSets)
Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna,
fieldnb)) grouping field.
|
static GroupField |
DSL.groupingSets(Field<?>... fields)
Create a GROUPING SETS(field1, field2, .., fieldn) grouping field where
each grouping set only consists of a single field.
|
static GroupField |
DSL.groupingSets(Field<?>[]... fieldSets)
Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna,
fieldnb)) grouping field.
|
static Field<Integer> |
DSL.hour(Date value)
Get the hour part of a date.
|
static Field<Integer> |
DSL.hour(Field<? extends Date> field)
Get the hour part of a date.
|
static <T> Field<T> |
DSL.isnull(Field<T> value,
Field<T> defaultValue)
Gets the SQL Server-style ISNULL(value, defaultValue) function.
|
static <T> Field<T> |
DSL.isnull(Field<T> value,
T defaultValue)
Gets the SQL Server-style ISNULL(value, defaultValue) function.
|
static <T> Field<T> |
DSL.isnull(T value,
Field<T> defaultValue)
Gets the SQL Server-style ISNULL(value, defaultValue) function.
|
static <T> Field<T> |
DSL.isnull(T value,
T defaultValue)
Gets the SQL Server-style ISNULL(value, defaultValue) function.
|
static <T> WindowIgnoreNullsStep<T> |
DSL.lag(Field<T> field)
The
lag(field) over ([analytic clause]) function. |
static <T> WindowIgnoreNullsStep<T> |
DSL.lag(Field<T> field,
int offset)
The
lag(field, offset) over ([analytic clause]) function. |
static <T> WindowIgnoreNullsStep<T> |
DSL.lag(Field<T> field,
int offset,
Field<T> defaultValue)
The
lag(field, offset, defaultValue) over ([analytic clause])
function. |
static <T> WindowIgnoreNullsStep<T> |
DSL.lag(Field<T> field,
int offset,
T defaultValue)
The
lag(field, offset, defaultValue) over ([analytic clause])
function. |
static <T> WindowIgnoreNullsStep<T> |
DSL.lastValue(Field<T> field)
The
last_value(field) over ([analytic clause]) function. |
static <T> WindowIgnoreNullsStep<T> |
DSL.lead(Field<T> field)
The
lead(field) over ([analytic clause]) function. |
static <T> WindowIgnoreNullsStep<T> |
DSL.lead(Field<T> field,
int offset)
The
lead(field, offset) over ([analytic clause]) function. |
static <T> WindowIgnoreNullsStep<T> |
DSL.lead(Field<T> field,
int offset,
Field<T> defaultValue)
The
lead(field, offset, defaultValue) over ([analytic clause])
function. |
static <T> WindowIgnoreNullsStep<T> |
DSL.lead(Field<T> field,
int offset,
T defaultValue)
The
lead(field, offset, defaultValue) over ([analytic clause])
function. |
static <T> Field<T> |
DSL.least(Field<T> field,
Field<?>... others)
Find the least among all values.
|
static <T> Field<T> |
DSL.least(T value,
T... values)
Find the least among all values.
|
static Field<Integer> |
DSL.level()
Retrieve the Oracle-specific
LEVEL pseudo-field (to be used
along with CONNECT BY clauses). |
static OrderedAggregateFunction<String> |
DSL.listAgg(Field<?> field)
Get the aggregated concatenation for a field.
|
static OrderedAggregateFunction<String> |
DSL.listAgg(Field<?> field,
String separator)
Get the aggregated concatenation for a field.
|
static Field<BigDecimal> |
DSL.ln(Field<? extends Number> field)
Get the ln(field) function, taking the natural logarithm of this field.
|
static Field<BigDecimal> |
DSL.ln(Number value)
Get the ln(field) function, taking the natural logarithm of this field.
|
static Field<BigDecimal> |
DSL.log(Field<? extends Number> field,
int base)
Get the log(field, base) function.
|
static Field<BigDecimal> |
DSL.log(Number value,
int base)
Get the log(field, base) function.
|
static Field<String> |
DSL.lower(Field<String> field)
Get the lower(field) function.
|
static Field<String> |
DSL.lower(String value)
Get the lower(field) function.
|
static Field<String> |
DSL.lpad(Field<String> field,
Field<? extends Number> length)
Get the lpad(field, length) function.
|
static Field<String> |
DSL.lpad(Field<String> field,
Field<? extends Number> length,
Field<String> character)
Get the lpad(field, length, character) function.
|
static Field<String> |
DSL.lpad(Field<String> field,
int length)
Get the lpad(field, length) function.
|
static Field<String> |
DSL.lpad(Field<String> field,
int length,
char character)
Get the lpad(field, length, character) function.
|
static Field<String> |
DSL.lpad(Field<String> field,
int length,
String character)
Get the lpad(field, length, character) function.
|
static Field<String> |
DSL.ltrim(Field<String> field)
Get the ltrim(field) function.
|
static Field<String> |
DSL.ltrim(String value)
Get the ltrim(field) function.
|
static <T> AggregateFunction<T> |
DSL.max(Field<T> field)
Get the max value over a field: max(field).
|
static <T> AggregateFunction<T> |
DSL.maxDistinct(Field<T> field)
Get the max value over a field: max(distinct field).
|
static AggregateFunction<BigDecimal> |
DSL.median(Field<? extends Number> field)
Get the median over a numeric field: median(field).
|
static <R extends Record> |
DSL.mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.
|
static <T> AggregateFunction<T> |
DSL.min(Field<T> field)
Get the min value over a field: min(field).
|
static <T> AggregateFunction<T> |
DSL.minDistinct(Field<T> field)
Get the min value over a field: min(distinct field).
|
static Field<Integer> |
DSL.minute(Date value)
Get the minute part of a date.
|
static Field<Integer> |
DSL.minute(Field<? extends Date> field)
Get the minute part of a date.
|
static Field<Integer> |
DSL.month(Date value)
Get the month part of a date.
|
static Field<Integer> |
DSL.month(Field<? extends Date> field)
Get the month part of a date.
|
static Condition |
DSL.not(Condition condition)
Invert a condition.
|
static Condition |
DSL.notExists(Select<?> query)
Create a not exists condition.
|
static WindowOverStep<Integer> |
DSL.ntile(int number)
The
ntile([number]) over ([analytic clause]) function. |
static <T> Field<T> |
DSL.nullif(Field<T> value,
Field<T> other)
Gets the Oracle-style NULLIF(value, other) function.
|
static <T> Field<T> |
DSL.nullif(Field<T> value,
T other)
Gets the Oracle-style NULLIF(value, other) function.
|
static <T> Field<T> |
DSL.nullif(T value,
Field<T> other)
Gets the Oracle-style NULLIF(value, other) function.
|
static <T> Field<T> |
DSL.nullif(T value,
T other)
Gets the Oracle-style NULLIF(value, other) function.
|
static <T> Field<T> |
DSL.nvl(Field<T> value,
Field<T> defaultValue)
Gets the Oracle-style NVL(value, defaultValue) function.
|
static <T> Field<T> |
DSL.nvl(Field<T> value,
T defaultValue)
Gets the Oracle-style NVL(value, defaultValue) function.
|
static <T> Field<T> |
DSL.nvl(T value,
Field<T> defaultValue)
Gets the Oracle-style NVL(value, defaultValue) function.
|
static <T> Field<T> |
DSL.nvl(T value,
T defaultValue)
Gets the Oracle-style NVL(value, defaultValue) function.
|
static <Z> Field<Z> |
DSL.nvl2(Field<?> value,
Field<Z> valueIfNotNull,
Field<Z> valueIfNull)
Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.
|
static <Z> Field<Z> |
DSL.nvl2(Field<?> value,
Field<Z> valueIfNotNull,
Z valueIfNull)
Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.
|
static <Z> Field<Z> |
DSL.nvl2(Field<?> value,
Z valueIfNotNull,
Field<Z> valueIfNull)
Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.
|
static <Z> Field<Z> |
DSL.nvl2(Field<?> value,
Z valueIfNotNull,
Z valueIfNull)
Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.
|
static Field<Integer> |
DSL.one()
A
1 literal. |
static WindowOverStep<BigDecimal> |
DSL.percentRank()
The
precent_rank() over ([analytic clause]) function. |
static Field<BigDecimal> |
DSL.pi()
The
PI literal. |
static Field<BigDecimal> |
DSL.power(Field<? extends Number> field,
Field<? extends Number> exponent)
Get the power(field, exponent) function.
|
static Field<BigDecimal> |
DSL.power(Field<? extends Number> field,
Number exponent)
Get the power(field, exponent) function.
|
static Field<BigDecimal> |
DSL.power(Number value,
Field<? extends Number> exponent)
Get the power(field, exponent) function.
|
static Field<BigDecimal> |
DSL.power(Number value,
Number exponent)
Get the power(field, exponent) function.
|
static <T> Field<T> |
DSL.prior(Field<T> field)
Add the Oracle-specific
PRIOR unary operator before a field
(to be used along with CONNECT BY clauses). |
static Field<BigDecimal> |
DSL.rad(Field<? extends Number> field)
Calculate radians from degrees from this field.
|
static Field<BigDecimal> |
DSL.rad(Number value)
Calculate radians from degrees from this field.
|
static Field<BigDecimal> |
DSL.rand()
Get the rand() function.
|
static WindowOverStep<Integer> |
DSL.rank()
The
rank_over() over ([analytic clause]) function. |
static AggregateFunction<BigDecimal> |
DSL.regrAvgX(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_AVGX linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrAvgY(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_AVGY linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrCount(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_COUNT linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrIntercept(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_INTERCEPT linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrR2(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_R2 linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrSlope(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_SLOPE linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrSXX(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_SXX linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrSXY(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_SXY linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrSYY(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_SYY linear regression function. |
static GroupField |
DSL.rollup(Field<?>... fields)
Create a ROLLUP(field1, field2, .., fieldn) grouping field.
|
static <T extends Number> |
DSL.round(Field<T> field)
Get rounded value of a numeric field: round(field).
|
static <T extends Number> |
DSL.round(Field<T> field,
int decimals)
Get rounded value of a numeric field: round(field, decimals).
|
static <T extends Number> |
DSL.round(T value)
Get rounded value of a numeric field: round(field).
|
static <T extends Number> |
DSL.round(T value,
int decimals)
Get rounded value of a numeric field: round(field, decimals).
|
static <T1> Row1<T1> |
DSL.row(Field<T1> t1)
Create a row value expression of degree
1. |
static <T1,T2> Row2<T1,T2> |
DSL.row(Field<T1> t1,
Field<T2> t2)
Create a row value expression of degree
2. |
static <T1,T2,T3> Row3<T1,T2,T3> |
DSL.row(Field<T1> t1,
Field<T2> t2,
Field<T3> t3)
Create a row value expression of degree
3. |
static <T1,T2,T3,T4> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.row(Field<T1> t1,
Field<T2> t2,
Field<T3> t3,
Field<T4> t4,
Field<T5> t5,
Field<T6> t6,
Field<T7> t7,
Field<T8> t8,
Field<T9> t9,
Field<T10> t10,
Field<T11> t11,
Field<T12> t12,
Field<T13> t13,
Field<T14> t14,
Field<T15> t15,
Field<T16> t16,
Field<T17> t17,
Field<T18> t18,
Field<T19> t19,
Field<T20> t20,
Field<T21> t21,
Field<T22> t22)
Create a row value expression of degree
22. |
static <T1> Row1<T1> |
DSL.row(T1 t1)
Create a row value expression of degree
1. |
static <T1,T2> Row2<T1,T2> |
DSL.row(T1 t1,
T2 t2)
Create a row value expression of degree
2. |
static <T1,T2,T3> Row3<T1,T2,T3> |
DSL.row(T1 t1,
T2 t2,
T3 t3)
Create a row value expression of degree
3. |
static <T1,T2,T3,T4> |
DSL.row(T1 t1,
T2 t2,
T3 t3,
T4 t4)
Create a row value expression of degree
4. |
static <T1,T2,T3,T4,T5> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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 WindowOverStep<Integer> |
DSL.rowNumber()
The
row_number() over ([analytic clause]) function. |
static Field<String> |
DSL.rpad(Field<String> field,
Field<? extends Number> length)
Get the rpad(field, length) function.
|
static Field<String> |
DSL.rpad(Field<String> field,
Field<? extends Number> length,
Field<String> character)
Get the rpad(field, length, character) function.
|
static Field<String> |
DSL.rpad(Field<String> field,
int length)
Get the rpad(field, length) function.
|
static Field<String> |
DSL.rpad(Field<String> field,
int length,
char character)
Get the rpad(field, length, character) function.
|
static Field<String> |
DSL.rpad(Field<String> field,
int length,
String character)
Get the rpad(field, length, character) function.
|
static Field<String> |
DSL.rtrim(Field<String> field)
Get the rtrim(field) function.
|
static Field<String> |
DSL.rtrim(String value)
Get the rtrim(field) function.
|
static Field<Integer> |
DSL.second(Date value)
Get the second part of a date.
|
static Field<Integer> |
DSL.second(Field<? extends Date> field)
Get the second part of a date.
|
static SelectSelectStep<Record> |
DSL.select(Collection<? extends Field<?>> fields)
Create a new DSL subselect statement.
|
static SelectSelectStep<Record> |
DSL.select(Field<?>... fields)
Create a new DSL subselect statement.
|
static <T1> SelectSelectStep<Record1<T1>> |
DSL.select(Field<T1> field1)
Create a new DSL subselect statement.
|
static <T1,T2> SelectSelectStep<Record2<T1,T2>> |
DSL.select(Field<T1> field1,
Field<T2> field2)
Create a new DSL subselect statement.
|
static <T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> |
DSL.select(Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Create a new DSL subselect statement.
|
static <T1,T2,T3,T4> |
DSL.select(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
Create a new DSL subselect statement.
|
static <T1,T2,T3,T4,T5> |
DSL.select(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
Create a new DSL subselect statement.
|
static <T1,T2,T3,T4,T5,T6> |
DSL.select(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
Create a new DSL subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7> |
DSL.select(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8> |
DSL.select(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9> |
DSL.select(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
DSL.select(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
DSL.select(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
DSL.select(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSL.select(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
DSL.select(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
DSL.select(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
DSL.select(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
DSL.select(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
DSL.select(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
DSL.select(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
DSL.select(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
DSL.select(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 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> |
DSL.select(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 subselect statement.
|
static SelectSelectStep<Record1<Integer>> |
DSL.selectCount()
Create a new DSL subselect statement for
COUNT(*). |
static SelectSelectStep<Record> |
DSL.selectDistinct(Collection<? extends Field<?>> fields)
Create a new DSL subselect statement.
|
static SelectSelectStep<Record> |
DSL.selectDistinct(Field<?>... fields)
Create a new DSL subselect statement.
|
static <T1> SelectSelectStep<Record1<T1>> |
DSL.selectDistinct(Field<T1> field1)
Create a new DSL subselect statement.
|
static <T1,T2> SelectSelectStep<Record2<T1,T2>> |
DSL.selectDistinct(Field<T1> field1,
Field<T2> field2)
Create a new DSL subselect statement.
|
static <T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> |
DSL.selectDistinct(Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Create a new DSL subselect statement.
|
static <T1,T2,T3,T4> |
DSL.selectDistinct(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
Create a new DSL subselect statement.
|
static <T1,T2,T3,T4,T5> |
DSL.selectDistinct(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
Create a new DSL subselect statement.
|
static <T1,T2,T3,T4,T5,T6> |
DSL.selectDistinct(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
Create a new DSL subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7> |
DSL.selectDistinct(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8> |
DSL.selectDistinct(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9> |
DSL.selectDistinct(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
DSL.selectDistinct(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
DSL.selectDistinct(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
DSL.selectDistinct(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSL.selectDistinct(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
DSL.selectDistinct(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
DSL.selectDistinct(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
DSL.selectDistinct(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
DSL.selectDistinct(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
DSL.selectDistinct(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
DSL.selectDistinct(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
DSL.selectDistinct(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 subselect statement.
|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
DSL.selectDistinct(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 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> |
DSL.selectDistinct(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 subselect statement.
|
static SelectSelectStep<Record1<Integer>> |
DSL.selectOne()
Create a new DSL subselect statement for a constant
1
literal. |
static SelectSelectStep<Record1<Integer>> |
DSL.selectZero()
Create a new DSL subselect statement for a constant
0
literal. |
static <T extends Number> |
DSL.shl(Field<T> field1,
Field<T> field2)
The bitwise left shift operator.
|
static <T extends Number> |
DSL.shl(Field<T> value1,
T value2)
The bitwise left shift operator.
|
static <T extends Number> |
DSL.shl(T value1,
Field<T> value2)
The bitwise left shift operator.
|
static <T extends Number> |
DSL.shl(T value1,
T value2)
The bitwise left shift operator.
|
static <T extends Number> |
DSL.shr(Field<T> field1,
Field<T> field2)
The bitwise right shift operator.
|
static <T extends Number> |
DSL.shr(Field<T> value1,
T value2)
The bitwise right shift operator.
|
static <T extends Number> |
DSL.shr(T value1,
Field<T> value2)
The bitwise right shift operator.
|
static <T extends Number> |
DSL.shr(T value1,
T value2)
The bitwise right shift operator.
|
static Field<Integer> |
DSL.sign(Field<? extends Number> field)
Get the sign of a numeric field: sign(field).
|
static Field<Integer> |
DSL.sign(Number value)
Get the sign of a numeric field: sign(field).
|
static Field<BigDecimal> |
DSL.sin(Field<? extends Number> field)
Get the sine(field) function.
|
static Field<BigDecimal> |
DSL.sin(Number value)
Get the sine(field) function.
|
static Field<BigDecimal> |
DSL.sinh(Field<? extends Number> field)
Get the hyperbolic sine function: sinh(field).
|
static Field<BigDecimal> |
DSL.sinh(Number value)
Get the hyperbolic sine function: sinh(field).
|
static Field<BigDecimal> |
DSL.sqrt(Field<? extends Number> field)
Get the sqrt(field) function.
|
static Field<BigDecimal> |
DSL.sqrt(Number value)
Get the sqrt(field) function.
|
static AggregateFunction<BigDecimal> |
DSL.stddevPop(Field<? extends Number> field)
Get the population standard deviation of a numeric field: stddev_pop(field).
|
static AggregateFunction<BigDecimal> |
DSL.stddevSamp(Field<? extends Number> field)
Get the sample standard deviation of a numeric field: stddev_samp(field).
|
static AggregateFunction<BigDecimal> |
DSL.sum(Field<? extends Number> field)
Get the sum over a numeric field: sum(field).
|
static AggregateFunction<BigDecimal> |
DSL.sumDistinct(Field<? extends Number> field)
Get the sum over a numeric field: sum(distinct field).
|
static Field<String> |
DSL.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<?> |
DSL.table(ArrayRecord<?> array)
A synonym for
DSL.unnest(ArrayRecord). |
static Table<?> |
DSL.table(Field<?> cursor)
A synonym for
DSL.unnest(Field). |
static Table<?> |
DSL.table(List<?> list)
A synonym for
DSL.unnest(List). |
static Table<?> |
DSL.table(Object[] array)
A synonym for
DSL.unnest(Object[]). |
static <R extends Record> |
DSL.table(Result<R> result)
Use a previously obtained result as a new
Table that can be used
in SQL statements through DSL.values(RowN...). |
static <R extends Record> |
DSL.table(Select<R> select)
A synonym for
TableLike.asTable(), which might look a bit more fluent
like this, to some users. |
static Field<BigDecimal> |
DSL.tan(Field<? extends Number> field)
Get the tangent(field) function.
|
static Field<BigDecimal> |
DSL.tan(Number value)
Get the tangent(field) function.
|
static Field<BigDecimal> |
DSL.tanh(Field<? extends Number> field)
Get the hyperbolic tangent function: tanh(field).
|
static Field<BigDecimal> |
DSL.tanh(Number value)
Get the hyperbolic tangent function: tanh(field).
|
static Field<Timestamp> |
DSL.timestampAdd(Field<Timestamp> timestamp,
Field<? extends Number> interval)
Add an interval to a timestamp.
|
static Field<Timestamp> |
DSL.timestampAdd(Timestamp timestamp,
Number interval)
Add an interval to a timestamp.
|
static Field<DayToSecond> |
DSL.timestampDiff(Field<Timestamp> timestamp1,
Field<Timestamp> timestamp2)
Get the timestamp difference as a
INTERVAL DAY TO SECOND
type. |
static Field<DayToSecond> |
DSL.timestampDiff(Field<Timestamp> timestamp1,
Timestamp timestamp2)
Get the timestamp difference as a
INTERVAL DAY TO SECOND
type. |
static Field<DayToSecond> |
DSL.timestampDiff(Timestamp timestamp1,
Field<Timestamp> timestamp2)
Get the timestamp difference as a
INTERVAL DAY TO SECOND
type. |
static Field<DayToSecond> |
DSL.timestampDiff(Timestamp timestamp1,
Timestamp timestamp2)
Get the timestamp difference as a
INTERVAL DAY TO SECOND
type. |
static Field<String> |
DSL.trim(Field<String> field)
Get the trim(field) function.
|
static Field<String> |
DSL.trim(String value)
Get the trim(field) function.
|
static Condition |
DSL.trueCondition()
Return a
Condition that will always evaluate to true. |
static <T extends Number> |
DSL.trunc(Field<T> number,
Field<Integer> decimals)
Truncate a number to a given number of decimals.
|
static <T extends Number> |
DSL.trunc(Field<T> number,
int decimals)
Truncate a number to a given number of decimals.
|
static <T extends Number> |
DSL.trunc(T number)
Truncate a number to a given number of decimals.
|
static <T extends Number> |
DSL.trunc(T number,
Field<Integer> decimals)
Truncate a number to a given number of decimals.
|
static <T extends Number> |
DSL.trunc(T number,
int decimals)
Truncate a number to a given number of decimals.
|
static <R extends Record> |
DSL.truncate(Table<R> table)
Create a new DSL truncate statement.
|
static Field<Integer> |
DSL.two()
A
2 literal. |
static Table<?> |
DSL.unnest(ArrayRecord<?> array)
Create a table from an array of values.
|
static Table<?> |
DSL.unnest(Field<?> cursor)
Create a table from a field.
|
static Table<?> |
DSL.unnest(List<?> list)
Create a table from a list of values.
|
static Table<?> |
DSL.unnest(Object[] array)
Create a table from an array of values.
|
static <R extends Record> |
DSL.update(Table<R> table)
Create a new DSL update statement.
|
static Field<String> |
DSL.upper(Field<String> field)
Get the upper(field) function.
|
static Field<String> |
DSL.upper(String value)
Get the upper(field) function.
|
static DSLContext |
DSL.using(Configuration configuration)
Create an executor from a custom configuration.
|
static DSLContext |
DSL.using(Connection connection)
Create an executor with a connection configured.
|
static DSLContext |
DSL.using(ConnectionProvider connectionProvider,
SQLDialect dialect)
Create an executor with a custom connection provider and a dialect
configured.
|
static DSLContext |
DSL.using(ConnectionProvider connectionProvider,
SQLDialect dialect,
Settings settings)
Create an executor with a custom connection provider, a dialect and settings
configured.
|
static DSLContext |
DSL.using(Connection connection,
Settings settings)
Create an executor with a connection, a dialect and settings configured.
|
static DSLContext |
DSL.using(Connection connection,
SQLDialect dialect)
Create an executor with a connection and a dialect configured.
|
static DSLContext |
DSL.using(Connection connection,
SQLDialect dialect,
Settings settings)
Create an executor with a connection, a dialect and settings configured.
|
static DSLContext |
DSL.using(DataSource datasource,
SQLDialect dialect)
Create an executor with a data source and a dialect configured.
|
static DSLContext |
DSL.using(DataSource datasource,
SQLDialect dialect,
Settings settings)
Create an executor with a data source, a dialect and settings configured.
|
static DSLContext |
DSL.using(SQLDialect dialect)
Create an executor with a dialect configured.
|
static DSLContext |
DSL.using(SQLDialect dialect,
Settings settings)
Create an executor with a dialect and settings configured.
|
static <T1> Table<Record1<T1>> |
DSL.values(Row1<T1>... rows)
Create a
VALUES() expression of degree 1. |
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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>> |
DSL.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> |
DSL.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> |
DSL.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> |
DSL.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>> |
DSL.values(Row3<T1,T2,T3>... rows)
Create a
VALUES() expression of degree 3. |
static <T1,T2,T3,T4> |
DSL.values(Row4<T1,T2,T3,T4>... rows)
Create a
VALUES() expression of degree 4. |
static <T1,T2,T3,T4,T5> |
DSL.values(Row5<T1,T2,T3,T4,T5>... rows)
Create a
VALUES() expression of degree 5. |
static <T1,T2,T3,T4,T5,T6> |
DSL.values(Row6<T1,T2,T3,T4,T5,T6>... rows)
Create a
VALUES() expression of degree 6. |
static <T1,T2,T3,T4,T5,T6,T7> |
DSL.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> |
DSL.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> |
DSL.values(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>... rows)
Create a
VALUES() expression of degree 9. |
static Table<Record> |
DSL.values(RowN... rows)
Create a
VALUES() expression of arbitrary degree. |
static AggregateFunction<BigDecimal> |
DSL.varPop(Field<? extends Number> field)
Get the population variance of a numeric field: var_pop(field).
|
static AggregateFunction<BigDecimal> |
DSL.varSamp(Field<? extends Number> field)
Get the sample variance of a numeric field: var_samp(field).
|
static Field<Integer> |
DSL.year(Date value)
Get the year part of a date.
|
static Field<Integer> |
DSL.year(Field<? extends Date> field)
Get the year part of a date.
|
static Field<Integer> |
DSL.zero()
A
0 literal. |
Copyright © 2014. All Rights Reserved.