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 | Interface and Description |
---|---|
interface |
SQL
A plain SQL
QueryPart . |
Modifier and Type | Method and Description |
---|---|
UpdateConditionStep<R> |
UpdateConditionStep.and(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnConditionStep<R> |
TableOnConditionStep.and(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.and(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectHavingConditionStep<R> |
SelectHavingConditionStep.and(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectConnectByConditionStep<R> |
SelectConnectByConditionStep.and(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectConditionStep<R> |
SelectConditionStep.and(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.and(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.and(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
DeleteConditionStep<R> |
DeleteConditionStep.and(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
Condition |
Condition.and(SQL sql)
Combine this condition with another one using the
Operator.AND
operator. |
UpdateConditionStep<R> |
UpdateConditionStep.and(String sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnConditionStep<R> |
TableOnConditionStep.and(String sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.and(String sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectHavingConditionStep<R> |
SelectHavingConditionStep.and(String sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectConnectByConditionStep<R> |
SelectConnectByConditionStep.and(String sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectConditionStep<R> |
SelectConditionStep.and(String sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.and(String sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.and(String sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
DeleteConditionStep<R> |
DeleteConditionStep.and(String sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
Condition |
Condition.and(String sql)
Combine this condition with another one using the
Operator.AND
operator. |
UpdateConditionStep<R> |
UpdateConditionStep.and(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.AND operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnConditionStep<R> |
TableOnConditionStep.and(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.and(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectHavingConditionStep<R> |
SelectHavingConditionStep.and(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectConnectByConditionStep<R> |
SelectConnectByConditionStep.and(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectConditionStep<R> |
SelectConditionStep.and(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.and(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.and(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
DeleteConditionStep<R> |
DeleteConditionStep.and(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.AND operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
Condition |
Condition.and(String sql,
Object... bindings)
Combine this condition with another one using the
Operator.AND
operator. |
UpdateConditionStep<R> |
UpdateConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnConditionStep<R> |
TableOnConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectHavingConditionStep<R> |
SelectHavingConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectConnectByConditionStep<R> |
SelectConnectByConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectConditionStep<R> |
SelectConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
DeleteConditionStep<R> |
DeleteConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
Condition |
Condition.and(String sql,
QueryPart... parts)
Combine this condition with another one using the
Operator.AND
operator. |
SelectConnectByConditionStep<R> |
SelectConnectByStep.connectBy(SQL sql)
Add an Oracle-specific
CONNECT BY clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
SelectConnectByConditionStep<R> |
SelectConnectByStep.connectBy(String sql)
Add an Oracle-specific
CONNECT BY clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
SelectConnectByConditionStep<R> |
SelectConnectByStep.connectBy(String sql,
Object... bindings)
Add an Oracle-specific
CONNECT BY clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
SelectConnectByConditionStep<R> |
SelectConnectByStep.connectBy(String sql,
QueryPart... parts)
Add an Oracle-specific
CONNECT BY clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
SelectConnectByConditionStep<R> |
SelectConnectByStep.connectByNoCycle(SQL sql)
Add an Oracle-specific
CONNECT BY NOCYCLE clause to the
query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
SelectConnectByConditionStep<R> |
SelectConnectByStep.connectByNoCycle(String sql)
Add an Oracle-specific
CONNECT BY NOCYCLE clause to the
query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
SelectConnectByConditionStep<R> |
SelectConnectByStep.connectByNoCycle(String sql,
Object... bindings)
Add an Oracle-specific
CONNECT BY NOCYCLE clause to the
query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
SelectConnectByConditionStep<R> |
SelectConnectByStep.connectByNoCycle(String sql,
QueryPart... parts)
Add an Oracle-specific
CONNECT BY NOCYCLE clause to the
query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
Table<Record> |
Table.crossApply(SQL sql)
CROSS APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossApply(SQL sql)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossApply(String sql)
CROSS APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.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. |
SelectJoinStep<R> |
SelectJoinStep.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. |
SelectJoinStep<R> |
SelectJoinStep.crossApply(String sql,
QueryPart... parts)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossJoin(SQL sql)
CROSS JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(SQL sql)
Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(String)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN . |
Table<Record> |
Table.crossJoin(String sql)
CROSS JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(String sql)
Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(String)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN . |
Table<Record> |
Table.crossJoin(String sql,
Object... bindings)
CROSS JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(String sql,
Object... bindings)
Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(String, Object...) |
Table<Record> |
Table.crossJoin(String sql,
QueryPart... parts)
CROSS JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(String sql,
QueryPart... parts)
Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(String, QueryPart...) |
int |
DSLContext.execute(SQL sql)
Execute a query holding plain SQL.
|
int |
DSLContext.execute(String sql)
Execute a query holding plain SQL.
|
int |
DSLContext.execute(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
int |
DSLContext.execute(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
Result<Record> |
DSLContext.fetch(SQL sql)
Execute a new query holding plain SQL.
|
Result<Record> |
DSLContext.fetch(String sql)
Execute a new query holding plain SQL.
|
Result<Record> |
DSLContext.fetch(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Result<Record> |
DSLContext.fetch(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(Executor executor,
SQL sql)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(Executor executor,
String sql)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(Executor executor,
String sql,
Object... bindings)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(Executor executor,
String sql,
QueryPart... parts)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(SQL sql)
Fetch results in a new
CompletionStage . |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(String sql)
Fetch results in a new
CompletionStage . |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(String sql,
Object... bindings)
Fetch results in a new
CompletionStage . |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(String sql,
QueryPart... parts)
Fetch results in a new
CompletionStage . |
Cursor<Record> |
DSLContext.fetchLazy(SQL sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
DSLContext.fetchLazy(String sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
DSLContext.fetchLazy(String sql,
Object... bindings)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
DSLContext.fetchLazy(String sql,
QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Results |
DSLContext.fetchMany(SQL sql)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Results |
DSLContext.fetchMany(String sql)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Results |
DSLContext.fetchMany(String sql,
Object... bindings)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Results |
DSLContext.fetchMany(String sql,
QueryPart... parts)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Record |
DSLContext.fetchOne(SQL sql)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchOne(String sql)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchOne(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchOne(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
Optional<Record> |
DSLContext.fetchOptional(SQL sql)
Execute a new query holding plain SQL.
|
Optional<Record> |
DSLContext.fetchOptional(String sql)
Execute a new query holding plain SQL.
|
Optional<Record> |
DSLContext.fetchOptional(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Optional<Record> |
DSLContext.fetchOptional(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
Optional<?> |
DSLContext.fetchOptionalValue(SQL sql)
Execute a new query holding plain SQL.
|
Optional<?> |
DSLContext.fetchOptionalValue(String sql)
Execute a new query holding plain SQL.
|
Optional<?> |
DSLContext.fetchOptionalValue(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Optional<?> |
DSLContext.fetchOptionalValue(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
java.util.stream.Stream<Record> |
DSLContext.fetchStream(SQL sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
java.util.stream.Stream<Record> |
DSLContext.fetchStream(String sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
java.util.stream.Stream<Record> |
DSLContext.fetchStream(String sql,
Object... bindings)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
java.util.stream.Stream<Record> |
DSLContext.fetchStream(String sql,
QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Object |
DSLContext.fetchValue(SQL sql)
Execute a new query holding plain SQL.
|
Object |
DSLContext.fetchValue(String sql)
Execute a new query holding plain SQL.
|
Object |
DSLContext.fetchValue(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Object |
DSLContext.fetchValue(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
List<?> |
DSLContext.fetchValues(SQL sql)
Execute a new query holding plain SQL.
|
List<?> |
DSLContext.fetchValues(String sql)
Execute a new query holding plain SQL.
|
List<?> |
DSLContext.fetchValues(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
List<?> |
DSLContext.fetchValues(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
WindowBeforeOverStep<T> |
AggregateFilterStep.filterWhere(SQL sql)
Add a
FILTER clause to the aggregate function. |
WindowBeforeOverStep<T> |
AggregateFilterStep.filterWhere(String sql)
Add a
FILTER clause to the aggregate function. |
WindowBeforeOverStep<T> |
AggregateFilterStep.filterWhere(String sql,
Object... bindings)
Add a
FILTER clause to the aggregate function. |
WindowBeforeOverStep<T> |
AggregateFilterStep.filterWhere(String sql,
QueryPart... parts)
Add a
FILTER clause to the aggregate function. |
UpdateWhereStep<R> |
UpdateFromStep.from(SQL sql)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(SQL sql)
Add a
FROM clause to the query. |
UpdateWhereStep<R> |
UpdateFromStep.from(String sql)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(String sql)
Add a
FROM clause to the query. |
UpdateWhereStep<R> |
UpdateFromStep.from(String sql,
Object... bindings)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(String sql,
Object... bindings)
Add a
FROM clause to the query. |
UpdateWhereStep<R> |
UpdateFromStep.from(String sql,
QueryPart... parts)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(String sql,
QueryPart... parts)
Add a
FROM clause to the query. |
TableOnStep<Record> |
Table.fullOuterJoin(SQL sql)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(SQL sql)
Convenience method to
FULL OUTER JOIN a table to the last
table added to the FROM clause using
Table.fullOuterJoin(String)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnStep<Record> |
Table.fullOuterJoin(String sql)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(String sql)
Convenience method to
FULL OUTER JOIN a table to the last
table added to the FROM clause using
Table.fullOuterJoin(String)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnStep<Record> |
Table.fullOuterJoin(String sql,
Object... bindings)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(String sql,
Object... bindings)
Convenience method to
FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table.fullOuterJoin(String, Object...) |
TableOnStep<Record> |
Table.fullOuterJoin(String sql,
QueryPart... parts)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(String sql,
QueryPart... parts)
Convenience method to
FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table.fullOuterJoin(String, QueryPart...) |
SelectHavingConditionStep<R> |
SelectHavingStep.having(SQL sql)
Add a
HAVING clause to the query. |
SelectHavingConditionStep<R> |
SelectHavingStep.having(String sql)
Add a
HAVING clause to the query. |
SelectHavingConditionStep<R> |
SelectHavingStep.having(String sql,
Object... bindings)
Add a
HAVING clause to the query. |
SelectHavingConditionStep<R> |
SelectHavingStep.having(String sql,
QueryPart... parts)
Add a
HAVING clause to the query. |
TableOnStep<Record> |
Table.innerJoin(SQL sql)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.innerJoin(SQL sql)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using Table.join(String) . |
TableOnStep<Record> |
Table.innerJoin(String sql)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.innerJoin(String sql)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using Table.join(String) . |
TableOnStep<Record> |
Table.innerJoin(String sql,
Object... bindings)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.innerJoin(String sql,
Object... bindings)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using
Table.join(String, Object...) . |
TableOnStep<Record> |
Table.innerJoin(String sql,
QueryPart... parts)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.innerJoin(String sql,
QueryPart... parts)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using
Table.join(String, QueryPart...) . |
TableOnStep<Record> |
Table.join(Name name)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.join(Name name)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using
Table.join(Name) . |
TableOnStep<Record> |
Table.join(SQL sql)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.join(SQL sql)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using Table.join(String) . |
TableOnStep<Record> |
Table.join(String sql)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.join(String sql)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using Table.join(String) . |
TableOnStep<Record> |
Table.join(String sql,
Object... bindings)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.join(String sql,
Object... bindings)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using
Table.join(String, Object...) . |
TableOnStep<Record> |
Table.join(String sql,
QueryPart... parts)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.join(String sql,
QueryPart... parts)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using
Table.join(String, QueryPart...) . |
TablePartitionByStep<Record> |
Table.leftJoin(SQL sql)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(SQL sql)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(String) . |
TablePartitionByStep<Record> |
Table.leftJoin(String sql)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(String sql)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(String) . |
TablePartitionByStep<Record> |
Table.leftJoin(String sql,
Object... bindings)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(String sql,
Object... bindings)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(String, Object...) . |
TablePartitionByStep<Record> |
Table.leftJoin(String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(String sql,
QueryPart... parts)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(String, QueryPart...) . |
TablePartitionByStep<Record> |
Table.leftOuterJoin(SQL sql)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(SQL sql)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(String)
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TablePartitionByStep<Record> |
Table.leftOuterJoin(String sql)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(String sql)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(String)
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TablePartitionByStep<Record> |
Table.leftOuterJoin(String sql,
Object... bindings)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(String sql,
Object... bindings)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(String, Object...) |
TablePartitionByStep<Record> |
Table.leftOuterJoin(String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(String sql,
QueryPart... parts)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(String, QueryPart...) |
Table<Record> |
Table.naturalJoin(SQL sql)
NATURAL JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(SQL sql)
Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(String)
Natural joins are supported by most RDBMS. |
Table<Record> |
Table.naturalJoin(String sql)
NATURAL JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(String sql)
Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(String)
Natural joins are supported by most RDBMS. |
Table<Record> |
Table.naturalJoin(String sql,
Object... bindings)
NATURAL JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(String sql,
Object... bindings)
Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(String, Object...) |
Table<Record> |
Table.naturalJoin(String sql,
QueryPart... parts)
NATURAL JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(String sql,
QueryPart... parts)
Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(String, QueryPart...) |
Table<Record> |
Table.naturalLeftOuterJoin(Name name)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(SQL sql)
NATURAL LEFT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(SQL sql)
Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(String)
Natural joins are supported by most RDBMS. |
Table<Record> |
Table.naturalLeftOuterJoin(String sql)
NATURAL LEFT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(String sql)
Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(String)
Natural joins are supported by most RDBMS. |
Table<Record> |
Table.naturalLeftOuterJoin(String sql,
Object... bindings)
NATURAL LEFT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(String sql,
Object... bindings)
Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(String, Object...) |
Table<Record> |
Table.naturalLeftOuterJoin(String sql,
QueryPart... parts)
NATURAL LEFT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(String sql,
QueryPart... parts)
Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(String, QueryPart...) |
Table<Record> |
Table.naturalRightOuterJoin(SQL sql)
NATURAL RIGHT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(SQL sql)
Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(String)
Natural joins are supported by most RDBMS. |
Table<Record> |
Table.naturalRightOuterJoin(String sql)
NATURAL RIGHT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(String sql)
Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(String)
Natural joins are supported by most RDBMS. |
Table<Record> |
Table.naturalRightOuterJoin(String sql,
Object... bindings)
NATURAL RIGHT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(String sql,
Object... bindings)
Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(String, Object...) |
Table<Record> |
Table.naturalRightOuterJoin(String sql,
QueryPart... parts)
NATURAL RIGHT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(String sql,
QueryPart... parts)
Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(String, QueryPart...) |
TableOnConditionStep<R> |
TableOnStep.on(SQL sql)
Add an
ON clause to the JOIN . |
SelectOnConditionStep<R> |
SelectOnStep.on(SQL sql)
Add an
ON clause to the previous JOIN . |
MergeOnConditionStep<R> |
MergeOnStep.on(SQL sql)
Provide join conditions and proceed to the next step
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
DivideByOnConditionStep |
DivideByOnStep.on(SQL sql)
Add a division condition to the
DIVIDE BY clause
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnConditionStep<R> |
TableOnStep.on(String sql)
Add an
ON clause to the JOIN . |
SelectOnConditionStep<R> |
SelectOnStep.on(String sql)
Add an
ON clause to the previous JOIN . |
MergeOnConditionStep<R> |
MergeOnStep.on(String sql)
Provide join conditions and proceed to the next step
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
DivideByOnConditionStep |
DivideByOnStep.on(String sql)
Add a division condition to the
DIVIDE BY clause
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnConditionStep<R> |
TableOnStep.on(String sql,
Object... bindings)
Add an
ON clause to the JOIN . |
SelectOnConditionStep<R> |
SelectOnStep.on(String sql,
Object... bindings)
Add an
ON clause to the previous JOIN . |
MergeOnConditionStep<R> |
MergeOnStep.on(String sql,
Object... bindings)
Provide join conditions and proceed to the next step
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
DivideByOnConditionStep |
DivideByOnStep.on(String sql,
Object... bindings)
Add a division condition to the
DIVIDE BY clause
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnConditionStep<R> |
TableOnStep.on(String sql,
QueryPart... parts)
Add an
ON clause to the JOIN . |
SelectOnConditionStep<R> |
SelectOnStep.on(String sql,
QueryPart... parts)
Add an
ON clause to the previous JOIN . |
MergeOnConditionStep<R> |
MergeOnStep.on(String sql,
QueryPart... parts)
Provide join conditions and proceed to the next step
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
DivideByOnConditionStep |
DivideByOnStep.on(String sql,
QueryPart... parts)
Add a division condition to the
DIVIDE BY clause
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
UpdateConditionStep<R> |
UpdateConditionStep.or(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnConditionStep<R> |
TableOnConditionStep.or(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.or(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
SelectHavingConditionStep<R> |
SelectHavingConditionStep.or(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
SelectConditionStep<R> |
SelectConditionStep.or(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.or(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.or(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
DeleteConditionStep<R> |
DeleteConditionStep.or(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
Condition |
Condition.or(SQL sql)
Combine this condition with another one using the
Operator.OR
operator. |
UpdateConditionStep<R> |
UpdateConditionStep.or(String sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnConditionStep<R> |
TableOnConditionStep.or(String sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.or(String sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
SelectHavingConditionStep<R> |
SelectHavingConditionStep.or(String sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
SelectConditionStep<R> |
SelectConditionStep.or(String sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.or(String sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.or(String sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
DeleteConditionStep<R> |
DeleteConditionStep.or(String sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
Condition |
Condition.or(String sql)
Combine this condition with another one using the
Operator.OR
operator. |
UpdateConditionStep<R> |
UpdateConditionStep.or(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnConditionStep<R> |
TableOnConditionStep.or(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.or(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
SelectHavingConditionStep<R> |
SelectHavingConditionStep.or(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
SelectConditionStep<R> |
SelectConditionStep.or(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.or(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.or(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
DeleteConditionStep<R> |
DeleteConditionStep.or(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
Condition |
Condition.or(String sql,
Object... bindings)
Combine this condition with another one using the
Operator.OR
operator. |
UpdateConditionStep<R> |
UpdateConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnConditionStep<R> |
TableOnConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
SelectHavingConditionStep<R> |
SelectHavingConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
SelectConditionStep<R> |
SelectConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
DeleteConditionStep<R> |
DeleteConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
Condition |
Condition.or(String sql,
QueryPart... parts)
Combine this condition with another one using the
Operator.OR
operator. |
Table<Record> |
Table.outerApply(SQL sql)
OUTER APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.outerApply(SQL sql)
OUTER APPLY a table to this table. |
Table<Record> |
Table.outerApply(String sql)
OUTER APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.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. |
SelectJoinStep<R> |
SelectJoinStep.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. |
SelectJoinStep<R> |
SelectJoinStep.outerApply(String sql,
QueryPart... parts)
OUTER APPLY a table to this table. |
Query |
DSLContext.query(SQL sql)
Create a new query holding plain SQL.
|
Query |
DSLContext.query(String sql)
Create a new query holding plain SQL.
|
Query |
DSLContext.query(String sql,
Object... bindings)
Create a new query holding plain SQL.
|
Query |
DSLContext.query(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
DSLContext.resultQuery(SQL sql)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
DSLContext.resultQuery(String sql)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
DSLContext.resultQuery(String sql,
Object... bindings)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
DSLContext.resultQuery(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
TablePartitionByStep<Record> |
Table.rightJoin(SQL sql)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightJoin(SQL sql)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(String) . |
TablePartitionByStep<Record> |
Table.rightJoin(String sql)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightJoin(String sql)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(String) . |
TablePartitionByStep<Record> |
Table.rightJoin(String sql,
Object... bindings)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightJoin(String sql,
Object... bindings)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(String, Object...) . |
TablePartitionByStep<Record> |
Table.rightJoin(String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightJoin(String sql,
QueryPart... parts)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(String, QueryPart...) . |
TablePartitionByStep<Record> |
Table.rightOuterJoin(SQL sql)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(SQL sql)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(String)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TablePartitionByStep<Record> |
Table.rightOuterJoin(String sql)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(String sql)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(String)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TablePartitionByStep<Record> |
Table.rightOuterJoin(String sql,
Object... bindings)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(String sql,
Object... bindings)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(String, Object...) |
TablePartitionByStep<Record> |
Table.rightOuterJoin(String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(String sql,
QueryPart... parts)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(String, QueryPart...) |
SelectGroupByStep<R> |
SelectStartWithStep.startWith(SQL sql)
Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause. |
SelectGroupByStep<R> |
SelectStartWithStep.startWith(String sql)
Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause. |
SelectGroupByStep<R> |
SelectStartWithStep.startWith(String sql,
Object... bindings)
Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause. |
SelectGroupByStep<R> |
SelectStartWithStep.startWith(String sql,
QueryPart... parts)
Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause. |
TableOnStep<Record> |
Table.straightJoin(Name name)
STRAIGHT_JOIN a table to this table. |
TableOnStep<Record> |
Table.straightJoin(SQL sql)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(SQL sql)
STRAIGHT_JOIN a table to this table. |
TableOnStep<Record> |
Table.straightJoin(String sql)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(String sql)
STRAIGHT_JOIN a table to this table. |
TableOnStep<Record> |
Table.straightJoin(String sql,
Object... bindings)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(String sql,
Object... bindings)
STRAIGHT_JOIN a table to this table. |
TableOnStep<Record> |
Table.straightJoin(String sql,
QueryPart... parts)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(String sql,
QueryPart... parts)
STRAIGHT_JOIN a table to this table. |
UpdateConditionStep<R> |
UpdateWhereStep.where(SQL sql)
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
SelectConditionStep<R> |
SelectWhereStep.where(SQL sql)
Add a
WHERE clause to the query. |
DeleteConditionStep<R> |
DeleteWhereStep.where(SQL sql)
Add conditions to the query.
|
UpdateConditionStep<R> |
UpdateWhereStep.where(String sql)
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
SelectConditionStep<R> |
SelectWhereStep.where(String sql)
Add a
WHERE clause to the query. |
DeleteConditionStep<R> |
DeleteWhereStep.where(String sql)
Add conditions to the query.
|
UpdateConditionStep<R> |
UpdateWhereStep.where(String sql,
Object... bindings)
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
SelectConditionStep<R> |
SelectWhereStep.where(String sql,
Object... bindings)
Add a
WHERE clause to the query. |
DeleteConditionStep<R> |
DeleteWhereStep.where(String sql,
Object... bindings)
Add conditions to the query.
|
UpdateConditionStep<R> |
UpdateWhereStep.where(String sql,
QueryPart... parts)
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
SelectConditionStep<R> |
SelectWhereStep.where(String sql,
QueryPart... parts)
Add a
WHERE clause to the query. |
DeleteConditionStep<R> |
DeleteWhereStep.where(String sql,
QueryPart... parts)
Add conditions to the query.
|
Modifier and Type | Method and Description |
---|---|
static Condition |
DSL.condition(SQL sql)
Create a new condition holding plain SQL.
|
static Condition |
DSL.condition(String sql)
Create a new condition holding plain SQL.
|
static Condition |
DSL.condition(String sql,
Object... bindings)
Create a new condition holding plain SQL.
|
static Condition |
DSL.condition(String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary SQL elements.
|
static Field<Object> |
DSL.field(SQL sql)
Create a "plain SQL" field.
|
static <T> Field<T> |
DSL.field(SQL sql,
Class<T> type)
Create a "plain SQL" field.
|
static <T> Field<T> |
DSL.field(SQL sql,
DataType<T> type)
Create a "plain SQL" field.
|
static Field<Object> |
DSL.field(String sql)
Create a "plain SQL" field.
|
static <T> Field<T> |
DSL.field(String sql,
Class<T> type)
Create a "plain SQL" field.
|
static <T> Field<T> |
DSL.field(String sql,
Class<T> type,
Object... bindings)
Create a "plain SQL" field.
|
static <T> Field<T> |
DSL.field(String sql,
Class<T> type,
QueryPart... parts)
A custom SQL clause that can render arbitrary SQL elements.
|
static <T> Field<T> |
DSL.field(String sql,
DataType<T> type)
Create a "plain SQL" field.
|
static <T> Field<T> |
DSL.field(String sql,
DataType<T> type,
Object... bindings)
Create a "plain SQL" field.
|
static <T> Field<T> |
DSL.field(String sql,
DataType<T> type,
QueryPart... parts)
Create a "plain SQL" field.
|
static Field<Object> |
DSL.field(String sql,
Object... bindings)
Create a "plain SQL" field.
|
static Field<Object> |
DSL.field(String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary SQL elements.
|
static <T> Field<T> |
DSL.function(String name,
Class<T> type,
Field<?>... arguments)
function() can be used to access native or user-defined
functions that are not yet or insufficiently supported by jOOQ. |
static <T> Field<T> |
DSL.function(String name,
DataType<T> type,
Field<?>... arguments)
function() can be used to access native or user-defined
functions that are not yet or insufficiently supported by jOOQ. |
static Query |
DSL.query(SQL sql)
Create a new query holding plain SQL.
|
static Query |
DSL.query(String sql)
Create a new query holding plain SQL.
|
static Query |
DSL.query(String sql,
Object... bindings)
Create a new query holding plain SQL.
|
static Query |
DSL.query(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
static QueryPart |
DSL.queryPart(String sql)
Deprecated.
- 3.6.0 - [#3854] - Use
DSL.sql(String) instead |
static QueryPart |
DSL.queryPart(String sql,
Object... bindings)
Deprecated.
- 3.6.0 - [#3854] - Use
DSL.sql(String, Object...) instead |
static QueryPart |
DSL.queryPart(String sql,
QueryPart... parts)
Deprecated.
- 3.6.0 - [#3854] - Use
DSL.sql(String, QueryPart...) instead |
static ResultQuery<Record> |
DSL.resultQuery(SQL sql)
Create a new query holding plain SQL.
|
static ResultQuery<Record> |
DSL.resultQuery(String sql)
Create a new query holding plain SQL.
|
static ResultQuery<Record> |
DSL.resultQuery(String sql,
Object... bindings)
Create a new query holding plain SQL.
|
static ResultQuery<Record> |
DSL.resultQuery(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
static Sequence<BigInteger> |
DSL.sequence(String sql)
Create a "plain SQL" sequence.
|
static <T extends Number> |
DSL.sequence(String sql,
Class<T> type)
Create a "plain SQL" sequence.
|
static <T extends Number> |
DSL.sequence(String sql,
DataType<T> type)
Create a "plain SQL" sequence.
|
static SQL |
DSL.sql(String sql)
A custom SQL clause that can render arbitrary expressions.
|
static SQL |
DSL.sql(String sql,
Object... bindings)
A custom SQL clause that can render arbitrary expressions.
|
static SQL |
DSL.sql(String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary expressions.
|
static Table<Record> |
DSL.table(SQL sql)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
DSL.table(String sql)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
DSL.table(String sql,
Object... bindings)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
DSL.table(String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary table expressions.
|
Copyright © 2017. All Rights Reserved.