Module org.jooq

Package org.jooq

Interface DSLContext

All Superinterfaces:

Scope

All Known Subinterfaces:

CloseableDSLContext

All Known Implementing Classes:

DefaultCloseableDSLContext, DefaultDSLContext

public interface DSLContext
extends Scope

A contextual DSL providing "attached" implementations to the org.jooq interfaces.

Apart from the DSL, this contextual DSL is the main entry point for client code, to access jOOQ classes and functionality that are related to Query execution. Unlike objects created through the DSL type, objects created from a DSLContext will be "attached" to the DSLContext's Scope.configuration(), such that they can be executed immediately in a fluent style. An example is given here:

 DSLContext create = DSL.using(connection, dialect);

 // Immediately fetch results after constructing a query
 create.selectFrom(MY_TABLE).where(MY_TABLE.ID.eq(1)).fetch();

 // The above is equivalent to this "non-fluent" style
 create.fetch(DSL.selectFrom(MY_TABLE).where(MY_TABLE.ID.eq(1)));
 

The DSL provides convenient constructors to create a Configuration, which will be shared among all Query objects thus created. Optionally, you can pass a reusable Configuration to the DSL.using(Configuration) constructor. Please consider thread-safety concerns documented in Configuration, should you want to reuse the same Configuration instance in various threads and / or transactions.

DSLContext is a Scope type, mostly for convenience access to its underlying Configuration properties, including the Scope.data() map, which it shares with the Configuration. It does not have an independent lifecycle.

Author:

Lukas Eder

See Also:

• DSL
• Configuration

Method Summary

Modifier and Type

Method

Description

@NotNull AlterDatabaseStep

alterDatabase(String database)

The ALTER DATABASE statement.

@NotNull AlterDatabaseStep

alterDatabase(Catalog database)

The ALTER DATABASE statement.

@NotNull AlterDatabaseStep

alterDatabase(Name database)

The ALTER DATABASE statement.

@NotNull AlterDatabaseStep

alterDatabaseIfExists(String database)

The ALTER DATABASE IF EXISTS statement.

@NotNull AlterDatabaseStep

alterDatabaseIfExists(Catalog database)

The ALTER DATABASE IF EXISTS statement.

@NotNull AlterDatabaseStep

alterDatabaseIfExists(Name database)

The ALTER DATABASE IF EXISTS statement.

<T> @NotNull AlterDomainStep<T>

alterDomain(String domain)

The ALTER DOMAIN statement.

<T> @NotNull AlterDomainStep<T>

alterDomain(Domain<T> domain)

The ALTER DOMAIN statement.

<T> @NotNull AlterDomainStep<T>

alterDomain(Name domain)

The ALTER DOMAIN statement.

<T> @NotNull AlterDomainStep<T>

alterDomainIfExists(String domain)

The ALTER DOMAIN IF EXISTS statement.

<T> @NotNull AlterDomainStep<T>

alterDomainIfExists(Domain<T> domain)

The ALTER DOMAIN IF EXISTS statement.

<T> @NotNull AlterDomainStep<T>

alterDomainIfExists(Name domain)

The ALTER DOMAIN IF EXISTS statement.

@NotNull AlterIndexOnStep

alterIndex(String index)

The ALTER INDEX statement.

@NotNull AlterIndexOnStep

alterIndex(Index index)

The ALTER INDEX statement.

@NotNull AlterIndexOnStep

alterIndex(Name index)

The ALTER INDEX statement.

@NotNull AlterIndexOnStep

alterIndexIfExists(String index)

The ALTER INDEX IF EXISTS statement.

@NotNull AlterIndexOnStep

alterIndexIfExists(Index index)

The ALTER INDEX IF EXISTS statement.

@NotNull AlterIndexOnStep

alterIndexIfExists(Name index)

The ALTER INDEX IF EXISTS statement.

@NotNull AlterSchemaStep

alterSchema(String schema)

The ALTER SCHEMA statement.

@NotNull AlterSchemaStep

alterSchema(Name schema)

The ALTER SCHEMA statement.

@NotNull AlterSchemaStep

alterSchema(Schema schema)

The ALTER SCHEMA statement.

@NotNull AlterSchemaStep

alterSchemaIfExists(String schema)

The ALTER SCHEMA IF EXISTS statement.

@NotNull AlterSchemaStep

alterSchemaIfExists(Name schema)

The ALTER SCHEMA IF EXISTS statement.

@NotNull AlterSchemaStep

alterSchemaIfExists(Schema schema)

The ALTER SCHEMA IF EXISTS statement.

@NotNull AlterSequenceStep<Number>

alterSequence(String sequence)

The ALTER SEQUENCE statement.

@NotNull AlterSequenceStep<Number>

alterSequence(Name sequence)

The ALTER SEQUENCE statement.

<T extends Number>
@NotNull AlterSequenceStep<T>

alterSequence(Sequence<T> sequence)

The ALTER SEQUENCE statement.

@NotNull AlterSequenceStep<Number>

alterSequenceIfExists(String sequence)

The ALTER SEQUENCE IF EXISTS statement.

@NotNull AlterSequenceStep<Number>

alterSequenceIfExists(Name sequence)

The ALTER SEQUENCE IF EXISTS statement.

<T extends Number>
@NotNull AlterSequenceStep<T>

alterSequenceIfExists(Sequence<T> sequence)

The ALTER SEQUENCE IF EXISTS statement.

@NotNull AlterTableStep

