Top Description Methods
org.jooq

public Interface DSLContext

extends Scope
Known Direct Subinterfaces
org.jooq.CloseableDSLContext
Known Direct Implementers
org.jooq.impl.DefaultDSLContext
Static Imports
org.jooq.SQLDialect.CUBRID, .SQLDialect.DERBY, .SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.HSQLDB, .SQLDialect.IGNITE, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, .SQLDialect.YUGABYTEDB

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 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 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 TypeMethod and Description
public @NotNull AlterDatabaseStep
alterDatabase(String database)

The ALTER DATABASE statement.

public @NotNull AlterDatabaseStep
alterDatabase(Name database)

The ALTER DATABASE statement.

public @NotNull AlterDatabaseStep
alterDatabase(Catalog database)

The ALTER DATABASE statement.

public @NotNull AlterDatabaseStep
alterDatabaseIfExists(String database)

The ALTER DATABASE IF EXISTS statement.

public @NotNull AlterDatabaseStep
alterDatabaseIfExists(Name database)

The ALTER DATABASE IF EXISTS statement.

public @NotNull AlterDatabaseStep
alterDatabaseIfExists(Catalog database)

The ALTER DATABASE IF EXISTS statement.

public <T> @NotNull AlterDomainStep<T>
alterDomain(String domain)

The ALTER DOMAIN statement.

public <T> @NotNull AlterDomainStep<T>
alterDomain(Name domain)

The ALTER DOMAIN statement.

public <T> @NotNull AlterDomainStep<T>
alterDomain(Domain<T> domain)

The ALTER DOMAIN statement.

public <T> @NotNull AlterDomainStep<T>
alterDomainIfExists(String domain)

The ALTER DOMAIN IF EXISTS statement.

public <T> @NotNull AlterDomainStep<T>
alterDomainIfExists(Name domain)

The ALTER DOMAIN IF EXISTS statement.

public <T> @NotNull AlterDomainStep<T>
alterDomainIfExists(Domain<T> domain)

The ALTER DOMAIN IF EXISTS statement.

public @NotNull AlterIndexOnStep
alterIndex(String index)

The ALTER INDEX statement.

public @NotNull AlterIndexOnStep
alterIndex(Name index)

The ALTER INDEX statement.

public @NotNull AlterIndexOnStep
alterIndex(Index index)

The ALTER INDEX statement.

public @NotNull AlterIndexOnStep
alterIndexIfExists(String index)

The ALTER INDEX IF EXISTS statement.

public @NotNull AlterIndexOnStep
alterIndexIfExists(Name index)

The ALTER INDEX IF EXISTS statement.

public @NotNull AlterIndexOnStep
alterIndexIfExists(Index index)

The ALTER INDEX IF EXISTS statement.

public @NotNull AlterSchemaStep
alterSchema(String schema)

The ALTER SCHEMA statement.

public @NotNull AlterSchemaStep
alterSchema(Name schema)

The ALTER SCHEMA statement.

public @NotNull AlterSchemaStep
alterSchema(Schema schema)

The ALTER SCHEMA statement.

public @NotNull AlterSchemaStep
alterSchemaIfExists(String schema)

The ALTER SCHEMA IF EXISTS statement.

public @NotNull AlterSchemaStep
alterSchemaIfExists(Name schema)

The ALTER SCHEMA IF EXISTS statement.

public @NotNull AlterSchemaStep
alterSchemaIfExists(Schema schema)

The ALTER SCHEMA IF EXISTS statement.

public @NotNull AlterSequenceStep<Number>
alterSequence(String sequence)

Deprecated as a consequence of AlterSequenceStep being deprecated.
The ALTER SEQUENCE statement.
public @NotNull AlterSequenceStep<Number>
alterSequence(Name sequence)

Deprecated as a consequence of AlterSequenceStep being deprecated.
The ALTER SEQUENCE statement.
public <T extends Number> @NotNull AlterSequenceStep<T>
alterSequence(Sequence<T> sequence)

Deprecated as a consequence of AlterSequenceStep being deprecated.
The ALTER SEQUENCE statement.
public @NotNull AlterSequenceStep<Number>
alterSequenceIfExists(String sequence)

Deprecated as a consequence of AlterSequenceStep being deprecated.
The ALTER SEQUENCE IF EXISTS statement.
public @NotNull AlterSequenceStep<Number>
alterSequenceIfExists(Name sequence)

Deprecated as a consequence of AlterSequenceStep being deprecated.
The ALTER SEQUENCE IF EXISTS statement.
public <T extends Number> @NotNull AlterSequenceStep<T>
alterSequenceIfExists(Sequence<T> sequence)

Deprecated as a consequence of AlterSequenceStep being deprecated.
The ALTER SEQUENCE IF EXISTS statement.
public @NotNull AlterTableStep
alterTable(String table)

Create a new DSL ALTER TABLE statement.

public @NotNull AlterTableStep
alterTable(Name table)

Create a new DSL ALTER TABLE statement.

public @NotNull AlterTableStep
alterTable(Table<?> table)

Create a new DSL ALTER TABLE statement.

public @NotNull AlterTableStep
alterTableIfExists(String table)

Create a new DSL ALTER TABLE statement.

public @NotNull AlterTableStep
alterTableIfExists(Name table)

Create a new DSL ALTER TABLE statement.

public @NotNull AlterTableStep
alterTableIfExists(Table<?> table)

Create a new DSL ALTER TABLE statement.

public @NotNull AlterTypeStep
alterType(String type)

The ALTER TYPE statement.

public @NotNull AlterTypeStep
alterType(Name type)

The ALTER TYPE statement.

public @NotNull AlterViewStep
alterView(String view)

The ALTER VIEW statement.

public @NotNull AlterViewStep
alterView(Name view)

The ALTER VIEW statement.

public @NotNull AlterViewStep
alterView(Table<?> view)

The ALTER VIEW statement.

public @NotNull AlterViewStep
alterView(Table<?> view, Field<?>... fields)

Deprecated as a consequence of Field being deprecated.
The ALTER VIEW statement.
public @NotNull AlterViewStep
alterView(Table<?> view, Collection<? extends Field<?>> fields)

The ALTER VIEW statement.

public @NotNull AlterViewStep
alterViewIfExists(String view)

The ALTER VIEW IF EXISTS statement.

public @NotNull AlterViewStep
alterViewIfExists(Name view)

The ALTER VIEW IF EXISTS statement.

public @NotNull AlterViewStep
alterViewIfExists(Table<?> view)

The ALTER VIEW IF EXISTS statement.

public void
attach(Attachable... attachables)

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

public void
attach(Collection<? extends Attachable> attachables)

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

public @NotNull Batch
batch(Query... queries)

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

public @NotNull Batch
batch(Queries queries)

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

public @NotNull Batch
batch(String... queries)

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

public @NotNull Batch
batch(Collection<? extends Query> queries)

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

public @NotNull BatchBindStep
batch(Query query)

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

public @NotNull BatchBindStep
batch(String sql)

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

public @NotNull Batch
batch(Query query, Object[]... bindings)

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

public @NotNull Batch
batch(String sql, Object[]... bindings)

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

public @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.

public @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.

public void
batched(BatchedRunnable runnable)

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

public <T> T
batchedResult(BatchedCallable<T> callable)

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

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @NotNull Block
begin(Statement... statements)

Wrap a collection of statements in an anonymous procedural block.

public @NotNull Block
begin(Collection<? extends Statement> statements)

Wrap a collection of statements in an anoymous procedural block.

public @NotNull BindContext
bindContext(PreparedStatement stmt)

