Module org.jooq
Package org.jooq
The
org.jooq
package contains jOOQ's public API.
This package mostly contains interfaces that are implemented by the
org.jooq.impl
package. These interfaces are constructed mostly
through the DSL
and DSLContext
classes, which hide implementation facts from the public API.
-
Interface Summary Interface Description AggregateFilterStep<T> The step in the specification of aggregate functions where the SQL:2003 standardFILTER clause
can be added.AggregateFunction<T> An aggregate function.AlterIndexFinalStep The final step in theALTER INDEX
DSL.AlterIndexOnStep The step in theALTER INDEX
where the table can be specified for the index.AlterIndexStep The step in theALTER INDEX
where the action can be decided.AlterSchemaFinalStep The final step in theDROP SCHEMA
DSL.AlterSchemaStep The step in theALTER SCHEMA
DSL used to specifyALTER
behaviour.AlterSequenceFinalStep AQuery
that can alter sequences.AlterSequenceRestartStep<T extends Number> AQuery
that can alter sequences.AlterSequenceStep<T extends Number> AQuery
that can alter sequences.AlterTableAlterStep<T> The step in theALTER TABLE
DSL used toALTER
columns.AlterTableDropStep The step in theALTER TABLE
DSL used toDROP
columns.AlterTableFinalStep The final step in theALTER TABLE
DSL.AlterTableRenameColumnToStep The step in theALTER TABLE
DSL used toRENAME
columns.AlterTableRenameConstraintToStep The step in theALTER TABLE
DSL used toRENAME
constraints.AlterTableRenameIndexToStep The step in theALTER TABLE
DSL used toRENAME
indexes.AlterTableStep The step in theALTER TABLE
statement where the action can be decided.AlterTableUsingIndexStep The step in theALTER TABLE ..
AlterViewFinalStep The final step in theALTER VIEW
DSL.AlterViewStep The step in theALTER VIEW
where the action can be decided.ArrayAggOrderByStep<T> The SQL standardARRAY_AGG()
function.ArrayRecord<E> A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally providing some convenience methods.Asterisk An unqualified asterisk.Attachable An object in jOOQ that can have an underlyingConfiguration
attached or detached.Batch A wrapper for a JDBC batch operation.BatchBindStep This type is used for theBatch
's DSL API.BetweenAndStep<T> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep1<T1> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep2<T1,T2> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep3<T1,T2,T3> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep4<T1,T2,T3,T4> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep5<T1,T2,T3,T4,T5> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep6<T1,T2,T3,T4,T5,T6> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep8<T1,T2,T3,T4,T5,T6,T7,T8> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9> An intermediate DSL type for the construction of aBETWEEN
predicate.BetweenAndStepN An intermediate DSL type for the construction of aBETWEEN
predicate.BindContext The bind context is used for bindingQueryPart
's and their contained values to aPreparedStatement
's bind variables.Binding<T,U> An SPI (Service Provider Interface) that exposes all low-level interactions with JDBC bind variables.BindingGetResultSetContext<U> A container type forBinding.get(BindingGetResultSetContext)
arguments.BindingGetSQLInputContext<U> A container type forBinding.get(BindingGetSQLInputContext)
arguments.BindingGetStatementContext<U> A container type forBinding.get(BindingGetStatementContext)
arguments.BindingRegisterContext<U> A container type forBinding.register(BindingRegisterContext)
arguments.BindingSetSQLOutputContext<U> A container type forBinding.set(BindingSetSQLOutputContext)
arguments.BindingSetStatementContext<U> A container type forBinding.set(BindingSetStatementContext)
arguments.BindingSQLContext<U> A container type forBinding.sql(BindingSQLContext)
arguments.Block A procedural block.Case The SQL case statement.CaseConditionStep<T> The final step in creating a case statement of the typeCaseValueStep<V> An intermediary step in creating a case statement of the typeCaseWhenStep<V,T> The final step in creating a case statement of the typeCatalog A catalog.CharacterSet A character set.Collation A collation.Comment A comment.CommentOnFinalStep The final step for the creation of aCOMMENT ON [ object type ]
statement.CommentOnIsStep The step in theCOMMENT ON [ object type ]
statement where the comment can be specified.CommonTableExpression<R extends Record> A common table expression.Condition A condition or predicate.ConditionProvider Deprecated. - 2.6.0 [#1881] - This type will be removed from the public API, soon.Configuration AConfiguration
configures aDSLContext
, providing it with information for query rendering and execution.ConnectionCallable<T> An operation that can run code and statements against a provided JDBCConnection
.ConnectionProvider A connection lifecycle handler API.ConnectionRunnable An operation that can run code and statements against a provided JDBCConnection
.Constraint A DDL constraint.ConstraintFinalStep The final step in theConstraint
construction DSL API.ConstraintForeignKeyOnStep The step in theConstraint
construction DSL API that allows for addingON DELETE
andON UPDATE
clauses.ConstraintForeignKeyReferencesStep1<T1> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep2<T1,T2> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep3<T1,T2,T3> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep4<T1,T2,T3,T4> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep5<T1,T2,T3,T4,T5> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep6<T1,T2,T3,T4,T5,T6> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep7<T1,T2,T3,T4,T5,T6,T7> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep8<T1,T2,T3,T4,T5,T6,T7,T8> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9> The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintForeignKeyReferencesStepN The step in theConstraint
construction DSL API that allows for matching aFOREIGN KEY
clause with aREFERENCES
clause.ConstraintTypeStep The step in theConstraint
construction DSL API that allows for specifying the constraint type.Context<C extends Context<C>> A context type that is used for rendering SQL or for binding.ContextTransactionalCallable<T> AnFunctionalInterface
that wraps transactional code.ContextTransactionalRunnable AnFunctionalInterface
that wraps transactional code.ContinueWhenStep A step in the construction of anCONTINUE
statement where aWHEN
clause can be added.Converter<T,U> AConverter
for data types.ConverterProvider Deprecated. - This API is still EXPERIMENTAL.CreateIndexFinalStep AQuery
that can create indexes.CreateIndexIncludeStep AQuery
that can create indexes.CreateIndexStep AQuery
that can create indexes.CreateIndexWhereStep AQuery
that can create indexes.CreateSchemaFinalStep AQuery
that can create schemas.CreateSequenceFinalStep AQuery
that can create sequences.CreateSequenceFlagsStep AQuery
that can create sequences.CreateTableAsStep<R extends Record> AQuery
that can create tables.CreateTableColumnStep AQuery
that can create tables.CreateTableCommentStep AQuery
that can create tables.CreateTableConstraintStep AQuery
that can create tables.CreateTableFinalStep AQuery
that can create tables.CreateTableIndexStep AQuery
that can create tables.CreateTableOnCommitStep AQuery
that can create tables.CreateTableStorageStep AQuery
that can create tables.CreateTableWithDataStep AQuery
that can create tables.CreateTypeFinalStep AQuery
that can create types.CreateTypeStep AQuery
that can create types.CreateViewAsStep<R extends Record> AQuery
that can create views.CreateViewFinalStep AQuery
that can create views.Cursor<R extends Record> Cursors allow for lazy, sequential access to an underlying JDBCResultSet
.DAO<R extends TableRecord<R>,P,T> A generic DAO interface for a pojo and a primary key type.DataType<T> A common interface to all dialect-specific data types.DDLQuery A marker interface for all DDL queries.Declaration<T> A local variable declaration.Delete<R extends Record> ADELETE
statement.DeleteConditionStep<R extends Record> This type is used for theDelete
's DSL API.DeleteFinalStep<R extends Record> This type is used for theDelete
's DSL API.DeleteLimitStep<R extends Record> This type is used for theDelete
's DSL API.DeleteOrderByStep<R extends Record> This type is used for theDelete
's DSL API.DeleteQuery<R extends Record> ADELETE
statement (model API).DeleteResultStep<R extends Record> This type is used for theDelete
's DSL API.DeleteReturningStep<R extends Record> This type is used for theDelete
's DSL API.DeleteWhereStep<R extends Record> This type is used for theDelete
's DSL API.DerivedColumnList A derived column list.DerivedColumnList1 A derived column list.DerivedColumnList10 A derived column list.DerivedColumnList11 A derived column list.DerivedColumnList12 A derived column list.DerivedColumnList13 A derived column list.DerivedColumnList14 A derived column list.DerivedColumnList15 A derived column list.DerivedColumnList16 A derived column list.DerivedColumnList17 A derived column list.DerivedColumnList18 A derived column list.DerivedColumnList19 A derived column list.DerivedColumnList2 A derived column list.DerivedColumnList20 A derived column list.DerivedColumnList21 A derived column list.DerivedColumnList22 A derived column list.DerivedColumnList3 A derived column list.DerivedColumnList4 A derived column list.DerivedColumnList5 A derived column list.DerivedColumnList6 A derived column list.DerivedColumnList7 A derived column list.DerivedColumnList8 A derived column list.DerivedColumnList9 A derived column list.DiagnosticsContext A parameter object that is passed toDiagnosticsListener
methods.DiagnosticsListener A diagnostics listener.DiagnosticsListenerProvider A provider forTransactionListener
instances.DivideByOnConditionStep An intermediate type for the construction of a relational division.DivideByOnStep An intermediate type for the construction of a relational divisionDivideByReturningStep An intermediate type for the construction of a relational divisionDropIndexFinalStep AQuery
that can drop indexes.DropIndexOnStep AQuery
that can drop indexes.DropSchemaFinalStep The final step in theDROP SCHEMA
DSL.DropSchemaStep The step in theDROP SCHEMA
DSL used to specifyDROP
behaviour.DropSequenceFinalStep AQuery
that can drop sequences.DropTableFinalStep The final step in theDROP TABLE
DSL.DropTableStep The step in theDROP TABLE
DSL used to specifyDROP
behaviour.DropTypeFinalStep AQuery
that can drop types.DropTypeStep AQuery
that can drop types.DropViewFinalStep The final step in theDROP VIEW
DSL.DSLContext A contextual DSL providing "attached" implementations to theorg.jooq
interfaces.EmbeddableRecord<R extends EmbeddableRecord<R>> A record originating from a single tableEnumType A SQL enum type.ExecuteContext A context object forQuery
execution passed to registeredExecuteListener
's.ExecuteEventHandler An event handler implementingExecuteListener
events.ExecuteListener ExecuteListenerProvider A provider forExecuteListener
instances.ExecutorProvider TheExecutorProvider
SPI can be used to provide jOOQ with custom asynchronous execution behaviour.ExitWhenStep A step in the construction of anEXIT
statement where aWHEN
clause can be added.Explain Results of anDSLContext.explain(Query)
call.False ACondition
that always yieldsfalse
.Field<T> A column expression.FieldLike An object that can behave like a field (a field-like object).FieldOrConstraint A common base type forField
andConstraint
where DSL API accepts both types alike.FieldOrRow ForByStep<T> The step in the creation of aFOR LOOP
statement where theBY
clause can be supplied.ForeignKey<R extends Record,O extends Record> AForeignKey
is an object referencing aUniqueKey
.ForInStep<T> The step in the creation of aFOR LOOP
statement where theIN
clause can be supplied.Formattable A type that can format its contents.FutureResult<R extends Record> Deprecated. - 3.2.0 - [#2581] - This type will be removed in jOOQ 4.0GrantFinalStep The final step in the creation of aREVOKE
statement.GrantOnStep The step in the creation of aGRANT
statement where theON
clause can be added.GrantToStep The step in the creation of aGRANT
statement where theTO
clause can be added.GrantWithGrantOptionStep The step of creationGRANT
statement that assign user or role a grant option.GroupConcatOrderByStep MySQL'sGROUP_CONCAT
function.GroupConcatSeparatorStep MySQL'sGROUP_CONCAT
function.GroupField An expression to be used exclusively inGROUP BY
clauses.Identity<R extends Record,T> AnIdentity
is an object representing anIDENTITY
column as understood by the SQL:2003 standard.IfElseStep An intermediate step in building a proceduralIF
statement.IfThenStep An intermediate step in building a proceduralIF
statement.Index A DDL index definition.Insert<R extends Record> AnINSERT
statement.InsertFinalStep<R extends Record> This type is used for theInsert
's DSL API.InsertOnConflictConditionStep<R extends Record> This type is used for theInsert
's DSL API.InsertOnConflictDoUpdateStep<R extends Record> This type is used for theInsert
's DSL API.InsertOnConflictWhereStep<R extends Record> This type is used for theInsert
's DSL API.InsertOnDuplicateSetMoreStep<R extends Record> This type is used for theInsert
's DSL API.InsertOnDuplicateSetStep<R extends Record> This type is used for theInsert
's DSL API.InsertOnDuplicateStep<R extends Record> This type is used for theInsert
's DSL API.InsertQuery<R extends Record> AnINSERT
statement (model API).InsertResultStep<R extends Record> This type is used for theInsert
's DSL API.InsertReturningStep<R extends Record> This type is used for theInsert
's DSL API.InsertSetMoreStep<R extends Record> This type is used for theInsert
's alternative DSL API.InsertSetStep<R extends Record> This type is used for theInsert
's alternative DSL API.InsertValuesStep1<R extends Record,T1> This type is used for theInsert
's DSL API.InsertValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> This type is used for theInsert
's DSL API.InsertValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> This type is used for theInsert
's DSL API.InsertValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> This type is used for theInsert
's DSL API.InsertValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> This type is used for theInsert
's DSL API.InsertValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> This type is used for theInsert
's DSL API.InsertValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> This type is used for theInsert
's DSL API.InsertValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> This type is used for theInsert
's DSL API.InsertValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> This type is used for theInsert
's DSL API.InsertValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> This type is used for theInsert
's DSL API.InsertValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> This type is used for theInsert
's DSL API.InsertValuesStep2<R extends Record,T1,T2> This type is used for theInsert
's DSL API.InsertValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> This type is used for theInsert
's DSL API.InsertValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> This type is used for theInsert
's DSL API.InsertValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> This type is used for theInsert
's DSL API.InsertValuesStep3<R extends Record,T1,T2,T3> This type is used for theInsert
's DSL API.InsertValuesStep4<R extends Record,T1,T2,T3,T4> This type is used for theInsert
's DSL API.InsertValuesStep5<R extends Record,T1,T2,T3,T4,T5> This type is used for theInsert
's DSL API.InsertValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6> This type is used for theInsert
's DSL API.InsertValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> This type is used for theInsert
's DSL API.InsertValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> This type is used for theInsert
's DSL API.InsertValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> This type is used for theInsert
's DSL API.InsertValuesStepN<R extends Record> This type is used for theInsert
's DSL API.JSONEntry<T> A JSON entry for JSON objects.Key<R extends Record> AKey
is an object representing aUNIQUE KEY
, aPRIMARY KEY
, or aFOREIGN KEY
.Keyword A SQL keyword.Label A label for use in procedural code.LikeEscapeStep A step in the creation of aLIKE
predicate to which anESCAPE
clause can be appended.Link A database link reference.Loader<R extends Record> TheLoader
API is used for configuring data loads.LoaderContext A context object that provides information about a loader's current state toLoaderRowListener
.LoaderCSVOptionsStep<R extends Record> TheLoader
API is used for configuring data loads.LoaderCSVStep<R extends Record> TheLoader
API is used for configuring data loads.LoaderError An error that occurred during loading.LoaderFieldMapper LoaderFieldMapper.LoaderFieldContext The argument object forLoaderFieldMapper.map(LoaderFieldContext)
.LoaderJSONOptionsStep<R extends Record> TheLoader
API is used for configuring data loads.LoaderJSONStep<R extends Record> TheLoader
API is used for configuring data loads.LoaderListenerStep<R extends Record> TheLoader
API is used for configuring data loads.LoaderLoadStep<R extends Record> TheLoader
API is used for configuring data loads.LoaderOptionsStep<R extends Record> TheLoader
API is used for configuring data loads.LoaderRowListener A listener forLoader
progress.LoaderRowsStep<R extends Record> TheLoader
API is used for configuring data loads.LoaderSourceStep<R extends Record> TheLoader
API is used for configuring data loads.LoaderXMLStep<R extends Record> TheLoader
API is used for configuring data loads.Log A common logger abstraction API for jOOQ's internal logging.LoopStep An intermediate step in building a proceduralLOOP
statement.Merge<R extends Record> AMERGE
statement.MergeFinalStep<R extends Record> This type is used for theMerge
's DSL API.MergeKeyStep1<R extends Record,T1> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep2<R extends Record,T1,T2> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep3<R extends Record,T1,T2,T3> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep4<R extends Record,T1,T2,T3,T4> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep5<R extends Record,T1,T2,T3,T4,T5> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep6<R extends Record,T1,T2,T3,T4,T5,T6> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> This type is used for the H2-specific variant of theMerge
's DSL API.MergeKeyStepN<R extends Record> This type is used for the H2-specific variant of theMerge
's DSL API.MergeMatchedDeleteStep<R extends Record> This type is used for theMerge
's DSL API.MergeMatchedSetMoreStep<R extends Record> This type is used for theMerge
's DSL API.MergeMatchedSetStep<R extends Record> This type is used for theMerge
's DSL API.MergeMatchedStep<R extends Record> This type is used for theMerge
's DSL API.MergeMatchedWhereStep<R extends Record> This type is used for theMerge
's DSL API.MergeNotMatchedSetMoreStep<R extends Record> This type is used for theMerge
's DSL API.MergeNotMatchedSetStep<R extends Record> This type is used for theMerge
's DSL API.MergeNotMatchedStep<R extends Record> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep1<R extends Record,T1> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep2<R extends Record,T1,T2> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep3<R extends Record,T1,T2,T3> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep4<R extends Record,T1,T2,T3,T4> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep5<R extends Record,T1,T2,T3,T4,T5> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> This type is used for theMerge
's DSL API.MergeNotMatchedValuesStepN<R extends Record> This type is used for theMerge
's DSL API.MergeNotMatchedWhereStep<R extends Record> This type is used for theMerge
's DSL API.MergeOnConditionStep<R extends Record> This type is used for theMerge
's DSL API.MergeOnStep<R extends Record> This type is used for theMerge
's DSL API.MergeUsingStep<R extends Record> This type is used for theMerge
's DSL API.MergeValuesStep1<R extends Record,T1> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep2<R extends Record,T1,T2> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep3<R extends Record,T1,T2,T3> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep4<R extends Record,T1,T2,T3,T4> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep5<R extends Record,T1,T2,T3,T4,T5> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> This type is used for the H2-specific variant of theMerge
's DSL API.MergeValuesStepN<R extends Record> This type is used for the H2-specific variant of theMerge
's DSL API.Meta A wrapping object forDatabaseMetaData
or for other sources of database meta information (e.g.MetaProvider An SPI that can produce dynamic catalog, schema, table meta data information.Name An identifier.Named A common base type for all qualifiable, named objects.OrderedAggregateFunction<T> An ordered-set aggregate function.OrderedAggregateFunctionOfDeferredType An ordered-set aggregate function.OrderField<T> AQueryPart
to be used exclusively inORDER BY
clauses.Package A container for stored procedures and functionsParam<T> A named parameter and/or bind value.Parameter<T> A parameter to a stored procedure or function.Parser This is experimental functionality.PivotForStep This type is used for the OraclePIVOT
clause DSL API, pivotingTable
objects to new tables.PivotInStep<T> This type is used for the OraclePIVOT
clause DSL API, pivotingTable
objects to new tables.Privilege A privilege for use inGRANT
andREVOKE
statements.QualifiedAsterisk A qualified asterisk.QuantifiedSelect<R extends Record> A quantified select for use in quantified comparison predicates.Queries A wrapper for a collection of queries.Query Any query.QueryPart The common base type for all objects that can be used for query composition.QueryPartInternal Base functionality declaration for all query objectsRecord A database result record.Record1<T1> A model type for a records with degree1
Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> A model type for a records with degree10
Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> A model type for a records with degree11
Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> A model type for a records with degree12
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> A model type for a records with degree13
Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> A model type for a records with degree14
Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> A model type for a records with degree15
Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> A model type for a records with degree16
Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> A model type for a records with degree17
Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> A model type for a records with degree18
Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> A model type for a records with degree19
Record2<T1,T2> A model type for a records with degree2
Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> A model type for a records with degree20
Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> A model type for a records with degree21
Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> A model type for a records with degree22
Record3<T1,T2,T3> A model type for a records with degree3
Record4<T1,T2,T3,T4> A model type for a records with degree4
Record5<T1,T2,T3,T4,T5> A model type for a records with degree5
Record6<T1,T2,T3,T4,T5,T6> A model type for a records with degree6
Record7<T1,T2,T3,T4,T5,T6,T7> A model type for a records with degree7
Record8<T1,T2,T3,T4,T5,T6,T7,T8> A model type for a records with degree8
Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> A model type for a records with degree9
RecordContext A context object forRecord
manipulation passed to registeredRecordListener
's.RecordHandler<R extends Record> ARecordHandler
is a handler that can receiveRecord
objects, when fetching data from the database.RecordListener A listener for manipulation events onUpdatableRecord
s.RecordListenerProvider A provider forRecordListener
instances.RecordMapper<R extends Record,E> ARecordMapper
is a mapper that can receiveRecord
objects, when fetching data from the database, transforming them into a custom type<E>
.RecordMapperProvider A provider forRecordMapper
instances.RecordType<R extends Record> RecordUnmapper<E,R extends Record> ARecordUnmapper
is a mapper that can receive user objects and convert them back toRecord
.RecordUnmapperProvider A provider forRecordUnmapper
instances.RenderContext The render context is used for renderingQueryPart
's to SQL.RepeatUntilStep An intermediate step in building a proceduralREPEAT
statement.ResourceManagingScope A scope that can manage resources.Result<R extends Record> A wrapper for database results returned bySelectQuery
ResultOrRows A type that contains either aResult
, an update count, or an exception.ResultQuery<R extends Record> A query that can return results.Results A list ofResult
and update counts that can be returned byResultQuery.fetchMany()
calls and other calls that produce multiple cursors and update counts.RevokeFinalStep The final step in the creation of aREVOKE
statement.RevokeFromStep The step in the creation of aREVOKE
statement where theFROM
clause can be added.RevokeOnStep The step in the creation of aREVOKE
statement where theON
clause can be added.Role A privilege for use inGRANT
andREVOKE
statements.Routine<T> A routine is a callable object in your RDBMS.Row A row value expression.Row1<T1> A row value expression.Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> A row value expression.Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> A row value expression.Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> A row value expression.Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> A row value expression.Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> A row value expression.Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> A row value expression.Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> A row value expression.Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> A row value expression.Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> A row value expression.Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> A row value expression.Row2<T1,T2> A row value expression.Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> A row value expression.Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> A row value expression.Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> A row value expression.Row3<T1,T2,T3> A row value expression.Row4<T1,T2,T3,T4> A row value expression.Row5<T1,T2,T3,T4,T5> A row value expression.Row6<T1,T2,T3,T4,T5,T6> A row value expression.Row7<T1,T2,T3,T4,T5,T6,T7> A row value expression.Row8<T1,T2,T3,T4,T5,T6,T7,T8> A row value expression.Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> A row value expression.RowCountQuery Any query that is not aResultQuery
, and thus possibly produces a row count as a result, instead of aResult
.RowId A data type corresponding to JDBC'sTypes.ROWID
.RowN A row value expression.Schema A schema.Scope Scope implementations provide access to a variety of objects that are available from a given scope.Select<R extends Record> ASELECT
statement.SelectConditionStep<R extends Record> SelectConnectByAfterStartWithConditionStep<R extends Record> SelectConnectByAfterStartWithStep<R extends Record> SelectConnectByConditionStep<R extends Record> SelectConnectByStep<R extends Record> SelectDistinctOnStep<R extends Record> SelectField<T> AQueryPart
to be used exclusively inSELECT
clauses.SelectFieldOrAsterisk AQueryPart
to be used exclusively inSELECT
clauses.SelectFinalStep<R extends Record> SelectForUpdateOfStep<R extends Record> SelectForUpdateStep<R extends Record> SelectForUpdateWaitStep<R extends Record> SelectFromStep<R extends Record> SelectGroupByStep<R extends Record> SelectHavingConditionStep<R extends Record> SelectHavingStep<R extends Record> SelectIntoStep<R extends Record> SelectJoinPartitionByStep<R extends Record> SelectJoinStep<R extends Record> SelectLimitAfterOffsetStep<R extends Record> SelectLimitPercentAfterOffsetStep<R extends Record> SelectLimitPercentStep<R extends Record> SelectLimitStep<R extends Record> SelectOffsetStep<R extends Record> SelectOnConditionStep<R extends Record> SelectOnStep<R extends Record> SelectOptionalOnStep<R extends Record> SelectOptionStep<R extends Record> SelectOrderByStep<R extends Record> SelectQualifyConditionStep<R extends Record> SelectQualifyStep<R extends Record> SelectQuery<R extends Record> ASELECT
statement (model API).SelectSeekLimitStep<R extends Record> SelectSeekStep1<R extends Record,T1> SelectSeekStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> SelectSeekStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> SelectSeekStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> SelectSeekStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> SelectSeekStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> SelectSeekStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> SelectSeekStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> SelectSeekStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> SelectSeekStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> SelectSeekStep2<R extends Record,T1,T2> SelectSeekStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> SelectSeekStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> SelectSeekStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> SelectSeekStep3<R extends Record,T1,T2,T3> SelectSeekStep4<R extends Record,T1,T2,T3,T4> SelectSeekStep5<R extends Record,T1,T2,T3,T4,T5> SelectSeekStep6<R extends Record,T1,T2,T3,T4,T5,T6> SelectSeekStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> SelectSeekStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> SelectSeekStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> SelectSeekStepN<R extends Record> SelectSelectStep<R extends Record> SelectStartWithStep<R extends Record> SelectUnionStep<R extends Record> SelectWhereStep<R extends Record> SelectWindowStep<R extends Record> SelectWithTiesAfterOffsetStep<R extends Record> SelectWithTiesStep<R extends Record> Sequence<T extends Number> A sequence.SortField<T> A sort specification.SQL A plain SQLQueryPart
.Statement A statement that can be placed inside of aBlock
, but not executed on its own.StoreQuery<R extends Record> A query storing objects to the database.Table<R extends Record> A table.TableField<R extends Record,T> A field contained in a table.TableLike<R extends Record> An object that can behave like a table (a table-like object).TableOnConditionStep<R extends Record> An intermediate (optional) type for the construction of aJOIN
clause, where the join criteria is added using anON
clause (with aCondition
.TableOnStep<R extends Record> TableOptionalOnStep<R extends Record> TableOuterJoinStep<R extends Record> An intermediate type for the construction of a partitionedSQLDialect.ORACLE
OUTER JOIN
clause.TablePartitionByStep<R extends Record> An intermediate type for the construction of a partitionedSQLDialect.ORACLE
OUTER JOIN
clause.TableRecord<R extends TableRecord<R>> A record originating from a single tableTransaction A custom transaction object.TransactionalCallable<T> AnFunctionalInterface
that wraps transactional code.TransactionalRunnable AnFunctionalInterface
that wraps transactional code.TransactionContext A context object that is used to pass arguments to the various methods ofTransactionProvider
.TransactionListener TheTransactionListener
SPI is used to intercept theTransactionProvider
's transaction events.TransactionListenerProvider A provider forTransactionListener
instances.TransactionProvider TheTransactionProvider
SPI can be used to implement customtransaction
behaviour that is applied when callingDSLContext.transactionResult(TransactionalCallable)
orDSLContext.transaction(TransactionalRunnable)
.True ACondition
that always yieldstrue
.Truncate<R extends Record> ATRUNCATE
statement.TruncateCascadeStep<R extends Record> AQuery
that can truncate a table in the database.TruncateFinalStep<R extends Record> AQuery
that can truncate a table in the database.TruncateIdentityStep<R extends Record> AQuery
that can truncate a table in the database.UDT<R extends UDTRecord<R>> UDT definition.UDTField<R extends UDTRecord<R>,T> A field contained in a UDT.UDTRecord<R extends UDTRecord<R>> An object holding data of a UDTUniqueKey<R extends Record> AUniqueKey
is an object representing aUNIQUE KEY
or aPRIMARY KEY
.Unwrapper An unwrapper SPI that can be used to override the default unwrapping algorithm.UnwrapperProvider A provider for theUnwrapper
SPI which is used to override the default behaviour when unwrapping JDBC types throughWrapper.unwrap(Class)
.UpdatableRecord<R extends UpdatableRecord<R>> A common interface for records that can be stored back to the database again.Update<R extends Record> AnUPDATE
statement.UpdateConditionStep<R extends Record> This type is used for theUpdate
's DSL API.UpdateFinalStep<R extends Record> This type is used for theUpdate
's DSL API.UpdateFromStep<R extends Record> This type is used for theUpdate
's DSL API.UpdateLimitStep<R extends Record> This type is used for theUpdate
's DSL API.UpdateOrderByStep<R extends Record> This type is used for theUpdate
's DSL API.UpdateQuery<R extends Record> AnUPDATE
statement (model API).UpdateResultStep<R extends Record> This type is used for theUpdate
's DSL API.UpdateReturningStep<R extends Record> This type is used for theUpdate
's DSL API.UpdateSetFirstStep<R extends Record> This type is used for theUpdate
's DSL API.UpdateSetMoreStep<R extends Record> This type is used for theUpdate
's DSL API.UpdateSetStep<R extends Record> This type is used for theUpdate
's DSL API.UpdateWhereStep<R extends Record> This type is used for theUpdate
's DSL API.User A privilege for use inGRANT
andREVOKE
statements.Variable<T> A local variable reference.VersionsBetweenAndStep<R extends Record,T> This type is used for the OracleVERSIONS
clause DSL API, providing access to the flashback versions query clauses.VisitContext A context object forQueryPart
traversal passed to registeredVisitListener
's.VisitListener A listener forQueryPart
traversal events.VisitListenerProvider A provider forVisitListener
instances.WindowBeforeOverStep<T> This type is used for the window function DSL API.WindowDefinition A window definition.WindowExcludeStep<T> This type is used for the window function DSL API.WindowFinalStep<T> This type is used for the window function DSL API.WindowFromFirstLastStep<T> This type is used for the window function DSL API.WindowIgnoreNullsStep<T> This type is used for the window function DSL API.WindowOrderByStep<T> This type is used for the window function DSL API.WindowOverStep<T> This type is used for the window function DSL API.WindowPartitionByStep<T> This type is used for the window function DSL API.WindowRowsAndStep<T> This type is used for the window function DSL API.WindowRowsStep<T> This type is used for the window function DSL API.WindowSpecification A window specification.WindowSpecificationExcludeStep An intermediate step in the construction of aWindowSpecification
.WindowSpecificationFinalStep An intermediate step in the construction of aWindowSpecification
.WindowSpecificationOrderByStep An intermediate step in the construction of aWindowSpecification
.WindowSpecificationPartitionByStep An intermediate step in the construction of aWindowSpecification
.WindowSpecificationRowsAndStep An intermediate step in the construction of aWindowSpecification
.WindowSpecificationRowsStep An intermediate step in the construction of aWindowSpecification
.WithAsStep WithAsStep1 WithAsStep10 WithAsStep11 WithAsStep12 WithAsStep13 WithAsStep14 WithAsStep15 WithAsStep16 WithAsStep17 WithAsStep18 WithAsStep19 WithAsStep2 WithAsStep20 WithAsStep21 WithAsStep22 WithAsStep3 WithAsStep4 WithAsStep5 WithAsStep6 WithAsStep7 WithAsStep8 WithAsStep9 WithStep -
Class Summary Class Description ChartFormat Constants Some publicly available constants used in jOOQConverters<T,U> A chain of converters.CSVFormat A CSV formatting type, which can be used to configure CSV imports / exports.DDLExportConfiguration A configuration type for use with the variousDSLContext.ddl(Catalog)
methods.JSON A JSON wrapper type for JSON data obtained from the database.JSONB A JSON wrapper type for JSONB data obtained from the database.JSONFormat A JSON formatting type, which can be used to configure JSON imports / exports.ParserCLI A command line interface to the Parser API, which works in a similar way as https://www.jooq.org/translate.ParserCLI.Args SchemaMapping Deprecated. - 2.0.5 - Use runtime configurationSettings
insteadSource A source of text data.TXTFormat A CSV formatting type, which can be used to configure CSV imports / exports.XMLFormat An XML formatting type, which can be used to configure XML imports / exports. -
Enum Summary Enum Description ChartFormat.Display ChartFormat.Output The chart output format.ChartFormat.Type Clause Deprecated. - 3.11.0 - [#7258] - This part of theVisitListener
SPI is deprecated.Comparator A comparator to be used in conditions to form comparison predicates.CSVFormat.Quote When to apply the quoteDatePart A date part can be used with SQL functions such as extract().DDLFlag ExecuteType The type of database interaction that is being executed with this context.JoinType The type of join.JSONFormat.RecordFormat The format of individual JSON records.Log.Level The log level.Name.Quoted A flag indicating whether the name is quoted or not.Nullability An enum that specifies the nullability of aDataType
.Operator An operator used for combining conditionsParamMode The mode of aParam
.RenderContext.CastMode The cast mode for bind values.SortOrder The sorting order used inORDER BY
clauses.SQLDialect Dialects and dialect families as supported by jOOQ.XMLFormat.RecordFormat The format of individual XML records. -
Annotation Types Summary Annotation Type Description Allow Allow a set ofSQLDialect
to be supported by any jOOQ statement in the scope of this annotation.Allow.PlainSQL This annotation allowsAllow.PlainSQL
API usage within the scope of where it is placed.Internal Signifies that a API (public class, method or field) is internal and subject to incompatible changes, or even removal, in a future release.PlainSQL This annotation marks all methods and types that allow for producing aQueryPart
that generates "plain SQL" inside of an AST.Pro An annotation that indicates that any given API is available to the commercial jOOQ distributions only, including the jOOQ Express Edition, the jOOQ Professional Edition, and the jOOQ Enterprise Edition.Require Require a set ofSQLDialect
to be supported by any jOOQ statement in the scope of this annotation.Support A formal declaration of whether any API element is supported by a givenSQLDialect