Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
Modifier and Type | Interface and Description |
---|---|
interface |
SelectJoinPartitionByStep<R extends Record>
|
interface |
SelectOptionalOnStep<R extends Record>
|
Modifier and Type | Method and Description |
---|---|
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(Name name)
Convenience method to
FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table.fullOuterJoin(Name)
This is only possible where the underlying RDBMS supports it |
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. |
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(String sql)
Convenience method to
FULL OUTER JOIN a table to the last
table added to the FROM clause using
Table.fullOuterJoin(String)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(String sql,
Object... bindings)
Convenience method to
FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table.fullOuterJoin(String, Object...) |
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(String sql,
QueryPart... parts)
Convenience method to
FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table.fullOuterJoin(String, QueryPart...) |
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(TableLike<?> table)
Convenience method to
FULL OUTER JOIN a table to the last
table added to the FROM clause using
Table.fullOuterJoin(TableLike)
This is only possible where the underlying RDBMS supports it |
SelectOnStep<R> |
SelectJoinStep.innerJoin(Name name)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using
Table.join(Name) . |
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) . |
SelectOnStep<R> |
SelectJoinStep.innerJoin(String sql)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using Table.join(String) . |
SelectOnStep<R> |
SelectJoinStep.innerJoin(String sql,
Object... bindings)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using
Table.join(String, Object...) . |
SelectOnStep<R> |
SelectJoinStep.innerJoin(String sql,
QueryPart... parts)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using
Table.join(String, QueryPart...) . |
SelectOnStep<R> |
SelectJoinStep.innerJoin(TableLike<?> table)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using Table.join(TableLike) . |
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) . |
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) . |
SelectOnStep<R> |
SelectJoinStep.join(String sql)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using Table.join(String) . |
SelectOnStep<R> |
SelectJoinStep.join(String sql,
Object... bindings)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using
Table.join(String, Object...) . |
SelectOnStep<R> |
SelectJoinStep.join(String sql,
QueryPart... parts)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using
Table.join(String, QueryPart...) . |
SelectOnStep<R> |
SelectJoinStep.join(TableLike<?> table)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using Table.join(TableLike) . |
SelectOnStep<R> |
SelectJoinStep.leftAntiJoin(TableLike<?> table)
A synthetic
LEFT ANTI JOIN clause that translates to an
equivalent NOT EXISTS predicate. |
SelectOnStep<R> |
SelectJoinStep.leftSemiJoin(TableLike<?> table)
A synthetic
LEFT SEMI JOIN clause that translates to an
equivalent EXISTS predicate. |
SelectOnStep<R> |
SelectJoinPartitionByStep.partitionBy(Collection<? extends Field<?>> fields)
Add a
PARTITION BY clause to the right hand side of the
OUTER JOIN keywords |
SelectOnStep<R> |
SelectJoinPartitionByStep.partitionBy(Field<?>... fields)
Add a
PARTITION BY clause to the right hand side of the
OUTER JOIN keywords |
SelectOnStep<R> |
SelectJoinStep.straightJoin(Name name)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(SQL sql)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(String sql)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(String sql,
Object... bindings)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(String sql,
QueryPart... parts)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(TableLike<?> table)
STRAIGHT_JOIN a table to this table. |
Copyright © 2017. All Rights Reserved.