Module org.jooq

Package org.jooq.impl

Class DefaultDSLContext

java.lang.Object

org.jooq.impl.DefaultDSLContext

All Implemented Interfaces:

Serializable, DSLContext, Scope

Direct Known Subclasses:

DefaultCloseableDSLContext

public class DefaultDSLContext
extends Object
implements DSLContext, Serializable

A default implementation for DSLContext.

You may use this as a base implementation for custom DSLContext subtypes preventing potential API breakage when upgrading jOOQ, or to delegate DSL method calls to your custom implementations.

Author:

Lukas Eder

See Also:

• Serialized Form

Constructor Summary

Constructors

Constructor	Description
DefaultDSLContext(io.r2dbc.spi.ConnectionFactory connectionFactory, SQLDialect dialect)
DefaultDSLContext(io.r2dbc.spi.ConnectionFactory connectionFactory, SQLDialect dialect, Settings settings)
DefaultDSLContext(Connection connection, SQLDialect dialect)
DefaultDSLContext(Connection connection, SQLDialect dialect, Settings settings)
DefaultDSLContext(DataSource datasource, SQLDialect dialect)
DefaultDSLContext(DataSource datasource, SQLDialect dialect, Settings settings)
DefaultDSLContext(Configuration configuration)
DefaultDSLContext(ConnectionProvider connectionProvider, SQLDialect dialect)
DefaultDSLContext(ConnectionProvider connectionProvider, SQLDialect dialect, Settings settings)
DefaultDSLContext(SQLDialect dialect)
DefaultDSLContext(SQLDialect dialect, Settings settings)

Method Summary

Modifier and Type

Method

Description

AlterDatabaseStep

alterDatabase(String database)

The ALTER DATABASE statement.

AlterDatabaseStep

alterDatabase(Catalog database)

The ALTER DATABASE statement.

AlterDatabaseStep

alterDatabase(Name database)

The ALTER DATABASE statement.

AlterDatabaseStep

alterDatabaseIfExists(String database)

The ALTER DATABASE IF EXISTS statement.

AlterDatabaseStep

alterDatabaseIfExists(Catalog database)

The ALTER DATABASE IF EXISTS statement.

AlterDatabaseStep

alterDatabaseIfExists(Name database)

The ALTER DATABASE IF EXISTS statement.

<T> AlterDomainStep<T>

alterDomain(String domain)

The ALTER DOMAIN statement.

<T> AlterDomainStep<T>

alterDomain(Domain<T> domain)

The ALTER DOMAIN statement.

<T> AlterDomainStep<T>

alterDomain(Name domain)

The ALTER DOMAIN statement.

<T> AlterDomainStep<T>

alterDomainIfExists(String domain)

The ALTER DOMAIN IF EXISTS statement.

<T> AlterDomainStep<T>

alterDomainIfExists(Domain<T> domain)

The ALTER DOMAIN IF EXISTS statement.

<T> AlterDomainStep<T>

alterDomainIfExists(Name domain)

The ALTER DOMAIN IF EXISTS statement.

AlterIndexOnStep

alterIndex(String index)

The ALTER INDEX statement.

AlterIndexOnStep

alterIndex(Index index)

The ALTER INDEX statement.

AlterIndexOnStep

alterIndex(Name index)

The ALTER INDEX statement.

AlterIndexOnStep

alterIndexIfExists(String index)

The ALTER INDEX IF EXISTS statement.

AlterIndexOnStep

alterIndexIfExists(Index index)

The ALTER INDEX IF EXISTS statement.

AlterIndexOnStep

alterIndexIfExists(Name index)

The ALTER INDEX IF EXISTS statement.

AlterSchemaStep

alterSchema(String schema)

The ALTER SCHEMA statement.

AlterSchemaStep

alterSchema(Name schema)

The ALTER SCHEMA statement.

AlterSchemaStep

alterSchema(Schema schema)

The ALTER SCHEMA statement.

AlterSchemaStep

alterSchemaIfExists(String schema)

The ALTER SCHEMA IF EXISTS statement.

AlterSchemaStep

alterSchemaIfExists(Name schema)

The ALTER SCHEMA IF EXISTS statement.

AlterSchemaStep

alterSchemaIfExists(Schema schema)

The ALTER SCHEMA IF EXISTS statement.

AlterSequenceStep<Number>

alterSequence(String sequence)

The ALTER SEQUENCE statement.

AlterSequenceStep<Number>

alterSequence(Name sequence)

The ALTER SEQUENCE statement.

<T extends Number>
AlterSequenceStep<T>

alterSequence(Sequence<T> sequence)

The ALTER SEQUENCE statement.

AlterSequenceStep<Number>

alterSequenceIfExists(String sequence)

The ALTER SEQUENCE IF EXISTS statement.

AlterSequenceStep<Number>

alterSequenceIfExists(Name sequence)

The ALTER SEQUENCE IF EXISTS statement.

<T extends Number>
AlterSequenceStep<T>

alterSequenceIfExists(Sequence<T> sequence)

The ALTER SEQUENCE IF EXISTS statement.

AlterTableStep

alterTable(String table)

Create a new DSL ALTER TABLE statement.

AlterTableStep

alterTable(Name table)

Create a new DSL ALTER TABLE statement.

AlterTableStep

alterTable(Table<?> table)

Create a new DSL ALTER TABLE statement.

AlterTableStep

alterTableIfExists(String table)

Create a new DSL ALTER TABLE statement.

AlterTableStep

alterTableIfExists(Name table)

Create a new DSL ALTER TABLE statement.

AlterTableStep

alterTableIfExists(Table<?> table)

Create a new DSL ALTER TABLE statement.

AlterTypeStep

alterType(String type)

The ALTER TYPE statement.

AlterTypeStep

alterType(Name type)

The ALTER TYPE statement.

AlterViewStep

alterView(String view)

The ALTER VIEW statement.

AlterViewStep

alterView(Name view)

The ALTER VIEW statement.

AlterViewStep

alterView(Table<?> view)

The ALTER VIEW statement.

AlterViewStep

alterViewIfExists(String view)

The ALTER VIEW IF EXISTS statement.

AlterViewStep

alterViewIfExists(Name view)

The ALTER VIEW IF EXISTS statement.

AlterViewStep

alterViewIfExists(Table<?> view)

The ALTER VIEW IF EXISTS statement.

void

attach(Collection<? extends Attachable> attachables)

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

void

attach(Attachable... attachables)

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

BatchBindStep

batch(String sql)

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

Batch

batch(String... queries)

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

Batch

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

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

Batch

batch(Collection<? extends Query> queries)

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

Batch

batch(Queries queries)

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

BatchBindStep

batch(Query query)

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

Batch