Deprecated for removal since 3.10. - [#6280] - 3.10 - Do not reuse this method. It will be completely internal with jOOQ 4.0
Get a new BindContext for the context of this DSLContext.
public @NotNull CommentOnIsStep
commentOnColumn(String field)

The COMMENT ON COLUMN statement.

public @NotNull CommentOnIsStep
commentOnColumn(Name field)

The COMMENT ON COLUMN statement.

public @NotNull CommentOnIsStep
commentOnColumn(Field<?> field)

Deprecated as a consequence of Field being deprecated.
The COMMENT ON COLUMN statement.
public @NotNull CommentOnIsStep
commentOnTable(String table)

The COMMENT ON TABLE statement.

public @NotNull CommentOnIsStep
commentOnTable(Name table)

The COMMENT ON TABLE statement.

public @NotNull CommentOnIsStep
commentOnTable(Table<?> table)

The COMMENT ON TABLE statement.

public @NotNull CommentOnIsStep
commentOnView(String view)

The COMMENT ON VIEW statement.

public @NotNull CommentOnIsStep
commentOnView(Name view)

The COMMENT ON VIEW statement.

public @NotNull CommentOnIsStep
commentOnView(Table<?> view)

The COMMENT ON VIEW statement.

public @NotNull Query
commit()

The COMMIT statement.

public void
connection(ConnectionRunnable
The code running statements against the connection.
runnable
)

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

public <T> T

Returns:

The outcome of the callable
connectionResult
(ConnectionCallable<T>
The code running statements against the connection.
callable
)

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

public @NotNull CreateDatabaseFinalStep
createDatabase(String database)

Deprecated as a consequence of CreateDatabaseFinalStep being deprecated.
The CREATE DATABASE statement.
public @NotNull CreateDatabaseFinalStep
createDatabase(Name database)

Deprecated as a consequence of CreateDatabaseFinalStep being deprecated.
The CREATE DATABASE statement.
public @NotNull CreateDatabaseFinalStep
createDatabase(Catalog database)

Deprecated as a consequence of CreateDatabaseFinalStep being deprecated.
The CREATE DATABASE statement.
public @NotNull CreateDatabaseFinalStep
createDatabaseIfNotExists(String database)

Deprecated as a consequence of CreateDatabaseFinalStep being deprecated.
The CREATE DATABASE IF NOT EXISTS statement.
public @NotNull CreateDatabaseFinalStep
createDatabaseIfNotExists(Name database)

Deprecated as a consequence of CreateDatabaseFinalStep being deprecated.
The CREATE DATABASE IF NOT EXISTS statement.
public @NotNull CreateDatabaseFinalStep
createDatabaseIfNotExists(Catalog database)

Deprecated as a consequence of CreateDatabaseFinalStep being deprecated.
The CREATE DATABASE IF NOT EXISTS statement.
public @NotNull CreateDomainAsStep
createDomain(String domain)

The CREATE DOMAIN statement.

public @NotNull CreateDomainAsStep
createDomain(Name domain)

The CREATE DOMAIN statement.

public @NotNull CreateDomainAsStep
createDomain(Domain<?> domain)

The CREATE DOMAIN statement.

public @NotNull CreateDomainAsStep
createDomainIfNotExists(String domain)

The CREATE DOMAIN IF NOT EXISTS statement.

public @NotNull CreateDomainAsStep
createDomainIfNotExists(Name domain)

The CREATE DOMAIN IF NOT EXISTS statement.

public @NotNull CreateDomainAsStep
createDomainIfNotExists(Domain<?> domain)

The CREATE DOMAIN IF NOT EXISTS statement.

public @NotNull CreateTableElementListStep
createGlobalTemporaryTable(String table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE GLOBAL TEMPORARY TABLE statement.
public @NotNull CreateTableElementListStep
createGlobalTemporaryTable(Name table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE GLOBAL TEMPORARY TABLE statement.
public @NotNull CreateTableElementListStep
createGlobalTemporaryTable(Table<?> table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE GLOBAL TEMPORARY TABLE statement.
public @NotNull CreateTableElementListStep
createGlobalTemporaryTableIfNotExists(String table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS statement.
public @NotNull CreateTableElementListStep
createGlobalTemporaryTableIfNotExists(Name table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS statement.
public @NotNull CreateTableElementListStep
createGlobalTemporaryTableIfNotExists(Table<?> table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS statement.
public @NotNull CreateIndexStep
createIndex(String index)

The CREATE INDEX statement.

public @NotNull CreateIndexStep
createIndex(Name index)

The CREATE INDEX statement.

public @NotNull CreateIndexStep
createIndex(Index index)

The CREATE INDEX statement.

public @NotNull CreateIndexStep
createIndex()

The CREATE INDEX statement.

public @NotNull CreateIndexStep
createIndexIfNotExists(String index)

The CREATE INDEX IF NOT EXISTS statement.

public @NotNull CreateIndexStep
createIndexIfNotExists(Name index)

The CREATE INDEX IF NOT EXISTS statement.

public @NotNull CreateIndexStep
createIndexIfNotExists(Index index)

The CREATE INDEX IF NOT EXISTS statement.

public @NotNull CreateIndexStep
createIndexIfNotExists()

The CREATE INDEX IF NOT EXISTS statement.

public @NotNull CreateViewAsStep<Record>
createOrReplaceView(String view, String... fields)

Create a new DSL CREATE OR REPLACE VIEW statement.

public @NotNull CreateViewAsStep<Record>
createOrReplaceView(Name view, Name... fields)

Create a new DSL CREATE OR REPLACE VIEW statement.

public @NotNull CreateViewAsStep<Record>
createOrReplaceView(Table<?> view, Field<?>... fields)

Deprecated as a consequence of Field being deprecated.
Create a new DSL CREATE OR REPLACE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createOrReplaceView(String view, Function<? super Field<?>, ? extends String> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE OR REPLACE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createOrReplaceView(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE OR REPLACE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createOrReplaceView(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE OR REPLACE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createOrReplaceView(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE OR REPLACE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createOrReplaceView(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE OR REPLACE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createOrReplaceView(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE OR REPLACE VIEW statement.
public @NotNull CreateSchemaFinalStep
createSchema(String schema)

Deprecated as a consequence of CreateSchemaFinalStep being deprecated.
The CREATE SCHEMA statement.
public @NotNull CreateSchemaFinalStep
createSchema(Name schema)

Deprecated as a consequence of CreateSchemaFinalStep being deprecated.
The CREATE SCHEMA statement.
public @NotNull CreateSchemaFinalStep
createSchema(Schema schema)

Deprecated as a consequence of CreateSchemaFinalStep being deprecated.
The CREATE SCHEMA statement.
public @NotNull CreateSchemaFinalStep
createSchemaIfNotExists(String schema)

Deprecated as a consequence of CreateSchemaFinalStep being deprecated.
The CREATE SCHEMA IF NOT EXISTS statement.
public @NotNull CreateSchemaFinalStep
createSchemaIfNotExists(Name schema)

Deprecated as a consequence of CreateSchemaFinalStep being deprecated.
The CREATE SCHEMA IF NOT EXISTS statement.
public @NotNull CreateSchemaFinalStep
createSchemaIfNotExists(Schema schema)

Deprecated as a consequence of CreateSchemaFinalStep being deprecated.
The CREATE SCHEMA IF NOT EXISTS statement.
public @NotNull CreateSequenceFlagsStep
createSequence(String sequence)

Deprecated as a consequence of CreateSequenceFlagsStep being deprecated.
The CREATE SEQUENCE statement.
public @NotNull CreateSequenceFlagsStep
createSequence(Name sequence)

Deprecated as a consequence of CreateSequenceFlagsStep being deprecated.
The CREATE SEQUENCE statement.
public @NotNull CreateSequenceFlagsStep
createSequence(Sequence<?> sequence)

Deprecated as a consequence of CreateSequenceFlagsStep being deprecated.
The CREATE SEQUENCE statement.
public @NotNull CreateSequenceFlagsStep
createSequenceIfNotExists(String sequence)

Deprecated as a consequence of CreateSequenceFlagsStep being deprecated.
The CREATE SEQUENCE IF NOT EXISTS statement.
public @NotNull CreateSequenceFlagsStep
createSequenceIfNotExists(Name sequence)

Deprecated as a consequence of CreateSequenceFlagsStep being deprecated.
The CREATE SEQUENCE IF NOT EXISTS statement.
public @NotNull CreateSequenceFlagsStep
createSequenceIfNotExists(Sequence<?> sequence)

Deprecated as a consequence of CreateSequenceFlagsStep being deprecated.
The CREATE SEQUENCE IF NOT EXISTS statement.
public @NotNull CreateTableElementListStep
createTable(String table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE TABLE statement.
public @NotNull CreateTableElementListStep
createTable(Name table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE TABLE statement.
public @NotNull CreateTableElementListStep
createTable(Table<?> table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE TABLE statement.
public @NotNull CreateTableElementListStep
createTableIfNotExists(String table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE TABLE IF NOT EXISTS statement.
public @NotNull CreateTableElementListStep
createTableIfNotExists(Name table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE TABLE IF NOT EXISTS statement.
public @NotNull CreateTableElementListStep
createTableIfNotExists(Table<?> table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE TABLE IF NOT EXISTS statement.
public @NotNull CreateTableElementListStep
createTemporaryTable(String table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE TEMPORARY TABLE statement.
public @NotNull CreateTableElementListStep
createTemporaryTable(Name table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE TEMPORARY TABLE statement.
public @NotNull CreateTableElementListStep
createTemporaryTable(Table<?> table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE TEMPORARY TABLE statement.
public @NotNull CreateTableElementListStep
createTemporaryTableIfNotExists(String table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE TEMPORARY TABLE IF NOT EXISTS statement.
public @NotNull CreateTableElementListStep
createTemporaryTableIfNotExists(Name table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE TEMPORARY TABLE IF NOT EXISTS statement.
public @NotNull CreateTableElementListStep
createTemporaryTableIfNotExists(Table<?> table)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
The CREATE TEMPORARY TABLE IF NOT EXISTS statement.
public @NotNull CreateTypeStep
createType(String type)

Create a new DSL CREATE TYPE statement.

public @NotNull CreateTypeStep
createType(Name type)

Create a new DSL CREATE TYPE statement.

public @NotNull CreateIndexStep
createUniqueIndex(String index)

The CREATE UNIQUE INDEX statement.

public @NotNull CreateIndexStep
createUniqueIndex(Name index)

The CREATE UNIQUE INDEX statement.

public @NotNull CreateIndexStep
createUniqueIndex(Index index)

The CREATE UNIQUE INDEX statement.

public @NotNull CreateIndexStep
createUniqueIndex()

The CREATE UNIQUE INDEX statement.

public @NotNull CreateIndexStep
createUniqueIndexIfNotExists(String index)

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

public @NotNull CreateIndexStep
createUniqueIndexIfNotExists(Name index)

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

public @NotNull CreateIndexStep
createUniqueIndexIfNotExists(Index index)

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

public @NotNull CreateIndexStep
createUniqueIndexIfNotExists()

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

public @NotNull CreateViewAsStep<Record>
createView(String view, String... fields)

Create a new DSL CREATE VIEW statement.

public @NotNull CreateViewAsStep<Record>
createView(Name view, Name... fields)

Create a new DSL CREATE VIEW statement.

public @NotNull CreateViewAsStep<Record>
createView(Table<?> view, Field<?>... fields)

Deprecated as a consequence of Field being deprecated.
Create a new DSL CREATE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createView(String view, Function<? super Field<?>, ? extends String> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createView(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createView(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createView(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createView(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createView(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createViewIfNotExists(String view, String... fields)

Create a new DSL CREATE VIEW statement.

public @NotNull CreateViewAsStep<Record>
createViewIfNotExists(Name view, Name... fields)

Create a new DSL CREATE VIEW statement.

public @NotNull CreateViewAsStep<Record>
createViewIfNotExists(Table<?> view, Field<?>... fields)

Deprecated as a consequence of Field being deprecated.
Create a new DSL CREATE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createViewIfNotExists(String view, Function<? super Field<?>, ? extends String> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createViewIfNotExists(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createViewIfNotExists(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createViewIfNotExists(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createViewIfNotExists(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE VIEW statement.
public @NotNull CreateViewAsStep<Record>
createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a new DSL CREATE VIEW statement.
public @NotNull BigInteger
currval(String sequence)

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

public @NotNull BigInteger
currval(Name sequence)

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

public <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.

public @NotNull Queries
ddl(Catalog catalog)

Convenience method for Meta#ddl().

public @NotNull Queries
ddl(Catalog schema, DDLExportConfiguration configuration)

Convenience method for Meta#ddl(DDLExportConfiguration).

public @NotNull Queries
ddl(Catalog schema, DDLFlag... flags)

Convenience method for Meta#ddl(DDLExportConfiguration).

public @NotNull Queries
ddl(Schema schema)

Convenience method for Meta#ddl().

public @NotNull Queries
ddl(Schema schema, DDLExportConfiguration configuration)

Convenience method for Meta#ddl(DDLExportConfiguration).

public @NotNull Queries
ddl(Schema schema, DDLFlag... flags)

Convenience method for Meta#ddl(DDLExportConfiguration).

public @NotNull Queries
ddl(Table<?> table)

Convenience method for Meta#ddl().

public @NotNull Queries
ddl(Table<?> table, DDLExportConfiguration configuration)

Convenience method for Meta#ddl(DDLExportConfiguration).

public @NotNull Queries
ddl(Table<?> table, DDLFlag... flags)

Convenience method for Meta#ddl(DDLExportConfiguration).

public @NotNull Queries
ddl(Table<?>... tables)

Convenience method for Meta#ddl().

public @NotNull Queries
ddl(Table<?>[] tables, DDLExportConfiguration configuration)

Convenience method for Meta#ddl(DDLExportConfiguration).

public @NotNull Queries
ddl(Table<?>[] tables, DDLFlag... flags)

Convenience method for Meta#ddl(DDLExportConfiguration).

public @NotNull Queries
ddl(Collection<? extends Table<?>> tables)

Convenience method for Meta#ddl().

public @NotNull Queries
ddl(Collection<? extends Table<?>> tables, DDLFlag... flags)

Convenience method for Meta#ddl(DDLExportConfiguration).

public @NotNull Queries
ddl(Collection<? extends Table<?>> tables, DDLExportConfiguration configuration)

Convenience method for Meta#ddl(DDLExportConfiguration).

public <R extends Record> @NotNull DeleteUsingStep<R>
delete(Table<R> table)

Deprecated as a consequence of DeleteUsingStep being deprecated.
Create a new DSL delete statement.
public <R extends Record> @NotNull DeleteUsingStep<R>
deleteFrom(Table<R> table)

Deprecated as a consequence of DeleteUsingStep being deprecated.
Create a new DSL delete statement.
public <R extends Record> @NotNull DeleteQuery<R>

Returns:

The new DeleteQuery
deleteQuery
(Table<R>
The table to delete data from
table
)

Deprecated as a consequence of DeleteQuery being deprecated.
Create a new DeleteQuery
public @NotNull Connection
diagnosticsConnection()

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

public @NotNull DataSource
diagnosticsDataSource()

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

public @NotNull DropDatabaseFinalStep
dropDatabase(String database)

Deprecated as a consequence of DropDatabaseFinalStep being deprecated.
The DROP DATABASE statement.
public @NotNull DropDatabaseFinalStep
dropDatabase(Name database)

Deprecated as a consequence of DropDatabaseFinalStep being deprecated.
The DROP DATABASE statement.
public @NotNull DropDatabaseFinalStep
dropDatabase(Catalog database)

Deprecated as a consequence of DropDatabaseFinalStep being deprecated.
The DROP DATABASE statement.
public @NotNull DropDatabaseFinalStep
dropDatabaseIfExists(String database)

Deprecated as a consequence of DropDatabaseFinalStep being deprecated.
The DROP DATABASE IF EXISTS statement.
public @NotNull DropDatabaseFinalStep
dropDatabaseIfExists(Name database)

Deprecated as a consequence of DropDatabaseFinalStep being deprecated.
The DROP DATABASE IF EXISTS statement.
public @NotNull DropDatabaseFinalStep
dropDatabaseIfExists(Catalog database)

Deprecated as a consequence of DropDatabaseFinalStep being deprecated.
The DROP DATABASE IF EXISTS statement.
public @NotNull DropDomainCascadeStep
dropDomain(String domain)

Deprecated as a consequence of DropDomainCascadeStep being deprecated.
The DROP DOMAIN statement.
public @NotNull DropDomainCascadeStep
dropDomain(Name domain)

Deprecated as a consequence of DropDomainCascadeStep being deprecated.
The DROP DOMAIN statement.
public @NotNull DropDomainCascadeStep
dropDomain(Domain<?> domain)

Deprecated as a consequence of DropDomainCascadeStep being deprecated.
The DROP DOMAIN statement.
public @NotNull DropDomainCascadeStep
dropDomainIfExists(String domain)

Deprecated as a consequence of DropDomainCascadeStep being deprecated.
The DROP DOMAIN IF EXISTS statement.
public @NotNull DropDomainCascadeStep
dropDomainIfExists(Name domain)

Deprecated as a consequence of DropDomainCascadeStep being deprecated.
The DROP DOMAIN IF EXISTS statement.
public @NotNull DropDomainCascadeStep
dropDomainIfExists(Domain<?> domain)

Deprecated as a consequence of DropDomainCascadeStep being deprecated.
The DROP DOMAIN IF EXISTS statement.
public @NotNull DropIndexOnStep
dropIndex(String index)

Deprecated as a consequence of DropIndexOnStep being deprecated.
The DROP INDEX statement.
public @NotNull DropIndexOnStep
dropIndex(Name index)

Deprecated as a consequence of DropIndexOnStep being deprecated.
The DROP INDEX statement.
public @NotNull DropIndexOnStep
dropIndex(Index index)

Deprecated as a consequence of DropIndexOnStep being deprecated.
The DROP INDEX statement.
public @NotNull DropIndexOnStep
dropIndexIfExists(String index)

Deprecated as a consequence of DropIndexOnStep being deprecated.
The DROP INDEX IF EXISTS statement.
public @NotNull DropIndexOnStep
dropIndexIfExists(Name index)

Deprecated as a consequence of DropIndexOnStep being deprecated.
The DROP INDEX IF EXISTS statement.
public @NotNull DropIndexOnStep
dropIndexIfExists(Index index)

Deprecated as a consequence of DropIndexOnStep being deprecated.
The DROP INDEX IF EXISTS statement.
public @NotNull DropSchemaStep
dropSchema(String schema)

Deprecated as a consequence of DropSchemaStep being deprecated.
The DROP SCHEMA statement.
public @NotNull DropSchemaStep
dropSchema(Name schema)

Deprecated as a consequence of DropSchemaStep being deprecated.
The DROP SCHEMA statement.
public @NotNull DropSchemaStep
dropSchema(Schema schema)

Deprecated as a consequence of DropSchemaStep being deprecated.
The DROP SCHEMA statement.
public @NotNull DropSchemaStep
dropSchemaIfExists(String schema)

Deprecated as a consequence of DropSchemaStep being deprecated.
The DROP SCHEMA IF EXISTS statement.
public @NotNull DropSchemaStep
dropSchemaIfExists(Name schema)

Deprecated as a consequence of DropSchemaStep being deprecated.
The DROP SCHEMA IF EXISTS statement.
public @NotNull DropSchemaStep
dropSchemaIfExists(Schema schema)

Deprecated as a consequence of DropSchemaStep being deprecated.
The DROP SCHEMA IF EXISTS statement.
public @NotNull DropSequenceFinalStep
dropSequence(String sequence)

Deprecated as a consequence of DropSequenceFinalStep being deprecated.
The DROP SEQUENCE statement.
public @NotNull DropSequenceFinalStep
dropSequence(Name sequence)

Deprecated as a consequence of DropSequenceFinalStep being deprecated.
The DROP SEQUENCE statement.
public @NotNull DropSequenceFinalStep
dropSequence(Sequence<?> sequence)

Deprecated as a consequence of DropSequenceFinalStep being deprecated.
The DROP SEQUENCE statement.
public @NotNull DropSequenceFinalStep
dropSequenceIfExists(String sequence)

Deprecated as a consequence of DropSequenceFinalStep being deprecated.
The DROP SEQUENCE IF EXISTS statement.
public @NotNull DropSequenceFinalStep
dropSequenceIfExists(Name sequence)

Deprecated as a consequence of DropSequenceFinalStep being deprecated.
The DROP SEQUENCE IF EXISTS statement.
public @NotNull DropSequenceFinalStep
dropSequenceIfExists(Sequence<?> sequence)

Deprecated as a consequence of DropSequenceFinalStep being deprecated.
The DROP SEQUENCE IF EXISTS statement.
public @NotNull DropTableStep
dropTable(String table)

Deprecated as a consequence of DropTableStep being deprecated.
The DROP TABLE statement.
public @NotNull DropTableStep
dropTable(Name table)

Deprecated as a consequence of DropTableStep being deprecated.
The DROP TABLE statement.
public @NotNull DropTableStep
dropTable(Table<?> table)

Deprecated as a consequence of DropTableStep being deprecated.
The DROP TABLE statement.
public @NotNull DropTableStep
dropTableIfExists(String table)

Deprecated as a consequence of DropTableStep being deprecated.
The DROP TABLE IF EXISTS statement.
public @NotNull DropTableStep
dropTableIfExists(Name table)

Deprecated as a consequence of DropTableStep being deprecated.
The DROP TABLE IF EXISTS statement.
public @NotNull DropTableStep
dropTableIfExists(Table<?> table)

Deprecated as a consequence of DropTableStep being deprecated.
The DROP TABLE IF EXISTS statement.
public @NotNull DropTableStep
dropTemporaryTable(String table)

Deprecated as a consequence of DropTableStep being deprecated.
The DROP TEMPORARY TABLE statement.
public @NotNull DropTableStep
dropTemporaryTable(Name table)

Deprecated as a consequence of DropTableStep being deprecated.
The DROP TEMPORARY TABLE statement.
public @NotNull DropTableStep
dropTemporaryTable(Table<?> table)

Deprecated as a consequence of DropTableStep being deprecated.
The DROP TEMPORARY TABLE statement.
public @NotNull DropTableStep
dropTemporaryTableIfExists(String table)

Deprecated as a consequence of DropTableStep being deprecated.
The DROP TEMPORARY TABLE IF EXISTS statement.
public @NotNull DropTableStep
dropTemporaryTableIfExists(Name table)

Deprecated as a consequence of DropTableStep being deprecated.
The DROP TEMPORARY TABLE IF EXISTS statement.
public @NotNull DropTableStep
dropTemporaryTableIfExists(Table<?> table)

Deprecated as a consequence of DropTableStep being deprecated.
The DROP TEMPORARY TABLE IF EXISTS statement.
public @NotNull DropTypeStep
dropType(String type)

Deprecated as a consequence of DropTypeStep being deprecated.
Create a new DSL DROP TYPE statement.
public @NotNull DropTypeStep
dropType(Name type)

Deprecated as a consequence of DropTypeStep being deprecated.
Create a new DSL DROP TYPE statement.
public @NotNull DropTypeStep
dropType(String... type)

Deprecated as a consequence of DropTypeStep being deprecated.
Create a new DSL DROP TYPE statement.
public @NotNull DropTypeStep
dropType(Name... type)

Deprecated as a consequence of DropTypeStep being deprecated.
Create a new DSL DROP TYPE statement.
public @NotNull DropTypeStep
dropType(Collection<?> type)

Deprecated as a consequence of DropTypeStep being deprecated.
Create a new DSL DROP TYPE statement.
public @NotNull DropTypeStep
dropTypeIfExists(String type)

Deprecated as a consequence of DropTypeStep being deprecated.
Create a new DSL DROP TYPE statement.
public @NotNull DropTypeStep
dropTypeIfExists(Name type)

Deprecated as a consequence of DropTypeStep being deprecated.
Create a new DSL DROP TYPE statement.
public @NotNull DropTypeStep
dropTypeIfExists(String... type)

Deprecated as a consequence of DropTypeStep being deprecated.
Create a new DSL DROP TYPE statement.
public @NotNull DropTypeStep
dropTypeIfExists(Name... type)

Deprecated as a consequence of DropTypeStep being deprecated.
Create a new DSL DROP TYPE statement.
public @NotNull DropTypeStep
dropTypeIfExists(Collection<?> type)

Deprecated as a consequence of DropTypeStep being deprecated.
Create a new DSL DROP TYPE statement.
public @NotNull DropViewFinalStep
dropView(String view)

Deprecated as a consequence of DropViewFinalStep being deprecated.
The DROP VIEW statement.
public @NotNull DropViewFinalStep
dropView(Name view)

Deprecated as a consequence of DropViewFinalStep being deprecated.
The DROP VIEW statement.
public @NotNull DropViewFinalStep
dropView(Table<?> view)

Deprecated as a consequence of DropViewFinalStep being deprecated.
The DROP VIEW statement.
public @NotNull DropViewFinalStep
dropViewIfExists(String view)

Deprecated as a consequence of DropViewFinalStep being deprecated.
The DROP VIEW IF EXISTS statement.
public @NotNull DropViewFinalStep
dropViewIfExists(Name view)

Deprecated as a consequence of DropViewFinalStep being deprecated.
The DROP VIEW IF EXISTS statement.
public @NotNull DropViewFinalStep
dropViewIfExists(Table<?> view)

Deprecated as a consequence of DropViewFinalStep being deprecated.
The DROP VIEW IF EXISTS statement.
public int

Returns:

The results from the executed query
execute
(SQL
The SQL
sql
)

Execute a query holding plain SQL.

public int

Returns:

The results from the executed query
execute
(String
The SQL
sql
)

Execute a query holding plain SQL.

public int

Returns:

The results from the executed query
execute
(String
The SQL
sql
,
Object...
The bindings
bindings
)

Execute a new query holding plain SQL.

public int

Returns:

The results from the executed query
execute
(String
The SQL clause, containing {numbered placeholders} where query parts can be injected
sql
,
QueryPart...
The QueryPart objects that are rendered at the {numbered placeholder} locations
parts
)

Execute a new query holding plain SQL.

public int

Returns:

The number of affected rows
execute
(Query
The query to execute
query
)

Execute a Query in the context of this DSLContext.

public int

Returns:

The number of deleted records
executeDelete
(UpdatableRecord<?> record)

Delete a record from a table.

public int

Returns:

The number of deleted records
executeDelete
(TableRecord<?> record, Condition condition)

Deprecated as a consequence of Condition being deprecated.
Delete a record from a table.
public int

Returns:

The number of inserted records
executeInsert
(TableRecord<?> record)

Insert one record.

public int

Returns:

The number of updated records
executeUpdate
(UpdatableRecord<?> record)

Update a table.

public int

Returns:

The number of updated records
executeUpdate
(TableRecord<?> record, Condition condition)

Deprecated as a consequence of Condition being deprecated.
Update a table.
public @NotNull Explain
explain(Query query)

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

public @NotNull List<Object>
extractBindValues(QueryPart part)

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

public @Nullable Param<?>
extractParam(QueryPart part, String name)

Deprecated as a consequence of Param being deprecated.
Get a named parameter from a QueryPart, provided its name.
public @NotNull Map<String, Param<?>>
extractParams(QueryPart part)

Get a Map of named parameters.

public @NotNull Result<Record>

Returns:

The results from the executed query. This will never be null.
fetch
(SQL
The SQL
sql
)

Execute a new query holding plain SQL.

public @NotNull Result<Record>

Returns:

The results from the executed query. This will never be null.
fetch
(String
The SQL
sql
)

Execute a new query holding plain SQL.

public @NotNull Result<Record>

Returns:

The results from the executed query. This will never be null.
fetch
(String
The SQL
sql
,
Object...
The bindings
bindings
)

Execute a new query holding plain SQL.

public @NotNull Result<Record>

Returns:

The results from the executed query. This will never be null.
fetch
(String
The SQL clause, containing {numbered placeholders} where query parts can be injected
sql
,
QueryPart...
The QueryPart objects that are rendered at the {numbered placeholder} locations
parts
)

Execute a new query holding plain SQL.

public @NotNull Result<Record>

Returns:

The resulting jOOQ Result. This will never be null.
fetch
(ResultSet
The JDBC ResultSet to fetch data from
rs
)

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

public @NotNull Result<Record>

Returns:

The resulting jOOQ Result. This will never be null.
fetch
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Field<?>...
The fields to use in the desired output
fields
)

Deprecated as a consequence of Field being deprecated.
Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.
public @NotNull Result<Record>

Returns:

The resulting jOOQ Result. This will never be null.
fetch
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
DataType<?>...
The data types to use in the desired output
types
)

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

public @NotNull Result<Record>

Returns:

The resulting jOOQ Result. This will never be null.
fetch
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Class<?>...
The data types to use in the desired output
types
)

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

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

Returns:

The result. This will never be null.
fetch
(ResultQuery<R>
The query to execute
query
)

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

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

Returns:

The results from the executed query. This will never be null.
fetch
(Table<R> table)

Execute and return all records for

SELECT table.col1, table.col2 FROM table
public <R extends Record> @NotNull Result<R>

Returns:

The results from the executed query. This will never be null.
fetch
(Table<R> table, Condition condition)

Deprecated as a consequence of Condition being deprecated.
Execute and return all records for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> @NotNull Result<R>

Returns:

The results from the executed query. This will never be null.
fetch
(Table<R> table, Condition... conditions)

Deprecated as a consequence of Condition being deprecated.
Execute and return all records for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> @NotNull Result<R>

Returns:

The results from the executed query. This will never be null.
fetch
(Table<R> table, Collection<? extends Condition> conditions)

Execute and return all records for

SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> R

Returns:

The record or null if no record was returned
fetchAny
(Table<R> table)

Execute and return zero or one record for

SELECT table.col1, table.col2 FROM table LIMIT 1
public <R extends Record> R

Returns:

The record or null if no record was returned
fetchAny
(Table<R> table, Condition condition)

Deprecated as a consequence of Condition being deprecated.
Execute and return zero or one record for
SELECT table.col1, table.col2 FROM table WHERE condition LIMIT 1
public <R extends Record> R

Returns:

The record or null if no record was returned
fetchAny
(Table<R> table, Condition... conditions)

Deprecated as a consequence of Condition being deprecated.
Execute and return zero or on e record for
SELECT table.col1, table.col2 FROM table WHERE condition LIMIT 1
public <R extends Record> R

Returns:

The record or null if no record was returned
fetchAny
(Table<R> table, Collection<? extends Condition> conditions)

Execute and return zero or one record for

SELECT table.col1, table.col2 FROM table WHERE condition LIMIT 1
public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(SQL
The SQL
sql
)

Fetch results in a new CompletionStage.

public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(String
The SQL
sql
)

Fetch results in a new CompletionStage.

public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(String
The SQL
sql
,
Object...
The bindings
bindings
)

Fetch results in a new CompletionStage.

public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(String
The SQL clause, containing {numbered placeholders} where query parts can be injected
sql
,
QueryPart...
The QueryPart objects that are rendered at the {numbered placeholder} locations
parts
)

Fetch results in a new CompletionStage.

public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Executor executor, SQL
The SQL
sql
)

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

public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Executor executor, String
The SQL
sql
)

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

public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Executor executor, String
The SQL
sql
,
Object...
The bindings
bindings
)

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

public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Executor executor, String
The SQL clause, containing {numbered placeholders} where query parts can be injected
sql
,
QueryPart...
The QueryPart objects that are rendered at the {numbered placeholder} locations
parts
)

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

public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(ResultSet
The JDBC ResultSet to fetch data from
rs
)

Fetch results in a new CompletionStage.

public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Field<?>...
The fields to use in the desired output
fields
)

Deprecated as a consequence of Field being deprecated.
Fetch results in a new CompletionStage.
public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
DataType<?>...
The data types to use in the desired output
types
)

Fetch results in a new CompletionStage.

public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Class<?>...
The data types to use in the desired output
types
)

Fetch results in a new CompletionStage.

public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Executor executor, ResultSet
The JDBC ResultSet to fetch data from
rs
)

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

public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Executor executor, ResultSet
The JDBC ResultSet to fetch data from
rs
,
Field<?>...
The fields to use in the desired output
fields
)

Deprecated as a consequence of Field being deprecated.
Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.
public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Executor executor, ResultSet
The JDBC ResultSet to fetch data from
rs
,
DataType<?>...
The data types to use in the desired output
types
)

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

public @NotNull CompletionStage<Result<Record>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Executor executor, ResultSet
The JDBC ResultSet to fetch data from
rs
,
Class<?>...
The data types to use in the desired output
types
)

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

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

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(ResultQuery<R>
The query to execute
query
)

Fetch results in a new CompletionStage.

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

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Executor executor, ResultQuery<R>
The query to execute
query
)

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

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

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Table<R> table)

Execute and return all records asynchronously for

SELECT table.col1, table.col2 FROM table
public <R extends Record> @NotNull CompletionStage<Result<R>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Table<R> table, Condition condition)

Deprecated as a consequence of Condition being deprecated.
Execute and return all records asynchronously for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> @NotNull CompletionStage<Result<R>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Table<R> table, Condition... condition)

Deprecated as a consequence of Condition being deprecated.
Execute and return all records asynchronously for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> @NotNull CompletionStage<Result<R>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Table<R> table, Collection<? extends Condition> condition)

Execute and return all records asynchronously for

SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> @NotNull CompletionStage<Result<R>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Executor executor, Table<R> table)

Execute and return all records asynchronously for

SELECT table.col1, table.col2 FROM table
public <R extends Record> @NotNull CompletionStage<Result<R>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Executor executor, Table<R> table, Condition condition)

Deprecated as a consequence of Condition being deprecated.
Execute and return all records asynchronously for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> @NotNull CompletionStage<Result<R>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Executor executor, Table<R> table, Condition... conditions)

Deprecated as a consequence of Condition being deprecated.
Execute and return all records asynchronously for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> @NotNull CompletionStage<Result<R>>

Returns:

The completion stage. The completed result will never be null.
fetchAsync
(Executor executor, Table<R> table, Collection<? extends Condition> conditions)

Execute and return all records asynchronously for

SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends TableRecord<R>> @NotNull Result<R>

Returns:

The resulting records matching the example record.
fetchByExample
(R
The example record
example
)

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

public int

Returns:

The COUNT(*) result
fetchCount
(Select<?>
The wrapped query
query
)

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

public int

Returns:

The number of records in the table
fetchCount
(Table<?>
The table whose records to count
table
)

Count the number of records in a table.

public int

Returns:

The number of records in the table that satisfy a condition
fetchCount
(Table<?>
The table whose records to count
table
,
Condition
The condition to apply
condition
)

Deprecated as a consequence of Condition being deprecated.
Count the number of records in a table that satisfy a condition.
public int

Returns:

The number of records in the table that satisfy a condition
fetchCount
(Table<?>
The table whose records to count
table
,
Condition...
The conditions to apply
conditions
)

Deprecated as a consequence of Condition being deprecated.
Count the number of records in a table that satisfy a condition.
public int

Returns:

The number of records in the table that satisfy a condition
fetchCount
(Table<?>
The table whose records to count
table
,
Collection<? extends Condition>
The conditions to apply
conditions
)

Count the number of records in a table that satisfy a condition.

public boolean

Returns:

The EXISTS(…) result
fetchExists
(Select<?>
The wrapped query
query
)

Check if a Select would return any records, if it were executed.

public boolean

Returns:

Whether the table contains any records
fetchExists
(Table<?>
The table whose records to count
table
)

Check if a table has any records.

public boolean

Returns:

Whether the table contains any records that satisfy a condition
fetchExists
(Table<?>
The table whose records to count
table
,
Condition condition)

Deprecated as a consequence of Condition being deprecated.
Check if a table has any records that satisfy a condition.
public boolean

Returns:

Whether the table contains any records that satisfy a condition
fetchExists
(Table<?>
The table whose records to count
table
,
Condition... conditions)

Deprecated as a consequence of Condition being deprecated.
Check if a table has any records that satisfy a condition.
public boolean

Returns:

Whether the table contains any records that satisfy a condition
fetchExists
(Table<?>
The table whose records to count
table
,
Collection<? extends Condition> conditions)

Check if a table has any records that satisfy a condition.

public @NotNull Result<Record>

Returns:

The transformed result. This will never be null.
fetchFromCSV
(String
The CSV string
string
)

Fetch all data from a CSV string.

public @NotNull Result<Record>

Returns:

The transformed result. This will never be null.
fetchFromCSV
(String
The CSV string
string
,
char
The delimiter to expect between records
delimiter
)

Fetch all data from a CSV string.

public @NotNull Result<Record>

Returns:

The transformed result. This will never be null.
fetchFromCSV
(String
The CSV string
string
,
boolean
Whether to parse the first line as a CSV header line
header
)

Fetch all data from a CSV string.

public @NotNull Result<Record>

Returns:

The transformed result. This will never be null.
fetchFromCSV
(String
The CSV string
string
,
boolean
Whether to parse the first line as a CSV header line
header
,
char
The delimiter to expect between records
delimiter
)

Fetch all data from a CSV string.

public @NotNull Result<Record>

Returns:

The transformed result. This will never be null.
fetchFromHTML
(String
The HTML-formatted string.
string
)

Convert an HTML table into a jOOQ Result.

public @NotNull Result<Record>

Returns:

The transformed result. This will never be null.
fetchFromJSON
(String
The JSON string
string
)

Fetch all data from a JSON string.

public @NotNull Result<Record>

Returns:

The transformed result. This will never be null.
fetchFromStringData
(String[]...
The data to be transformed into a Result
data
)

Fetch all data from a list of strings.

public @NotNull Result<Record>

Returns:

The transformed result. This will never be null.
fetchFromStringData
(List<String[]>
The data to be transformed into a Result
data
)

Fetch all data from a list of strings.

public @NotNull Result<Record>

Returns:

The transformed result. This will never be null.
fetchFromStringData
(List<String[]>
The data to be transformed into a Result
data
,
boolean
Whether to interpret the first line as a set of column names.
header
)

Fetch all data from a list of strings.

public @NotNull Result<Record>

Returns:

The transformed result. This will never be null.
fetchFromTXT
(String
The formatted string
string
)

Fetch all data from a formatted string.

public @NotNull Result<Record>

Returns:

The transformed result. This will never be null.
fetchFromTXT
(String
The formatted string
string
,
String
The string literal to be used as null value.
nullLiteral
)

Fetch all data from a formatted string.

public @NotNull Result<Record>

Returns:

The transformed result. This will never be null.
fetchFromXML
(String
The XML string
string
)

Fetch all data from an XML string.

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

Returns:

A Map containing grouped results. This will never be null.
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.

public @NotNull Cursor<Record>

Returns:

The cursor. This will never be null.
fetchLazy
(SQL
The SQL
sql
)

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

public @NotNull Cursor<Record>

Returns:

The cursor. This will never be null.
fetchLazy
(String
The SQL
sql
)

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

public @NotNull Cursor<Record>

Returns:

The cursor. This will never be null.
fetchLazy
(String
The SQL
sql
,
Object...
The bindings
bindings
)

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

public @NotNull Cursor<Record>

Returns:

The cursor. This will never be null.
fetchLazy
(String
The SQL clause, containing {numbered placeholders} where query parts can be injected
sql
,
QueryPart...
The QueryPart objects that are rendered at the {numbered placeholder} locations
parts
)

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

public @NotNull Cursor<Record>

Returns:

The cursor. This will never be null.
fetchLazy
(ResultSet
The JDBC ResultSet to fetch data from
rs
)

Wrap a JDBC ResultSet into a jOOQ Cursor.

public @NotNull Cursor<Record>

Returns:

The cursor. This will never be null.
fetchLazy
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Field<?>...
The fields to use in the desired output
fields
)

Deprecated as a consequence of Field being deprecated.
Wrap a JDBC ResultSet into a jOOQ Cursor.
public @NotNull Cursor<Record>

Returns:

The cursor. This will never be null.
fetchLazy
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
DataType<?>...
The data types to use in the desired output
types
)

Wrap a JDBC ResultSet into a jOOQ Cursor.

public @NotNull Cursor<Record>

Returns:

The cursor. This will never be null.
fetchLazy
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Class<?>...
The data types to use in the desired output
types
)

Wrap a JDBC ResultSet into a jOOQ Cursor.

public <R extends Record> @NotNull Cursor<R>

Returns:

The cursor. This will never be null.
fetchLazy
(ResultQuery<R>
The query to execute
query
)

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

public <R extends Record> @NotNull Cursor<R>

Returns:

The cursor. This will never be null.
fetchLazy
(Table<R> table)

Execute and return all records lazily for

SELECT table.col1, table.col2 FROM table
public <R extends Record> @NotNull Cursor<R>

Returns:

The cursor. This will never be null.
fetchLazy
(Table<R> table, Condition condition)

Deprecated as a consequence of Condition being deprecated.
Execute and return all records lazily for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> @NotNull Cursor<R>

Returns:

The cursor. This will never be null.
fetchLazy
(Table<R> table, Condition... conditions)

Deprecated as a consequence of Condition being deprecated.
Execute and return all records lazily for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> @NotNull Cursor<R>

Returns:

The cursor. This will never be null.
fetchLazy
(Table<R> table, Collection<? extends Condition> conditions)

Execute and return all records lazily for

SELECT table.col1, table.col2 FROM table WHERE condition
public @NotNull Results

Returns:

The results. This will never be null.
fetchMany
(SQL
The SQL
sql
)

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

public @NotNull Results

Returns:

The results. This will never be null.
fetchMany
(String
The SQL
sql
)

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

public @NotNull Results

Returns:

The results. This will never be null.
fetchMany
(String
The SQL
sql
,
Object...
The bindings
bindings
)

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

public @NotNull Results

Returns:

The results. This will never be null.
fetchMany
(String
The SQL clause, containing {numbered placeholders} where query parts can be injected
sql
,
QueryPart...
The QueryPart objects that are rendered at the {numbered placeholder} locations
parts
)

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

public <R extends Record> @NotNull Results

Returns:

The results. This will never be null.
fetchMany
(ResultQuery<R>
The query to execute
query
)

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

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

Returns:

A Map containing grouped results. This will never be null.
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.

public @Nullable Record

Returns:

The record or null, if no record was found.
fetchOne
(SQL
The SQL
sql
)

Execute a new query holding plain SQL.

public @Nullable Record

Returns:

The record or null, if no record was found.
fetchOne
(String
The SQL
sql
)

Execute a new query holding plain SQL.

public @Nullable Record

Returns:

The record or null, if no record was found.
fetchOne
(String
The SQL
sql
,
Object...
The bindings
bindings
)

Execute a new query holding plain SQL.

public @Nullable Record

Returns:

The record or null, if no record was found.
fetchOne
(String
The SQL clause, containing {numbered placeholders} where query parts can be injected
sql
,
QueryPart...
The QueryPart objects that are rendered at the {numbered placeholder} locations
parts
)

Execute a new query holding plain SQL.

public @Nullable Record

Returns:

The record or null, if no record was found.
fetchOne
(ResultSet
The JDBC ResultSet to fetch data from
rs
)

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

public @Nullable Record

Returns:

The record or null, if no record was found.
fetchOne
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Field<?>...
The fields to use in the desired output
fields
)

Deprecated as a consequence of Field being deprecated.
Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
public @Nullable Record

Returns:

The record or null, if no record was found.
fetchOne
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
DataType<?>...
The data types to use in the desired output
types
)

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

public @Nullable Record

Returns:

The record. This is never null.
fetchOne
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Class<?>...
The data types to use in the desired output
types
)

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

public <R extends Record> R

Returns:

The record or null, if no record was found.
fetchOne
(ResultQuery<R>
The query to execute
query
)

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

public <R extends Record> R

Returns:

The record or null, if no record was found.
fetchOne
(Table<R> table)

Execute and return zero or one record for

SELECT table.col1, table.col2 FROM table
public <R extends Record> R

Returns:

The record or null, if no record was found.
fetchOne
(Table<R> table, Condition condition)

Deprecated as a consequence of Condition being deprecated.
Execute and return zero or one record for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> R

Returns:

The record or null, if no record was found.
fetchOne
(Table<R> table, Condition... conditions)

Deprecated as a consequence of Condition being deprecated.
Execute and return zero or one record for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> R

Returns:

The record or null, if no record was found.
fetchOne
(Table<R> table, Collection<? extends Condition> conditions)

Execute and return zero or one record for

SELECT table.col1, table.col2 FROM table WHERE condition
public @NotNull Optional<Record>

Returns:

The results from the executed query
fetchOptional
(SQL
The SQL
sql
)

Execute a new query holding plain SQL.

public @NotNull Optional<Record>

Returns:

The results from the executed query
fetchOptional
(String
The SQL
sql
)

Execute a new query holding plain SQL.

public @NotNull Optional<Record>

Returns:

The results from the executed query
fetchOptional
(String
The SQL
sql
,
Object...
The bindings
bindings
)

Execute a new query holding plain SQL.

public @NotNull Optional<Record>

Returns:

The results from the executed query
fetchOptional
(String
The SQL clause, containing {numbered placeholders} where query parts can be injected
sql
,
QueryPart...
The QueryPart objects that are rendered at the {numbered placeholder} locations
parts
)

Execute a new query holding plain SQL.

public @NotNull Optional<Record>

Returns:

The resulting jOOQ record
fetchOptional
(ResultSet
The JDBC ResultSet to fetch data from
rs
)

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

public @NotNull Optional<Record>

Returns:

The resulting jOOQ record
fetchOptional
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Field<?>...
The fields to use in the desired output
fields
)

Deprecated as a consequence of Field being deprecated.
Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
public @NotNull Optional<Record>

Returns:

The resulting jOOQ record
fetchOptional
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
DataType<?>...
The data types to use in the desired output
types
)

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

public @NotNull Optional<Record>

Returns:

The resulting jOOQ record
fetchOptional
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Class<?>...
The data types to use in the desired output
types
)

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

public <R extends Record> @NotNull Optional<R>

Returns:

The record
fetchOptional
(ResultQuery<R>
The query to execute
query
)

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

public <R extends Record> @NotNull Optional<R>

Returns:

The record
fetchOptional
(Table<R> table)

Execute and return zero or one record for

SELECT table.col1, table.col2 FROM table
public <R extends Record> @NotNull Optional<R>

Returns:

The record
fetchOptional
(Table<R> table, Condition condition)

Deprecated as a consequence of Condition being deprecated.
Execute and return zero or one record for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> @NotNull Optional<R>

Returns:

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

Deprecated as a consequence of Condition being deprecated.
Execute and return zero or one record for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> @NotNull Optional<R>

Returns:

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

Execute and return zero or one record for

SELECT table.col1, table.col2 FROM table WHERE condition
public @NotNull Optional<?>

Returns:

The result value from the executed query
fetchOptionalValue
(SQL
The SQL
sql
)

Execute a new query holding plain SQL.

public @NotNull Optional<?>

Returns:

The result value from the executed query
fetchOptionalValue
(String
The SQL
sql
)

Execute a new query holding plain SQL.

public @NotNull Optional<?>

Returns:

The results from the executed query
fetchOptionalValue
(String
The SQL
sql
,
Object...
The bindings
bindings
)

Execute a new query holding plain SQL.

public @NotNull Optional<?>

Returns:

The results from the executed query
fetchOptionalValue
(String
The SQL clause, containing {numbered placeholders} where query parts can be injected
sql
,
QueryPart...
The QueryPart objects that are rendered at the {numbered placeholder} locations
parts
)

Execute a new query holding plain SQL.

public @NotNull Optional<?>

Returns:

The resulting value
fetchOptionalValue
(ResultSet
The JDBC ResultSet to fetch data from
rs
)

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

public <T> @NotNull Optional<T>

Returns:

The resulting value
fetchOptionalValue
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Field<T>
The field to use in the desired output
field
)

Deprecated as a consequence of Field being deprecated.
Fetch a record from a JDBC ResultSet and return the only contained value.
public <T> @NotNull Optional<T>

Returns:

The resulting value
fetchOptionalValue
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
DataType<T>
The data type to use in the desired output
type
)

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

public <T> @NotNull Optional<T>

Returns:

The resulting value
fetchOptionalValue
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Class<T>
The data types to use in the desired output
type
)

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

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

Returns:

The value.
fetchOptionalValue
(ResultQuery<R>
The query to execute
query
)

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

public <T> @NotNull Optional<T>

Returns:

The value.
fetchOptionalValue
(TableField<?, T>
The field for which to fetch a single value.
field
)

Deprecated as a consequence of TableField being deprecated.
Execute a ResultQuery in the context of this DSLContext and return a single value.
public <T> @NotNull Optional<T>

Returns:

The value.
fetchOptionalValue
(TableField<?, T>
The field for which to fetch a single value.
field
,
Condition
The condition for which to fetch a single value.
condition
)

Deprecated as a consequence of TableField and Condition being deprecated.
Execute a ResultQuery in the context of this DSLContext and return a single value.
public @NotNull Record

Returns:

The record. This is never null.
fetchSingle
(SQL
The SQL
sql
)

Execute a new query holding plain SQL.

public @NotNull Record

Returns:

The record. This is never null.
fetchSingle
(String
The SQL
sql
)

Execute a new query holding plain SQL.

public @NotNull Record

Returns:

The record. This is never null.
fetchSingle
(String
The SQL
sql
,
Object...
The bindings
bindings
)

Execute a new query holding plain SQL.

public @NotNull Record

Returns:

The record. This is never null.
fetchSingle
(String
The SQL clause, containing {numbered placeholders} where query parts can be injected
sql
,
QueryPart...
The QueryPart objects that are rendered at the {numbered placeholder} locations
parts
)

Execute a new query holding plain SQL.

public @NotNull Record

Returns:

The record or null, if no record was found.
fetchSingle
(ResultSet
The JDBC ResultSet to fetch data from
rs
)

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

public @NotNull Record

Returns:

The record. This is never null.
fetchSingle
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Field<?>...
The fields to use in the desired output
fields
)

