@Pro public interface PivotForStepThis type is used for the Oracle
PIVOTclause DSL API, pivoting
Tableobjects to new tables.
XYZ*Steptypes directly from client code
It is usually not recommended to reference any
XYZ*Steptypes 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
- 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
- Lukas Eder
@Deprecated @Support(ORACLE11G) <T> PivotInStep<T> on(Field<T> field)Deprecated.- 3.12.0 - [#8163] - Use
for_(Field)instead.Add a list of fields to the
field- The pivoting field
- A DSL object to create the