batch(Query... queries)

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

Batch

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

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

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.

Batch

batchDelete(UpdatableRecord<?>... records)

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

void

batched(BatchedRunnable runnable)

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

<T> T

batchedResult(BatchedCallable<T> callable)

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

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.

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.

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.

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.

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.

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.

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.

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.

Block

begin(Collection<? extends Statement> statements)

Wrap a collection of statements in an anoymous procedural block.

Block

begin(Statement... statements)

Wrap a collection of statements in an anonymous procedural block.

BindContext

bindContext(PreparedStatement stmt)

Get a new BindContext for the context of this DSLContext.

CallArgsStep

call(String procedure)

The CALL statement.

CallArgsStep

call(Name procedure)

The CALL statement.

CommentOnIsStep

commentOnColumn(String field)

The COMMENT ON COLUMN statement.

CommentOnIsStep

commentOnColumn(Field<?> field)

The COMMENT ON COLUMN statement.

CommentOnIsStep

commentOnColumn(Name field)

The COMMENT ON COLUMN statement.

CommentOnIsStep

commentOnTable(String table)

The COMMENT ON TABLE statement.

CommentOnIsStep

commentOnTable(Name table)

The COMMENT ON TABLE statement.

CommentOnIsStep

commentOnTable(Table<?> table)

The COMMENT ON TABLE statement.

CommentOnIsStep

commentOnView(String view)

The COMMENT ON VIEW statement.

CommentOnIsStep

commentOnView(Name view)

The COMMENT ON VIEW statement.

CommentOnIsStep

commentOnView(Table<?> view)

The COMMENT ON VIEW statement.

Commit

commit(String id)

Initialise a Version.

Commits

commits()

Initialise a Commits graph.

final Configuration

configuration()

The configuration of the current scope.

void

connection(ConnectionRunnable runnable)

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

<T> T

connectionResult(ConnectionCallable<T> callable)

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

CreateDatabaseFinalStep

createDatabase(String database)

The CREATE DATABASE statement.

CreateDatabaseFinalStep

createDatabase(Catalog database)

The CREATE DATABASE statement.

CreateDatabaseFinalStep

createDatabase(Name database)

The CREATE DATABASE statement.

CreateDatabaseFinalStep

createDatabaseIfNotExists(String database)

The CREATE DATABASE IF NOT EXISTS statement.

CreateDatabaseFinalStep

createDatabaseIfNotExists(Catalog database)

The CREATE DATABASE IF NOT EXISTS statement.

CreateDatabaseFinalStep

createDatabaseIfNotExists(Name database)

The CREATE DATABASE IF NOT EXISTS statement.

CreateDomainAsStep

createDomain(String domain)

The CREATE DOMAIN statement.

CreateDomainAsStep

createDomain(Domain<?> domain)

The CREATE DOMAIN statement.

CreateDomainAsStep

createDomain(Name domain)

The CREATE DOMAIN statement.

CreateDomainAsStep

createDomainIfNotExists(String domain)

The CREATE DOMAIN IF NOT EXISTS statement.

CreateDomainAsStep

createDomainIfNotExists(Domain<?> domain)

The CREATE DOMAIN IF NOT EXISTS statement.

CreateDomainAsStep

createDomainIfNotExists(Name domain)

The CREATE DOMAIN IF NOT EXISTS statement.

CreateFunctionParametersStep

createFunction(String function)

The CREATE FUNCTION statement.

CreateFunctionParametersStep

createFunction(Name function)

The CREATE FUNCTION statement.

CreateTableElementListStep

createGlobalTemporaryTable(String table)

The CREATE GLOBAL TEMPORARY TABLE statement.

CreateTableElementListStep

createGlobalTemporaryTable(Name table)

The CREATE GLOBAL TEMPORARY TABLE statement.

CreateTableElementListStep

createGlobalTemporaryTable(Table<?> table)

The CREATE GLOBAL TEMPORARY TABLE statement.

CreateTableElementListStep

createGlobalTemporaryTableIfNotExists(String table)

The CREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS statement.

CreateTableElementListStep

createGlobalTemporaryTableIfNotExists(Name table)

The CREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS statement.

CreateTableElementListStep

createGlobalTemporaryTableIfNotExists(Table<?> table)

The CREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS statement.

CreateIndexStep

createIndex()

The CREATE INDEX statement.

CreateIndexStep

createIndex(String index)

The CREATE INDEX statement.

CreateIndexStep

createIndex(Index index)

The CREATE INDEX statement.

CreateIndexStep

createIndex(Name index)

The CREATE INDEX statement.

CreateIndexStep

createIndexIfNotExists()

The CREATE INDEX IF NOT EXISTS statement.

CreateIndexStep

createIndexIfNotExists(String index)

The CREATE INDEX IF NOT EXISTS statement.

CreateIndexStep

createIndexIfNotExists(Index index)

The CREATE INDEX IF NOT EXISTS statement.

CreateIndexStep

createIndexIfNotExists(Name index)

The CREATE INDEX IF NOT EXISTS statement.

CreateFunctionParametersStep

createOrReplaceFunction(String function)

The CREATE OR REPLACE FUNCTION statement.

CreateFunctionParametersStep

createOrReplaceFunction(Name function)

The CREATE OR REPLACE FUNCTION statement.

CreateProcedureParametersStep

createOrReplaceProcedure(String procedure)

The CREATE OR REPLACE PROCEDURE statement.

CreateProcedureParametersStep

createOrReplaceProcedure(Name procedure)

The CREATE OR REPLACE PROCEDURE statement.

CreateTriggerEventStep

createOrReplaceTrigger(String trigger)

The CREATE OR REPLACE TRIGGER statement.

CreateTriggerEventStep

createOrReplaceTrigger(Name trigger)

The CREATE OR REPLACE TRIGGER statement.

CreateViewAsStep<Record>

createOrReplaceView(String view, String... fields)

Create a new DSL CREATE OR REPLACE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE OR REPLACE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE OR REPLACE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE OR REPLACE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE OR REPLACE VIEW statement.

CreateViewAsStep<Record>

createOrReplaceView(Name view, Name... fields)

Create a new DSL CREATE OR REPLACE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE OR REPLACE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE OR REPLACE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE OR REPLACE VIEW statement.

CreateProcedureParametersStep

createProcedure(String procedure)

The CREATE PROCEDURE statement.

CreateProcedureParametersStep

createProcedure(Name procedure)

The CREATE PROCEDURE statement.

CreateSchemaFinalStep

createSchema(String schema)

The CREATE SCHEMA statement.

CreateSchemaFinalStep

createSchema(Name schema)

The CREATE SCHEMA statement.

CreateSchemaFinalStep

createSchema(Schema schema)

