Uses of Annotation Interface
org.jooq.Pro
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
JDBC tooling.
This package contains classes related to the
SQLDialect.ORACLE
dialect family.-
Uses of Pro in org.jooq
Modifier and TypeInterfaceDescriptioninterface
A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), or an associative array, additionally providing some convenience methods.interface
ArrayRecord<E>
A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally providing some convenience methods.interface
A "record" that encapsulates an Oracle-style associative array, additionally providing some convenience methods.interface
An SPI to provide audit fields.enum
The type of the audit info produced by anAuditGenerator
.interface
A step in the construction of theCALL
statement.interface
A step in the construction of anCONTINUE
statement where aWHEN
clause can be added.interface
A step in the construction of theCREATE FUNCTION
statement.interface
A step in the construction of theCREATE FUNCTION
statement.interface
A step in the construction of theCREATE FUNCTION
statement.interface
A step in the construction of theCREATE FUNCTION
statement.interface
A step in the construction of theCREATE PROCEDURE
statement.interface
A step in the construction of theCREATE PROCEDURE
statement.interface
A step in the construction of theCREATE PROCEDURE
statement.interface
A step in the construction of theCREATE TRIGGER
statement.interface
A step in the construction of theCREATE TRIGGER
statement.interface
A step in the construction of theCREATE TRIGGER
statement.interface
A step in the construction of theCREATE TRIGGER
statement.interface
A step in the construction of theCREATE TRIGGER
statement.interface
A step in the construction of theCREATE TRIGGER
statement.interface
A step in the construction of theCREATE TRIGGER
statement.interface
A step in the construction of theCREATE TRIGGER
statement.interface
Declaration<T>
A local variable declaration.interface
A step in the construction of theDROP TRIGGER
statement.interface
A step in the construction of anEXIT
statement where aWHEN
clause can be added.interface
ForByStep<T>
The step in the creation of aFOR LOOP
statement where theBY
clause can be supplied.interface
ForInStep<T>
The step in the creation of aFOR LOOP
statement where theIN
clause can be supplied.interface
An intermediate step in building a proceduralIF
statement.interface
An intermediate step in building a proceduralIF
statement.interface
A label for use in procedural code.interface
A database link reference.interface
An intermediate step in building a proceduralLOOP
statement.interface
A listener that allows for parsing custom SQL.interface
A provider forParseListener
instances.interface
Period<T>
A period specification for usage in temporal tables.interface
interface
interface
interface
This type is used for the OraclePIVOT
clause DSL API, pivotingTable
objects to new tables.interface
PivotInStep<T>
This type is used for the OraclePIVOT
clause DSL API, pivotingTable
objects to new tables.interface
A policy that applies row level security to a table.interface
A policy provider to provide aPolicy
for a table's row level security.@interface
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
An intermediate step in building a proceduralREPEAT
statement.interface
An API forQueryPart.$replace(Replacer)
query part transformations.final class
A set ofReplacer
constructor methods.interface
SelectConnectByAfterStartWithConditionStep<R extends Record>
interface
SelectConnectByAfterStartWithStep<R extends Record>
interface
SelectConnectByConditionStep<R extends Record>
interface
SelectForJSONCommonDirectivesStep<R extends Record>
interface
SelectForJSONStep<R extends Record>
interface
SelectForXMLCommonDirectivesStep<R extends Record>
interface
SelectForXMLPathDirectivesStep<R extends Record>
interface
SelectForXMLRawDirectivesStep<R extends Record>
interface
SelectForXMLStep<R extends Record>
interface
SelectStartWithStep<R extends Record>
interface
A step in the construction of theSIGNAL SQL STATE
function.interface
An SPI to provide SQL transformation configuration and behaviour.interface
Traverser<A,
R> An API forQueryPart.$traverse(Traverser)
query part traversals.final class
A set ofTraverser
constructor methods.interface
A meta model of SQLTRIGGER
objects.enum
The event type on which a trigger fires.enum
The execution scope of a trigger.enum
The time when which a trigger fires.interface
Variable<T>
A local variable reference.interface
VersionsBetweenAndStep<R extends Record,
T> This type is used for the OracleVERSIONS
clause DSL API, providing access to the flashback versions query clauses.Modifier and TypeMethodDescription@Nullable Condition
Select.$connectBy()
Experimental query object model accessor method, see alsoQOM
.Select.$connectBy
(Condition newConnectBy) Experimental query object model accessor method, see alsoQOM
.boolean
Select.$connectByNoCycle()
Experimental query object model accessor method, see alsoQOM
.Select.$connectByNoCycle
(boolean newConnectByNoCycle) Experimental query object model accessor method, see alsoQOM
.@Nullable Condition
Select.$connectByStartWith()
Experimental query object model accessor method, see alsoQOM
.Select.$connectByStartWith
(Condition newConnectByStartWith) Experimental query object model accessor method, see alsoQOM
.default @NotNull QueryPart
Traverse aQueryPart
hierarchy and recursively replace its elements by alternatives.@NotNull QueryPart
Traverse aQueryPart
hierarchy and recursively replace its elements by alternatives.default <R> R
QueryPart.$traverse
(Supplier<R> supplier, BiFunction<? super R, ? super QueryPart, ? extends R> before) Traverser thisQueryPart
expression tree using a composable<R> R
void
SelectQuery.addConnectBy
(Condition condition) Add an Oracle-specificCONNECT BY
clause to the query.void
SelectQuery.addConnectByNoCycle
(Condition condition) Add an Oracle-specificCONNECT 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 withOperator.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 withOperator.AND
.void
SelectQuery.addJoin
(TableLike<?> table, JoinType type, QOM.JoinHint hint, Condition[] conditions, Field<?>[] partitionBy) Joins the existing table product to a new table using conditions, connecting them with each other withOperator.AND
.void
SelectQuery.addJoin
(TableLike<?> table, JoinType type, QOM.JoinHint hint, Condition conditions, Field<?>[] partitionBy) Joins the existing table product to a new table using conditions, connecting them with each other withOperator.AND
.@NotNull SelectConnectByAfterStartWithConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.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.<A extends AssociativeArrayRecord<?,
?>>
@NotNull DataType<A>DataType.asAssociativeArrayDataType
(Class<A> arrayDataType) Retrieve the data type for an Oracle-style associative array of this data type.Create anSQLDialect.ORACLE
flashback query clause from this table.Create anSQLDialect.ORACLE
flashback query clause from this table.Table.asOfTimestamp
(Timestamp timestamp) Create anSQLDialect.ORACLE
flashback query clause from this table.Table.asOfTimestamp
(Field<Timestamp> timestamp) Create anSQLDialect.ORACLE
flashback query clause from this table.A table reference of this table at a givenLink
.A table reference of this table at a givenLink
.A table reference of this table at a givenLink
.@NotNull AuditProvider
Configuration.auditProvider()
Get the configuredAuditProvider
from this configuration.@NotNull SelectForJSONCommonDirectivesStep<R>
SelectForJSONStep.auto()
Add a SQL Server-styleFOR JSON AUTO
clause.@NotNull SelectForXMLRawDirectivesStep<R>
SelectForXMLStep.auto()
Add a SQL Server-styleFOR XML AUTO
clause.void
ExecuteContext.batchQueries
(Query... query) Set the jOOQ batchQuery
objects that are being executed, if applicable.@NotNull SelectForXMLCommonDirectivesStep<R>
SelectForXMLCommonDirectivesStep.binaryBase64()
Add a SQL Server-styleFOR XML …, BINARY BASE64
clause.@NotNull CallArgsStep
TheCALL
statement.@NotNull CallArgsStep
TheCALL
statement.default void
DiagnosticsListener.concatenationInPredicate
(DiagnosticsContext ctx) String concatenation was encountered in predicates.@NotNull SelectConnectByAfterStartWithConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query@NotNull SelectConnectByConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query.@NotNull SelectConnectByConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query.@NotNull SelectConnectByConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query.@NotNull SelectConnectByConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query.@NotNull SelectConnectByConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query.@NotNull SelectConnectByConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query.@NotNull SelectConnectByAfterStartWithConditionStep<R>
SelectConnectByAfterStartWithStep.connectByNoCycle
(String sql) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
SelectConnectByAfterStartWithStep.connectByNoCycle
(String sql, Object... bindings) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
SelectConnectByAfterStartWithStep.connectByNoCycle
(String sql, QueryPart... parts) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
SelectConnectByAfterStartWithStep.connectByNoCycle
(Condition condition) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
SelectConnectByAfterStartWithStep.connectByNoCycle
(Field<Boolean> condition) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
SelectConnectByAfterStartWithStep.connectByNoCycle
(SQL sql) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByConditionStep<R>
SelectConnectByStep.connectByNoCycle
(String sql) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByConditionStep<R>
SelectConnectByStep.connectByNoCycle
(String sql, Object... bindings) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByConditionStep<R>
SelectConnectByStep.connectByNoCycle
(String sql, QueryPart... parts) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByConditionStep<R>
SelectConnectByStep.connectByNoCycle
(Condition condition) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByConditionStep<R>
SelectConnectByStep.connectByNoCycle
(Field<Boolean> condition) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByConditionStep<R>
SelectConnectByStep.connectByNoCycle
(SQL sql) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the querydefault void
DiagnosticsListener.consecutiveAggregation
(DiagnosticsContext ctx) Similar JDBC statements are repeated consecutively with differing aggregation.@NotNull CreateFunctionParametersStep
DSLContext.createFunction
(String function) TheCREATE FUNCTION
statement.@NotNull CreateFunctionParametersStep
DSLContext.createFunction
(Name function) TheCREATE FUNCTION
statement.@NotNull CreateFunctionParametersStep
DSLContext.createOrReplaceFunction
(String function) TheCREATE OR REPLACE FUNCTION
statement.@NotNull CreateFunctionParametersStep
DSLContext.createOrReplaceFunction
(Name function) TheCREATE OR REPLACE FUNCTION
statement.@NotNull CreateProcedureParametersStep
DSLContext.createOrReplaceProcedure
(String procedure) TheCREATE OR REPLACE PROCEDURE
statement.@NotNull CreateProcedureParametersStep
DSLContext.createOrReplaceProcedure
(Name procedure) TheCREATE OR REPLACE PROCEDURE
statement.final boolean
DDLExportConfiguration.createOrReplaceTrigger()
Whether to generateCREATE OR REPLACE TRIGGER
statements.final DDLExportConfiguration
DDLExportConfiguration.createOrReplaceTrigger
(boolean newCreateOrReplaceTrigger) Whether to generateCREATE OR REPLACE TRIGGER
statements.@NotNull CreateTriggerEventStep
DSLContext.createOrReplaceTrigger
(String trigger) TheCREATE OR REPLACE TRIGGER
statement.@NotNull CreateTriggerEventStep
DSLContext.createOrReplaceTrigger
(Name trigger) TheCREATE OR REPLACE TRIGGER
statement.@NotNull CreateTriggerEventStep
DSLContext.createOrReplaceTrigger
(Trigger trigger) TheCREATE OR REPLACE TRIGGER
statement.@NotNull CreateProcedureParametersStep
DSLContext.createProcedure
(String procedure) TheCREATE PROCEDURE
statement.@NotNull CreateProcedureParametersStep
DSLContext.createProcedure
(Name procedure) TheCREATE PROCEDURE
statement.@NotNull CreateTriggerEventStep
DSLContext.createTrigger
(String trigger) TheCREATE TRIGGER
statement.@NotNull CreateTriggerEventStep
DSLContext.createTrigger
(Name trigger) TheCREATE TRIGGER
statement.@NotNull CreateTriggerEventStep
DSLContext.createTrigger
(Trigger trigger) TheCREATE TRIGGER
statement.boolean
Context.declareParameters()
Whether the current context is rendering a procedure or function parameter declaration.Context.declareParameters
(boolean declareParameters) Set the new context value forContext.declareParameters()
.Context.declareParameters
(boolean declareParameters, Consumer<? super C> consumer) Set the new context value forContext.declareParameters()
for the scope of aConsumer
.boolean
QueryPartInternal.declaresParameters()
Check whether thisQueryPart
is able to declare function or procedure parameters.@NotNull JSONValueDefaultStep<J>
Add anNULL ON EMPTY
clause.@NotNull Configuration
Configuration.derive
(AuditProvider newAuditProvider) Create a derived configuration from this one, with a new audit provider.@NotNull Configuration
Configuration.derive
(ParseListener... newParseListeners) Create a derived configuration from this one, with new parse listeners.@NotNull Configuration
Configuration.derive
(ParseListenerProvider... newParseListenerProviders) Create a derived configuration from this one, with new parse listener providers.@NotNull Configuration
Configuration.derive
(PolicyProvider... newPolicyProviders) Create a derived configuration from this one, with a new policy provider.@NotNull Configuration
Configuration.derive
(TransformProvider newTransformProvider) Create a derived configuration from this one, with a new transform provider.@NotNull Configuration
Configuration.deriveAppending
(ParseListener... newParseListeners) Create a derived configuration from this one, with appended parse listeners.@NotNull Configuration
Configuration.deriveAppending
(ParseListenerProvider... newParseListenerProviders) Create a derived configuration from this one, with appended parse listener providers.@NotNull Configuration
Configuration.deriveAppending
(PolicyProvider... newPolicyProvider) Create a derived configuration from this one, with appended policy providers.@NotNull DDLQuery
DSLContext.dropFunction
(String function) TheDROP FUNCTION
statement.@NotNull DDLQuery
DSLContext.dropFunction
(Name function) TheDROP FUNCTION
statement.@NotNull DDLQuery
DSLContext.dropFunctionIfExists
(String function) TheDROP FUNCTION IF EXISTS
statement.@NotNull DDLQuery
DSLContext.dropFunctionIfExists
(Name function) TheDROP FUNCTION IF EXISTS
statement.@NotNull DDLQuery
DSLContext.dropProcedure
(String procedure) TheDROP PROCEDURE
statement.@NotNull DDLQuery
DSLContext.dropProcedure
(Name procedure) TheDROP PROCEDURE
statement.@NotNull DDLQuery
DSLContext.dropProcedureIfExists
(String procedure) TheDROP PROCEDURE IF EXISTS
statement.@NotNull DDLQuery
DSLContext.dropProcedureIfExists
(Name procedure) TheDROP PROCEDURE IF EXISTS
statement.@NotNull DropTriggerOnStep
DSLContext.dropTrigger
(String trigger) TheDROP TRIGGER
statement.@NotNull DropTriggerOnStep
DSLContext.dropTrigger
(Name trigger) TheDROP TRIGGER
statement.@NotNull DropTriggerOnStep
DSLContext.dropTrigger
(Trigger trigger) TheDROP TRIGGER
statement.@NotNull DropTriggerOnStep
DSLContext.dropTriggerIfExists
(String trigger) TheDROP TRIGGER IF EXISTS
statement.@NotNull DropTriggerOnStep
DSLContext.dropTriggerIfExists
(Name trigger) TheDROP TRIGGER IF EXISTS
statement.@NotNull DropTriggerOnStep
DSLContext.dropTriggerIfExists
(Trigger trigger) TheDROP TRIGGER IF EXISTS
statement.@NotNull SelectForXMLCommonDirectivesStep<R>
SelectForXMLPathDirectivesStep.elements()
Add a SQL Server-styleFOR XML PATH, ELEMENTS
clause.@NotNull SelectForXMLCommonDirectivesStep<R>
SelectForXMLRawDirectivesStep.elements()
Add a SQL Server-styleFOR XML RAW, ELEMENTS
clause.@NotNull SelectForXMLCommonDirectivesStep<R>
SelectForXMLPathDirectivesStep.elementsAbsent()
Add a SQL Server-styleFOR XML PATH, ELEMENTS ABSENT
clause.@NotNull SelectForXMLCommonDirectivesStep<R>
SelectForXMLRawDirectivesStep.elementsAbsent()
Add a SQL Server-styleFOR XML PATH, ELEMENTS ABSENT
clause.@NotNull SelectForXMLCommonDirectivesStep<R>
SelectForXMLPathDirectivesStep.elementsXsinil()
Add a SQL Server-styleFOR XML PATH, ELEMENTS XSINIL
clause.@NotNull SelectForXMLCommonDirectivesStep<R>
SelectForXMLRawDirectivesStep.elementsXsinil()
Add a SQL Server-styleFOR XML PATH, ELEMENTS XSINIL
clause.@NotNull JSONValueOnStep<J>
JSONValueOnStep.errorOnEmpty()
Add anERROR ON EMPTY
clause.@NotNull Condition
JSONExistsOnStep.errorOnError()
Add anERROR ON ERROR
clause.@NotNull JSONValueOnStep<J>
JSONValueOnStep.errorOnError()
Add anERROR ON ERROR
clause.@NotNull SelectForXMLPathDirectivesStep<R>
SelectForXMLStep.explicit()
Add a SQL Server-styleFOR XML EXPLICIT
clause.@NotNull Condition
JSONExistsOnStep.falseOnError()
Add anFALSE ON ERROR
clause.@NotNull Meta
Meta.filterTriggers
(Predicate<? super Trigger> filter) Create a wrapperMeta
instance filtering out some triggers.Table.for_
(PeriodSpecification periodSpecification) Create a reference to a temporal table with aPeriodSpecification
for usage inSelect
.@NotNull SelectForJSONStep<Record1<JSON>>
SelectForStep.forJSON()
Add a SQL Server-styleFOR JSON
clause.@NotNull SelectForJSONStep<Record1<JSONB>>
SelectForStep.forJSONB()
Add a SQL Server-styleFOR JSON
clause.Table.forPortionOf
(PeriodSpecification periodSpecification) @NotNull SelectForXMLStep<Record1<XML>>
SelectForStep.forXML()
Add a SQL Server-styleFOR XML
clause.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.fullHashJoin
(Path<?> table) Convenience method toFULL OUTER JOIN
a path to the last table added to theFROM
clause usingTable.fullOuterHashJoin(Path)
.@NotNull SelectOnStep<R>
SelectJoinStep.fullHashJoin
(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterHashJoin(TableLike)
.@NotNull TableOptionalOnStep<Record>
Table.fullHashJoin
(Path<?> path) FULL OUTER JOIN
a path to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
Table.fullHashJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.fullLoopJoin
(Path<?> table) Convenience method toFULL OUTER JOIN
a path to the last table added to theFROM
clause usingTable.fullOuterLoopJoin(Path)
.@NotNull SelectOnStep<R>
SelectJoinStep.fullLoopJoin
(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterLoopJoin(TableLike)
.@NotNull TableOptionalOnStep<Record>
Table.fullLoopJoin
(Path<?> path) FULL OUTER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TablePartitionByStep<Record>
Table.fullLoopJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.fullMergeJoin
(Path<?> table) Convenience method toFULL OUTER JOIN
a path to the last table added to theFROM
clause usingTable.fullOuterMergeJoin(Path)
.@NotNull SelectOnStep<R>
SelectJoinStep.fullMergeJoin
(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterMergeJoin(TableLike)
.@NotNull TableOptionalOnStep<Record>
Table.fullMergeJoin
(Path<?> path) FULL OUTER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TablePartitionByStep<Record>
Table.fullMergeJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.fullOuterHashJoin
(Path<?> table) Convenience method toFULL OUTER JOIN
a path to the last table added to theFROM
clause usingTable.fullOuterHashJoin(Path)
@NotNull SelectOnStep<R>
SelectJoinStep.fullOuterHashJoin
(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterHashJoin(TableLike)
@NotNull TableOptionalOnStep<Record>
Table.fullOuterHashJoin
(Path<?> path) FULL OUTER JOIN
a path to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
Table.fullOuterHashJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.fullOuterJoin
(String sql) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.fullOuterJoin
(String sql, Object... bindings) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.fullOuterJoin
(String sql, QueryPart... parts) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.fullOuterJoin
(Name name) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.fullOuterJoin
(SQL sql) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.fullOuterJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.fullOuterLoopJoin
(Path<?> table) Convenience method toFULL OUTER JOIN
a path to the last table added to theFROM
clause usingTable.fullOuterLoopJoin(Path)
@NotNull SelectOnStep<R>
SelectJoinStep.fullOuterLoopJoin
(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterLoopJoin(TableLike)
@NotNull TableOptionalOnStep<Record>
Table.fullOuterLoopJoin
(Path<?> path) FULL OUTER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TablePartitionByStep<Record>
Table.fullOuterLoopJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.fullOuterMergeJoin
(Path<?> table) Convenience method toFULL OUTER JOIN
a path to the last table added to theFROM
clause usingTable.fullOuterMergeJoin(Path)
@NotNull SelectOnStep<R>
SelectJoinStep.fullOuterMergeJoin
(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterMergeJoin(TableLike)
@NotNull TableOptionalOnStep<Record>
Table.fullOuterMergeJoin
(Path<?> path) FULL OUTER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TablePartitionByStep<Record>
Table.fullOuterMergeJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@Nullable Package
Routine.getPackage()
The container package of this stored procedure or function.Meta.getTriggers()
Get all trigger objects from the underlying meta data source.Meta.getTriggers
(String name) Get all trigger objects by name from the underlying meta data source.Meta.getTriggers
(Name name) Get all trigger objects by name from the underlying meta data source.Table.getTriggers()
Get a list ofTRIGGER
objects of this table.@NotNull SelectOptionalOnStep<R>
Convenience method toINNER JOIN
a path to the last table added to theFROM
clause usingTable.hashJoin(Path)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.hashJoin(TableLike)
.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull SelectForJSONCommonDirectivesStep<R>
SelectForJSONCommonDirectivesStep.includeNullValues()
Add a SQL Server-styleFOR JSON …, INCLUDE_NULL_VALUES
clause.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.innerHashJoin
(Path<?> path) Convenience method toINNER JOIN
a path to the last table added to theFROM
clause usingTable.innerHashJoin(Path)
.@NotNull SelectOnStep<R>
SelectJoinStep.innerHashJoin
(TableLike<?> table) Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.innerHashJoin(TableLike)
.@NotNull TableOptionalOnStep<Record>
Table.innerHashJoin
(Path<?> path) INNER JOIN
a path to this table with aQOM.JoinHint.HASH
hint.@NotNull TableOnStep<Record>
Table.innerHashJoin
(TableLike<?> table) INNER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.innerLoopJoin
(Path<?> path) Convenience method toINNER JOIN
a path to the last table added to theFROM
clause usingTable.innerLoopJoin(Path)
.@NotNull SelectOnStep<R>
SelectJoinStep.innerLoopJoin
(TableLike<?> table) Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.innerLoopJoin(TableLike)
.@NotNull TableOptionalOnStep<Record>
Table.innerLoopJoin
(Path<?> path) INNER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TableOnStep<Record>
Table.innerLoopJoin
(TableLike<?> table) INNER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.innerMergeJoin
(Path<?> path) Convenience method toINNER JOIN
a path to the last table added to theFROM
clause usingTable.innerMergeJoin(Path)
.@NotNull SelectOnStep<R>
SelectJoinStep.innerMergeJoin
(TableLike<?> table) Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.innerMergeJoin(TableLike)
.@NotNull TableOptionalOnStep<Record>
Table.innerMergeJoin
(Path<?> path) INNER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TableOnStep<Record>
Table.innerMergeJoin
(TableLike<?> table) INNER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull SelectFromStep<R>
SelectIntoStep.into
(Collection<? extends Variable<?>> variables) Add a PL/SQL styleINTO
clause to theSELECT
statement to assign the projection of a single rowSELECT
statement to local variables in a procedural context.@NotNull SelectFromStep<R>
Add a PL/SQL styleINTO
clause to theSELECT
statement to assign the projection of a single rowSELECT
statement to local variables in a procedural context.@NotNull TablePartitionByStep<Record>
Join a table to this table using aJoinType
.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.join
(TableLike<?> table, JoinType type, QOM.JoinHint hint) Join a table to this table using aJoinType
and aQOM.JoinHint
.@NotNull AggregateFilterStep<T>
AggregateFunction.keepDenseRankFirstOrderBy
(Collection<? extends OrderField<?>> fields) Restrict this aggregate function toFIRST
values@NotNull AggregateFilterStep<T>
AggregateFunction.keepDenseRankFirstOrderBy
(OrderField<?>... fields) Restrict this aggregate function toFIRST
values@NotNull AggregateFilterStep<T>
AggregateFunction.keepDenseRankLastOrderBy
(Collection<? extends OrderField<?>> fields) Restrict this aggregate function toLAST
values@NotNull AggregateFilterStep<T>
AggregateFunction.keepDenseRankLastOrderBy
(OrderField<?>... fields) Restrict this aggregate function toLAST
values@NotNull SelectOptionalOnStep<R>
SelectJoinStep.leftHashJoin
(Path<?> table) Convenience method toLEFT OUTER JOIN
a path to the last table added to theFROM
clause usingTable.leftOuterHashJoin(Path)
.@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.leftHashJoin
(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterHashJoin(TableLike)
.@NotNull TableOptionalOnStep<Record>
Table.leftHashJoin
(Path<?> path) LEFT OUTER JOIN
a path to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
Table.leftHashJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.leftLoopJoin
(Path<?> table) Convenience method toLEFT OUTER JOIN
a path to the last table added to theFROM
clause usingTable.leftOuterLoopJoin(Path)
.@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.leftLoopJoin
(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterLoopJoin(TableLike)
.@NotNull TableOptionalOnStep<Record>
Table.leftLoopJoin
(Path<?> path) LEFT OUTER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TablePartitionByStep<Record>
Table.leftLoopJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.leftMergeJoin
(Path<?> table) Convenience method toLEFT OUTER JOIN
a path to the last table added to theFROM
clause usingTable.leftOuterMergeJoin(Path)
.@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.leftMergeJoin
(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterMergeJoin(TableLike)
.@NotNull TableOptionalOnStep<Record>
Table.leftMergeJoin
(Path<?> path) LEFT OUTER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TablePartitionByStep<Record>
Table.leftMergeJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.leftOuterHashJoin
(Path<?> path) Convenience method toLEFT OUTER JOIN
a path to the last table added to theFROM
clause usingTable.leftOuterHashJoin(Path)
@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.leftOuterHashJoin
(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterHashJoin(TableLike)
@NotNull TableOptionalOnStep<Record>
Table.leftOuterHashJoin
(Path<?> path) LEFT OUTER JOIN
a path to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
Table.leftOuterHashJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.leftOuterJoin
(String sql) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.leftOuterJoin
(String sql, Object... bindings) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.leftOuterJoin
(String sql, QueryPart... parts) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.leftOuterJoin
(Name name) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.leftOuterJoin
(SQL sql) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.leftOuterJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.leftOuterLoopJoin
(Path<?> path) Convenience method toLEFT OUTER JOIN
a path to the last table added to theFROM
clause usingTable.leftOuterLoopJoin(Path)
@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.leftOuterLoopJoin
(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterLoopJoin(TableLike)
@NotNull TableOptionalOnStep<Record>
Table.leftOuterLoopJoin
(Path<?> path) LEFT OUTER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TablePartitionByStep<Record>
Table.leftOuterLoopJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.leftOuterMergeJoin
(Path<?> path) Convenience method toLEFT OUTER JOIN
a path to the last table added to theFROM
clause usingTable.leftOuterMergeJoin(Path)
@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.leftOuterMergeJoin
(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterMergeJoin(TableLike)
@NotNull TableOptionalOnStep<Record>
Table.leftOuterMergeJoin
(Path<?> path) LEFT OUTER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TablePartitionByStep<Record>
Table.leftOuterMergeJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull SelectOptionalOnStep<R>
Convenience method toINNER JOIN
a path to the last table added to theFROM
clause usingTable.loopJoin(Path)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.loopJoin(TableLike)
.@NotNull TableOptionalOnStep<Record>
INNER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectOptionalOnStep<R>
Convenience method toINNER JOIN
a path to the last table added to theFROM
clause usingTable.mergeJoin(Path)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.mergeJoin(TableLike)
.@NotNull TableOptionalOnStep<Record>
INNER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.default void
DiagnosticsListener.nullCondition
(DiagnosticsContext ctx) ANULL
condition was encountered, which is almost always a mistake.@NotNull JSONValueOnStep<J>
JSONValueOnStep.nullOnEmpty()
Add anNULL ON EMPTY
clause.@NotNull JSONValueOnStep<J>
JSONValueOnStep.nullOnError()
Add anNULL ON ERROR
clause.@NotNull JSONValueOnStep<J>
JSONValueDefaultStep.onEmpty()
Add anON EMPTY
clause.@NotNull JSONValueOnStep<J>
JSONValueDefaultStep.onError()
Add anON ERROR
clause.@NotNull SelectLimitStep<R>
SelectOrderByStep.orderSiblingsBy
(int... fieldIndexes) Add anORDER SIBLINGS BY
clause to the query@NotNull SelectLimitStep<R>
SelectOrderByStep.orderSiblingsBy
(Collection<? extends OrderField<?>> fields) Add anORDER SIBLINGS BY
clause to the query@NotNull SelectLimitStep<R>
SelectOrderByStep.orderSiblingsBy
(OrderField<?>... fields) Add anORDER SIBLINGS BY
clause to the query@NotNull Query @NotNull []
ExecuteContext.originalBatchQueries()
The original batchQuery
objects that were available at theExecuteListener.start(ExecuteContext)
of thisExecuteContext
.@Nullable Query
ExecuteContext.originalQuery()
The originalQuery
that was available at theExecuteListener.start(ExecuteContext)
of thisExecuteContext
, ornull
if the query is unknown, if it is a batch query, or if there was no jOOQQuery
.@NotNull ParseListenerProvider @NotNull []
Configuration.parseListenerProviders()
Get the configuredParseListenerProvider
instances from this configuration.@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 aPARTITION BY
clause to the right hand side of theOUTER JOIN
keywords@NotNull SelectOnStep<R>
SelectJoinPartitionByStep.partitionBy
(Field<?>... fields) Add aPARTITION BY
clause to the right hand side of theOUTER JOIN
keywords@NotNull TableOuterJoinStep<Record>
Table.partitionBy
(Collection<? extends Field<?>> fields) Add aPARTITION BY
clause to the left hand side of theOUTER JOIN
keywords@NotNull TableOuterJoinStep<Record>
Table.partitionBy
(Field<?>... fields) Add aPARTITION BY
clause to the left hand side of theOUTER JOIN
keywords@NotNull TableOnStep<R>
TablePartitionByStep.partitionBy
(Collection<? extends Field<?>> fields) Add aPARTITION BY
clause to the right hand side of theOUTER JOIN
keywords@NotNull TableOnStep<R>
TablePartitionByStep.partitionBy
(Field<?>... fields) Add aPARTITION BY
clause to the right hand side of theOUTER JOIN
keywords@NotNull SelectForJSONCommonDirectivesStep<R>
SelectForJSONStep.path()
Add a SQL Server-styleFOR JSON PATH
clause.@NotNull SelectForXMLPathDirectivesStep<R>
SelectForXMLStep.path()
Add a SQL Server-styleFOR XML PATH
clause.@NotNull SelectForXMLPathDirectivesStep<R>
Add a SQL Server-styleFOR XML PATH
clause.@NotNull PivotForStep
Table.pivot
(Collection<? extends Field<?>> aggregateFunctions) Create a newTABLE
reference from this table, pivoting it into another form.@NotNull PivotForStep
Create a newTABLE
reference from this table, pivoting it into another form.@NotNull PivotForStep
Create a newTABLE
reference from this table, pivoting it into another form.Field.plus()
ThePLUS
operator.@NotNull PolicyProvider @NotNull []
Configuration.policyProviders()
Get the configuredPolicyProvider
instances from this configuration.default void
DiagnosticsListener.possiblyWrongExpression
(DiagnosticsContext ctx) A possibly wrong expression was encountered.void
Set the jOOQQuery
that is being executed, if applicable.@NotNull SelectForXMLRawDirectivesStep<R>
SelectForXMLStep.raw()
Add a SQL Server-styleFOR XML RAW
clause.@NotNull SelectForXMLRawDirectivesStep<R>
Add a SQL Server-styleFOR XML RAW
clause.final boolean
DDLExportConfiguration.respectTriggerOrder()
Whether to respect the trigger order produced by theMeta
source when generated trigger DDL.final DDLExportConfiguration
DDLExportConfiguration.respectTriggerOrder
(boolean newRespectTriggerOrder) Whether to respect the trigger order produced by theMeta
source when generated trigger DDL.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.rightHashJoin
(Path<?> path) Convenience method toRIGHT OUTER JOIN
a path to the last table added to theFROM
clause usingTable.rightOuterHashJoin(Path)
.@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.rightHashJoin
(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterHashJoin(TableLike)
.@NotNull TableOptionalOnStep<Record>
Table.rightHashJoin
(Path<?> path) RIGHT OUTER JOIN
a path to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
Table.rightHashJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.rightLoopJoin
(Path<?> path) Convenience method toRIGHT OUTER JOIN
a path to the last table added to theFROM
clause usingTable.rightOuterLoopJoin(Path)
.@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.rightLoopJoin
(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterLoopJoin(TableLike)
.@NotNull TableOptionalOnStep<Record>
Table.rightLoopJoin
(Path<?> path) RIGHT OUTER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TablePartitionByStep<Record>
Table.rightLoopJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.rightMergeJoin
(Path<?> path) Convenience method toRIGHT OUTER JOIN
a path to the last table added to theFROM
clause usingTable.rightOuterMergeJoin(Path)
.@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.rightMergeJoin
(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterMergeJoin(TableLike)
.@NotNull TableOptionalOnStep<Record>
Table.rightMergeJoin
(Path<?> path) RIGHT OUTER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TablePartitionByStep<Record>
Table.rightMergeJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.rightOuterHashJoin
(Path<?> path) Convenience method toRIGHT OUTER JOIN
a path to the last table added to theFROM
clause usingTable.rightOuterHashJoin(Path)
@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.rightOuterHashJoin
(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterHashJoin(TableLike)
@NotNull TableOptionalOnStep<Record>
Table.rightOuterHashJoin
(Path<?> path) RIGHT OUTER JOIN
a path to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
Table.rightOuterHashJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.rightOuterJoin
(String sql) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.rightOuterJoin
(String sql, Object... bindings) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.rightOuterJoin
(String sql, QueryPart... parts) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.rightOuterJoin
(Name name) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.rightOuterJoin
(SQL sql) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.rightOuterJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.rightOuterLoopJoin
(Path<?> path) Convenience method toRIGHT OUTER JOIN
a path to the last table added to theFROM
clause usingTable.rightOuterLoopJoin(Path)
@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.rightOuterLoopJoin
(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterLoopJoin(TableLike)
@NotNull TableOptionalOnStep<Record>
Table.rightOuterLoopJoin
(Path<?> path) RIGHT OUTER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TablePartitionByStep<Record>
Table.rightOuterLoopJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectOptionalOnStep<R>
SelectJoinStep.rightOuterMergeJoin
(Path<?> path) Convenience method toRIGHT OUTER JOIN
a path to the last table added to theFROM
clause usingTable.rightOuterMergeJoin(Path)
@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.rightOuterMergeJoin
(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterMergeJoin(TableLike)
@NotNull TableOptionalOnStep<Record>
Table.rightOuterMergeJoin
(Path<?> path) RIGHT OUTER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TablePartitionByStep<Record>
Table.rightOuterMergeJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull SelectForJSONCommonDirectivesStep<R>
SelectForJSONCommonDirectivesStep.root()
Add a SQL Server-styleFOR JSON …, ROOT
clause.@NotNull SelectForJSONCommonDirectivesStep<R>
Add a SQL Server-styleFOR JSON …, ROOT
clause.@NotNull SelectForXMLCommonDirectivesStep<R>
SelectForXMLCommonDirectivesStep.root()
Add a SQL Server-styleFOR XML …, ROOT
clause.@NotNull SelectForXMLCommonDirectivesStep<R>
Add a SQL Server-styleFOR XML …, ROOT
clause.@NotNull Configuration
Configuration.set
(AuditProvider newAuditProvider) Change this configuration to hold new audit provider.@NotNull Configuration
Configuration.set
(ParseListener... newParseListeners) Change this configuration to hold new parse listeners.@NotNull Configuration
Configuration.set
(ParseListenerProvider... newParseListenerProviders) Change this configuration to hold new parse listener providers.@NotNull Configuration
Configuration.set
(PolicyProvider... newPolicyProviders) Change this configuration to hold new policy provider.@NotNull Configuration
Configuration.set
(TransformProvider newTransformProvider) Change this configuration to hold new transform provider.@NotNull Configuration
Configuration.setAppending
(ParseListener... newParseListeners) Change this configuration by appending new parse listeners.@NotNull Configuration
Configuration.setAppending
(ParseListenerProvider... newParseListenerProviders) Change this configuration by appending new parse listener providers.void
SelectQuery.setConnectByStartWith
(Condition condition) Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.void
SelectQuery.setForJSONAuto
(boolean forJSONAuto) Add aFOR JSON AUTO
clause to the end of the query.void
SelectQuery.setForJSONB
(boolean forJSONB) void
SelectQuery.setForJSONIncludeNullValues
(boolean forJSONIncludeNullValues) Add aFOR JSON ROOT
clause to the end of the query.void
SelectQuery.setForJSONPath
(boolean forJSONPath) Add aFOR JSON PATH
clause to the end of the query.void
SelectQuery.setForJSONRoot
(boolean forJSONRoot) Add aFOR JSON ROOT
clause to the end of the query.void
SelectQuery.setForJSONRoot
(boolean forJSONRoot, String rootName) Add aFOR JSON ROOT
clause to the end of the query.void
SelectQuery.setForJSONWithoutArrayWrapper
(boolean forJSONWithoutArrayWrapper) Add aFOR JSON ROOT
clause to the end of the query.void
SelectQuery.setForXMLAuto
(boolean forXMLAuto) Add aFOR XML AUTO
clause to the end of the query.void
SelectQuery.setForXMLBinaryBase64
(boolean forXMLBinaryBase64) Add aFOR XML BINARY BASE64
clause to the end of the query.void
SelectQuery.setForXMLElements
(boolean forXMLElements) Add aFOR XML ELEMENTS
clause to the end of the query.void
SelectQuery.setForXMLElementsAbsent
(boolean forXMLElementsAbsent) Add aFOR XML ELEMENTS ABSENT
clause to the end of the query.void
SelectQuery.setForXMLElementsXsinil
(boolean forXMLElementsXsinil) Add aFOR XML ELEMENTS XSINIL
clause to the end of the query.void
SelectQuery.setForXMLExplicit
(boolean forXMLExplicit) Add aFOR XML EXPLICIT
clause to the end of the query.void
SelectQuery.setForXMLPath
(boolean forXMLPath) Add aFOR XML PATH
clause to the end of the query.void
SelectQuery.setForXMLPath
(boolean forXMLPath, String elementName) Add aFOR XML PATH
clause to the end of the query.void
SelectQuery.setForXMLRaw
(boolean forXMLRaw) Add aFOR XML RAW
clause to the end of the query.void
SelectQuery.setForXMLRaw
(boolean forXMLRaw, String elementName) Add aFOR XML RAW
clause to the end of the query.void
SelectQuery.setForXMLRoot
(boolean forXMLRoot) Add aFOR XML ROOT
clause to the end of the query.void
SelectQuery.setForXMLRoot
(boolean forXMLRoot, String rootName) Add aFOR XML ROOT
clause to the end of the query.void
SelectQuery.setForXMLType
(boolean forXMLType) Add aFOR XML TYPE
clause to the end of the query.void
SelectQuery.setInto
(Collection<? extends Variable<?>> variables) Add a PL/SQL styleINTO
clause to theSELECT
statement to assign the projection of a single rowSELECT
statement to local variables in a procedural context.void
SelectQuery.setOrderBySiblings
(boolean orderBySiblings) Indicate whether theSIBLINGS
keyword should be used in anORDER BY
clause to form anORDER SIBLINGS BY
clause.@NotNull SelectConnectByAfterStartWithStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectConnectByAfterStartWithStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectConnectByAfterStartWithStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectConnectByAfterStartWithStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectConnectByAfterStartWithStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectConnectByAfterStartWithStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectGroupByStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectGroupByStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectGroupByStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectGroupByStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectGroupByStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectGroupByStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull Block
DSLContext.statements
(Collection<? extends Statement> statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;
, unless explicitly needed.@NotNull Block
DSLContext.statements
(Statement... statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;
, unless explicitly needed.@NotNull Query @NotNull []
ExecuteContext.transformedBatchQueries()
The transformed batchQuery
objects that were available at theExecuteListener.transformEnd(ExecuteContext)
event of thisExecuteContext
.@Nullable Query
ExecuteContext.transformedQuery()
The transformedQuery
that was available at theExecuteListener.transformEnd(ExecuteContext)
event of thisExecuteContext
, ornull
if the query is unknown, if it is a batch query, or if there was no jOOQQuery
.default void
ExecuteListener.transformEnd
(ExecuteContext ctx) Called before transforming aQuery
.default void
DiagnosticsListener.transformPattern
(DiagnosticsContext ctx) ASettings.isTransformPatterns()
pattern has been matched.@NotNull TransformProvider
Configuration.transformProvider()
Get the configuredTransformProvider
from this configuration.default void
ExecuteListener.transformStart
(ExecuteContext ctx) Called before transforming aQuery
.default void
DiagnosticsListener.trivialCondition
(DiagnosticsContext ctx) A trivial condition was encountered, which can be replaced by aNULL
predicate, or even byDSL.trueCondition()
orDSL.falseCondition()
, but it is more likely just a typo.@NotNull Condition
JSONExistsOnStep.trueOnError()
Add anTRUE ON ERROR
clause.@NotNull SelectForXMLCommonDirectivesStep<R>
SelectForXMLCommonDirectivesStep.type()
Add a SQL Server-styleFOR XML …, ROOT
clause.@NotNull Condition
JSONExistsOnStep.unknownOnError()
Add anUNKNOWN ON ERROR
clause.@NotNull AlterTableFinalStep
AlterTableUsingIndexStep.usingIndex
(String index) Add theUSING INDEX
clause to the statement.@NotNull AlterTableFinalStep
AlterTableUsingIndexStep.usingIndex
(Index index) Add theUSING INDEX
clause to the statement.@NotNull AlterTableFinalStep
AlterTableUsingIndexStep.usingIndex
(Name index) Add theUSING INDEX
clause to the statement.@NotNull VersionsBetweenAndStep<R,
Number> Table.versionsBetweenScn
(Number scn) Create anSQLDialect.ORACLE
flashback versions query clause from this table.@NotNull VersionsBetweenAndStep<R,
Number> Table.versionsBetweenScn
(Field<? extends Number> scn) Create anSQLDialect.ORACLE
flashback versions query clause from this table.@NotNull VersionsBetweenAndStep<R,
Number> Table.versionsBetweenScnMinvalue()
Create anSQLDialect.ORACLE
flashback versions query clause from this table.@NotNull VersionsBetweenAndStep<R,
Timestamp> Table.versionsBetweenTimestamp
(Timestamp timestamp) Create anSQLDialect.ORACLE
flashback versions query clause from this table.@NotNull VersionsBetweenAndStep<R,
Timestamp> Table.versionsBetweenTimestamp
(Field<Timestamp> timestamp) Create anSQLDialect.ORACLE
flashback versions query clause from this table.@NotNull VersionsBetweenAndStep<R,
Timestamp> Table.versionsBetweenTimestampMinvalue()
Create anSQLDialect.ORACLE
flashback versions query clause from this table.Specify a SQL Server style table hint for query optimisation.Specify a SQL Server style table hint for query optimisation.Specify a SQL Server style table hint for query optimisation.Specify a SQL Server style table hint for query optimisation.@NotNull SelectForJSONCommonDirectivesStep<R>
SelectForJSONCommonDirectivesStep.withoutArrayWrapper()
Add a SQL Server-styleFOR JSON …, WITHOUT_ARRAY_WRAPPER
clause. -
Uses of Pro in org.jooq.impl
Modifier and TypeClassDescriptionclass
A common base class for Oracle ARRAY typesclass
A common base class for Oracle associative array typesfinal class
AuditGenerator<R extends Record,
X extends Table<R>, T> AGenerator
that can be used for audit columns, whose values are defined byConfiguration.auditProvider()
.final class
AParseListener
that allows for functional composition.class
A base class for customStatement
implementations in client code.class
class
Deprecated.- 3.17.0 - [#13542] - This class is no longer needed.class
A default implementation forParseListenerProvider
.class
A default implementation of thePolicyProvider
SPI, offering a way to construct aPolicyProvider
.class
static interface
static interface
TheCALL
statement.static interface
QOM.Collect<T,
A extends ArrayRecord<T>> static interface
TheCONNECT BY ISCYCLE
function.static interface
TheCONNECT BY ISLEAF
function.static interface
TheCONNECT BY ROOT
function.static interface
static interface
TheCREATE FUNCTION
statement.static interface
TheCREATE PROCEDURE
statement.static interface
TheCREATE TRIGGER
statement.static interface
static interface
TheDELETING
function.static enum
TheDeterministic
type.static interface
TheDROP FUNCTION
statement.static interface
TheDROP PROCEDURE
statement.static interface
TheDROP TRIGGER
statement.static interface
TheEXECUTE
function.static interface
static interface
TheGOTO
function.static interface
static interface
TheINSERTING
function.static interface
static interface
static interface
TheLEVEL
function.static interface
QOM.LinkedTable<R extends Record>
A table with a database link.static interface
static enum
TheNullCallClause
type.static interface
QOM.PlusJoin<T>
ThePLUS
operator.static interface
QOM.Prior<T>
ThePRIOR
function.static interface
TheRETURN_
function.static interface
static interface
TheROWNUM
function.static interface
TheSIGNAL SQL STATE
function.static enum
TheSQLDataAccess
type.static interface
TheST AREA
function.static interface
TheST ASBINARY
function.static interface
TheST ASTEXT
function.static interface
TheST CENTROID
function.static interface
QOM.StContains<T extends Spatial>
TheST CONTAINS
function.static interface
TheST CROSSES
function.static interface
QOM.StDifference<T extends Spatial>
TheST DIFFERENCE
function.static interface
QOM.StDisjoint<T extends Spatial>
TheST DISJOINT
function.static interface
QOM.StDistance<T extends Spatial>
TheST DISTANCE
function.static interface
QOM.StEndPoint<T extends Spatial>
TheST ENDPOINT
function.static interface
QOM.StEquals<T extends Spatial>
TheST EQUALS
function.static interface
TheST EXTERIORRING
function.static interface
QOM.StGeometryN<T extends Spatial>
TheST GEOMETRYN
function.static interface
TheST GEOMETRYTYPE
function.static interface
TheST GEOMFROMTEXT
function.static interface
TheST GEOMFROMWKB
function.static interface
TheST INTERIORRINGN
function.static interface
QOM.StIntersection<T extends Spatial>
TheST INTERSECTION
function.static interface
QOM.StIntersects<T extends Spatial>
TheST INTERSECTS
function.static interface
TheST ISCLOSED
function.static interface
TheST ISEMPTY
function.static interface
TheST LENGTH
function.static interface
TheST NUMGEOMETRIES
function.static interface
TheST NUMINTERIORRING
function.static interface
TheST NUMPOINTS
function.static interface
QOM.StOverlaps<T extends Spatial>
TheST OVERLAPS
function.static interface
QOM.StPointN<T extends Spatial>
TheST POINTN
function.static interface
TheST SRID
function.static interface
QOM.StStartPoint<T extends Spatial>
TheST STARTPOINT
function.static interface
QOM.StTouches<T extends Spatial>
TheST TOUCHES
function.static interface
QOM.StUnion<T extends Spatial>
TheST UNION
function.static interface
QOM.StWithin<T extends Spatial>
TheST WITHIN
function.static interface
TheST X
function.static interface
TheST Y
function.static interface
TheST Z
function.static interface
TheSYS CONNECT BY PATH
function.static interface
TheUPDATING
function.static interface
QOM.WithTable<R extends Record>
A table with a T-SQL styleWITH
hint.static interface
TheXMLDOCUMENT
function.Modifier and TypeMethodDescriptionstatic CallArgsStep
TheCALL
statement.static CallArgsStep
TheCALL
statement.static <T,
A extends ArrayRecord<T>>
@NotNull ArrayAggOrderByStep<A>Get thecollect()
aggregate function.static <T,
A extends ArrayRecord<T>>
@NotNull ArrayAggOrderByStep<A>Get thecollect()
aggregate function.static <T,
A extends ArrayRecord<T>>
@NotNull ArrayAggOrderByStep<A>DSL.collectDistinct
(Field<T> field, Class<A> type) Get thecollect()
aggregate function.static <T,
A extends ArrayRecord<T>>
@NotNull ArrayAggOrderByStep<A>DSL.collectDistinct
(Field<T> field, DataType<A> type) Get thecollect()
aggregate function.DSL.connectByIsCycle()
TheCONNECT_BY_ISCYCLE
function.DSL.connectByIsLeaf()
TheCONNECT_BY_ISLEAF
function.static <T> @NotNull Field<T>
DSL.connectByRoot
(Field<T> field) TheCONNECT_BY_ROOT
function.static @NotNull ContinueWhenStep
DSL.continue_()
Create anCONTINUE
statement for use in procedural code.static @NotNull ContinueWhenStep
Create anCONTINUE
statement for use in procedural code.static @NotNull Statement
DSL.continueWhen
(Condition condition) Create anCONTINUE
statement for use in procedural code.static @NotNull Statement
DSL.continueWhen
(Field<Boolean> condition) Create anCONTINUE
statement for use in procedural code.static <T> @NotNull Field<T>
Convert a date time value to a string value using the SQL Server styleCONVERT()
function.static <T> @NotNull Field<T>
Convert a date time value to a string value using the SQL Server styleCONVERT()
function.DefaultDSLContext.createFunction
(String function) DefaultDSLContext.createFunction
(Name function) static CreateFunctionParametersStep
DSL.createFunction
(String function) TheCREATE FUNCTION
statement.static CreateFunctionParametersStep
DSL.createFunction
(Name function) TheCREATE FUNCTION
statement.DefaultDSLContext.createOrReplaceFunction
(String function) DefaultDSLContext.createOrReplaceFunction
(Name function) static CreateFunctionParametersStep
DSL.createOrReplaceFunction
(String function) TheCREATE OR REPLACE FUNCTION
statement.static CreateFunctionParametersStep
DSL.createOrReplaceFunction
(Name function) TheCREATE OR REPLACE FUNCTION
statement.DefaultDSLContext.createOrReplaceProcedure
(String procedure) DefaultDSLContext.createOrReplaceProcedure
(Name procedure) DSL.createOrReplaceProcedure
(String procedure) TheCREATE OR REPLACE PROCEDURE
statement.DSL.createOrReplaceProcedure
(Name procedure) TheCREATE OR REPLACE PROCEDURE
statement.DefaultDSLContext.createOrReplaceTrigger
(String trigger) DefaultDSLContext.createOrReplaceTrigger
(Name trigger) DefaultDSLContext.createOrReplaceTrigger
(Trigger trigger) static CreateTriggerEventStep
DSL.createOrReplaceTrigger
(String trigger) TheCREATE OR REPLACE TRIGGER
statement.static CreateTriggerEventStep
DSL.createOrReplaceTrigger
(Name trigger) TheCREATE OR REPLACE TRIGGER
statement.static CreateTriggerEventStep
DSL.createOrReplaceTrigger
(Trigger trigger) TheCREATE OR REPLACE TRIGGER
statement.DefaultDSLContext.createProcedure
(String procedure) DefaultDSLContext.createProcedure
(Name procedure) DSL.createProcedure
(String procedure) TheCREATE PROCEDURE
statement.DSL.createProcedure
(Name procedure) TheCREATE PROCEDURE
statement.Internal.createQueue
(String name, Schema schema, UDT<R> type) DefaultDSLContext.createTrigger
(String trigger) DefaultDSLContext.createTrigger
(Name trigger) DefaultDSLContext.createTrigger
(Trigger trigger) static CreateTriggerEventStep
DSL.createTrigger
(String trigger) TheCREATE TRIGGER
statement.static CreateTriggerEventStep
DSL.createTrigger
(Name trigger) TheCREATE TRIGGER
statement.static CreateTriggerEventStep
DSL.createTrigger
(Trigger trigger) TheCREATE TRIGGER
statement.static final @NotNull Trigger
Internal.createTrigger
(Schema schema, Table<?> table, List<Field<?>> fields, Name name, Comment comment, TriggerTime time, Set<TriggerEvent> events, TriggerExecution execution, Condition when, int actionOrder, Statement action) Factory method for trigger specifications.static @NotNull Statement
DSL.declare
(Collection<? extends Variable<?>> variables) Create a local variable declaration for use in procedural code.static @NotNull Statement
Create a local variable declaration for use in procedural code.static <T> @NotNull Declaration<T>
Create a local variable declaration for use in procedural code.static final Replacer
Internal.decomposing()
The implementation ofReplacers.decomposing()
.static @NotNull Condition
DSL.deleting()
TheDELETING
function.final Configuration
AbstractConfiguration.derive
(ParseListener... newParseListeners) final Configuration
DefaultConfiguration.derive
(AuditProvider newAuditProvider) final Configuration
DefaultConfiguration.derive
(ParseListenerProvider... newParseListenerProviders) final Configuration
DefaultConfiguration.derive
(PolicyProvider... newPolicyProviders) final Configuration
DefaultConfiguration.derive
(TransformProvider newTransformProvider) final Configuration
AbstractConfiguration.deriveAppending
(ParseListener... newParseListeners) final Configuration
AbstractConfiguration.deriveAppending
(ParseListenerProvider... newParseListenerProviders) DefaultDSLContext.dropFunction
(String function) DefaultDSLContext.dropFunction
(Name function) static DDLQuery
DSL.dropFunction
(String function) TheDROP FUNCTION
statement.static DDLQuery
DSL.dropFunction
(Name function) TheDROP FUNCTION
statement.DefaultDSLContext.dropFunctionIfExists
(String function) DefaultDSLContext.dropFunctionIfExists
(Name function) static DDLQuery
DSL.dropFunctionIfExists
(String function) TheDROP FUNCTION IF EXISTS
statement.static DDLQuery
DSL.dropFunctionIfExists
(Name function) TheDROP FUNCTION IF EXISTS
statement.DefaultDSLContext.dropProcedure
(String procedure) DefaultDSLContext.dropProcedure
(Name procedure) static DDLQuery
DSL.dropProcedure
(String procedure) TheDROP PROCEDURE
statement.static DDLQuery
DSL.dropProcedure
(Name procedure) TheDROP PROCEDURE
statement.DefaultDSLContext.dropProcedureIfExists
(String procedure) DefaultDSLContext.dropProcedureIfExists
(Name procedure) static DDLQuery
DSL.dropProcedureIfExists
(String procedure) TheDROP PROCEDURE IF EXISTS
statement.static DDLQuery
DSL.dropProcedureIfExists
(Name procedure) TheDROP PROCEDURE IF EXISTS
statement.DefaultDSLContext.dropTrigger
(String trigger) DefaultDSLContext.dropTrigger
(Name trigger) DefaultDSLContext.dropTrigger
(Trigger trigger) static DropTriggerOnStep
DSL.dropTrigger
(String trigger) TheDROP TRIGGER
statement.static DropTriggerOnStep
DSL.dropTrigger
(Name trigger) TheDROP TRIGGER
statement.static DropTriggerOnStep
DSL.dropTrigger
(Trigger trigger) TheDROP TRIGGER
statement.DefaultDSLContext.dropTriggerIfExists
(String trigger) DefaultDSLContext.dropTriggerIfExists
(Name trigger) DefaultDSLContext.dropTriggerIfExists
(Trigger trigger) static DropTriggerOnStep
DSL.dropTriggerIfExists
(String trigger) TheDROP TRIGGER IF EXISTS
statement.static DropTriggerOnStep
DSL.dropTriggerIfExists
(Name trigger) TheDROP TRIGGER IF EXISTS
statement.static DropTriggerOnStep
DSL.dropTriggerIfExists
(Trigger trigger) TheDROP TRIGGER IF EXISTS
statement.static @NotNull Statement
TheEXECUTE
function.static @NotNull Statement
TheEXECUTE
function.static @NotNull Statement
Execute a statement dynamically from within procedural code.static @NotNull ExitWhenStep
DSL.exit()
Create anEXIT
statement for use in procedural code.static @NotNull ExitWhenStep
Create anEXIT
statement for use in procedural code.static @NotNull Statement
Create anEXIT
statement for use in procedural code.static @NotNull Statement
Create anEXIT
statement for use in procedural code.static <T> @NotNull ForInStep<T>
Create aFOR
loop for use in procedural code.final Package
AbstractRoutine.getPackage()
static @NotNull Statement
TheGOTO
function.DSL.groupId()
Create aGROUP_ID()
aggregation function to be used along withCUBE
,ROLLUP
, andGROUPING SETS
groupings.DSL.groupingId
(Field<?>... fields) Create a GROUPING_ID(field1, field2, .., fieldn) aggregation field to be used along withCUBE
,ROLLUP
, andGROUPING SETS
groupings.static @NotNull IfThenStep
Create anIF
statement for use in procedural code.static @NotNull Condition
DSL.inserting()
TheINSERTING
function.protected final boolean
AbstractRoutine.isPipelined()
static @NotNull Label
Create a label reference for use in procedural code.static @NotNull Label
Create a label reference for use in procedural code.DSL.level()
TheLEVEL
function.static @NotNull Link
Create a database link reference.static @NotNull Link
Create a database link reference.static @NotNull Link
Create a database link reference.static @NotNull Statement
DSL.loop
(Collection<? extends Statement> statements) Create aLOOP
for use in procedural code.static @NotNull Statement
Create aLOOP
for use in procedural code.static final Replacer
Internal.mappingTable
(Function<? super Table<?>, ? extends Table<?>> replacement) The implementation ofReplacers.mappingTable(Function)
.Create a namedPeriod
reference.static <T> @NotNull Period<T>
Create a namedPeriod
reference.static <T> @NotNull Period<T>
Create a namedPeriod
reference.static <T> @NotNull Field<T>
ThePRIOR
function.static @NotNull RepeatUntilStep
DSL.repeat
(Collection<? extends Statement> statements) Create aREPEAT
loop for use in procedural code.static @NotNull RepeatUntilStep
Create aREPEAT
loop for use in procedural code.static @NotNull Statement
DSL.return_()
TheRETURN_
function.static @NotNull Statement
TheRETURN_
function.static @NotNull Statement
TheRETURN_
function.DSL.rownum()
TheROWNUM
function.final Configuration
AbstractConfiguration.set
(ParseListener... newParseListeners) final Configuration
DefaultConfiguration.set
(ParseListenerProvider... newParseListenerProviders) final Configuration
AbstractConfiguration.setAppending
(ParseListener... newParseListeners) final Configuration
AbstractConfiguration.setAppending
(ParseListenerProvider... newParseListenerProviders) final void
DefaultConfiguration.setAuditProvider
(AuditProvider newAuditProvider) final void
DefaultConfiguration.setParseListener
(ParseListener... newParseListener) final void
DefaultConfiguration.setParseListenerProvider
(ParseListenerProvider... newParseListenerProviders) protected final void
AbstractRoutine.setPipelined
(boolean pipelined) protected final void
AbstractRoutine.setPLSQLBooleanParameter
(Parameter<?> parameter) final void
DefaultConfiguration.setPolicyProvider
(PolicyProvider newPolicyProvider) protected final void
AbstractRoutine.setSyntheticReturnParameter
(Parameter<T> parameter) final void
DefaultConfiguration.setTransformProvider
(TransformProvider newTransformProvider) static SignalSetStep
DSL.signalSQLState
(Object value) TheSIGNAL_SQLSTATE
function.static SignalSetStep
DSL.signalSQLState
(Field<?> value) TheSIGNAL_SQLSTATE
function.TheST_AREA
function.TheST_AREA
function.static @NotNull Field<byte[]>
DSL.stAsBinary
(Field<? extends Spatial> value) TheST_ASBINARY
function.static @NotNull Field<byte[]>
DSL.stAsBinary
(Spatial value) TheST_ASBINARY
function.TheST_ASTEXT
function.TheST_ASTEXT
function.static @NotNull Statement
A custom procedural fragment that can render arbitrary statements.static @NotNull Statement
A custom procedural fragment that can render arbitrary statements.static @NotNull Statement
A custom procedural fragment that can render arbitrary statements.static @NotNull Statement
A custom procedural fragment that can render arbitrary statements.DefaultDSLContext.statements
(Collection<? extends Statement> statements) 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 inBEGIN … END;
, unless explicitly needed.static @NotNull Block
DSL.statements
(Statement... statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;
, unless explicitly needed.DSL.stCentroid
(Field<Geometry> value) TheST_CENTROID
function.DSL.stCentroid
(Geometry value) TheST_CENTROID
function.DSL.stContains
(Field<T> arg1, Field<T> arg2) TheST_CONTAINS
function.DSL.stContains
(Field<T> arg1, T arg2) TheST_CONTAINS
function.DSL.stContains
(T arg1, Field<T> arg2) TheST_CONTAINS
function.DSL.stContains
(T arg1, T arg2) TheST_CONTAINS
function.static @NotNull Condition
TheST_CROSSES
function.static @NotNull Condition
TheST_CROSSES
function.static @NotNull Condition
TheST_CROSSES
function.static @NotNull Condition
TheST_CROSSES
function.DSL.stDifference
(Field<T> arg1, Field<T> arg2) TheST_DIFFERENCE
function.DSL.stDifference
(Field<T> arg1, T arg2) TheST_DIFFERENCE
function.DSL.stDifference
(T arg1, Field<T> arg2) TheST_DIFFERENCE
function.DSL.stDifference
(T arg1, T arg2) TheST_DIFFERENCE
function.DSL.stDisjoint
(Field<T> arg1, Field<T> arg2) TheST_DISJOINT
function.DSL.stDisjoint
(Field<T> arg1, T arg2) TheST_DISJOINT
function.DSL.stDisjoint
(T arg1, Field<T> arg2) TheST_DISJOINT
function.DSL.stDisjoint
(T arg1, T arg2) TheST_DISJOINT
function.DSL.stDistance
(Field<T> arg1, Field<T> arg2) TheST_DISTANCE
function.DSL.stDistance
(Field<T> arg1, T arg2) TheST_DISTANCE
function.DSL.stDistance
(T arg1, Field<T> arg2) TheST_DISTANCE
function.DSL.stDistance
(T arg1, T arg2) TheST_DISTANCE
function.DSL.stEndPoint
(Field<T> value) TheST_ENDPOINT
function.DSL.stEndPoint
(T value) TheST_ENDPOINT
function.TheST_EQUALS
function.TheST_EQUALS
function.TheST_EQUALS
function.DSL.stEquals
(T arg1, T arg2) TheST_EQUALS
function.DSL.stExteriorRing
(Field<Geometry> value) TheST_EXTERIORRING
function.DSL.stExteriorRing
(Geometry value) TheST_EXTERIORRING
function.DSL.stGeometryN
(Field<T> value, int position) TheST_GEOMETRYN
function.DSL.stGeometryN
(Field<T> value, Field<? extends Number> position) TheST_GEOMETRYN
function.DSL.stGeometryN
(T value, int position) TheST_GEOMETRYN
function.DSL.stGeometryN
(T value, Field<? extends Number> position) TheST_GEOMETRYN
function.DSL.stGeometryType
(Field<? extends Spatial> value) TheST_GEOMETRYTYPE
function.DSL.stGeometryType
(Spatial value) TheST_GEOMETRYTYPE
function.DSL.stGeomFromText
(String text) TheST_GEOMFROMTEXT
function.DSL.stGeomFromText
(String text, int srid) TheST_GEOMFROMTEXT
function.DSL.stGeomFromText
(String text, Field<? extends Number> srid) TheST_GEOMFROMTEXT
function.DSL.stGeomFromText
(Field<String> text) TheST_GEOMFROMTEXT
function.DSL.stGeomFromText
(Field<String> text, int srid) TheST_GEOMFROMTEXT
function.DSL.stGeomFromText
(Field<String> text, Field<? extends Number> srid) TheST_GEOMFROMTEXT
function.DSL.stGeomFromWKB
(byte[] wkb) TheST_GEOMFROMWKB
function.DSL.stGeomFromWKB
(byte[] wkb, int srid) TheST_GEOMFROMWKB
function.DSL.stGeomFromWKB
(byte[] wkb, Field<? extends Number> srid) TheST_GEOMFROMWKB
function.DSL.stGeomFromWKB
(Field<byte[]> wkb) TheST_GEOMFROMWKB
function.DSL.stGeomFromWKB
(Field<byte[]> wkb, int srid) TheST_GEOMFROMWKB
function.DSL.stGeomFromWKB
(Field<byte[]> wkb, Field<? extends Number> srid) TheST_GEOMFROMWKB
function.DSL.stInteriorRingN
(Field<Geometry> value, int position) TheST_INTERIORRINGN
function.DSL.stInteriorRingN
(Field<Geometry> value, Field<? extends Number> position) TheST_INTERIORRINGN
function.DSL.stInteriorRingN
(Geometry value, int position) TheST_INTERIORRINGN
function.DSL.stInteriorRingN
(Geometry value, Field<? extends Number> position) TheST_INTERIORRINGN
function.DSL.stIntersection
(Field<T> arg1, Field<T> arg2) TheST_INTERSECTION
function.DSL.stIntersection
(Field<T> arg1, T arg2) TheST_INTERSECTION
function.DSL.stIntersection
(T arg1, Field<T> arg2) TheST_INTERSECTION
function.DSL.stIntersection
(T arg1, T arg2) TheST_INTERSECTION
function.DSL.stIntersects
(Field<T> arg1, Field<T> arg2) TheST_INTERSECTS
function.DSL.stIntersects
(Field<T> arg1, T arg2) TheST_INTERSECTS
function.DSL.stIntersects
(T arg1, Field<T> arg2) TheST_INTERSECTS
function.DSL.stIntersects
(T arg1, T arg2) TheST_INTERSECTS
function.static @NotNull Condition
DSL.stIsClosed
(Field<? extends Spatial> value) TheST_ISCLOSED
function.static @NotNull Condition
DSL.stIsClosed
(Spatial value) TheST_ISCLOSED
function.static @NotNull Condition
TheST_ISEMPTY
function.static @NotNull Condition
TheST_ISEMPTY
function.TheST_LENGTH
function.TheST_LENGTH
function.DSL.stNumGeometries
(Field<? extends Spatial> value) TheST_NUMGEOMETRIES
function.DSL.stNumGeometries
(Spatial value) TheST_NUMGEOMETRIES
function.DSL.stNumInteriorRings
(Field<Geometry> value) TheST_NUMINTERIORRING
function.DSL.stNumInteriorRings
(Geometry value) TheST_NUMINTERIORRING
function.DSL.stNumPoints
(Field<? extends Spatial> value) TheST_NUMPOINTS
function.DSL.stNumPoints
(Spatial value) TheST_NUMPOINTS
function.DSL.stOverlaps
(Field<T> arg1, Field<T> arg2) TheST_OVERLAPS
function.DSL.stOverlaps
(Field<T> arg1, T arg2) TheST_OVERLAPS
function.DSL.stOverlaps
(T arg1, Field<T> arg2) TheST_OVERLAPS
function.DSL.stOverlaps
(T arg1, T arg2) TheST_OVERLAPS
function.TheST_POINTN
function.TheST_POINTN
function.DSL.stPointN
(T value, int position) TheST_POINTN
function.TheST_POINTN
function.TheST_SRID
function.TheST_SRID
function.DSL.stStartPoint
(Field<T> value) TheST_STARTPOINT
function.DSL.stStartPoint
(T value) TheST_STARTPOINT
function.TheST_TOUCHES
function.TheST_TOUCHES
function.TheST_TOUCHES
function.DSL.stTouches
(T arg1, T arg2) TheST_TOUCHES
function.TheST_UNION
function.TheST_UNION
function.TheST_UNION
function.DSL.stUnion
(T arg1, T arg2) TheST_UNION
function.TheST_WITHIN
function.TheST_WITHIN
function.TheST_WITHIN
function.DSL.stWithin
(T arg1, T arg2) TheST_WITHIN
function.TheST_X
function.TheST_X
function.TheST_Y
function.TheST_Y
function.TheST_Z
function.TheST_Z
function.DSL.sysConnectByPath
(Field<?> field, String separator) TheSYS_CONNECT_BY_PATH
function.DSL.systemTime()
Create aSYSTEM_TIME
Period
reference.static <T> @NotNull Period<T>
DSL.systemTime
(Class<T> type) Create aSYSTEM_TIME
Period
reference.static <T> @NotNull Period<T>
DSL.systemTime
(DataType<T> type) Create aSYSTEM_TIME
Period
reference.static @NotNull Table<?>
DSL.table
(ArrayRecord<?> array) A synonym forDSL.unnest(ArrayRecord)
.static final Replacer
Internal.transformPatterns
(Configuration configuration) The implementation ofReplacers.transformPatterns(Configuration)
.static @NotNull Trigger
Create a qualified trigger reference by name.static @NotNull Trigger
Create a qualified trigger reference by name.static @NotNull Table<?>
DSL.unnest
(ArrayRecord<?> array) Create a table from an array of values.static @NotNull Condition
DSL.updating()
TheUPDATING
function.static <T> @NotNull Variable<T>
Create a local variable reference for use in procedural code.static <T> @NotNull Variable<T>
Create a local variable reference for use in procedural code.static <T> @NotNull Variable<T>
A synonym forDSL.var(Name, DataType)
to be used in Scala and Groovy, wherevar
is a reserved keyword.static <T> @NotNull Variable<T>
A synonym forDSL.var(Name, DataType)
to be used in Scala and Groovy, wherevar
is a reserved keyword.static @NotNull LoopStep
Create aWHILE
loop for use in procedural code.DSL.xmldocument
(Field<XML> content) TheXMLDOCUMENT
function. -
Uses of Pro in org.jooq.tools.jdbc
Modifier and TypeMethodDescriptionMockConnection.createARRAY
(String name, Object object) MockConfiguration.derive
(AuditProvider newAuditProvider) MockConfiguration.derive
(ParseListenerProvider... newParseListenerProviders) MockConfiguration.derive
(PolicyProvider... newPolicyProviders) MockConfiguration.derive
(TransformProvider newTransformProvider) MockConfiguration.parseListenerProviders()
MockConfiguration.set
(ParseListenerProvider... newParseListenerProviders) -
Uses of Pro in org.jooq.util.oracle