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

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
TableOnStep<Record>	join(TableLike<?> table, JoinType type) Join a table to this table using a JoinType.
TableOnStep<Record>	leftJoin(Name name) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftJoin(SQL sql) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftJoin(java.lang.String sql) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftJoin(java.lang.String sql, java.lang.Object... bindings) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftJoin(java.lang.String sql, QueryPart... parts) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftJoin(TableLike<?> table) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftOuterJoin(Name name) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftOuterJoin(SQL sql) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftOuterJoin(java.lang.String sql) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftOuterJoin(java.lang.String sql, java.lang.Object... bindings) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftOuterJoin(java.lang.String sql, QueryPart... parts) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftOuterJoin(TableLike<?> table) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	rightJoin(Name name) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightJoin(SQL sql) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightJoin(java.lang.String sql) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightJoin(java.lang.String sql, java.lang.Object... bindings) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightJoin(java.lang.String sql, QueryPart... parts) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightJoin(TableLike<?> table) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightOuterJoin(Name name) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightOuterJoin(SQL sql) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightOuterJoin(java.lang.String sql) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightOuterJoin(java.lang.String sql, java.lang.Object... bindings) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightOuterJoin(java.lang.String sql, QueryPart... parts) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightOuterJoin(TableLike<?> table) RIGHT OUTER JOIN a table to this table.

Method Detail

join

@Support
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

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

LEFT OUTER JOIN a table to this table.

A synonym for leftOuterJoin(TableLike).

See Also:

leftOuterJoin(TableLike)

leftJoin

@Support
 @PlainSQL
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

@Support
 @PlainSQL
TableOnStep<Record> leftJoin(java.lang.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

@Support
 @PlainSQL
TableOnStep<Record> leftJoin(java.lang.String sql,
                                                   java.lang.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

@Support
 @PlainSQL
TableOnStep<Record> leftJoin(java.lang.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

@Support
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

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

LEFT OUTER JOIN a table to this table.

leftOuterJoin

@Support
 @PlainSQL
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

@Support
 @PlainSQL
TableOnStep<Record> leftOuterJoin(java.lang.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

@Support
 @PlainSQL
TableOnStep<Record> leftOuterJoin(java.lang.String sql,
                                                        java.lang.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

@Support
 @PlainSQL
TableOnStep<Record> leftOuterJoin(java.lang.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

@Support
TableOnStep<Record> leftOuterJoin(Name name)

LEFT OUTER JOIN a table to this table.

See Also:

DSL.table(Name), SQL

rightJoin

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
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

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
 @PlainSQL
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

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
 @PlainSQL
TableOnStep<Record> rightJoin(java.lang.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

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
 @PlainSQL
TableOnStep<Record> rightJoin(java.lang.String sql,
                                                                                                                                                                                        java.lang.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

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
 @PlainSQL
TableOnStep<Record> rightJoin(java.lang.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

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
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

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
TableOnStep<Record> rightOuterJoin(TableLike<?> table)

RIGHT OUTER JOIN a table to this table.

This is only possible where the underlying RDBMS supports it

rightOuterJoin

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
 @PlainSQL
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

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
 @PlainSQL
TableOnStep<Record> rightOuterJoin(java.lang.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

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
 @PlainSQL
TableOnStep<Record> rightOuterJoin(java.lang.String sql,
                                                                                                                                                                                             java.lang.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

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
 @PlainSQL
TableOnStep<Record> rightOuterJoin(java.lang.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

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
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)