SQLDialect.ORACLE
OUTER JOIN
clause.
This step allows for adding Oracle-specific PARTITION BY
clauses
to the left of an OUTER JOIN
keyword. See the Oracle
documentation for more details here: https://docs.oracle.com/database/121/SQLRF/statements_10002.htm#BABBCHJA
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. When writing
dynamic SQL, creating a statement's components dynamically, and passing them
to the DSL API statically is usually a better choice. See the manual's
section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.
Drawbacks of referencing the XYZ*Step
types directly:
- They're operating on mutable implementations (as of jOOQ 3.x)
- They're less composable and not easy to get right when dynamic SQL gets complex
- They're less readable
- They might have binary incompatible changes between minor releases
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescription@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
fullOuterJoin
(String sql) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
fullOuterJoin
(String sql, Object... bindings) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
fullOuterJoin
(String sql, QueryPart... parts) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
fullOuterJoin
(Name name) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
fullOuterJoin
(SQL sql) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
fullOuterJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Join a table to this table using aJoinType
.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
leftOuterJoin
(String sql) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
leftOuterJoin
(String sql, Object... bindings) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
leftOuterJoin
(String sql, QueryPart... parts) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
leftOuterJoin
(Name name) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
leftOuterJoin
(SQL sql) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
leftOuterJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
rightOuterJoin
(String sql) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
rightOuterJoin
(String sql, Object... bindings) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
rightOuterJoin
(String sql, QueryPart... parts) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
rightOuterJoin
(Name name) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
rightOuterJoin
(SQL sql) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
rightOuterJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table.
-
Method Details
-
join
@NotNull @Support(ORACLE) @Pro @NotNull TablePartitionByStep<Record> join(TableLike<?> table, JoinType type) Join a table to this table using aJoinType
.Only
JoinType.LEFT_OUTER_JOIN
,JoinType.RIGHT_OUTER_JOIN
, andJoinType.FULL_OUTER_JOIN
are allowed. -
leftJoin
LEFT OUTER JOIN
a table to this table.A synonym for
leftOuterJoin(TableLike)
.- See Also:
-
leftJoin
LEFT OUTER JOIN
a table to this table.A synonym for
leftOuterJoin(String)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
leftJoin
LEFT OUTER JOIN
a table to this table.A synonym for
leftOuterJoin(String)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
leftJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> leftJoin(String sql, Object... bindings) LEFT OUTER JOIN
a table to this table.A synonym for
leftOuterJoin(String, Object...)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
leftJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> leftJoin(String sql, QueryPart... parts) LEFT OUTER JOIN
a table to this table.A synonym for
leftOuterJoin(String, QueryPart...)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
leftJoin
LEFT OUTER JOIN
a table to this table.A synonym for
leftOuterJoin(Name)
.- See Also:
-
leftOuterJoin
@NotNull @Support(ORACLE) @Pro @NotNull TablePartitionByStep<Record> leftOuterJoin(TableLike<?> table) LEFT OUTER JOIN
a table to this table. -
leftOuterJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> leftOuterJoin(SQL sql) LEFT OUTER JOIN
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
leftOuterJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> leftOuterJoin(String sql) LEFT OUTER JOIN
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
leftOuterJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> leftOuterJoin(String sql, Object... bindings) LEFT OUTER JOIN
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
leftOuterJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> leftOuterJoin(String sql, QueryPart... parts) LEFT OUTER JOIN
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
leftOuterJoin
LEFT OUTER JOIN
a table to this table.- See Also:
-
rightJoin
RIGHT OUTER JOIN
a table to this table.A synonym for
rightOuterJoin(TableLike)
.This is only possible where the underlying RDBMS supports it.
- See Also:
-
rightJoin
RIGHT OUTER JOIN
a table to this table.A synonym for
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. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
rightJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> rightJoin(String sql) RIGHT OUTER JOIN
a table to this table.A synonym for
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. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
rightJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> rightJoin(String sql, Object... bindings) RIGHT OUTER JOIN
a table to this table.A synonym for
rightOuterJoin(String, Object...)
.This is only possible where the underlying RDBMS supports it.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
rightJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> rightJoin(String sql, QueryPart... parts) RIGHT OUTER JOIN
a table to this table.A synonym for
rightOuterJoin(String, QueryPart...)
.This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
rightJoin
RIGHT OUTER JOIN
a table to this table.A synonym for
rightOuterJoin(Name)
.This is only possible where the underlying RDBMS supports it
- See Also:
-
rightOuterJoin
@NotNull @Support(ORACLE) @Pro @NotNull TablePartitionByStep<Record> rightOuterJoin(TableLike<?> table) RIGHT OUTER JOIN
a table to this table.This is only possible where the underlying RDBMS supports it
-
rightOuterJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> rightOuterJoin(SQL sql) RIGHT OUTER JOIN
a table to this table.This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
rightOuterJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> rightOuterJoin(String sql) RIGHT OUTER JOIN
a table to this table.This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
rightOuterJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> rightOuterJoin(String sql, Object... bindings) RIGHT OUTER JOIN
a table to this table.This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
rightOuterJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> rightOuterJoin(String sql, QueryPart... parts) RIGHT OUTER JOIN
a table to this table.This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
rightOuterJoin
RIGHT OUTER JOIN
a table to this table.This is only possible where the underlying RDBMS supports it
- See Also:
-
fullJoin
FULL OUTER JOIN
a table to this table.A synonym for
fullOuterJoin(TableLike)
.- See Also:
-
fullJoin
FULL OUTER JOIN
a table to this table.A synonym for
fullOuterJoin(String)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
fullJoin
FULL OUTER JOIN
a table to this table.A synonym for
fullOuterJoin(String)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
fullJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> fullJoin(String sql, Object... bindings) FULL OUTER JOIN
a table to this table.A synonym for
fullOuterJoin(String, Object...)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
fullJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> fullJoin(String sql, QueryPart... parts) FULL OUTER JOIN
a table to this table.A synonym for
fullOuterJoin(String, QueryPart...)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
fullJoin
FULL OUTER JOIN
a table to this table.A synonym for
fullOuterJoin(Name)
.- See Also:
-
fullOuterJoin
@NotNull @Support(ORACLE) @Pro @NotNull TablePartitionByStep<Record> fullOuterJoin(TableLike<?> table) FULL OUTER JOIN
a table to this table. -
fullOuterJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> fullOuterJoin(SQL sql) FULL OUTER JOIN
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
fullOuterJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> fullOuterJoin(String sql) FULL OUTER JOIN
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
fullOuterJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> fullOuterJoin(String sql, Object... bindings) FULL OUTER JOIN
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
fullOuterJoin
@NotNull @Support(ORACLE) @PlainSQL @Pro @NotNull TablePartitionByStep<Record> fullOuterJoin(String sql, QueryPart... parts) FULL OUTER JOIN
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
fullOuterJoin
FULL OUTER JOIN
a table to this table.- See Also:
-