The CREATE SCHEMA statement.

CreateSchemaFinalStep

createSchemaIfNotExists(String schema)

The CREATE SCHEMA IF NOT EXISTS statement.

CreateSchemaFinalStep

createSchemaIfNotExists(Name schema)

The CREATE SCHEMA IF NOT EXISTS statement.

CreateSchemaFinalStep

createSchemaIfNotExists(Schema schema)

The CREATE SCHEMA IF NOT EXISTS statement.

CreateSequenceFlagsStep

createSequence(String sequence)

The CREATE SEQUENCE statement.

CreateSequenceFlagsStep

createSequence(Name sequence)

The CREATE SEQUENCE statement.

CreateSequenceFlagsStep

createSequence(Sequence<?> sequence)

The CREATE SEQUENCE statement.

CreateSequenceFlagsStep

createSequenceIfNotExists(String sequence)

The CREATE SEQUENCE IF NOT EXISTS statement.

CreateSequenceFlagsStep

createSequenceIfNotExists(Name sequence)

The CREATE SEQUENCE IF NOT EXISTS statement.

CreateSequenceFlagsStep

createSequenceIfNotExists(Sequence<?> sequence)

The CREATE SEQUENCE IF NOT EXISTS statement.

CreateTableElementListStep

createTable(String table)

The CREATE TABLE statement.

CreateTableElementListStep

createTable(Name table)

The CREATE TABLE statement.

CreateTableElementListStep

createTable(Table<?> table)

The CREATE TABLE statement.

CreateTableElementListStep

createTableIfNotExists(String table)

The CREATE TABLE IF NOT EXISTS statement.

CreateTableElementListStep

createTableIfNotExists(Name table)

The CREATE TABLE IF NOT EXISTS statement.

CreateTableElementListStep

createTableIfNotExists(Table<?> table)

The CREATE TABLE IF NOT EXISTS statement.

CreateTableElementListStep

createTemporaryTable(String table)

The CREATE TEMPORARY TABLE statement.

CreateTableElementListStep

createTemporaryTable(Name table)

The CREATE TEMPORARY TABLE statement.

CreateTableElementListStep

createTemporaryTable(Table<?> table)

The CREATE TEMPORARY TABLE statement.

CreateTableElementListStep

createTemporaryTableIfNotExists(String table)

The CREATE TEMPORARY TABLE IF NOT EXISTS statement.

CreateTableElementListStep

createTemporaryTableIfNotExists(Name table)

The CREATE TEMPORARY TABLE IF NOT EXISTS statement.

CreateTableElementListStep

createTemporaryTableIfNotExists(Table<?> table)

The CREATE TEMPORARY TABLE IF NOT EXISTS statement.

CreateTriggerEventStep

createTrigger(String trigger)

The CREATE TRIGGER statement.

CreateTriggerEventStep

createTrigger(Name trigger)

The CREATE TRIGGER statement.

CreateTypeStep

createType(String type)

Create a new DSL CREATE TYPE statement.

CreateTypeStep

createType(Name type)

Create a new DSL CREATE TYPE statement.

CreateIndexStep

createUniqueIndex()

The CREATE UNIQUE INDEX statement.

CreateIndexStep

createUniqueIndex(String index)

The CREATE UNIQUE INDEX statement.

CreateIndexStep

createUniqueIndex(Index index)

The CREATE UNIQUE INDEX statement.

CreateIndexStep

createUniqueIndex(Name index)

The CREATE UNIQUE INDEX statement.

CreateIndexStep

createUniqueIndexIfNotExists()

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

CreateIndexStep

createUniqueIndexIfNotExists(String index)

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

CreateIndexStep

createUniqueIndexIfNotExists(Index index)

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

CreateIndexStep

createUniqueIndexIfNotExists(Name index)

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

CreateViewAsStep<Record>

createView(String view, String... fields)

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

createView(Name view, Name... fields)

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

createViewIfNotExists(String view, String... fields)

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

createViewIfNotExists(Name view, Name... fields)

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

final Instant

creationTime()

The time, according to Configuration.clock(), when this Scope was created.

BigInteger

currval(String sequence)

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

BigInteger

currval(Name sequence)

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

<T extends Number>
T

currval(Sequence<T> sequence)

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

final Map<Object,Object>

data()

Get all custom data from this Scope.

final Object

data(Object key)

Get some custom data from this Scope.

final Object

data(Object key, Object value)

Set some custom data to this Scope.

Queries

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

Convenience method for Meta.ddl().

Queries

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

Convenience method for Meta.ddl(DDLExportConfiguration).

Queries

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

Convenience method for Meta.ddl(DDLExportConfiguration).

Queries

ddl(Catalog catalog)

Convenience method for Meta.ddl().

Queries

ddl(Catalog catalog, DDLExportConfiguration exportConfiguration)

Convenience method for Meta.ddl(DDLExportConfiguration).

Queries

ddl(Catalog catalog, DDLFlag... flags)

Convenience method for Meta.ddl(DDLExportConfiguration).

Queries

ddl(Schema schema)

Convenience method for Meta.ddl().

Queries

ddl(Schema schema, DDLExportConfiguration exportConfiguration)

Convenience method for Meta.ddl(DDLExportConfiguration).

Queries

ddl(Schema schema, DDLFlag... flags)

Convenience method for Meta.ddl(DDLExportConfiguration).

Queries

ddl(Table... tables)

Convenience method for Meta.ddl().

Queries

ddl(Table[] tables, DDLExportConfiguration exportConfiguration)

Convenience method for Meta.ddl(DDLExportConfiguration).

Queries

ddl(Table[] tables, DDLFlag... flags)

Convenience method for Meta.ddl(DDLExportConfiguration).

Queries

ddl(Table<?> table)

Convenience method for Meta.ddl().

Queries

ddl(Table<?> table, DDLExportConfiguration exportConfiguration)

Convenience method for Meta.ddl(DDLExportConfiguration).

Queries

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

Convenience method for Meta.ddl(DDLExportConfiguration).

<R extends Record>
DeleteUsingStep<R>

delete(Table<R> table)

Create a new DSL delete statement.

<R extends Record>
DeleteUsingStep<R>

deleteFrom(Table<R> table)

Create a new DSL delete statement.

<R extends Record>
DeleteQuery<R>

deleteQuery(Table<R> table)

Create a new DeleteQuery

Connection

diagnosticsConnection()

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

DataSource

diagnosticsDataSource()

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

final SQLDialect

dialect()

The SQLDialect wrapped by this context.

DropDatabaseFinalStep

dropDatabase(String database)

The DROP DATABASE statement.

DropDatabaseFinalStep

dropDatabase(Catalog database)

The DROP DATABASE statement.

