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

Packages that use Pro
Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.impl	This package contains jOOQ's implementation classes.
org.jooq.tools.jdbc	This package contains compatibility classes to bridge between JDBC 4.0 and JDBC 4.1.
org.jooq.util.oracle	This package contains classes related to the `SQLDialect.ORACLE` dialect family.

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.tools.jdbc

Methods in org.jooq.tools.jdbc with annotations of type Pro
Modifier and Type Method Description

Array MockConnection.createARRAY(String name, Object object)

Methods in org.jooq.tools.jdbc with annotations of type Pro
Modifier and Type	Method	Description
`Array`	MockConnection.`createARRAY(String name, Object object)`

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.tools.jdbc

Uses of Pro in org.jooq.util.oracle

Uses of Class
org.jooq.Pro