Deprecated as a consequence of Field being deprecated.
Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
public @NotNull Record

Returns:

The record. This is never null.
fetchSingle
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
DataType<?>...
The data types to use in the desired output
types
)

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

public @NotNull Record

Returns:

The record. This is never null.
fetchSingle
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Class<?>...
The data types to use in the desired output
types
)

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

public <R extends Record> R

Returns:

The record. This is never null.
fetchSingle
(ResultQuery<R>
The query to execute
query
)

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

public <R extends Record> R

Returns:

The record. This is never null.
fetchSingle
(Table<R> table)

Execute and return exactly one record for

SELECT table.col1, table.col2 FROM table
public <R extends Record> R

Returns:

The record. This is never null.
fetchSingle
(Table<R> table, Condition condition)

Deprecated as a consequence of Condition being deprecated.
Execute and return exactly one record for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> R

Returns:

The record. This is never null.
fetchSingle
(Table<R> table, Condition... conditions)

Deprecated as a consequence of Condition being deprecated.
Execute and return exactly one record for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> R

Returns:

The record. This is never null.
fetchSingle
(Table<R> table, Collection<? extends Condition> conditions)

Execute and return exactly one record for

SELECT table.col1, table.col2 FROM table WHERE condition
public @NotNull Record

Returns:

The record. This is never null.
fetchSingle
(SelectField<?>... fields)