DropDatabaseFinalStep

dropDatabase(Name database)

The DROP DATABASE statement.

DropDatabaseFinalStep

dropDatabaseIfExists(String database)

The DROP DATABASE IF EXISTS statement.

DropDatabaseFinalStep

dropDatabaseIfExists(Catalog database)

The DROP DATABASE IF EXISTS statement.

DropDatabaseFinalStep

dropDatabaseIfExists(Name database)

The DROP DATABASE IF EXISTS statement.

DropDomainCascadeStep

dropDomain(String domain)

The DROP DOMAIN statement.

DropDomainCascadeStep

dropDomain(Domain<?> domain)

The DROP DOMAIN statement.

DropDomainCascadeStep

dropDomain(Name domain)

The DROP DOMAIN statement.

DropDomainCascadeStep

dropDomainIfExists(String domain)

The DROP DOMAIN IF EXISTS statement.

DropDomainCascadeStep

dropDomainIfExists(Domain<?> domain)

The DROP DOMAIN IF EXISTS statement.

DropDomainCascadeStep

dropDomainIfExists(Name domain)

The DROP DOMAIN IF EXISTS statement.

DDLQuery

dropFunction(String function)

The DROP FUNCTION statement.

DDLQuery

dropFunction(Name function)

The DROP FUNCTION statement.

DDLQuery

dropFunctionIfExists(String function)

The DROP FUNCTION IF EXISTS statement.

DDLQuery

dropFunctionIfExists(Name function)

The DROP FUNCTION IF EXISTS statement.

DropIndexOnStep

dropIndex(String index)

The DROP INDEX statement.

DropIndexOnStep

dropIndex(Index index)

The DROP INDEX statement.

DropIndexOnStep

dropIndex(Name index)

The DROP INDEX statement.

DropIndexOnStep

dropIndexIfExists(String index)

The DROP INDEX IF EXISTS statement.

DropIndexOnStep

dropIndexIfExists(Index index)

The DROP INDEX IF EXISTS statement.

DropIndexOnStep

dropIndexIfExists(Name index)

The DROP INDEX IF EXISTS statement.

DDLQuery

dropProcedure(String procedure)

The DROP PROCEDURE statement.

DDLQuery

dropProcedure(Name procedure)

The DROP PROCEDURE statement.

DDLQuery

dropProcedureIfExists(String procedure)

The DROP PROCEDURE IF EXISTS statement.

DDLQuery

dropProcedureIfExists(Name procedure)

The DROP PROCEDURE IF EXISTS statement.

DropSchemaStep

dropSchema(String schema)

The DROP SCHEMA statement.

DropSchemaStep

dropSchema(Name schema)

The DROP SCHEMA statement.

DropSchemaStep

dropSchema(Schema schema)

The DROP SCHEMA statement.

DropSchemaStep

dropSchemaIfExists(String schema)

The DROP SCHEMA IF EXISTS statement.

DropSchemaStep

dropSchemaIfExists(Name schema)

The DROP SCHEMA IF EXISTS statement.

DropSchemaStep

dropSchemaIfExists(Schema schema)

The DROP SCHEMA IF EXISTS statement.

DropSequenceFinalStep

dropSequence(String sequence)

The DROP SEQUENCE statement.

DropSequenceFinalStep

dropSequence(Name sequence)

The DROP SEQUENCE statement.

DropSequenceFinalStep

dropSequence(Sequence<?> sequence)

The DROP SEQUENCE statement.

DropSequenceFinalStep

dropSequenceIfExists(String sequence)

The DROP SEQUENCE IF EXISTS statement.

DropSequenceFinalStep

dropSequenceIfExists(Name sequence)

The DROP SEQUENCE IF EXISTS statement.

DropSequenceFinalStep

dropSequenceIfExists(Sequence<?> sequence)

The DROP SEQUENCE IF EXISTS statement.

DropTableStep

dropTable(String table)

The DROP TABLE statement.

DropTableStep

dropTable(Name table)

The DROP TABLE statement.

DropTableStep

dropTable(Table<?> table)

The DROP TABLE statement.

DropTableStep

dropTableIfExists(String table)

The DROP TABLE IF EXISTS statement.

DropTableStep

dropTableIfExists(Name table)

The DROP TABLE IF EXISTS statement.

DropTableStep

dropTableIfExists(Table<?> table)

The DROP TABLE IF EXISTS statement.

DropTableStep

dropTemporaryTable(String table)

The DROP TEMPORARY TABLE statement.

DropTableStep

dropTemporaryTable(Name table)

The DROP TEMPORARY TABLE statement.

DropTableStep

dropTemporaryTable(Table<?> table)

The DROP TEMPORARY TABLE statement.

DropTableStep

dropTemporaryTableIfExists(String table)

The DROP TEMPORARY TABLE IF EXISTS statement.

DropTableStep

dropTemporaryTableIfExists(Name table)

The DROP TEMPORARY TABLE IF EXISTS statement.

DropTableStep

dropTemporaryTableIfExists(Table<?> table)

The DROP TEMPORARY TABLE IF EXISTS statement.

DDLQuery

dropTrigger(String trigger)

The DROP TRIGGER statement.

DDLQuery

dropTrigger(Name trigger)

The DROP TRIGGER statement.

DDLQuery

dropTriggerIfExists(String trigger)

The DROP TRIGGER IF EXISTS statement.

DDLQuery

dropTriggerIfExists(Name trigger)

The DROP TRIGGER IF EXISTS statement.

DropTypeStep

dropType(String type)

Create a new DSL DROP TYPE statement.

DropTypeStep

dropType(String... type)

Create a new DSL DROP TYPE statement.

DropTypeStep

dropType(Collection<?> type)

Create a new DSL DROP TYPE statement.

DropTypeStep

dropType(Name type)

Create a new DSL DROP TYPE statement.

DropTypeStep

dropType(Name... type)

Create a new DSL DROP TYPE statement.

DropTypeStep

dropTypeIfExists(String type)

Create a new DSL DROP TYPE statement.

DropTypeStep

dropTypeIfExists(String... type)

Create a new DSL DROP TYPE statement.

DropTypeStep

dropTypeIfExists(Collection<?> type)

Create a new DSL DROP TYPE statement.

DropTypeStep

dropTypeIfExists(Name type)

Create a new DSL DROP TYPE statement.

DropTypeStep

dropTypeIfExists(Name... type)

Create a new DSL DROP TYPE statement.

DropViewFinalStep

dropView(String view)

The DROP VIEW statement.

DropViewFinalStep

dropView(Name view)

The DROP VIEW statement.

DropViewFinalStep

dropView(Table<?> view)

The DROP VIEW statement.

DropViewFinalStep

