java.lang.Object
org.jooq.impl.DefaultDSLContext
- All Implemented Interfaces:
Serializable
,DSLContext
,Scope
- Direct Known Subclasses:
DefaultCloseableDSLContext
A default implementation for
DSLContext
.
You may use this as a base implementation for custom DSLContext
subtypes preventing potential API breakage when upgrading jOOQ, or to
delegate DSL method calls to your custom implementations.
- Author:
- Lukas Eder
- See Also:
-
Constructor Summary
ConstructorDescriptionDefaultDSLContext
(io.r2dbc.spi.ConnectionFactory connectionFactory, SQLDialect dialect) DefaultDSLContext
(io.r2dbc.spi.ConnectionFactory connectionFactory, SQLDialect dialect, Settings settings) DefaultDSLContext
(Connection connection, SQLDialect dialect) DefaultDSLContext
(Connection connection, SQLDialect dialect, Settings settings) DefaultDSLContext
(DataSource datasource, SQLDialect dialect) DefaultDSLContext
(DataSource datasource, SQLDialect dialect, Settings settings) DefaultDSLContext
(Configuration configuration) DefaultDSLContext
(ConnectionProvider connectionProvider, SQLDialect dialect) DefaultDSLContext
(ConnectionProvider connectionProvider, SQLDialect dialect, Settings settings) DefaultDSLContext
(SQLDialect dialect) DefaultDSLContext
(SQLDialect dialect, Settings settings) -
Method Summary
Modifier and TypeMethodDescriptionalterDatabase
(String database) TheALTER DATABASE
statement.alterDatabase
(Catalog database) TheALTER DATABASE
statement.alterDatabase
(Name database) TheALTER DATABASE
statement.alterDatabaseIfExists
(String database) TheALTER DATABASE IF EXISTS
statement.alterDatabaseIfExists
(Catalog database) TheALTER DATABASE IF EXISTS
statement.alterDatabaseIfExists
(Name database) TheALTER DATABASE IF EXISTS
statement.<T> AlterDomainStep
<T> alterDomain
(String domain) TheALTER DOMAIN
statement.<T> AlterDomainStep
<T> alterDomain
(Domain<T> domain) TheALTER DOMAIN
statement.<T> AlterDomainStep
<T> alterDomain
(Name domain) TheALTER DOMAIN
statement.<T> AlterDomainStep
<T> alterDomainIfExists
(String domain) TheALTER DOMAIN IF EXISTS
statement.<T> AlterDomainStep
<T> alterDomainIfExists
(Domain<T> domain) TheALTER DOMAIN IF EXISTS
statement.<T> AlterDomainStep
<T> alterDomainIfExists
(Name domain) TheALTER DOMAIN IF EXISTS
statement.alterIndex
(String index) TheALTER INDEX
statement.alterIndex
(Index index) TheALTER INDEX
statement.alterIndex
(Name index) TheALTER INDEX
statement.alterIndexIfExists
(String index) TheALTER INDEX IF EXISTS
statement.alterIndexIfExists
(Index index) TheALTER INDEX IF EXISTS
statement.alterIndexIfExists
(Name index) TheALTER INDEX IF EXISTS
statement.alterMaterializedView
(String view) TheALTER MATERIALIZED VIEW
statement.alterMaterializedView
(Name view) TheALTER MATERIALIZED VIEW
statement.alterMaterializedView
(Table<?> view) TheALTER MATERIALIZED VIEW
statement.TheALTER MATERIALIZED VIEW IF EXISTS
statement.TheALTER MATERIALIZED VIEW IF EXISTS
statement.alterMaterializedViewIfExists
(Table<?> view) TheALTER MATERIALIZED VIEW IF EXISTS
statement.alterSchema
(String schema) TheALTER SCHEMA
statement.alterSchema
(Name schema) TheALTER SCHEMA
statement.alterSchema
(Schema schema) TheALTER SCHEMA
statement.alterSchemaIfExists
(String schema) TheALTER SCHEMA IF EXISTS
statement.alterSchemaIfExists
(Name schema) TheALTER SCHEMA IF EXISTS
statement.alterSchemaIfExists
(Schema schema) TheALTER SCHEMA IF EXISTS
statement.alterSequence
(String sequence) TheALTER SEQUENCE
statement.alterSequence
(Name sequence) TheALTER SEQUENCE
statement.<T extends Number>
AlterSequenceStep<T> alterSequence
(Sequence<T> sequence) TheALTER SEQUENCE
statement.alterSequenceIfExists
(String sequence) TheALTER SEQUENCE IF EXISTS
statement.alterSequenceIfExists
(Name sequence) TheALTER SEQUENCE IF EXISTS
statement.<T extends Number>
AlterSequenceStep<T> alterSequenceIfExists
(Sequence<T> sequence) TheALTER SEQUENCE IF EXISTS
statement.alterTable
(String table) Create a new DSLALTER TABLE
statement.alterTable
(Name table) Create a new DSLALTER TABLE
statement.alterTable
(Table<?> table) Create a new DSLALTER TABLE
statement.alterTableIfExists
(String table) Create a new DSLALTER TABLE
statement.alterTableIfExists
(Name table) Create a new DSLALTER TABLE
statement.alterTableIfExists
(Table<?> table) Create a new DSLALTER TABLE
statement.TheALTER TYPE
statement.TheALTER TYPE
statement.alterTypeIfExists
(String type) TheALTER TYPE IF EXISTS
statement.alterTypeIfExists
(Name type) TheALTER TYPE IF EXISTS
statement.TheALTER VIEW
statement.TheALTER VIEW
statement.TheALTER VIEW
statement.alterView
(Table<?> view, Collection<? extends Field<?>> fields) TheALTER VIEW
statement.TheALTER VIEW
statement.alterViewIfExists
(String view) TheALTER VIEW IF EXISTS
statement.alterViewIfExists
(Name view) TheALTER VIEW IF EXISTS
statement.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.Create a batch statement to execute a set of queries in batch mode (with bind values).Create a batch statement to execute a set of queries in batch mode (without bind values).Create a batch statement to execute a set of queries in batch mode (with bind values).batch
(Collection<? extends Query> queries) Create a batch statement to execute a set of queries in batch mode (without bind values).Create a batch statement to execute a set of queries in batch mode (without bind values).Create a batch statement to execute a set of queries in batch mode (with bind values).Create a batch statement to execute a set of queries in batch mode (without bind values).Create a batch statement to execute a set of queries in batch mode (with bind values).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.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.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.batchInsert
(TableRecord<?>... records) Create a batch statement to execute a set ofINSERT
queries in batch mode (with bind values) according toTableRecord.insert()
semantics.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.batchMerge
(UpdatableRecord<?>... records) Create a batch statement to execute a set ofMERGE
queries in batch mode (with bind values) according toUpdatableRecord.merge()
semantics.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.batchStore
(UpdatableRecord<?>... records) Create a batch statement to execute a set ofINSERT
andUPDATE
queries in batch mode (with bind values) according toUpdatableRecord.store()
semantics.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.batchUpdate
(UpdatableRecord<?>... records) Create a batch statement to execute a set ofUPDATE
queries in batch mode (with bind values) according toUpdatableRecord.update()
semantics.begin
(Collection<? extends Statement> statements) Wrap a collection of statements in an anoymous procedural block.Wrap a collection of statements in an anonymous procedural block.bindContext
(PreparedStatement stmt) Get a newBindContext
for the context of thisDSLContext
.TheCALL
statement.TheCALL
statement.commentOnColumn
(String field) TheCOMMENT ON COLUMN
statement.commentOnColumn
(Field<?> field) TheCOMMENT ON COLUMN
statement.commentOnColumn
(Name field) TheCOMMENT ON COLUMN
statement.TheCOMMENT ON MATERIALIZED VIEW
statement.TheCOMMENT ON MATERIALIZED VIEW
statement.commentOnMaterializedView
(Table<?> view) TheCOMMENT ON MATERIALIZED VIEW
statement.commentOnTable
(String table) TheCOMMENT ON TABLE
statement.commentOnTable
(Name table) TheCOMMENT ON TABLE
statement.commentOnTable
(Table<?> table) TheCOMMENT ON TABLE
statement.commentOnView
(String view) TheCOMMENT ON VIEW
statement.commentOnView
(Name view) TheCOMMENT ON VIEW
statement.commentOnView
(Table<?> view) TheCOMMENT ON VIEW
statement.commit()
TheCOMMIT
statement.final Configuration
The configuration of the current scope.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()
.createDatabase
(String database) TheCREATE DATABASE
statement.createDatabase
(Catalog database) TheCREATE DATABASE
statement.createDatabase
(Name database) TheCREATE DATABASE
statement.createDatabaseIfNotExists
(String database) TheCREATE DATABASE IF NOT EXISTS
statement.createDatabaseIfNotExists
(Catalog database) TheCREATE DATABASE IF NOT EXISTS
statement.createDatabaseIfNotExists
(Name database) TheCREATE DATABASE IF NOT EXISTS
statement.createDomain
(String domain) TheCREATE DOMAIN
statement.createDomain
(Domain<?> domain) TheCREATE DOMAIN
statement.createDomain
(Name domain) TheCREATE DOMAIN
statement.createDomainIfNotExists
(String domain) TheCREATE DOMAIN IF NOT EXISTS
statement.createDomainIfNotExists
(Domain<?> domain) TheCREATE DOMAIN IF NOT EXISTS
statement.createDomainIfNotExists
(Name domain) TheCREATE DOMAIN IF NOT EXISTS
statement.createFunction
(String function) TheCREATE FUNCTION
statement.createFunction
(Name function) TheCREATE FUNCTION
statement.createGlobalTemporaryTable
(String table) TheCREATE GLOBAL TEMPORARY TABLE
statement.createGlobalTemporaryTable
(Name table) TheCREATE GLOBAL TEMPORARY TABLE
statement.createGlobalTemporaryTable
(Table<?> table) TheCREATE GLOBAL TEMPORARY TABLE
statement.TheCREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS
statement.TheCREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS
statement.createGlobalTemporaryTableIfNotExists
(Table<?> table) TheCREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS
statement.TheCREATE INDEX
statement.createIndex
(String index) TheCREATE INDEX
statement.createIndex
(Index index) TheCREATE INDEX
statement.createIndex
(Name index) TheCREATE INDEX
statement.TheCREATE INDEX IF NOT EXISTS
statement.createIndexIfNotExists
(String index) TheCREATE INDEX IF NOT EXISTS
statement.createIndexIfNotExists
(Index index) TheCREATE INDEX IF NOT EXISTS
statement.createIndexIfNotExists
(Name index) TheCREATE INDEX IF NOT EXISTS
statement.createMaterializedView
(String view, String... fields) TheCREATE MATERIALIZED VIEW
statement.createMaterializedView
(String view, Collection<? extends String> fields) TheCREATE MATERIALIZED VIEW
statement.createMaterializedView
(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW
statement.createMaterializedView
(Name view, Name... fields) TheCREATE MATERIALIZED VIEW
statement.createMaterializedView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE MATERIALIZED VIEW
statement.createMaterializedView
(Table<?> view, Field<?>... fields) TheCREATE MATERIALIZED VIEW
statement.createMaterializedViewIfNotExists
(String view, String... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.createMaterializedViewIfNotExists
(String view, Collection<? extends String> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.createMaterializedViewIfNotExists
(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.createMaterializedViewIfNotExists
(Name view, Name... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.createMaterializedViewIfNotExists
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.createMaterializedViewIfNotExists
(Table<?> view, Field<?>... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.createOrReplaceFunction
(String function) TheCREATE OR REPLACE FUNCTION
statement.createOrReplaceFunction
(Name function) TheCREATE OR REPLACE FUNCTION
statement.createOrReplaceMaterializedView
(String view, String... fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.createOrReplaceMaterializedView
(String view, Collection<? extends String> fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.createOrReplaceMaterializedView
(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.createOrReplaceMaterializedView
(Name view, Name... fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.createOrReplaceMaterializedView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.createOrReplaceMaterializedView
(Table<?> view, Field<?>... fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.createOrReplaceProcedure
(String procedure) TheCREATE OR REPLACE PROCEDURE
statement.createOrReplaceProcedure
(Name procedure) TheCREATE OR REPLACE PROCEDURE
statement.createOrReplaceTrigger
(String trigger) TheCREATE OR REPLACE TRIGGER
statement.createOrReplaceTrigger
(Name trigger) TheCREATE OR REPLACE TRIGGER
statement.createOrReplaceTrigger
(Trigger trigger) TheCREATE OR REPLACE TRIGGER
statement.createOrReplaceView
(String view, String... fields) TheCREATE OR REPLACE VIEW
statement.createOrReplaceView
(String view, Collection<? extends String> fields) TheCREATE OR REPLACE VIEW
statement.createOrReplaceView
(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) Create a new DSLCREATE OR REPLACE VIEW
statement.createOrReplaceView
(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Create a new DSLCREATE OR REPLACE VIEW
statement.createOrReplaceView
(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE VIEW
statement.createOrReplaceView
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Create a new DSLCREATE OR REPLACE VIEW
statement.createOrReplaceView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Create a new DSLCREATE OR REPLACE VIEW
statement.createOrReplaceView
(Name view, Name... fields) TheCREATE OR REPLACE VIEW
statement.createOrReplaceView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE OR REPLACE VIEW
statement.createOrReplaceView
(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) Create a new DSLCREATE OR REPLACE VIEW
statement.createOrReplaceView
(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Create a new DSLCREATE OR REPLACE VIEW
statement.createOrReplaceView
(Table<?> view, Field<?>... fields) TheCREATE OR REPLACE VIEW
statement.createProcedure
(String procedure) TheCREATE PROCEDURE
statement.createProcedure
(Name procedure) TheCREATE PROCEDURE
statement.createSchema
(String schema) TheCREATE SCHEMA
statement.createSchema
(Name schema) TheCREATE SCHEMA
statement.createSchema
(Schema schema) TheCREATE SCHEMA
statement.createSchemaIfNotExists
(String schema) TheCREATE SCHEMA IF NOT EXISTS
statement.createSchemaIfNotExists
(Name schema) TheCREATE SCHEMA IF NOT EXISTS
statement.createSchemaIfNotExists
(Schema schema) TheCREATE SCHEMA IF NOT EXISTS
statement.createSequence
(String sequence) TheCREATE SEQUENCE
statement.createSequence
(Name sequence) TheCREATE SEQUENCE
statement.createSequence
(Sequence<?> sequence) TheCREATE SEQUENCE
statement.createSequenceIfNotExists
(String sequence) TheCREATE SEQUENCE IF NOT EXISTS
statement.createSequenceIfNotExists
(Name sequence) TheCREATE SEQUENCE IF NOT EXISTS
statement.createSequenceIfNotExists
(Sequence<?> sequence) TheCREATE SEQUENCE IF NOT EXISTS
statement.createTable
(String table) TheCREATE TABLE
statement.createTable
(Name table) TheCREATE TABLE
statement.createTable
(Table<?> table) TheCREATE TABLE
statement.createTableIfNotExists
(String table) TheCREATE TABLE IF NOT EXISTS
statement.createTableIfNotExists
(Name table) TheCREATE TABLE IF NOT EXISTS
statement.createTableIfNotExists
(Table<?> table) TheCREATE TABLE IF NOT EXISTS
statement.createTemporaryTable
(String table) TheCREATE TEMPORARY TABLE
statement.createTemporaryTable
(Name table) TheCREATE TEMPORARY TABLE
statement.createTemporaryTable
(Table<?> table) TheCREATE TEMPORARY TABLE
statement.TheCREATE TEMPORARY TABLE IF NOT EXISTS
statement.TheCREATE TEMPORARY TABLE IF NOT EXISTS
statement.createTemporaryTableIfNotExists
(Table<?> table) TheCREATE TEMPORARY TABLE IF NOT EXISTS
statement.createTrigger
(String trigger) TheCREATE TRIGGER
statement.createTrigger
(Name trigger) TheCREATE TRIGGER
statement.createTrigger
(Trigger trigger) TheCREATE TRIGGER
statement.createType
(String type) TheCREATE TYPE
statement.createType
(Name type) TheCREATE TYPE
statement.createType
(Type<?> type) TheCREATE TYPE
statement.createTypeIfNotExists
(String type) TheCREATE TYPE IF NOT EXISTS
statement.createTypeIfNotExists
(Name type) TheCREATE TYPE IF NOT EXISTS
statement.createTypeIfNotExists
(Type<?> type) TheCREATE TYPE IF NOT EXISTS
statement.TheCREATE UNIQUE INDEX
statement.createUniqueIndex
(String index) TheCREATE UNIQUE INDEX
statement.createUniqueIndex
(Index index) TheCREATE UNIQUE INDEX
statement.createUniqueIndex
(Name index) TheCREATE UNIQUE INDEX
statement.TheCREATE UNIQUE INDEX IF NOT EXISTS
statement.TheCREATE UNIQUE INDEX IF NOT EXISTS
statement.TheCREATE UNIQUE INDEX IF NOT EXISTS
statement.createUniqueIndexIfNotExists
(Name index) TheCREATE UNIQUE INDEX IF NOT EXISTS
statement.createView
(String view, String... fields) TheCREATE VIEW
statement.createView
(String view, Collection<? extends String> fields) TheCREATE VIEW
statement.createView
(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) Create a new DSLCREATE VIEW
statement.createView
(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Create a new DSLCREATE VIEW
statement.createView
(Name view, Collection<? extends Name> fields) TheCREATE VIEW
statement.createView
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Create a new DSLCREATE VIEW
statement.createView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Create a new DSLCREATE VIEW
statement.createView
(Name view, Name... fields) TheCREATE VIEW
statement.createView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE VIEW
statement.createView
(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) Create a new DSLCREATE VIEW
statement.createView
(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Create a new DSLCREATE VIEW
statement.createView
(Table<?> view, Field<?>... fields) TheCREATE VIEW
statement.createViewIfNotExists
(String view, String... fields) TheCREATE VIEW IF NOT EXISTS
statement.createViewIfNotExists
(String view, Collection<? extends String> fields) TheCREATE VIEW IF NOT EXISTS
statement.createViewIfNotExists
(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) Create a new DSLCREATE VIEW
statement.createViewIfNotExists
(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Create a new DSLCREATE VIEW
statement.createViewIfNotExists
(Name view, Collection<? extends Name> fields) TheCREATE VIEW IF NOT EXISTS
statement.createViewIfNotExists
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Create a new DSLCREATE VIEW
statement.createViewIfNotExists
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Create a new DSLCREATE VIEW
statement.createViewIfNotExists
(Name view, Name... fields) TheCREATE VIEW IF NOT EXISTS
statement.createViewIfNotExists
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE VIEW IF NOT EXISTS
statement.createViewIfNotExists
(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) Create a new DSLCREATE VIEW
statement.createViewIfNotExists
(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Create a new DSLCREATE VIEW
statement.createViewIfNotExists
(Table<?> view, Field<?>... fields) TheCREATE VIEW IF NOT EXISTS
statement.final Instant
The time, according toConfiguration.clock()
, when thisScope
was created.Convenience method to fetch the CURRVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.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
.data()
Get all custom data from thisScope
.final Object
Get some custom data from thisScope
.final Object
Set some custom data to thisScope
.ddl
(Collection<? extends Table<?>> tables) Convenience method forMeta.ddl()
.ddl
(Collection<? extends Table<?>> tables, DDLExportConfiguration exportConfiguration) Convenience method forMeta.ddl(DDLExportConfiguration)
.ddl
(Collection<? extends Table<?>> tables, DDLFlag... flags) Convenience method forMeta.ddl(DDLExportConfiguration)
.Convenience method forMeta.ddl()
.ddl
(Catalog catalog, DDLExportConfiguration exportConfiguration) Convenience method forMeta.ddl(DDLExportConfiguration)
.Convenience method forMeta.ddl(DDLExportConfiguration)
.Convenience method forMeta.ddl()
.ddl
(Schema schema, DDLExportConfiguration exportConfiguration) Convenience method forMeta.ddl(DDLExportConfiguration)
.Convenience method forMeta.ddl(DDLExportConfiguration)
.Convenience method forMeta.ddl()
.ddl
(Table[] tables, DDLExportConfiguration exportConfiguration) Convenience method forMeta.ddl(DDLExportConfiguration)
.Convenience method forMeta.ddl(DDLExportConfiguration)
.Convenience method forMeta.ddl()
.ddl
(Table<?> table, DDLExportConfiguration exportConfiguration) Convenience method forMeta.ddl(DDLExportConfiguration)
.Convenience method forMeta.ddl(DDLExportConfiguration)
.<R extends Record>
DeleteUsingStep<R> Create a new DSL delete statement.<R extends Record>
DeleteUsingStep<R> deleteFrom
(Table<R> table) Create a new DSL delete statement.<R extends Record>
DeleteQuery<R> deleteQuery
(Table<R> table) Create a newDeleteQuery
A JDBC connection that proxies the underlying connection to run the jOOQ Diagnostics Pack on executed queries.A JDBC connection that proxies the underlying connection to run the jOOQ Diagnostics Pack on executed queries.final SQLDialect
dialect()
TheSQLDialect
wrapped by this context.dropDatabase
(String database) TheDROP DATABASE
statement.dropDatabase
(Catalog database) TheDROP DATABASE
statement.dropDatabase
(Name database) TheDROP DATABASE
statement.dropDatabaseIfExists
(String database) TheDROP DATABASE IF EXISTS
statement.dropDatabaseIfExists
(Catalog database) TheDROP DATABASE IF EXISTS
statement.dropDatabaseIfExists
(Name database) TheDROP DATABASE IF EXISTS
statement.dropDomain
(String domain) TheDROP DOMAIN
statement.dropDomain
(Domain<?> domain) TheDROP DOMAIN
statement.dropDomain
(Name domain) TheDROP DOMAIN
statement.dropDomainIfExists
(String domain) TheDROP DOMAIN IF EXISTS
statement.dropDomainIfExists
(Domain<?> domain) TheDROP DOMAIN IF EXISTS
statement.dropDomainIfExists
(Name domain) TheDROP DOMAIN IF EXISTS
statement.dropFunction
(String function) TheDROP FUNCTION
statement.dropFunction
(Name function) TheDROP FUNCTION
statement.dropFunctionIfExists
(String function) TheDROP FUNCTION IF EXISTS
statement.dropFunctionIfExists
(Name function) TheDROP FUNCTION IF EXISTS
statement.TheDROP INDEX
statement.TheDROP INDEX
statement.TheDROP INDEX
statement.dropIndexIfExists
(String index) TheDROP INDEX IF EXISTS
statement.dropIndexIfExists
(Index index) TheDROP INDEX IF EXISTS
statement.dropIndexIfExists
(Name index) TheDROP INDEX IF EXISTS
statement.dropMaterializedView
(String view) TheDROP MATERIALIZED VIEW
statement.dropMaterializedView
(Name view) TheDROP MATERIALIZED VIEW
statement.dropMaterializedView
(Table<?> view) TheDROP MATERIALIZED VIEW
statement.TheDROP MATERIALIZED VIEW IF EXISTS
statement.TheDROP MATERIALIZED VIEW IF EXISTS
statement.dropMaterializedViewIfExists
(Table<?> view) TheDROP MATERIALIZED VIEW IF EXISTS
statement.dropProcedure
(String procedure) TheDROP PROCEDURE
statement.dropProcedure
(Name procedure) TheDROP PROCEDURE
statement.dropProcedureIfExists
(String procedure) TheDROP PROCEDURE IF EXISTS
statement.dropProcedureIfExists
(Name procedure) TheDROP PROCEDURE IF EXISTS
statement.dropSchema
(String schema) TheDROP SCHEMA
statement.dropSchema
(Name schema) TheDROP SCHEMA
statement.dropSchema
(Schema schema) TheDROP SCHEMA
statement.dropSchemaIfExists
(String schema) TheDROP SCHEMA IF EXISTS
statement.dropSchemaIfExists
(Name schema) TheDROP SCHEMA IF EXISTS
statement.dropSchemaIfExists
(Schema schema) TheDROP SCHEMA IF EXISTS
statement.dropSequence
(String sequence) TheDROP SEQUENCE
statement.dropSequence
(Name sequence) TheDROP SEQUENCE
statement.dropSequence
(Sequence<?> sequence) TheDROP SEQUENCE
statement.dropSequenceIfExists
(String sequence) TheDROP SEQUENCE IF EXISTS
statement.dropSequenceIfExists
(Name sequence) TheDROP SEQUENCE IF EXISTS
statement.dropSequenceIfExists
(Sequence<?> sequence) TheDROP SEQUENCE IF EXISTS
statement.TheDROP TABLE
statement.TheDROP TABLE
statement.TheDROP TABLE
statement.dropTableIfExists
(String table) TheDROP TABLE IF EXISTS
statement.dropTableIfExists
(Name table) TheDROP TABLE IF EXISTS
statement.dropTableIfExists
(Table<?> table) TheDROP TABLE IF EXISTS
statement.dropTemporaryTable
(String table) TheDROP TEMPORARY TABLE
statement.dropTemporaryTable
(Name table) TheDROP TEMPORARY TABLE
statement.dropTemporaryTable
(Table<?> table) TheDROP TEMPORARY TABLE
statement.dropTemporaryTableIfExists
(String table) TheDROP TEMPORARY TABLE IF EXISTS
statement.dropTemporaryTableIfExists
(Name table) TheDROP TEMPORARY TABLE IF EXISTS
statement.dropTemporaryTableIfExists
(Table<?> table) TheDROP TEMPORARY TABLE IF EXISTS
statement.dropTrigger
(String trigger) TheDROP TRIGGER
statement.dropTrigger
(Name trigger) TheDROP TRIGGER
statement.dropTrigger
(Trigger trigger) TheDROP TRIGGER
statement.dropTriggerIfExists
(String trigger) TheDROP TRIGGER IF EXISTS
statement.dropTriggerIfExists
(Name trigger) TheDROP TRIGGER IF EXISTS
statement.dropTriggerIfExists
(Trigger trigger) TheDROP TRIGGER IF EXISTS
statement.TheDROP TYPE
statement.TheDROP TYPE
statement.dropType
(Collection<? extends Type<?>> types) TheDROP TYPE
statement.TheDROP TYPE
statement.TheDROP TYPE
statement.TheDROP TYPE
statement.TheDROP TYPE
statement.dropTypeIfExists
(String types) TheDROP TYPE IF EXISTS
statement.dropTypeIfExists
(String... types) TheDROP TYPE IF EXISTS
statement.dropTypeIfExists
(Collection<? extends Type<?>> types) TheDROP TYPE IF EXISTS
statement.dropTypeIfExists
(Name types) TheDROP TYPE IF EXISTS
statement.dropTypeIfExists
(Name... types) TheDROP TYPE IF EXISTS
statement.dropTypeIfExists
(Type<?> types) TheDROP TYPE IF EXISTS
statement.dropTypeIfExists
(Type<?>... types) TheDROP TYPE IF EXISTS
statement.TheDROP VIEW
statement.TheDROP VIEW
statement.TheDROP VIEW
statement.dropViewIfExists
(String view) TheDROP VIEW IF EXISTS
statement.dropViewIfExists
(Name view) TheDROP VIEW IF EXISTS
statement.dropViewIfExists
(Table<?> view) TheDROP VIEW IF EXISTS
statement.final DSLContext
dsl()
Wrap theScope.configuration()
in aDSLContext
, providing access to the configuration-contextual DSL to construct executable queries.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.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
.Param
<?> extractParam
(QueryPart part, String name) Get a named parameter from aQueryPart
, provided its name.extractParams
(QueryPart part) Get aMap
of named parameters.final SQLDialect
family()
TheSQLDialect.family()
wrapped by this context.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 forfetchAsync
(String sql) Fetch results in a newCompletionStage
.fetchAsync
(String sql, Object... bindings) Fetch results in a newCompletionStage
.fetchAsync
(String sql, QueryPart... parts) Fetch results in a newCompletionStage
.fetchAsync
(ResultSet rs) Fetch results in a newCompletionStage
.fetchAsync
(ResultSet rs, Class<?>... types) Fetch results in a newCompletionStage
.fetchAsync
(ResultSet rs, DataType<?>... types) Fetch results in a newCompletionStage
.fetchAsync
(ResultSet rs, Field<?>... fields) Fetch results in a newCompletionStage
.fetchAsync
(Executor executor, String sql) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.fetchAsync
(Executor executor, String sql, Object... bindings) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.fetchAsync
(Executor executor, String sql, QueryPart... parts) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.fetchAsync
(Executor executor, ResultSet rs) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.fetchAsync
(Executor executor, ResultSet rs, Class<?>... types) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.fetchAsync
(Executor executor, ResultSet rs, DataType<?>... types) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.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>
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.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>
CompletionStage<Result<R>> fetchAsync
(Executor executor, Table<R> table) Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>> fetchAsync
(Executor executor, Table<R> table, Collection<? extends Condition> conditions) Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>> fetchAsync
(Executor executor, Table<R> table, Condition condition) Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>> fetchAsync
(Executor executor, Table<R> table, Condition... conditions) Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>> fetchAsync
(ResultQuery<R> query) Fetch results in a newCompletionStage
.fetchAsync
(SQL sql) Fetch results in a newCompletionStage
.<R extends Record>
CompletionStage<Result<R>> fetchAsync
(Table<R> table) Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>> fetchAsync
(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>> fetchAsync
(Table<R> table, Condition condition) Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>> fetchAsync
(Table<R> table, Condition... conditions) Execute and return all records asynchronously for<R extends TableRecord<R>>
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[]... strings) Fetch all data from a list of strings.fetchFromStringData
(List<String[]> strings) Fetch all data from a list of strings.fetchFromStringData
(List<String[]> strings, 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 forExecute a new query holding plain SQL, possibly returning several result sets.Execute a new query holding plain SQL, possibly returning several result sets.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.Execute a new query holding plain SQL, possibly returning several result sets.<K,
V> 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.Execute a new query holding plain SQL.Execute a new query holding plain SQL.Execute a new query holding plain SQL.<R extends Record>
RfetchOne
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a 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 forOptional
<?> fetchOptionalValue
(String sql) Execute a new query holding plain SQL.Optional
<?> fetchOptionalValue
(String sql, Object... bindings) Execute a new query holding plain SQL.Optional
<?> fetchOptionalValue
(String sql, QueryPart... parts) Execute a new query holding plain SQL.Optional
<?> Fetch a record from a JDBCResultSet
and return the only contained value.<T> Optional
<T> fetchOptionalValue
(ResultSet rs, Class<T> type) Fetch a record from a JDBCResultSet
and return the only contained value.<T> Optional
<T> fetchOptionalValue
(ResultSet rs, DataType<T> type) Fetch a record from a JDBCResultSet
and return the only contained value.<T> 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.Optional
<?> fetchOptionalValue
(SQL sql) Execute a new query holding plain SQL.<T> Optional
<T> fetchOptionalValue
(TableField<?, T> field) Execute aResultQuery
in the context of thisDSLContext
and return a single value.<T> Optional
<T> fetchOptionalValue
(TableField<?, T> field, Condition condition) Execute aResultQuery
in the context of thisDSLContext
and return a single value.fetchSingle
(String sql) Execute a new query holding plain SQL.fetchSingle
(String sql, Object... bindings) Execute a new query holding plain SQL.fetchSingle
(String sql, QueryPart... parts) Execute a new query holding plain SQL.fetchSingle
(ResultSet rs) fetchSingle
(ResultSet rs, Class<?>... types) fetchSingle
(ResultSet rs, DataType<?>... types) fetchSingle
(ResultSet rs, Field<?>... fields) 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.fetchSingle
(SelectField<?>... fields) Execute and return exactly one record for<T1> Record1
<T1> fetchSingle
(SelectField<T1> field1) Execute and return exactly one record for<T1,
T2> Record2 <T1, T2> fetchSingle
(SelectField<T1> field1, SelectField<T2> field2) Execute and return exactly one record for<T1,
T2, T3>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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 forfetchSingle
(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 ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDisambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDisambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RfetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6) Disambiguation overload ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 ofDSLContext.fetchSingle(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 forfetchValue
(String sql) Execute a new query holding plain SQL.fetchValue
(String sql, Object... bindings) Execute a new query holding plain SQL.fetchValue
(String sql, QueryPart... parts) Execute a new query holding plain SQL.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.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.List
<?> fetchValues
(String sql) Execute a new query holding plain SQL.List
<?> fetchValues
(String sql, Object... bindings) Execute a new query holding plain SQL.List
<?> fetchValues
(String sql, QueryPart... parts) Execute a new query holding plain SQL.List
<?> fetchValues
(ResultSet rs) Fetch a result from a JDBCResultSet
and return the only contained column's values.<T> List
<T> fetchValues
(ResultSet rs, Class<T> type) Fetch a result from a JDBCResultSet
and return the only contained column's values.<T> List
<T> fetchValues
(ResultSet rs, DataType<T> type) Fetch a result from a JDBCResultSet
and return the only contained column's values.<T> 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.List
<?> fetchValues
(SQL sql) Execute a new query holding plain SQL.<T> List
<T> fetchValues
(Table<? extends Record1<T>> table) Fetch all values from a single column table.<T> List
<T> fetchValues
(TableField<?, T> field) Fetch all values in a givenTable
'sTableField
.<T> List
<T> fetchValues
(TableField<?, T> field, Condition condition) Fetch all values in a givenTable
'sTableField
.grant
(Collection<? extends Privilege> privileges) TheGRANT
statement.TheGRANT
statement.TheGRANT
statement.informationSchema
(Catalog catalog) Convenience method forMeta.informationSchema()
.informationSchema
(Catalog... catalogs) Convenience method forMeta.informationSchema()
.informationSchema
(Schema schema) Convenience method forMeta.informationSchema()
.informationSchema
(Schema... schemas) Convenience method forMeta.informationSchema()
.informationSchema
(Table<?> table) Convenience method forMeta.informationSchema()
.informationSchema
(Table<?>... tables) Convenience method forMeta.informationSchema()
.<R extends Record>
InsertSetStep<R> insertInto
(Table<R> into) Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R> insertInto
(Table<R> into, Collection<? extends Field<?>> fields) Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R> insertInto
(Table<R> into, Field<?>... fields) Create a new DSL insert statement.<R extends Record,
T1>
InsertValuesStep1<R, T1> insertInto
(Table<R> into, Field<T1> field1) Create a new DSL insert statement.<R extends Record,
T1, T2>
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>
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>
InsertValuesStep4<R, T1, T2, T3, T4> Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
InsertQuery<R> insertQuery
(Table<R> into) Create a newInsertQuery
lastID()
Retrieve the last inserted ID.<R extends Record>
LoaderOptionsStep<R> Create a newLoader
object to load data from a CSV or XML source.Map a schema to another one.Map a table to another one.<R extends Record>
MergeUsingStep<R> Create a new DSL SQL standard MERGE statement.<R extends Record>
MergeKeyStepN<R> mergeInto
(Table<R> table, Collection<? extends Field<?>> fields) Create a new DSL merge statement (H2-specific syntax).<R extends Record>
MergeKeyStepN<R> <R extends Record,
T1>
MergeKeyStep1<R, T1> Deprecated, for removal: This API element is subject to removal in a future version.<R extends Record,
T1, T2>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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)
meta()
Access the database meta data.Create meta data from a set of sources.meta
(DatabaseMetaData meta) Access the database meta data from an explicit JDBCDatabaseMetaData
.Access the database meta data from explicit catalog information.Create meta data from a set of DDL queries.Access the database meta data from explicit schema information.Create meta data from a set of sources.Access the database meta data from explicit table information.meta
(InformationSchema schema) Access the database meta data from an explicit JAXB-annotated meta model.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.newRecord
(Collection<? extends Field<?>> fields) Create a new emptyRecord
.Create a new emptyRecord
.<T1> Record1
<T1> Create a new emptyRecord
.<T1,
T2> Record2 <T1, T2> Create a new emptyRecord
.<T1,
T2, T3>
Record3<T1, T2, T3> Create a new emptyRecord
.<T1,
T2, T3, T4>
Record4<T1, T2, T3, T4> Create a new emptyRecord
.<T1,
T2, T3, T4, T5>
Record5<T1, T2, T3, T4, T5> Create a new emptyRecord
.<T1,
T2, T3, T4, T5, T6>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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
.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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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
.Convenience method to fetch the NEXTVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.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
.parser()
Access the parser API.A JDBC connection that runs each statement through theDSLContext.parser()
first, prior to re-generating and running the SQL.io.r2dbc.spi.ConnectionFactory
An R2DBCConnectionFactory
that runs each statement through theDSLContext.parser()
first, prior to re-generating and running the SQL.A JDBC data source that runs each statement through theDSLContext.parser()
first, prior to re-generating and running the SQL.queries
(Collection<? extends Query> queries) Wrap a collection of queries.Wrap a collection of queries.Create a new query holding plain SQL.Create a new query holding plain SQL.Create a new query holding plain SQL.Create a new query holding plain SQL.releaseSavepoint
(String name) TheRELEASE SAVEPOINT
statement.releaseSavepoint
(Name name) TheRELEASE SAVEPOINT
statement.Render a QueryPart in the context of thisDSLContext
.Get a newRenderContext
for the context of thisDSLContext
.renderInlined
(QueryPart part) Render a QueryPart in the context of thisDSLContext
, inlining all bind variables.Render a QueryPart in the context of thisDSLContext
, rendering bind variables as named parameters, or inlined parameters if they have no name.renderNamedParams
(QueryPart part) Render a QueryPart in the context of thisDSLContext
, rendering bind variables as named parameters.resultQuery
(String sql) Create a new query holding plain SQL.resultQuery
(String sql, Object... bindings) Create a new query holding plain SQL.resultQuery
(String sql, QueryPart... parts) Create a new query holding plain SQL.resultQuery
(SQL sql) Create a new query holding plain SQL.revoke
(Collection<? extends Privilege> privileges) TheREVOKE
statement.TheREVOKE
statement.TheREVOKE
statement.revokeGrantOptionFor
(Collection<? extends Privilege> privileges) TheREVOKE GRANT OPTION FOR
statement.revokeGrantOptionFor
(Privilege privileges) TheREVOKE GRANT OPTION FOR
statement.revokeGrantOptionFor
(Privilege... privileges) TheREVOKE GRANT OPTION FOR
statement.rollback()
TheROLLBACK
statement.TheSAVEPOINT
statement.TheSAVEPOINT
statement.select
(Collection<? extends SelectFieldOrAsterisk> fields) Create a new DSL select statement.<T1> SelectSelectStep
<Record1<T1>> select
(SelectField<T1> field1) Create a new DSL select statement.<T1,
T2> SelectSelectStep <Record2<T1, T2>> select
(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL select statement.<T1,
T2, T3>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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.select
(SelectFieldOrAsterisk... fields) Create a new DSL select statement.Create a new DSL select statement forCOUNT(*)
.selectDistinct
(Collection<? extends SelectFieldOrAsterisk> fields) Create a new DSL select statement.<T1> SelectSelectStep
<Record1<T1>> selectDistinct
(SelectField<T1> field1) Create a new DSL select statement.<T1,
T2> SelectSelectStep <Record2<T1, T2>> selectDistinct
(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL select statement.<T1,
T2, T3>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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.selectDistinct
(SelectFieldOrAsterisk... fields) Create a new DSL select statement.selectFrom
(String sql) Create a new DSL select statement, projecting*
.selectFrom
(String sql, Object... bindings) Create a new DSL select statement, projecting*
.selectFrom
(String sql, QueryPart... parts) Create a new DSL select statement, projecting*
.selectFrom
(Name table) Create a new DSL select statement, projecting*
.selectFrom
(SQL sql) Create a new DSL select statement, projecting*
.<R extends Record>
SelectWhereStep<R> selectFrom
(TableLike<R> table) Create a new DSL select statement, projecting the known columns from a table.Create a new DSL select statement for a constant1
literal.Create a newSelectQuery
<R extends Record>
SelectQuery<R> selectQuery
(TableLike<R> table) Create a newSelectQuery
Create a new DSL select statement for a constant0
literal.TheSET
statement.TheSET
statement.setCatalog
(String catalog) TheSET CATALOG
statement.setCatalog
(Catalog catalog) TheSET CATALOG
statement.setCatalog
(Name catalog) TheSET CATALOG
statement.TheSET LOCAL
statement.TheSET LOCAL
statement.TheSET SCHEMA
statement.TheSET SCHEMA
statement.TheSET SCHEMA
statement.final Settings
settings()
The settings wrapped by this context.TheSTART TRANSACTION
statement.statements
(Collection<? extends Statement> statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;
, unless explicitly needed.statements
(Statement... statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;
, unless explicitly needed.toString()
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()
.transactionAsync
(Executor executor, TransactionalRunnable transactional) Run aTransactionalRunnable
asynchronously.transactionAsync
(TransactionalRunnable transactional) Run aTransactionalRunnable
asynchronously.<T> 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> CompletionStage
<T> transactionResultAsync
(Executor executor, TransactionalCallable<T> transactional) Run aTransactionalCallable
asynchronously.<T> CompletionStage
<T> transactionResultAsync
(TransactionalCallable<T> transactional) Run aTransactionalCallable
asynchronously.TheTRUNCATE
statement.TheTRUNCATE
statement.truncate
(Collection<? extends Table<?>> table) TheTRUNCATE
statement.TheTRUNCATE
statement.TheTRUNCATE
statement.TheTRUNCATE
statement.<R extends Record>
TruncateIdentityStep<R> TheTRUNCATE
statement.truncateTable
(String table) TheTRUNCATE TABLE
statement.truncateTable
(String... table) TheTRUNCATE TABLE
statement.truncateTable
(Collection<? extends Table<?>> table) TheTRUNCATE TABLE
statement.truncateTable
(Name table) TheTRUNCATE TABLE
statement.truncateTable
(Name... table) TheTRUNCATE TABLE
statement.truncateTable
(Table<?>... table) TheTRUNCATE TABLE
statement.<R extends Record>
TruncateIdentityStep<R> truncateTable
(Table<R> table) TheTRUNCATE TABLE
statement.<R extends Record>
UpdateSetFirstStep<R> Create a new DSL update statement.<R extends Record>
UpdateQuery<R> updateQuery
(Table<R> table) Create a newUpdateQuery
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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.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.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.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.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.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.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.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.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.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.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.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.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.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.
mergeInto(Table)