Uses of Class org.jooq.Pro (jOOQ 3.13.1 API)

Packages that use Pro
Package	Description
org.jooq	The `org.jooq` package contains jOOQ's public API.
org.jooq.impl	The `org.jooq.impl` package contains jOOQ's implementation classes.
org.jooq.util.oracle	The `org.jooq.util.ase` package contains classes related to the `SQLDialect.ORACLE` dialect.

Uses of Pro in org.jooq

Classes in org.jooq with annotations of type Pro
Modifier and Type	Interface	Description
`interface`	`AlterTableAlterConstraintStep`	The step in the `ALTER TABLE` DSL used to `ALTER` constraints.
`interface`	`ArrayRecord<E>`	A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally providing some convenience methods.
`interface`	`ContinueWhenStep`	A step in the construction of an `CONTINUE` statement where a `WHEN` clause can be added.
`interface`	`Declaration<T>`	A local variable declaration.
`interface`	`ExitWhenStep`	A step in the construction of an `EXIT` statement where a `WHEN` clause can be added.
`interface`	`ForByStep<T>`	The step in the creation of a `FOR LOOP` statement where the `BY` clause can be supplied.
`interface`	`ForInStep<T>`	The step in the creation of a `FOR LOOP` statement where the `IN` clause can be supplied.
`interface`	`IfElseStep`	An intermediate step in building a procedural `IF` statement.
`interface`	`IfThenStep`	An intermediate step in building a procedural `IF` statement.
`interface`	`Label`	A label for use in procedural code.
`interface`	`Link`	A database link reference.
`interface`	`LoopStep`	An intermediate step in building a procedural `LOOP` statement.
`interface`	`Period<T>`	A period specification for usage in temporal tables.
`interface`	`PeriodSpecification`	A specification of a `Period` application for use in `Select` queries.
`interface`	`PeriodSpecificationBetweenAndStep<T>`
`interface`	`PeriodSpecificationFromToStep<T>`
`interface`	`PivotForStep`	This type is used for the Oracle `PIVOT` clause DSL API, pivoting `Table` objects to new tables.
`interface`	`PivotInStep<T>`	This type is used for the Oracle `PIVOT` clause DSL API, pivoting `Table` objects to new tables.
`interface`	`Pro`	An annotation that indicates that any given API is available to the commercial jOOQ distributions only, including the jOOQ Express Edition, the jOOQ Professional Edition, and the jOOQ Enterprise Edition.
`interface`	`RepeatUntilStep`	An intermediate step in building a procedural `REPEAT` statement.
`interface`	`Variable<T>`	A local variable reference.
`interface`	`VersionsBetweenAndStep<R extends Record,T>`	This type is used for the Oracle `VERSIONS` clause DSL API, providing access to the flashback versions query clauses.