dropViewIfExists(String view)

The DROP VIEW IF EXISTS statement.

DropViewFinalStep

dropViewIfExists(Name view)

The DROP VIEW IF EXISTS statement.

DropViewFinalStep

dropViewIfExists(Table<?> view)

The DROP VIEW IF EXISTS statement.

final DSLContext

dsl()

Wrap the Scope.configuration() in a DSLContext, providing access to the configuration-contextual DSL to construct executable queries.

int

execute(String sql)

Execute a query holding plain SQL.

int

execute(String sql, Object... bindings)

Execute a new query holding plain SQL.

int

execute(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

int

execute(Query query)

Execute a Query in the context of this DSLContext.

int

execute(SQL sql)

Execute a query holding plain SQL.

int

executeDelete(TableRecord<?> record, Condition condition)

Delete a record from a table.

int

executeDelete(UpdatableRecord<?> record)

Delete a record from a table.

int

executeInsert(TableRecord<?> record)

Insert one record.

int

executeUpdate(TableRecord<?> record, Condition condition)

Update a table.

int

executeUpdate(UpdatableRecord<?> record)

Update a table.

Explain

explain(Query query)

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

List<Object>

extractBindValues(QueryPart part)

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

Param<?>

extractParam(QueryPart part, String name)

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

Map<String,Param<?>>

extractParams(QueryPart part)

Get a Map of named parameters.

final SQLDialect

family()

The SQLDialect.family() wrapped by this context.

Result<Record>

fetch(String sql)

Execute a new query holding plain SQL.

Result<Record>

fetch(String sql, Object... bindings)

Execute a new query holding plain SQL.

Result<Record>

fetch(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

Result<Record>

fetch(ResultSet rs)

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

Result<Record>

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

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

Result<Record>

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

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

Result<Record>

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

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

<R extends Record>
Result<R>

fetch(ResultQuery<R> query)

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

Result<Record>

fetch(SQL sql)

Execute a new query holding plain SQL.

<R extends Record>
Result<R>

fetch(Table<R> table)

Execute and return all records for

<R extends Record>
Result<R>

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

Execute and return all records for

<R extends Record>
Result<R>

fetch(Table<R> table, Condition condition)

Execute and return all records for

<R extends Record>
Result<R>

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

Execute and return all records for

<R extends Record>
R

fetchAny(Table<R> table)

Execute and return zero or one record for

<R extends Record>
R

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

Execute and return zero or one record for

<R extends Record>
R

fetchAny(Table<R> table, Condition condition)

Execute and return zero or one record for

<R extends Record>
R

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

Execute and return zero or on e record for

CompletionStage<Result<Record>>

fetchAsync(String sql)

Fetch results in a new CompletionStage.

CompletionStage<Result<Record>>

fetchAsync(String sql, Object... bindings)

Fetch results in a new CompletionStage.

CompletionStage<Result<Record>>

fetchAsync(String sql, QueryPart... parts)

Fetch results in a new CompletionStage.

CompletionStage<Result<Record>>

fetchAsync(ResultSet rs)

Fetch results in a new CompletionStage.

CompletionStage<Result<Record>>

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

Fetch results in a new CompletionStage.

CompletionStage<Result<Record>>

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

Fetch results in a new CompletionStage.

CompletionStage<Result<Record>>

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

Fetch results in a new CompletionStage.

CompletionStage<Result<Record>>

fetchAsync(Executor executor, String sql)

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

CompletionStage<Result<Record>>

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

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

CompletionStage<Result<Record>>

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

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

CompletionStage<Result<Record>>

fetchAsync(Executor executor, ResultSet rs)

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

CompletionStage<Result<Record>>

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

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

CompletionStage<Result<Record>>

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

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

CompletionStage<Result<Record>>

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

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

<R extends Record>
CompletionStage<Result<R>>

fetchAsync(Executor executor, ResultQuery<R> query)

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

CompletionStage<Result<Record>>

fetchAsync(Executor executor, SQL sql)

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

<R extends Record>
CompletionStage<Result<R>>

fetchAsync(Executor executor, Table<R> table)

Execute and return all records asynchronously for

<R extends Record>
CompletionStage<Result<R>>

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

Execute and return all records asynchronously for

<R extends Record>
CompletionStage<Result<R>>

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

Execute and return all records asynchronously for

<R extends Record>
CompletionStage<Result<R>>

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

Execute and return all records asynchronously for

<R extends Record>
CompletionStage<Result<R>>

fetchAsync(ResultQuery<R> query)

Fetch results in a new CompletionStage.

CompletionStage<Result<Record>>

fetchAsync(SQL sql)

Fetch results in a new CompletionStage.

<R extends Record>
CompletionStage<Result<R>>

fetchAsync(Table<R> table)

Execute and return all records asynchronously for

<R extends Record>
CompletionStage<Result<R>>

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

Execute and return all records asynchronously for

<R extends Record>
CompletionStage<Result<R>>

fetchAsync(Table<R> table, Condition condition)

Execute and return all records asynchronously for

<R extends Record>
CompletionStage<Result<R>>

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

Execute and return all records asynchronously for

<R extends TableRecord<R>>
Result<R>

fetchByExample(R example)

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

int

fetchCount(Select<?> query)

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

int

fetchCount(Table<?> table)

Count the number of records in a table.

int

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

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

int

fetchCount(Table<?> table, Condition condition)

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

int

fetchCount(Table<?> table, Condition... conditions)

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

boolean

fetchExists(Select<?> query)

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

boolean

fetchExists(Table<?> table)

Check if a table has any records.

boolean

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

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

boolean

fetchExists(Table<?> table, Condition condition)

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

boolean

fetchExists(Table<?> table, Condition... conditions)

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

Result<Record>

fetchFromCSV(String string)

Fetch all data from a CSV string.

Result<Record>

fetchFromCSV(String string, boolean header)

Fetch all data from a CSV string.

Result<Record>

fetchFromCSV(String string, boolean header, char delimiter)

Fetch all data from a CSV string.

Result<Record>

fetchFromCSV(String string, char delimiter)

Fetch all data from a CSV string.

Result<Record>

fetchFromHTML(String string)

Convert an HTML table into a jOOQ Result.

Result<Record>

fetchFromJSON(String string)

Fetch all data from a JSON string.

Result<Record>

fetchFromStringData(String[]... strings)

Fetch all data from a list of strings.

Result<Record>

fetchFromStringData(List<String[]> strings)

Fetch all data from a list of strings.

Result<Record>

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

Fetch all data from a list of strings.

Result<Record>

fetchFromTXT(String string)

Fetch all data from a formatted string.

Result<Record>

fetchFromTXT(String string, String nullLiteral)

Fetch all data from a formatted string.

Result<Record>

fetchFromXML(String string)

Fetch all data from an XML string.

<K, V> Map<K,List<V>>

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

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

Cursor<Record>

fetchLazy(String sql)

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

Cursor<Record>

fetchLazy(String sql, Object... bindings)

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

Cursor<Record>

fetchLazy(String sql, QueryPart... parts)

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

Cursor<Record>

fetchLazy(ResultSet rs)

Wrap a JDBC ResultSet into a jOOQ Cursor.

Cursor<Record>

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

Wrap a JDBC ResultSet into a jOOQ Cursor.

Cursor<Record>

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

Wrap a JDBC ResultSet into a jOOQ Cursor.

Cursor<Record>

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

Wrap a JDBC ResultSet into a jOOQ Cursor.

<R extends Record>
Cursor<R>

fetchLazy(ResultQuery<R> query)

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

Cursor<Record>

fetchLazy(SQL sql)

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

<R extends Record>
Cursor<R>

fetchLazy(Table<R> table)

Execute and return all records lazily for

<R extends Record>
Cursor<R>

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

Execute and return all records lazily for

<R extends Record>
Cursor<R>

fetchLazy(Table<R> table, Condition condition)

Execute and return all records lazily for

<R extends Record>
Cursor<R>

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

Execute and return all records lazily for

Results

fetchMany(String sql)

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

Results

fetchMany(String sql, Object... bindings)

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

Results

fetchMany(String sql, QueryPart... parts)

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

<R extends Record>
Results

fetchMany(ResultQuery<R> query)

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

Results

fetchMany(SQL sql)

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

<K, V> Map<K,V>

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

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

Record

fetchOne(String sql)

Execute a new query holding plain SQL.

Record

fetchOne(String sql, Object... bindings)

Execute a new query holding plain SQL.

Record

fetchOne(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

Record

fetchOne(ResultSet rs)

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

Record

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

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

Record

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

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

Record

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

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

<R extends Record>
R

fetchOne(ResultQuery<R> query)

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

Record

fetchOne(SQL sql)

Execute a new query holding plain SQL.

<R extends Record>
R

fetchOne(Table<R> table)

Execute and return zero or one record for

<R extends Record>
R

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

Execute and return zero or one record for

<R extends Record>
R

fetchOne(Table<R> table, Condition condition)

Execute and return zero or one record for

<R extends Record>
R

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

Execute and return zero or one record for

Optional<Record>

fetchOptional(String sql)

Execute a new query holding plain SQL.

Optional<Record>

fetchOptional(String sql, Object... bindings)

Execute a new query holding plain SQL.

Optional<Record>

fetchOptional(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

Optional<Record>

fetchOptional(ResultSet rs)

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

Optional<Record>

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

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

Optional<Record>

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

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

Optional<Record>

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

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

<R extends Record>
Optional<R>

fetchOptional(ResultQuery<R> query)

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

Optional<Record>

fetchOptional(SQL sql)

Execute a new query holding plain SQL.

<R extends Record>
Optional<R>

fetchOptional(Table<R> table)

Execute and return zero or one record for

<R extends Record>
Optional<R>

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

Execute and return zero or one record for

<R extends Record>
Optional<R>

fetchOptional(Table<R> table, Condition condition)

Execute and return zero or one record for

<R extends Record>
Optional<R>

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

Execute and return zero or one record for

Optional<?>

fetchOptionalValue(String sql)

Execute a new query holding plain SQL.

Optional<?>

fetchOptionalValue(String sql, Object... bindings)

Execute a new query holding plain SQL.

Optional<?>

fetchOptionalValue(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

Optional<?>

fetchOptionalValue(ResultSet rs)

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

<T> Optional<T>

fetchOptionalValue(ResultSet rs, Class<T> type)

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

<T> Optional<T>

fetchOptionalValue(ResultSet rs, DataType<T> type)

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

<T> Optional<T>

fetchOptionalValue(ResultSet rs, Field<T> field)

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

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

fetchOptionalValue(ResultQuery<R> query)

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

Optional<?>

fetchOptionalValue(SQL sql)

Execute a new query holding plain SQL.

<T> Optional<T>

fetchOptionalValue(TableField<?,T> field)

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

Record

fetchSingle(String sql)

Execute a new query holding plain SQL.

Record

fetchSingle(String sql, Object... bindings)

Execute a new query holding plain SQL.

Record

fetchSingle(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

Record

fetchSingle(ResultSet rs)

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

Record

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

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

Record

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

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

Record

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

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

Record

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

Execute and return exactly one record for

<R extends Record>
R

fetchSingle(ResultQuery<R> query)

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

Record

fetchSingle(SelectField<?>... fields)

Execute and return exactly one record for

<T1> Record1<T1>

fetchSingle(SelectField<T1> field1)

Execute and return exactly one record for

<T1, T2> Record2<T1,T2>

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

Execute and return exactly one record for

<T1, T2, T3> Record3<T1,T2,T3>

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

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

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

Execute and return exactly one record for

Record

fetchSingle(SQL sql)

Execute a new query holding plain SQL.

<R extends Record>
R

fetchSingle(Table<R> table)

Execute and return exactly one record for

<R extends Record>
R

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

Execute and return exactly one record for

<R extends Record>
R

fetchSingle(Table<R> table, Condition condition)

Execute and return exactly one record for

<R extends Record>
R

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

Execute and return exactly one record for

<R extends Record>
R

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

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

<R extends Record>
R

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

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

<R extends Record>
R

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

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

<R extends Record>
R

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

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

<R extends Record>
R

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

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

<R extends Record>
R

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

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

<R extends Record>
R

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

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

<R extends Record>
R

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

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

<R extends Record>
R

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

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

<R extends Record>
R

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

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

<R extends Record>
R

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

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

<R extends Record>
R

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

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

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14)

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

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15)

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

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16)

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

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17)

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

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18)

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

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19)

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

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20)

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

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21)

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

