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

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
TableOnStep<R>	partitionBy(java.util.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, 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(java.util.Collection<? extends Field<?>> fields)

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