Execute and return exactly one record for

SELECT F1, F2, …, FN
public @NotNull Record

Returns:

The record. This is never null.
fetchSingle
(Collection<? extends SelectField<?>> fields)

Execute and return exactly one record for

SELECT F1, F2, …, FN
public <T1> @NotNull Record1<T1>

Returns:

The record. This is never null.
fetchSingle
(SelectField<T1> field1)

Execute and return exactly one record for

SELECT F1, F2, …, FN
public <T1, T2> @NotNull Record2<T1, T2>

Returns:

The record. This is never null.
fetchSingle
(SelectField<T1> field1, SelectField<T2> field2)

Execute and return exactly one record for

SELECT F1, F2, …, FN
public <T1, T2, T3> @NotNull Record3<T1, T2, T3>

Returns:

The record. This is never null.
fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)

Execute and return exactly one record for

SELECT F1, F2, …, FN
public <T1, T2, T3, T4> @NotNull Record4<T1, T2, T3, T4>

Returns:

The record. This is never null.
fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)

Execute and return exactly one record for

SELECT F1, F2, …, FN
public <T1, T2, T3, T4, T5> @NotNull Record5<T1, T2, T3, T4, T5>

Returns:

The record. This is never null.
fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)

Execute and return exactly one record for

SELECT F1, F2, …, FN
public <T1, T2, T3, T4, T5, T6> @NotNull Record6<T1, T2, T3, T4, T5, T6>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <T1, T2, T3, T4, T5, T6, T7> @NotNull Record7<T1, T2, T3, T4, T5, T6, T7>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <T1, T2, T3, T4, T5, T6, T7, T8> @NotNull Record8<T1, T2, T3, T4, T5, T6, T7, T8>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <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>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <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>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <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>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <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>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <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>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <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>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <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>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <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>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <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>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <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>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <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>

