Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
Modifier and Type | Interface and Description |
---|---|
interface |
TableOptionalOnStep<R extends Record>
An intermediate type for the construction of a
JOIN clause,
where there may optionally be a join criteria added using an ON
clause (with a Condition ), or using a USING clause (with
a list of Field )
Referencing XYZ*Step types directly from client code
It is usually not recommended to reference any XYZ*Step types
directly from client code, or assign them to local variables. |
interface |
TablePartitionByStep<R extends Record>
An intermediate type for the construction of a partitioned
SQLDialect.ORACLE OUTER JOIN clause. |
Modifier and Type | Method and Description |
---|---|
TableOnStep<Record> |
Table.fullJoin(Name name)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullJoin(SQL sql)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullJoin(String sql)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullJoin(String sql,
Object... bindings)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullJoin(String sql,
QueryPart... parts)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullJoin(TableLike<?> table)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullOuterJoin(Name name)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullOuterJoin(SQL sql)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullOuterJoin(String sql)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullOuterJoin(String sql,
Object... bindings)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullOuterJoin(String sql,
QueryPart... parts)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullOuterJoin(TableLike<?> table)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.innerJoin(Name name)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.innerJoin(SQL sql)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.innerJoin(String sql)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.innerJoin(String sql,
Object... bindings)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.innerJoin(String sql,
QueryPart... parts)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.innerJoin(TableLike<?> table)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.join(Name name)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.join(SQL sql)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.join(String sql)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.join(String sql,
Object... bindings)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.join(String sql,
QueryPart... parts)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.join(TableLike<?> table)
INNER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.join(TableLike<?> table,
JoinType type)
Join a table to this table using a
JoinType . |
TableOnStep<R> |
Table.leftAntiJoin(TableLike<?> table)
A synthetic
LEFT ANTI JOIN clause that translates to an
equivalent NOT EXISTS predicate. |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(Name name)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(SQL sql)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(String sql)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(String sql,
Object... bindings)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(TableLike<?> table)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(Name name)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(SQL sql)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(String sql)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(String sql,
Object... bindings)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(TableLike<?> table)
LEFT OUTER JOIN a table to this table. |
TableOnStep<R> |
Table.leftSemiJoin(TableLike<?> table)
A synthetic
LEFT SEMI JOIN clause that translates to an
equivalent EXISTS predicate. |
TableOnStep<R> |
TablePartitionByStep.partitionBy(Collection<? extends Field<?>> fields)
Add a
PARTITION BY clause to the right hand side of the
OUTER JOIN keywords |
TableOnStep<R> |
TablePartitionByStep.partitionBy(Field<?>... fields)
Add a
PARTITION BY clause to the right hand side of the
OUTER JOIN keywords |
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(Name name)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(SQL sql)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(String sql)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(String sql,
Object... bindings)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(TableLike<?> table)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(Name name)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(SQL sql)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(String sql)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(String sql,
Object... bindings)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(TableLike<?> table)
RIGHT OUTER JOIN a table to this table. |
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. |
TableOnStep<Record> |
Table.straightJoin(String sql)
STRAIGHT_JOIN a table to this table. |
TableOnStep<Record> |
Table.straightJoin(String sql,
Object... bindings)
STRAIGHT_JOIN a table to this table. |
TableOnStep<Record> |
Table.straightJoin(String sql,
QueryPart... parts)
STRAIGHT_JOIN a table to this table. |
TableOnStep<Record> |
Table.straightJoin(TableLike<?> table)
STRAIGHT_JOIN a table to this table. |
Copyright © 2019. All rights reserved.