Module org.jooq

Package org.jooq

Interface TableOuterJoinStep<R extends Record>

public interface TableOuterJoinStep<R extends Record>

An intermediate type for the construction of a partitioned 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 Type	Method	Description
@NotNull TableOnStep<Record>	join(TableLike<?> table, JoinType type)	Join a table to this table using a JoinType.
@NotNull TableOnStep<Record>	leftJoin(String sql)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	leftJoin(String sql, Object... bindings)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	leftJoin(String sql, QueryPart... parts)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	leftJoin(Name name)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	leftJoin(SQL sql)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	leftJoin(TableLike<?> table)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	leftOuterJoin(String sql)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	leftOuterJoin(String sql, Object... bindings)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	leftOuterJoin(String sql, QueryPart... parts)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	leftOuterJoin(Name name)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	leftOuterJoin(SQL sql)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	leftOuterJoin(TableLike<?> table)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	rightJoin(String sql)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	rightJoin(String sql, Object... bindings)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	rightJoin(String sql, QueryPart... parts)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	rightJoin(Name name)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	rightJoin(SQL sql)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	rightJoin(TableLike<?> table)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	rightOuterJoin(String sql)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	rightOuterJoin(String sql, Object... bindings)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	rightOuterJoin(String sql, QueryPart... parts)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	rightOuterJoin(Name name)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	rightOuterJoin(SQL sql)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	rightOuterJoin(TableLike<?> table)	RIGHT OUTER JOIN a table to this table.

Method Detail

join

@NotNull
@Support(ORACLE)
@Pro
@NotNull TableOnStep<Record> join(TableLike<?> table,
                                  JoinType type)

Join a table to this table using a JoinType.

Only JoinType.LEFT_OUTER_JOIN, JoinType.RIGHT_OUTER_JOIN, and JoinType.FULL_OUTER_JOIN are allowed.

leftJoin

@NotNull
@Support(ORACLE)
@Pro
@NotNull TableOnStep<Record> leftJoin(TableLike<?> table)

LEFT OUTER JOIN a table to this table.

A synonym for leftOuterJoin(TableLike).

See Also:

leftOuterJoin(TableLike)

leftJoin

@NotNull
@Support(ORACLE)
@PlainSQL
@Pro
@NotNull TableOnStep<Record> leftJoin(SQL sql)

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:

DSL.table(SQL), leftOuterJoin(SQL), SQL

leftJoin

@NotNull
@Support(ORACLE)
@PlainSQL
@Pro
@NotNull TableOnStep<Record> leftJoin(String sql)

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:

DSL.table(String), leftOuterJoin(String), SQL

leftJoin

@NotNull
@Support(ORACLE)
@PlainSQL
@Pro
@NotNull TableOnStep<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!

See Also:

DSL.table(String, Object...), DSL.sql(String, Object...), leftOuterJoin(String, Object...), SQL

leftJoin

@NotNull
@Support(ORACLE)
@PlainSQL
@Pro
@NotNull TableOnStep<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!

See Also:

DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), leftOuterJoin(String, QueryPart...), SQL

leftJoin

@NotNull
@Support(ORACLE)
@Pro
@NotNull TableOnStep<Record> leftJoin(Name name)

LEFT OUTER JOIN a table to this table.

A synonym for leftOuterJoin(Name).

See Also:

DSL.table(Name), leftOuterJoin(Name)

leftOuterJoin

@NotNull
@Support(ORACLE)
@Pro
@NotNull TableOnStep<Record> leftOuterJoin(TableLike<?> table)

LEFT OUTER JOIN a table to this table.

leftOuterJoin

@NotNull
@Support(ORACLE)
@PlainSQL
@Pro
@NotNull TableOnStep<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:

DSL.table(SQL), SQL

leftOuterJoin

@NotNull
@Support(ORACLE)
@PlainSQL
@Pro
@NotNull TableOnStep<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:

DSL.table(String), SQL

leftOuterJoin

@NotNull
@Support(ORACLE)
@PlainSQL
@Pro
@NotNull TableOnStep<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!

See Also:

DSL.table(String, Object...), DSL.sql(String, Object...), SQL

leftOuterJoin

@NotNull
@Support(ORACLE)
@PlainSQL
@Pro
@NotNull TableOnStep<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!

See Also:

DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL

leftOuterJoin

@NotNull
@Support(ORACLE)
@Pro
@NotNull TableOnStep<Record> leftOuterJoin(Name name)

LEFT OUTER JOIN a table to this table.

See Also:

DSL.table(Name), SQL

rightJoin

@NotNull
@Support(ORACLE)
@Pro
@NotNull TableOnStep<Record> rightJoin(TableLike<?> table)

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:

rightOuterJoin(TableLike)

rightJoin

@NotNull
@Support(ORACLE)
@PlainSQL
@Pro
@NotNull TableOnStep<Record> rightJoin(SQL 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:

DSL.table(SQL), rightOuterJoin(SQL), SQL

rightJoin

@NotNull
@Support(ORACLE)
@PlainSQL
@Pro
@NotNull TableOnStep<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:

DSL.table(String), rightOuterJoin(String), SQL

rightJoin

@NotNull
@Support(ORACLE)
@PlainSQL
@Pro
@NotNull TableOnStep<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!

See Also:

DSL.table(String, Object...), DSL.sql(String, Object...), rightOuterJoin(String, Object...), SQL

rightJoin

@NotNull
@Support(ORACLE)
@PlainSQL
@Pro
@NotNull TableOnStep<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!

See Also:

DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), rightOuterJoin(String, QueryPart...), SQL

rightJoin

@NotNull
@Support(ORACLE)
@Pro
@NotNull TableOnStep<Record> rightJoin(Name name)

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:

DSL.table(Name), rightOuterJoin(Name)

rightOuterJoin

@NotNull
@Support(ORACLE)
@Pro
@NotNull TableOnStep<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 TableOnStep<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:

DSL.table(SQL), SQL

rightOuterJoin

@NotNull
@Support(ORACLE)
@PlainSQL
@Pro
@NotNull TableOnStep<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:

DSL.table(String), SQL

rightOuterJoin

@NotNull
@Support(ORACLE)
@PlainSQL
@Pro
@NotNull TableOnStep<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!

See Also:

DSL.table(String, Object...), DSL.sql(String, Object...), SQL

rightOuterJoin

@NotNull
@Support(ORACLE)
@PlainSQL
@Pro
@NotNull TableOnStep<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!

See Also:

DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL

rightOuterJoin

@NotNull
@Support(ORACLE)
@Pro
@NotNull TableOnStep<Record> rightOuterJoin(Name name)

RIGHT OUTER JOIN a table to this table.

This is only possible where the underlying RDBMS supports it

See Also:

DSL.table(Name)