Uses of Class
org.jooq.Pro

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	SelectConnectByAfterStartWithConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectConnectByAfterStartWithStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectConnectByConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForJSONCommonDirectivesStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForJSONStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForXMLCommonDirectivesStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForXMLPathDirectivesStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForXMLRawDirectivesStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForXMLStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectStartWithStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
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.addConnectBy(Condition condition)	Add an Oracle-specific CONNECT BY clause to the query.
void	SelectQuery.addConnectByNoCycle(Condition condition)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query.
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.
@NotNull AlterTableAlterConstraintStep	AlterTableStep.alter(Constraint constraint)	Add an ALTER CONSTRAINT clause to the ALTER TABLE statement.
@NotNull AlterTableAlterConstraintStep	AlterTableStep.alterConstraint(String constraint)	Add an ALTER CONSTRAINT clause to the ALTER TABLE statement.
@NotNull AlterTableAlterConstraintStep	AlterTableStep.alterConstraint(Constraint constraint)	Add an ALTER CONSTRAINT clause to the ALTER TABLE statement.
@NotNull AlterTableAlterConstraintStep	AlterTableStep.alterConstraint(Name constraint)	Add an ALTER CONSTRAINT clause to the ALTER TABLE statement.
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithConditionStep.and(Boolean condition)	Deprecated. - 3.8.0 - [#4763] - Use SelectConnectByAfterStartWithConditionStep.and(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or SelectConnectByAfterStartWithConditionStep.and(Field) instead.
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithConditionStep.and(String sql)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithConditionStep.and(String sql, Object... bindings)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithConditionStep.and(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithConditionStep.and(Condition condition)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithConditionStep.and(Field<Boolean> condition)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithConditionStep.and(SQL sql)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectConnectByConditionStep<R>	SelectConnectByConditionStep.and(Boolean condition)	Deprecated. - 3.8.0 - [#4763] - Use SelectConnectByConditionStep.and(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or SelectConnectByConditionStep.and(Field) instead.
@NotNull SelectConnectByConditionStep<R>	SelectConnectByConditionStep.and(String sql)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectConnectByConditionStep<R>	SelectConnectByConditionStep.and(String sql, Object... bindings)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectConnectByConditionStep<R>	SelectConnectByConditionStep.and(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectConnectByConditionStep<R>	SelectConnectByConditionStep.and(Condition condition)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectConnectByConditionStep<R>	SelectConnectByConditionStep.and(Field<Boolean> condition)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectConnectByConditionStep<R>	SelectConnectByConditionStep.and(SQL sql)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
<A extends ArrayRecord<?>> @NotNull DataType<A>	DataType.asArrayDataType(Class<A> arrayDataType)	Retrieve the data type for an Oracle-style ARRAY of this data type.
@NotNull Table<R>	Table.asOfScn(Number scn)	Create an SQLDialect.ORACLE flashback query clause from this table.
@NotNull Table<R>	Table.asOfScn(Field<? extends Number> scn)	Create an SQLDialect.ORACLE flashback query clause from this table.
@NotNull Table<R>	Table.asOfTimestamp(Timestamp timestamp)	Create an SQLDialect.ORACLE flashback query clause from this table.
@NotNull Table<R>	Table.asOfTimestamp(Field<Timestamp> timestamp)	Create an SQLDialect.ORACLE flashback query clause from this table.
@NotNull Table<R>	Table.at(String link)	A table reference of this table at a given Link.
@NotNull Table<R>	Table.at(Link link)	A table reference of this table at a given Link.
@NotNull Table<R>	Table.at(Name link)	A table reference of this table at a given Link.
@NotNull SelectForJSONCommonDirectivesStep<R>	SelectForJSONStep.auto()	Add a SQL Server-style FOR JSON AUTO clause.
@NotNull SelectForXMLRawDirectivesStep<R>	SelectForXMLStep.auto()	Add a SQL Server-style FOR XML AUTO clause.
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectBy(Boolean condition)	Deprecated. - 3.8.0 - [#4763] - Use SelectConnectByAfterStartWithStep.connectBy(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or SelectConnectByAfterStartWithStep.connectBy(Field) instead.
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectBy(String sql)	Add an Oracle-specific CONNECT BY clause to the query
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectBy(String sql, Object... bindings)	Add an Oracle-specific CONNECT BY clause to the query
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectBy(String sql, QueryPart... parts)	Add an Oracle-specific CONNECT BY clause to the query
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectBy(Condition condition)	Add an Oracle-specific CONNECT BY clause to the query
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectBy(Field<Boolean> condition)	Add an Oracle-specific CONNECT BY clause to the query
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectBy(SQL sql)	Add an Oracle-specific CONNECT BY clause to the query
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectBy(Boolean condition)	Deprecated. - 3.8.0 - [#4763] - Use SelectConnectByStep.connectBy(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or SelectConnectByStep.connectBy(Field) instead.
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectBy(String sql)	Add an Oracle-specific CONNECT BY clause to the query
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectBy(String sql, Object... bindings)	Add an Oracle-specific CONNECT BY clause to the query
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectBy(String sql, QueryPart... parts)	Add an Oracle-specific CONNECT BY clause to the query
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectBy(Condition condition)	Add an Oracle-specific CONNECT BY clause to the query
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectBy(Field<Boolean> condition)	Add an Oracle-specific CONNECT BY clause to the query
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectBy(SQL sql)	Add an Oracle-specific CONNECT BY clause to the query
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectByNoCycle(Boolean condition)	Deprecated. - 3.8.0 - [#4763] - Use SelectConnectByAfterStartWithStep.connectByNoCycle(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or SelectConnectByAfterStartWithStep.connectByNoCycle(Field) instead.
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectByNoCycle(String sql)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectByNoCycle(String sql, Object... bindings)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectByNoCycle(String sql, QueryPart... parts)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectByNoCycle(Condition condition)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectByNoCycle(Field<Boolean> condition)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectByNoCycle(SQL sql)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectByNoCycle(Boolean condition)	Deprecated. - 3.8.0 - [#4763] - Use SelectConnectByStep.connectByNoCycle(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or SelectConnectByStep.connectByNoCycle(Field) instead.
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectByNoCycle(String sql)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectByNoCycle(String sql, Object... bindings)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectByNoCycle(String sql, QueryPart... parts)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectByNoCycle(Condition condition)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectByNoCycle(Field<Boolean> condition)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectByNoCycle(SQL sql)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
@NotNull JSONValueDefaultStep<J>	JSONValueOnStep.default_(Field<?> defaultValue)	Add an NULL ON EMPTY clause.
@NotNull SelectForXMLCommonDirectivesStep<R>	SelectForXMLPathDirectivesStep.elements()	Add a SQL Server-style FOR XML PATH, ELEMENTS clause.
@NotNull SelectForXMLCommonDirectivesStep<R>	SelectForXMLRawDirectivesStep.elements()	Add a SQL Server-style FOR XML RAW, ELEMENTS clause.
@NotNull AlterTableFinalStep	AlterTableAlterConstraintStep.enforced()	Add the ENFORCED clause to the constraint.
@NotNull ConstraintFinalStep	ConstraintEnforcementStep.enforced()	Add the ENFORCED clause to the constraint.
@NotNull JSONValueOnStep<J>	JSONValueOnStep.errorOnEmpty()	Add an ERROR ON EMPTY clause.
@NotNull Condition	JSONExistsOnStep.errorOnError()	Add an ERROR ON ERROR clause.
@NotNull JSONValueOnStep<J>	JSONValueOnStep.errorOnError()	Add an ERROR ON ERROR clause.
@NotNull Condition	JSONExistsOnStep.falseOnError()	Add an FALSE ON ERROR clause.
@NotNull Table<R>	Table.for_(PeriodSpecification periodSpecification)	Create a reference to a temporal table with a PeriodSpecification for usage in Select.
@NotNull SelectForJSONStep<Record1<JSON>>	SelectForStep.forJSON()	Add a SQL Server-style FOR JSON clause.
@NotNull SelectForJSONStep<Record1<JSONB>>	SelectForStep.forJSONB()	Add a SQL Server-style FOR JSON clause.
@NotNull Table<R>	Table.forPortionOf(PeriodSpecification periodSpecification)	Create a reference to a temporal table with a PeriodSpecification for usage in Update and Delete.
@NotNull SelectForXMLStep<Record1<XML>>	SelectForStep.forXML()	Add a SQL Server-style FOR XML clause.
@Nullable Package	Routine.getPackage()	The container package of this stored procedure or function.
@NotNull SelectForJSONCommonDirectivesStep<R>	SelectForJSONCommonDirectivesStep.includeNullValues()	Add a SQL Server-style FOR JSON .., INCLUDE_NULL_VALUES clause.
@NotNull TableOnStep<Record>	TableOuterJoinStep.join(TableLike<?> table, JoinType type)	Join a table to this table using a JoinType.
@NotNull AggregateFilterStep<T>	AggregateFunction.keepDenseRankFirstOrderBy(Collection<? extends OrderField<?>> fields)	Restrict this aggregate function to FIRST values
@NotNull AggregateFilterStep<T>	AggregateFunction.keepDenseRankFirstOrderBy(OrderField<?>... fields)	Restrict this aggregate function to FIRST values
@NotNull AggregateFilterStep<T>	AggregateFunction.keepDenseRankLastOrderBy(Collection<? extends OrderField<?>> fields)	Restrict this aggregate function to FIRST values
@NotNull AggregateFilterStep<T>	AggregateFunction.keepDenseRankLastOrderBy(OrderField<?>... fields)	Restrict this aggregate function to FIRST values
@NotNull TableOnStep<Record>	TableOuterJoinStep.leftJoin(String sql)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.leftJoin(String sql, Object... bindings)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.leftJoin(String sql, QueryPart... parts)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.leftJoin(Name name)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.leftJoin(SQL sql)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.leftJoin(TableLike<?> table)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.leftOuterJoin(String sql)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.leftOuterJoin(String sql, Object... bindings)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.leftOuterJoin(String sql, QueryPart... parts)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.leftOuterJoin(Name name)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.leftOuterJoin(SQL sql)	LEFT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.leftOuterJoin(TableLike<?> table)	LEFT OUTER JOIN a table to this table.
@NotNull AlterTableFinalStep	AlterTableAlterConstraintStep.notEnforced()	Add the NOT ENFORCED clause to the constraint.
@NotNull ConstraintFinalStep	ConstraintEnforcementStep.notEnforced()	Add the NOT ENFORCED clause to the constraint.
@NotNull JSONValueOnStep<J>	JSONValueOnStep.nullOnEmpty()	Add an NULL ON EMPTY clause.
@NotNull JSONValueOnStep<J>	JSONValueOnStep.nullOnError()	Add an NULL ON ERROR clause.
@NotNull JSONValueOnStep<J>	JSONValueDefaultStep.onEmpty()	Add an ON EMPTY clause.
@NotNull JSONValueOnStep<J>	JSONValueDefaultStep.onError()	Add an ON ERROR clause.
@NotNull SelectLimitStep<R>	SelectOrderByStep.orderSiblingsBy(int... fieldIndexes)	Add an ORDER SIBLINGS BY clause to the query
@NotNull SelectLimitStep<R>	SelectOrderByStep.orderSiblingsBy(Collection<? extends OrderField<?>> fields)	Add an ORDER SIBLINGS BY clause to the query
@NotNull SelectLimitStep<R>	SelectOrderByStep.orderSiblingsBy(OrderField<?>... fields)	Add an ORDER SIBLINGS BY clause to the query
@NotNull Block	Parser.parseStatements(String sql)	Parse a SQL string to a set of procedural statements.
@NotNull Block	Parser.parseStatements(String sql, Object... bindings)	Parse a SQL string with bind variables to a set of procedural statements.
@NotNull SelectOnStep<R>	SelectJoinPartitionByStep.partitionBy(Collection<? extends Field<?>> fields)	Add a PARTITION BY clause to the right hand side of the OUTER JOIN keywords
@NotNull SelectOnStep<R>	SelectJoinPartitionByStep.partitionBy(Field<?>... fields)	Add a PARTITION BY clause to the right hand side of the OUTER JOIN keywords
@NotNull TableOuterJoinStep<Record>	Table.partitionBy(Collection<? extends Field<?>> fields)	Add a PARTITION BY clause to the left hand side of the OUTER JOIN keywords
@NotNull TableOuterJoinStep<Record>	Table.partitionBy(Field<?>... fields)	Add a PARTITION BY clause to the left hand side of the OUTER JOIN keywords
@NotNull TableOnStep<R>	TablePartitionByStep.partitionBy(Collection<? extends Field<?>> fields)	Add a PARTITION BY clause to the right hand side of the OUTER JOIN keywords
@NotNull TableOnStep<R>	TablePartitionByStep.partitionBy(Field<?>... fields)	Add a PARTITION BY clause to the right hand side of the OUTER JOIN keywords
@NotNull SelectForJSONCommonDirectivesStep<R>	SelectForJSONStep.path()	Add a SQL Server-style FOR JSON PATH clause.
@NotNull SelectForXMLPathDirectivesStep<R>	SelectForXMLStep.path()	Add a SQL Server-style FOR XML PATH clause.
@NotNull SelectForXMLPathDirectivesStep<R>	SelectForXMLStep.path(String elementName)	Add a SQL Server-style FOR XML PATH clause.
@NotNull PivotForStep	Table.pivot(Collection<? extends Field<?>> aggregateFunctions)	Create a new TABLE reference from this table, pivoting it into another form.
@NotNull PivotForStep	Table.pivot(Field<?>... aggregateFunctions)	Create a new TABLE reference from this table, pivoting it into another form.
@NotNull Field<T>	Field.plus()	Turn this field into an Oracle-specific field for use in outer-join predicates.
@NotNull SelectForXMLRawDirectivesStep<R>	SelectForXMLStep.raw()	Add a SQL Server-style FOR XML RAW clause.
@NotNull SelectForXMLRawDirectivesStep<R>	SelectForXMLStep.raw(String elementName)	Add a SQL Server-style FOR XML RAW clause.
@NotNull TableOnStep<Record>	TableOuterJoinStep.rightJoin(String sql)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.rightJoin(String sql, Object... bindings)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.rightJoin(String sql, QueryPart... parts)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.rightJoin(Name name)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.rightJoin(SQL sql)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.rightJoin(TableLike<?> table)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.rightOuterJoin(String sql)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.rightOuterJoin(String sql, Object... bindings)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.rightOuterJoin(String sql, QueryPart... parts)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.rightOuterJoin(Name name)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.rightOuterJoin(SQL sql)	RIGHT OUTER JOIN a table to this table.
@NotNull TableOnStep<Record>	TableOuterJoinStep.rightOuterJoin(TableLike<?> table)	RIGHT OUTER JOIN a table to this table.
@NotNull SelectForJSONCommonDirectivesStep<R>	SelectForJSONCommonDirectivesStep.root()	Add a SQL Server-style FOR JSON .., ROOT clause.
@NotNull SelectForJSONCommonDirectivesStep<R>	SelectForJSONCommonDirectivesStep.root(String rootName)	Add a SQL Server-style FOR JSON .., ROOT clause.
@NotNull SelectOptionStep<R>	SelectForXMLCommonDirectivesStep.root()	Add a SQL Server-style FOR XML .., ROOT clause.
@NotNull SelectOptionStep<R>	SelectForXMLCommonDirectivesStep.root(String rootName)	Add a SQL Server-style FOR XML .., ROOT clause.
void	SelectQuery.setConnectByStartWith(Condition condition)	Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
void	SelectQuery.setForJSONAuto(boolean forJSONAuto)	Add a FOR JSON AUTO clause to the end of the query.
void	SelectQuery.setForJSONB(boolean forJSONB)	Whether the FOR JSON query should produce JSONB instead of JSON.
void	SelectQuery.setForJSONIncludeNullValues(boolean forJSONIncludeNullValues)	Add a FOR JSON ROOT clause to the end of the query.
void	SelectQuery.setForJSONPath(boolean forJSONPath)	Add a FOR JSON PATH clause to the end of the query.
void	SelectQuery.setForJSONRoot(boolean forJSONRoot)	Add a FOR JSON ROOT clause to the end of the query.
void	SelectQuery.setForJSONRoot(boolean forJSONRoot, String rootName)	Add a FOR JSON ROOT clause to the end of the query.
void	SelectQuery.setForJSONWithoutArrayWrapper(boolean forJSONWithoutArrayWrapper)	Add a FOR JSON ROOT clause to the end of the query.
void	SelectQuery.setForXMLAuto(boolean forXMLAuto)	Add a FOR XML AUTO clause to the end of the query.
void	SelectQuery.setForXMLElements(boolean forXMLElements)	Add a FOR XML ELEMENTS clause to the end of the query.
void	SelectQuery.setForXMLPath(boolean forXMLPath)	Add a FOR XML PATH clause to the end of the query.
void	SelectQuery.setForXMLPath(boolean forXMLPath, String elementName)	Add a FOR XML PATH clause to the end of the query.
void	SelectQuery.setForXMLRaw(boolean forXMLRaw)	Add a FOR XML RAW clause to the end of the query.
void	SelectQuery.setForXMLRaw(boolean forXMLRaw, String elementName)	Add a FOR XML RAW clause to the end of the query.
void	SelectQuery.setForXMLRoot(boolean forXMLRoot)	Add a FOR XML ROOT clause to the end of the query.
void	SelectQuery.setForXMLRoot(boolean forXMLRoot, String rootName)	Add a FOR XML ROOT clause to the end of the query.
void	SelectQuery.setOrderBySiblings(boolean orderBySiblings)	Indicate whether the SIBLINGS keyword should be used in an ORDER BY clause to form an ORDER SIBLINGS BY clause.
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.
@NotNull SelectConnectByAfterStartWithStep<R>	SelectConnectByStep.startWith(Boolean condition)	Deprecated. - 3.8.0 - [#4763] - Use SelectConnectByStep.startWith(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or SelectConnectByStep.startWith(Field) instead.
@NotNull SelectConnectByAfterStartWithStep<R>	SelectConnectByStep.startWith(String sql)	Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
@NotNull SelectConnectByAfterStartWithStep<R>	SelectConnectByStep.startWith(String sql, Object... bindings)	Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
@NotNull SelectConnectByAfterStartWithStep<R>	SelectConnectByStep.startWith(String sql, QueryPart... parts)	Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
@NotNull SelectConnectByAfterStartWithStep<R>	SelectConnectByStep.startWith(Condition condition)	Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
@NotNull SelectConnectByAfterStartWithStep<R>	SelectConnectByStep.startWith(Field<Boolean> condition)	Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
@NotNull SelectConnectByAfterStartWithStep<R>	SelectConnectByStep.startWith(SQL sql)	Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
@NotNull SelectGroupByStep<R>	SelectStartWithStep.startWith(Boolean condition)	Deprecated. - 3.8.0 - [#4763] - Use SelectStartWithStep.startWith(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or SelectStartWithStep.startWith(Field) instead.
@NotNull SelectGroupByStep<R>	SelectStartWithStep.startWith(String sql)	Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
@NotNull SelectGroupByStep<R>	SelectStartWithStep.startWith(String sql, Object... bindings)	Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
@NotNull SelectGroupByStep<R>	SelectStartWithStep.startWith(String sql, QueryPart... parts)	Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
@NotNull SelectGroupByStep<R>	SelectStartWithStep.startWith(Condition condition)	Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
@NotNull SelectGroupByStep<R>	SelectStartWithStep.startWith(Field<Boolean> condition)	Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
@NotNull SelectGroupByStep<R>	SelectStartWithStep.startWith(SQL sql)	Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
@NotNull Block	DSLContext.statements(Collection<? extends Statement> statements)	Wrap a collection of statements in an anonymous procedural block that does not wrap in BEGIN ..
@NotNull Block	DSLContext.statements(Statement... statements)	Wrap a collection of statements in an anonymous procedural block that does not wrap in BEGIN ..
@NotNull Condition	JSONExistsOnStep.trueOnError()	Add an TRUE ON ERROR clause.
@NotNull Condition	JSONExistsOnStep.unknownOnError()	Add an UNKNOWN ON ERROR clause.
@NotNull AlterTableFinalStep	AlterTableUsingIndexStep.usingIndex(String index)	Add the USING INDEX clause to the statement.
@NotNull AlterTableFinalStep	AlterTableUsingIndexStep.usingIndex(Index index)	Add the USING INDEX clause to the statement.
@NotNull AlterTableFinalStep	AlterTableUsingIndexStep.usingIndex(Name index)	Add the USING INDEX clause to the statement.
@NotNull VersionsBetweenAndStep<R,Number>	Table.versionsBetweenScn(Number scn)	Create an SQLDialect.ORACLE flashback versions query clause from this table.
@NotNull VersionsBetweenAndStep<R,Number>	Table.versionsBetweenScn(Field<? extends Number> scn)	Create an SQLDialect.ORACLE flashback versions query clause from this table.
@NotNull VersionsBetweenAndStep<R,Number>	Table.versionsBetweenScnMinvalue()	Create an SQLDialect.ORACLE flashback versions query clause from this table.
@NotNull VersionsBetweenAndStep<R,Timestamp>	Table.versionsBetweenTimestamp(Timestamp timestamp)	Create an SQLDialect.ORACLE flashback versions query clause from this table.
@NotNull VersionsBetweenAndStep<R,Timestamp>	Table.versionsBetweenTimestamp(Field<Timestamp> timestamp)	Create an SQLDialect.ORACLE flashback versions query clause from this table.
@NotNull VersionsBetweenAndStep<R,Timestamp>	Table.versionsBetweenTimestampMinvalue()	Create an SQLDialect.ORACLE flashback versions query clause from this table.
@NotNull Table<R>	Table.with(String hint)	Specify a SQL Server style table hint for query optimisation.
@NotNull Table<R>	Table.with(String hint, Object... binds)	Specify a SQL Server style table hint for query optimisation.
@NotNull Table<R>	Table.with(String hint, QueryPart... parts)	Specify a SQL Server style table hint for query optimisation.
@NotNull Table<R>	Table.with(SQL hint)	Specify a SQL Server style table hint for query optimisation.
@NotNull SelectFinalStep<R>	SelectForUpdateStep.withCheckOption()	Add a WITH CHECK OPTION clause to the end of the subquery.
@NotNull SelectForJSONCommonDirectivesStep<R>	SelectForJSONCommonDirectivesStep.withoutArrayWrapper()	Add a SQL Server-style FOR JSON .., WITHOUT_ARRAY_WRAPPER clause.
@NotNull 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

Methods in org.jooq.impl with annotations of type Pro

Modifier and Type	Method	Description
static <T,A extends ArrayRecord<T>> @NotNull ArrayAggOrderByStep<A>	DSL.collect(Field<T> field, Class<A> type)	Get the collect() aggregate function.
static <T,A extends ArrayRecord<T>> @NotNull ArrayAggOrderByStep<A>	DSL.collect(Field<T> field, DataType<A> type)	Get the collect() aggregate function.
static <T,A extends ArrayRecord<T>> @NotNull ArrayAggOrderByStep<A>	DSL.collectDistinct(Field<T> field, Class<A> type)	Get the collect() aggregate function.
static <T,A extends ArrayRecord<T>> @NotNull ArrayAggOrderByStep<A>	DSL.collectDistinct(Field<T> field, DataType<A> type)	Get the collect() aggregate function.
static @NotNull Field<Boolean>	DSL.connectByIsCycle()	Retrieve the Oracle-specific CONNECT_BY_ISCYCLE pseudo-field (to be used along with CONNECT BY clauses).
static @NotNull Field<Boolean>	DSL.connectByIsLeaf()	Retrieve the Oracle-specific CONNECT_BY_ISLEAF pseudo-field (to be used along with CONNECT BY clauses).
static <T> @NotNull Field<T>	DSL.connectByRoot(Field<T> field)	Retrieve the Oracle-specific CONNECT_BY_ROOT pseudo-column (to be used along with CONNECT BY clauses).
static @NotNull ContinueWhenStep	DSL.continue_()	Create an CONTINUE statement for use in procedural code.
static @NotNull ContinueWhenStep	DSL.continue_(Label label)	Create an CONTINUE statement for use in procedural code.
static @NotNull Statement	DSL.continueWhen(Condition condition)	Create an CONTINUE statement for use in procedural code.
static @NotNull Statement	DSL.continueWhen(Field<Boolean> condition)	Create an CONTINUE statement for use in procedural code.
static <T> @NotNull 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> @NotNull 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>> @NotNull Queue<R>	Internal.createQueue(String name, Schema schema, UDT<R> type)
static <T> @NotNull Declaration<T>	DSL.declare(Variable<T> variable)	Create a local variable declaration for use in procedural code.
static @NotNull Statement	DSL.execute(String sql)	Execute a statement dynamically from within procedural code.
static @NotNull Statement	DSL.execute(Field<String> sql)	Execute a statement dynamically from within procedural code.
static @NotNull Statement	DSL.execute(Query sql)	Execute a statement dynamically from within procedural code.
static @NotNull ExitWhenStep	DSL.exit()	Create an EXIT statement for use in procedural code.
static @NotNull ExitWhenStep	DSL.exit(Label label)	Create an EXIT statement for use in procedural code.
static @NotNull Statement	DSL.exitWhen(Condition condition)	Create an EXIT statement for use in procedural code.
static @NotNull Statement	DSL.exitWhen(Field<Boolean> condition)	Create an EXIT statement for use in procedural code.
static <T> @NotNull ForInStep<T>	DSL.for_(Variable<T> index)	Create a FOR loop for use in procedural code.
Package	AbstractRoutine.getPackage()
static @NotNull Statement	DSL.goto_(Label label)	Create an GOTO statement for use in procedural code.
static @NotNull Field<Integer>	DSL.groupId()	Create a GROUP_ID() aggregation function to be used along with CUBE, ROLLUP, and GROUPING SETS groupings.
static @NotNull Field<Integer>	DSL.groupingId(Field<?>... fields)	Create a GROUPING_ID(field1, field2, .., fieldn) aggregation field to be used along with CUBE, ROLLUP, and GROUPING SETS groupings.
static @NotNull IfThenStep	DSL.if_(Condition condition)	Create an IF statement for use in procedural code.
protected boolean	AbstractRoutine.isPipelined()
static @NotNull Label	DSL.label(String label)	Create a label reference for use in procedural code.
static @NotNull Label	DSL.label(Name label)	Create a label reference for use in procedural code.
static @NotNull Field<Integer>	DSL.level()	Retrieve the Oracle-specific LEVEL pseudo-field (to be used along with CONNECT BY clauses).
static @NotNull Link	DSL.link(String name)	Create a database link reference.
static @NotNull Link	DSL.link(String name, Schema schema)	Create a database link reference.
static @NotNull Link	DSL.link(Name name)	Create a database link reference.
static @NotNull Statement	DSL.loop(Collection<? extends Statement> statements)	Create a LOOP for use in procedural code.
static @NotNull Statement	DSL.loop(Statement... statements)	Create a LOOP for use in procedural code.
static @NotNull Period<Timestamp>	DSL.period(Name name)	Create a named Period reference.
static <T> @NotNull Period<T>	DSL.period(Name name, Class<T> type)	Create a named Period reference.
static <T> @NotNull Period<T>	DSL.period(Name name, DataType<T> type)	Create a named Period reference.
static <T> @NotNull Field<T>	DSL.prior(Field<T> field)	Add the Oracle-specific PRIOR unary operator before a field (to be used along with CONNECT BY clauses).
static @NotNull RepeatUntilStep	DSL.repeat(Collection<? extends Statement> statements)	Create a REPEAT loop for use in procedural code.
static @NotNull RepeatUntilStep	DSL.repeat(Statement... statements)	Create a REPEAT loop for use in procedural code.
static @NotNull Statement	DSL.return_()	Create an RETURN statement for use in procedural code.
static @NotNull Statement	DSL.return_(Object value)	Create an RETURN statement for use in procedural code.
static @NotNull Statement	DSL.return_(Field<?> value)	Create an RETURN statement for use in procedural code.
static @NotNull Field<Integer>	DSL.rownum()	Retrieve the Oracle-specific ROWNUM pseudo-field.
protected void	AbstractRoutine.setPipelined(boolean pipelined)
protected void	AbstractRoutine.setPLSQLBooleanParameter(Parameter<?> parameter)
protected void	AbstractRoutine.setSyntheticReturnParameter(Parameter<T> parameter)
static @NotNull Statement	DSL.statement(String sql)	A custom procedural fragment that can render arbitrary statements.
static @NotNull Statement	DSL.statement(String sql, Object... bindings)	A custom procedural fragment that can render arbitrary statements.
static @NotNull Statement	DSL.statement(String sql, QueryPart... parts)	A custom procedural fragment that can render arbitrary statements.
static @NotNull 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 @NotNull Block	DSL.statements(Collection<? extends Statement> statements)	Wrap a collection of statements in an anonymous procedural block that does not wrap in BEGIN ..
static @NotNull Block	DSL.statements(Statement... statements)	Wrap a collection of statements in an anonymous procedural block that does not wrap in BEGIN ..
static @NotNull Field<String>	DSL.sysConnectByPath(Field<?> field, String separator)	Retrieve the Oracle-specific SYS_CONNECT_BY_PATH(field, separator) function (to be used along with CONNECT BY clauses).
static @NotNull Period<Timestamp>	DSL.systemTime()	Create a SYSTEM_TIME Period reference.
static <T> @NotNull Period<T>	DSL.systemTime(Class<T> type)	Create a SYSTEM_TIME Period reference.
static <T> @NotNull Period<T>	DSL.systemTime(DataType<T> type)	Create a SYSTEM_TIME Period reference.
static @NotNull Table<?>	DSL.table(ArrayRecord<?> array)	A synonym for DSL.unnest(ArrayRecord).
static @NotNull Table<?>	DSL.unnest(ArrayRecord<?> array)	Create a table from an array of values.
static <T> @NotNull Variable<T>	DSL.var(String name, DataType<T> type)	Create a local variable reference for use in procedural code.
static <T> @NotNull Variable<T>	DSL.var(Name name, DataType<T> type)	Create a local variable reference for use in procedural code.
static <T> @NotNull 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> @NotNull 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 @NotNull LoopStep	DSL.while_(Condition condition)	Create a WHILE loop for use in procedural code.
static @NotNull Field<XML>	DSL.xmldocument(Field<XML> content)	The XML document constructor.

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)

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.