alterTable(String table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

alterTable(Name table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

alterTable(Table<?> table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

alterTableIfExists(String table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

alterTableIfExists(Name table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

alterTableIfExists(Table<?> table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTypeStep

alterType(String type)

The ALTER TYPE statement.

@NotNull AlterTypeStep

alterType(Name type)

The ALTER TYPE statement.

@NotNull AlterViewStep

alterView(String view)

The ALTER VIEW statement.

@NotNull AlterViewStep

alterView(Name view)

The ALTER VIEW statement.

@NotNull AlterViewStep

alterView(Table<?> view)

The ALTER VIEW statement.

@NotNull AlterViewStep

alterViewIfExists(String view)

The ALTER VIEW IF EXISTS statement.

@NotNull AlterViewStep

alterViewIfExists(Name view)

The ALTER VIEW IF EXISTS statement.

@NotNull AlterViewStep

alterViewIfExists(Table<?> view)

The ALTER VIEW IF EXISTS statement.

void

attach(Collection<? extends Attachable> attachables)

Attach this DSLContext's underlying Scope.configuration() to some attachables.

void

attach(Attachable... attachables)

Attach this DSLContext's underlying Scope.configuration() to some attachables.

@NotNull BatchBindStep

batch(String sql)

Create a batch statement to execute a set of queries in batch mode (with bind values).

@NotNull Batch

batch(String... queries)

Create a batch statement to execute a set of queries in batch mode (without bind values).

@NotNull Batch

batch(String sql, Object[]... bindings)

Create a batch statement to execute a set of queries in batch mode (with bind values).

@NotNull Batch

batch(Collection<? extends Query> queries)

Create a batch statement to execute a set of queries in batch mode (without bind values).

@NotNull Batch

batch(Queries queries)

Create a batch statement to execute a set of queries in batch mode (without bind values).

@NotNull BatchBindStep

batch(Query query)

Create a batch statement to execute a set of queries in batch mode (with bind values).

@NotNull Batch

batch(Query... queries)

Create a batch statement to execute a set of queries in batch mode (without bind values).

@NotNull Batch

batch(Query query, Object[]... bindings)

Create a batch statement to execute a set of queries in batch mode (with bind values).

@NotNull Batch

batchDelete(Collection<? extends UpdatableRecord<?>> records)

Create a batch statement to execute a set of DELETE queries in batch mode (with bind values) according to UpdatableRecord.delete() sematics.

@NotNull Batch

batchDelete(UpdatableRecord<?>... records)

Create a batch statement to execute a set of DELETE queries in batch mode (with bind values) according to UpdatableRecord.delete() sematics.

void

batched(BatchedRunnable runnable)

Run a BatchedRunnable on a BatchedConnection, delaying execution as long as possible before batching.

<T> T

batchedResult(BatchedCallable<T> callable)

Run a BatchedRunnable on a BatchedConnection, delaying execution as long as possible before batching.

@NotNull Batch

batchInsert(Collection<? extends TableRecord<?>> records)

Create a batch statement to execute a set of INSERT queries in batch mode (with bind values) according to TableRecord.insert() semantics.

@NotNull Batch

batchInsert(TableRecord<?>... records)

Create a batch statement to execute a set of INSERT queries in batch mode (with bind values) according to TableRecord.insert() semantics.

@NotNull Batch

batchMerge(Collection<? extends UpdatableRecord<?>> records)

Create a batch statement to execute a set of MERGE queries in batch mode (with bind values) according to UpdatableRecord.merge() semantics.

@NotNull Batch

batchMerge(UpdatableRecord<?>... records)

Create a batch statement to execute a set of MERGE queries in batch mode (with bind values) according to UpdatableRecord.merge() semantics.

@NotNull Batch

batchStore(Collection<? extends UpdatableRecord<?>> records)

Create a batch statement to execute a set of INSERT and UPDATE queries in batch mode (with bind values) according to UpdatableRecord.store() semantics.

@NotNull Batch

batchStore(UpdatableRecord<?>... records)

Create a batch statement to execute a set of INSERT and UPDATE queries in batch mode (with bind values) according to UpdatableRecord.store() semantics.

@NotNull Batch

batchUpdate(Collection<? extends UpdatableRecord<?>> records)

Create a batch statement to execute a set of UPDATE queries in batch mode (with bind values) according to UpdatableRecord.update() semantics.

@NotNull Batch

batchUpdate(UpdatableRecord<?>... records)

Create a batch statement to execute a set of UPDATE queries in batch mode (with bind values) according to UpdatableRecord.update() semantics.

@NotNull Block

begin(Collection<? extends Statement> statements)

Wrap a collection of statements in an anoymous procedural block.

@NotNull Block

begin(Statement... statements)

Wrap a collection of statements in an anonymous procedural block.

@NotNull BindContext

bindContext(PreparedStatement stmt)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#6280] - 3.10 - Do not reuse this method.

@NotNull CallArgsStep

call(String procedure)

The CALL statement.

@NotNull CallArgsStep

call(Name procedure)

The CALL statement.

@NotNull CommentOnIsStep

commentOnColumn(String field)

The COMMENT ON COLUMN statement.

@NotNull CommentOnIsStep

commentOnColumn(Field<?> field)

The COMMENT ON COLUMN statement.

@NotNull CommentOnIsStep

commentOnColumn(Name field)

The COMMENT ON COLUMN statement.

@NotNull CommentOnIsStep

commentOnTable(String table)

The COMMENT ON TABLE statement.

@NotNull CommentOnIsStep

commentOnTable(Name table)

The COMMENT ON TABLE statement.

@NotNull CommentOnIsStep

commentOnTable(Table<?> table)

The COMMENT ON TABLE statement.

@NotNull CommentOnIsStep

commentOnView(String view)

The COMMENT ON VIEW statement.

@NotNull CommentOnIsStep

commentOnView(Name view)

The COMMENT ON VIEW statement.

@NotNull CommentOnIsStep

commentOnView(Table<?> view)

The COMMENT ON VIEW statement.

@NotNull Commit

commit(String id)

Initialise a Version.

@NotNull Commits

commits()

Initialise a Commits graph.

void

connection(ConnectionRunnable runnable)

Run a ConnectionRunnable in the context of this DSLContext's underlying Scope.configuration()'s Configuration.connectionProvider().

<T> T

connectionResult(ConnectionCallable<T> callable)

Run a ConnectionCallable in the context of this DSLContext's underlying Scope.configuration()'s Configuration.connectionProvider().

@NotNull CreateDatabaseFinalStep

createDatabase(String database)

The CREATE DATABASE statement.

@NotNull CreateDatabaseFinalStep

createDatabase(Catalog database)

The CREATE DATABASE statement.

@NotNull CreateDatabaseFinalStep

createDatabase(Name database)

The CREATE DATABASE statement.

@NotNull CreateDatabaseFinalStep

createDatabaseIfNotExists(String database)

The CREATE DATABASE IF NOT EXISTS statement.

@NotNull CreateDatabaseFinalStep

createDatabaseIfNotExists(Catalog database)

The CREATE DATABASE IF NOT EXISTS statement.

@NotNull CreateDatabaseFinalStep

createDatabaseIfNotExists(Name database)

The CREATE DATABASE IF NOT EXISTS statement.

@NotNull CreateDomainAsStep

createDomain(String domain)

The CREATE DOMAIN statement.

@NotNull CreateDomainAsStep

createDomain(Domain<?> domain)

The CREATE DOMAIN statement.

@NotNull CreateDomainAsStep

createDomain(Name domain)

The CREATE DOMAIN statement.

@NotNull CreateDomainAsStep

createDomainIfNotExists(String domain)

The CREATE DOMAIN IF NOT EXISTS statement.

@NotNull CreateDomainAsStep

createDomainIfNotExists(Domain<?> domain)

The CREATE DOMAIN IF NOT EXISTS statement.

@NotNull CreateDomainAsStep

createDomainIfNotExists(Name domain)

The CREATE DOMAIN IF NOT EXISTS statement.

@NotNull CreateFunctionParametersStep

createFunction(String function)

The CREATE FUNCTION statement.

@NotNull CreateFunctionParametersStep

createFunction(Name function)

The CREATE FUNCTION statement.

@NotNull CreateTableElementListStep

createGlobalTemporaryTable(String table)

The CREATE GLOBAL TEMPORARY TABLE statement.

@NotNull CreateTableElementListStep

createGlobalTemporaryTable(Name table)

The CREATE GLOBAL TEMPORARY TABLE statement.

@NotNull CreateTableElementListStep

createGlobalTemporaryTable(Table<?> table)

The CREATE GLOBAL TEMPORARY TABLE statement.

@NotNull CreateTableElementListStep

createGlobalTemporaryTableIfNotExists(String table)

The CREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS statement.

@NotNull CreateTableElementListStep

createGlobalTemporaryTableIfNotExists(Name table)

The CREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS statement.

@NotNull CreateTableElementListStep

createGlobalTemporaryTableIfNotExists(Table<?> table)

The CREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS statement.

@NotNull CreateIndexStep

createIndex()

The CREATE INDEX statement.

@NotNull CreateIndexStep

createIndex(String index)

The CREATE INDEX statement.

@NotNull CreateIndexStep

createIndex(Index index)

The CREATE INDEX statement.

@NotNull CreateIndexStep

createIndex(Name index)

The CREATE INDEX statement.

@NotNull CreateIndexStep

createIndexIfNotExists()

The CREATE INDEX IF NOT EXISTS statement.

@NotNull CreateIndexStep

createIndexIfNotExists(String index)

The CREATE INDEX IF NOT EXISTS statement.

@NotNull CreateIndexStep

createIndexIfNotExists(Index index)

The CREATE INDEX IF NOT EXISTS statement.

@NotNull CreateIndexStep

createIndexIfNotExists(Name index)

The CREATE INDEX IF NOT EXISTS statement.

@NotNull CreateFunctionParametersStep

createOrReplaceFunction(String function)

The CREATE OR REPLACE FUNCTION statement.

@NotNull CreateFunctionParametersStep

createOrReplaceFunction(Name function)

The CREATE OR REPLACE FUNCTION statement.

@NotNull CreateProcedureParametersStep

createOrReplaceProcedure(String procedure)

The CREATE OR REPLACE PROCEDURE statement.

@NotNull CreateProcedureParametersStep

createOrReplaceProcedure(Name procedure)

The CREATE OR REPLACE PROCEDURE statement.

@NotNull CreateTriggerEventStep

createOrReplaceTrigger(String trigger)

The CREATE OR REPLACE TRIGGER statement.

@NotNull CreateTriggerEventStep

createOrReplaceTrigger(Name trigger)

The CREATE OR REPLACE TRIGGER statement.

@NotNull CreateViewAsStep<Record>

createOrReplaceView(String view, String... fields)

Create a new DSL CREATE OR REPLACE VIEW statement.

@NotNull CreateViewAsStep<Record>

createOrReplaceView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createOrReplaceView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createOrReplaceView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createOrReplaceView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createOrReplaceView(Name view, Name... fields)

Create a new DSL CREATE OR REPLACE VIEW statement.

@NotNull CreateViewAsStep<Record>

createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createOrReplaceView(Table<?> view, Field<?>... fields)

Create a new DSL CREATE OR REPLACE VIEW statement.

@NotNull CreateProcedureParametersStep

createProcedure(String procedure)

The CREATE PROCEDURE statement.

@NotNull CreateProcedureParametersStep

createProcedure(Name procedure)

The CREATE PROCEDURE statement.

@NotNull CreateSchemaFinalStep

createSchema(String schema)

The CREATE SCHEMA statement.

@NotNull CreateSchemaFinalStep

createSchema(Name schema)

The CREATE SCHEMA statement.

@NotNull CreateSchemaFinalStep

createSchema(Schema schema)

The CREATE SCHEMA statement.

@NotNull CreateSchemaFinalStep

createSchemaIfNotExists(String schema)

The CREATE SCHEMA IF NOT EXISTS statement.

@NotNull CreateSchemaFinalStep

createSchemaIfNotExists(Name schema)

The CREATE SCHEMA IF NOT EXISTS statement.

@NotNull CreateSchemaFinalStep

createSchemaIfNotExists(Schema schema)

The CREATE SCHEMA IF NOT EXISTS statement.

@NotNull CreateSequenceFlagsStep

createSequence(String sequence)

The CREATE SEQUENCE statement.

@NotNull CreateSequenceFlagsStep

createSequence(Name sequence)

The CREATE SEQUENCE statement.

@NotNull CreateSequenceFlagsStep

createSequence(Sequence<?> sequence)

The CREATE SEQUENCE statement.

@NotNull CreateSequenceFlagsStep

createSequenceIfNotExists(String sequence)

The CREATE SEQUENCE IF NOT EXISTS statement.

@NotNull CreateSequenceFlagsStep

createSequenceIfNotExists(Name sequence)

The CREATE SEQUENCE IF NOT EXISTS statement.

@NotNull CreateSequenceFlagsStep

createSequenceIfNotExists(Sequence<?> sequence)

The CREATE SEQUENCE IF NOT EXISTS statement.

@NotNull CreateTableElementListStep

createTable(String table)

The CREATE TABLE statement.

@NotNull CreateTableElementListStep

createTable(Name table)

The CREATE TABLE statement.

@NotNull CreateTableElementListStep

createTable(Table<?> table)

The CREATE TABLE statement.

@NotNull CreateTableElementListStep

createTableIfNotExists(String table)

The CREATE TABLE IF NOT EXISTS statement.

@NotNull CreateTableElementListStep

createTableIfNotExists(Name table)

The CREATE TABLE IF NOT EXISTS statement.

@NotNull CreateTableElementListStep

createTableIfNotExists(Table<?> table)

The CREATE TABLE IF NOT EXISTS statement.

@NotNull CreateTableElementListStep

createTemporaryTable(String table)

The CREATE TEMPORARY TABLE statement.

@NotNull CreateTableElementListStep

createTemporaryTable(Name table)

The CREATE TEMPORARY TABLE statement.

@NotNull CreateTableElementListStep

createTemporaryTable(Table<?> table)

The CREATE TEMPORARY TABLE statement.

@NotNull CreateTableElementListStep

createTemporaryTableIfNotExists(String table)

The CREATE TEMPORARY TABLE IF NOT EXISTS statement.

@NotNull CreateTableElementListStep

createTemporaryTableIfNotExists(Name table)

The CREATE TEMPORARY TABLE IF NOT EXISTS statement.

@NotNull CreateTableElementListStep

createTemporaryTableIfNotExists(Table<?> table)

The CREATE TEMPORARY TABLE IF NOT EXISTS statement.

@NotNull CreateTriggerEventStep

createTrigger(String trigger)

The CREATE TRIGGER statement.

@NotNull CreateTriggerEventStep

createTrigger(Name trigger)

The CREATE TRIGGER statement.

@NotNull CreateTypeStep

createType(String type)

Create a new DSL CREATE TYPE statement.

@NotNull CreateTypeStep

createType(Name type)

Create a new DSL CREATE TYPE statement.

@NotNull CreateIndexStep

createUniqueIndex()

The CREATE UNIQUE INDEX statement.

@NotNull CreateIndexStep

createUniqueIndex(String index)

The CREATE UNIQUE INDEX statement.

@NotNull CreateIndexStep

createUniqueIndex(Index index)

The CREATE UNIQUE INDEX statement.

@NotNull CreateIndexStep

createUniqueIndex(Name index)

The CREATE UNIQUE INDEX statement.

@NotNull CreateIndexStep

createUniqueIndexIfNotExists()

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

@NotNull CreateIndexStep

createUniqueIndexIfNotExists(String index)

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

@NotNull CreateIndexStep

createUniqueIndexIfNotExists(Index index)

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

@NotNull CreateIndexStep

createUniqueIndexIfNotExists(Name index)

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

@NotNull CreateViewAsStep<Record>

createView(String view, String... fields)

Create a new DSL CREATE VIEW statement.

@NotNull CreateViewAsStep<Record>

createView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createView(Name view, Name... fields)

Create a new DSL CREATE VIEW statement.

@NotNull CreateViewAsStep<Record>

createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createView(Table<?> view, Field<?>... fields)

Create a new DSL CREATE VIEW statement.

@NotNull CreateViewAsStep<Record>

createViewIfNotExists(String view, String... fields)

Create a new DSL CREATE VIEW statement.

@NotNull CreateViewAsStep<Record>

createViewIfNotExists(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createViewIfNotExists(String view, Function<? super Field<?>,? extends String> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createViewIfNotExists(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createViewIfNotExists(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createViewIfNotExists(Name view, Name... fields)

Create a new DSL CREATE VIEW statement.

@NotNull CreateViewAsStep<Record>

createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

createViewIfNotExists(Table<?> view, Field<?>... fields)

Create a new DSL CREATE VIEW statement.

@NotNull BigInteger

currval(String sequence)

Convenience method to fetch the CURRVAL for a sequence directly from this DSLContext's underlying JDBC Connection.

@NotNull BigInteger

currval(Name sequence)

Convenience method to fetch the CURRVAL for a sequence directly from this DSLContext's underlying JDBC Connection.

<T extends Number>
T

currval(Sequence<T> sequence)

Convenience method to fetch the CURRVAL for a sequence directly from this DSLContext's underlying JDBC Connection.

@NotNull Queries

ddl(Collection<? extends Table<?>> tables)

Convenience method for Meta.ddl().

@NotNull Queries

ddl(Collection<? extends Table<?>> tables, DDLExportConfiguration configuration)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

ddl(Collection<? extends Table<?>> tables, DDLFlag... flags)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

ddl(Catalog catalog)

Convenience method for Meta.ddl().

@NotNull Queries

ddl(Catalog schema, DDLExportConfiguration configuration)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

ddl(Catalog schema, DDLFlag... flags)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

ddl(Schema schema)

Convenience method for Meta.ddl().

@NotNull Queries

ddl(Schema schema, DDLExportConfiguration configuration)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

ddl(Schema schema, DDLFlag... flags)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

ddl(Table<?> table)

Convenience method for Meta.ddl().

@NotNull Queries

ddl(Table<?>... tables)

Convenience method for Meta.ddl().

@NotNull Queries

ddl(Table<?>[] tables, DDLExportConfiguration configuration)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

ddl(Table<?>[] tables, DDLFlag... flags)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

ddl(Table<?> table, DDLExportConfiguration configuration)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

ddl(Table<?> table, DDLFlag... flags)

Convenience method for Meta.ddl(DDLExportConfiguration).

<R extends Record>
@NotNull DeleteUsingStep<R>

delete(Table<R> table)

Create a new DSL delete statement.

<R extends Record>
@NotNull DeleteUsingStep<R>

deleteFrom(Table<R> table)

Create a new DSL delete statement.

<R extends Record>
@NotNull DeleteQuery<R>

deleteQuery(Table<R> table)

Create a new DeleteQuery

@NotNull Connection

diagnosticsConnection()

A JDBC connection that proxies the underlying connection to run the jOOQ Diagnostics Pack on executed queries.

@NotNull DataSource

diagnosticsDataSource()

A JDBC connection that proxies the underlying connection to run the jOOQ Diagnostics Pack on executed queries.

@NotNull DropDatabaseFinalStep

dropDatabase(String database)

The DROP DATABASE statement.

@NotNull DropDatabaseFinalStep

dropDatabase(Catalog database)

The DROP DATABASE statement.

@NotNull DropDatabaseFinalStep

dropDatabase(Name database)

The DROP DATABASE statement.

@NotNull DropDatabaseFinalStep

dropDatabaseIfExists(String database)

The DROP DATABASE IF EXISTS statement.

@NotNull DropDatabaseFinalStep

dropDatabaseIfExists(Catalog database)

The DROP DATABASE IF EXISTS statement.

@NotNull DropDatabaseFinalStep

dropDatabaseIfExists(Name database)

The DROP DATABASE IF EXISTS statement.

@NotNull DropDomainCascadeStep

dropDomain(String domain)

The DROP DOMAIN statement.

@NotNull DropDomainCascadeStep

dropDomain(Domain<?> domain)

The DROP DOMAIN statement.

@NotNull DropDomainCascadeStep

dropDomain(Name domain)

The DROP DOMAIN statement.

@NotNull DropDomainCascadeStep

dropDomainIfExists(String domain)

The DROP DOMAIN IF EXISTS statement.

@NotNull DropDomainCascadeStep

dropDomainIfExists(Domain<?> domain)

The DROP DOMAIN IF EXISTS statement.

@NotNull DropDomainCascadeStep

dropDomainIfExists(Name domain)

The DROP DOMAIN IF EXISTS statement.

@NotNull DDLQuery

dropFunction(String function)

The DROP FUNCTION statement.

@NotNull DDLQuery

dropFunction(Name function)

The DROP FUNCTION statement.

@NotNull DDLQuery

dropFunctionIfExists(String function)

The DROP FUNCTION IF EXISTS statement.

@NotNull DDLQuery

dropFunctionIfExists(Name function)

The DROP FUNCTION IF EXISTS statement.

@NotNull DropIndexOnStep

dropIndex(String index)

The DROP INDEX statement.

@NotNull DropIndexOnStep

dropIndex(Index index)

The DROP INDEX statement.

@NotNull DropIndexOnStep

dropIndex(Name index)

The DROP INDEX statement.

@NotNull DropIndexOnStep

dropIndexIfExists(String index)

The DROP INDEX IF EXISTS statement.

@NotNull DropIndexOnStep

dropIndexIfExists(Index index)

The DROP INDEX IF EXISTS statement.

@NotNull DropIndexOnStep

dropIndexIfExists(Name index)

The DROP INDEX IF EXISTS statement.

@NotNull DDLQuery

dropProcedure(String procedure)

The DROP PROCEDURE statement.

@NotNull DDLQuery

dropProcedure(Name procedure)

The DROP PROCEDURE statement.

@NotNull DDLQuery

dropProcedureIfExists(String procedure)

The DROP PROCEDURE IF EXISTS statement.

@NotNull DDLQuery

dropProcedureIfExists(Name procedure)

The DROP PROCEDURE IF EXISTS statement.

@NotNull DropSchemaStep

dropSchema(String schema)

The DROP SCHEMA statement.

@NotNull DropSchemaStep

dropSchema(Name schema)

The DROP SCHEMA statement.

@NotNull DropSchemaStep

dropSchema(Schema schema)

The DROP SCHEMA statement.

@NotNull DropSchemaStep

dropSchemaIfExists(String schema)

The DROP SCHEMA IF EXISTS statement.

@NotNull DropSchemaStep

dropSchemaIfExists(Name schema)

The DROP SCHEMA IF EXISTS statement.

@NotNull DropSchemaStep

dropSchemaIfExists(Schema schema)

The DROP SCHEMA IF EXISTS statement.

@NotNull DropSequenceFinalStep

dropSequence(String sequence)

The DROP SEQUENCE statement.

@NotNull DropSequenceFinalStep

dropSequence(Name sequence)

The DROP SEQUENCE statement.

@NotNull DropSequenceFinalStep

dropSequence(Sequence<?> sequence)

The DROP SEQUENCE statement.

@NotNull DropSequenceFinalStep

dropSequenceIfExists(String sequence)

The DROP SEQUENCE IF EXISTS statement.

@NotNull DropSequenceFinalStep

dropSequenceIfExists(Name sequence)

The DROP SEQUENCE IF EXISTS statement.

@NotNull DropSequenceFinalStep

dropSequenceIfExists(Sequence<?> sequence)

The DROP SEQUENCE IF EXISTS statement.

@NotNull DropTableStep

dropTable(String table)

The DROP TABLE statement.

@NotNull DropTableStep

dropTable(Name table)

The DROP TABLE statement.

@NotNull DropTableStep

dropTable(Table<?> table)

The DROP TABLE statement.

@NotNull DropTableStep

dropTableIfExists(String table)

The DROP TABLE IF EXISTS statement.

@NotNull DropTableStep

dropTableIfExists(Name table)

The DROP TABLE IF EXISTS statement.

@NotNull DropTableStep

dropTableIfExists(Table<?> table)

The DROP TABLE IF EXISTS statement.

@NotNull DropTableStep

dropTemporaryTable(String table)

The DROP TEMPORARY TABLE statement.

@NotNull DropTableStep

dropTemporaryTable(Name table)

The DROP TEMPORARY TABLE statement.

@NotNull DropTableStep

dropTemporaryTable(Table<?> table)

The DROP TEMPORARY TABLE statement.

@NotNull DropTableStep

dropTemporaryTableIfExists(String table)

The DROP TEMPORARY TABLE IF EXISTS statement.

@NotNull DropTableStep

dropTemporaryTableIfExists(Name table)

The DROP TEMPORARY TABLE IF EXISTS statement.

@NotNull DropTableStep

dropTemporaryTableIfExists(Table<?> table)

The DROP TEMPORARY TABLE IF EXISTS statement.

@NotNull DDLQuery

dropTrigger(String trigger)

The DROP TRIGGER statement.

@NotNull DDLQuery

dropTrigger(Name trigger)

The DROP TRIGGER statement.

@NotNull DDLQuery

dropTriggerIfExists(String trigger)

The DROP TRIGGER IF EXISTS statement.

@NotNull DDLQuery

dropTriggerIfExists(Name trigger)

The DROP TRIGGER IF EXISTS statement.

@NotNull DropTypeStep

dropType(String type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

dropType(String... type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

dropType(Collection<?> type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

dropType(Name type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

dropType(Name... type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

dropTypeIfExists(String type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

dropTypeIfExists(String... type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

dropTypeIfExists(Collection<?> type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

dropTypeIfExists(Name type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

dropTypeIfExists(Name... type)

Create a new DSL DROP TYPE statement.

@NotNull DropViewFinalStep

dropView(String view)

The DROP VIEW statement.

@NotNull DropViewFinalStep

dropView(Name view)

The DROP VIEW statement.

@NotNull DropViewFinalStep

dropView(Table<?> view)

The DROP VIEW statement.

@NotNull DropViewFinalStep

dropViewIfExists(String view)

The DROP VIEW IF EXISTS statement.

@NotNull DropViewFinalStep

dropViewIfExists(Name view)

The DROP VIEW IF EXISTS statement.

@NotNull DropViewFinalStep

dropViewIfExists(Table<?> view)

The DROP VIEW IF EXISTS statement.

int

execute(String sql)

Execute a query holding plain SQL.

int

execute(String sql, Object... bindings)

Execute a new query holding plain SQL.

int

execute(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

int

execute(Query query)

Execute a Query in the context of this DSLContext.

int

execute(SQL sql)

Execute a query holding plain SQL.

int

executeDelete(TableRecord<?> record, Condition condition)

Delete a record from a table.

int

executeDelete(UpdatableRecord<?> record)

Delete a record from a table.

int

executeInsert(TableRecord<?> record)

Insert one record.

int

executeUpdate(TableRecord<?> record, Condition condition)

Update a table.

int

executeUpdate(UpdatableRecord<?> record)

Update a table.

@NotNull Explain

explain(Query query)

Run an EXPLAIN statement in the database to estimate the cardinality of the query.

@NotNull List<Object>

extractBindValues(QueryPart part)

Retrieve the bind values that will be bound by a given QueryPart.

@Nullable Param<?>

extractParam(QueryPart part, String name)

Get a named parameter from a QueryPart, provided its name.

@NotNull Map<String,Param<?>>

extractParams(QueryPart part)

Get a Map of named parameters.

@NotNull Result<Record>

fetch(String sql)

Execute a new query holding plain SQL.

@NotNull Result<Record>

fetch(String sql, Object... bindings)

Execute a new query holding plain SQL.

@NotNull Result<Record>

fetch(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

@NotNull Result<Record>

fetch(ResultSet rs)

Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.

@NotNull Result<Record>

fetch(ResultSet rs, Class<?>... types)

Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.

@NotNull Result<Record>

fetch(ResultSet rs, DataType<?>... types)

Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.

@NotNull Result<Record>

fetch(ResultSet rs, Field<?>... fields)

Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.

<R extends Record>
@NotNull Result<R>

fetch(ResultQuery<R> query)

Execute a ResultQuery in the context of this DSLContext and return results.

@NotNull Result<Record>

fetch(SQL sql)

Execute a new query holding plain SQL.

<R extends Record>
@NotNull Result<R>

fetch(Table<R> table)

Execute and return all records for

<R extends Record>
@NotNull Result<R>

fetch(Table<R> table, Collection<? extends Condition> conditions)

Execute and return all records for

<R extends Record>
@NotNull Result<R>

fetch(Table<R> table, Condition condition)

Execute and return all records for

<R extends Record>
@NotNull Result<R>

fetch(Table<R> table, Condition... conditions)

Execute and return all records for

<R extends Record>
R

fetchAny(Table<R> table)

Execute and return zero or one record for

<R extends Record>
R

fetchAny(Table<R> table, Collection<? extends Condition> conditions)

Execute and return zero or one record for

<R extends Record>
R

fetchAny(Table<R> table, Condition condition)

Execute and return zero or one record for

<R extends Record>
R

fetchAny(Table<R> table, Condition... conditions)

Execute and return zero or on e record for

@NotNull CompletionStage<Result<Record>>

fetchAsync(String sql)

Fetch results in a new CompletionStage.

@NotNull CompletionStage<Result<Record>>

fetchAsync(String sql, Object... bindings)

Fetch results in a new CompletionStage.

@NotNull CompletionStage<Result<Record>>

fetchAsync(String sql, QueryPart... parts)

Fetch results in a new CompletionStage.

@NotNull CompletionStage<Result<Record>>

fetchAsync(ResultSet rs)

Fetch results in a new CompletionStage.

@NotNull CompletionStage<Result<Record>>

fetchAsync(ResultSet rs, Class<?>... types)

Fetch results in a new CompletionStage.

@NotNull CompletionStage<Result<Record>>

fetchAsync(ResultSet rs, DataType<?>... types)

Fetch results in a new CompletionStage.

@NotNull CompletionStage<Result<Record>>

fetchAsync(ResultSet rs, Field<?>... fields)

Fetch results in a new CompletionStage.

@NotNull CompletionStage<Result<Record>>

fetchAsync(Executor executor, String sql)

Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.

@NotNull CompletionStage<Result<Record>>

fetchAsync(Executor executor, String sql, Object... bindings)

Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.

@NotNull CompletionStage<Result<Record>>

fetchAsync(Executor executor, String sql, QueryPart... parts)

Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.

@NotNull CompletionStage<Result<Record>>

fetchAsync(Executor executor, ResultSet rs)

Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.

@NotNull CompletionStage<Result<Record>>

fetchAsync(Executor executor, ResultSet rs, Class<?>... types)

Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.

@NotNull CompletionStage<Result<Record>>

fetchAsync(Executor executor, ResultSet rs, DataType<?>... types)

Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.

@NotNull CompletionStage<Result<Record>>

fetchAsync(Executor executor, ResultSet rs, Field<?>... fields)

Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.

<R extends Record>
@NotNull CompletionStage<Result<R>>

fetchAsync(Executor executor, ResultQuery<R> query)

Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.

@NotNull CompletionStage<Result<Record>>

fetchAsync(Executor executor, SQL sql)

Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.

<R extends Record>
@NotNull CompletionStage<Result<R>>

fetchAsync(Executor executor, Table<R> table)

Execute and return all records asynchronously for

<R extends Record>
@NotNull CompletionStage<Result<R>>

fetchAsync(Executor executor, Table<R> table, Collection<? extends Condition> conditions)

Execute and return all records asynchronously for

<R extends Record>
@NotNull CompletionStage<Result<R>>

fetchAsync(Executor executor, Table<R> table, Condition condition)

Execute and return all records asynchronously for

<R extends Record>
@NotNull CompletionStage<Result<R>>

fetchAsync(Executor executor, Table<R> table, Condition... conditions)

Execute and return all records asynchronously for

<R extends Record>
@NotNull CompletionStage<Result<R>>

fetchAsync(ResultQuery<R> query)

Fetch results in a new CompletionStage.

@NotNull CompletionStage<Result<Record>>

fetchAsync(SQL sql)

Fetch results in a new CompletionStage.

<R extends Record>
@NotNull CompletionStage<Result<R>>

fetchAsync(Table<R> table)

Execute and return all records asynchronously for

<R extends Record>
@NotNull CompletionStage<Result<R>>

fetchAsync(Table<R> table, Collection<? extends Condition> condition)

Execute and return all records asynchronously for

<R extends Record>
@NotNull CompletionStage<Result<R>>

fetchAsync(Table<R> table, Condition condition)

Execute and return all records asynchronously for

<R extends Record>
@NotNull CompletionStage<Result<R>>

fetchAsync(Table<R> table, Condition... condition)

Execute and return all records asynchronously for

<R extends TableRecord<R>>
@NotNull Result<R>

fetchByExample(R example)

Execute a "Query by Example" (QBE) based on an example record.

int

fetchCount(Select<?> query)

Execute a Select query in the context of this DSLContext and return a COUNT(*) value.

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 a Select 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.

@NotNull Result<Record>

fetchFromCSV(String string)

Fetch all data from a CSV string.

@NotNull Result<Record>

fetchFromCSV(String string, boolean header)

Fetch all data from a CSV string.

@NotNull Result<Record>

fetchFromCSV(String string, boolean header, char delimiter)

Fetch all data from a CSV string.

@NotNull Result<Record>

fetchFromCSV(String string, char delimiter)

Fetch all data from a CSV string.

@NotNull Result<Record>

fetchFromHTML(String string)

Convert an HTML table into a jOOQ Result.

@NotNull Result<Record>

fetchFromJSON(String string)

Fetch all data from a JSON string.

@NotNull Result<Record>

fetchFromStringData(String[]... data)

Fetch all data from a list of strings.

@NotNull Result<Record>

fetchFromStringData(List<String[]> data)

Fetch all data from a list of strings.

@NotNull Result<Record>

fetchFromStringData(List<String[]> data, boolean header)

Fetch all data from a list of strings.

@NotNull Result<Record>

fetchFromTXT(String string)

Fetch all data from a formatted string.

@NotNull Result<Record>

fetchFromTXT(String string, String nullLiteral)

Fetch all data from a formatted string.

@NotNull Result<Record>

fetchFromXML(String string)

Fetch all data from an XML string.

<K, V> @NotNull Map<K,List<V>>

fetchGroups(ResultQuery<? extends Record2<K,V>> query)

Execute the query and return a Map with the first column as the map key and the second column as the map values.

@NotNull Cursor<Record>

fetchLazy(String sql)

Execute a new query holding plain SQL and "lazily" return the generated result.

@NotNull Cursor<Record>

fetchLazy(String sql, Object... bindings)

Execute a new query holding plain SQL and "lazily" return the generated result.

@NotNull Cursor<Record>

fetchLazy(String sql, QueryPart... parts)

Execute a new query holding plain SQL and "lazily" return the generated result.

@NotNull Cursor<Record>

fetchLazy(ResultSet rs)

Wrap a JDBC ResultSet into a jOOQ Cursor.

@NotNull Cursor<Record>

fetchLazy(ResultSet rs, Class<?>... types)

Wrap a JDBC ResultSet into a jOOQ Cursor.

@NotNull Cursor<Record>

fetchLazy(ResultSet rs, DataType<?>... types)

Wrap a JDBC ResultSet into a jOOQ Cursor.

@NotNull Cursor<Record>

fetchLazy(ResultSet rs, Field<?>... fields)

Wrap a JDBC ResultSet into a jOOQ Cursor.

<R extends Record>
@NotNull Cursor<R>

fetchLazy(ResultQuery<R> query)

Execute a ResultQuery in the context of this DSLContext and return a cursor.

@NotNull Cursor<Record>

fetchLazy(SQL sql)

Execute a new query holding plain SQL and "lazily" return the generated result.

<R extends Record>
@NotNull Cursor<R>

fetchLazy(Table<R> table)

Execute and return all records lazily for

<R extends Record>
@NotNull Cursor<R>

fetchLazy(Table<R> table, Collection<? extends Condition> conditions)

Execute and return all records lazily for

<R extends Record>
@NotNull Cursor<R>

fetchLazy(Table<R> table, Condition condition)

Execute and return all records lazily for

<R extends Record>
@NotNull Cursor<R>

fetchLazy(Table<R> table, Condition... conditions)

Execute and return all records lazily for

@NotNull Results

fetchMany(String sql)

Execute a new query holding plain SQL, possibly returning several result sets.

@NotNull Results

fetchMany(String sql, Object... bindings)

Execute a new query holding plain SQL, possibly returning several result sets.

@NotNull Results

fetchMany(String sql, QueryPart... parts)

Execute a new query holding plain SQL, possibly returning several result sets.

<R extends Record>
@NotNull Results

fetchMany(ResultQuery<R> query)

Execute a ResultQuery in the context of this DSLContext and return a cursor.

@NotNull Results

fetchMany(SQL sql)

Execute a new query holding plain SQL, possibly returning several result sets.

<K, V> @NotNull Map<K,V>

fetchMap(ResultQuery<? extends Record2<K,V>> query)

Execute the query and return a Map with the first column as the map key and the second column as the map value.

@Nullable Record

fetchOne(String sql)

Execute a new query holding plain SQL.

@Nullable Record

fetchOne(String sql, Object... bindings)

Execute a new query holding plain SQL.

@Nullable Record

fetchOne(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

@Nullable Record

fetchOne(ResultSet rs)

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

@Nullable Record

fetchOne(ResultSet rs, Class<?>... types)

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

@Nullable Record

fetchOne(ResultSet rs, DataType<?>... types)

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

@Nullable Record

fetchOne(ResultSet rs, Field<?>... fields)

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

<R extends Record>
R

fetchOne(ResultQuery<R> query)

Execute a ResultQuery in the context of this DSLContext and return a record.

@Nullable Record

fetchOne(SQL sql)

Execute a new query holding plain SQL.

<R extends Record>
R

fetchOne(Table<R> table)

Execute and return zero or one record for

<R extends Record>
R

fetchOne(Table<R> table, Collection<? extends Condition> conditions)

Execute and return zero or one record for

<R extends Record>
R

fetchOne(Table<R> table, Condition condition)

Execute and return zero or one record for

<R extends Record>
R

fetchOne(Table<R> table, Condition... conditions)

Execute and return zero or one record for

@NotNull Optional<Record>

fetchOptional(String sql)

Execute a new query holding plain SQL.

@NotNull Optional<Record>

fetchOptional(String sql, Object... bindings)

Execute a new query holding plain SQL.

@NotNull Optional<Record>

fetchOptional(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

@NotNull Optional<Record>

fetchOptional(ResultSet rs)

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

@NotNull Optional<Record>

fetchOptional(ResultSet rs, Class<?>... types)

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

@NotNull Optional<Record>

fetchOptional(ResultSet rs, DataType<?>... types)

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

@NotNull Optional<Record>

fetchOptional(ResultSet rs, Field<?>... fields)

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

<R extends Record>
@NotNull Optional<R>

fetchOptional(ResultQuery<R> query)

Execute a ResultQuery in the context of this DSLContext and return a record.

@NotNull Optional<Record>

fetchOptional(SQL sql)

Execute a new query holding plain SQL.

<R extends Record>
@NotNull Optional<R>

fetchOptional(Table<R> table)

Execute and return zero or one record for

<R extends Record>
@NotNull Optional<R>

fetchOptional(Table<R> table, Collection<? extends Condition> conditions)

Execute and return zero or one record for

<R extends Record>
@NotNull Optional<R>

fetchOptional(Table<R> table, Condition condition)

Execute and return zero or one record for

<R extends Record>
@NotNull Optional<R>

fetchOptional(Table<R> table, Condition... conditions)

Execute and return zero or one record for

@NotNull Optional<?>

fetchOptionalValue(String sql)

Execute a new query holding plain SQL.

@NotNull Optional<?>

fetchOptionalValue(String sql, Object... bindings)

Execute a new query holding plain SQL.

@NotNull Optional<?>

fetchOptionalValue(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

@NotNull Optional<?>

fetchOptionalValue(ResultSet rs)

Fetch a record from a JDBC ResultSet and return the only contained value.

<T> @NotNull Optional<T>

fetchOptionalValue(ResultSet rs, Class<T> type)

Fetch a record from a JDBC ResultSet and return the only contained value.

<T> @NotNull Optional<T>

fetchOptionalValue(ResultSet rs, DataType<T> type)

Fetch a record from a JDBC ResultSet and return the only contained value.

<T> @NotNull Optional<T>

fetchOptionalValue(ResultSet rs, Field<T> field)

Fetch a record from a JDBC ResultSet and return the only contained value.

<T, R extends Record1<T>>
@NotNull Optional<T>

fetchOptionalValue(ResultQuery<R> query)

Execute a ResultQuery in the context of this DSLContext and return a single value.

@NotNull Optional<?>

fetchOptionalValue(SQL sql)

Execute a new query holding plain SQL.

<T> @NotNull Optional<T>

fetchOptionalValue(TableField<?,T> field)

Execute a ResultQuery in the context of this DSLContext and return a single value.

@NotNull Record

fetchSingle(String sql)

Execute a new query holding plain SQL.

@NotNull Record

fetchSingle(String sql, Object... bindings)

Execute a new query holding plain SQL.

@NotNull Record

fetchSingle(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

@NotNull Record

fetchSingle(ResultSet rs)

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

@NotNull Record

fetchSingle(ResultSet rs, Class<?>... types)

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

@NotNull Record

fetchSingle(ResultSet rs, DataType<?>... types)

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

@NotNull Record

fetchSingle(ResultSet rs, Field<?>... fields)

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

@NotNull Record

fetchSingle(Collection<? extends SelectField<?>> fields)

Execute and return exactly one record for

<R extends Record>
R

fetchSingle(ResultQuery<R> query)

Execute a ResultQuery in the context of this DSLContext and return a record.

@NotNull Record

fetchSingle(SelectField<?>... fields)

Execute and return exactly one record for

<T1> @NotNull Record1<T1>

fetchSingle(SelectField<T1> field1)

Execute and return exactly one record for

<T1, T2> @NotNull Record2<T1,T2>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2)

Execute and return exactly one record for

<T1, T2, T3> @NotNull Record3<T1,T2,T3>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)

Execute and return exactly one record for

<T1, T2, T3, T4>
@NotNull Record4<T1,T2,T3,T4>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)

Execute and return exactly one record for

<T1, T2, T3, T4, T5>
@NotNull Record5<T1,T2,T3,T4,T5>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6>
@NotNull Record6<T1,T2,T3,T4,T5,T6>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7>
@NotNull Record7<T1,T2,T3,T4,T5,T6,T7>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull Record8<T1,T2,T3,T4,T5,T6,T7,T8>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21)

Execute and return exactly one record for

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22)

Execute and return exactly one record for

@NotNull Record

fetchSingle(SQL sql)

Execute a new query holding plain SQL.

<R extends Record>
R

fetchSingle(Table<R> table)

Execute and return exactly one record for

<R extends Record>
R

fetchSingle(Table<R> table, Collection<? extends Condition> conditions)

Execute and return exactly one record for

<R extends Record>
R

fetchSingle(Table<R> table, Condition condition)

Execute and return exactly one record for

<R extends Record>
R

fetchSingle(Table<R> table, Condition... conditions)

Execute and return exactly one record for

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2)

Disambiguation overload of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3)

Disambiguation overload of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4)

Disambiguation overload of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5)

Disambiguation overload of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6)

Disambiguation overload of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7)

Disambiguation overload of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8)

Disambiguation overload of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9)

Disambiguation overload of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(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 of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(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 of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(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 of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(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 of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(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 of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(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 of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(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 of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(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 of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(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 of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(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 of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(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 of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(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 of fetchSingle(Table, Condition...).

<R extends Record>
R

fetchSingle(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 of fetchSingle(Table, Condition...).

@NotNull Stream<Record>

fetchStream(String sql)

Execute a new query holding plain SQL and "lazily" return the generated result.

@NotNull Stream<Record>

fetchStream(String sql, Object... bindings)

Execute a new query holding plain SQL and "lazily" return the generated result.

@NotNull Stream<Record>

fetchStream(String sql, QueryPart... parts)

Execute a new query holding plain SQL and "lazily" return the generated result.

@NotNull Stream<Record>

fetchStream(ResultSet rs)

Wrap a JDBC ResultSet into a jOOQ Stream.

@NotNull Stream<Record>

fetchStream(ResultSet rs, Class<?>... types)

Wrap a JDBC ResultSet into a jOOQ Stream.

@NotNull Stream<Record>

fetchStream(ResultSet rs, DataType<?>... types)

Wrap a JDBC ResultSet into a jOOQ Stream.

@NotNull Stream<Record>

fetchStream(ResultSet rs, Field<?>... fields)

Wrap a JDBC ResultSet into a jOOQ Stream.

<R extends Record>
@NotNull Stream<R>

fetchStream(ResultQuery<R> query)

Execute a ResultQuery in the context of this DSLContext and return a stream.

@NotNull Stream<Record>

fetchStream(SQL sql)

Execute a new query holding plain SQL and "lazily" return the generated result.

<R extends Record>
@NotNull Stream<R>

fetchStream(Table<R> table)

Execute and return all records lazily for

<R extends Record>
@NotNull Stream<R>

fetchStream(Table<R> table, Collection<? extends Condition> conditions)

Execute and return all records lazily for

<R extends Record>
@NotNull Stream<R>

fetchStream(Table<R> table, Condition condition)

Execute and return all records lazily for

<R extends Record>
@NotNull Stream<R>

fetchStream(Table<R> table, Condition... conditions)

Execute and return all records lazily for

@Nullable Object

fetchValue(String sql)

Execute a new query holding plain SQL.

@Nullable Object

fetchValue(String sql, Object... bindings)

Execute a new query holding plain SQL.

@Nullable Object

fetchValue(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

@Nullable Object

fetchValue(ResultSet rs)

Fetch a record from a JDBC ResultSet and return the only contained value.

<T> T

fetchValue(ResultSet rs, Class<T> type)

Fetch a record from a JDBC ResultSet and return the only contained value.

<T> T

fetchValue(ResultSet rs, DataType<T> type)

Fetch a record from a JDBC ResultSet and return the only contained value.

<T> T

fetchValue(ResultSet rs, Field<T> field)

Fetch a record from a JDBC ResultSet and return the only contained value.

<T, R extends Record1<T>>
T

fetchValue(ResultQuery<R> query)

Execute a ResultQuery in the context of this DSLContext and return a single value.

<T> T

fetchValue(SelectField<T> field)

Execute a ResultQuery in the context of this DSLContext and return a single value.

@Nullable Object

fetchValue(SQL sql)

Execute a new query holding plain SQL.

<T> T

fetchValue(Table<? extends Record1<T>> table)

Fetch a single value from a single column table.

<T> T

fetchValue(TableField<?,T> field)

Execute a ResultQuery in the context of this DSLContext and return a single value.

@NotNull List<?>

fetchValues(String sql)

Execute a new query holding plain SQL.

@NotNull List<?>

fetchValues(String sql, Object... bindings)

Execute a new query holding plain SQL.

@NotNull List<?>

fetchValues(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

@NotNull List<?>

fetchValues(ResultSet rs)

Fetch a result from a JDBC ResultSet and return the only contained column's values.

<T> @NotNull List<T>

fetchValues(ResultSet rs, Class<T> type)

Fetch a result from a JDBC ResultSet and return the only contained column's values.

<T> @NotNull List<T>

fetchValues(ResultSet rs, DataType<T> type)

Fetch a result from a JDBC ResultSet and return the only contained column's values.

<T> @NotNull List<T>

fetchValues(ResultSet rs, Field<T> field)

Fetch a result from a JDBC ResultSet and return the only contained column's values.

<T, R extends Record1<T>>
@NotNull List<T>

fetchValues(ResultQuery<R> query)

Execute a ResultQuery in the context of this DSLContext and return all values for the only column.

@NotNull List<?>

fetchValues(SQL sql)

Execute a new query holding plain SQL.

<T> @NotNull List<T>

fetchValues(Table<? extends Record1<T>> table)

Fetch all values from a single column table.

<T> @NotNull List<T>

fetchValues(TableField<?,T> field)

Fetch all values in a given Table's TableField.

@NotNull GrantOnStep

grant(Collection<? extends Privilege> privileges)

The GRANT statement.

@NotNull GrantOnStep

grant(Privilege privileges)

The GRANT statement.

@NotNull GrantOnStep

grant(Privilege... privileges)

The GRANT statement.

@NotNull InformationSchema

informationSchema(Catalog catalog)

Convenience method for Meta.informationSchema().

@NotNull InformationSchema

informationSchema(Catalog... catalogs)

Convenience method for Meta.informationSchema().

@NotNull InformationSchema

informationSchema(Schema schema)

Convenience method for Meta.informationSchema().

@NotNull InformationSchema

informationSchema(Schema... schemas)

Convenience method for Meta.informationSchema().

@NotNull InformationSchema

informationSchema(Table<?> table)

Convenience method for Meta.informationSchema().

@NotNull InformationSchema

informationSchema(Table<?>... table)

Convenience method for Meta.informationSchema().

<R extends Record>
@NotNull InsertSetStep<R>

insertInto(Table<R> into)

Create a new DSL insert statement.

<R extends Record>
@NotNull InsertValuesStepN<R>

insertInto(Table<R> into, Collection<? extends Field<?>> fields)

Create a new DSL insert statement.

<R extends Record>
@NotNull InsertValuesStepN<R>

insertInto(Table<R> into, Field<?>... fields)

Create a new DSL insert statement.

<R extends Record, T1>
@NotNull InsertValuesStep1<R,T1>

insertInto(Table<R> into, Field<T1> field1)

Create a new DSL insert statement.

<R extends Record, T1, T2>
@NotNull InsertValuesStep2<R,T1,T2>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3>
@NotNull InsertValuesStep3<R,T1,T2,T3>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4>
@NotNull InsertValuesStep4<R,T1,T2,T3,T4>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5>
@NotNull InsertValuesStep5<R,T1,T2,T3,T4,T5>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6>
@NotNull InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7>
@NotNull InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Create a new DSL insert statement.

<R extends Record>
@NotNull InsertQuery<R>

insertQuery(Table<R> into)

Create a new InsertQuery

@NotNull BigInteger

lastID()

Retrieve the last inserted ID.

<R extends Record>
@NotNull LoaderOptionsStep<R>

loadInto(Table<R> table)

Create a new Loader object to load data from a CSV or XML source.

@Nullable Schema

map(Schema schema)

Map a schema to another one.

<R extends Record>
@Nullable Table<R>

map(Table<R> table)

Map a table to another one.

<R extends Record>
@NotNull MergeUsingStep<R>

mergeInto(Table<R> table)

Create a new DSL SQL standard MERGE statement.

<R extends Record>
@NotNull MergeKeyStepN<R>

mergeInto(Table<R> table, Collection<? extends Field<?>> fields)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record>
@NotNull MergeKeyStepN<R>

mergeInto(Table<R> table, Field<?>... fields)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1>
@NotNull MergeKeyStep1<R,T1>

mergeInto(Table<R> table, Field<T1> field1)

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, via mergeInto(Table)

<R extends Record, T1, T2>
@NotNull MergeKeyStep2<R,T1,T2>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)

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, via mergeInto(Table)

<R extends Record, T1, T2, T3>
@NotNull MergeKeyStep3<R,T1,T2,T3>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)

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, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4>
@NotNull MergeKeyStep4<R,T1,T2,T3,T4>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

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, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5>
@NotNull MergeKeyStep5<R,T1,T2,T3,T4,T5>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6>
@NotNull MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7>
@NotNull MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

@NotNull Meta

meta()

Access the database meta data.

@NotNull Meta

meta(String... sources)

Create meta data from a set of sources.

@NotNull Meta

meta(DatabaseMetaData meta)

Access the database meta data from an explicit JDBC DatabaseMetaData.

@NotNull Meta

meta(Catalog... catalogs)

Access the database meta data from explicit catalog information.

@NotNull Meta

meta(Query... queries)

Create meta data from a set of DDL queries.

@NotNull Meta

meta(Schema... schemas)

Access the database meta data from explicit schema information.

@NotNull Meta

meta(Source... sources)

Create meta data from a set of sources.

@NotNull Meta

meta(Table<?>... tables)

Access the database meta data from explicit table information.

@NotNull Meta

meta(InformationSchema schema)

Access the database meta data from an explicit JAXB-annotated meta model.

@NotNull Migration

migrateTo(Commit to)

Create a migration from the currently installed version to a new version.

void

mock(MockDataProvider provider, MockRunnable mockable)

Run a MockRunnable in the context of this DSLContext 's underlying Scope.configuration()'s, and of a MockDataProvider.

<T> T

mockResult(MockDataProvider provider, MockCallable<T> mockable)

Run a MockRunnable in the context of this DSLContext 's underlying Scope.configuration()'s, and of a MockDataProvider and return the mockable's outcome.

@NotNull Record

newRecord(Collection<? extends Field<?>> fields)

Create a new empty Record.

@NotNull Record

newRecord(Field<?>... fields)

Create a new empty Record.

<T1> @NotNull Record1<T1>

newRecord(Field<T1> field1)

Create a new empty Record.

<T1, T2> @NotNull Record2<T1,T2>

newRecord(Field<T1> field1, Field<T2> field2)

Create a new empty Record.

<T1, T2, T3> @NotNull Record3<T1,T2,T3>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3)

Create a new empty Record.

<T1, T2, T3, T4>
@NotNull Record4<T1,T2,T3,T4>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Create a new empty Record.

<T1, T2, T3, T4, T5>
@NotNull Record5<T1,T2,T3,T4,T5>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6>
@NotNull Record6<T1,T2,T3,T4,T5,T6>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7>
@NotNull Record7<T1,T2,T3,T4,T5,T6,T7>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull Record8<T1,T2,T3,T4,T5,T6,T7,T8>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Create a new empty Record.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Create a new empty Record.

<R extends Record>
R

newRecord(Table<R> table)

Create a new Record that can be inserted into the corresponding table.

<R extends Record>
R

newRecord(Table<R> table, Object source)

Create a new pre-filled Record that can be inserted into the corresponding table.

<R extends UDTRecord<R>>
R

newRecord(UDT<R> type)

Create a new UDTRecord.

@NotNull Result<Record>

newResult(Collection<? extends Field<?>> fields)

Create a new empty Record.

@NotNull Result<Record>

newResult(Field<?>... fields)

Create a new empty Record.

<T1> @NotNull Result<Record1<T1>>

newResult(Field<T1> field1)

Create a new empty Result.

<T1, T2> @NotNull Result<Record2<T1,T2>>

newResult(Field<T1> field1, Field<T2> field2)

Create a new empty Result.

<T1, T2, T3> @NotNull Result<Record3<T1,T2,T3>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3)

Create a new empty Result.

<T1, T2, T3, T4>
@NotNull Result<Record4<T1,T2,T3,T4>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Create a new empty Result.

<T1, T2, T3, T4, T5>
@NotNull Result<Record5<T1,T2,T3,T4,T5>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Create a new empty Result.

<T1, T2, T3, T4, T5, T6>
@NotNull Result<Record6<T1,T2,T3,T4,T5,T6>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Create a new empty Result.

<T1, T2, T3, T4, T5, T6, T7>
@NotNull Result<Record7<T1,T2,T3,T4,T5,T6,T7>>

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 empty Result.

<T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull Result<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>

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 empty Result.

<T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull Result<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>

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 empty Result.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull Result<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>

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 empty Result.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull Result<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Create a new empty Result.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull Result<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Create a new empty Result.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull Result<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Create a new empty Result.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull Result<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Create a new empty Result.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull Result<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Create a new empty Result.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull Result<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Create a new empty Result.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull Result<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Create a new empty Result.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull Result<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Create a new empty Result.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull Result<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Create a new empty Result.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull Result<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Create a new empty Result.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull Result<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Create a new empty Result.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull Result<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>

newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Create a new empty Result.

<R extends Record>
@NotNull Result<R>

newResult(Table<R> table)

Create a new empty Result.

@NotNull BigInteger

nextval(String sequence)

Convenience method to fetch the NEXTVAL for a sequence directly from this DSLContext's underlying JDBC Connection.

@NotNull BigInteger

nextval(Name sequence)

Convenience method to fetch the NEXTVAL for a sequence directly from this DSLContext's underlying JDBC Connection.

<T extends Number>
T

nextval(Sequence<T> sequence)

Convenience method to fetch the NEXTVAL for a sequence directly from this DSLContext's underlying JDBC Connection.

<T extends Number>
@NotNull List<T>

nextvals(Sequence<T> sequence, int size)

Convenience method to fetch several NEXTVAL for a sequence directly from this DSLContext's underlying JDBC Connection.

@NotNull Parser

parser()

Access the parser API.

@NotNull Connection

parsingConnection()

A JDBC connection that runs each statement through the parser() first, prior to re-generating and running the SQL.

@NotNull io.r2dbc.spi.ConnectionFactory

parsingConnectionFactory()

An R2DBC ConnectionFactory that runs each statement through the parser() first, prior to re-generating and running the SQL.

@NotNull DataSource

parsingDataSource()

A JDBC data source that runs each statement through the parser() first, prior to re-generating and running the SQL.

@NotNull Queries

queries(Collection<? extends Query> queries)

Wrap a collection of queries.

@NotNull Queries

queries(Query... queries)

Wrap a collection of queries.

@NotNull RowCountQuery

query(String sql)

Create a new query holding plain SQL.

@NotNull RowCountQuery

query(String sql, Object... bindings)

Create a new query holding plain SQL.

@NotNull RowCountQuery

query(String sql, QueryPart... parts)

Create a new query holding plain SQL.

@NotNull RowCountQuery

query(SQL sql)

Create a new query holding plain SQL.

@NotNull String

render(QueryPart part)

Render a QueryPart in the context of this DSLContext.

@NotNull RenderContext

renderContext()

Deprecated, for removal: This API element is subject to removal in a future version.

- [#6280] - 3.10 - Do not reuse this method.

@NotNull String

renderInlined(QueryPart part)

Render a QueryPart in the context of this DSLContext, inlining all bind variables.

@NotNull String

renderNamedOrInlinedParams(QueryPart part)

Render a QueryPart in the context of this DSLContext, rendering bind variables as named parameters, or inlined parameters if they have no name.

@NotNull String

renderNamedParams(QueryPart part)

Render a QueryPart in the context of this DSLContext, rendering bind variables as named parameters.

@NotNull ResultQuery<Record>

resultQuery(String sql)

Create a new query holding plain SQL.

@NotNull ResultQuery<Record>

resultQuery(String sql, Object... bindings)

Create a new query holding plain SQL.

@NotNull ResultQuery<Record>

resultQuery(String sql, QueryPart... parts)

Create a new query holding plain SQL.

@NotNull ResultQuery<Record>

resultQuery(SQL sql)

Create a new query holding plain SQL.

@NotNull RevokeOnStep

revoke(Collection<? extends Privilege> privileges)

The REVOKE statement.

@NotNull RevokeOnStep

revoke(Privilege privileges)

The REVOKE statement.

@NotNull RevokeOnStep

revoke(Privilege... privileges)

The REVOKE statement.

@NotNull RevokeOnStep

revokeGrantOptionFor(Collection<? extends Privilege> privileges)

The REVOKE GRANT OPTION FOR statement.

@NotNull RevokeOnStep

revokeGrantOptionFor(Privilege privileges)

The REVOKE GRANT OPTION FOR statement.

@NotNull RevokeOnStep

revokeGrantOptionFor(Privilege... privileges)

The REVOKE GRANT OPTION FOR statement.

@NotNull SelectSelectStep<Record>

select(Collection<? extends SelectFieldOrAsterisk> fields)

Create a new DSL select statement.

<T1> @NotNull SelectSelectStep<Record1<T1>>

select(SelectField<T1> field1)

Create a new DSL select statement.

<T1, T2> @NotNull SelectSelectStep<Record2<T1,T2>>

select(SelectField<T1> field1, SelectField<T2> field2)

Create a new DSL select statement.

<T1, T2, T3> @NotNull SelectSelectStep<Record3<T1,T2,T3>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)

Create a new DSL select statement.

<T1, T2, T3, T4>
@NotNull SelectSelectStep<Record4<T1,T2,T3,T4>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)

Create a new DSL select statement.

<T1, T2, T3, T4, T5>
@NotNull SelectSelectStep<Record5<T1,T2,T3,T4,T5>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6>
@NotNull SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7>
@NotNull SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull SelectSelectStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull SelectSelectStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull SelectSelectStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull SelectSelectStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull SelectSelectStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull SelectSelectStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull SelectSelectStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull SelectSelectStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull SelectSelectStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull SelectSelectStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull SelectSelectStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull SelectSelectStep<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>

select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22)

Create a new DSL select statement.

@NotNull SelectSelectStep<Record>

select(SelectFieldOrAsterisk... fields)

Create a new DSL select statement.

@NotNull SelectSelectStep<Record1<Integer>>

selectCount()

Create a new DSL select statement for COUNT(*).

@NotNull SelectSelectStep<Record>

selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)

Create a new DSL select statement.

<T1> @NotNull SelectSelectStep<Record1<T1>>

selectDistinct(SelectField<T1> field1)

Create a new DSL select statement.

<T1, T2> @NotNull SelectSelectStep<Record2<T1,T2>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2)

Create a new DSL select statement.

<T1, T2, T3> @NotNull SelectSelectStep<Record3<T1,T2,T3>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)

Create a new DSL select statement.

<T1, T2, T3, T4>
@NotNull SelectSelectStep<Record4<T1,T2,T3,T4>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)

Create a new DSL select statement.

<T1, T2, T3, T4, T5>
@NotNull SelectSelectStep<Record5<T1,T2,T3,T4,T5>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6>
@NotNull SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7>
@NotNull SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull SelectSelectStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull SelectSelectStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull SelectSelectStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull SelectSelectStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull SelectSelectStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull SelectSelectStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull SelectSelectStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull SelectSelectStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull SelectSelectStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull SelectSelectStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull SelectSelectStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21)

Create a new DSL select statement.

<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull SelectSelectStep<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>

selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22)

Create a new DSL select statement.

@NotNull SelectSelectStep<Record>

selectDistinct(SelectFieldOrAsterisk... fields)

Create a new DSL select statement.

@NotNull SelectWhereStep<Record>

selectFrom(String sql)

Create a new DSL select statement, projecting *.

@NotNull SelectWhereStep<Record>

selectFrom(String sql, Object... bindings)

Create a new DSL select statement, projecting *.

@NotNull SelectWhereStep<Record>

selectFrom(String sql, QueryPart... parts)

Create a new DSL select statement, projecting *.

@NotNull SelectWhereStep<Record>

selectFrom(Name table)

Create a new DSL select statement, projecting *.

@NotNull SelectWhereStep<Record>

selectFrom(SQL sql)

Create a new DSL select statement, projecting *.

<R extends Record>
@NotNull SelectWhereStep<R>

selectFrom(TableLike<R> table)

Create a new DSL select statement, projecting the known columns from a table.

@NotNull SelectSelectStep<Record1<Integer>>

selectOne()

Create a new DSL select statement for a constant 1 literal.

@NotNull SelectQuery<Record>

selectQuery()

Create a new SelectQuery

<R extends Record>
@NotNull SelectQuery<R>

selectQuery(TableLike<R> table)

Create a new SelectQuery

@NotNull SelectSelectStep<Record1<Integer>>

selectZero()

Create a new DSL select statement for a constant 0 literal.

@NotNull RowCountQuery

set(Name name, Param<?> value)

The SET statement.

@NotNull RowCountQuery

setCatalog(String catalog)

The SET CATALOG statement.

@NotNull RowCountQuery

setCatalog(Catalog catalog)

The SET CATALOG statement.

@NotNull RowCountQuery

setCatalog(Name catalog)

The SET CATALOG statement.

@NotNull RowCountQuery

setLocal(Name name, Param<?> value)

The SET LOCAL statement.

@NotNull RowCountQuery

setSchema(String schema)

The SET SCHEMA statement.

@NotNull RowCountQuery

setSchema(Name schema)

The SET SCHEMA statement.

@NotNull RowCountQuery

setSchema(Schema schema)

The SET SCHEMA statement.

@NotNull Block

statements(Collection<? extends Statement> statements)

Wrap a collection of statements in an anonymous procedural block that does not wrap in BEGIN … END;, unless explicitly needed.

@NotNull Block

statements(Statement... statements)

Wrap a collection of statements in an anonymous procedural block that does not wrap in BEGIN … END;, unless explicitly needed.

void

transaction(ContextTransactionalRunnable transactional)

Run a ContextTransactionalRunnable in the context of this DSLContext's underlying Scope.configuration()'s Configuration.transactionProvider().

void

transaction(TransactionalRunnable transactional)

Run a TransactionalRunnable in the context of this DSLContext's underlying Scope.configuration()'s Configuration.transactionProvider().

@NotNull CompletionStage<Void>

transactionAsync(Executor executor, TransactionalRunnable transactional)

Run a TransactionalRunnable asynchronously.

@NotNull CompletionStage<Void>

transactionAsync(TransactionalRunnable transactional)

Run a TransactionalRunnable asynchronously.

<T> @NotNull Publisher<T>

transactionPublisher(TransactionalPublishable<T> transactional)

Run a TransactionalPublishable reactively.

<T> T

transactionResult(ContextTransactionalCallable<T> transactional)

Run a ContextTransactionalRunnable in the context of this DSLContext's underlying Scope.configuration()'s Configuration.transactionProvider(), and return the transactional's outcome.

<T> T

transactionResult(TransactionalCallable<T> transactional)

Run a TransactionalCallable in the context of this DSLContext's underlying Scope.configuration()'s Configuration.transactionProvider(), and return the transactional's outcome.

<T> @NotNull CompletionStage<T>

transactionResultAsync(Executor executor, TransactionalCallable<T> transactional)

Run a TransactionalCallable asynchronously.

<T> @NotNull CompletionStage<T>

transactionResultAsync(TransactionalCallable<T> transactional)

Run a TransactionalCallable asynchronously.

@NotNull TruncateIdentityStep<Record>

truncate(String table)

The TRUNCATE statement.

@NotNull TruncateIdentityStep<Record>

truncate(Name table)

The TRUNCATE statement.

<R extends Record>
@NotNull TruncateIdentityStep<R>

truncate(Table<R> table)

The TRUNCATE statement.

@NotNull TruncateIdentityStep<Record>

truncateTable(String table)

The TRUNCATE TABLE statement.

@NotNull TruncateIdentityStep<Record>

truncateTable(Name table)

The TRUNCATE TABLE statement.

<R extends Record>
@NotNull TruncateIdentityStep<R>

truncateTable(Table<R> table)

The TRUNCATE TABLE statement.

<R extends Record>
@NotNull UpdateSetFirstStep<R>

update(Table<R> table)

Create a new DSL update statement.

<R extends Record>
@NotNull UpdateQuery<R>

updateQuery(Table<R> table)

Create a new UpdateQuery

@NotNull Version

version(String id)

Initialise a Version.

@NotNull Versions

versions()

Initialise a Versions graph.

@NotNull WithAsStep

with(String alias)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep1

with(String alias, String fieldAlias1)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep

with(String alias, String... fieldAliases)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep2

with(String alias, String fieldAlias1, String fieldAlias2)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep3

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep4

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep5

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep6

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep7

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep8

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep9

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep10

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep11

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep12

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep13

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep14

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep15

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep16

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep17

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep18

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17, String fieldAlias18)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep19

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17, String fieldAlias18, String fieldAlias19)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep20

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17, String fieldAlias18, String fieldAlias19, String fieldAlias20)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep21

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17, String fieldAlias18, String fieldAlias19, String fieldAlias20, String fieldAlias21)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep22

with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17, String fieldAlias18, String fieldAlias19, String fieldAlias20, String fieldAlias21, String fieldAlias22)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep

with(String alias, Collection<String> fieldAliases)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep

with(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull WithAsStep

with(String alias, Function<? super Field<?>,? extends String> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull WithStep

with(Collection<? extends CommonTableExpression<?>> tables)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithStep

with(CommonTableExpression<?>... tables)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep

with(Name alias)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep

with(Name alias, Collection<? extends Name> fieldAliases)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep1

with(Name alias, Name fieldAlias1)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep

with(Name alias, Name... fieldAliases)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep2

with(Name alias, Name fieldAlias1, Name fieldAlias2)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep3

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep4

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep5

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep6

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep7

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep8

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep9

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep10

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep11

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep12

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep13

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep14

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep15

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep16

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep17

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep18

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep19

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep20

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep21

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep22

with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21, Name fieldAlias22)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep

withRecursive(String alias)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep1

withRecursive(String alias, String fieldAlias1)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep

withRecursive(String alias, String... fieldAliases)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep2

withRecursive(String alias, String fieldAlias1, String fieldAlias2)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep3

withRecursive(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3)

Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

@NotNull WithAsStep4

withRecursive(String alias, String fieldAlias1, St