Returns:

The record. This is never null.
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

SELECT F1, F2, …, FN
public <R extends Record> R

Returns:

The record. This is never null.
fetchSingle
(Table<R> table, Condition c1, Condition c2)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
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)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
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)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
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)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
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)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
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)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
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)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
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)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
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)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
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)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
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)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
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)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public <R extends Record> R

Returns:

The record. This is never null.
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)

Deprecated as a consequence of Condition being deprecated.
Disambiguation overload of fetchSingle(Table, Condition...).
public @NotNull Stream<Record>

Returns:

The results from the executed query. This is never null, even if the database returns no ResultSet
fetchStream
(SQL
The SQL
sql
)

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

public @NotNull Stream<Record>

Returns:

The results from the executed query. This is never null, even if the database returns no ResultSet
fetchStream
(String
The SQL
sql
)

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

public @NotNull Stream<Record>

Returns:

The results from the executed query. This is never null, even if the database returns no ResultSet
fetchStream
(String
The SQL
sql
,
Object...
The bindings
bindings
)

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

public @NotNull Stream<Record>

Returns:

The results from the executed query. This is never null, even if the database returns no ResultSet
fetchStream
(String
The SQL clause, containing {numbered placeholders} where query parts can be injected
sql
,
QueryPart...
The QueryPart objects that are rendered at the {numbered placeholder} locations
parts
)

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

