Interface | Description |
---|---|
AggregateFilterStep<T> |
The step in the specification of aggregate functions where the SQL:2003
standard
FILTER clause can be added. |
AggregateFunction<T> |
An aggregate function is a special field that is usually used in a
GROUP BY context. |
AlterIndexFinalStep |
The final step in the
ALTER INDEX DSL. |
AlterIndexOnStep |
The step in the
ALTER INDEX where the table can be specified for
the index. |
AlterIndexStep |
The step in the
ALTER INDEX where the action can be decided. |
AlterSchemaFinalStep |
The final step in the
DROP SCHEMA DSL. |
AlterSchemaStep |
The step in the
ALTER SCHEMA DSL used to specify
ALTER behaviour. |
AlterSequenceFinalStep |
A
Query that can alter sequences. |
AlterSequenceRestartStep<T extends Number> |
A
Query that can alter sequences. |
AlterSequenceStep<T extends Number> |
A
Query that can alter sequences. |
AlterTableAlterStep<T> |
The step in the
ALTER TABLE DSL used to ALTER
columns. |
AlterTableDropStep |
The step in the
ALTER TABLE DSL used to DROP
columns. |
AlterTableFinalStep |
The final step in the
ALTER TABLE DSL. |
AlterTableRenameColumnToStep |
The step in the
ALTER TABLE DSL used to RENAME
columns. |
AlterTableRenameConstraintToStep |
The step in the
ALTER TABLE DSL used to RENAME
constraints. |
AlterTableRenameIndexToStep |
The step in the
ALTER TABLE DSL used to RENAME
indexes. |
AlterTableStep |
The step in the
ALTER TABLE statement where the action can be
decided. |
AlterTableUsingIndexStep |
The step in the
ALTER TABLE .. |
AlterViewFinalStep |
The final step in the
ALTER VIEW DSL. |
AlterViewStep |
The step in the
ALTER VIEW where the action can be decided. |
ArrayAggOrderByStep<T> |
The SQL standard
ARRAY_AGG() function. |
ArrayRecord<E> |
A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally
providing some convenience methods
|
Asterisk |
A
QueryPart to be used exclusively in SELECT
clauses. |
Attachable |
An object in jOOQ that can have an underlying
Configuration attached
or detached. |
Batch |
A wrapper for a JDBC batch operation.
|
BatchBindStep |
This type is used for the
Batch 's DSL API. |
BetweenAndStep<T> |
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
BetweenAndStep1<T1> |
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
BetweenAndStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
BetweenAndStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
BetweenAndStep14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
An intermediate DSL type for the construction of a
BETWEEN
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 a
BETWEEN
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 a
BETWEEN
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 a
BETWEEN
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 a
BETWEEN
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 a
BETWEEN
predicate. |
BetweenAndStep2<T1,T2> |
An intermediate DSL type for the construction of a
BETWEEN
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 a
BETWEEN
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 a
BETWEEN
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 a
BETWEEN
predicate. |
BetweenAndStep3<T1,T2,T3> |
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
BetweenAndStep4<T1,T2,T3,T4> |
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
BetweenAndStep5<T1,T2,T3,T4,T5> |
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
BetweenAndStep6<T1,T2,T3,T4,T5,T6> |
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> |
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
BetweenAndStep8<T1,T2,T3,T4,T5,T6,T7,T8> |
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
BetweenAndStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
BetweenAndStepN |
An intermediate DSL type for the construction of a
BETWEEN
predicate. |
BindContext |
The bind context is used for binding
QueryPart 's and their contained
values to a PreparedStatement '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 for
Binding.get(BindingGetResultSetContext)
arguments. |
BindingGetSQLInputContext<U> |
A container type for
Binding.get(BindingGetSQLInputContext)
arguments. |
BindingGetStatementContext<U> |
A container type for
Binding.get(BindingGetStatementContext)
arguments. |
BindingRegisterContext<U> |
A container type for
Binding.register(BindingRegisterContext)
arguments. |
BindingSetSQLOutputContext<U> |
A container type for
Binding.set(BindingSetSQLOutputContext)
arguments. |
BindingSetStatementContext<U> |
A container type for
Binding.set(BindingSetStatementContext)
arguments. |
BindingSQLContext<U> |
A container type for
Binding.sql(BindingSQLContext) arguments. |
Block |
A query that models an anonymous procedural block
|
Case |
The SQL case statement.
|
CaseConditionStep<T> |
The final step in creating a case statement of the type
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
|
CaseValueStep<V> |
An intermediary step in creating a case statement of the type
CASE x WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
|
CaseWhenStep<V,T> |
The final step in creating a case statement of the type
CASE x WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
|
Catalog |
An object representing a database catalog.
|
Collation |
A collation.
|
Comment |
A meta model for SQL comments on tables, fields, etc.
|
CommentOnFinalStep |
The final step for the creation of a
COMMENT ON [ object type ]
statement. |
CommentOnIsStep |
The step in the
COMMENT ON [ object type ] statement where the
comment can be specified. |
CommonTableExpression<R extends Record> |
A common table expression is a table that can be supplied to
WITH clauses. |
Condition |
A condition to be used in a query's where part
|
ConditionProvider | Deprecated
- 2.6.0 [#1881] - This type will be removed from the public API,
soon.
|
Configuration |
A
Configuration configures a DSLContext , providing it
with information for query rendering and execution. |
ConnectionCallable<T> |
An operation that can run code and statements against a provided JDBC
Connection . |
ConnectionProvider |
A connection lifecycle handler API.
|
ConnectionRunnable |
An operation that can run code and statements against a provided JDBC
Connection . |
Constraint |
A DDL constraint.
|
ConstraintFinalStep |
The final step in the
Constraint construction DSL API. |
ConstraintForeignKeyOnStep |
The step in the
Constraint construction DSL API that allows for
adding ON DELETE and ON UPDATE clauses. |
ConstraintForeignKeyReferencesStep1<T1> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep2<T1,T2> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
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 the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
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 the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
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 the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep3<T1,T2,T3> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep4<T1,T2,T3,T4> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep5<T1,T2,T3,T4,T5> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep6<T1,T2,T3,T4,T5,T6> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep7<T1,T2,T3,T4,T5,T6,T7> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep8<T1,T2,T3,T4,T5,T6,T7,T8> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintForeignKeyReferencesStepN |
The step in the
Constraint construction DSL API that allows for
matching a FOREIGN KEY clause with a REFERENCES
clause. |
ConstraintTypeStep |
The step in the
Constraint 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> |
An
FunctionalInterface that wraps transactional code. |
ContextTransactionalRunnable |
An
FunctionalInterface that wraps transactional code. |
Converter<T,U> |
A
Converter for data types. |
ConverterProvider | Deprecated
- This API is still EXPERIMENTAL.
|
CreateIndexFinalStep |
A
Query that can create indexes. |
CreateIndexIncludeStep |
A
Query that can create indexes. |
CreateIndexStep |
A
Query that can create indexes. |
CreateIndexWhereStep |
A
Query that can create indexes. |
CreateSchemaFinalStep |
A
Query that can create schemas. |
CreateSequenceFinalStep |
A
Query that can create sequences. |
CreateTableAsStep<R extends Record> |
A
Query that can create tables. |
CreateTableColumnStep |
A
Query that can create tables. |
CreateTableCommentStep |
A
Query that can create tables. |
CreateTableConstraintStep |
A
Query that can create tables. |
CreateTableFinalStep |
A
Query that can create tables. |
CreateTableIndexStep |
A
Query that can create tables. |
CreateTableOnCommitStep |
A
Query that can create tables. |
CreateTableStorageStep |
A
Query that can create tables. |
CreateTableWithDataStep |
A
Query that can create tables. |
CreateViewAsStep<R extends Record> |
A
Query that can create views. |
CreateViewFinalStep |
A
Query that can create views. |
Cursor<R extends Record> |
Cursors allow for lazy, sequential access to an underlying JDBC
ResultSet . |
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.
|
Delete<R extends Record> |
A
Query that can delete data in the database. |
DeleteConditionStep<R extends Record> |
This type is used for the
Delete 's DSL API. |
DeleteFinalStep<R extends Record> |
This type is used for the
Delete 's DSL API. |
DeleteQuery<R extends Record> |
A query used for deletion of data
|
DeleteResultStep<R extends Record> |
This type is used for the
Delete 's DSL API. |
DeleteReturningStep<R extends Record> |
This type is used for the
Delete 's DSL API. |
DeleteWhereStep<R extends Record> |
This type is used for the
Delete 's DSL API. |
DerivedColumnList |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList1 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList10 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList11 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList12 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList13 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList14 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList15 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList16 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList17 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList18 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList19 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList2 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList20 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList21 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList22 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList3 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList4 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList5 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList6 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList7 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList8 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DerivedColumnList9 |
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
DiagnosticsContext |
A parameter object that is passed to
DiagnosticsListener methods. |
DiagnosticsListener |
A diagnostics listener.
|
DiagnosticsListenerProvider |
A provider for
TransactionListener instances. |
DivideByOnConditionStep |
An intermediate type for the construction of a relational division.
|
DivideByOnStep |
An intermediate type for the construction of a relational division
Referencing
XYZ*Step types directly from client code
It is usually not recommended to reference any XYZ*Step types
directly from client code, or assign them to local variables. |
DivideByReturningStep |
An intermediate type for the construction of a relational division
Referencing
XYZ*Step types directly from client code
It is usually not recommended to reference any XYZ*Step types
directly from client code, or assign them to local variables. |
DropIndexFinalStep |
A
Query that can drop indexes. |
DropIndexOnStep |
A
Query that can drop indexes. |
DropSchemaFinalStep |
The final step in the
DROP SCHEMA DSL. |
DropSchemaStep |
The step in the
DROP SCHEMA DSL used to specify
DROP behaviour. |
DropSequenceFinalStep |
A
Query that can drop sequences. |
DropTableFinalStep |
The final step in the
DROP TABLE DSL. |
DropTableStep |
The step in the
DROP TABLE DSL used to specify DROP
behaviour. |
DropViewFinalStep |
The final step in the
DROP VIEW DSL. |
DSLContext |
A contextual DSL providing "attached" implementations to the
org.jooq interfaces. |
EnumType |
A SQL enum type.
|
ExecuteContext |
A context object for
Query execution passed to registered
ExecuteListener 's. |
ExecuteEventHandler |
An event handler implementing
ExecuteListener events. |
ExecuteListener | |
ExecuteListenerProvider |
A provider for
ExecuteListener instances. |
ExecutorProvider |
The
ExecutorProvider SPI can be used to provide jOOQ with custom
asynchronous execution behaviour. |
Explain |
Results of an
DSLContext.explain(Query) call. |
False |
A predicate that always yields
false . |
Field<T> |
A field used in tables and conditions
Note that all fields qualify as
GroupField , i.e. they can always be
used in GROUP BY clauses |
FieldLike |
An object that can behave like a field (a field-like object)
|
FieldOrConstraint |
A common base type for
Field and Constraint where DSL API accepts
both types alike. |
FieldOrRow | |
ForeignKey<R extends Record,O extends Record> |
A
ForeignKey is an object referencing a UniqueKey . |
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.0
|
GrantFinalStep |
The final step in the creation of a
REVOKE statement. |
GrantOnStep |
The step in the creation of a
GRANT statement where the
ON clause can be added. |
GrantToStep |
The step in the creation of a
GRANT statement where the
TO clause can be added. |
GrantWithGrantOptionStep |
The step of creation
GRANT statement that assign user
or role a grant option. |
GroupConcatOrderByStep |
MySQL's
GROUP_CONCAT function. |
GroupConcatSeparatorStep |
MySQL's
GROUP_CONCAT function. |
GroupField |
A
QueryPart to be used exclusively in GROUP BY
clauses |
Identity<R extends Record,T> |
An
Identity is an object representing an IDENTITY
column as understood by the SQL:2003 standard. |
Index |
A DDL index definition.
|
Insert<R extends Record> |
A
Query that can insert data in the database. |
InsertFinalStep<R extends Record> |
This type is used for the
Insert 's DSL API. |
InsertOnConflictConditionStep<R extends Record> |
This type is used for the
Insert 's DSL API. |
InsertOnConflictDoUpdateStep<R extends Record> |
This type is used for the
Insert 's DSL API. |
InsertOnConflictWhereStep<R extends Record> |
This type is used for the
Insert 's DSL API. |
InsertOnDuplicateSetMoreStep<R extends Record> |
This type is used for the
Insert 's DSL API. |
InsertOnDuplicateSetStep<R extends Record> |
This type is used for the
Insert 's DSL API. |
InsertOnDuplicateStep<R extends Record> |
This type is used for the
Insert 's DSL API. |
InsertQuery<R extends Record> |
A query for data insertion
|
InsertResultStep<R extends Record> |
This type is used for the
Insert 's DSL API. |
InsertReturningStep<R extends Record> |
This type is used for the
Insert 's DSL API. |
InsertSetMoreStep<R extends Record> |
This type is used for the
Insert 's alternative DSL API. |
InsertSetStep<R extends Record> |
This type is used for the
Insert 's alternative DSL API. |
InsertValuesStep1<R extends Record,T1> |
This type is used for the
Insert 's DSL API. |
InsertValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
This type is used for the
Insert 's DSL API. |
InsertValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
This type is used for the
Insert 's DSL API. |
InsertValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
This type is used for the
Insert '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 the
Insert '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 the
Insert '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 the
Insert '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 the
Insert '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 the
Insert '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 the
Insert '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 the
Insert 's DSL API. |
InsertValuesStep2<R extends Record,T1,T2> |
This type is used for the
Insert '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 the
Insert '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 the
Insert '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 the
Insert 's DSL API. |
InsertValuesStep3<R extends Record,T1,T2,T3> |
This type is used for the
Insert 's DSL API. |
InsertValuesStep4<R extends Record,T1,T2,T3,T4> |
This type is used for the
Insert 's DSL API. |
InsertValuesStep5<R extends Record,T1,T2,T3,T4,T5> |
This type is used for the
Insert 's DSL API. |
InsertValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6> |
This type is used for the
Insert 's DSL API. |
InsertValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> |
This type is used for the
Insert 's DSL API. |
InsertValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> |
This type is used for the
Insert 's DSL API. |
InsertValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> |
This type is used for the
Insert 's DSL API. |
InsertValuesStepN<R extends Record> |
This type is used for the
Insert 's DSL API. |
Key<R extends Record> |
A
Key is an object representing a UNIQUE KEY , a
PRIMARY KEY , or a FOREIGN KEY . |
Keyword |
A SQL keyword
QueryPart . |
LikeEscapeStep |
A step in the creation of a
LIKE predicate to which an
ESCAPE clause can be appended. |
Link |
A database link reference.
|
Loader<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderContext |
A context object that provides information about a loader's current state to
LoaderRowListener . |
LoaderCSVOptionsStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderCSVStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderError |
An error that occurred during loading.
|
LoaderFieldMapper | |
LoaderFieldMapper.LoaderFieldContext |
The argument object for
LoaderFieldMapper.map(LoaderFieldContext)
. |
LoaderJSONOptionsStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderJSONStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderListenerStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderLoadStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderOptionsStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderRowListener |
A listener for
Loader progress. |
LoaderRowsStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderSourceStep<R extends Record> |
The
Loader API is used for configuring data loads. |
LoaderXMLStep<R extends Record> |
The
Loader API is used for configuring data loads. |
Log |
A common logger abstraction API for jOOQ's internal logging.
|
Merge<R extends Record> |
A
Query that can merge data in the database. |
MergeFinalStep<R extends Record> |
This type is used for the
Merge 's DSL API. |
MergeKeyStep1<R extends Record,T1> |
This type is used for the H2-specific variant of the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge 's DSL API. |
MergeKeyStep2<R extends Record,T1,T2> |
This type is used for the H2-specific variant of the
Merge '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 the
Merge '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 the
Merge '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 the
Merge 's DSL API. |
MergeKeyStep3<R extends Record,T1,T2,T3> |
This type is used for the H2-specific variant of the
Merge 's DSL API. |
MergeKeyStep4<R extends Record,T1,T2,T3,T4> |
This type is used for the H2-specific variant of the
Merge 's DSL API. |
MergeKeyStep5<R extends Record,T1,T2,T3,T4,T5> |
This type is used for the H2-specific variant of the
Merge 's DSL API. |
MergeKeyStep6<R extends Record,T1,T2,T3,T4,T5,T6> |
This type is used for the H2-specific variant of the
Merge 's DSL API. |
MergeKeyStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> |
This type is used for the H2-specific variant of the
Merge '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 the
Merge '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 the
Merge 's DSL API. |
MergeKeyStepN<R extends Record> |
This type is used for the H2-specific variant of the
Merge 's DSL API. |
MergeMatchedDeleteStep<R extends Record> |
This type is used for the
Merge 's DSL API. |
MergeMatchedSetMoreStep<R extends Record> |
This type is used for the
Merge 's DSL API. |
MergeMatchedSetStep<R extends Record> |
This type is used for the
Merge 's DSL API. |
MergeMatchedStep<R extends Record> |
This type is used for the
Merge 's DSL API. |
MergeMatchedWhereStep<R extends Record> |
This type is used for the
Merge 's DSL API. |
MergeNotMatchedSetMoreStep<R extends Record> |
This type is used for the
Merge 's DSL API. |
MergeNotMatchedSetStep<R extends Record> |
This type is used for the
Merge 's DSL API. |
MergeNotMatchedStep<R extends Record> |
This type is used for the
Merge 's DSL API. |
MergeNotMatchedValuesStep1<R extends Record,T1> |
This type is used for the
Merge 's DSL API. |
MergeNotMatchedValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
This type is used for the
Merge 's DSL API. |
MergeNotMatchedValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
This type is used for the
Merge 's DSL API. |
MergeNotMatchedValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
This type is used for the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge 's DSL API. |
MergeNotMatchedValuesStep2<R extends Record,T1,T2> |
This type is used for the
Merge '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 the
Merge '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 the
Merge '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 the
Merge 's DSL API. |
MergeNotMatchedValuesStep3<R extends Record,T1,T2,T3> |
This type is used for the
Merge 's DSL API. |
MergeNotMatchedValuesStep4<R extends Record,T1,T2,T3,T4> |
This type is used for the
Merge 's DSL API. |
MergeNotMatchedValuesStep5<R extends Record,T1,T2,T3,T4,T5> |
This type is used for the
Merge 's DSL API. |
MergeNotMatchedValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6> |
This type is used for the
Merge 's DSL API. |
MergeNotMatchedValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> |
This type is used for the
Merge 's DSL API. |
MergeNotMatchedValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> |
This type is used for the
Merge 's DSL API. |
MergeNotMatchedValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> |
This type is used for the
Merge 's DSL API. |
MergeNotMatchedValuesStepN<R extends Record> |
This type is used for the
Merge 's DSL API. |
MergeNotMatchedWhereStep<R extends Record> |
This type is used for the
Merge 's DSL API. |
MergeOnConditionStep<R extends Record> |
This type is used for the
Merge 's DSL API. |
MergeOnStep<R extends Record> |
This type is used for the
Merge 's DSL API. |
MergeUsingStep<R extends Record> |
This type is used for the
Merge 's DSL API. |
MergeValuesStep1<R extends Record,T1> |
This type is used for the H2-specific variant of the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge '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 the
Merge 's DSL API. |
MergeValuesStep2<R extends Record,T1,T2> |
This type is used for the H2-specific variant of the
Merge '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 the
Merge '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 the
Merge '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 the
Merge 's DSL API. |
MergeValuesStep3<R extends Record,T1,T2,T3> |
This type is used for the H2-specific variant of the
Merge 's DSL API. |
MergeValuesStep4<R extends Record,T1,T2,T3,T4> |
This type is used for the H2-specific variant of the
Merge 's DSL API. |
MergeValuesStep5<R extends Record,T1,T2,T3,T4,T5> |
This type is used for the H2-specific variant of the
Merge 's DSL API. |
MergeValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6> |
This type is used for the H2-specific variant of the
Merge 's DSL API. |
MergeValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> |
This type is used for the H2-specific variant of the
Merge '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 the
Merge '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 the
Merge 's DSL API. |
MergeValuesStepN<R extends Record> |
This type is used for the H2-specific variant of the
Merge 's DSL API. |
Meta |
A wrapping object for
DatabaseMetaData or for other sources of
database meta information (e.g. |
MetaProvider |
An SPI that can produce dynamic catalog, schema, table meta data information.
|
Name |
A SQL identifier
QueryPart . |
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> |
A
QueryPart to be used exclusively in ORDER BY
clauses. |
Package |
A container for stored procedures and functions
This is only supported in the
SQLDialect.ORACLE dialect |
Param<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 Oracle
PIVOT clause DSL API, pivoting
Table objects to new tables. |
PivotInStep<T> |
This type is used for the Oracle
PIVOT clause DSL API, pivoting
Table objects to new tables. |
Privilege | |
QualifiedAsterisk |
A
QueryPart to be used exclusively in SELECT
clauses. |
QuantifiedSelect<R extends Record> |
A participant of a quantified comparison predicate
A
QuantifiedSelect models the right hand side of a quantified
comparison predicate. |
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 objects
This interface is for JOOQ INTERNAL USE only.
|
Record |
A database result record.
|
Record1<T1> |
A model type for a records with degree
1 |
Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
A model type for a records with degree
10 |
Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
A model type for a records with degree
11 |
Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
A model type for a records with degree
12 |
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
A model type for a records with degree
13 |
Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
A model type for a records with degree
14 |
Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
A model type for a records with degree
15 |
Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
A model type for a records with degree
16 |
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 degree
17 |
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 degree
18 |
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 degree
19 |
Record2<T1,T2> |
A model type for a records with degree
2 |
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 degree
20 |
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 degree
21 |
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 degree
22 |
Record3<T1,T2,T3> |
A model type for a records with degree
3 |
Record4<T1,T2,T3,T4> |
A model type for a records with degree
4 |
Record5<T1,T2,T3,T4,T5> |
A model type for a records with degree
5 |
Record6<T1,T2,T3,T4,T5,T6> |
A model type for a records with degree
6 |
Record7<T1,T2,T3,T4,T5,T6,T7> |
A model type for a records with degree
7 |
Record8<T1,T2,T3,T4,T5,T6,T7,T8> |
A model type for a records with degree
8 |
Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
A model type for a records with degree
9 |
RecordContext |
A context object for
Record manipulation passed to registered
RecordListener 's. |
RecordHandler<R extends Record> |
A
RecordHandler is a handler that can receive Record
objects, when fetching data from the database. |
RecordListener |
A listener for manipulation events on
UpdatableRecord s. |
RecordListenerProvider |
A provider for
RecordListener instances. |
RecordMapper<R extends Record,E> |
A
RecordMapper is a mapper that can receive Record
objects, when fetching data from the database, transforming them into a
custom type <E> . |
RecordMapperProvider |
A provider for
RecordMapper instances. |
RecordType<R extends Record> | |
RecordUnmapper<E,R extends Record> |
A
RecordUnmapper is a mapper that can receive user objects and
convert them back to Record . |
RecordUnmapperProvider |
A provider for
RecordUnmapper instances. |
RenderContext |
The render context is used for rendering
QueryPart 's to SQL. |
Result<R extends Record> |
A wrapper for database results returned by
|
ResultOrRows |
A type that contains either a
Result , an update count, or an
exception. |
ResultQuery<R extends Record> |
A query that can return results.
|
Results |
A list of
Result and update counts that can be returned by
ResultQuery.fetchMany() calls and other calls that produce multiple
cursors and update counts. |
RevokeFinalStep |
The final step in the creation of a
REVOKE statement. |
RevokeFromStep |
The step in the creation of a
REVOKE statement where the
FROM clause can be added. |
RevokeOnStep |
The step in the creation of a
REVOKE statement where the
ON clause can be added. |
Role |
The Role to be used by GRANT statement.
|
Routine<T> |
A routine is a callable object in your RDBMS.
|
Row |
A model type for a row value expression.
|
Row1<T1> |
A model type for a row value expression with degree
1 . |
Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
A model type for a row value expression with degree
10 . |
Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
A model type for a row value expression with degree
11 . |
Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
A model type for a row value expression with degree
12 . |
Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
A model type for a row value expression with degree
13 . |
Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
A model type for a row value expression with degree
14 . |
Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
A model type for a row value expression with degree
15 . |
Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
A model type for a row value expression with degree
16 . |
Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
A model type for a row value expression with degree
17 . |
Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
A model type for a row value expression with degree
18 . |
Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
A model type for a row value expression with degree
19 . |
Row2<T1,T2> |
A model type for a row value expression with degree
2 . |
Row20<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 row value expression with degree
20 . |
Row21<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 row value expression with degree
21 . |
Row22<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 row value expression with degree
22 . |
Row3<T1,T2,T3> |
A model type for a row value expression with degree
3 . |
Row4<T1,T2,T3,T4> |
A model type for a row value expression with degree
4 . |
Row5<T1,T2,T3,T4,T5> |
A model type for a row value expression with degree
5 . |
Row6<T1,T2,T3,T4,T5,T6> |
A model type for a row value expression with degree
6 . |
Row7<T1,T2,T3,T4,T5,T6,T7> |
A model type for a row value expression with degree
7 . |
Row8<T1,T2,T3,T4,T5,T6,T7,T8> |
A model type for a row value expression with degree
8 . |
Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
A model type for a row value expression with degree
9 . |
RowN |
A model type for a row value expression with degree
N > 22 . |
Schema |
An object representing a database schema.
|
Scope |
Scope implementations provide access to a variety of objects that are
available from a given scope.
|
Select<R extends Record> | |
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> |
A
QueryPart to be used exclusively in SELECT
clauses. |
SelectFieldOrAsterisk |
A
QueryPart to be used exclusively in SELECT
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> | |
SelectQuery<R extends Record> |
A query for data selection
|
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 type representing sequences in databases that support this.
|
SortField<T> | |
SQL |
A plain SQL
QueryPart . |
Statement |
A statement that can be placed inside of a
Block , but not executed on
its own. |
StoreQuery<R extends Record> |
A query storing objects to the database.
|
Table<R extends Record> |
A table to be used in queries
|
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 a
JOIN
clause, where the join criteria is added using an ON clause
(with a Condition . |
TableOnStep<R extends Record> | |
TableOptionalOnStep<R extends Record> |
An intermediate type for the construction of a
JOIN clause,
where there may optionally be a join criteria added using an ON
clause (with a Condition ), or using a USING clause (with
a list of Field )
Referencing XYZ*Step types directly from client code
It is usually not recommended to reference any XYZ*Step types
directly from client code, or assign them to local variables. |
TableOuterJoinStep<R extends Record> |
An intermediate type for the construction of a partitioned
SQLDialect.ORACLE OUTER JOIN clause. |
TablePartitionByStep<R extends Record> |
An intermediate type for the construction of a partitioned
SQLDialect.ORACLE OUTER JOIN clause. |
TableRecord<R extends TableRecord<R>> |
A record originating from a single table
|
Transaction |
A custom transaction object.
|
TransactionalCallable<T> |
An
FunctionalInterface that wraps transactional code. |
TransactionalRunnable |
An
FunctionalInterface that wraps transactional code. |
TransactionContext |
A context object that is used to pass arguments to the various methods of
TransactionProvider . |
TransactionListener |
The
TransactionListener SPI is used to intercept the
TransactionProvider 's transaction events. |
TransactionListenerProvider |
A provider for
TransactionListener instances. |
TransactionProvider |
The
TransactionProvider SPI can be used to implement custom
transaction behaviour that is applied when calling
DSLContext.transactionResult(TransactionalCallable) or
DSLContext.transaction(TransactionalRunnable) . |
True |
A predicate that always yields
true . |
Truncate<R extends Record> |
A
Query that can truncate a table in the database. |
TruncateCascadeStep<R extends Record> |
A
Query that can truncate a table in the database. |
TruncateFinalStep<R extends Record> |
A
Query that can truncate a table in the database. |
TruncateIdentityStep<R extends Record> |
A
Query 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 UDT
|
UniqueKey<R extends Record> |
A
UniqueKey is an object representing a UNIQUE KEY
or a PRIMARY KEY . |
UpdatableRecord<R extends UpdatableRecord<R>> |
A common interface for records that can be stored back to the database again.
|
Update<R extends Record> |
A
Query that can update data in the database. |
UpdateConditionStep<R extends Record> |
This type is used for the
Update 's DSL API. |
UpdateFinalStep<R extends Record> |
This type is used for the
Update 's DSL API. |
UpdateFromStep<R extends Record> |
This type is used for the
Update 's DSL API. |
UpdateQuery<R extends Record> |
A query for data updating
|
UpdateResultStep<R extends Record> |
This type is used for the
Update 's DSL API. |
UpdateReturningStep<R extends Record> |
This type is used for the
Update 's DSL API. |
UpdateSetFirstStep<R extends Record> |
This type is used for the
Update 's DSL API. |
UpdateSetMoreStep<R extends Record> |
This type is used for the
Update 's DSL API. |
UpdateSetStep<R extends Record> |
This type is used for the
Update 's DSL API. |
UpdateWhereStep<R extends Record> |
This type is used for the
Update 's DSL API. |
User |
The User to be used by GRANT statement.
|
VersionsBetweenAndStep<R extends Record,T> |
This type is used for the Oracle
VERSIONS clause DSL API,
providing access to the flashback versions query clauses. |
VisitContext |
A context object for
QueryPart traversal passed to registered
VisitListener 's. |
VisitListener |
A listener for
QueryPart traversal events. |
VisitListenerProvider |
A provider for
VisitListener instances. |
WindowBeforeOverStep<T> |
This type is used for the window function DSL API.
|
WindowDefinition |
A window definition.
|
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.
|
WindowSpecificationFinalStep |
An intermediate step in the construction of a
WindowSpecification . |
WindowSpecificationOrderByStep |
An intermediate step in the construction of a
WindowSpecification . |
WindowSpecificationPartitionByStep |
An intermediate step in the construction of a
WindowSpecification . |
WindowSpecificationRowsAndStep |
An intermediate step in the construction of a
WindowSpecification . |
WindowSpecificationRowsStep |
An intermediate step in the construction of a
WindowSpecification . |
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 | Description |
---|---|
ChartFormat | |
Constants |
Some publicly available constants used in jOOQ
|
Converters<T,U> |
A chain of converters.
|
CSVFormat |
A CSV formatting type, which can be used to configure CSV imports / exports.
|
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 configuration
Settings instead |
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 | Description |
---|---|
ChartFormat.Display | |
ChartFormat.Output |
The chart output format.
|
ChartFormat.Type | |
Clause | Deprecated
- 3.11.0 - [#7258] - This part of the
VisitListener SPI
is deprecated. |
Comparator |
A comparator to be used in conditions to form comparison predicates.
|
CSVFormat.Quote |
When to apply the quote
|
DatePart |
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.
|
Nullability |
An enum that specifies the nullability of a
DataType . |
Operator |
An operator used for combining conditions
|
ParamMode |
The mode of a
Param . |
RenderContext.CastMode |
The cast mode for bind values.
|
SortOrder |
The sorting order used in
ORDER BY clauses. |
SQLDialect |
Dialects and dialect families as supported by jOOQ.
|
XMLFormat.RecordFormat |
The format of individual XML records.
|
Annotation Type | Description |
---|---|
Allow |
Allow a set of
SQLDialect to be supported by any jOOQ statement in
the scope of this annotation. |
Allow.PlainSQL |
This annotation allows
PlainSQL API usage within the scope of
where it is placed. |
PlainSQL |
This annotation marks all methods and types that allow for producing a
QueryPart that generates "plain SQL" inside of an AST. |
Require |
Require a set of
SQLDialect 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 given
SQLDialect
The annotation is mainly used in three modes:
The annotation is absent on a method. |
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.
Copyright © 2019. All rights reserved.