This type is used for the Oracle Referencing
PIVOT
clause DSL API, pivoting
Table
objects to new tables.
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<T> @NotNull PivotInStep<T>
Add a list of fields to thePIVOT
clause.<T> @NotNull PivotInStep<T>
Deprecated, for removal: This API element is subject to removal in a future version.
-
Method Details
-
on
@Deprecated(forRemoval=true, since="3.12") @NotNull @Support({ORACLE11G,SNOWFLAKE,SQLSERVER}) <T> @NotNull PivotInStep<T> on(Field<T> field) Deprecated, for removal: This API element is subject to removal in a future version.- 3.12.0 - [#8163] - Usefor_(Field)
instead.Add a list of fields to thePIVOT
clause.- Parameters:
field
- The pivoting field- Returns:
- A DSL object to create the
PIVOT
expression
-
for_
Add a list of fields to thePIVOT
clause.- Parameters:
field
- The pivoting field- Returns:
- A DSL object to create the
PIVOT
expression
-
for_(Field)
instead.