public @NotNull Stream<Record>

Returns:

The resulting stream
fetchStream
(ResultSet
The JDBC ResultSet to fetch data from
rs
)

Wrap a JDBC ResultSet into a jOOQ Stream.

public @NotNull Stream<Record>

Returns:

The resulting stream
fetchStream
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Field<?>...
The fields to use in the desired output
fields
)

Deprecated as a consequence of Field being deprecated.
Wrap a JDBC ResultSet into a jOOQ Stream.
public @NotNull Stream<Record>

Returns:

The resulting stream
fetchStream
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
DataType<?>...
The data types to use in the desired output
types
)

Wrap a JDBC ResultSet into a jOOQ Stream.

public @NotNull Stream<Record>

Returns:

The resulting stream
fetchStream
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Class<?>...
The data types to use in the desired output
types
)

Wrap a JDBC ResultSet into a jOOQ Stream.

public <R extends Record> @NotNull Stream<R>

Returns:

The stream
fetchStream
(ResultQuery<R>
The query to execute
query
)

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

public <R extends Record> @NotNull Stream<R>
fetchStream(Table<R> table)

Execute and return all records lazily for

SELECT table.col1, table.col2 FROM table
public <R extends Record> @NotNull Stream<R>
fetchStream(Table<R> table, Condition condition)

Deprecated as a consequence of Condition being deprecated.
Execute and return all records lazily for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> @NotNull Stream<R>
fetchStream(Table<R> table, Condition... conditions)

Deprecated as a consequence of Condition being deprecated.
Execute and return all records lazily for
SELECT table.col1, table.col2 FROM table WHERE condition
public <R extends Record> @NotNull Stream<R>
fetchStream(Table<R> table, Collection<? extends Condition> conditions)

Execute and return all records lazily for

SELECT table.col1, table.col2 FROM table WHERE condition
public @Nullable Object

Returns:

The value or null, if no record was found.
fetchValue
(SQL
The SQL
sql
)

Execute a new query holding plain SQL.

public @Nullable Object

Returns:

The value or null, if no record was found.
fetchValue
(String
The SQL
sql
)

Execute a new query holding plain SQL.

public @Nullable Object

Returns:

The value or null, if no record was found.
fetchValue
(String
The SQL
sql
,
Object...
The bindings
bindings
)

Execute a new query holding plain SQL.

public @Nullable Object

Returns:

The value or null, if no record was found.
fetchValue
(String
The SQL clause, containing {numbered placeholders} where query parts can be injected
sql
,
QueryPart...
The QueryPart objects that are rendered at the {numbered placeholder} locations
parts
)

Execute a new query holding plain SQL.

public @Nullable Object

Returns:

The value or null, if no record was found.
fetchValue
(ResultSet
The JDBC ResultSet to fetch data from
rs
)

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

public <T> T

Returns:

The value or null, if no record was found.
fetchValue
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Field<T>
The field to use in the desired output
field
)

Deprecated as a consequence of Field being deprecated.
Fetch a record from a JDBC ResultSet and return the only contained value.
public <T> T

Returns:

The value or null, if no record was found.
fetchValue
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
DataType<T>
The data type to use in the desired output
type
)

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

public <T> T

Returns:

The value or null, if no record was found.
fetchValue
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Class<T>
The data types to use in the desired output
type
)

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

public <T> T

Returns:

The value or null, if no record was found.
fetchValue
(Table<? extends Record1<T>>
The table from which to fetch a value
table
)

Fetch a single value from a single column table.

public <T, R extends Record1<T>> T

Returns:

The value or null, if no record was found.
fetchValue
(ResultQuery<R>
The query to execute
query
)

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

public <T> T

Returns:

The value or null, if no record was found.
fetchValue
(TableField<?, T>
The field for which to fetch a single value.
field
)

Deprecated as a consequence of TableField being deprecated.
Execute a ResultQuery in the context of this DSLContext and return a single value.
public <T> T

Returns:

The value or null, if no record was found.
fetchValue
(TableField<?, T>
The field for which to fetch a single value.
field
,
Condition
The condition for which to fetch a single value.
condition
)

Deprecated as a consequence of TableField and Condition being deprecated.
Execute a ResultQuery in the context of this DSLContext and return a single value.
public <T> T

Returns:

The value or null, if no record was found.
fetchValue
(SelectField<T>
The field for which to fetch a single value.
field
)

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

public @NotNull List<?>

Returns:

The values. This will never be null.
fetchValues
(SQL
The SQL
sql
)

Execute a new query holding plain SQL.

public @NotNull List<?>

Returns:

The values. This will never be null.
fetchValues
(String
The SQL
sql
)

Execute a new query holding plain SQL.

public @NotNull List<?>

Returns:

The values. This will never be null.
fetchValues
(String
The SQL
sql
,
Object...
The bindings
bindings
)

Execute a new query holding plain SQL.

public @NotNull List<?>

Returns:

The values. This will never be null.
fetchValues
(String
The SQL clause, containing {numbered placeholders} where query parts can be injected
sql
,
QueryPart...
The QueryPart objects that are rendered at the {numbered placeholder} locations
parts
)

Execute a new query holding plain SQL.

public @NotNull List<?>

Returns:

The values. This will never be null.
fetchValues
(ResultSet
The JDBC ResultSet to fetch data from
rs
)

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

public <T> @NotNull List<T>

Returns:

The values. This will never be null.
fetchValues
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Field<T>
The field to use in the desired output
field
)

Deprecated as a consequence of Field being deprecated.
Fetch a result from a JDBC ResultSet and return the only contained column's values.
public <T> @NotNull List<T>

Returns:

The values. This will never be null.
fetchValues
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
DataType<T>
The data type to use in the desired output
type
)

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

public <T> @NotNull List<T>

Returns:

The values. This will never be null.
fetchValues
(ResultSet
The JDBC ResultSet to fetch data from
rs
,
Class<T>
The data types to use in the desired output
type
)

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

public <T> @NotNull List<T>

Returns:

The values. This will never be null.
fetchValues
(Table<? extends Record1<T>>
The table from which to fetch values
table
)

Fetch all values from a single column table.

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

Returns:

The values. This will never be null.
fetchValues
(ResultQuery<R>
The query to execute
query
)

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

public <T> @NotNull List<T>

Returns:

The values. This will never be null.
fetchValues
(TableField<?, T>
The field for which to fetch all values.
field
)

Deprecated as a consequence of TableField being deprecated.
Fetch all values in a given Table's TableField.
public <T> @NotNull List<T>

Returns:

The values. This will never be null.
fetchValues
(TableField<?, T>
The field for which to fetch values.
field
,
Condition
The condition for which to fetch values.
condition
)

Deprecated as a consequence of TableField and Condition being deprecated.
Fetch all values in a given Table's TableField.
public @NotNull GrantOnStep
grant(Privilege privileges)

The GRANT statement.

public @NotNull GrantOnStep
grant(Privilege... privileges)

The GRANT statement.

public @NotNull GrantOnStep
grant(Collection<? extends Privilege> privileges)

The GRANT statement.

public @NotNull InformationSchema
informationSchema(Catalog catalog)

Convenience method for Meta#informationSchema().

public @NotNull InformationSchema
informationSchema(Catalog... catalogs)

Convenience method for Meta#informationSchema().

public @NotNull InformationSchema
informationSchema(Schema schema)

Convenience method for Meta#informationSchema().

public @NotNull InformationSchema
informationSchema(Schema... schemas)

Convenience method for Meta#informationSchema().

public @NotNull InformationSchema
informationSchema(Table<?> table)

Convenience method for Meta#informationSchema().

public @NotNull InformationSchema
informationSchema(Table<?>... table)

Convenience method for Meta#informationSchema().

public <R extends Record> @NotNull InsertSetStep<R>
insertInto(Table<R> into)

Create a new DSL insert statement.

public <R extends Record, T1> @NotNull InsertValuesStep1<R, T1>
insertInto(Table<R> into, Field<T1> field1)

Deprecated as a consequence of Field and InsertValuesStep1 being deprecated.
Create a new DSL insert statement.
public <R extends Record, T1, T2> @NotNull InsertValuesStep2<R, T1, T2>
insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)

Deprecated as a consequence of Field and InsertValuesStep2 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep3 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep4 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep5 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep6 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep7 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep8 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep9 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep10 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep11 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep12 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep13 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep14 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep15 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep16 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep17 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep18 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep19 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep20 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep21 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep22 being deprecated.
Create a new DSL insert statement.
public <R extends Record> @NotNull InsertValuesStepN<R>
insertInto(Table<R> into, Field<?>... fields)

Deprecated as a consequence of Field and InsertValuesStepN being deprecated.
Create a new DSL insert statement.
public <R extends Record> @NotNull InsertValuesStepN<R>
insertInto(Table<R> into, Collection<? extends Field<?>> fields)

Deprecated as a consequence of InsertValuesStepN being deprecated.
Create a new DSL insert statement.
public <R extends Record> @NotNull InsertQuery<R>

Returns:

The new InsertQuery
insertQuery
(Table<R>
The table to insert data into
into
)

Deprecated as a consequence of InsertQuery being deprecated.
Create a new InsertQuery
public @NotNull BigInteger

Returns:

The last inserted ID. This may be null in some dialects, if no such number is available.
lastID
()

Retrieve the last inserted ID.

This is implemented for the following dialects:

public <R extends Record> @NotNull LoaderOptionsStep<R>
loadInto(Table<R> table)

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

public @Nullable Schema

Returns:

The mapped schema
map
(Schema
A schema
schema
)

Map a schema to another one.

public <R extends Record> @Nullable Table<R>

Returns:

The mapped table
map
(Table<R>
A table
table
)

Map a table to another one.

public <R extends Record> @NotNull MergeUsingStep<R>
mergeInto(Table<R> table)

Create a new DSL SQL standard MERGE statement.

public <R extends Record, T1> @NotNull MergeKeyStep1<R, T1>
mergeInto(Table<R> table, Field<T1> field1)

Deprecated for removal since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <R extends Record, T1, T2> @NotNull MergeKeyStep2<R, T1, T2>
mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)

Deprecated for removal since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <R extends Record> @NotNull MergeKeyStepN<R>
mergeInto(Table<R> table, Field<?>... fields)

Deprecated for removal since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL UPSERT statement (SQLDialect#H2 MERGE) or SQLDialect#HANA UPSERT).
public <R extends Record> @NotNull MergeKeyStepN<R>
mergeInto(Table<R> table, Collection<? extends Field<?>> fields)

Deprecated for removal since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public @NotNull Meta
meta()

Access the database meta data.

public @NotNull Meta
meta(DatabaseMetaData meta)

Access the database meta data from an explicit JDBC DatabaseMetaData.

public @NotNull Meta
meta(Catalog... catalogs)

Access the database meta data from explicit catalog information.

public @NotNull Meta
meta(Schema... schemas)

Access the database meta data from explicit schema information.

public @NotNull Meta
meta(Table<?>... tables)

Access the database meta data from explicit table information.

public @NotNull Meta
meta(InformationSchema schema)

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

public @NotNull Meta
meta(String... sources)

Create meta data from a set of sources.

public @NotNull Meta
meta(Source... sources)

Create meta data from a set of sources.

public @NotNull Meta
meta(Query... queries)

Create meta data from a set of DDL queries.

public @NotNull Migrations
migrations()

The experimental migrations API.

public void
mock(MockDataProvider provider, MockRunnable mockable)

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

public <T> T
mockResult(MockDataProvider provider, MockCallable<T> mockable)

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

public <
The generic record type
R extends UDTRecord<R>
>
R

Returns:

The new record
newRecord
(UDT<R>
The UDT describing records of type <R>
type
)

Create a new UDTRecord.

public <
The generic record type
R extends Record
>
R

Returns:

The new record
newRecord
(Table<R>
The table holding records of type <R>
table
)

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

public <
The generic record type
R extends Record
>
R

Returns:

The new record
newRecord
(Table<R>
The table holding records of type <R>
table
,
Object
The source to be used to fill the new record
source
)

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

public @NotNull Record

Returns:

The new record
newRecord
(Field<?>...
The fields defining the Record type
fields
)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public @NotNull Record

Returns:

The new record
newRecord
(Collection<? extends Field<?>>
The fields defining the Record type
fields
)

Create a new empty Record.

public <T1> @NotNull Record1<T1>

Returns:

The new record
newRecord
(Field<T1> field1)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <T1, T2> @NotNull Record2<T1, T2>

Returns:

The new record
newRecord
(Field<T1> field1, Field<T2> field2)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <T1, T2, T3> @NotNull Record3<T1, T2, T3>

Returns:

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

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <T1, T2, T3, T4> @NotNull Record4<T1, T2, T3, T4>

Returns:

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

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <T1, T2, T3, T4, T5> @NotNull Record5<T1, T2, T3, T4, T5>

Returns:

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

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <T1, T2, T3, T4, T5, T6> @NotNull Record6<T1, T2, T3, T4, T5, T6>

Returns:

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

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <T1, T2, T3, T4, T5, T6, T7> @NotNull Record7<T1, T2, T3, T4, T5, T6, T7>

Returns:

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

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <T1, T2, T3, T4, T5, T6, T7, T8> @NotNull Record8<T1, T2, T3, T4, T5, T6, T7, T8>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <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>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <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>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <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>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <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>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <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>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <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>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <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>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <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>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <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>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <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>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <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>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public <
The generic record type
R extends Record
>
@NotNull Result<R>

Returns:

The new result
newResult
(Table<R>
The table holding records of type <R>
table
)

Create a new empty Result.

public @NotNull Result<Record>

Returns:

The new record
newResult
(Field<?>...
The fields defining the Record type
fields
)

Deprecated as a consequence of Field being deprecated.
Create a new empty Record.
public @NotNull Result<Record>

Returns:

The new record
newResult
(Collection<? extends Field<?>>
The fields defining the Record type
fields
)

Create a new empty Record.

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

Returns:

The new result
newResult
(Field<T1> field1)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <T1, T2> @NotNull Result<Record2<T1, T2>>

Returns:

The new result
newResult
(Field<T1> field1, Field<T2> field2)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <T1, T2, T3> @NotNull Result<Record3<T1, T2, T3>>

Returns:

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

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <T1, T2, T3, T4> @NotNull Result<Record4<T1, T2, T3, T4>>

Returns:

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

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <T1, T2, T3, T4, T5> @NotNull Result<Record5<T1, T2, T3, T4, T5>>

Returns:

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

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <T1, T2, T3, T4, T5, T6> @NotNull Result<Record6<T1, T2, T3, T4, T5, T6>>

Returns:

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

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <T1, T2, T3, T4, T5, T6, T7> @NotNull Result<Record7<T1, T2, T3, T4, T5, T6, T7>>

Returns:

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

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <T1, T2, T3, T4, T5, T6, T7, T8> @NotNull Result<Record8<T1, T2, T3, T4, T5, T6, T7, T8>>

Returns:

The new result
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull Result<Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>>

Returns:

The new result
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull Result<Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>>

Returns:

The new result
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <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>>

Returns:

The new result
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <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>>

Returns:

The new result
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <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>>

Returns:

The new result
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <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>>

Returns:

The new result
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <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>>

Returns:

The new result
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <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>>

Returns:

The new result
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <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>>

Returns:

The new result
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <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>>

Returns:

The new result
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <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>>

Returns:

The new result
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <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>>

Returns:

The new result
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <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>>

Returns:

The new result
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public <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>>

Returns:

The new result
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)

Deprecated as a consequence of Field being deprecated.
Create a new empty Result.
public @NotNull BigInteger
nextval(String sequence)

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

public @NotNull BigInteger
nextval(Name sequence)

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

public <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.

public <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.

public @NotNull Parser
parser()

Access the parser API.

public @NotNull Connection
parsingConnection()

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

public @NotNull ConnectionFactory
parsingConnectionFactory()

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

public @NotNull DataSource
parsingDataSource()

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

public @NotNull Queries
queries(Query... queries)

Wrap a collection of queries.

public @NotNull Queries
queries(Collection<? extends Query> queries)

Wrap a collection of queries.

public @NotNull RowCountQuery

Returns:

A query wrapping the plain SQL
query
(SQL
The SQL
sql
)

Create a new query holding plain SQL.

public @NotNull RowCountQuery

Returns:

A query wrapping the plain SQL
query
(String
The SQL
sql
)

Create a new query holding plain SQL.

public @NotNull RowCountQuery

Returns:

A query wrapping the plain SQL
query
(String
The SQL
sql
,
Object...
The bindings
bindings
)

Create a new query holding plain SQL.

public @NotNull RowCountQuery

Returns:

A query wrapping the plain SQL
query
(String
The SQL clause, containing {numbered placeholders} where query parts can be injected
sql
,
QueryPart...
The QueryPart objects that are rendered at the {numbered placeholder} locations
parts
)

Create a new query holding plain SQL.

public @NotNull Query
releaseSavepoint(String name)

The RELEASE SAVEPOINT statement.

public @NotNull Query
releaseSavepoint(Name name)

The RELEASE SAVEPOINT statement.

public @NotNull String

Returns:

The rendered SQL
render
(QueryPart
The QueryPart to be rendered
part
)

Render a QueryPart in the context of this DSLContext.

public @NotNull RenderContext
renderContext()

Deprecated for removal since 3.10. - [#6280] - 3.10 - Do not reuse this method. It will be completely internal with jOOQ 4.0
Get a new RenderContext for the context of this DSLContext.
public @NotNull String

Returns:

The rendered SQL
renderInlined
(QueryPart
The QueryPart to be rendered
part
)

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

public @NotNull String

Returns:

The rendered SQL
renderNamedOrInlinedParams
(QueryPart
The QueryPart to be rendered
part
)

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

public @NotNull String

Returns:

The rendered SQL
renderNamedParams
(QueryPart
The QueryPart to be rendered
part
)

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

public @NotNull ResultQuery<Record>

Returns:

An executable query
resultQuery
(SQL
The SQL
sql
)

Create a new query holding plain SQL.

public @NotNull ResultQuery<Record>

Returns:

An executable query
resultQuery
(String
The SQL
sql
)

Create a new query holding plain SQL.

public @NotNull ResultQuery<Record>

Returns:

A query wrapping the plain SQL
resultQuery
(String
The SQL
sql
,
Object...
The bindings
bindings
)

Create a new query holding plain SQL.

public @NotNull ResultQuery<Record>

Returns:

A query wrapping the plain SQL
resultQuery
(String
The SQL clause, containing {numbered placeholders} where query parts can be injected
sql
,
QueryPart...
The QueryPart objects that are rendered at the {numbered placeholder} locations
parts
)

Create a new query holding plain SQL.

public @NotNull RevokeOnStep
revoke(Privilege privileges)

The REVOKE statement.

public @NotNull RevokeOnStep
revoke(Privilege... privileges)

The REVOKE statement.

public @NotNull RevokeOnStep
revoke(Collection<? extends Privilege> privileges)

The REVOKE statement.

public @NotNull RevokeOnStep
revokeGrantOptionFor(Privilege privileges)

The REVOKE GRANT OPTION FOR statement.

public @NotNull RevokeOnStep
revokeGrantOptionFor(Privilege... privileges)

The REVOKE GRANT OPTION FOR statement.

public @NotNull RevokeOnStep
revokeGrantOptionFor(Collection<? extends Privilege> privileges)

The REVOKE GRANT OPTION FOR statement.

public @NotNull RollbackToSavepointStep
rollback()

The ROLLBACK statement.

public @NotNull Query
savepoint(String name)

The SAVEPOINT statement.

public @NotNull Query
savepoint(Name name)

The SAVEPOINT statement.

public @NotNull SelectSelectStep<Record>
select(Collection<? extends SelectFieldOrAsterisk> fields)

Create a new DSL select statement.

public @NotNull SelectSelectStep<Record>
select(SelectFieldOrAsterisk... fields)

Create a new DSL select statement.

public <T1> @NotNull SelectSelectStep<Record1<T1>>
select(SelectField<T1> field1)

Create a new DSL select statement.

public <T1, T2> @NotNull SelectSelectStep<Record2<T1, T2>>
select(SelectField<T1> field1, SelectField<T2> field2)

Create a new DSL select statement.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public @NotNull SelectSelectStep<Record1<Integer>>
selectCount()

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

public @NotNull SelectSelectStep<Record>
selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)

Create a new DSL select statement.

public @NotNull SelectSelectStep<Record>
selectDistinct(SelectFieldOrAsterisk... fields)

Create a new DSL select statement.

public <T1> @NotNull SelectSelectStep<Record1<T1>>
selectDistinct(SelectField<T1> field1)

Create a new DSL select statement.

public <T1, T2> @NotNull SelectSelectStep<Record2<T1, T2>>
selectDistinct(SelectField<T1> field1, SelectField<T2> field2)

Create a new DSL select statement.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <R extends Record> @NotNull SelectWhereStep<R>
selectFrom(TableLike<R> table)

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

public @NotNull SelectWhereStep<Record>
selectFrom(Name table)

Create a new DSL select statement, projecting *.

public @NotNull SelectWhereStep<Record>
selectFrom(SQL sql)

Create a new DSL select statement, projecting *.

public @NotNull SelectWhereStep<Record>
selectFrom(String sql)

Create a new DSL select statement, projecting *.

public @NotNull SelectWhereStep<Record>
selectFrom(String sql, Object... bindings)

Create a new DSL select statement, projecting *.

public @NotNull SelectWhereStep<Record>
selectFrom(String sql, QueryPart... parts)

Create a new DSL select statement, projecting *.

public @NotNull SelectSelectStep<Record1<Integer>>
selectOne()

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

public @NotNull SelectQuery<Record>
selectQuery()

Deprecated as a consequence of SelectQuery being deprecated.
Create a new SelectQuery
public <R extends Record> @NotNull SelectQuery<R>

Returns:

The new SelectQuery
selectQuery
(TableLike<R>
The table to select data from
table
)

Deprecated as a consequence of SelectQuery being deprecated.
Create a new SelectQuery
public @NotNull SelectSelectStep<Record1<Integer>>
selectZero()

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

public @NotNull RowCountQuery
set(String name, Param<?> value)

Deprecated as a consequence of Param being deprecated.
The SET statement.
public @NotNull RowCountQuery
set(Name name, Param<?> value)

Deprecated as a consequence of Param being deprecated.
The SET statement.
public @NotNull RowCountQuery
setCatalog(String catalog)

The SET CATALOG statement.

public @NotNull RowCountQuery
setCatalog(Name catalog)

The SET CATALOG statement.

public @NotNull RowCountQuery
setCatalog(Catalog catalog)

The SET CATALOG statement.

public @NotNull RowCountQuery
setLocal(String name, Param<?> value)

Deprecated as a consequence of Param being deprecated.
The SET LOCAL statement.
public @NotNull RowCountQuery
setLocal(Name name, Param<?> value)

Deprecated as a consequence of Param being deprecated.
The SET LOCAL statement.
public @NotNull RowCountQuery
setSchema(String schema)

The SET SCHEMA statement.

public @NotNull RowCountQuery
setSchema(Name schema)

The SET SCHEMA statement.

public @NotNull RowCountQuery
setSchema(Schema schema)

The SET SCHEMA statement.

public @NotNull Query
startTransaction()

The START TRANSACTION statement.

public void
transaction(TransactionalRunnable
The transactional code
transactional
)

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

public void
transaction(ContextTransactionalRunnable
The transactional code
transactional
)

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

public @NotNull CompletionStage<Void>
transactionAsync(TransactionalRunnable
The transactional code
transactional
)

Run a TransactionalRunnable asynchronously.

public @NotNull CompletionStage<Void>
transactionAsync(Executor executor, TransactionalRunnable
The transactional code
transactional
)

Run a TransactionalRunnable asynchronously.

public <T> @NotNull Publisher<T>

Returns:

The transactional outcome
transactionPublisher
(TransactionalPublishable<T>
The transactional code
transactional
)

Run a TransactionalPublishable reactively.

public <T> T

Returns:

The transactional outcome
transactionResult
(TransactionalCallable<T>
The transactional code
transactional
)

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

public <T> T

Returns:

The transactional outcome
transactionResult
(ContextTransactionalCallable<T>
The transactional code
transactional
)

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

public <T> @NotNull CompletionStage<T>

Returns:

The transactional outcome
transactionResultAsync
(TransactionalCallable<T>
The transactional code
transactional
)

Run a TransactionalCallable asynchronously.

public <T> @NotNull CompletionStage<T>

Returns:

The transactional outcome
transactionResultAsync
(Executor executor, TransactionalCallable<T>
The transactional code
transactional
)

Run a TransactionalCallable asynchronously.

public @NotNull TruncateIdentityStep<Record>
truncate(String table)

Deprecated as a consequence of TruncateIdentityStep being deprecated.
The TRUNCATE statement.
public @NotNull TruncateIdentityStep<Record>
truncate(Name table)

Deprecated as a consequence of TruncateIdentityStep being deprecated.
The TRUNCATE statement.
public <R extends Record> @NotNull TruncateIdentityStep<R>
truncate(Table<R> table)

Deprecated as a consequence of TruncateIdentityStep being deprecated.
The TRUNCATE statement.
public @NotNull TruncateIdentityStep<Record>
truncateTable(String table)

Deprecated as a consequence of TruncateIdentityStep being deprecated.
The TRUNCATE TABLE statement.
public @NotNull TruncateIdentityStep<Record>
truncateTable(Name table)

Deprecated as a consequence of TruncateIdentityStep being deprecated.
The TRUNCATE TABLE statement.
public <R extends Record> @NotNull TruncateIdentityStep<R>
truncateTable(Table<R> table)

Deprecated as a consequence of TruncateIdentityStep being deprecated.
The TRUNCATE TABLE statement.
public <R extends Record> @NotNull UpdateSetFirstStep<R>
update(Table<R> table)

Create a new DSL update statement.

public <R extends Record> @NotNull UpdateQuery<R>

Returns:

The new UpdateQuery
updateQuery
(Table<R>
The table to update data into
table
)

Deprecated as a consequence of UpdateQuery being deprecated.
Create a new UpdateQuery
public @NotNull WithAsStep
with(String alias)

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

public @NotNull WithAsStep
with(String alias, String... fieldAliases)

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

public @NotNull WithAsStep
with(String alias, Collection<String> fieldAliases)

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

public @NotNull WithAsStep
with(Name alias)

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

public @NotNull WithAsStep
with(Name alias, Name... fieldAliases)

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

public @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.

public @NotNull WithAsStep
with(String alias, Function<? super Field<?>, ? extends String> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.
public @NotNull WithAsStep
with(String alias, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.
public @NotNull WithAsStep1
with(String alias, String fieldAlias1)

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

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @NotNull WithAsStep1
with(Name alias, Name fieldAlias1)

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

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @NotNull WithStep
with(CommonTableExpression<?>... tables)

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

public @NotNull WithStep
with(Collection<? extends CommonTableExpression<?>> tables)

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

public @NotNull WithAsStep
withRecursive(String alias)

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

public @NotNull WithAsStep
withRecursive(String alias, String... fieldAliases)

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

public @NotNull WithAsStep
withRecursive(String alias, Collection<String> fieldAliases)

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

public @NotNull WithAsStep
withRecursive(Name alias)

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

public @NotNull WithAsStep
withRecursive(Name alias, Name... fieldAliases)

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

public @NotNull WithAsStep
withRecursive(Name alias, Collection<? extends Name> fieldAliases)

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

public @NotNull WithAsStep
withRecursive(String alias, Function<? super Field<?>, ? extends String> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.
public @NotNull WithAsStep
withRecursive(String alias, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.
public @NotNull WithAsStep1
withRecursive(String alias, String fieldAlias1)

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

public @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.

public @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.

public @NotNull WithAsStep4
withRecursive(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.

public @NotNull WithAsStep5
withRecursive(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.

public @NotNull WithAsStep6
withRecursive(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.

public @NotNull WithAsStep7
withRecursive(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.

public @NotNull WithAsStep8
withRecursive(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.

public @NotNull WithAsStep9
withRecursive(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.

public @NotNull WithAsStep10
withRecursive(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.

public @NotNull WithAsStep11
withRecursive(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.

public @NotNull WithAsStep12
withRecursive(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.

public @NotNull WithAsStep13
withRecursive(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.

public @NotNull WithAsStep14
withRecursive(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.

public @NotNull WithAsStep15
withRecursive(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.

public @NotNull WithAsStep16
withRecursive(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.

public @NotNull WithAsStep17
withRecursive(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.

public @NotNull WithAsStep18
withRecursive(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.

public @NotNull WithAsStep19
withRecursive(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.

public @NotNull WithAsStep20
withRecursive(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.

public @NotNull WithAsStep21
withRecursive(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.

public @NotNull WithAsStep22
withRecursive(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.

public @NotNull WithAsStep1
withRecursive(Name alias, Name fieldAlias1)

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

public @NotNull WithAsStep2
withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2)

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

public @NotNull WithAsStep3
withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3)

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

public @NotNull WithAsStep4
withRecursive(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.

public @NotNull WithAsStep5
withRecursive(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.

public @NotNull WithAsStep6
withRecursive(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.

public @NotNull WithAsStep7
withRecursive(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.

public @NotNull WithAsStep8
withRecursive(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.

public @NotNull WithAsStep9
withRecursive(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.

public @NotNull WithAsStep10
withRecursive(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.

public @NotNull WithAsStep11
withRecursive(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.

public @NotNull WithAsStep12
withRecursive(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.

public @NotNull WithAsStep13
withRecursive(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.

public @NotNull WithAsStep14
withRecursive(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.

public @NotNull WithAsStep15
withRecursive(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.

public @NotNull WithAsStep16
withRecursive(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.

public @NotNull WithAsStep17
withRecursive(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.

public @NotNull WithAsStep18
withRecursive(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.

public @NotNull WithAsStep19
withRecursive(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.

public @NotNull WithAsStep20
withRecursive(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.

public @NotNull WithAsStep21
withRecursive(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.

public @NotNull WithAsStep22
withRecursive(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.

public @NotNull WithStep
withRecursive(CommonTableExpression<?>... tables)

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

public @NotNull WithStep
withRecursive(Collection<? extends CommonTableExpression<?>> tables)

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

Inherited from org.jooq.Scope:
configurationcreationTimedatadatadatadialectdslfamilysettings