Uses of Annotation Interface
org.jooq.Pro
Packages that use 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 TypeInterfaceDescriptioninterfaceA "record" that encapsulates an Oracle-style ARRAY (or VARRAY), or an associative array, additionally providing some convenience methods.interfaceArrayRecord<E>A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally providing some convenience methods.interfaceA "record" that encapsulates an Oracle-style associative array, additionally providing some convenience methods.interfaceAn SPI to provide audit fields.enumThe type of the audit info produced by anAuditGenerator.interfaceA step in the construction of theCALLstatement.interfaceA step in the construction of anCONTINUEstatement where aWHENclause can be added.interfaceA step in the construction of theCREATE FUNCTIONstatement.interfaceA step in the construction of theCREATE FUNCTIONstatement.interfaceA step in the construction of theCREATE FUNCTIONstatement.interfaceA step in the construction of theCREATE FUNCTIONstatement.interfaceA step in the construction of theCREATE PROCEDUREstatement.interfaceA step in the construction of theCREATE PROCEDUREstatement.interfaceA step in the construction of theCREATE PROCEDUREstatement.interfaceA step in the construction of theCREATE SYNONYMstatement.interfaceA step in the construction of theCREATE TRIGGERstatement.interfaceA step in the construction of theCREATE TRIGGERstatement.interfaceA step in the construction of theCREATE TRIGGERstatement.interfaceA step in the construction of theCREATE TRIGGERstatement.interfaceA step in the construction of theCREATE TRIGGERstatement.interfaceA step in the construction of theCREATE TRIGGERstatement.interfaceA step in the construction of theCREATE TRIGGERstatement.interfaceA step in the construction of theCREATE TRIGGERstatement.interfaceDeclaration<T>A local variable declaration.interfaceA step in the construction of theDROP TRIGGERstatement.interfaceA step in the construction of anEXITstatement where aWHENclause can be added.interfaceForByStep<T>The step in the creation of aFOR LOOPstatement where theBYclause can be supplied.interfaceForInStep<T>The step in the creation of aFOR LOOPstatement where theINclause can be supplied.interfaceAn intermediate step in building a proceduralIFstatement.interfaceAn intermediate step in building a proceduralIFstatement.interfaceA label for use in procedural code.interfaceA database link reference.interfaceAn intermediate step in building a proceduralLOOPstatement.interfaceA listener that allows for parsing custom SQL.interfaceA provider forParseListenerinstances.interfacePeriod<T>A period specification for usage in temporal tables.interfaceinterfaceinterfaceinterfaceThis type is used for the OraclePIVOTclause DSL API, pivotingTableobjects to new tables.interfacePivotInStep<T>This type is used for the OraclePIVOTclause DSL API, pivotingTableobjects to new tables.interfaceA policy that applies row level security to a table.interfaceA policy provider to provide aPolicyfor a table's row level security.@interfaceAn 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.interfaceAn intermediate step in building a proceduralREPEATstatement.interfaceAn API forQueryPart.$replace(Replacer)query part transformations.final classA set ofReplacerconstructor methods.interfaceSelectConnectByAfterStartWithConditionStep<R extends Record>interfaceSelectConnectByAfterStartWithStep<R extends Record>interfaceSelectConnectByConditionStep<R extends Record>interfaceSelectForJSONCommonDirectivesStep<R extends Record>interfaceSelectForJSONStep<R extends Record>interfaceSelectForXMLCommonDirectivesStep<R extends Record>interfaceSelectForXMLPathDirectivesStep<R extends Record>interfaceSelectForXMLRawDirectivesStep<R extends Record>interfaceSelectForXMLStep<R extends Record>interfaceSelectStartWithStep<R extends Record>interfaceA step in the construction of theSIGNAL SQL STATEfunction.interfaceinterfaceAn SPI to provide SQL transformation configuration and behaviour.interfaceTraverser<A,R> An API forQueryPart.$traverse(Traverser)query part traversals.final classA set ofTraverserconstructor methods.interfaceA meta model of SQLTRIGGERobjects.enumThe event type on which a trigger fires.enumThe execution scope of a trigger.enumThe time when which a trigger fires.interfaceVariable<T>A local variable reference.interfaceVersionsBetweenAndStep<R extends Record,T> This type is used for the OracleVERSIONSclause DSL API, providing access to the flashback versions query clauses.Modifier and TypeMethodDescription@Nullable ConditionSelect.$connectBy()Experimental query object model accessor method, see alsoQOM.Select.$connectBy(Condition newConnectBy) Experimental query object model accessor method, see alsoQOM.booleanSelect.$connectByNoCycle()Experimental query object model accessor method, see alsoQOM.Select.$connectByNoCycle(boolean newConnectByNoCycle) Experimental query object model accessor method, see alsoQOM.@Nullable ConditionSelect.$connectByStartWith()Experimental query object model accessor method, see alsoQOM.Select.$connectByStartWith(Condition newConnectByStartWith) Experimental query object model accessor method, see alsoQOM.default @NotNull QueryPartTraverse aQueryParthierarchy and recursively replace its elements by alternatives.@NotNull QueryPartTraverse aQueryParthierarchy and recursively replace its elements by alternatives.default <R> RQueryPart.$traverse(Supplier<R> supplier, BiFunction<? super R, ? super QueryPart, ? extends R> before) Traverser thisQueryPartexpression tree using a composable<R> RvoidSelectQuery.addConnectBy(Condition condition) Add an Oracle-specificCONNECT BYclause to the query.voidSelectQuery.addConnectByNoCycle(Condition condition) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query.voidSelectQuery.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.voidSelectQuery.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.voidSelectQuery.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.voidSelectQuery.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.ANDoperator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R> Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R> Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R> Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R> Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R> Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByConditionStep<R> Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByConditionStep<R> Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByConditionStep<R> Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByConditionStep<R> Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByConditionStep<R> Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByConditionStep<R> Combine the currently assembled conditions with another one using theOperator.ANDoperator 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.ORACLEflashback query clause from this table.Create anSQLDialect.ORACLEflashback query clause from this table.Table.asOfTimestamp(Timestamp timestamp) Create anSQLDialect.ORACLEflashback query clause from this table.Table.asOfTimestamp(Field<Timestamp> timestamp) Create anSQLDialect.ORACLEflashback 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 AuditProviderConfiguration.auditProvider()Get the configuredAuditProviderfrom this configuration.@NotNull SelectForJSONCommonDirectivesStep<R> SelectForJSONStep.auto()Add a SQL Server-styleFOR JSON AUTOclause.@NotNull SelectForXMLRawDirectivesStep<R> SelectForXMLStep.auto()Add a SQL Server-styleFOR XML AUTOclause.voidExecuteContext.batchQueries(Query... query) Set the jOOQ batchQueryobjects that are being executed, if applicable.@NotNull SelectForXMLCommonDirectivesStep<R> SelectForXMLCommonDirectivesStep.binaryBase64()Add a SQL Server-styleFOR XML …, BINARY BASE64clause.@NotNull CallArgsStepTheCALLstatement.@NotNull CallArgsStepTheCALLstatement.default voidDiagnosticsListener.concatenationInPredicate(DiagnosticsContext ctx) String concatenation was encountered in predicates.@NotNull SelectConnectByAfterStartWithConditionStep<R> Add an Oracle-specificCONNECT BYclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R> Add an Oracle-specificCONNECT BYclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R> Add an Oracle-specificCONNECT BYclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R> Add an Oracle-specificCONNECT BYclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R> Add an Oracle-specificCONNECT BYclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R> Add an Oracle-specificCONNECT BYclause to the query@NotNull SelectConnectByConditionStep<R> Add an Oracle-specificCONNECT BYclause to the query.@NotNull SelectConnectByConditionStep<R> Add an Oracle-specificCONNECT BYclause to the query.@NotNull SelectConnectByConditionStep<R> Add an Oracle-specificCONNECT BYclause to the query.@NotNull SelectConnectByConditionStep<R> Add an Oracle-specificCONNECT BYclause to the query.@NotNull SelectConnectByConditionStep<R> Add an Oracle-specificCONNECT BYclause to the query.@NotNull SelectConnectByConditionStep<R> Add an Oracle-specificCONNECT BYclause to the query.@NotNull SelectConnectByAfterStartWithConditionStep<R> SelectConnectByAfterStartWithStep.connectByNoCycle(String sql) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R> SelectConnectByAfterStartWithStep.connectByNoCycle(String sql, Object... bindings) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R> SelectConnectByAfterStartWithStep.connectByNoCycle(String sql, QueryPart... parts) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R> SelectConnectByAfterStartWithStep.connectByNoCycle(Condition condition) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R> SelectConnectByAfterStartWithStep.connectByNoCycle(Field<Boolean> condition) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R> SelectConnectByAfterStartWithStep.connectByNoCycle(SQL sql) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByConditionStep<R> SelectConnectByStep.connectByNoCycle(String sql) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByConditionStep<R> SelectConnectByStep.connectByNoCycle(String sql, Object... bindings) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByConditionStep<R> SelectConnectByStep.connectByNoCycle(String sql, QueryPart... parts) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByConditionStep<R> SelectConnectByStep.connectByNoCycle(Condition condition) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByConditionStep<R> SelectConnectByStep.connectByNoCycle(Field<Boolean> condition) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByConditionStep<R> SelectConnectByStep.connectByNoCycle(SQL sql) Add an Oracle-specificCONNECT BY NOCYCLEclause to the querydefault voidDiagnosticsListener.consecutiveAggregation(DiagnosticsContext ctx) Similar JDBC statements are repeated consecutively with differing aggregation.@NotNull CreateFunctionParametersStepDSLContext.createFunction(String function) TheCREATE FUNCTIONstatement.@NotNull CreateFunctionParametersStepDSLContext.createFunction(Name function) TheCREATE FUNCTIONstatement.@NotNull CreateFunctionParametersStepDSLContext.createOrReplaceFunction(String function) TheCREATE OR REPLACE FUNCTIONstatement.@NotNull CreateFunctionParametersStepDSLContext.createOrReplaceFunction(Name function) TheCREATE OR REPLACE FUNCTIONstatement.@NotNull CreateProcedureParametersStepDSLContext.createOrReplaceProcedure(String procedure) TheCREATE OR REPLACE PROCEDUREstatement.@NotNull CreateProcedureParametersStepDSLContext.createOrReplaceProcedure(Name procedure) TheCREATE OR REPLACE PROCEDUREstatement.@NotNull CreateSynonymForStepDSLContext.createOrReplacePublicSynonym(String synonym) TheCREATE OR REPLACE PUBLIC SYNONYMstatement.@NotNull CreateSynonymForStepDSLContext.createOrReplacePublicSynonym(Name synonym) TheCREATE OR REPLACE PUBLIC SYNONYMstatement.@NotNull CreateSynonymForStepDSLContext.createOrReplacePublicSynonym(Synonym synonym) TheCREATE OR REPLACE PUBLIC SYNONYMstatement.final booleanDDLExportConfiguration.createOrReplaceSynonym()Whether to generateCREATE OR REPLACE SYNONYMstatements.final DDLExportConfigurationDDLExportConfiguration.createOrReplaceSynonym(boolean newCreateOrReplaceSynonym) Whether to generateCREATE OR REPLACE SYNONYMstatements.@NotNull CreateSynonymForStepDSLContext.createOrReplaceSynonym(String synonym) TheCREATE OR REPLACE SYNONYMstatement.@NotNull CreateSynonymForStepDSLContext.createOrReplaceSynonym(Name synonym) TheCREATE OR REPLACE SYNONYMstatement.@NotNull CreateSynonymForStepDSLContext.createOrReplaceSynonym(Synonym synonym) TheCREATE OR REPLACE SYNONYMstatement.final booleanDDLExportConfiguration.createOrReplaceTrigger()Whether to generateCREATE OR REPLACE TRIGGERstatements.final DDLExportConfigurationDDLExportConfiguration.createOrReplaceTrigger(boolean newCreateOrReplaceTrigger) Whether to generateCREATE OR REPLACE TRIGGERstatements.@NotNull CreateTriggerEventStepDSLContext.createOrReplaceTrigger(String trigger) TheCREATE OR REPLACE TRIGGERstatement.@NotNull CreateTriggerEventStepDSLContext.createOrReplaceTrigger(Name trigger) TheCREATE OR REPLACE TRIGGERstatement.@NotNull CreateTriggerEventStepDSLContext.createOrReplaceTrigger(Trigger trigger) TheCREATE OR REPLACE TRIGGERstatement.@NotNull CreateProcedureParametersStepDSLContext.createProcedure(String procedure) TheCREATE PROCEDUREstatement.@NotNull CreateProcedureParametersStepDSLContext.createProcedure(Name procedure) TheCREATE PROCEDUREstatement.@NotNull CreateSynonymForStepDSLContext.createPublicSynonym(String synonym) TheCREATE PUBLIC SYNONYMstatement.@NotNull CreateSynonymForStepDSLContext.createPublicSynonym(Name synonym) TheCREATE PUBLIC SYNONYMstatement.@NotNull CreateSynonymForStepDSLContext.createPublicSynonym(Synonym synonym) TheCREATE PUBLIC SYNONYMstatement.@NotNull CreateSynonymForStepDSLContext.createSynonym(String synonym) TheCREATE SYNONYMstatement.@NotNull CreateSynonymForStepDSLContext.createSynonym(Name synonym) TheCREATE SYNONYMstatement.@NotNull CreateSynonymForStepDSLContext.createSynonym(Synonym synonym) TheCREATE SYNONYMstatement.@NotNull CreateTriggerEventStepDSLContext.createTrigger(String trigger) TheCREATE TRIGGERstatement.@NotNull CreateTriggerEventStepDSLContext.createTrigger(Name trigger) TheCREATE TRIGGERstatement.@NotNull CreateTriggerEventStepDSLContext.createTrigger(Trigger trigger) TheCREATE TRIGGERstatement.booleanContext.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.booleanQueryPartInternal.declaresParameters()Check whether thisQueryPartis able to declare function or procedure parameters.@NotNull JSONValueDefaultStep<J> Add anNULL ON EMPTYclause.@NotNull ConfigurationConfiguration.derive(AuditProvider newAuditProvider) Create a derived configuration from this one, with a new audit provider.@NotNull ConfigurationConfiguration.derive(ParseListener... newParseListeners) Create a derived configuration from this one, with new parse listeners.@NotNull ConfigurationConfiguration.derive(ParseListenerProvider... newParseListenerProviders) Create a derived configuration from this one, with new parse listener providers.@NotNull ConfigurationConfiguration.derive(PolicyProvider... newPolicyProviders) Create a derived configuration from this one, with a new policy provider.@NotNull ConfigurationConfiguration.derive(TransformProvider newTransformProvider) Create a derived configuration from this one, with a new transform provider.@NotNull ConfigurationConfiguration.deriveAppending(ParseListener... newParseListeners) Create a derived configuration from this one, with appended parse listeners.@NotNull ConfigurationConfiguration.deriveAppending(ParseListenerProvider... newParseListenerProviders) Create a derived configuration from this one, with appended parse listener providers.@NotNull ConfigurationConfiguration.deriveAppending(PolicyProvider... newPolicyProvider) Create a derived configuration from this one, with appended policy providers.@NotNull DDLQueryDSLContext.dropFunction(String function) TheDROP FUNCTIONstatement.@NotNull DDLQueryDSLContext.dropFunction(Name function) TheDROP FUNCTIONstatement.@NotNull DDLQueryDSLContext.dropFunctionIfExists(String function) TheDROP FUNCTION IF EXISTSstatement.@NotNull DDLQueryDSLContext.dropFunctionIfExists(Name function) TheDROP FUNCTION IF EXISTSstatement.@NotNull DDLQueryDSLContext.dropProcedure(String procedure) TheDROP PROCEDUREstatement.@NotNull DDLQueryDSLContext.dropProcedure(Name procedure) TheDROP PROCEDUREstatement.@NotNull DDLQueryDSLContext.dropProcedureIfExists(String procedure) TheDROP PROCEDURE IF EXISTSstatement.@NotNull DDLQueryDSLContext.dropProcedureIfExists(Name procedure) TheDROP PROCEDURE IF EXISTSstatement.@NotNull DDLQueryDSLContext.dropPublicSynonym(String synonym) TheDROP PUBLIC SYNONYMstatement.@NotNull DDLQueryDSLContext.dropPublicSynonym(Name synonym) TheDROP PUBLIC SYNONYMstatement.@NotNull DDLQueryDSLContext.dropPublicSynonym(Synonym synonym) TheDROP PUBLIC SYNONYMstatement.@NotNull DDLQueryDSLContext.dropPublicSynonymIfExists(String synonym) TheDROP PUBLIC SYNONYM IF EXISTSstatement.@NotNull DDLQueryDSLContext.dropPublicSynonymIfExists(Name synonym) TheDROP PUBLIC SYNONYM IF EXISTSstatement.@NotNull DDLQueryDSLContext.dropPublicSynonymIfExists(Synonym synonym) TheDROP PUBLIC SYNONYM IF EXISTSstatement.@NotNull DDLQueryDSLContext.dropSynonym(String synonym) TheDROP SYNONYMstatement.@NotNull DDLQueryDSLContext.dropSynonym(Name synonym) TheDROP SYNONYMstatement.@NotNull DDLQueryDSLContext.dropSynonym(Synonym synonym) TheDROP SYNONYMstatement.@NotNull DDLQueryDSLContext.dropSynonymIfExists(String synonym) TheDROP SYNONYM IF EXISTSstatement.@NotNull DDLQueryDSLContext.dropSynonymIfExists(Name synonym) TheDROP SYNONYM IF EXISTSstatement.@NotNull DDLQueryDSLContext.dropSynonymIfExists(Synonym synonym) TheDROP SYNONYM IF EXISTSstatement.@NotNull DropTriggerOnStepDSLContext.dropTrigger(String trigger) TheDROP TRIGGERstatement.@NotNull DropTriggerOnStepDSLContext.dropTrigger(Name trigger) TheDROP TRIGGERstatement.@NotNull DropTriggerOnStepDSLContext.dropTrigger(Trigger trigger) TheDROP TRIGGERstatement.@NotNull DropTriggerOnStepDSLContext.dropTriggerIfExists(String trigger) TheDROP TRIGGER IF EXISTSstatement.@NotNull DropTriggerOnStepDSLContext.dropTriggerIfExists(Name trigger) TheDROP TRIGGER IF EXISTSstatement.@NotNull DropTriggerOnStepDSLContext.dropTriggerIfExists(Trigger trigger) TheDROP TRIGGER IF EXISTSstatement.@NotNull SelectForXMLCommonDirectivesStep<R> SelectForXMLPathDirectivesStep.elements()Add a SQL Server-styleFOR XML PATH, ELEMENTSclause.@NotNull SelectForXMLCommonDirectivesStep<R> SelectForXMLRawDirectivesStep.elements()Add a SQL Server-styleFOR XML RAW, ELEMENTSclause.@NotNull SelectForXMLCommonDirectivesStep<R> SelectForXMLPathDirectivesStep.elementsAbsent()Add a SQL Server-styleFOR XML PATH, ELEMENTS ABSENTclause.@NotNull SelectForXMLCommonDirectivesStep<R> SelectForXMLRawDirectivesStep.elementsAbsent()Add a SQL Server-styleFOR XML PATH, ELEMENTS ABSENTclause.@NotNull SelectForXMLCommonDirectivesStep<R> SelectForXMLPathDirectivesStep.elementsXsinil()Add a SQL Server-styleFOR XML PATH, ELEMENTS XSINILclause.@NotNull SelectForXMLCommonDirectivesStep<R> SelectForXMLRawDirectivesStep.elementsXsinil()Add a SQL Server-styleFOR XML PATH, ELEMENTS XSINILclause.@NotNull JSONValueOnStep<J> JSONValueOnStep.errorOnEmpty()Add anERROR ON EMPTYclause.@NotNull ConditionJSONExistsOnStep.errorOnError()Add anERROR ON ERRORclause.@NotNull JSONValueOnStep<J> JSONValueOnStep.errorOnError()Add anERROR ON ERRORclause.@NotNull SelectForXMLPathDirectivesStep<R> SelectForXMLStep.explicit()Add a SQL Server-styleFOR XML EXPLICITclause.@NotNull ConditionJSONExistsOnStep.falseOnError()Add anFALSE ON ERRORclause.@NotNull MetaMeta.filterSynonyms(Predicate<? super Synonym> filter) Create a wrapperMetainstance filtering out some synonym.@NotNull MetaMeta.filterTriggers(Predicate<? super Trigger> filter) Create a wrapperMetainstance filtering out some triggers.Table.for_(PeriodSpecification periodSpecification) Create a reference to a temporal table with aPeriodSpecificationfor usage inSelect.@NotNull SelectForJSONStep<Record1<JSON>> SelectForStep.forJSON()Add a SQL Server-styleFOR JSONclause.@NotNull SelectForJSONStep<Record1<JSONB>> SelectForStep.forJSONB()Add a SQL Server-styleFOR JSONclause.Table.forPortionOf(PeriodSpecification periodSpecification) @NotNull SelectForXMLStep<Record1<XML>> SelectForStep.forXML()Add a SQL Server-styleFOR XMLclause.@NotNull SelectOptionalOnStep<R> SelectJoinStep.fullHashJoin(Path<?> table) Convenience method toFULL OUTER JOINa path to the last table added to theFROMclause usingTable.fullOuterHashJoin(Path).@NotNull SelectOnStep<R> SelectJoinStep.fullHashJoin(TableLike<?> table) Convenience method toFULL OUTER JOINa table to the last table added to theFROMclause usingTable.fullOuterHashJoin(TableLike).@NotNull TableOptionalOnStep<Record> Table.fullHashJoin(Path<?> path) FULL OUTER JOINa path to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> Table.fullHashJoin(TableLike<?> table) FULL OUTER JOINa table to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull SelectOptionalOnStep<R> SelectJoinStep.fullLoopJoin(Path<?> table) Convenience method toFULL OUTER JOINa path to the last table added to theFROMclause usingTable.fullOuterLoopJoin(Path).@NotNull SelectOnStep<R> SelectJoinStep.fullLoopJoin(TableLike<?> table) Convenience method toFULL OUTER JOINa table to the last table added to theFROMclause usingTable.fullOuterLoopJoin(TableLike).@NotNull TableOptionalOnStep<Record> Table.fullLoopJoin(Path<?> path) FULL OUTER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TablePartitionByStep<Record> Table.fullLoopJoin(TableLike<?> table) FULL OUTER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull SelectOptionalOnStep<R> SelectJoinStep.fullMergeJoin(Path<?> table) Convenience method toFULL OUTER JOINa path to the last table added to theFROMclause usingTable.fullOuterMergeJoin(Path).@NotNull SelectOnStep<R> SelectJoinStep.fullMergeJoin(TableLike<?> table) Convenience method toFULL OUTER JOINa table to the last table added to theFROMclause usingTable.fullOuterMergeJoin(TableLike).@NotNull TableOptionalOnStep<Record> Table.fullMergeJoin(Path<?> path) FULL OUTER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TablePartitionByStep<Record> Table.fullMergeJoin(TableLike<?> table) FULL OUTER JOINa table to this table with aQOM.JoinHint.MERGEhint.@NotNull SelectOptionalOnStep<R> SelectJoinStep.fullOuterHashJoin(Path<?> table) Convenience method toFULL OUTER JOINa path to the last table added to theFROMclause usingTable.fullOuterHashJoin(Path)@NotNull SelectOnStep<R> SelectJoinStep.fullOuterHashJoin(TableLike<?> table) Convenience method toFULL OUTER JOINa table to the last table added to theFROMclause usingTable.fullOuterHashJoin(TableLike)@NotNull TableOptionalOnStep<Record> Table.fullOuterHashJoin(Path<?> path) FULL OUTER JOINa path to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> Table.fullOuterHashJoin(TableLike<?> table) FULL OUTER JOINa table to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.fullOuterJoin(String sql) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.fullOuterJoin(String sql, Object... bindings) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.fullOuterJoin(String sql, QueryPart... parts) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.fullOuterJoin(Name name) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.fullOuterJoin(SQL sql) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.fullOuterJoin(TableLike<?> table) FULL OUTER JOINa table to this table.@NotNull SelectOptionalOnStep<R> SelectJoinStep.fullOuterLoopJoin(Path<?> table) Convenience method toFULL OUTER JOINa path to the last table added to theFROMclause usingTable.fullOuterLoopJoin(Path)@NotNull SelectOnStep<R> SelectJoinStep.fullOuterLoopJoin(TableLike<?> table) Convenience method toFULL OUTER JOINa table to the last table added to theFROMclause usingTable.fullOuterLoopJoin(TableLike)@NotNull TableOptionalOnStep<Record> Table.fullOuterLoopJoin(Path<?> path) FULL OUTER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TablePartitionByStep<Record> Table.fullOuterLoopJoin(TableLike<?> table) FULL OUTER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull SelectOptionalOnStep<R> SelectJoinStep.fullOuterMergeJoin(Path<?> table) Convenience method toFULL OUTER JOINa path to the last table added to theFROMclause usingTable.fullOuterMergeJoin(Path)@NotNull SelectOnStep<R> SelectJoinStep.fullOuterMergeJoin(TableLike<?> table) Convenience method toFULL OUTER JOINa table to the last table added to theFROMclause usingTable.fullOuterMergeJoin(TableLike)@NotNull TableOptionalOnStep<Record> Table.fullOuterMergeJoin(Path<?> path) FULL OUTER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TablePartitionByStep<Record> Table.fullOuterMergeJoin(TableLike<?> table) FULL OUTER JOINa table to this table with aQOM.JoinHint.MERGEhint.@Nullable PackageRoutine.getPackage()The container package of this stored procedure or function.Meta.getPublicSynonyms()Get all public synonym objects from the underlying meta data source.Meta.getPublicSynonyms(String name) Get all public synonym objects by name from the underlying meta data source.Meta.getPublicSynonyms(Name name) Get all public synonym objects by name from the underlying meta data source.Meta.getSynonyms()Get all synonym objects from the underlying meta data source.Meta.getSynonyms(String name) Get all synonym objects by name from the underlying meta data source.Meta.getSynonyms(Name name) Get all synonym objects by name from the underlying meta data source.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 ofTRIGGERobjects of this table.@NotNull SelectOptionalOnStep<R> Convenience method toINNER JOINa path to the last table added to theFROMclause usingTable.hashJoin(Path).@NotNull SelectOnStep<R> Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.hashJoin(TableLike).@NotNull TableOnStep<Record> INNER JOINa table to this table with aQOM.JoinHint.HASHhint.@NotNull SelectForJSONCommonDirectivesStep<R> SelectForJSONCommonDirectivesStep.includeNullValues()Add a SQL Server-styleFOR JSON …, INCLUDE_NULL_VALUESclause.@NotNull SelectOptionalOnStep<R> SelectJoinStep.innerHashJoin(Path<?> path) Convenience method toINNER JOINa path to the last table added to theFROMclause usingTable.innerHashJoin(Path).@NotNull SelectOnStep<R> SelectJoinStep.innerHashJoin(TableLike<?> table) Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.innerHashJoin(TableLike).@NotNull TableOptionalOnStep<Record> Table.innerHashJoin(Path<?> path) INNER JOINa path to this table with aQOM.JoinHint.HASHhint.@NotNull TableOnStep<Record> Table.innerHashJoin(TableLike<?> table) INNER JOINa table to this table with aQOM.JoinHint.HASHhint.@NotNull SelectOptionalOnStep<R> SelectJoinStep.innerLoopJoin(Path<?> path) Convenience method toINNER JOINa path to the last table added to theFROMclause usingTable.innerLoopJoin(Path).@NotNull SelectOnStep<R> SelectJoinStep.innerLoopJoin(TableLike<?> table) Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.innerLoopJoin(TableLike).@NotNull TableOptionalOnStep<Record> Table.innerLoopJoin(Path<?> path) INNER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TableOnStep<Record> Table.innerLoopJoin(TableLike<?> table) INNER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull SelectOptionalOnStep<R> SelectJoinStep.innerMergeJoin(Path<?> path) Convenience method toINNER JOINa path to the last table added to theFROMclause usingTable.innerMergeJoin(Path).@NotNull SelectOnStep<R> SelectJoinStep.innerMergeJoin(TableLike<?> table) Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.innerMergeJoin(TableLike).@NotNull TableOptionalOnStep<Record> Table.innerMergeJoin(Path<?> path) INNER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TableOnStep<Record> Table.innerMergeJoin(TableLike<?> table) INNER JOINa table to this table with aQOM.JoinHint.MERGEhint.@NotNull SelectFromStep<R> SelectIntoStep.into(Collection<? extends Variable<?>> variables) Add a PL/SQL styleINTOclause to theSELECTstatement to assign the projection of a single rowSELECTstatement to local variables in a procedural context.@NotNull SelectFromStep<R> Add a PL/SQL styleINTOclause to theSELECTstatement to assign the projection of a single rowSELECTstatement 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 aJoinTypeand aQOM.JoinHint.@NotNull AggregateFilterStep<T> AggregateFunction.keepDenseRankFirstOrderBy(Collection<? extends OrderField<?>> fields) Restrict this aggregate function toFIRSTvalues@NotNull AggregateFilterStep<T> AggregateFunction.keepDenseRankFirstOrderBy(OrderField<?>... fields) Restrict this aggregate function toFIRSTvalues@NotNull AggregateFilterStep<T> AggregateFunction.keepDenseRankLastOrderBy(Collection<? extends OrderField<?>> fields) Restrict this aggregate function toLASTvalues@NotNull AggregateFilterStep<T> AggregateFunction.keepDenseRankLastOrderBy(OrderField<?>... fields) Restrict this aggregate function toLASTvalues@NotNull SelectOptionalOnStep<R> SelectJoinStep.leftHashJoin(Path<?> table) Convenience method toLEFT OUTER JOINa path to the last table added to theFROMclause usingTable.leftOuterHashJoin(Path).@NotNull SelectJoinPartitionByStep<R> SelectJoinStep.leftHashJoin(TableLike<?> table) Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterHashJoin(TableLike).@NotNull TableOptionalOnStep<Record> Table.leftHashJoin(Path<?> path) LEFT OUTER JOINa path to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> Table.leftHashJoin(TableLike<?> table) LEFT OUTER JOINa table to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> LEFT OUTER JOINa table to this table.@NotNull SelectOptionalOnStep<R> SelectJoinStep.leftLoopJoin(Path<?> table) Convenience method toLEFT OUTER JOINa path to the last table added to theFROMclause usingTable.leftOuterLoopJoin(Path).@NotNull SelectJoinPartitionByStep<R> SelectJoinStep.leftLoopJoin(TableLike<?> table) Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterLoopJoin(TableLike).@NotNull TableOptionalOnStep<Record> Table.leftLoopJoin(Path<?> path) LEFT OUTER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TablePartitionByStep<Record> Table.leftLoopJoin(TableLike<?> table) LEFT OUTER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull SelectOptionalOnStep<R> SelectJoinStep.leftMergeJoin(Path<?> table) Convenience method toLEFT OUTER JOINa path to the last table added to theFROMclause usingTable.leftOuterMergeJoin(Path).@NotNull SelectJoinPartitionByStep<R> SelectJoinStep.leftMergeJoin(TableLike<?> table) Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterMergeJoin(TableLike).@NotNull TableOptionalOnStep<Record> Table.leftMergeJoin(Path<?> path) LEFT OUTER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TablePartitionByStep<Record> Table.leftMergeJoin(TableLike<?> table) LEFT OUTER JOINa table to this table with aQOM.JoinHint.MERGEhint.@NotNull SelectOptionalOnStep<R> SelectJoinStep.leftOuterHashJoin(Path<?> path) Convenience method toLEFT OUTER JOINa path to the last table added to theFROMclause usingTable.leftOuterHashJoin(Path)@NotNull SelectJoinPartitionByStep<R> SelectJoinStep.leftOuterHashJoin(TableLike<?> table) Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterHashJoin(TableLike)@NotNull TableOptionalOnStep<Record> Table.leftOuterHashJoin(Path<?> path) LEFT OUTER JOINa path to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> Table.leftOuterHashJoin(TableLike<?> table) LEFT OUTER JOINa table to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.leftOuterJoin(String sql) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.leftOuterJoin(String sql, Object... bindings) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.leftOuterJoin(String sql, QueryPart... parts) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.leftOuterJoin(Name name) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.leftOuterJoin(SQL sql) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.leftOuterJoin(TableLike<?> table) LEFT OUTER JOINa table to this table.@NotNull SelectOptionalOnStep<R> SelectJoinStep.leftOuterLoopJoin(Path<?> path) Convenience method toLEFT OUTER JOINa path to the last table added to theFROMclause usingTable.leftOuterLoopJoin(Path)@NotNull SelectJoinPartitionByStep<R> SelectJoinStep.leftOuterLoopJoin(TableLike<?> table) Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterLoopJoin(TableLike)@NotNull TableOptionalOnStep<Record> Table.leftOuterLoopJoin(Path<?> path) LEFT OUTER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TablePartitionByStep<Record> Table.leftOuterLoopJoin(TableLike<?> table) LEFT OUTER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull SelectOptionalOnStep<R> SelectJoinStep.leftOuterMergeJoin(Path<?> path) Convenience method toLEFT OUTER JOINa path to the last table added to theFROMclause usingTable.leftOuterMergeJoin(Path)@NotNull SelectJoinPartitionByStep<R> SelectJoinStep.leftOuterMergeJoin(TableLike<?> table) Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterMergeJoin(TableLike)@NotNull TableOptionalOnStep<Record> Table.leftOuterMergeJoin(Path<?> path) LEFT OUTER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TablePartitionByStep<Record> Table.leftOuterMergeJoin(TableLike<?> table) LEFT OUTER JOINa table to this table with aQOM.JoinHint.MERGEhint.@NotNull SelectOptionalOnStep<R> Convenience method toINNER JOINa path to the last table added to theFROMclause usingTable.loopJoin(Path).@NotNull SelectOnStep<R> Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.loopJoin(TableLike).@NotNull TableOptionalOnStep<Record> INNER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TableOnStep<Record> INNER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull SelectOptionalOnStep<R> Convenience method toINNER JOINa path to the last table added to theFROMclause usingTable.mergeJoin(Path).@NotNull SelectOnStep<R> Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.mergeJoin(TableLike).@NotNull TableOptionalOnStep<Record> INNER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TableOnStep<Record> INNER JOINa table to this table with aQOM.JoinHint.MERGEhint.default voidDiagnosticsListener.nullCondition(DiagnosticsContext ctx) ANULLcondition was encountered, which is almost always a mistake.@NotNull JSONValueOnStep<J> JSONValueOnStep.nullOnEmpty()Add anNULL ON EMPTYclause.@NotNull JSONValueOnStep<J> JSONValueOnStep.nullOnError()Add anNULL ON ERRORclause.@NotNull JSONValueOnStep<J> JSONValueDefaultStep.onEmpty()Add anON EMPTYclause.@NotNull JSONValueOnStep<J> JSONValueDefaultStep.onError()Add anON ERRORclause.@NotNull SelectLimitStep<R> SelectOrderByStep.orderSiblingsBy(int... fieldIndexes) Add anORDER SIBLINGS BYclause to the query@NotNull SelectLimitStep<R> SelectOrderByStep.orderSiblingsBy(Collection<? extends OrderField<?>> fields) Add anORDER SIBLINGS BYclause to the query@NotNull SelectLimitStep<R> SelectOrderByStep.orderSiblingsBy(OrderField<?>... fields) Add anORDER SIBLINGS BYclause to the query@NotNull Query @NotNull []ExecuteContext.originalBatchQueries()The original batchQueryobjects that were available at theExecuteListener.start(ExecuteContext)of thisExecuteContext.@Nullable QueryExecuteContext.originalQuery()The originalQuerythat was available at theExecuteListener.start(ExecuteContext)of thisExecuteContext, ornullif the query is unknown, if it is a batch query, or if there was no jOOQQuery.@NotNull ParseListenerProvider @NotNull []Configuration.parseListenerProviders()Get the configuredParseListenerProviderinstances from this configuration.@NotNull BlockParser.parseStatements(String sql) Parse a SQL string into a proceduralBlockstatement.@NotNull BlockParser.parseStatements(String sql, Object... bindings) Parse a SQL string with bind variables into a proceduralBlockstatement.@NotNull SelectOnStep<R> SelectJoinPartitionByStep.partitionBy(Collection<? extends Field<?>> fields) Add aPARTITION BYclause to the right hand side of theOUTER JOINkeywords@NotNull SelectOnStep<R> SelectJoinPartitionByStep.partitionBy(Field<?>... fields) Add aPARTITION BYclause to the right hand side of theOUTER JOINkeywords@NotNull TableOuterJoinStep<Record> Table.partitionBy(Collection<? extends Field<?>> fields) Add aPARTITION BYclause to the left hand side of theOUTER JOINkeywords@NotNull TableOuterJoinStep<Record> Table.partitionBy(Field<?>... fields) Add aPARTITION BYclause to the left hand side of theOUTER JOINkeywords@NotNull TableOnStep<R> TablePartitionByStep.partitionBy(Collection<? extends Field<?>> fields) Add aPARTITION BYclause to the right hand side of theOUTER JOINkeywords@NotNull TableOnStep<R> TablePartitionByStep.partitionBy(Field<?>... fields) Add aPARTITION BYclause to the right hand side of theOUTER JOINkeywords@NotNull SelectForJSONCommonDirectivesStep<R> SelectForJSONStep.path()Add a SQL Server-styleFOR JSON PATHclause.@NotNull SelectForXMLPathDirectivesStep<R> SelectForXMLStep.path()Add a SQL Server-styleFOR XML PATHclause.@NotNull SelectForXMLPathDirectivesStep<R> Add a SQL Server-styleFOR XML PATHclause.@NotNull PivotForStepTable.pivot(Collection<? extends Field<?>> aggregateFunctions) Create a newTABLEreference from this table, pivoting it into another form.@NotNull PivotForStepCreate a newTABLEreference from this table, pivoting it into another form.@NotNull PivotForStepCreate a newTABLEreference from this table, pivoting it into another form.Field.plus()ThePLUSoperator.@NotNull PolicyProvider @NotNull []Configuration.policyProviders()Get the configuredPolicyProviderinstances from this configuration.default voidDiagnosticsListener.possiblyWrongExpression(DiagnosticsContext ctx) A possibly wrong expression was encountered.voidSet the jOOQQuerythat is being executed, if applicable.@NotNull SelectForXMLRawDirectivesStep<R> SelectForXMLStep.raw()Add a SQL Server-styleFOR XML RAWclause.@NotNull SelectForXMLRawDirectivesStep<R> Add a SQL Server-styleFOR XML RAWclause.final booleanDDLExportConfiguration.respectSynonymOrder()Whether to respect the synonym order produced by theMetasource when generated synonym DDL.final DDLExportConfigurationDDLExportConfiguration.respectSynonymOrder(boolean newRespectSynonymOrder) Whether to respect the synonym order produced by theMetasource when generated synonym DDL.final booleanDDLExportConfiguration.respectTriggerOrder()Whether to respect the trigger order produced by theMetasource when generated trigger DDL.final DDLExportConfigurationDDLExportConfiguration.respectTriggerOrder(boolean newRespectTriggerOrder) Whether to respect the trigger order produced by theMetasource when generated trigger DDL.@NotNull SelectOptionalOnStep<R> SelectJoinStep.rightHashJoin(Path<?> path) Convenience method toRIGHT OUTER JOINa path to the last table added to theFROMclause usingTable.rightOuterHashJoin(Path).@NotNull SelectJoinPartitionByStep<R> SelectJoinStep.rightHashJoin(TableLike<?> table) Convenience method toRIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.rightOuterHashJoin(TableLike).@NotNull TableOptionalOnStep<Record> Table.rightHashJoin(Path<?> path) RIGHT OUTER JOINa path to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> Table.rightHashJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> RIGHT OUTER JOINa table to this table.@NotNull SelectOptionalOnStep<R> SelectJoinStep.rightLoopJoin(Path<?> path) Convenience method toRIGHT OUTER JOINa path to the last table added to theFROMclause usingTable.rightOuterLoopJoin(Path).@NotNull SelectJoinPartitionByStep<R> SelectJoinStep.rightLoopJoin(TableLike<?> table) Convenience method toRIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.rightOuterLoopJoin(TableLike).@NotNull TableOptionalOnStep<Record> Table.rightLoopJoin(Path<?> path) RIGHT OUTER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TablePartitionByStep<Record> Table.rightLoopJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull SelectOptionalOnStep<R> SelectJoinStep.rightMergeJoin(Path<?> path) Convenience method toRIGHT OUTER JOINa path to the last table added to theFROMclause usingTable.rightOuterMergeJoin(Path).@NotNull SelectJoinPartitionByStep<R> SelectJoinStep.rightMergeJoin(TableLike<?> table) Convenience method toRIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.rightOuterMergeJoin(TableLike).@NotNull TableOptionalOnStep<Record> Table.rightMergeJoin(Path<?> path) RIGHT OUTER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TablePartitionByStep<Record> Table.rightMergeJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table with aQOM.JoinHint.MERGEhint.@NotNull SelectOptionalOnStep<R> SelectJoinStep.rightOuterHashJoin(Path<?> path) Convenience method toRIGHT OUTER JOINa path to the last table added to theFROMclause usingTable.rightOuterHashJoin(Path)@NotNull SelectJoinPartitionByStep<R> SelectJoinStep.rightOuterHashJoin(TableLike<?> table) Convenience method toRIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.rightOuterHashJoin(TableLike)@NotNull TableOptionalOnStep<Record> Table.rightOuterHashJoin(Path<?> path) RIGHT OUTER JOINa path to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> Table.rightOuterHashJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.rightOuterJoin(String sql) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.rightOuterJoin(String sql, Object... bindings) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.rightOuterJoin(String sql, QueryPart... parts) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.rightOuterJoin(Name name) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.rightOuterJoin(SQL sql) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.rightOuterJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table.@NotNull SelectOptionalOnStep<R> SelectJoinStep.rightOuterLoopJoin(Path<?> path) Convenience method toRIGHT OUTER JOINa path to the last table added to theFROMclause usingTable.rightOuterLoopJoin(Path)@NotNull SelectJoinPartitionByStep<R> SelectJoinStep.rightOuterLoopJoin(TableLike<?> table) Convenience method toRIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.rightOuterLoopJoin(TableLike)@NotNull TableOptionalOnStep<Record> Table.rightOuterLoopJoin(Path<?> path) RIGHT OUTER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TablePartitionByStep<Record> Table.rightOuterLoopJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull SelectOptionalOnStep<R> SelectJoinStep.rightOuterMergeJoin(Path<?> path) Convenience method toRIGHT OUTER JOINa path to the last table added to theFROMclause usingTable.rightOuterMergeJoin(Path)@NotNull SelectJoinPartitionByStep<R> SelectJoinStep.rightOuterMergeJoin(TableLike<?> table) Convenience method toRIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.rightOuterMergeJoin(TableLike)@NotNull TableOptionalOnStep<Record> Table.rightOuterMergeJoin(Path<?> path) RIGHT OUTER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TablePartitionByStep<Record> Table.rightOuterMergeJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table with aQOM.JoinHint.MERGEhint.@NotNull SelectForJSONCommonDirectivesStep<R> SelectForJSONCommonDirectivesStep.root()Add a SQL Server-styleFOR JSON …, ROOTclause.@NotNull SelectForJSONCommonDirectivesStep<R> Add a SQL Server-styleFOR JSON …, ROOTclause.@NotNull SelectForXMLCommonDirectivesStep<R> SelectForXMLCommonDirectivesStep.root()Add a SQL Server-styleFOR XML …, ROOTclause.@NotNull SelectForXMLCommonDirectivesStep<R> Add a SQL Server-styleFOR XML …, ROOTclause.@NotNull ConfigurationConfiguration.set(AuditProvider newAuditProvider) Change this configuration to hold new audit provider.@NotNull ConfigurationConfiguration.set(ParseListener... newParseListeners) Change this configuration to hold new parse listeners.@NotNull ConfigurationConfiguration.set(ParseListenerProvider... newParseListenerProviders) Change this configuration to hold new parse listener providers.@NotNull ConfigurationConfiguration.set(PolicyProvider... newPolicyProviders) Change this configuration to hold new policy provider.@NotNull ConfigurationConfiguration.set(TransformProvider newTransformProvider) Change this configuration to hold new transform provider.@NotNull ConfigurationConfiguration.setAppending(ParseListener... newParseListeners) Change this configuration by appending new parse listeners.@NotNull ConfigurationConfiguration.setAppending(ParseListenerProvider... newParseListenerProviders) Change this configuration by appending new parse listener providers.voidSelectQuery.setConnectByStartWith(Condition condition) Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.voidSelectQuery.setForJSONAuto(boolean forJSONAuto) Add aFOR JSON AUTOclause to the end of the query.voidSelectQuery.setForJSONB(boolean forJSONB) voidSelectQuery.setForJSONIncludeNullValues(boolean forJSONIncludeNullValues) Add aFOR JSON ROOTclause to the end of the query.voidSelectQuery.setForJSONPath(boolean forJSONPath) Add aFOR JSON PATHclause to the end of the query.voidSelectQuery.setForJSONRoot(boolean forJSONRoot) Add aFOR JSON ROOTclause to the end of the query.voidSelectQuery.setForJSONRoot(boolean forJSONRoot, String rootName) Add aFOR JSON ROOTclause to the end of the query.voidSelectQuery.setForJSONWithoutArrayWrapper(boolean forJSONWithoutArrayWrapper) Add aFOR JSON ROOTclause to the end of the query.voidSelectQuery.setForXMLAuto(boolean forXMLAuto) Add aFOR XML AUTOclause to the end of the query.voidSelectQuery.setForXMLBinaryBase64(boolean forXMLBinaryBase64) Add aFOR XML BINARY BASE64clause to the end of the query.voidSelectQuery.setForXMLElements(boolean forXMLElements) Add aFOR XML ELEMENTSclause to the end of the query.voidSelectQuery.setForXMLElementsAbsent(boolean forXMLElementsAbsent) Add aFOR XML ELEMENTS ABSENTclause to the end of the query.voidSelectQuery.setForXMLElementsXsinil(boolean forXMLElementsXsinil) Add aFOR XML ELEMENTS XSINILclause to the end of the query.voidSelectQuery.setForXMLExplicit(boolean forXMLExplicit) Add aFOR XML EXPLICITclause to the end of the query.voidSelectQuery.setForXMLPath(boolean forXMLPath) Add aFOR XML PATHclause to the end of the query.voidSelectQuery.setForXMLPath(boolean forXMLPath, String elementName) Add aFOR XML PATHclause to the end of the query.voidSelectQuery.setForXMLRaw(boolean forXMLRaw) Add aFOR XML RAWclause to the end of the query.voidSelectQuery.setForXMLRaw(boolean forXMLRaw, String elementName) Add aFOR XML RAWclause to the end of the query.voidSelectQuery.setForXMLRoot(boolean forXMLRoot) Add aFOR XML ROOTclause to the end of the query.voidSelectQuery.setForXMLRoot(boolean forXMLRoot, String rootName) Add aFOR XML ROOTclause to the end of the query.voidSelectQuery.setForXMLType(boolean forXMLType) Add aFOR XML TYPEclause to the end of the query.voidSelectQuery.setInto(Collection<? extends Variable<?>> variables) Add a PL/SQL styleINTOclause to theSELECTstatement to assign the projection of a single rowSELECTstatement to local variables in a procedural context.voidSelectQuery.setOrderBySiblings(boolean orderBySiblings) Indicate whether theSIBLINGSkeyword should be used in anORDER BYclause to form anORDER SIBLINGS BYclause.@NotNull SelectConnectByAfterStartWithStep<R> Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectConnectByAfterStartWithStep<R> Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectConnectByAfterStartWithStep<R> Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectConnectByAfterStartWithStep<R> Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectConnectByAfterStartWithStep<R> Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectConnectByAfterStartWithStep<R> Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectGroupByStep<R> Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectGroupByStep<R> Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectGroupByStep<R> Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectGroupByStep<R> Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectGroupByStep<R> Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectGroupByStep<R> Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull BlockDSLContext.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 BlockDSLContext.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 batchQueryobjects that were available at theExecuteListener.transformEnd(ExecuteContext)event of thisExecuteContext.@Nullable QueryExecuteContext.transformedQuery()The transformedQuerythat was available at theExecuteListener.transformEnd(ExecuteContext)event of thisExecuteContext, ornullif the query is unknown, if it is a batch query, or if there was no jOOQQuery.default voidExecuteListener.transformEnd(ExecuteContext ctx) Called before transforming aQuery.default voidDiagnosticsListener.transformPattern(DiagnosticsContext ctx) ASettings.isTransformPatterns()pattern has been matched.@NotNull TransformProviderConfiguration.transformProvider()Get the configuredTransformProviderfrom this configuration.default voidExecuteListener.transformStart(ExecuteContext ctx) Called before transforming aQuery.default voidDiagnosticsListener.trivialCondition(DiagnosticsContext ctx) A trivial condition was encountered, which can be replaced by aNULLpredicate, or even byDSL.trueCondition()orDSL.falseCondition(), but it is more likely just a typo.@NotNull ConditionJSONExistsOnStep.trueOnError()Add anTRUE ON ERRORclause.@NotNull SelectForXMLCommonDirectivesStep<R> SelectForXMLCommonDirectivesStep.type()Add a SQL Server-styleFOR XML …, ROOTclause.@NotNull ConditionJSONExistsOnStep.unknownOnError()Add anUNKNOWN ON ERRORclause.@NotNull AlterTableFinalStepAlterTableUsingIndexStep.usingIndex(String index) Add theUSING INDEXclause to the statement.@NotNull AlterTableFinalStepAlterTableUsingIndexStep.usingIndex(Index index) Add theUSING INDEXclause to the statement.@NotNull AlterTableFinalStepAlterTableUsingIndexStep.usingIndex(Name index) Add theUSING INDEXclause to the statement.@NotNull VersionsBetweenAndStep<R, Number> Table.versionsBetweenScn(Number scn) Create anSQLDialect.ORACLEflashback versions query clause from this table.@NotNull VersionsBetweenAndStep<R, Number> Table.versionsBetweenScn(Field<? extends Number> scn) Create anSQLDialect.ORACLEflashback versions query clause from this table.@NotNull VersionsBetweenAndStep<R, Number> Table.versionsBetweenScnMinvalue()Create anSQLDialect.ORACLEflashback versions query clause from this table.@NotNull VersionsBetweenAndStep<R, Timestamp> Table.versionsBetweenTimestamp(Timestamp timestamp) Create anSQLDialect.ORACLEflashback versions query clause from this table.@NotNull VersionsBetweenAndStep<R, Timestamp> Table.versionsBetweenTimestamp(Field<Timestamp> timestamp) Create anSQLDialect.ORACLEflashback versions query clause from this table.@NotNull VersionsBetweenAndStep<R, Timestamp> Table.versionsBetweenTimestampMinvalue()Create anSQLDialect.ORACLEflashback 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_WRAPPERclause. -
Uses of Pro in org.jooq.impl
Classes in org.jooq.impl with annotations of type ProModifier and TypeClassDescriptionclassA common base class for Oracle ARRAY typesclassA common base class for Oracle associative array typesfinal classAuditGenerator<R extends Record,X extends Table<R>, T> AGeneratorthat can be used for audit columns, whose values are defined byConfiguration.auditProvider().final classAParseListenerthat allows for functional composition.classA base class for customStatementimplementations in client code.classclassDeprecated.- 3.17.0 - [#13542] - This class is no longer needed.classA default implementation forParseListenerProvider.classA default implementation of thePolicyProviderSPI, offering a way to construct aPolicyProvider.classstatic interfacestatic interfaceTheCALLstatement.static interfaceQOM.Collect<T,A extends ArrayRecord<T>> static interfaceTheCONNECT BY ISCYCLEfunction.static interfaceTheCONNECT BY ISLEAFfunction.static interfaceTheCONNECT BY ROOTfunction.static interfacestatic interfaceTheCREATE FUNCTIONstatement.static interfaceTheCREATE PROCEDUREstatement.static interfaceTheCREATE SYNONYMstatement.static interfaceTheCREATE TRIGGERstatement.static interfacestatic interfaceTheDELETINGfunction.static enumTheDeterministictype.static interfaceTheDROP FUNCTIONstatement.static interfaceTheDROP PROCEDUREstatement.static interfaceTheDROP SYNONYMstatement.static interfaceTheDROP TRIGGERstatement.static interfaceTheEXECUTEfunction.static interfacestatic interfaceTheGOTOfunction.static interfacestatic interfaceTheINSERTINGfunction.static interfacestatic interfacestatic interfaceTheLEVELfunction.static interfaceQOM.LinkedTable<R extends Record>A table with a database link.static interfacestatic enumTheNullCallClausetype.static interfaceQOM.PlusJoin<T>ThePLUSoperator.static interfaceQOM.Prior<T>ThePRIORfunction.static interfaceTheRETURN_function.static interfacestatic interfaceTheROWNUMfunction.static interfaceTheSIGNAL SQL STATEfunction.static enumTheSQLDataAccesstype.static interfaceTheST AREAfunction.static interfaceTheST ASBINARYfunction.static interfaceTheST ASTEXTfunction.static interfaceQOM.StBoundary<T extends Spatial>TheST BOUNDARYfunction.static interfaceTheST CENTROIDfunction.static interfaceQOM.StContains<T extends Spatial>TheST CONTAINSfunction.static interfaceQOM.StCoveredBy<T extends Spatial>TheST COVEREDBYfunction.static interfaceQOM.StCovers<T extends Spatial>TheST COVERSfunction.static interfaceTheST CROSSESfunction.static interfaceQOM.StDifference<T extends Spatial>TheST DIFFERENCEfunction.static interfaceTheST DIMENSIONfunction.static interfaceQOM.StDisjoint<T extends Spatial>TheST DISJOINTfunction.static interfaceQOM.StDistance<T extends Spatial>TheST DISTANCEfunction.static interfaceQOM.StEndPoint<T extends Spatial>TheST ENDPOINTfunction.static interfaceQOM.StEquals<T extends Spatial>TheST EQUALSfunction.static interfaceTheST EXTERIORRINGfunction.static interfaceQOM.StGeometryN<T extends Spatial>TheST GEOMETRYNfunction.static interfaceTheST GEOMETRYTYPEfunction.static interfaceTheST GEOMFROMTEXTfunction.static interfaceTheST GEOMFROMWKBfunction.static interfaceTheST INTERIORRINGNfunction.static interfaceQOM.StIntersection<T extends Spatial>TheST INTERSECTIONfunction.static interfaceQOM.StIntersects<T extends Spatial>TheST INTERSECTSfunction.static interfaceTheST ISCLOSEDfunction.static interfaceTheST ISEMPTYfunction.static interfaceTheST ISRINGfunction.static interfaceTheST ISSIMPLEfunction.static interfaceTheST ISVALIDfunction.static interfaceTheST LENGTHfunction.static interfaceTheST NUMGEOMETRIESfunction.static interfaceTheST NUMINTERIORRINGfunction.static interfaceTheST NUMPOINTSfunction.static interfaceQOM.StOverlaps<T extends Spatial>TheST OVERLAPSfunction.static interfaceQOM.StPerimeter<T extends Spatial>TheST PERIMETERfunction.static interfaceQOM.StPointN<T extends Spatial>TheST POINTNfunction.static interfaceTheST SRIDfunction.static interfaceQOM.StStartPoint<T extends Spatial>TheST STARTPOINTfunction.static interfaceQOM.StTouches<T extends Spatial>TheST TOUCHESfunction.static interfaceQOM.StTransform<T extends Spatial>TheST TRANSFORMfunction.static interfaceQOM.StUnion<T extends Spatial>TheST UNIONfunction.static interfaceQOM.StWithin<T extends Spatial>TheST WITHINfunction.static interfaceTheST Xfunction.static interfaceTheST XMAXfunction.static interfaceTheST XMINfunction.static interfaceTheST Yfunction.static interfaceTheST YMAXfunction.static interfaceTheST YMINfunction.static interfaceTheST Zfunction.static interfaceTheST ZMAXfunction.static interfaceTheST ZMINfunction.static interfaceTheSYS CONNECT BY PATHfunction.static interfaceTheUPDATINGfunction.static interfaceQOM.WithTable<R extends Record>A table with a T-SQL styleWITHhint.static interfaceTheXMLDOCUMENTfunction.Methods in org.jooq.impl with annotations of type ProModifier and TypeMethodDescriptionstatic CallArgsStepTheCALLstatement.static CallArgsStepTheCALLstatement.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_ISCYCLEfunction.DSL.connectByIsLeaf()TheCONNECT_BY_ISLEAFfunction.static <T> @NotNull Field<T> DSL.connectByRoot(Field<T> field) TheCONNECT_BY_ROOTfunction.static @NotNull ContinueWhenStepDSL.continue_()Create anCONTINUEstatement for use in procedural code.static @NotNull ContinueWhenStepCreate anCONTINUEstatement for use in procedural code.static @NotNull StatementDSL.continueWhen(Condition condition) Create anCONTINUEstatement for use in procedural code.static @NotNull StatementDSL.continueWhen(Field<Boolean> condition) Create anCONTINUEstatement 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 CreateFunctionParametersStepDSL.createFunction(String function) TheCREATE FUNCTIONstatement.static CreateFunctionParametersStepDSL.createFunction(Name function) TheCREATE FUNCTIONstatement.DefaultDSLContext.createOrReplaceFunction(String function) DefaultDSLContext.createOrReplaceFunction(Name function) static CreateFunctionParametersStepDSL.createOrReplaceFunction(String function) TheCREATE OR REPLACE FUNCTIONstatement.static CreateFunctionParametersStepDSL.createOrReplaceFunction(Name function) TheCREATE OR REPLACE FUNCTIONstatement.DefaultDSLContext.createOrReplaceProcedure(String procedure) DefaultDSLContext.createOrReplaceProcedure(Name procedure) DSL.createOrReplaceProcedure(String procedure) TheCREATE OR REPLACE PROCEDUREstatement.DSL.createOrReplaceProcedure(Name procedure) TheCREATE OR REPLACE PROCEDUREstatement.DefaultDSLContext.createOrReplacePublicSynonym(String synonym) DefaultDSLContext.createOrReplacePublicSynonym(Name synonym) DefaultDSLContext.createOrReplacePublicSynonym(Synonym synonym) static CreateSynonymForStepDSL.createOrReplacePublicSynonym(String synonym) TheCREATE OR REPLACE PUBLIC SYNONYMstatement.static CreateSynonymForStepDSL.createOrReplacePublicSynonym(Name synonym) TheCREATE OR REPLACE PUBLIC SYNONYMstatement.static CreateSynonymForStepDSL.createOrReplacePublicSynonym(Synonym synonym) TheCREATE OR REPLACE PUBLIC SYNONYMstatement.DefaultDSLContext.createOrReplaceSynonym(String synonym) DefaultDSLContext.createOrReplaceSynonym(Name synonym) DefaultDSLContext.createOrReplaceSynonym(Synonym synonym) static CreateSynonymForStepDSL.createOrReplaceSynonym(String synonym) TheCREATE OR REPLACE SYNONYMstatement.static CreateSynonymForStepDSL.createOrReplaceSynonym(Name synonym) TheCREATE OR REPLACE SYNONYMstatement.static CreateSynonymForStepDSL.createOrReplaceSynonym(Synonym synonym) TheCREATE OR REPLACE SYNONYMstatement.DefaultDSLContext.createOrReplaceTrigger(String trigger) DefaultDSLContext.createOrReplaceTrigger(Name trigger) DefaultDSLContext.createOrReplaceTrigger(Trigger trigger) static CreateTriggerEventStepDSL.createOrReplaceTrigger(String trigger) TheCREATE OR REPLACE TRIGGERstatement.static CreateTriggerEventStepDSL.createOrReplaceTrigger(Name trigger) TheCREATE OR REPLACE TRIGGERstatement.static CreateTriggerEventStepDSL.createOrReplaceTrigger(Trigger trigger) TheCREATE OR REPLACE TRIGGERstatement.DefaultDSLContext.createProcedure(String procedure) DefaultDSLContext.createProcedure(Name procedure) DSL.createProcedure(String procedure) TheCREATE PROCEDUREstatement.DSL.createProcedure(Name procedure) TheCREATE PROCEDUREstatement.DefaultDSLContext.createPublicSynonym(String synonym) DefaultDSLContext.createPublicSynonym(Name synonym) DefaultDSLContext.createPublicSynonym(Synonym synonym) static CreateSynonymForStepDSL.createPublicSynonym(String synonym) TheCREATE PUBLIC SYNONYMstatement.static CreateSynonymForStepDSL.createPublicSynonym(Name synonym) TheCREATE PUBLIC SYNONYMstatement.static CreateSynonymForStepDSL.createPublicSynonym(Synonym synonym) TheCREATE PUBLIC SYNONYMstatement.Internal.createQueue(String name, Schema schema, UDT<R> type) DefaultDSLContext.createSynonym(String synonym) DefaultDSLContext.createSynonym(Name synonym) DefaultDSLContext.createSynonym(Synonym synonym) static CreateSynonymForStepDSL.createSynonym(String synonym) TheCREATE SYNONYMstatement.static CreateSynonymForStepDSL.createSynonym(Name synonym) TheCREATE SYNONYMstatement.static CreateSynonymForStepDSL.createSynonym(Synonym synonym) TheCREATE SYNONYMstatement.static final @NotNull SynonymInternal.createSynonym(Schema schema, Name name, Table<?> table, boolean isPublic, Comment comment) Factory method for synonym specifications.DefaultDSLContext.createTrigger(String trigger) DefaultDSLContext.createTrigger(Name trigger) DefaultDSLContext.createTrigger(Trigger trigger) static CreateTriggerEventStepDSL.createTrigger(String trigger) TheCREATE TRIGGERstatement.static CreateTriggerEventStepDSL.createTrigger(Name trigger) TheCREATE TRIGGERstatement.static CreateTriggerEventStepDSL.createTrigger(Trigger trigger) TheCREATE TRIGGERstatement.static final @NotNull TriggerInternal.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 StatementDSL.declare(Collection<? extends Variable<?>> variables) Create a local variable declaration for use in procedural code.static @NotNull StatementCreate 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 ReplacerInternal.decomposing()The implementation ofReplacers.decomposing().static @NotNull ConditionDSL.deleting()TheDELETINGfunction.final ConfigurationAbstractConfiguration.derive(ParseListener... newParseListeners) final ConfigurationDefaultConfiguration.derive(AuditProvider newAuditProvider) final ConfigurationDefaultConfiguration.derive(ParseListenerProvider... newParseListenerProviders) final ConfigurationDefaultConfiguration.derive(PolicyProvider... newPolicyProviders) final ConfigurationDefaultConfiguration.derive(TransformProvider newTransformProvider) final ConfigurationAbstractConfiguration.deriveAppending(ParseListener... newParseListeners) final ConfigurationAbstractConfiguration.deriveAppending(ParseListenerProvider... newParseListenerProviders) DefaultDSLContext.dropFunction(String function) DefaultDSLContext.dropFunction(Name function) static DDLQueryDSL.dropFunction(String function) TheDROP FUNCTIONstatement.static DDLQueryDSL.dropFunction(Name function) TheDROP FUNCTIONstatement.DefaultDSLContext.dropFunctionIfExists(String function) DefaultDSLContext.dropFunctionIfExists(Name function) static DDLQueryDSL.dropFunctionIfExists(String function) TheDROP FUNCTION IF EXISTSstatement.static DDLQueryDSL.dropFunctionIfExists(Name function) TheDROP FUNCTION IF EXISTSstatement.DefaultDSLContext.dropProcedure(String procedure) DefaultDSLContext.dropProcedure(Name procedure) static DDLQueryDSL.dropProcedure(String procedure) TheDROP PROCEDUREstatement.static DDLQueryDSL.dropProcedure(Name procedure) TheDROP PROCEDUREstatement.DefaultDSLContext.dropProcedureIfExists(String procedure) DefaultDSLContext.dropProcedureIfExists(Name procedure) static DDLQueryDSL.dropProcedureIfExists(String procedure) TheDROP PROCEDURE IF EXISTSstatement.static DDLQueryDSL.dropProcedureIfExists(Name procedure) TheDROP PROCEDURE IF EXISTSstatement.DefaultDSLContext.dropPublicSynonym(String synonym) DefaultDSLContext.dropPublicSynonym(Name synonym) DefaultDSLContext.dropPublicSynonym(Synonym synonym) static DDLQueryDSL.dropPublicSynonym(String synonym) TheDROP PUBLIC SYNONYMstatement.static DDLQueryDSL.dropPublicSynonym(Name synonym) TheDROP PUBLIC SYNONYMstatement.static DDLQueryDSL.dropPublicSynonym(Synonym synonym) TheDROP PUBLIC SYNONYMstatement.DefaultDSLContext.dropPublicSynonymIfExists(String synonym) DefaultDSLContext.dropPublicSynonymIfExists(Name synonym) DefaultDSLContext.dropPublicSynonymIfExists(Synonym synonym) static DDLQueryDSL.dropPublicSynonymIfExists(String synonym) TheDROP PUBLIC SYNONYM IF EXISTSstatement.static DDLQueryDSL.dropPublicSynonymIfExists(Name synonym) TheDROP PUBLIC SYNONYM IF EXISTSstatement.static DDLQueryDSL.dropPublicSynonymIfExists(Synonym synonym) TheDROP PUBLIC SYNONYM IF EXISTSstatement.DefaultDSLContext.dropSynonym(String synonym) DefaultDSLContext.dropSynonym(Name synonym) DefaultDSLContext.dropSynonym(Synonym synonym) static DDLQueryDSL.dropSynonym(String synonym) TheDROP SYNONYMstatement.static DDLQueryDSL.dropSynonym(Name synonym) TheDROP SYNONYMstatement.static DDLQueryDSL.dropSynonym(Synonym synonym) TheDROP SYNONYMstatement.DefaultDSLContext.dropSynonymIfExists(String synonym) DefaultDSLContext.dropSynonymIfExists(Name synonym) DefaultDSLContext.dropSynonymIfExists(Synonym synonym) static DDLQueryDSL.dropSynonymIfExists(String synonym) TheDROP SYNONYM IF EXISTSstatement.static DDLQueryDSL.dropSynonymIfExists(Name synonym) TheDROP SYNONYM IF EXISTSstatement.static DDLQueryDSL.dropSynonymIfExists(Synonym synonym) TheDROP SYNONYM IF EXISTSstatement.DefaultDSLContext.dropTrigger(String trigger) DefaultDSLContext.dropTrigger(Name trigger) DefaultDSLContext.dropTrigger(Trigger trigger) static DropTriggerOnStepDSL.dropTrigger(String trigger) TheDROP TRIGGERstatement.static DropTriggerOnStepDSL.dropTrigger(Name trigger) TheDROP TRIGGERstatement.static DropTriggerOnStepDSL.dropTrigger(Trigger trigger) TheDROP TRIGGERstatement.DefaultDSLContext.dropTriggerIfExists(String trigger) DefaultDSLContext.dropTriggerIfExists(Name trigger) DefaultDSLContext.dropTriggerIfExists(Trigger trigger) static DropTriggerOnStepDSL.dropTriggerIfExists(String trigger) TheDROP TRIGGER IF EXISTSstatement.static DropTriggerOnStepDSL.dropTriggerIfExists(Name trigger) TheDROP TRIGGER IF EXISTSstatement.static DropTriggerOnStepDSL.dropTriggerIfExists(Trigger trigger) TheDROP TRIGGER IF EXISTSstatement.static @NotNull StatementTheEXECUTEfunction.static @NotNull StatementTheEXECUTEfunction.static @NotNull StatementExecute a statement dynamically from within procedural code.static @NotNull ExitWhenStepDSL.exit()Create anEXITstatement for use in procedural code.static @NotNull ExitWhenStepCreate anEXITstatement for use in procedural code.static @NotNull StatementCreate anEXITstatement for use in procedural code.static @NotNull StatementCreate anEXITstatement for use in procedural code.static <T> @NotNull ForInStep<T> Create aFORloop for use in procedural code.final PackageAbstractRoutine.getPackage()static @NotNull StatementTheGOTOfunction.DSL.groupId()Create aGROUP_ID()aggregation function to be used along withCUBE,ROLLUP, andGROUPING SETSgroupings.DSL.groupingId(Field<?>... fields) Create a GROUPING_ID(field1, field2, .., fieldn) aggregation field to be used along withCUBE,ROLLUP, andGROUPING SETSgroupings.static @NotNull IfThenStepCreate anIFstatement for use in procedural code.static @NotNull ConditionDSL.inserting()TheINSERTINGfunction.protected final booleanAbstractRoutine.isPipelined()static @NotNull LabelCreate a label reference for use in procedural code.static @NotNull LabelCreate a label reference for use in procedural code.DSL.level()TheLEVELfunction.static @NotNull LinkCreate a database link reference.static @NotNull LinkCreate a database link reference.static @NotNull LinkCreate a database link reference.static @NotNull StatementDSL.loop(Collection<? extends Statement> statements) Create aLOOPfor use in procedural code.static @NotNull StatementCreate aLOOPfor use in procedural code.static final ReplacerInternal.mappingTable(Function<? super Table<?>, ? extends Table<?>> replacement) The implementation ofReplacers.mappingTable(Function).Create a namedPeriodreference.static <T> @NotNull Period<T> Create a namedPeriodreference.static <T> @NotNull Period<T> Create a namedPeriodreference.static <T> @NotNull Field<T> ThePRIORfunction.static @NotNull RepeatUntilStepDSL.repeat(Collection<? extends Statement> statements) Create aREPEATloop for use in procedural code.static @NotNull RepeatUntilStepCreate aREPEATloop for use in procedural code.static @NotNull StatementDSL.return_()TheRETURN_function.static @NotNull StatementTheRETURN_function.static @NotNull StatementTheRETURN_function.DSL.rownum()TheROWNUMfunction.final ConfigurationAbstractConfiguration.set(ParseListener... newParseListeners) final ConfigurationDefaultConfiguration.set(ParseListenerProvider... newParseListenerProviders) final ConfigurationAbstractConfiguration.setAppending(ParseListener... newParseListeners) final ConfigurationAbstractConfiguration.setAppending(ParseListenerProvider... newParseListenerProviders) final voidDefaultConfiguration.setAuditProvider(AuditProvider newAuditProvider) final voidDefaultConfiguration.setParseListener(ParseListener... newParseListener) final voidDefaultConfiguration.setParseListenerProvider(ParseListenerProvider... newParseListenerProviders) protected final voidAbstractRoutine.setPipelined(boolean pipelined) protected final voidAbstractRoutine.setPLSQLBooleanParameter(Parameter<?> parameter) final voidDefaultConfiguration.setPolicyProvider(PolicyProvider newPolicyProvider) protected final voidAbstractRoutine.setSyntheticReturnParameter(Parameter<T> parameter) final voidDefaultConfiguration.setTransformProvider(TransformProvider newTransformProvider) static SignalSetStepDSL.signalSQLState(Object value) TheSIGNAL_SQLSTATEfunction.static SignalSetStepDSL.signalSQLState(Field<?> value) TheSIGNAL_SQLSTATEfunction.TheST_AREAfunction.TheST_AREAfunction.static @NotNull Field<byte[]> DSL.stAsBinary(Field<? extends Spatial> value) TheST_ASBINARYfunction.static @NotNull Field<byte[]> DSL.stAsBinary(Spatial value) TheST_ASBINARYfunction.TheST_ASTEXTfunction.TheST_ASTEXTfunction.static @NotNull StatementA custom procedural fragment that can render arbitrary statements.static @NotNull StatementA custom procedural fragment that can render arbitrary statements.static @NotNull StatementA custom procedural fragment that can render arbitrary statements.static @NotNull StatementA custom procedural fragment that can render arbitrary statements.DefaultDSLContext.statements(Collection<? extends Statement> statements) DefaultDSLContext.statements(Statement... statements) static @NotNull BlockDSL.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 BlockDSL.statements(Statement... statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;, unless explicitly needed.DSL.stBoundary(Field<? extends Spatial> value) TheST_BOUNDARYfunction.DSL.stBoundary(Spatial value) TheST_BOUNDARYfunction.DSL.stCentroid(Field<Geometry> value) TheST_CENTROIDfunction.DSL.stCentroid(Geometry value) TheST_CENTROIDfunction.DSL.stContains(Field<T> arg1, Field<T> arg2) TheST_CONTAINSfunction.DSL.stContains(Field<T> arg1, T arg2) TheST_CONTAINSfunction.DSL.stContains(T arg1, Field<T> arg2) TheST_CONTAINSfunction.DSL.stContains(T arg1, T arg2) TheST_CONTAINSfunction.DSL.stCoveredBy(Field<T> arg1, Field<T> arg2) TheST_COVEREDBYfunction.DSL.stCoveredBy(Field<T> arg1, T arg2) TheST_COVEREDBYfunction.DSL.stCoveredBy(T arg1, Field<T> arg2) TheST_COVEREDBYfunction.DSL.stCoveredBy(T arg1, T arg2) TheST_COVEREDBYfunction.TheST_COVERSfunction.TheST_COVERSfunction.TheST_COVERSfunction.DSL.stCovers(T arg1, T arg2) TheST_COVERSfunction.static @NotNull ConditionTheST_CROSSESfunction.static @NotNull ConditionTheST_CROSSESfunction.static @NotNull ConditionTheST_CROSSESfunction.static @NotNull ConditionTheST_CROSSESfunction.DSL.stDifference(Field<T> arg1, Field<T> arg2) TheST_DIFFERENCEfunction.DSL.stDifference(Field<T> arg1, T arg2) TheST_DIFFERENCEfunction.DSL.stDifference(T arg1, Field<T> arg2) TheST_DIFFERENCEfunction.DSL.stDifference(T arg1, T arg2) TheST_DIFFERENCEfunction.DSL.stDimension(Field<? extends Spatial> value) TheST_DIMENSIONfunction.DSL.stDimension(Spatial value) TheST_DIMENSIONfunction.DSL.stDisjoint(Field<T> arg1, Field<T> arg2) TheST_DISJOINTfunction.DSL.stDisjoint(Field<T> arg1, T arg2) TheST_DISJOINTfunction.DSL.stDisjoint(T arg1, Field<T> arg2) TheST_DISJOINTfunction.DSL.stDisjoint(T arg1, T arg2) TheST_DISJOINTfunction.DSL.stDistance(Field<T> arg1, Field<T> arg2) TheST_DISTANCEfunction.DSL.stDistance(Field<T> arg1, T arg2) TheST_DISTANCEfunction.DSL.stDistance(T arg1, Field<T> arg2) TheST_DISTANCEfunction.DSL.stDistance(T arg1, T arg2) TheST_DISTANCEfunction.DSL.stEndPoint(Field<T> value) TheST_ENDPOINTfunction.DSL.stEndPoint(T value) TheST_ENDPOINTfunction.TheST_EQUALSfunction.TheST_EQUALSfunction.TheST_EQUALSfunction.DSL.stEquals(T arg1, T arg2) TheST_EQUALSfunction.DSL.stExteriorRing(Field<Geometry> value) TheST_EXTERIORRINGfunction.DSL.stExteriorRing(Geometry value) TheST_EXTERIORRINGfunction.DSL.stGeometryN(Field<T> value, int position) TheST_GEOMETRYNfunction.DSL.stGeometryN(Field<T> value, Field<? extends Number> position) TheST_GEOMETRYNfunction.DSL.stGeometryN(T value, int position) TheST_GEOMETRYNfunction.DSL.stGeometryN(T value, Field<? extends Number> position) TheST_GEOMETRYNfunction.DSL.stGeometryType(Field<? extends Spatial> value) TheST_GEOMETRYTYPEfunction.DSL.stGeometryType(Spatial value) TheST_GEOMETRYTYPEfunction.DSL.stGeomFromText(String text) TheST_GEOMFROMTEXTfunction.DSL.stGeomFromText(String text, int srid) TheST_GEOMFROMTEXTfunction.DSL.stGeomFromText(String text, Field<? extends Number> srid) TheST_GEOMFROMTEXTfunction.DSL.stGeomFromText(Field<String> text) TheST_GEOMFROMTEXTfunction.DSL.stGeomFromText(Field<String> text, int srid) TheST_GEOMFROMTEXTfunction.DSL.stGeomFromText(Field<String> text, Field<? extends Number> srid) TheST_GEOMFROMTEXTfunction.DSL.stGeomFromWKB(byte[] wkb) TheST_GEOMFROMWKBfunction.DSL.stGeomFromWKB(byte[] wkb, int srid) TheST_GEOMFROMWKBfunction.DSL.stGeomFromWKB(byte[] wkb, Field<? extends Number> srid) TheST_GEOMFROMWKBfunction.DSL.stGeomFromWKB(Field<byte[]> wkb) TheST_GEOMFROMWKBfunction.DSL.stGeomFromWKB(Field<byte[]> wkb, int srid) TheST_GEOMFROMWKBfunction.DSL.stGeomFromWKB(Field<byte[]> wkb, Field<? extends Number> srid) TheST_GEOMFROMWKBfunction.DSL.stInteriorRingN(Field<Geometry> value, int position) TheST_INTERIORRINGNfunction.DSL.stInteriorRingN(Field<Geometry> value, Field<? extends Number> position) TheST_INTERIORRINGNfunction.DSL.stInteriorRingN(Geometry value, int position) TheST_INTERIORRINGNfunction.DSL.stInteriorRingN(Geometry value, Field<? extends Number> position) TheST_INTERIORRINGNfunction.DSL.stIntersection(Field<T> arg1, Field<T> arg2) TheST_INTERSECTIONfunction.DSL.stIntersection(Field<T> arg1, T arg2) TheST_INTERSECTIONfunction.DSL.stIntersection(T arg1, Field<T> arg2) TheST_INTERSECTIONfunction.DSL.stIntersection(T arg1, T arg2) TheST_INTERSECTIONfunction.DSL.stIntersects(Field<T> arg1, Field<T> arg2) TheST_INTERSECTSfunction.DSL.stIntersects(Field<T> arg1, T arg2) TheST_INTERSECTSfunction.DSL.stIntersects(T arg1, Field<T> arg2) TheST_INTERSECTSfunction.DSL.stIntersects(T arg1, T arg2) TheST_INTERSECTSfunction.static @NotNull ConditionDSL.stIsClosed(Field<? extends Spatial> value) TheST_ISCLOSEDfunction.static @NotNull ConditionDSL.stIsClosed(Spatial value) TheST_ISCLOSEDfunction.static @NotNull ConditionTheST_ISEMPTYfunction.static @NotNull ConditionTheST_ISEMPTYfunction.static @NotNull ConditionTheST_ISRINGfunction.static @NotNull ConditionTheST_ISRINGfunction.static @NotNull ConditionDSL.stIsSimple(Field<? extends Spatial> value) TheST_ISSIMPLEfunction.static @NotNull ConditionDSL.stIsSimple(Spatial value) TheST_ISSIMPLEfunction.static @NotNull ConditionTheST_ISVALIDfunction.static @NotNull ConditionTheST_ISVALIDfunction.TheST_LENGTHfunction.TheST_LENGTHfunction.DSL.stNumGeometries(Field<? extends Spatial> value) TheST_NUMGEOMETRIESfunction.DSL.stNumGeometries(Spatial value) TheST_NUMGEOMETRIESfunction.DSL.stNumInteriorRings(Field<Geometry> value) TheST_NUMINTERIORRINGfunction.DSL.stNumInteriorRings(Geometry value) TheST_NUMINTERIORRINGfunction.DSL.stNumPoints(Field<? extends Spatial> value) TheST_NUMPOINTSfunction.DSL.stNumPoints(Spatial value) TheST_NUMPOINTSfunction.DSL.stOverlaps(Field<T> arg1, Field<T> arg2) TheST_OVERLAPSfunction.DSL.stOverlaps(Field<T> arg1, T arg2) TheST_OVERLAPSfunction.DSL.stOverlaps(T arg1, Field<T> arg2) TheST_OVERLAPSfunction.DSL.stOverlaps(T arg1, T arg2) TheST_OVERLAPSfunction.DSL.stPerimeter(Field<T> value) TheST_PERIMETERfunction.DSL.stPerimeter(T value) TheST_PERIMETERfunction.TheST_POINTNfunction.TheST_POINTNfunction.DSL.stPointN(T value, int position) TheST_POINTNfunction.TheST_POINTNfunction.TheST_SRIDfunction.TheST_SRIDfunction.DSL.stStartPoint(Field<T> value) TheST_STARTPOINTfunction.DSL.stStartPoint(T value) TheST_STARTPOINTfunction.TheST_TOUCHESfunction.TheST_TOUCHESfunction.TheST_TOUCHESfunction.DSL.stTouches(T arg1, T arg2) TheST_TOUCHESfunction.DSL.stTransform(Field<T> value, int srid) TheST_TRANSFORMfunction.DSL.stTransform(Field<T> value, Field<? extends Number> srid) TheST_TRANSFORMfunction.DSL.stTransform(T value, int srid) TheST_TRANSFORMfunction.DSL.stTransform(T value, Field<? extends Number> srid) TheST_TRANSFORMfunction.TheST_UNIONfunction.TheST_UNIONfunction.TheST_UNIONfunction.DSL.stUnion(T arg1, T arg2) TheST_UNIONfunction.TheST_WITHINfunction.TheST_WITHINfunction.TheST_WITHINfunction.DSL.stWithin(T arg1, T arg2) TheST_WITHINfunction.TheST_Xfunction.TheST_Xfunction.TheST_XMAXfunction.TheST_XMAXfunction.TheST_XMINfunction.TheST_XMINfunction.TheST_Yfunction.TheST_Yfunction.TheST_YMAXfunction.TheST_YMAXfunction.TheST_YMINfunction.TheST_YMINfunction.TheST_Zfunction.TheST_Zfunction.TheST_ZMAXfunction.TheST_ZMAXfunction.TheST_ZMINfunction.TheST_ZMINfunction.static @NotNull SynonymCreate a qualified synonym, given its synonym name.static @NotNull SynonymCreate a qualified type, given its type name.DSL.sysConnectByPath(Field<?> field, String separator) TheSYS_CONNECT_BY_PATHfunction.DSL.systemTime()Create aSYSTEM_TIMEPeriodreference.static <T> @NotNull Period<T> DSL.systemTime(Class<T> type) Create aSYSTEM_TIMEPeriodreference.static <T> @NotNull Period<T> DSL.systemTime(DataType<T> type) Create aSYSTEM_TIMEPeriodreference.static @NotNull Table<?> DSL.table(ArrayRecord<?> array) A synonym forDSL.unnest(ArrayRecord).static final ReplacerInternal.transformPatterns(Configuration configuration) The implementation ofReplacers.transformPatterns(Configuration).static @NotNull TriggerCreate a qualified trigger reference by name.static @NotNull TriggerCreate a qualified trigger reference by name.static @NotNull Table<?> DSL.unnest(ArrayRecord<?> array) Create a table from an array of values.static @NotNull ConditionDSL.updating()TheUPDATINGfunction.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, wherevaris a reserved keyword.static <T> @NotNull Variable<T> A synonym forDSL.var(Name, DataType)to be used in Scala and Groovy, wherevaris a reserved keyword.static @NotNull LoopStepCreate aWHILEloop for use in procedural code.DSL.xmldocument(Field<XML> content) TheXMLDOCUMENTfunction. -
Uses of Pro in org.jooq.tools.jdbc
Methods in org.jooq.tools.jdbc with annotations of type ProModifier 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
Classes in org.jooq.util.oracle with annotations of type Pro