Methods in org.jooq with annotations of type Pro
Modifier and Type	Method	Description
`void`	SelectQuery.`addJoin(TableLike<?> table, JoinType type, Condition[] conditions, Field<?>[] partitionBy)`	Joins the existing table product to a new table using conditions, connecting them with each other with `Operator.AND`.
`void`	SelectQuery.`addJoin(TableLike<?> table, JoinType type, Condition conditions, Field<?>[] partitionBy)`	Joins the existing table product to a new table using conditions, connecting them with each other with `Operator.AND`.
`AlterTableAlterConstraintStep`	AlterTableStep.`alter(Constraint constraint)`	Add an `ALTER CONSTRAINT` clause to the `ALTER TABLE` statement.
`AlterTableAlterConstraintStep`	AlterTableStep.`alterConstraint(String constraint)`	Add an `ALTER CONSTRAINT` clause to the `ALTER TABLE` statement.
`AlterTableAlterConstraintStep`	AlterTableStep.`alterConstraint(Constraint constraint)`	Add an `ALTER CONSTRAINT` clause to the `ALTER TABLE` statement.
`AlterTableAlterConstraintStep`	AlterTableStep.`alterConstraint(Name constraint)`	Add an `ALTER CONSTRAINT` clause to the `ALTER TABLE` statement.
`<A extends ArrayRecord<?>> DataType<A>`	DataType.`asArrayDataType(Class<A> arrayDataType)`	Retrieve the data type for an Oracle-style ARRAY of this data type.
`Table<R>`	Table.`asOfScn(Number scn)`	Create an `SQLDialect.ORACLE` flashback query clause from this table.
`Table<R>`	Table.`asOfScn(Field<? extends Number> scn)`	Create an `SQLDialect.ORACLE` flashback query clause from this table.
`Table<R>`	Table.`asOfTimestamp(Timestamp timestamp)`	Create an `SQLDialect.ORACLE` flashback query clause from this table.
`Table<R>`	Table.`asOfTimestamp(Field<Timestamp> timestamp)`	Create an `SQLDialect.ORACLE` flashback query clause from this table.
`Table<R>`	Table.`at(String link)`	A table reference of this table at a given `Link`.
`Table<R>`	Table.`at(Link link)`	A table reference of this table at a given `Link`.
`Table<R>`	Table.`at(Name link)`	A table reference of this table at a given `Link`.
`AlterTableFinalStep`	AlterTableAlterConstraintStep.`enforced()`	Add the `ENFORCED` clause to the constraint.
`ConstraintFinalStep`	ConstraintEnforcementStep.`enforced()`	Add the `ENFORCED` clause to the constraint.
`Table<R>`	Table.`for_(PeriodSpecification periodSpecification)`	Create a reference to a temporal table with a `PeriodSpecification` for usage in `Select`.
`Table<R>`	Table.`forPortionOf(PeriodSpecification periodSpecification)`	Create a reference to a temporal table with a `PeriodSpecification` for usage in `Update` and `Delete`.
`Package`	Routine.`getPackage()`	The container package of this stored procedure or function.
`Package`	UDT.`getPackage()`	Get the UDT package.
`TableOnStep<Record>`	TableOuterJoinStep.`join(TableLike<?> table, JoinType type)`	Join a table to this table using a `JoinType`.
`AggregateFilterStep<T>`	AggregateFunction.`keepDenseRankFirstOrderBy(Collection<? extends OrderField<?>> fields)`	Restrict this aggregate function to `FIRST` values
`AggregateFilterStep<T>`	AggregateFunction.`keepDenseRankFirstOrderBy(OrderField<?>... fields)`	Restrict this aggregate function to `FIRST` values
`AggregateFilterStep<T>`	AggregateFunction.`keepDenseRankLastOrderBy(Collection<? extends OrderField<?>> fields)`	Restrict this aggregate function to `FIRST` values
`AggregateFilterStep<T>`	AggregateFunction.`keepDenseRankLastOrderBy(OrderField<?>... fields)`	Restrict this aggregate function to `FIRST` values
`TableOnStep<Record>`	TableOuterJoinStep.`leftJoin(String sql)`	`LEFT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`leftJoin(String sql, Object... bindings)`	`LEFT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`leftJoin(String sql, QueryPart... parts)`	`LEFT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`leftJoin(Name name)`	`LEFT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`leftJoin(SQL sql)`	`LEFT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`leftJoin(TableLike<?> table)`	`LEFT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`leftOuterJoin(String sql)`	`LEFT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`leftOuterJoin(String sql, Object... bindings)`	`LEFT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`leftOuterJoin(String sql, QueryPart... parts)`	`LEFT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`leftOuterJoin(Name name)`	`LEFT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`leftOuterJoin(SQL sql)`	`LEFT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`leftOuterJoin(TableLike<?> table)`	`LEFT OUTER JOIN` a table to this table.
`AlterTableFinalStep`	AlterTableAlterConstraintStep.`notEnforced()`	Add the `NOT ENFORCED` clause to the constraint.
`ConstraintFinalStep`	ConstraintEnforcementStep.`notEnforced()`	Add the `NOT ENFORCED` clause to the constraint.
`Block`	Parser.`parseStatements(String sql)`	Parse a SQL string to a set of procedural statements.
`Block`	Parser.`parseStatements(String sql, Object... bindings)`	Parse a SQL string with bind variables to a set of procedural statements.
`SelectOnStep<R>`	SelectJoinPartitionByStep.`partitionBy(Collection<? extends Field<?>> fields)`	Add a `PARTITION BY` clause to the right hand side of the `OUTER JOIN` keywords
`SelectOnStep<R>`	SelectJoinPartitionByStep.`partitionBy(Field<?>... fields)`	Add a `PARTITION BY` clause to the right hand side of the `OUTER JOIN` keywords
`TableOuterJoinStep<Record>`	Table.`partitionBy(Collection<? extends Field<?>> fields)`	Add a `PARTITION BY` clause to the left hand side of the `OUTER JOIN` keywords
`TableOuterJoinStep<Record>`	Table.`partitionBy(Field<?>... fields)`	Add a `PARTITION BY` clause to the left hand side of the `OUTER JOIN` keywords
`TableOnStep<R>`	TablePartitionByStep.`partitionBy(Collection<? extends Field<?>> fields)`	Add a `PARTITION BY` clause to the right hand side of the `OUTER JOIN` keywords
`TableOnStep<R>`	TablePartitionByStep.`partitionBy(Field<?>... fields)`	Add a `PARTITION BY` clause to the right hand side of the `OUTER JOIN` keywords
`PivotForStep`	Table.`pivot(Collection<? extends Field<?>> aggregateFunctions)`	Create a new `TABLE` reference from this table, pivoting it into another form.
`PivotForStep`	Table.`pivot(Field<?>... aggregateFunctions)`	Create a new `TABLE` reference from this table, pivoting it into another form.
`Field<T>`	Field.`plus()`	Turn this field into an Oracle-specific field for use in outer-join predicates.
`TableOnStep<Record>`	TableOuterJoinStep.`rightJoin(String sql)`	`RIGHT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`rightJoin(String sql, Object... bindings)`	`RIGHT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`rightJoin(String sql, QueryPart... parts)`	`RIGHT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`rightJoin(Name name)`	`RIGHT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`rightJoin(SQL sql)`	`RIGHT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`rightJoin(TableLike<?> table)`	`RIGHT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`rightOuterJoin(String sql)`	`RIGHT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`rightOuterJoin(String sql, Object... bindings)`	`RIGHT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`rightOuterJoin(String sql, QueryPart... parts)`	`RIGHT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`rightOuterJoin(Name name)`	`RIGHT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`rightOuterJoin(SQL sql)`	`RIGHT OUTER JOIN` a table to this table.
`TableOnStep<Record>`	TableOuterJoinStep.`rightOuterJoin(TableLike<?> table)`	`RIGHT OUTER JOIN` a table to this table.
`void`	SelectQuery.`setWithCheckOption()`	Add a `WITH CHECK OPTION` clause to the end of the subquery.
`void`	SelectQuery.`setWithReadOnly()`	Add a `WITH READ ONLY` clause to the end of the subquery.
`Block`	DSLContext.`statements(Collection<? extends Statement> statements)`	Wrap a collection of statements in an anonymous procedural block that does not wrap in `BEGIN ..`
`Block`	DSLContext.`statements(Statement... statements)`	Wrap a collection of statements in an anonymous procedural block that does not wrap in `BEGIN ..`
`AlterTableFinalStep`	AlterTableUsingIndexStep.`usingIndex(String index)`	Add the `USING INDEX` clause to the statement.
`AlterTableFinalStep`	AlterTableUsingIndexStep.`usingIndex(Index index)`	Add the `USING INDEX` clause to the statement.
`AlterTableFinalStep`	AlterTableUsingIndexStep.`usingIndex(Name index)`	Add the `USING INDEX` clause to the statement.
`VersionsBetweenAndStep<R,Number>`	Table.`versionsBetweenScn(Number scn)`	Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`VersionsBetweenAndStep<R,Number>`	Table.`versionsBetweenScn(Field<? extends Number> scn)`	Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`VersionsBetweenAndStep<R,Number>`	Table.`versionsBetweenScnMinvalue()`	Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`VersionsBetweenAndStep<R,Timestamp>`	Table.`versionsBetweenTimestamp(Timestamp timestamp)`	Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`VersionsBetweenAndStep<R,Timestamp>`	Table.`versionsBetweenTimestamp(Field<Timestamp> timestamp)`	Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`VersionsBetweenAndStep<R,Timestamp>`	Table.`versionsBetweenTimestampMinvalue()`	Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`Table<R>`	Table.`with(String hint)`	Specify a SQL Server style table hint for query optimisation.
`SelectFinalStep<R>`	SelectForUpdateStep.`withCheckOption()`	Add a `WITH CHECK OPTION` clause to the end of the subquery.
`SelectFinalStep<R>`	SelectForUpdateStep.`withReadOnly()`	Add a `WITH READ ONLY` clause to the end of the subquery.

Uses of Pro in org.jooq.impl

Classes in org.jooq.impl with annotations of type Pro
Modifier and Type	Class	Description
`class`	`ArrayRecordImpl<T>`	A common base class for Oracle ARRAY types
`class`	`ConvertDateTime<T>`

Methods in org.jooq.impl with annotations of type Pro
Modifier and Type	Method	Description
`<A extends ArrayRecord<?>> DataType<A>`	DefaultDataType.`asArrayDataType(Class<A> arrayDataType)`
`static <T,A extends ArrayRecord<T>> ArrayAggOrderByStep<A>`	DSL.`collect(Field<T> field, Class<A> type)`	Get the `collect()` aggregate function.
`static <T,A extends ArrayRecord<T>> ArrayAggOrderByStep<A>`	DSL.`collect(Field<T> field, DataType<A> type)`	Get the `collect()` aggregate function.
`static <T,A extends ArrayRecord<T>> ArrayAggOrderByStep<A>`	DSL.`collectDistinct(Field<T> field, Class<A> type)`	Get the `collect()` aggregate function.
`static <T,A extends ArrayRecord<T>> ArrayAggOrderByStep<A>`	DSL.`collectDistinct(Field<T> field, DataType<A> type)`	Get the `collect()` aggregate function.
`static ContinueWhenStep`	DSL.`continue_()`	Create an `CONTINUE` statement for use in procedural code.
`static ContinueWhenStep`	DSL.`continue_(Label label)`	Create an `CONTINUE` statement for use in procedural code.
`static Statement`	DSL.`continueWhen(Condition condition)`	Create an `CONTINUE` statement for use in procedural code.
`static <T> Field<T>`	DSL.`convert(DataType<T> type, Object value, int style)`	Convert a date time value to a string value using the SQL Server style `CONVERT()` function.
`static <T> Field<T>`	DSL.`convert(DataType<T> type, Field<?> value, int style)`	Convert a date time value to a string value using the SQL Server style `CONVERT()` function.
`static <R extends UDTRecord<R>> Queue<R>`	Internal.`createQueue(String name, Schema schema, UDT<R> type)`
`static <T> Declaration<T>`	DSL.`declare(Variable<T> variable)`	Create a local variable declaration for use in procedural code.
`static Statement`	DSL.`execute(String sql)`	Execute a statement dynamically from within procedural code.
`static Statement`	DSL.`execute(Field<String> sql)`	Execute a statement dynamically from within procedural code.
`static Statement`	DSL.`execute(Query sql)`	Execute a statement dynamically from within procedural code.
`static ExitWhenStep`	DSL.`exit()`	Create an `EXIT` statement for use in procedural code.
`static ExitWhenStep`	DSL.`exit(Label label)`	Create an `EXIT` statement for use in procedural code.
`static Statement`	DSL.`exitWhen(Condition condition)`	Create an `EXIT` statement for use in procedural code.
`static <T> ForInStep<T>`	DSL.`for_(Variable<T> index)`	Create a `FOR` loop for use in procedural code.
`Package`	AbstractRoutine.`getPackage()`
`Package`	UDTImpl.`getPackage()`
`static Statement`	DSL.`goto_(Label label)`	Create an `GOTO` statement for use in procedural code.
`static Field<Integer>`	DSL.`groupId()`	Create a `GROUP_ID()` aggregation function to be used along with `CUBE`, `ROLLUP`, and `GROUPING SETS` groupings.
`static IfThenStep`	DSL.`if_(Condition condition)`	Create an `IF` statement for use in procedural code.
`protected boolean`	AbstractRoutine.`isPipelined()`
`static Label`	DSL.`label(String label)`	Create a label reference for use in procedural code.
`static Label`	DSL.`label(Name label)`	Create a label reference for use in procedural code.
`static Link`	DSL.`link(String name)`	Create a database link reference.
`static Link`	DSL.`link(String name, Schema schema)`	Create a database link reference.
`static Link`	DSL.`link(Name name)`	Create a database link reference.
`static Statement`	DSL.`loop(Collection<? extends Statement> statements)`	Create a `LOOP` for use in procedural code.
`static Statement`	DSL.`loop(Statement... statements)`	Create a `LOOP` for use in procedural code.
`static Period<Timestamp>`	DSL.`period(Name name)`	Create a named `Period` reference.
`static <T> Period<T>`	DSL.`period(Name name, Class<T> type)`	Create a named `Period` reference.
`static <T> Period<T>`	DSL.`period(Name name, DataType<T> type)`	Create a named `Period` reference.
`static RepeatUntilStep`	DSL.`repeat(Collection<? extends Statement> statements)`	Create a `REPEAT` loop for use in procedural code.
`static RepeatUntilStep`	DSL.`repeat(Statement... statements)`	Create a `REPEAT` loop for use in procedural code.
`static Statement`	DSL.`return_()`	Create an `RETURN` statement for use in procedural code.
`static Statement`	DSL.`return_(Object value)`	Create an `RETURN` statement for use in procedural code.
`static Statement`	DSL.`return_(Field<?> value)`	Create an `RETURN` statement for use in procedural code.
`protected void`	AbstractRoutine.`setPipelined(boolean pipelined)`
`protected void`	AbstractRoutine.`setPLSQLBooleanParameter(Parameter<?> parameter)`
`static Statement`	DSL.`statement(String sql)`	A custom procedural fragment that can render arbitrary statements.
`static Statement`	DSL.`statement(String sql, Object... bindings)`	A custom procedural fragment that can render arbitrary statements.
`static Statement`	DSL.`statement(String sql, QueryPart... parts)`	A custom procedural fragment that can render arbitrary statements.
`static Statement`	DSL.`statement(SQL sql)`	A custom procedural fragment that can render arbitrary statements.
`Block`	DefaultDSLContext.`statements(Collection<? extends Statement> statements)`
`Block`	DefaultDSLContext.`statements(Statement... statements)`
`static Block`	DSL.`statements(Collection<? extends Statement> statements)`	Wrap a collection of statements in an anonymous procedural block that does not wrap in `BEGIN ..`
`static Block`	DSL.`statements(Statement... statements)`	Wrap a collection of statements in an anonymous procedural block that does not wrap in `BEGIN ..`
`static Period<Timestamp>`	DSL.`systemTime()`	Create a `SYSTEM_TIME` `Period` reference.
`static <T> Period<T>`	DSL.`systemTime(Class<T> type)`	Create a `SYSTEM_TIME` `Period` reference.
`static <T> Period<T>`	DSL.`systemTime(DataType<T> type)`	Create a `SYSTEM_TIME` `Period` reference.
`static Table<?>`	DSL.`table(ArrayRecord<?> array)`	A synonym for `DSL.unnest(ArrayRecord)`.
`static Table<?>`	DSL.`unnest(ArrayRecord<?> array)`	Create a table from an array of values.
`static <T> Variable<T>`	DSL.`var(String name, DataType<T> type)`	Create a local variable reference for use in procedural code.
`static <T> Variable<T>`	DSL.`var(Name name, DataType<T> type)`	Create a local variable reference for use in procedural code.
`static <T> Variable<T>`	DSL.`variable(String name, DataType<T> type)`	A synonym for `DSL.var(Name, DataType)` to be used in Scala and Groovy, where `var` is a reserved keyword.
`static <T> Variable<T>`	DSL.`variable(Name name, DataType<T> type)`	A synonym for `DSL.var(Name, DataType)` to be used in Scala and Groovy, where `var` is a reserved keyword.
`static LoopStep`	DSL.`while_(Condition condition)`	Create a `WHILE` loop for use in procedural code.

Uses of Pro in org.jooq.util.oracle

Classes in org.jooq.util.oracle with annotations of type Pro
Modifier and Type	Interface	Description
`interface`	`Queue<R extends UDTRecord<R>>`	An Oracle AQ specification.
`class`	`QueueImpl<R extends UDTRecord<R>>`	A common base class for AQ.

Uses of Classorg.jooq.Pro

Uses of Pro in org.jooq

Uses of Pro in org.jooq.impl

Uses of Pro in org.jooq.util.oracle

Uses of Class
org.jooq.Pro