<R extends Record>
R

fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21, Condition c22)

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

Stream<Record>

fetchStream(String sql)

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

Stream<Record>

fetchStream(String sql, Object... bindings)

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

Stream<Record>

fetchStream(String sql, QueryPart... parts)

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

Stream<Record>

fetchStream(ResultSet rs)

Wrap a JDBC ResultSet into a jOOQ Stream.

Stream<Record>

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

Wrap a JDBC ResultSet into a jOOQ Stream.

Stream<Record>

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

Wrap a JDBC ResultSet into a jOOQ Stream.

Stream<Record>

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

Wrap a JDBC ResultSet into a jOOQ Stream.

<R extends Record>
Stream<R>

fetchStream(ResultQuery<R> query)

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

Stream<Record>

fetchStream(SQL sql)

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

<R extends Record>
Stream<R>

fetchStream(Table<R> table)

Execute and return all records lazily for

<R extends Record>
Stream<R>

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

Execute and return all records lazily for

<R extends Record>
Stream<R>

fetchStream(Table<R> table, Condition condition)

Execute and return all records lazily for

<R extends Record>
Stream<R>

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

Execute and return all records lazily for

Object

fetchValue(String sql)

Execute a new query holding plain SQL.

Object

fetchValue(String sql, Object... bindings)

