org.jooq

Interface TablePartitionByStep<R extends Record>

All Superinterfaces:

TableOnStep<R>

public interface TablePartitionByStep<R extends Record>
extends TableOnStep<R>

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 right 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 and Description
TableOnStep<R>	partitionBy(Collection<? extends Field<?>> fields) Add a PARTITION BY clause to the right hand side of the OUTER JOIN keywords
TableOnStep<R>	partitionBy(Field<?>... fields) Add a PARTITION BY clause to the right hand side of the OUTER JOIN keywords

Methods inherited from interface org.jooq.TableOnStep

on, on, on, on, on, on, on, on, onKey, onKey, onKey, using, using

Method Detail

partitionBy

@Support(value=ORACLE)
TableOnStep<R> partitionBy(Field<?>... fields)

Add a PARTITION BY clause to the right hand side of the OUTER JOIN keywords

partitionBy

@Support(value=ORACLE)
TableOnStep<R> partitionBy(Collection<? extends Field<?>> fields)

Add a PARTITION BY clause to the right hand side of the OUTER JOIN keywords