| 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(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 |
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. |
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. |
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 |
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. |
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. |
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 |
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. |
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. |
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(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. |
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. |
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. |
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. |
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. |
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(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 simulated 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(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(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.
|
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.
|
java.util.List<Result<Record>> |
DSLContext.fetchMany(java.lang.String sql)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
java.util.List<Result<Record>> |
DSLContext.fetchMany(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
java.util.List<Result<Record>> |
DSLContext.fetchMany(java.lang.String sql,
QueryPart... parts)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
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.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(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(java.lang.String sql)
Add a
FILTER clause to the aggregate function, connecting
conditions with each other with Operator.AND. |
WindowBeforeOverStep<T> |
AggregateFilterStep.filterWhere(java.lang.String sql,
java.lang.Object... bindings)
Add a
FILTER clause to the aggregate function, connecting
conditions with each other with Operator.AND. |
WindowBeforeOverStep<T> |
AggregateFilterStep.filterWhere(java.lang.String sql,
QueryPart... parts)
Add a
FILTER clause to the aggregate function, connecting
conditions with each other with Operator.AND. |
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 |
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 |
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 |
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(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 |
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)
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnStep |
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 |
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...) |
TablePartitionByStep |
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. |
TablePartitionByStep |
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...) |
TablePartitionByStep |
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(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(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(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 |
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 |
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 |
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(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 |
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. |
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 |
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. |
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 |
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. |
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(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. |
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(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.
|
TablePartitionByStep |
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. |
TablePartitionByStep |
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...) |
TablePartitionByStep |
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(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. |
SelectGroupByStep<R> |
SelectStartWithStep.startWith(java.lang.String sql,
QueryPart... parts)
Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause. |
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. |
DeleteConditionStep<R> |
DeleteWhereStep.where(java.lang.String sql)
Add conditions to the query.
|
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. |
DeleteConditionStep<R> |
DeleteWhereStep.where(java.lang.String sql,
java.lang.Object... bindings)
Add conditions to the query.
|
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. |
DeleteConditionStep<R> |
DeleteWhereStep.where(java.lang.String sql,
QueryPart... parts)
Add conditions to the query.
|
| Modifier and Type | Method and Description |
|---|---|
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(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 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(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(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)
Create a "plain SQL" sequence.
|
static <T extends java.lang.Number> |
DSL.sequence(java.lang.String sql,
java.lang.Class<T> type)
Create a "plain SQL" sequence.
|
static <T extends java.lang.Number> |
DSL.sequence(java.lang.String sql,
DataType<T> type)
Create a "plain SQL" sequence.
|
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(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 © 2015. All Rights Reserved.