- All Superinterfaces:
Scope
- All Known Subinterfaces:
CloseableDSLContext
- All Known Implementing Classes:
DefaultCloseableDSLContext
,DefaultDSLContext
org.jooq
interfaces.
Apart from the DSL
, this contextual DSL is the main entry point for
client code, to access jOOQ classes and functionality that are related to
Query
execution. Unlike objects created through the DSL
type, objects created from a DSLContext
will be "attached" to
the DSLContext
's Scope.configuration()
, such that they can be
executed immediately in a fluent style. An example is given here:
DSLContext create = DSL.using(connection, dialect);
// Immediately fetch results after constructing a query
create.selectFrom(MY_TABLE).where(MY_TABLE.ID.eq(1)).fetch();
// The above is equivalent to this "non-fluent" style
create.fetch(DSL.selectFrom(MY_TABLE).where(MY_TABLE.ID.eq(1)));
The DSL
provides convenient constructors to create a
Configuration
, which will be shared among all Query
objects thus created. Optionally, you can pass a reusable
Configuration
to the DSL.using(Configuration)
constructor. Please consider thread-safety concerns documented in
Configuration
, should you want to reuse the same
Configuration
instance in various threads and / or transactions.
DSLContext
is a Scope
type, mostly for convenience access to
its underlying Configuration
properties, including the
Scope.data()
map, which it shares with the Configuration
. It does
not have an independent lifecycle.
- Author:
- Lukas Eder
- See Also:
-
Method Summary
Modifier and TypeMethodDescription@NotNull AlterDatabaseStep
alterDatabase
(String database) TheALTER DATABASE
statement.@NotNull AlterDatabaseStep
alterDatabase
(Catalog database) TheALTER DATABASE
statement.@NotNull AlterDatabaseStep
alterDatabase
(Name database) TheALTER DATABASE
statement.@NotNull AlterDatabaseStep
alterDatabaseIfExists
(String database) TheALTER DATABASE IF EXISTS
statement.@NotNull AlterDatabaseStep
alterDatabaseIfExists
(Catalog database) TheALTER DATABASE IF EXISTS
statement.@NotNull AlterDatabaseStep
alterDatabaseIfExists
(Name database) TheALTER DATABASE IF EXISTS
statement.<T> @NotNull AlterDomainStep<T>
alterDomain
(String domain) TheALTER DOMAIN
statement.<T> @NotNull AlterDomainStep<T>
alterDomain
(Domain<T> domain) TheALTER DOMAIN
statement.<T> @NotNull AlterDomainStep<T>
alterDomain
(Name domain) TheALTER DOMAIN
statement.<T> @NotNull AlterDomainStep<T>
alterDomainIfExists
(String domain) TheALTER DOMAIN IF EXISTS
statement.<T> @NotNull AlterDomainStep<T>
alterDomainIfExists
(Domain<T> domain) TheALTER DOMAIN IF EXISTS
statement.<T> @NotNull AlterDomainStep<T>
alterDomainIfExists
(Name domain) TheALTER DOMAIN IF EXISTS
statement.@NotNull AlterIndexOnStep
alterIndex
(String index) TheALTER INDEX
statement.@NotNull AlterIndexOnStep
alterIndex
(Index index) TheALTER INDEX
statement.@NotNull AlterIndexOnStep
alterIndex
(Name index) TheALTER INDEX
statement.@NotNull AlterIndexOnStep
alterIndexIfExists
(String index) TheALTER INDEX IF EXISTS
statement.@NotNull AlterIndexOnStep
alterIndexIfExists
(Index index) TheALTER INDEX IF EXISTS
statement.@NotNull AlterIndexOnStep
alterIndexIfExists
(Name index) TheALTER INDEX IF EXISTS
statement.@NotNull AlterSchemaStep
alterSchema
(String schema) TheALTER SCHEMA
statement.@NotNull AlterSchemaStep
alterSchema
(Name schema) TheALTER SCHEMA
statement.@NotNull AlterSchemaStep
alterSchema
(Schema schema) TheALTER SCHEMA
statement.@NotNull AlterSchemaStep
alterSchemaIfExists
(String schema) TheALTER SCHEMA IF EXISTS
statement.@NotNull AlterSchemaStep
alterSchemaIfExists
(Name schema) TheALTER SCHEMA IF EXISTS
statement.@NotNull AlterSchemaStep
alterSchemaIfExists
(Schema schema) TheALTER SCHEMA IF EXISTS
statement.@NotNull AlterSequenceStep<Number>
alterSequence
(String sequence) TheALTER SEQUENCE
statement.@NotNull AlterSequenceStep<Number>
alterSequence
(Name sequence) TheALTER SEQUENCE
statement.<T extends Number>
@NotNull AlterSequenceStep<T>alterSequence
(Sequence<T> sequence) TheALTER SEQUENCE
statement.@NotNull AlterSequenceStep<Number>
alterSequenceIfExists
(String sequence) TheALTER SEQUENCE IF EXISTS
statement.@NotNull AlterSequenceStep<Number>
alterSequenceIfExists
(Name sequence) TheALTER SEQUENCE IF EXISTS
statement.<T extends Number>
@NotNull AlterSequenceStep<T>alterSequenceIfExists
(Sequence<T> sequence) TheALTER SEQUENCE IF EXISTS
statement.@NotNull AlterTableStep
alterTable
(String table) Create a new DSLALTER TABLE
statement.@NotNull AlterTableStep
alterTable
(Name table) Create a new DSLALTER TABLE
statement.@NotNull AlterTableStep
alterTable
(Table<?> table) Create a new DSLALTER TABLE
statement.@NotNull AlterTableStep
alterTableIfExists
(String table) Create a new DSLALTER TABLE
statement.@NotNull AlterTableStep
alterTableIfExists
(Name table) Create a new DSLALTER TABLE
statement.@NotNull AlterTableStep
alterTableIfExists
(Table<?> table) Create a new DSLALTER TABLE
statement.@NotNull AlterTypeStep
TheALTER TYPE
statement.@NotNull AlterTypeStep
TheALTER TYPE
statement.@NotNull AlterViewStep
TheALTER VIEW
statement.@NotNull AlterViewStep
TheALTER VIEW
statement.@NotNull AlterViewStep
TheALTER VIEW
statement.@NotNull AlterViewStep
alterView
(Table<?> view, Collection<? extends Field<?>> fields) TheALTER VIEW
statement.@NotNull AlterViewStep
TheALTER VIEW
statement.@NotNull AlterViewStep
alterViewIfExists
(String view) TheALTER VIEW IF EXISTS
statement.@NotNull AlterViewStep
alterViewIfExists
(Name view) TheALTER VIEW IF EXISTS
statement.@NotNull AlterViewStep
alterViewIfExists
(Table<?> view) TheALTER VIEW IF EXISTS
statement.void
attach
(Collection<? extends Attachable> attachables) Attach thisDSLContext
's underlyingScope.configuration()
to some attachables.void
attach
(Attachable... attachables) Attach thisDSLContext
's underlyingScope.configuration()
to some attachables.@NotNull BatchBindStep
Create a batch statement to execute a set of queries in batch mode (with bind values).@NotNull Batch
Create a batch statement to execute a set of queries in batch mode (without bind values).@NotNull Batch
Create a batch statement to execute a set of queries in batch mode (with bind values).@NotNull Batch
batch
(Collection<? extends Query> queries) Create a batch statement to execute a set of queries in batch mode (without bind values).@NotNull Batch
Create a batch statement to execute a set of queries in batch mode (without bind values).@NotNull BatchBindStep
Create a batch statement to execute a set of queries in batch mode (with bind values).@NotNull Batch
Create a batch statement to execute a set of queries in batch mode (without bind values).@NotNull Batch
Create a batch statement to execute a set of queries in batch mode (with bind values).@NotNull Batch
batchDelete
(Collection<? extends UpdatableRecord<?>> records) Create a batch statement to execute a set ofDELETE
queries in batch mode (with bind values) according toUpdatableRecord.delete()
sematics.@NotNull Batch
batchDelete
(UpdatableRecord<?>... records) Create a batch statement to execute a set ofDELETE
queries in batch mode (with bind values) according toUpdatableRecord.delete()
sematics.void
batched
(BatchedRunnable runnable) Run aBatchedRunnable
on aBatchedConnection
, delaying execution as long as possible before batching.<T> T
batchedResult
(BatchedCallable<T> callable) Run aBatchedRunnable
on aBatchedConnection
, delaying execution as long as possible before batching.@NotNull Batch
batchInsert
(Collection<? extends TableRecord<?>> records) Create a batch statement to execute a set ofINSERT
queries in batch mode (with bind values) according toTableRecord.insert()
semantics.@NotNull Batch
batchInsert
(TableRecord<?>... records) Create a batch statement to execute a set ofINSERT
queries in batch mode (with bind values) according toTableRecord.insert()
semantics.@NotNull Batch
batchMerge
(Collection<? extends UpdatableRecord<?>> records) Create a batch statement to execute a set ofMERGE
queries in batch mode (with bind values) according toUpdatableRecord.merge()
semantics.@NotNull Batch
batchMerge
(UpdatableRecord<?>... records) Create a batch statement to execute a set ofMERGE
queries in batch mode (with bind values) according toUpdatableRecord.merge()
semantics.@NotNull Batch
batchStore
(Collection<? extends UpdatableRecord<?>> records) Create a batch statement to execute a set ofINSERT
andUPDATE
queries in batch mode (with bind values) according toUpdatableRecord.store()
semantics.@NotNull Batch
batchStore
(UpdatableRecord<?>... records) Create a batch statement to execute a set ofINSERT
andUPDATE
queries in batch mode (with bind values) according toUpdatableRecord.store()
semantics.@NotNull Batch
batchUpdate
(Collection<? extends UpdatableRecord<?>> records) Create a batch statement to execute a set ofUPDATE
queries in batch mode (with bind values) according toUpdatableRecord.update()
semantics.@NotNull Batch
batchUpdate
(UpdatableRecord<?>... records) Create a batch statement to execute a set ofUPDATE
queries in batch mode (with bind values) according toUpdatableRecord.update()
semantics.@NotNull Block
begin
(Collection<? extends Statement> statements) Wrap a collection of statements in an anoymous procedural block.@NotNull Block
Wrap a collection of statements in an anonymous procedural block.@NotNull BindContext
bindContext
(PreparedStatement stmt) Deprecated, for removal: This API element is subject to removal in a future version.- [#6280] - 3.10 - Do not reuse this method.@NotNull CallArgsStep
TheCALL
statement.@NotNull CallArgsStep
TheCALL
statement.@NotNull CommentOnIsStep
commentOnColumn
(String field) TheCOMMENT ON COLUMN
statement.@NotNull CommentOnIsStep
commentOnColumn
(Field<?> field) TheCOMMENT ON COLUMN
statement.@NotNull CommentOnIsStep
commentOnColumn
(Name field) TheCOMMENT ON COLUMN
statement.@NotNull CommentOnIsStep
commentOnTable
(String table) TheCOMMENT ON TABLE
statement.@NotNull CommentOnIsStep
commentOnTable
(Name table) TheCOMMENT ON TABLE
statement.@NotNull CommentOnIsStep
commentOnTable
(Table<?> table) TheCOMMENT ON TABLE
statement.@NotNull CommentOnIsStep
commentOnView
(String view) TheCOMMENT ON VIEW
statement.@NotNull CommentOnIsStep
commentOnView
(Name view) TheCOMMENT ON VIEW
statement.@NotNull CommentOnIsStep
commentOnView
(Table<?> view) TheCOMMENT ON VIEW
statement.@NotNull Query
commit()
TheCOMMIT
statement.void
connection
(ConnectionRunnable runnable) Run aConnectionRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.connectionProvider()
.<T> T
connectionResult
(ConnectionCallable<T> callable) Run aConnectionCallable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.connectionProvider()
.@NotNull CreateDatabaseFinalStep
createDatabase
(String database) TheCREATE DATABASE
statement.@NotNull CreateDatabaseFinalStep
createDatabase
(Catalog database) TheCREATE DATABASE
statement.@NotNull CreateDatabaseFinalStep
createDatabase
(Name database) TheCREATE DATABASE
statement.@NotNull CreateDatabaseFinalStep
createDatabaseIfNotExists
(String database) TheCREATE DATABASE IF NOT EXISTS
statement.@NotNull CreateDatabaseFinalStep
createDatabaseIfNotExists
(Catalog database) TheCREATE DATABASE IF NOT EXISTS
statement.@NotNull CreateDatabaseFinalStep
createDatabaseIfNotExists
(Name database) TheCREATE DATABASE IF NOT EXISTS
statement.@NotNull CreateDomainAsStep
createDomain
(String domain) TheCREATE DOMAIN
statement.@NotNull CreateDomainAsStep
createDomain
(Domain<?> domain) TheCREATE DOMAIN
statement.@NotNull CreateDomainAsStep
createDomain
(Name domain) TheCREATE DOMAIN
statement.@NotNull CreateDomainAsStep
createDomainIfNotExists
(String domain) TheCREATE DOMAIN IF NOT EXISTS
statement.@NotNull CreateDomainAsStep
createDomainIfNotExists
(Domain<?> domain) TheCREATE DOMAIN IF NOT EXISTS
statement.@NotNull CreateDomainAsStep
createDomainIfNotExists
(Name domain) TheCREATE DOMAIN IF NOT EXISTS
statement.@NotNull CreateFunctionParametersStep
createFunction
(String function) TheCREATE FUNCTION
statement.@NotNull CreateFunctionParametersStep
createFunction
(Name function) TheCREATE FUNCTION
statement.@NotNull CreateTableElementListStep
createGlobalTemporaryTable
(String table) TheCREATE GLOBAL TEMPORARY TABLE
statement.@NotNull CreateTableElementListStep
createGlobalTemporaryTable
(Name table) TheCREATE GLOBAL TEMPORARY TABLE
statement.@NotNull CreateTableElementListStep
createGlobalTemporaryTable
(Table<?> table) TheCREATE GLOBAL TEMPORARY TABLE
statement.@NotNull CreateTableElementListStep
TheCREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS
statement.@NotNull CreateTableElementListStep
TheCREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS
statement.@NotNull CreateTableElementListStep
createGlobalTemporaryTableIfNotExists
(Table<?> table) TheCREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS
statement.@NotNull CreateIndexStep
TheCREATE INDEX
statement.@NotNull CreateIndexStep
createIndex
(String index) TheCREATE INDEX
statement.@NotNull CreateIndexStep
createIndex
(Index index) TheCREATE INDEX
statement.@NotNull CreateIndexStep
createIndex
(Name index) TheCREATE INDEX
statement.@NotNull CreateIndexStep
TheCREATE INDEX IF NOT EXISTS
statement.@NotNull CreateIndexStep
createIndexIfNotExists
(String index) TheCREATE INDEX IF NOT EXISTS
statement.@NotNull CreateIndexStep
createIndexIfNotExists
(Index index) TheCREATE INDEX IF NOT EXISTS
statement.@NotNull CreateIndexStep
createIndexIfNotExists
(Name index) TheCREATE INDEX IF NOT EXISTS
statement.@NotNull CreateFunctionParametersStep
createOrReplaceFunction
(String function) TheCREATE OR REPLACE FUNCTION
statement.@NotNull CreateFunctionParametersStep
createOrReplaceFunction
(Name function) TheCREATE OR REPLACE FUNCTION
statement.@NotNull CreateProcedureParametersStep
createOrReplaceProcedure
(String procedure) TheCREATE OR REPLACE PROCEDURE
statement.@NotNull CreateProcedureParametersStep
createOrReplaceProcedure
(Name procedure) TheCREATE OR REPLACE PROCEDURE
statement.@NotNull CreateTriggerEventStep
createOrReplaceTrigger
(String trigger) TheCREATE OR REPLACE TRIGGER
statement.@NotNull CreateTriggerEventStep
createOrReplaceTrigger
(Name trigger) TheCREATE OR REPLACE TRIGGER
statement.@NotNull CreateViewAsStep<Record>
createOrReplaceView
(String view, String... fields) Create a new DSLCREATE OR REPLACE VIEW
statement.@NotNull CreateViewAsStep<Record>
createOrReplaceView
(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createOrReplaceView
(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createOrReplaceView
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createOrReplaceView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createOrReplaceView
(Name view, Name... fields) Create a new DSLCREATE OR REPLACE VIEW
statement.@NotNull CreateViewAsStep<Record>
createOrReplaceView
(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createOrReplaceView
(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createOrReplaceView
(Table<?> view, Field<?>... fields) Create a new DSLCREATE OR REPLACE VIEW
statement.@NotNull CreateProcedureParametersStep
createProcedure
(String procedure) TheCREATE PROCEDURE
statement.@NotNull CreateProcedureParametersStep
createProcedure
(Name procedure) TheCREATE PROCEDURE
statement.@NotNull CreateSchemaFinalStep
createSchema
(String schema) TheCREATE SCHEMA
statement.@NotNull CreateSchemaFinalStep
createSchema
(Name schema) TheCREATE SCHEMA
statement.@NotNull CreateSchemaFinalStep
createSchema
(Schema schema) TheCREATE SCHEMA
statement.@NotNull CreateSchemaFinalStep
createSchemaIfNotExists
(String schema) TheCREATE SCHEMA IF NOT EXISTS
statement.@NotNull CreateSchemaFinalStep
createSchemaIfNotExists
(Name schema) TheCREATE SCHEMA IF NOT EXISTS
statement.@NotNull CreateSchemaFinalStep
createSchemaIfNotExists
(Schema schema) TheCREATE SCHEMA IF NOT EXISTS
statement.@NotNull CreateSequenceFlagsStep
createSequence
(String sequence) TheCREATE SEQUENCE
statement.@NotNull CreateSequenceFlagsStep
createSequence
(Name sequence) TheCREATE SEQUENCE
statement.@NotNull CreateSequenceFlagsStep
createSequence
(Sequence<?> sequence) TheCREATE SEQUENCE
statement.@NotNull CreateSequenceFlagsStep
createSequenceIfNotExists
(String sequence) TheCREATE SEQUENCE IF NOT EXISTS
statement.@NotNull CreateSequenceFlagsStep
createSequenceIfNotExists
(Name sequence) TheCREATE SEQUENCE IF NOT EXISTS
statement.@NotNull CreateSequenceFlagsStep
createSequenceIfNotExists
(Sequence<?> sequence) TheCREATE SEQUENCE IF NOT EXISTS
statement.@NotNull CreateTableElementListStep
createTable
(String table) TheCREATE TABLE
statement.@NotNull CreateTableElementListStep
createTable
(Name table) TheCREATE TABLE
statement.@NotNull CreateTableElementListStep
createTable
(Table<?> table) TheCREATE TABLE
statement.@NotNull CreateTableElementListStep
createTableIfNotExists
(String table) TheCREATE TABLE IF NOT EXISTS
statement.@NotNull CreateTableElementListStep
createTableIfNotExists
(Name table) TheCREATE TABLE IF NOT EXISTS
statement.@NotNull CreateTableElementListStep
createTableIfNotExists
(Table<?> table) TheCREATE TABLE IF NOT EXISTS
statement.@NotNull CreateTableElementListStep
createTemporaryTable
(String table) TheCREATE TEMPORARY TABLE
statement.@NotNull CreateTableElementListStep
createTemporaryTable
(Name table) TheCREATE TEMPORARY TABLE
statement.@NotNull CreateTableElementListStep
createTemporaryTable
(Table<?> table) TheCREATE TEMPORARY TABLE
statement.@NotNull CreateTableElementListStep
TheCREATE TEMPORARY TABLE IF NOT EXISTS
statement.@NotNull CreateTableElementListStep
TheCREATE TEMPORARY TABLE IF NOT EXISTS
statement.@NotNull CreateTableElementListStep
createTemporaryTableIfNotExists
(Table<?> table) TheCREATE TEMPORARY TABLE IF NOT EXISTS
statement.@NotNull CreateTriggerEventStep
createTrigger
(String trigger) TheCREATE TRIGGER
statement.@NotNull CreateTriggerEventStep
createTrigger
(Name trigger) TheCREATE TRIGGER
statement.@NotNull CreateTypeStep
createType
(String type) Create a new DSLCREATE TYPE
statement.@NotNull CreateTypeStep
createType
(Name type) Create a new DSLCREATE TYPE
statement.@NotNull CreateIndexStep
TheCREATE UNIQUE INDEX
statement.@NotNull CreateIndexStep
createUniqueIndex
(String index) TheCREATE UNIQUE INDEX
statement.@NotNull CreateIndexStep
createUniqueIndex
(Index index) TheCREATE UNIQUE INDEX
statement.@NotNull CreateIndexStep
createUniqueIndex
(Name index) TheCREATE UNIQUE INDEX
statement.@NotNull CreateIndexStep
TheCREATE UNIQUE INDEX IF NOT EXISTS
statement.@NotNull CreateIndexStep
TheCREATE UNIQUE INDEX IF NOT EXISTS
statement.@NotNull CreateIndexStep
TheCREATE UNIQUE INDEX IF NOT EXISTS
statement.@NotNull CreateIndexStep
createUniqueIndexIfNotExists
(Name index) TheCREATE UNIQUE INDEX IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
createView
(String view, String... fields) Create a new DSLCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
createView
(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createView
(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createView
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createView
(Name view, Name... fields) Create a new DSLCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
createView
(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createView
(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createView
(Table<?> view, Field<?>... fields) Create a new DSLCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
createViewIfNotExists
(String view, String... fields) Create a new DSLCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
createViewIfNotExists
(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createViewIfNotExists
(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createViewIfNotExists
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createViewIfNotExists
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createViewIfNotExists
(Name view, Name... fields) Create a new DSLCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
createViewIfNotExists
(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createViewIfNotExists
(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
createViewIfNotExists
(Table<?> view, Field<?>... fields) Create a new DSLCREATE VIEW
statement.@NotNull BigInteger
Convenience method to fetch the CURRVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.@NotNull BigInteger
Convenience method to fetch the CURRVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.<T extends Number>
TConvenience method to fetch the CURRVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.@NotNull Queries
ddl
(Collection<? extends Table<?>> tables) Convenience method forMeta.ddl()
.@NotNull Queries
ddl
(Collection<? extends Table<?>> tables, DDLExportConfiguration configuration) Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
ddl
(Collection<? extends Table<?>> tables, DDLFlag... flags) Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
Convenience method forMeta.ddl()
.@NotNull Queries
ddl
(Catalog schema, DDLExportConfiguration configuration) Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
Convenience method forMeta.ddl()
.@NotNull Queries
ddl
(Schema schema, DDLExportConfiguration configuration) Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
Convenience method forMeta.ddl()
.@NotNull Queries
Convenience method forMeta.ddl()
.@NotNull Queries
ddl
(Table<?>[] tables, DDLExportConfiguration configuration) Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
ddl
(Table<?> table, DDLExportConfiguration configuration) Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
Convenience method forMeta.ddl(DDLExportConfiguration)
.<R extends Record>
@NotNull DeleteUsingStep<R>Create a new DSL delete statement.<R extends Record>
@NotNull DeleteUsingStep<R>deleteFrom
(Table<R> table) Create a new DSL delete statement.<R extends Record>
@NotNull DeleteQuery<R>deleteQuery
(Table<R> table) Create a newDeleteQuery
@NotNull Connection
A JDBC connection that proxies the underlying connection to run the jOOQ Diagnostics Pack on executed queries.@NotNull DataSource
A JDBC connection that proxies the underlying connection to run the jOOQ Diagnostics Pack on executed queries.@NotNull DropDatabaseFinalStep
dropDatabase
(String database) TheDROP DATABASE
statement.@NotNull DropDatabaseFinalStep
dropDatabase
(Catalog database) TheDROP DATABASE
statement.@NotNull DropDatabaseFinalStep
dropDatabase
(Name database) TheDROP DATABASE
statement.@NotNull DropDatabaseFinalStep
dropDatabaseIfExists
(String database) TheDROP DATABASE IF EXISTS
statement.@NotNull DropDatabaseFinalStep
dropDatabaseIfExists
(Catalog database) TheDROP DATABASE IF EXISTS
statement.@NotNull DropDatabaseFinalStep
dropDatabaseIfExists
(Name database) TheDROP DATABASE IF EXISTS
statement.@NotNull DropDomainCascadeStep
dropDomain
(String domain) TheDROP DOMAIN
statement.@NotNull DropDomainCascadeStep
dropDomain
(Domain<?> domain) TheDROP DOMAIN
statement.@NotNull DropDomainCascadeStep
dropDomain
(Name domain) TheDROP DOMAIN
statement.@NotNull DropDomainCascadeStep
dropDomainIfExists
(String domain) TheDROP DOMAIN IF EXISTS
statement.@NotNull DropDomainCascadeStep
dropDomainIfExists
(Domain<?> domain) TheDROP DOMAIN IF EXISTS
statement.@NotNull DropDomainCascadeStep
dropDomainIfExists
(Name domain) TheDROP DOMAIN IF EXISTS
statement.@NotNull DDLQuery
dropFunction
(String function) TheDROP FUNCTION
statement.@NotNull DDLQuery
dropFunction
(Name function) TheDROP FUNCTION
statement.@NotNull DDLQuery
dropFunctionIfExists
(String function) TheDROP FUNCTION IF EXISTS
statement.@NotNull DDLQuery
dropFunctionIfExists
(Name function) TheDROP FUNCTION IF EXISTS
statement.@NotNull DropIndexOnStep
TheDROP INDEX
statement.@NotNull DropIndexOnStep
TheDROP INDEX
statement.@NotNull DropIndexOnStep
TheDROP INDEX
statement.@NotNull DropIndexOnStep
dropIndexIfExists
(String index) TheDROP INDEX IF EXISTS
statement.@NotNull DropIndexOnStep
dropIndexIfExists
(Index index) TheDROP INDEX IF EXISTS
statement.@NotNull DropIndexOnStep
dropIndexIfExists
(Name index) TheDROP INDEX IF EXISTS
statement.@NotNull DDLQuery
dropProcedure
(String procedure) TheDROP PROCEDURE
statement.@NotNull DDLQuery
dropProcedure
(Name procedure) TheDROP PROCEDURE
statement.@NotNull DDLQuery
dropProcedureIfExists
(String procedure) TheDROP PROCEDURE IF EXISTS
statement.@NotNull DDLQuery
dropProcedureIfExists
(Name procedure) TheDROP PROCEDURE IF EXISTS
statement.@NotNull DropSchemaStep
dropSchema
(String schema) TheDROP SCHEMA
statement.@NotNull DropSchemaStep
dropSchema
(Name schema) TheDROP SCHEMA
statement.@NotNull DropSchemaStep
dropSchema
(Schema schema) TheDROP SCHEMA
statement.@NotNull DropSchemaStep
dropSchemaIfExists
(String schema) TheDROP SCHEMA IF EXISTS
statement.@NotNull DropSchemaStep
dropSchemaIfExists
(Name schema) TheDROP SCHEMA IF EXISTS
statement.@NotNull DropSchemaStep
dropSchemaIfExists
(Schema schema) TheDROP SCHEMA IF EXISTS
statement.@NotNull DropSequenceFinalStep
dropSequence
(String sequence) TheDROP SEQUENCE
statement.@NotNull DropSequenceFinalStep
dropSequence
(Name sequence) TheDROP SEQUENCE
statement.@NotNull DropSequenceFinalStep
dropSequence
(Sequence<?> sequence) TheDROP SEQUENCE
statement.@NotNull DropSequenceFinalStep
dropSequenceIfExists
(String sequence) TheDROP SEQUENCE IF EXISTS
statement.@NotNull DropSequenceFinalStep
dropSequenceIfExists
(Name sequence) TheDROP SEQUENCE IF EXISTS
statement.@NotNull DropSequenceFinalStep
dropSequenceIfExists
(Sequence<?> sequence) TheDROP SEQUENCE IF EXISTS
statement.@NotNull DropTableStep
TheDROP TABLE
statement.@NotNull DropTableStep
TheDROP TABLE
statement.@NotNull DropTableStep
TheDROP TABLE
statement.@NotNull DropTableStep
dropTableIfExists
(String table) TheDROP TABLE IF EXISTS
statement.@NotNull DropTableStep
dropTableIfExists
(Name table) TheDROP TABLE IF EXISTS
statement.@NotNull DropTableStep
dropTableIfExists
(Table<?> table) TheDROP TABLE IF EXISTS
statement.@NotNull DropTableStep
dropTemporaryTable
(String table) TheDROP TEMPORARY TABLE
statement.@NotNull DropTableStep
dropTemporaryTable
(Name table) TheDROP TEMPORARY TABLE
statement.@NotNull DropTableStep
dropTemporaryTable
(Table<?> table) TheDROP TEMPORARY TABLE
statement.@NotNull DropTableStep
dropTemporaryTableIfExists
(String table) TheDROP TEMPORARY TABLE IF EXISTS
statement.@NotNull DropTableStep
dropTemporaryTableIfExists
(Name table) TheDROP TEMPORARY TABLE IF EXISTS
statement.@NotNull DropTableStep
dropTemporaryTableIfExists
(Table<?> table) TheDROP TEMPORARY TABLE IF EXISTS
statement.@NotNull DDLQuery
dropTrigger
(String trigger) TheDROP TRIGGER
statement.@NotNull DDLQuery
dropTrigger
(Name trigger) TheDROP TRIGGER
statement.@NotNull DDLQuery
dropTriggerIfExists
(String trigger) TheDROP TRIGGER IF EXISTS
statement.@NotNull DDLQuery
dropTriggerIfExists
(Name trigger) TheDROP TRIGGER IF EXISTS
statement.@NotNull DropTypeStep
Create a new DSLDROP TYPE
statement.@NotNull DropTypeStep
Create a new DSLDROP TYPE
statement.@NotNull DropTypeStep
dropType
(Collection<?> type) Create a new DSLDROP TYPE
statement.@NotNull DropTypeStep
Create a new DSLDROP TYPE
statement.@NotNull DropTypeStep
Create a new DSLDROP TYPE
statement.@NotNull DropTypeStep
dropTypeIfExists
(String type) Create a new DSLDROP TYPE
statement.@NotNull DropTypeStep
dropTypeIfExists
(String... type) Create a new DSLDROP TYPE
statement.@NotNull DropTypeStep
dropTypeIfExists
(Collection<?> type) Create a new DSLDROP TYPE
statement.@NotNull DropTypeStep
dropTypeIfExists
(Name type) Create a new DSLDROP TYPE
statement.@NotNull DropTypeStep
dropTypeIfExists
(Name... type) Create a new DSLDROP TYPE
statement.@NotNull DropViewFinalStep
TheDROP VIEW
statement.@NotNull DropViewFinalStep
TheDROP VIEW
statement.@NotNull DropViewFinalStep
TheDROP VIEW
statement.@NotNull DropViewFinalStep
dropViewIfExists
(String view) TheDROP VIEW IF EXISTS
statement.@NotNull DropViewFinalStep
dropViewIfExists
(Name view) TheDROP VIEW IF EXISTS
statement.@NotNull DropViewFinalStep
dropViewIfExists
(Table<?> view) TheDROP VIEW IF EXISTS
statement.int
Execute a query holding plain SQL.int
Execute a new query holding plain SQL.int
Execute a new query holding plain SQL.int
Execute aQuery
in the context of thisDSLContext
.int
Execute a query holding plain SQL.int
executeDelete
(TableRecord<?> record, Condition condition) Delete a record from a table.int
executeDelete
(UpdatableRecord<?> record) Delete a record from a table.int
executeInsert
(TableRecord<?> record) Insert one record.int
executeUpdate
(TableRecord<?> record, Condition condition) Update a table.int
executeUpdate
(UpdatableRecord<?> record) Update a table.@NotNull Explain
Run anEXPLAIN
statement in the database to estimate the cardinality of the query.extractBindValues
(QueryPart part) Retrieve the bind values that will be bound by a givenQueryPart
.@Nullable Param<?>
extractParam
(QueryPart part, String name) Get a named parameter from aQueryPart
, provided its name.extractParams
(QueryPart part) Get aMap
of named parameters.Execute a new query holding plain SQL.Execute a new query holding plain SQL.Execute a new query holding plain SQL.fetch
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return results.Execute a new query holding plain SQL.Execute and return all records forfetch
(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records forExecute and return all records forExecute and return all records for<R extends Record>
RExecute and return zero or one record for<R extends Record>
RfetchAny
(Table<R> table, Collection<? extends Condition> conditions) Execute and return zero or one record for<R extends Record>
RExecute and return zero or one record for<R extends Record>
RExecute and return zero or on e record for@NotNull CompletionStage<Result<Record>>
fetchAsync
(String sql) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
fetchAsync
(String sql, Object... bindings) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
fetchAsync
(String sql, QueryPart... parts) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
fetchAsync
(ResultSet rs) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
fetchAsync
(ResultSet rs, Class<?>... types) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
fetchAsync
(ResultSet rs, DataType<?>... types) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
fetchAsync
(ResultSet rs, Field<?>... fields) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
fetchAsync
(Executor executor, String sql) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
fetchAsync
(Executor executor, String sql, Object... bindings) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
fetchAsync
(Executor executor, String sql, QueryPart... parts) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
fetchAsync
(Executor executor, ResultSet rs) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
fetchAsync
(Executor executor, ResultSet rs, Class<?>... types) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
fetchAsync
(Executor executor, ResultSet rs, DataType<?>... types) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
fetchAsync
(Executor executor, ResultSet rs, Field<?>... fields) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.<R extends Record>
@NotNull CompletionStage<Result<R>>fetchAsync
(Executor executor, ResultQuery<R> query) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
fetchAsync
(Executor executor, SQL sql) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.<R extends Record>
@NotNull CompletionStage<Result<R>>fetchAsync
(Executor executor, Table<R> table) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>fetchAsync
(Executor executor, Table<R> table, Collection<? extends Condition> conditions) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>fetchAsync
(Executor executor, Table<R> table, Condition condition) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>fetchAsync
(Executor executor, Table<R> table, Condition... conditions) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>fetchAsync
(ResultQuery<R> query) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
fetchAsync
(SQL sql) Fetch results in a newCompletionStage
.<R extends Record>
@NotNull CompletionStage<Result<R>>fetchAsync
(Table<R> table) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>fetchAsync
(Table<R> table, Collection<? extends Condition> condition) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>fetchAsync
(Table<R> table, Condition condition) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>fetchAsync
(Table<R> table, Condition... condition) Execute and return all records asynchronously for<R extends TableRecord<R>>
@NotNull Result<R>fetchByExample
(R example) Execute a "Query by Example" (QBE) based on an example record.int
fetchCount
(Select<?> query) int
fetchCount
(Table<?> table) Count the number of records in a table.int
fetchCount
(Table<?> table, Collection<? extends Condition> conditions) Count the number of records in a table that satisfy a condition.int
fetchCount
(Table<?> table, Condition condition) Count the number of records in a table that satisfy a condition.int
fetchCount
(Table<?> table, Condition... conditions) Count the number of records in a table that satisfy a condition.boolean
fetchExists
(Select<?> query) Check if aSelect
would return any records, if it were executed.boolean
fetchExists
(Table<?> table) Check if a table has any records.boolean
fetchExists
(Table<?> table, Collection<? extends Condition> conditions) Check if a table has any records that satisfy a condition.boolean
fetchExists
(Table<?> table, Condition condition) Check if a table has any records that satisfy a condition.boolean
fetchExists
(Table<?> table, Condition... conditions) Check if a table has any records that satisfy a condition.fetchFromCSV
(String string) Fetch all data from a CSV string.fetchFromCSV
(String string, boolean header) Fetch all data from a CSV string.fetchFromCSV
(String string, boolean header, char delimiter) Fetch all data from a CSV string.fetchFromCSV
(String string, char delimiter) Fetch all data from a CSV string.fetchFromHTML
(String string) Convert an HTML table into a jOOQResult
.fetchFromJSON
(String string) Fetch all data from a JSON string.fetchFromStringData
(String[]... data) Fetch all data from a list of strings.fetchFromStringData
(List<String[]> data) Fetch all data from a list of strings.fetchFromStringData
(List<String[]> data, boolean header) Fetch all data from a list of strings.fetchFromTXT
(String string) Fetch all data from a formatted string.fetchFromTXT
(String string, String nullLiteral) Fetch all data from a formatted string.fetchFromXML
(String string) Fetch all data from an XML string.fetchGroups
(ResultQuery<? extends Record2<K, V>> query) Execute the query and return aMap
with the first column as the map key and the second column as the map values.Execute a new query holding plain SQL and "lazily" return the generated result.Execute a new query holding plain SQL and "lazily" return the generated result.Execute a new query holding plain SQL and "lazily" return the generated result.fetchLazy
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a cursor.Execute a new query holding plain SQL and "lazily" return the generated result.Execute and return all records lazily forfetchLazy
(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records lazily forExecute and return all records lazily forExecute and return all records lazily for@NotNull Results
Execute a new query holding plain SQL, possibly returning several result sets.@NotNull Results
Execute a new query holding plain SQL, possibly returning several result sets.@NotNull Results
Execute a new query holding plain SQL, possibly returning several result sets.fetchMany
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a cursor.@NotNull Results
Execute a new query holding plain SQL, possibly returning several result sets.<K,
V> @NotNull Map<K, V> fetchMap
(ResultQuery<? extends Record2<K, V>> query) Execute the query and return aMap
with the first column as the map key and the second column as the map value.@Nullable Record
Execute a new query holding plain SQL.@Nullable Record
Execute a new query holding plain SQL.@Nullable Record
Execute a new query holding plain SQL.@Nullable Record
@Nullable Record
@Nullable Record
@Nullable Record
<R extends Record>
RfetchOne
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a record.@Nullable Record
Execute a new query holding plain SQL.<R extends Record>
RExecute and return zero or one record for<R extends Record>
RfetchOne
(Table<R> table, Collection<? extends Condition> conditions) Execute and return zero or one record for<R extends Record>
RExecute and return zero or one record for<R extends Record>
RExecute and return zero or one record forfetchOptional
(String sql) Execute a new query holding plain SQL.fetchOptional
(String sql, Object... bindings) Execute a new query holding plain SQL.fetchOptional
(String sql, QueryPart... parts) Execute a new query holding plain SQL.fetchOptional
(ResultSet rs, Class<?>... types) fetchOptional
(ResultSet rs, DataType<?>... types) fetchOptional
(ResultSet rs, Field<?>... fields) fetchOptional
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a record.fetchOptional
(SQL sql) Execute a new query holding plain SQL.fetchOptional
(Table<R> table) Execute and return zero or one record forfetchOptional
(Table<R> table, Collection<? extends Condition> conditions) Execute and return zero or one record forfetchOptional
(Table<R> table, Condition condition) Execute and return zero or one record forfetchOptional
(Table<R> table, Condition... conditions) Execute and return zero or one record for@NotNull Optional<?>
fetchOptionalValue
(String sql) Execute a new query holding plain SQL.@NotNull Optional<?>
fetchOptionalValue
(String sql, Object... bindings) Execute a new query holding plain SQL.@NotNull Optional<?>
fetchOptionalValue
(String sql, QueryPart... parts) Execute a new query holding plain SQL.@NotNull Optional<?>
Fetch a record from a JDBCResultSet
and return the only contained value.<T> @NotNull Optional<T>
fetchOptionalValue
(ResultSet rs, Class<T> type) Fetch a record from a JDBCResultSet
and return the only contained value.<T> @NotNull Optional<T>
fetchOptionalValue
(ResultSet rs, DataType<T> type) Fetch a record from a JDBCResultSet
and return the only contained value.<T> @NotNull Optional<T>
fetchOptionalValue
(ResultSet rs, Field<T> field) Fetch a record from a JDBCResultSet
and return the only contained value.fetchOptionalValue
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a single value.@NotNull Optional<?>
fetchOptionalValue
(SQL sql) Execute a new query holding plain SQL.<T> @NotNull Optional<T>
fetchOptionalValue
(TableField<?, T> field) Execute aResultQuery
in the context of thisDSLContext
and return a single value.<T> @NotNull Optional<T>
fetchOptionalValue
(TableField<?, T> field, Condition condition) Execute aResultQuery
in the context of thisDSLContext
and return a single value.@NotNull Record
fetchSingle
(String sql) Execute a new query holding plain SQL.@NotNull Record
fetchSingle
(String sql, Object... bindings) Execute a new query holding plain SQL.@NotNull Record
fetchSingle
(String sql, QueryPart... parts) Execute a new query holding plain SQL.@NotNull Record
fetchSingle
(ResultSet rs) @NotNull Record
fetchSingle
(ResultSet rs, Class<?>... types) @NotNull Record
fetchSingle
(ResultSet rs, DataType<?>... types) @NotNull Record
fetchSingle
(ResultSet rs, Field<?>... fields) @NotNull Record
fetchSingle
(Collection<? extends SelectField<?>> fields) Execute and return exactly one record for<R extends Record>
RfetchSingle
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a record.@NotNull Record
fetchSingle
(SelectField<?>... fields) Execute and return exactly one record for<T1> @NotNull Record1<T1>
fetchSingle
(SelectField<T1> field1) Execute and return exactly one record for<T1,
T2> @NotNull Record2<T1, T2> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2) Execute and return exactly one record for<T1,
T2, T3> @NotNull Record3<T1, T2, T3> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3) Execute and return exactly one record for<T1,
T2, T3, T4>
@NotNull Record4<T1,T2, T3, T4> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4) Execute and return exactly one record for<T1,
T2, T3, T4, T5>
@NotNull Record5<T1,T2, T3, T4, T5> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6>
@NotNull Record6<T1,T2, T3, T4, T5, T6> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7>
@NotNull Record7<T1,T2, T3, T4, T5, T6, T7> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull Record8<T1,T2, T3, T4, T5, T6, T7, T8> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull Record10<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull Record11<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull Record12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull Record13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull Record14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull Record15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull Record16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull Record17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull Record18<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull Record19<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull Record20<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull Record21<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull Record22<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22) Execute and return exactly one record for@NotNull Record
fetchSingle
(SQL sql) Execute a new query holding plain SQL.<R extends Record>
RfetchSingle
(Table<R> table) Execute and return exactly one record for<R extends Record>
RfetchSingle
(Table<R> table, Collection<? extends Condition> conditions) Execute and return exactly one record for<R extends Record>
RfetchSingle
(Table<R> table, Condition condition) Execute and return exactly one record for<R extends Record>
RfetchSingle
(Table<R> table, Condition... conditions) Execute and return exactly one record for<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RDisambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RDisambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21) Disambiguation overload offetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21, Condition c22) Disambiguation overload offetchSingle(Table, Condition...)
.fetchStream
(String sql) Execute a new query holding plain SQL and "lazily" return the generated result.fetchStream
(String sql, Object... bindings) Execute a new query holding plain SQL and "lazily" return the generated result.fetchStream
(String sql, QueryPart... parts) Execute a new query holding plain SQL and "lazily" return the generated result.fetchStream
(ResultSet rs) fetchStream
(ResultSet rs, Class<?>... types) fetchStream
(ResultSet rs, DataType<?>... types) fetchStream
(ResultSet rs, Field<?>... fields) fetchStream
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a stream.fetchStream
(SQL sql) Execute a new query holding plain SQL and "lazily" return the generated result.fetchStream
(Table<R> table) Execute and return all records lazily forfetchStream
(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records lazily forfetchStream
(Table<R> table, Condition condition) Execute and return all records lazily forfetchStream
(Table<R> table, Condition... conditions) Execute and return all records lazily for@Nullable Object
fetchValue
(String sql) Execute a new query holding plain SQL.@Nullable Object
fetchValue
(String sql, Object... bindings) Execute a new query holding plain SQL.@Nullable Object
fetchValue
(String sql, QueryPart... parts) Execute a new query holding plain SQL.@Nullable Object
fetchValue
(ResultSet rs) Fetch a record from a JDBCResultSet
and return the only contained value.<T> T
fetchValue
(ResultSet rs, Class<T> type) Fetch a record from a JDBCResultSet
and return the only contained value.<T> T
fetchValue
(ResultSet rs, DataType<T> type) Fetch a record from a JDBCResultSet
and return the only contained value.<T> T
fetchValue
(ResultSet rs, Field<T> field) Fetch a record from a JDBCResultSet
and return the only contained value.<T,
R extends Record1<T>>
TfetchValue
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a single value.<T> T
fetchValue
(SelectField<T> field) Execute aResultQuery
in the context of thisDSLContext
and return a single value.@Nullable Object
fetchValue
(SQL sql) Execute a new query holding plain SQL.<T> T
fetchValue
(Table<? extends Record1<T>> table) Fetch a single value from a single column table.<T> T
fetchValue
(TableField<?, T> field) Execute aResultQuery
in the context of thisDSLContext
and return a single value.<T> T
fetchValue
(TableField<?, T> field, Condition condition) Execute aResultQuery
in the context of thisDSLContext
and return a single value.@NotNull List<?>
fetchValues
(String sql) Execute a new query holding plain SQL.@NotNull List<?>
fetchValues
(String sql, Object... bindings) Execute a new query holding plain SQL.@NotNull List<?>
fetchValues
(String sql, QueryPart... parts) Execute a new query holding plain SQL.@NotNull List<?>
fetchValues
(ResultSet rs) Fetch a result from a JDBCResultSet
and return the only contained column's values.<T> @NotNull List<T>
fetchValues
(ResultSet rs, Class<T> type) Fetch a result from a JDBCResultSet
and return the only contained column's values.<T> @NotNull List<T>
fetchValues
(ResultSet rs, DataType<T> type) Fetch a result from a JDBCResultSet
and return the only contained column's values.<T> @NotNull List<T>
fetchValues
(ResultSet rs, Field<T> field) Fetch a result from a JDBCResultSet
and return the only contained column's values.fetchValues
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return all values for the only column.@NotNull List<?>
fetchValues
(SQL sql) Execute a new query holding plain SQL.<T> @NotNull List<T>
fetchValues
(Table<? extends Record1<T>> table) Fetch all values from a single column table.<T> @NotNull List<T>
fetchValues
(TableField<?, T> field) Fetch all values in a givenTable
'sTableField
.<T> @NotNull List<T>
fetchValues
(TableField<?, T> field, Condition condition) Fetch all values in a givenTable
'sTableField
.@NotNull GrantOnStep
grant
(Collection<? extends Privilege> privileges) TheGRANT
statement.@NotNull GrantOnStep
TheGRANT
statement.@NotNull GrantOnStep
TheGRANT
statement.@NotNull InformationSchema
informationSchema
(Catalog catalog) Convenience method forMeta.informationSchema()
.@NotNull InformationSchema
informationSchema
(Catalog... catalogs) Convenience method forMeta.informationSchema()
.@NotNull InformationSchema
informationSchema
(Schema schema) Convenience method forMeta.informationSchema()
.@NotNull InformationSchema
informationSchema
(Schema... schemas) Convenience method forMeta.informationSchema()
.@NotNull InformationSchema
informationSchema
(Table<?> table) Convenience method forMeta.informationSchema()
.@NotNull InformationSchema
informationSchema
(Table<?>... table) Convenience method forMeta.informationSchema()
.<R extends Record>
@NotNull InsertSetStep<R>insertInto
(Table<R> into) Create a new DSL insert statement.<R extends Record>
@NotNull InsertValuesStepN<R>insertInto
(Table<R> into, Collection<? extends Field<?>> fields) Create a new DSL insert statement.<R extends Record>
@NotNull InsertValuesStepN<R>insertInto
(Table<R> into, Field<?>... fields) Create a new DSL insert statement.<R extends Record,
T1>
@NotNull InsertValuesStep1<R,T1> insertInto
(Table<R> into, Field<T1> field1) Create a new DSL insert statement.<R extends Record,
T1, T2>
@NotNull InsertValuesStep2<R,T1, T2> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2) Create a new DSL insert statement.<R extends Record,
T1, T2, T3>
@NotNull InsertValuesStep3<R,T1, T2, T3> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4>
@NotNull InsertValuesStep4<R,T1, T2, T3, T4> Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5>
@NotNull InsertValuesStep5<R,T1, T2, T3, T4, T5> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6>
@NotNull InsertValuesStep6<R,T1, T2, T3, T4, T5, T6> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7>
@NotNull InsertValuesStep7<R,T1, T2, T3, T4, T5, T6, T7> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull InsertValuesStep8<R,T1, T2, T3, T4, T5, T6, T7, T8> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull InsertValuesStep9<R,T1, T2, T3, T4, T5, T6, T7, T8, T9> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull InsertValuesStep10<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull InsertValuesStep11<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull InsertValuesStep12<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull InsertValuesStep13<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull InsertValuesStep14<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull InsertValuesStep15<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull InsertValuesStep16<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull InsertValuesStep17<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull InsertValuesStep18<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull InsertValuesStep19<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull InsertValuesStep20<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull InsertValuesStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Create a new DSL insert statement.<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>
@NotNull InsertValuesStep22<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Create a new DSL insert statement.<R extends Record>
@NotNull InsertQuery<R>insertQuery
(Table<R> into) Create a newInsertQuery
@NotNull BigInteger
lastID()
Retrieve the last inserted ID.<R extends Record>
@NotNull LoaderOptionsStep<R>Create a newLoader
object to load data from a CSV or XML source.@Nullable Schema
Map a schema to another one.Map a table to another one.<R extends Record>
@NotNull MergeUsingStep<R>Create a new DSL SQL standard MERGE statement.<R extends Record>
@NotNull MergeKeyStepN<R>mergeInto
(Table<R> table, Collection<? extends Field<?>> fields) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record>
@NotNull MergeKeyStepN<R>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1>
@NotNull MergeKeyStep1<R,T1> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2>
@NotNull MergeKeyStep2<R,T1, T2> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3>
@NotNull MergeKeyStep3<R,T1, T2, T3> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4>
@NotNull MergeKeyStep4<R,T1, T2, T3, T4> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5>
@NotNull MergeKeyStep5<R,T1, T2, T3, T4, T5> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6>
@NotNull MergeKeyStep6<R,T1, T2, T3, T4, T5, T6> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7>
@NotNull MergeKeyStep7<R,T1, T2, T3, T4, T5, T6, T7> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull MergeKeyStep8<R,T1, T2, T3, T4, T5, T6, T7, T8> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull MergeKeyStep9<R,T1, T2, T3, T4, T5, T6, T7, T8, T9> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull MergeKeyStep10<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull MergeKeyStep11<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull MergeKeyStep12<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull MergeKeyStep13<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull MergeKeyStep14<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull MergeKeyStep15<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull MergeKeyStep16<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull MergeKeyStep17<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull MergeKeyStep18<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull MergeKeyStep19<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull MergeKeyStep20<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull MergeKeyStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
<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>
@NotNull MergeKeyStep22<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viamergeInto(Table)
@NotNull Meta
meta()
Access the database meta data.@NotNull Meta
Create meta data from a set of sources.@NotNull Meta
meta
(DatabaseMetaData meta) Access the database meta data from an explicit JDBCDatabaseMetaData
.@NotNull Meta
Access the database meta data from explicit catalog information.@NotNull Meta
Create meta data from a set of DDL queries.@NotNull Meta
Access the database meta data from explicit schema information.@NotNull Meta
Create meta data from a set of sources.@NotNull Meta
Access the database meta data from explicit table information.@NotNull Meta
meta
(InformationSchema schema) Access the database meta data from an explicit JAXB-annotated meta model.@NotNull Migrations
The experimental migrations API.void
mock
(MockDataProvider provider, MockRunnable mockable) Run aMockRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
's, and of aMockDataProvider
.<T> T
mockResult
(MockDataProvider provider, MockCallable<T> mockable) Run aMockRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
's, and of aMockDataProvider
and return themockable
's outcome.@NotNull Record
newRecord
(Collection<? extends Field<?>> fields) Create a new emptyRecord
.@NotNull Record
Create a new emptyRecord
.<T1> @NotNull Record1<T1>
Create a new emptyRecord
.<T1,
T2> @NotNull Record2<T1, T2> Create a new emptyRecord
.<T1,
T2, T3> @NotNull Record3<T1, T2, T3> Create a new emptyRecord
.<T1,
T2, T3, T4>
@NotNull Record4<T1,T2, T3, T4> Create a new emptyRecord
.<T1,
T2, T3, T4, T5>
@NotNull Record5<T1,T2, T3, T4, T5> Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6>
@NotNull Record6<T1,T2, T3, T4, T5, T6> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7>
@NotNull Record7<T1,T2, T3, T4, T5, T6, T7> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull Record8<T1,T2, T3, T4, T5, T6, T7, T8> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull Record10<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull Record11<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull Record12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull Record13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull Record14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull Record15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull Record16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull Record17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull Record18<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull Record19<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull Record20<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull Record21<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull Record22<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Create a new emptyRecord
.<R extends Record>
RCreate a newRecord
that can be inserted into the corresponding table.<R extends Record>
RCreate a new pre-filledRecord
that can be inserted into the corresponding table.<R extends UDTRecord<R>>
RCreate a newUDTRecord
.newResult
(Collection<? extends Field<?>> fields) Create a new emptyRecord
.Create a new emptyRecord
.Create a new emptyResult
.Create a new emptyResult
.Create a new emptyResult
.Create a new emptyResult
.Create a new emptyResult
.newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Create a new emptyResult
.newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Create a new emptyResult
.newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Create a new emptyResult
.newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Create a new emptyResult
.newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Create a new emptyResult
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull Result<Record11<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Create a new emptyResult
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull Result<Record12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Create a new emptyResult
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull Result<Record13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Create a new emptyResult
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull Result<Record14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Create a new emptyResult
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull Result<Record15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Create a new emptyResult
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull Result<Record16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Create a new emptyResult
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull Result<Record17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Create a new emptyResult
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull Result<Record18<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Create a new emptyResult
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull Result<Record19<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Create a new emptyResult
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull Result<Record20<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Create a new emptyResult
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull Result<Record21<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Create a new emptyResult
.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull Result<Record22<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Create a new emptyResult
.Create a new emptyResult
.@NotNull BigInteger
Convenience method to fetch the NEXTVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.@NotNull BigInteger
Convenience method to fetch the NEXTVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.<T extends Number>
TConvenience method to fetch the NEXTVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.Convenience method to fetch several NEXTVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.@NotNull Parser
parser()
Access the parser API.@NotNull Connection
A JDBC connection that runs each statement through theparser()
first, prior to re-generating and running the SQL.@NotNull io.r2dbc.spi.ConnectionFactory
An R2DBCConnectionFactory
that runs each statement through theparser()
first, prior to re-generating and running the SQL.@NotNull DataSource
A JDBC data source that runs each statement through theparser()
first, prior to re-generating and running the SQL.@NotNull Queries
queries
(Collection<? extends Query> queries) Wrap a collection of queries.@NotNull Queries
Wrap a collection of queries.@NotNull RowCountQuery
Create a new query holding plain SQL.@NotNull RowCountQuery
Create a new query holding plain SQL.@NotNull RowCountQuery
Create a new query holding plain SQL.@NotNull RowCountQuery
Create a new query holding plain SQL.@NotNull Query
releaseSavepoint
(String name) TheRELEASE SAVEPOINT
statement.@NotNull Query
releaseSavepoint
(Name name) TheRELEASE SAVEPOINT
statement.@NotNull String
Render a QueryPart in the context of thisDSLContext
.@NotNull RenderContext
Deprecated, for removal: This API element is subject to removal in a future version.- [#6280] - 3.10 - Do not reuse this method.@NotNull String
renderInlined
(QueryPart part) Render a QueryPart in the context of thisDSLContext
, inlining all bind variables.@NotNull String
Render a QueryPart in the context of thisDSLContext
, rendering bind variables as named parameters, or inlined parameters if they have no name.@NotNull String
renderNamedParams
(QueryPart part) Render a QueryPart in the context of thisDSLContext
, rendering bind variables as named parameters.@NotNull ResultQuery<Record>
resultQuery
(String sql) Create a new query holding plain SQL.@NotNull ResultQuery<Record>
resultQuery
(String sql, Object... bindings) Create a new query holding plain SQL.@NotNull ResultQuery<Record>
resultQuery
(String sql, QueryPart... parts) Create a new query holding plain SQL.@NotNull ResultQuery<Record>
resultQuery
(SQL sql) Create a new query holding plain SQL.@NotNull RevokeOnStep
revoke
(Collection<? extends Privilege> privileges) TheREVOKE
statement.@NotNull RevokeOnStep
TheREVOKE
statement.@NotNull RevokeOnStep
TheREVOKE
statement.@NotNull RevokeOnStep
revokeGrantOptionFor
(Collection<? extends Privilege> privileges) TheREVOKE GRANT OPTION FOR
statement.@NotNull RevokeOnStep
revokeGrantOptionFor
(Privilege privileges) TheREVOKE GRANT OPTION FOR
statement.@NotNull RevokeOnStep
revokeGrantOptionFor
(Privilege... privileges) TheREVOKE GRANT OPTION FOR
statement.@NotNull RollbackToSavepointStep
rollback()
TheROLLBACK
statement.@NotNull Query
TheSAVEPOINT
statement.@NotNull Query
TheSAVEPOINT
statement.@NotNull SelectSelectStep<Record>
select
(Collection<? extends SelectFieldOrAsterisk> fields) Create a new DSL select statement.<T1> @NotNull SelectSelectStep<Record1<T1>>
select
(SelectField<T1> field1) Create a new DSL select statement.<T1,
T2> @NotNull SelectSelectStep<Record2<T1, T2>> select
(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL select statement.<T1,
T2, T3> @NotNull SelectSelectStep<Record3<T1, T2, T3>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3) Create a new DSL select statement.<T1,
T2, T3, T4>
@NotNull SelectSelectStep<Record4<T1,T2, T3, T4>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4) Create a new DSL select statement.<T1,
T2, T3, T4, T5>
@NotNull SelectSelectStep<Record5<T1,T2, T3, T4, T5>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6>
@NotNull SelectSelectStep<Record6<T1,T2, T3, T4, T5, T6>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7>
@NotNull SelectSelectStep<Record7<T1,T2, T3, T4, T5, T6, T7>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull SelectSelectStep<Record8<T1,T2, T3, T4, T5, T6, T7, T8>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull SelectSelectStep<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull SelectSelectStep<Record10<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull SelectSelectStep<Record11<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull SelectSelectStep<Record12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull SelectSelectStep<Record13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull SelectSelectStep<Record14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull SelectSelectStep<Record15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull SelectSelectStep<Record16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull SelectSelectStep<Record17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull SelectSelectStep<Record18<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull SelectSelectStep<Record19<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull SelectSelectStep<Record20<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull SelectSelectStep<Record21<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull SelectSelectStep<Record22<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22) Create a new DSL select statement.@NotNull SelectSelectStep<Record>
select
(SelectFieldOrAsterisk... fields) Create a new DSL select statement.@NotNull SelectSelectStep<Record1<Integer>>
Create a new DSL select statement forCOUNT(*)
.@NotNull SelectSelectStep<Record>
selectDistinct
(Collection<? extends SelectFieldOrAsterisk> fields) Create a new DSL select statement.<T1> @NotNull SelectSelectStep<Record1<T1>>
selectDistinct
(SelectField<T1> field1) Create a new DSL select statement.<T1,
T2> @NotNull SelectSelectStep<Record2<T1, T2>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL select statement.<T1,
T2, T3> @NotNull SelectSelectStep<Record3<T1, T2, T3>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3) Create a new DSL select statement.<T1,
T2, T3, T4>
@NotNull SelectSelectStep<Record4<T1,T2, T3, T4>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4) Create a new DSL select statement.<T1,
T2, T3, T4, T5>
@NotNull SelectSelectStep<Record5<T1,T2, T3, T4, T5>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6>
@NotNull SelectSelectStep<Record6<T1,T2, T3, T4, T5, T6>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7>
@NotNull SelectSelectStep<Record7<T1,T2, T3, T4, T5, T6, T7>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull SelectSelectStep<Record8<T1,T2, T3, T4, T5, T6, T7, T8>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull SelectSelectStep<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull SelectSelectStep<Record10<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull SelectSelectStep<Record11<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull SelectSelectStep<Record12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull SelectSelectStep<Record13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull SelectSelectStep<Record14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull SelectSelectStep<Record15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull SelectSelectStep<Record16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull SelectSelectStep<Record17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull SelectSelectStep<Record18<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull SelectSelectStep<Record19<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull SelectSelectStep<Record20<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull SelectSelectStep<Record21<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull SelectSelectStep<Record22<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22) Create a new DSL select statement.@NotNull SelectSelectStep<Record>
selectDistinct
(SelectFieldOrAsterisk... fields) Create a new DSL select statement.@NotNull SelectWhereStep<Record>
selectFrom
(String sql) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
selectFrom
(String sql, Object... bindings) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
selectFrom
(String sql, QueryPart... parts) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
selectFrom
(Name table) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
selectFrom
(SQL sql) Create a new DSL select statement, projecting*
.<R extends Record>
@NotNull SelectWhereStep<R>selectFrom
(TableLike<R> table) Create a new DSL select statement, projecting the known columns from a table.@NotNull SelectSelectStep<Record1<Integer>>
Create a new DSL select statement for a constant1
literal.@NotNull SelectQuery<Record>
Create a newSelectQuery
<R extends Record>
@NotNull SelectQuery<R>selectQuery
(TableLike<R> table) Create a newSelectQuery
@NotNull SelectSelectStep<Record1<Integer>>
Create a new DSL select statement for a constant0
literal.@NotNull RowCountQuery
TheSET
statement.@NotNull RowCountQuery
TheSET
statement.@NotNull RowCountQuery
setCatalog
(String catalog) TheSET CATALOG
statement.@NotNull RowCountQuery
setCatalog
(Catalog catalog) TheSET CATALOG
statement.@NotNull RowCountQuery
setCatalog
(Name catalog) TheSET CATALOG
statement.@NotNull RowCountQuery
TheSET LOCAL
statement.@NotNull RowCountQuery
TheSET LOCAL
statement.@NotNull RowCountQuery
TheSET SCHEMA
statement.@NotNull RowCountQuery
TheSET SCHEMA
statement.@NotNull RowCountQuery
TheSET SCHEMA
statement.@NotNull Query
TheSTART TRANSACTION
statement.@NotNull Block
statements
(Collection<? extends Statement> statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;
, unless explicitly needed.@NotNull Block
statements
(Statement... statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;
, unless explicitly needed.void
transaction
(ContextTransactionalRunnable transactional) Run aContextTransactionalRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.transactionProvider()
.void
transaction
(TransactionalRunnable transactional) Run aTransactionalRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.transactionProvider()
.@NotNull CompletionStage<Void>
transactionAsync
(Executor executor, TransactionalRunnable transactional) Run aTransactionalRunnable
asynchronously.@NotNull CompletionStage<Void>
transactionAsync
(TransactionalRunnable transactional) Run aTransactionalRunnable
asynchronously.<T> @NotNull Publisher<T>
transactionPublisher
(TransactionalPublishable<T> transactional) Run aTransactionalPublishable
reactively.<T> T
transactionResult
(ContextTransactionalCallable<T> transactional) Run aContextTransactionalRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.transactionProvider()
, and return thetransactional
's outcome.<T> T
transactionResult
(TransactionalCallable<T> transactional) Run aTransactionalCallable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.transactionProvider()
, and return thetransactional
's outcome.<T> @NotNull CompletionStage<T>
transactionResultAsync
(Executor executor, TransactionalCallable<T> transactional) Run aTransactionalCallable
asynchronously.<T> @NotNull CompletionStage<T>
transactionResultAsync
(TransactionalCallable<T> transactional) Run aTransactionalCallable
asynchronously.@NotNull TruncateIdentityStep<Record>
TheTRUNCATE
statement.@NotNull TruncateIdentityStep<Record>
TheTRUNCATE
statement.<R extends Record>
@NotNull TruncateIdentityStep<R>TheTRUNCATE
statement.@NotNull TruncateIdentityStep<Record>
truncateTable
(String table) TheTRUNCATE TABLE
statement.@NotNull TruncateIdentityStep<Record>
truncateTable
(Name table) TheTRUNCATE TABLE
statement.<R extends Record>
@NotNull TruncateIdentityStep<R>truncateTable
(Table<R> table) TheTRUNCATE TABLE
statement.<R extends Record>
@NotNull UpdateSetFirstStep<R>Create a new DSL update statement.<R extends Record>
@NotNull UpdateQuery<R>updateQuery
(Table<R> table) Create a newUpdateQuery
@NotNull WithAsStep
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep1
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep2
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep3
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep4
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep5
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep6
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep7
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep8
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep9
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep10
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep11
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep12
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep13
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep14
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep15
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep16
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep17
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep18
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17, String fieldAlias18) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep19
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17, String fieldAlias18, String fieldAlias19) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep20
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17, String fieldAlias18, String fieldAlias19, String fieldAlias20) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep21
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17, String fieldAlias18, String fieldAlias19, String fieldAlias20, String fieldAlias21) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep22
with
(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17, String fieldAlias18, String fieldAlias19, String fieldAlias20, String fieldAlias21, String fieldAlias22) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep
with
(String alias, Collection<String> fieldAliases) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep
Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull WithAsStep
Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull WithStep
with
(Collection<? extends CommonTableExpression<?>> tables) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithStep
with
(CommonTableExpression<?>... tables) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep
with
(Name alias, Collection<? extends Name> fieldAliases) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep1
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep2
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep3
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep4
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep5
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep6
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep7
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep8
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep9
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep10
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep11
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep12
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep13
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep14
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep15
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep16
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep17
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep18
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep19
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep20
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep21
with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep22