| 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. |
SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithConditionStep.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. |
InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.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(java.lang.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(java.lang.String sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.and(java.lang.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(java.lang.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(java.lang.String sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithConditionStep.and(java.lang.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(java.lang.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(java.lang.String sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.and(java.lang.String sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.and(java.lang.String sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
DeleteConditionStep<R> |
DeleteConditionStep.and(java.lang.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(java.lang.String sql)
Combine this condition with another one using the
Operator.AND
operator. |
UpdateConditionStep<R> |
UpdateConditionStep.and(java.lang.String sql,
java.lang.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(java.lang.String sql,
java.lang.Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.and(java.lang.String sql,
java.lang.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(java.lang.String sql,
java.lang.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(java.lang.String sql,
java.lang.Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithConditionStep.and(java.lang.String sql,
java.lang.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(java.lang.String sql,
java.lang.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(java.lang.String sql,
java.lang.Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.and(java.lang.String sql,
java.lang.Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.and(java.lang.String sql,
java.lang.Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
DeleteConditionStep<R> |
DeleteConditionStep.and(java.lang.String sql,
java.lang.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(java.lang.String sql,
java.lang.Object... bindings)
Combine this condition with another one using the
Operator.AND
operator. |
UpdateConditionStep<R> |
UpdateConditionStep.and(java.lang.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(java.lang.String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.and(java.lang.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(java.lang.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(java.lang.String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithConditionStep.and(java.lang.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(java.lang.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(java.lang.String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.and(java.lang.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(java.lang.String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
DeleteConditionStep<R> |
DeleteConditionStep.and(java.lang.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(java.lang.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. |
SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.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(java.lang.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. |
SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.connectBy(java.lang.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(java.lang.String sql,
java.lang.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. |
SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.connectBy(java.lang.String sql,
java.lang.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(java.lang.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. |
SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.connectBy(java.lang.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. |
SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.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(java.lang.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. |
SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.connectByNoCycle(java.lang.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(java.lang.String sql,
java.lang.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. |
SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.connectByNoCycle(java.lang.String sql,
java.lang.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(java.lang.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. |
SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.connectByNoCycle(java.lang.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(java.lang.String sql)
CROSS APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossApply(java.lang.String sql)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossApply(java.lang.String sql,
java.lang.Object... bindings)
CROSS APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossApply(java.lang.String sql,
java.lang.Object... bindings)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossApply(java.lang.String sql,
QueryPart... parts)
CROSS APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossApply(java.lang.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(java.lang.String sql)
CROSS JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(java.lang.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(java.lang.String sql,
java.lang.Object... bindings)
CROSS JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(java.lang.String sql,
java.lang.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(java.lang.String sql,
QueryPart... parts)
CROSS JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(java.lang.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(java.lang.String sql)
Execute a query holding plain SQL.
|
int |
DSLContext.execute(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL.
|
int |
DSLContext.execute(java.lang.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(java.lang.String sql)
Execute a new query holding plain SQL.
|
Result<Record> |
DSLContext.fetch(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL.
|
Result<Record> |
DSLContext.fetch(java.lang.String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.util.concurrent.Executor executor,
SQL sql)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.lang.String sql)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.lang.String sql,
java.lang.Object... bindings)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.lang.String sql,
QueryPart... parts)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(SQL sql)
Fetch results in a new
CompletionStage. |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.lang.String sql)
Fetch results in a new
CompletionStage. |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.lang.String sql,
java.lang.Object... bindings)
Fetch results in a new
CompletionStage. |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.lang.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(java.lang.String sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
DSLContext.fetchLazy(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
DSLContext.fetchLazy(java.lang.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(java.lang.String sql)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Results |
DSLContext.fetchMany(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Results |
DSLContext.fetchMany(java.lang.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(java.lang.String sql)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchOne(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchOne(java.lang.String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
java.util.Optional<Record> |
DSLContext.fetchOptional(SQL sql)
Execute a new query holding plain SQL.
|
java.util.Optional<Record> |
DSLContext.fetchOptional(java.lang.String sql)
Execute a new query holding plain SQL.
|
java.util.Optional<Record> |
DSLContext.fetchOptional(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL.
|
java.util.Optional<Record> |
DSLContext.fetchOptional(java.lang.String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
java.util.Optional<?> |
DSLContext.fetchOptionalValue(SQL sql)
Execute a new query holding plain SQL.
|
java.util.Optional<?> |
DSLContext.fetchOptionalValue(java.lang.String sql)
Execute a new query holding plain SQL.
|
java.util.Optional<?> |
DSLContext.fetchOptionalValue(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL.
|
java.util.Optional<?> |
DSLContext.fetchOptionalValue(java.lang.String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchSingle(SQL sql)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchSingle(java.lang.String sql)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchSingle(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchSingle(java.lang.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(java.lang.String sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
java.util.stream.Stream<Record> |
DSLContext.fetchStream(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
java.util.stream.Stream<Record> |
DSLContext.fetchStream(java.lang.String sql,
QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
java.lang.Object |
DSLContext.fetchValue(SQL sql)
Execute a new query holding plain SQL.
|
java.lang.Object |
DSLContext.fetchValue(java.lang.String sql)
Execute a new query holding plain SQL.
|
java.lang.Object |
DSLContext.fetchValue(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL.
|
java.lang.Object |
DSLContext.fetchValue(java.lang.String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
java.util.List<?> |
DSLContext.fetchValues(SQL sql)
Execute a new query holding plain SQL.
|
java.util.List<?> |
DSLContext.fetchValues(java.lang.String sql)
Execute a new query holding plain SQL.
|
java.util.List<?> |
DSLContext.fetchValues(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL.
|
java.util.List<?> |
DSLContext.fetchValues(java.lang.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(java.lang.String sql)
Add a
FILTER clause to the aggregate function. |
WindowBeforeOverStep<T> |
AggregateFilterStep.filterWhere(java.lang.String sql,
java.lang.Object... bindings)
Add a
FILTER clause to the aggregate function. |
WindowBeforeOverStep<T> |
AggregateFilterStep.filterWhere(java.lang.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(java.lang.String sql)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(java.lang.String sql)
Add a
FROM clause to the query. |
UpdateWhereStep<R> |
UpdateFromStep.from(java.lang.String sql,
java.lang.Object... bindings)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(java.lang.String sql,
java.lang.Object... bindings)
Add a
FROM clause to the query. |
UpdateWhereStep<R> |
UpdateFromStep.from(java.lang.String sql,
QueryPart... parts)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(java.lang.String sql,
QueryPart... parts)
Add a
FROM clause to the query. |
TableOnStep<Record> |
Table.fullJoin(SQL sql)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullJoin(SQL sql)
Convenience method to
FULL OUTER JOIN a table to the last
table added to the FROM clause using
Table.fullOuterJoin(String). |
TableOnStep<Record> |
Table.fullJoin(java.lang.String sql)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullJoin(java.lang.String sql)
Convenience method to
FULL OUTER JOIN a table to the last
table added to the FROM clause using
Table.fullOuterJoin(String). |
TableOnStep<Record> |
Table.fullJoin(java.lang.String sql,
java.lang.Object... bindings)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullJoin(java.lang.String sql,
java.lang.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.fullJoin(java.lang.String sql,
QueryPart... parts)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullJoin(java.lang.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...). |
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(java.lang.String sql)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(java.lang.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(java.lang.String sql,
java.lang.Object... bindings)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(java.lang.String sql,
java.lang.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(java.lang.String sql,
QueryPart... parts)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(java.lang.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(java.lang.String sql)
Add a
HAVING clause to the query. |
SelectHavingConditionStep<R> |
SelectHavingStep.having(java.lang.String sql,
java.lang.Object... bindings)
Add a
HAVING clause to the query. |
SelectHavingConditionStep<R> |
SelectHavingStep.having(java.lang.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(java.lang.String sql)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.innerJoin(java.lang.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(java.lang.String sql,
java.lang.Object... bindings)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.innerJoin(java.lang.String sql,
java.lang.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(java.lang.String sql,
QueryPart... parts)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.innerJoin(java.lang.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(java.lang.String sql)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.join(java.lang.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(java.lang.String sql,
java.lang.Object... bindings)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.join(java.lang.String sql,
java.lang.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(java.lang.String sql,
QueryPart... parts)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.join(java.lang.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> |
TableOuterJoinStep.leftJoin(SQL sql)
LEFT OUTER JOIN a table to this table. |
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). |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(java.lang.String sql)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftJoin(java.lang.String sql)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(java.lang.String sql)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(String). |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(java.lang.String sql,
java.lang.Object... bindings)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftJoin(java.lang.String sql,
java.lang.Object... bindings)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(java.lang.String sql,
java.lang.Object... bindings)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(String, Object...). |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(java.lang.String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftJoin(java.lang.String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(java.lang.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...). |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(SQL sql)
LEFT OUTER JOIN a table to this table. |
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. |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(java.lang.String sql)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftOuterJoin(java.lang.String sql)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(java.lang.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. |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(java.lang.String sql,
java.lang.Object... bindings)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftOuterJoin(java.lang.String sql,
java.lang.Object... bindings)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(java.lang.String sql,
java.lang.Object... bindings)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(String, Object...) |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(java.lang.String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftOuterJoin(java.lang.String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(java.lang.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(java.lang.String sql)
NATURAL JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(java.lang.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(java.lang.String sql,
java.lang.Object... bindings)
NATURAL JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(java.lang.String sql,
java.lang.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(java.lang.String sql,
QueryPart... parts)
NATURAL JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(java.lang.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(java.lang.String sql)
NATURAL LEFT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(java.lang.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(java.lang.String sql,
java.lang.Object... bindings)
NATURAL LEFT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(java.lang.String sql,
java.lang.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(java.lang.String sql,
QueryPart... parts)
NATURAL LEFT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(java.lang.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(java.lang.String sql)
NATURAL RIGHT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(java.lang.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(java.lang.String sql,
java.lang.Object... bindings)
NATURAL RIGHT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(java.lang.String sql,
java.lang.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(java.lang.String sql,
QueryPart... parts)
NATURAL RIGHT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(java.lang.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(java.lang.String sql)
Add an
ON clause to the JOIN. |
SelectOnConditionStep<R> |
SelectOnStep.on(java.lang.String sql)
Add an
ON clause to the previous JOIN. |
MergeOnConditionStep<R> |
MergeOnStep.on(java.lang.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(java.lang.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(java.lang.String sql,
java.lang.Object... bindings)
Add an
ON clause to the JOIN. |
SelectOnConditionStep<R> |
SelectOnStep.on(java.lang.String sql,
java.lang.Object... bindings)
Add an
ON clause to the previous JOIN. |
MergeOnConditionStep<R> |
MergeOnStep.on(java.lang.String sql,
java.lang.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(java.lang.String sql,
java.lang.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(java.lang.String sql,
QueryPart... parts)
Add an
ON clause to the JOIN. |
SelectOnConditionStep<R> |
SelectOnStep.on(java.lang.String sql,
QueryPart... parts)
Add an
ON clause to the previous JOIN. |
MergeOnConditionStep<R> |
MergeOnStep.on(java.lang.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(java.lang.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. |
InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.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(java.lang.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(java.lang.String sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.or(java.lang.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(java.lang.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(java.lang.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(java.lang.String sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.or(java.lang.String sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.or(java.lang.String sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
DeleteConditionStep<R> |
DeleteConditionStep.or(java.lang.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(java.lang.String sql)
Combine this condition with another one using the
Operator.OR
operator. |
UpdateConditionStep<R> |
UpdateConditionStep.or(java.lang.String sql,
java.lang.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(java.lang.String sql,
java.lang.Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.or(java.lang.String sql,
java.lang.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(java.lang.String sql,
java.lang.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(java.lang.String sql,
java.lang.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(java.lang.String sql,
java.lang.Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.or(java.lang.String sql,
java.lang.Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.or(java.lang.String sql,
java.lang.Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
DeleteConditionStep<R> |
DeleteConditionStep.or(java.lang.String sql,
java.lang.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(java.lang.String sql,
java.lang.Object... bindings)
Combine this condition with another one using the
Operator.OR
operator. |
UpdateConditionStep<R> |
UpdateConditionStep.or(java.lang.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(java.lang.String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.or(java.lang.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(java.lang.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(java.lang.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(java.lang.String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.or(java.lang.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(java.lang.String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
DeleteConditionStep<R> |
DeleteConditionStep.or(java.lang.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(java.lang.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(java.lang.String sql)
OUTER APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.outerApply(java.lang.String sql)
OUTER APPLY a table to this table. |
Table<Record> |
Table.outerApply(java.lang.String sql,
java.lang.Object... bindings)
OUTER APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.outerApply(java.lang.String sql,
java.lang.Object... bindings)
OUTER APPLY a table to this table. |
Table<Record> |
Table.outerApply(java.lang.String sql,
QueryPart... parts)
OUTER APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.outerApply(java.lang.String sql,
QueryPart... parts)
OUTER APPLY a table to this table. |
Queries |
Parser.parse(java.lang.String sql)
Parse a SQL string to a set of queries.
|
Queries |
Parser.parse(java.lang.String sql,
java.lang.Object... bindings)
Parse a SQL string with bind variables to a set of queries.
|
Condition |
Parser.parseCondition(java.lang.String sql)
Parse a SQL string to a condition.
|
Condition |
Parser.parseCondition(java.lang.String sql,
java.lang.Object... bindings)
Parse a SQL string with bind variables to a condition.
|
Field<?> |
Parser.parseField(java.lang.String sql)
Parse a SQL string to a field.
|
Field<?> |
Parser.parseField(java.lang.String sql,
java.lang.Object... bindings)
Parse a SQL string with bind variables to a field.
|
Name |
Parser.parseName(java.lang.String sql)
Parse a SQL string to a name.
|
Name |
Parser.parseName(java.lang.String sql,
java.lang.Object... bindings)
Parse a SQL string with bind variables to a name.
|
Query |
Parser.parseQuery(java.lang.String sql)
Parse a SQL string to a query.
|
Query |
Parser.parseQuery(java.lang.String sql,
java.lang.Object... bindings)
Parse a SQL string with bind variables to a query.
|
ResultQuery<?> |
Parser.parseResultQuery(java.lang.String sql)
Parse a SQL string to a result query.
|
ResultQuery<?> |
Parser.parseResultQuery(java.lang.String sql,
java.lang.Object... bindings)
Parse a SQL string with bind variables to a result query.
|
Row |
Parser.parseRow(java.lang.String sql)
Parse a SQL string to a row.
|
Row |
Parser.parseRow(java.lang.String sql,
java.lang.Object... bindings)
Parse a SQL string with bind variables to a row.
|
Table<?> |
Parser.parseTable(java.lang.String sql)
Parse a SQL string to a table.
|
Table<?> |
Parser.parseTable(java.lang.String sql,
java.lang.Object... bindings)
Parse a SQL string with bind variables to a table.
|
Query |
DSLContext.query(SQL sql)
Create a new query holding plain SQL.
|
Query |
DSLContext.query(java.lang.String sql)
Create a new query holding plain SQL.
|
Query |
DSLContext.query(java.lang.String sql,
java.lang.Object... bindings)
Create a new query holding plain SQL.
|
Query |
DSLContext.query(java.lang.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(java.lang.String sql)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
DSLContext.resultQuery(java.lang.String sql,
java.lang.Object... bindings)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
DSLContext.resultQuery(java.lang.String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(SQL sql)
RIGHT OUTER JOIN a table to this table. |
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). |
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(java.lang.String sql)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightJoin(java.lang.String sql)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightJoin(java.lang.String sql)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(String). |
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(java.lang.String sql,
java.lang.Object... bindings)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightJoin(java.lang.String sql,
java.lang.Object... bindings)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightJoin(java.lang.String sql,
java.lang.Object... bindings)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(String, Object...). |
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(java.lang.String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightJoin(java.lang.String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightJoin(java.lang.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...). |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(SQL sql)
RIGHT OUTER JOIN a table to this table. |
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. |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(java.lang.String sql)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightOuterJoin(java.lang.String sql)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(java.lang.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. |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(java.lang.String sql,
java.lang.Object... bindings)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightOuterJoin(java.lang.String sql,
java.lang.Object... bindings)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(java.lang.String sql,
java.lang.Object... bindings)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(String, Object...) |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(java.lang.String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightOuterJoin(java.lang.String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(java.lang.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. |
SelectConnectByAfterStartWithStep<R> |
SelectConnectByStep.startWith(SQL sql)
Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause. |
SelectGroupByStep<R> |
SelectStartWithStep.startWith(java.lang.String sql)
Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause. |
SelectConnectByAfterStartWithStep<R> |
SelectConnectByStep.startWith(java.lang.String sql)
Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause. |
SelectGroupByStep<R> |
SelectStartWithStep.startWith(java.lang.String sql,
java.lang.Object... bindings)
Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause. |
SelectConnectByAfterStartWithStep<R> |
SelectConnectByStep.startWith(java.lang.String sql,
java.lang.Object... bindings)
Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause. |
SelectGroupByStep<R> |
SelectStartWithStep.startWith(java.lang.String sql,
QueryPart... parts)
Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause. |
SelectConnectByAfterStartWithStep<R> |
SelectConnectByStep.startWith(java.lang.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(java.lang.String sql)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(java.lang.String sql)
STRAIGHT_JOIN a table to this table. |
TableOnStep<Record> |
Table.straightJoin(java.lang.String sql,
java.lang.Object... bindings)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(java.lang.String sql,
java.lang.Object... bindings)
STRAIGHT_JOIN a table to this table. |
TableOnStep<Record> |
Table.straightJoin(java.lang.String sql,
QueryPart... parts)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(java.lang.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. |
InsertReturningStep<R> |
InsertOnConflictWhereStep.where(SQL sql)
Add a
WHERE clause to the query. |
DeleteConditionStep<R> |
DeleteWhereStep.where(SQL sql)
Add conditions to the query.
|
CreateIndexFinalStep |
CreateIndexWhereStep.where(SQL sql)
Add a
WHERE clause to create a partial index. |
UpdateConditionStep<R> |
UpdateWhereStep.where(java.lang.String sql)
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
SelectConditionStep<R> |
SelectWhereStep.where(java.lang.String sql)
Add a
WHERE clause to the query. |
InsertReturningStep<R> |
InsertOnConflictWhereStep.where(java.lang.String sql)
Add a
WHERE clause to the query. |
DeleteConditionStep<R> |
DeleteWhereStep.where(java.lang.String sql)
Add conditions to the query.
|
CreateIndexFinalStep |
CreateIndexWhereStep.where(java.lang.String sql)
Add a
WHERE clause to create a partial index. |
UpdateConditionStep<R> |
UpdateWhereStep.where(java.lang.String sql,
java.lang.Object... bindings)
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
SelectConditionStep<R> |
SelectWhereStep.where(java.lang.String sql,
java.lang.Object... bindings)
Add a
WHERE clause to the query. |
InsertReturningStep<R> |
InsertOnConflictWhereStep.where(java.lang.String sql,
java.lang.Object... bindings)
Add a
WHERE clause to the query. |
DeleteConditionStep<R> |
DeleteWhereStep.where(java.lang.String sql,
java.lang.Object... bindings)
Add conditions to the query.
|
CreateIndexFinalStep |
CreateIndexWhereStep.where(java.lang.String sql,
java.lang.Object... bindings)
Add a
WHERE clause to create a partial index. |
UpdateConditionStep<R> |
UpdateWhereStep.where(java.lang.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(java.lang.String sql,
QueryPart... parts)
Add a
WHERE clause to the query. |
InsertReturningStep<R> |
InsertOnConflictWhereStep.where(java.lang.String sql,
QueryPart... parts)
Add a
WHERE clause to the query. |
DeleteConditionStep<R> |
DeleteWhereStep.where(java.lang.String sql,
QueryPart... parts)
Add conditions to the query.
|
CreateIndexFinalStep |
CreateIndexWhereStep.where(java.lang.String sql,
QueryPart... parts)
Add a
WHERE clause to create a partial index. |
| Modifier and Type | Method and Description |
|---|---|
static Condition |
DSL.condition(SQL sql)
Create a new condition holding plain SQL.
|
static Condition |
DSL.condition(java.lang.String sql)
Create a new condition holding plain SQL.
|
static Condition |
DSL.condition(java.lang.String sql,
java.lang.Object... bindings)
Create a new condition holding plain SQL.
|
static Condition |
DSL.condition(java.lang.String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary SQL elements.
|
static Field<java.lang.Object> |
DSL.field(SQL sql)
Create a "plain SQL" field.
|
static <T> Field<T> |
DSL.field(SQL sql,
java.lang.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<java.lang.Object> |
DSL.field(java.lang.String sql)
Create a "plain SQL" field.
|
static <T> Field<T> |
DSL.field(java.lang.String sql,
java.lang.Class<T> type)
Create a "plain SQL" field.
|
static <T> Field<T> |
DSL.field(java.lang.String sql,
java.lang.Class<T> type,
java.lang.Object... bindings)
Create a "plain SQL" field.
|
static <T> Field<T> |
DSL.field(java.lang.String sql,
java.lang.Class<T> type,
QueryPart... parts)
A custom SQL clause that can render arbitrary SQL elements.
|
static <T> Field<T> |
DSL.field(java.lang.String sql,
DataType<T> type)
Create a "plain SQL" field.
|
static <T> Field<T> |
DSL.field(java.lang.String sql,
DataType<T> type,
java.lang.Object... bindings)
Create a "plain SQL" field.
|
static <T> Field<T> |
DSL.field(java.lang.String sql,
DataType<T> type,
QueryPart... parts)
Create a "plain SQL" field.
|
static Field<java.lang.Object> |
DSL.field(java.lang.String sql,
java.lang.Object... bindings)
Create a "plain SQL" field.
|
static Field<java.lang.Object> |
DSL.field(java.lang.String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary SQL elements.
|
static <T> Field<T> |
DSL.function(java.lang.String name,
java.lang.Class<T> type,
Field<?>... arguments)
function() can be used to access native or user-defined
functions that are not yet or insufficiently supported by jOOQ. |
static <T> Field<T> |
DSL.function(java.lang.String name,
DataType<T> type,
Field<?>... arguments)
function() can be used to access native or user-defined
functions that are not yet or insufficiently supported by jOOQ. |
static Query |
DSL.query(SQL sql)
Create a new query holding plain SQL.
|
static Query |
DSL.query(java.lang.String sql)
Create a new query holding plain SQL.
|
static Query |
DSL.query(java.lang.String sql,
java.lang.Object... bindings)
Create a new query holding plain SQL.
|
static Query |
DSL.query(java.lang.String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
static QueryPart |
DSL.queryPart(java.lang.String sql)
Deprecated.
- 3.6.0 - [#3854] - Use
DSL.sql(String) instead |
static QueryPart |
DSL.queryPart(java.lang.String sql,
java.lang.Object... bindings)
Deprecated.
- 3.6.0 - [#3854] - Use
DSL.sql(String, Object...) instead |
static QueryPart |
DSL.queryPart(java.lang.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(java.lang.String sql)
Create a new query holding plain SQL.
|
static ResultQuery<Record> |
DSL.resultQuery(java.lang.String sql,
java.lang.Object... bindings)
Create a new query holding plain SQL.
|
static ResultQuery<Record> |
DSL.resultQuery(java.lang.String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
static Sequence<java.math.BigInteger> |
DSL.sequence(java.lang.String sql)
Deprecated.
- 3.10 - [#6162] - Use
DSL.sequence(Name) instead. |
static <T extends java.lang.Number> |
DSL.sequence(java.lang.String sql,
java.lang.Class<T> type)
Deprecated.
- 3.10 - [#6162] - Use
DSL.sequence(Name, Class) instead. |
static <T extends java.lang.Number> |
DSL.sequence(java.lang.String sql,
DataType<T> type)
Deprecated.
- 3.10 - [#6162] - Use
DSL.sequence(Name, DataType)
instead. |
static SQL |
DSL.sql(java.lang.String sql)
A custom SQL clause that can render arbitrary expressions.
|
static SQL |
DSL.sql(java.lang.String sql,
java.lang.Object... bindings)
A custom SQL clause that can render arbitrary expressions.
|
static SQL |
DSL.sql(java.lang.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(java.lang.String sql)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
DSL.table(java.lang.String sql,
java.lang.Object... bindings)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
DSL.table(java.lang.String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary table expressions.
|
Copyright © 2018. All Rights Reserved.