Execute a new query holding plain SQL.

Object

fetchValue(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

Object

fetchValue(ResultSet rs)

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

<T> T

fetchValue(ResultSet rs, Class<T> type)

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

<T> T

fetchValue(ResultSet rs, DataType<T> type)

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

<T> T

fetchValue(ResultSet rs, Field<T> field)

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

<T, R extends Record1<T>>
T

fetchValue(ResultQuery<R> query)

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

<T> T

fetchValue(SelectField<T> field)

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

Object

fetchValue(SQL sql)

Execute a new query holding plain SQL.

<T> T

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

Fetch a single value from a single column table.

<T> T

fetchValue(TableField<?,T> field)

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

List<?>

fetchValues(String sql)

Execute a new query holding plain SQL.

List<?>

fetchValues(String sql, Object... bindings)

Execute a new query holding plain SQL.

List<?>

fetchValues(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

List<?>

fetchValues(ResultSet rs)

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

<T> List<T>

fetchValues(ResultSet rs, Class<T> type)

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

<T> List<T>

fetchValues(ResultSet rs, DataType<T> type)

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

<T> List<T>

fetchValues(ResultSet rs, Field<T> field)

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

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

fetchValues(ResultQuery<R> query)

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

List<?>

fetchValues(SQL sql)

Execute a new query holding plain SQL.

<T> List<T>

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

Fetch all values from a single column table.

<T> List<T>

fetchValues(TableField<?,T> field)

Fetch all values in a given Table's TableField.

GrantOnStep

grant(Collection<? extends Privilege> privileges)

The GRANT statement.

GrantOnStep

grant(Privilege privileges)

The GRANT statement.

GrantOnStep

grant(Privilege... privileges)

The GRANT statement.

InformationSchema

informationSchema(Catalog catalog)

Convenience method for Meta.informationSchema().

InformationSchema

informationSchema(Catalog... catalogs)

Convenience method for Meta.informationSchema().

InformationSchema

informationSchema(Schema schema)

Convenience method for Meta.informationSchema().

InformationSchema

informationSchema(Schema... schemas)

Convenience method for Meta.informationSchema().

InformationSchema

informationSchema(Table<?> table)

Convenience method for Meta.informationSchema().

InformationSchema

informationSchema(Table<?>... tables)

Convenience method for Meta.informationSchema().

<R extends Record>
InsertSetStep<R>

insertInto(Table<R> into)

Create a new DSL insert statement.

<R extends Record>
InsertValuesStepN<R>

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

Create a new DSL insert statement.

<R extends Record>
InsertValuesStepN<R>

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

<R extends Record>
InsertQuery<R>

insertQuery(Table<R> into)

Create a new InsertQuery

BigInteger

lastID()

Retrieve the last inserted ID.

<R extends Record>
LoaderOptionsStep<R>

loadInto(Table<R> table)

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

Schema

map(Schema schema)

Map a schema to another one.

<R extends Record>
Table<R>

map(Table<R> table)

Map a table to another one.

<R extends Record>
MergeUsingStep<R>

mergeInto(Table<R> table)

Create a new DSL SQL standard MERGE statement.

<R extends Record>
MergeKeyStepN<R>

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

Create a new DSL merge statement (H2-specific syntax).

<R extends Record>
MergeKeyStepN<R>

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

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Meta

meta()

Access the database meta data.

Meta

meta(String... sources)

Create meta data from a set of sources.

Meta

meta(DatabaseMetaData meta)

Access the database meta data from an explicit JDBC DatabaseMetaData.

Meta

meta(Catalog... catalogs)

Access the database meta data from explicit catalog information.

Meta

meta(Query... queries)

Create meta data from a set of DDL queries.

Meta

meta(Schema... schemas)

Access the database meta data from explicit schema information.

Meta

meta(Source... sources)

Create meta data from a set of sources.

Meta

meta(Table<?>... tables)

Access the database meta data from explicit table information.

Meta

meta(InformationSchema schema)

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

Migration

migrateTo(Commit to)

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

void

mock(MockDataProvider provider, MockRunnable mockable)

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

<T> T

mockResult(MockDataProvider provider, MockCallable<T> mockable)

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

Record

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

Create a new empty Record.

Record

newRecord(Field<?>... fields)

Create a new empty Record.

<T1> Record1<T1>

newRecord(Field<T1> field1)

Create a new empty Record.

<T1, T2> Record2<T1,T2>

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

Create a new empty Record.

<T1, T2, T3> Record3<T1,T2,T3>

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

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

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

Create a new empty Record.

<R extends Record>
R

newRecord(Table<R> table)

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

<R extends Record>
R

newRecord(Table<R> table, Object source)

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

<R extends UDTRecord<R>>
R

newRecord(UDT<R> type)

Create a new UDTRecord.

Result<Record>

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

Create a new empty Record.

Result<Record>

newResult(Field<?>... fields)

Create a new empty Record.

<T1> Result<Record1<T1>>

newResult(Field<T1> field1)

Create a new empty Result.

<T1, T2> Result<Record2<T1,T2>>

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

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

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

Create a new empty Result.

<R extends Record>
Result<R>

newResult(Table<R> table)

Create a new empty Result.

BigInteger

nextval(String sequence)

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

BigInteger

nextval(Name sequence)

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

<T extends Number>
T

nextval(Sequence<T> sequence)

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

<T extends Number>
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.

Parser

parser()

Access the parser API.

Connection

parsingConnection()

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

io.r2dbc.spi.ConnectionFactory

parsingConnectionFactory()

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

DataSource

parsingDataSource()

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

Queries

queries(Collection<? extends Query> queries)

Wrap a collection of queries.

Queries

queries(Query... queries)

Wrap a collection of queries.

RowCountQuery

query(String sql)

Create a new query holding plain SQL.

RowCountQuery

query(String sql, Object... bindings)

Create a new query holding plain SQL.

RowCountQuery

query(String sql, QueryPart... parts)

Create a new query holding plain SQL.

RowCountQuery

query(SQL sql)

Create a new query holding plain SQL.

String

render(QueryPart part)

Render a QueryPart in the context of this DSLContext.

RenderContext

renderContext()

Get a new RenderContext for the context of this DSLContext.

String

renderInlined(QueryPart part)

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

String

renderNamedOrInlinedParams(QueryPart part)

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

String

renderNamedParams(QueryPart part)

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

ResultQuery<Record>

resultQuery(String sql)

Create a new query holding plain SQL.

ResultQuery<Record>

resultQuery(String sql, Object... bindings)

Create a new query holding plain SQL.

ResultQuery<Record>

resultQuery(String sql, QueryPart... parts)

Create a new query holding plain SQL.

ResultQuery<Record>

resultQuery(SQL sql)

Create a new query holding plain SQL.

RevokeOnStep

revoke(Collection<? extends Privilege> privileges)

The REVOKE statement.

RevokeOnStep

revoke(Privilege privileges)

The REVOKE statement.

RevokeOnStep

revoke(Privilege... privileges)

The REVOKE statement.

RevokeOnStep

revokeGrantOptionFor(Collection<? extends Privilege> privileges)

The REVOKE GRANT OPTION FOR statement.

RevokeOnStep

revokeGrantOptionFor(Privilege privileges)

The REVOKE GRANT OPTION FOR statement.

RevokeOnStep

revokeGrantOptionFor(Privilege... privileges)

The REVOKE GRANT OPTION FOR statement.

SelectSelectStep<Record>

select(Collection<? extends SelectFieldOrAsterisk> fields)

Create a new DSL select statement.

<T1> SelectSelectStep<Record1<T1>>

select(SelectField<T1> field1)

Create a new DSL select statement.

<T1, T2> SelectSelectStep<Record2<T1,T2>>

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

SelectSelectStep<Record>

select(SelectFieldOrAsterisk... fields)

Create a new DSL select statement.

SelectSelectStep<Record1<Integer>>

selectCount()

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

SelectSelectStep<Record>

selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)

Create a new DSL select statement.

<T1> SelectSelectStep<Record1<T1>>

selectDistinct(SelectField<T1> field1)

Create a new DSL select statement.

<T1, T2> SelectSelectStep<Record2<T1,T2>>

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

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

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

Create a new DSL select statement.

SelectSelectStep<Record>

selectDistinct(SelectFieldOrAsterisk... fields)

Create a new DSL select statement.

SelectWhereStep<Record>

selectFrom(String sql)

Create a new DSL select statement, projecting *.

SelectWhereStep<Record>

selectFrom(String sql, Object... bindings)

Create a new DSL select statement, projecting *.

SelectWhereStep<Record>

selectFrom(String sql, QueryPart... parts)

Create a new DSL select statement, projecting *.

SelectWhereStep<Record>

selectFrom(Name table)

Create a new DSL select statement, projecting *.

SelectWhereStep<Record>

selectFrom(SQL sql)

Create a new DSL select statement, projecting *.

<R extends Record>
SelectWhereStep<R>

selectFrom(TableLike<R> table)

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

SelectSelectStep<Record1<Integer>>

selectOne()

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

SelectQuery<Record>

selectQuery()

Create a new SelectQuery

<R extends Record>
SelectQuery<R>

selectQuery(TableLike<R> table)

Create a new SelectQuery

SelectSelectStep<Record1<Integer>>

selectZero()

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

RowCountQuery

set(Name name, Param<?> value)

The SET statement.

RowCountQuery

setCatalog(String catalog)

The SET CATALOG statement.

RowCountQuery

setCatalog(Catalog catalog)

The SET CATALOG statement.

RowCountQuery

setCatalog(Name catalog)

The SET CATALOG statement.

RowCountQuery

setLocal(Name name, Param<?> value)

The SET LOCAL statement.

RowCountQuery

setSchema(String schema)

The SET SCHEMA statement.

RowCountQuery

setSchema(Name schema)

The SET SCHEMA statement.

RowCountQuery

setSchema(Schema schema)

The SET SCHEMA statement.

final Settings

settings()

The settings wrapped by this context.

Block

statements(Collection<? extends Statement> statements)

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

Block

statements(Statement... statements)

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

String

toString()

void

transaction(ContextTransactionalRunnable transactional)

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

void

transaction(TransactionalRunnable transactional)

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

CompletionStage<Void>

transactionAsync(Executor executor, TransactionalRunnable transactional)

Run a TransactionalRunnable asynchronously.

CompletionStage<Void>

transactionAsync(TransactionalRunnable transactional)

Run a TransactionalRunnable asynchronously.

<T> Publisher<T>

transactionPublisher(TransactionalPublishable<T> transactional)

Run a TransactionalPublishable reactively.

<T> T

transactionResult(ContextTransactionalCallable<T> transactional)

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

<T> T

transactionResult(TransactionalCallable<T> transactional)

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

<T> CompletionStage<T>

transactionResultAsync(Executor executor, TransactionalCallable<T> transactional)

Run a TransactionalCallable asynchronously.

<T> CompletionStage<T>

transactionResultAsync(TransactionalCallable<T> transactional)

Run a TransactionalCallable asynchronously.

TruncateIdentityStep<Record>

truncate(String table)

The TRUNCATE statement.

TruncateIdentityStep<Record>

truncate(Name table)

The TRUNCATE statement.

<R extends Record>
TruncateIdentityStep<R>

truncate(Table<R> table)

The TRUNCATE statement.

TruncateIdentityStep<Record>

truncateTable(String table)

The TRUNCATE TABLE statement.

TruncateIdentityStep<Record>

truncateTable(Name table)

The TRUNCATE TABLE statement.

<R extends Record>
TruncateIdentityStep<R>

truncateTable(Table<R> table)

The TRUNCATE TABLE statement.

<R extends Record>
UpdateSetFirstStep<R>

update(Table<R> table)

Create a new DSL update statement.

<R extends Record>
UpdateQuery<R>

updateQuery(Table<R> table)

Create a new UpdateQuery

Version

version(String id)

Initialise a Version.

Versions

versions()

Initialise a Versions graph.

WithAsStep

with(String alias)

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

WithAsStep1

with(String alias, String fieldAlias1)

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

WithAsStep

with(String alias, String... fieldAliases)

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

WithAsStep2

with(String alias, String fieldAlias1, String fieldAlias2)

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

WithAsStep

with(String alias, Collection<String> fieldAliases)

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

WithAsStep

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

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

WithAsStep

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

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

WithStep

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

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

WithStep

with(CommonTableExpression<?>... tables)

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

WithAsStep

with(Name alias)

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

WithAsStep

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

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

WithAsStep1

with(Name alias, Name fieldAlias1)

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

WithAsStep

with(Name alias, Name... fieldAliases)

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

WithAsStep2

with(Name alias, Name fieldAlias1, Name fieldAlias2)

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

WithAsStep21

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