Uses of Annotation Interface
org.jooq.CheckReturnValue

Packages that use CheckReturnValue

Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.impl	This package contains jOOQ's implementation classes.

Uses of CheckReturnValue in org.jooq

Methods in org.jooq with annotations of type CheckReturnValue

Modifier and Type

Method

Description

@NotNull JSONArrayReturningStep<T>

JSONArrayNullStep.absentOnNull()

Add the ABSENT ON NULL clause to the JSON ARRAY function.

@NotNull JSONObjectReturningStep<T>

JSONObjectNullStep.absentOnNull()

Add the ABSENT ON NULL clause to the JSON OBJECT function.

@NotNull AlterDomainFinalStep

AlterDomainStep.add(Constraint addConstraint)

Add the ADD clause to the ALTER DOMAIN statement.

@NotNull AlterTableAddStep

AlterTableStep.add(String field, DataType<?> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.add(Collection<? extends FieldOrConstraint> fields)

Add an ADD clause with multiple columns or constraints to the ALTER TABLE statement.

@NotNull AlterTableUsingIndexStep

AlterTableStep.add(Constraint constraint)

Add an ADD CONSTRAINT clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.add(Field<?> field)

Add an ADD COLUMN clause to the ALTER TABLE statement.

<T> @NotNull AlterTableAddStep

AlterTableStep.add(Field<T> field, DataType<T> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.add(FieldOrConstraint... fields)

Add an ADD clause with multiple columns or constraints to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.add(Name field, DataType<?> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addColumn(String field, DataType<?> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addColumn(Field<?> field)

Add an ADD COLUMN clause to the ALTER TABLE statement.

<T> @NotNull AlterTableAddStep

AlterTableStep.addColumn(Field<T> field, DataType<T> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addColumn(Name field, DataType<?> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addColumnIfNotExists(String field, DataType<?> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addColumnIfNotExists(Field<?> field)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

<T> @NotNull AlterTableAddStep

AlterTableStep.addColumnIfNotExists(Field<T> field, DataType<T> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addColumnIfNotExists(Name field, DataType<?> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addIfNotExists(String field, DataType<?> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addIfNotExists(Field<?> field)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

<T> @NotNull AlterTableAddStep

AlterTableStep.addIfNotExists(Field<T> field, DataType<T> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableAddStep

AlterTableStep.addIfNotExists(Name field, DataType<?> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTypeFinalStep

AlterTypeStep.addValue(String addValue)

Add the ADD VALUE clause to the ALTER TYPE statement.

@NotNull AlterTypeFinalStep

AlterTypeStep.addValue(Field<String> addValue)

Add the ADD VALUE clause to the ALTER TYPE statement.

@NotNull AlterTableFinalStep

AlterTableAddStep.after(String columnName)

Add a AFTER clause to ALTER TABLE … ADD ….

@NotNull AlterTableFinalStep

AlterTableAddStep.after(Field<?> columnName)

Add a AFTER clause to ALTER TABLE … ADD ….

@NotNull AlterTableFinalStep

AlterTableAddStep.after(Name columnName)

Add a AFTER clause to ALTER TABLE … ADD ….

@NotNull CreateTriggerEventOrStep

CreateTriggerEventStep.afterDelete()

Add the AFTER DELETE clause to the CREATE TRIGGER statement.

@NotNull CreateTriggerEventOrStep

CreateTriggerEventStep.afterInsert()

Add the AFTER INSERT clause to the CREATE TRIGGER statement.

@NotNull CreateTriggerEventOfStep

CreateTriggerEventStep.afterUpdate()

Add the AFTER UPDATE clause to the CREATE TRIGGER statement.

@NotNull AlterTableAlterStep<Object>

AlterTableStep.alter(String field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAlterConstraintStep

AlterTableStep.alter(Constraint constraint)

Add an ALTER CONSTRAINT clause to the ALTER TABLE statement.

<T> @NotNull AlterTableAlterStep<T>

AlterTableStep.alter(Field<T> field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAlterStep<Object>

AlterTableStep.alter(Name field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAlterStep<Object>

AlterTableStep.alterColumn(String field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

<T> @NotNull AlterTableAlterStep<T>

AlterTableStep.alterColumn(Field<T> field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAlterStep<Object>

AlterTableStep.alterColumn(Name field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableAlterConstraintStep

AlterTableStep.alterConstraint(String constraint)

Add an ALTER CONSTRAINT clause to the ALTER TABLE statement.

@NotNull AlterTableAlterConstraintStep

AlterTableStep.alterConstraint(Constraint constraint)

Add an ALTER CONSTRAINT clause to the ALTER TABLE statement.

@NotNull AlterTableAlterConstraintStep

AlterTableStep.alterConstraint(Name constraint)

Add an ALTER CONSTRAINT clause to the ALTER TABLE statement.

@NotNull AlterDatabaseStep

DSLContext.alterDatabase(String database)

The ALTER DATABASE statement.

@NotNull AlterDatabaseStep

DSLContext.alterDatabase(Catalog database)

The ALTER DATABASE statement.

@NotNull AlterDatabaseStep

DSLContext.alterDatabase(Name database)

The ALTER DATABASE statement.

@NotNull AlterDatabaseStep

DSLContext.alterDatabaseIfExists(String database)

The ALTER DATABASE IF EXISTS statement.

@NotNull AlterDatabaseStep

DSLContext.alterDatabaseIfExists(Catalog database)

The ALTER DATABASE IF EXISTS statement.

@NotNull AlterDatabaseStep

DSLContext.alterDatabaseIfExists(Name database)

The ALTER DATABASE IF EXISTS statement.

<T> @NotNull AlterDomainStep<T>

DSLContext.alterDomain(String domain)

The ALTER DOMAIN statement.

<T> @NotNull AlterDomainStep<T>

DSLContext.alterDomain(Domain<T> domain)

The ALTER DOMAIN statement.

<T> @NotNull AlterDomainStep<T>

DSLContext.alterDomain(Name domain)

The ALTER DOMAIN statement.

<T> @NotNull AlterDomainStep<T>

DSLContext.alterDomainIfExists(String domain)

The ALTER DOMAIN IF EXISTS statement.

<T> @NotNull AlterDomainStep<T>

DSLContext.alterDomainIfExists(Domain<T> domain)

The ALTER DOMAIN IF EXISTS statement.

<T> @NotNull AlterDomainStep<T>

DSLContext.alterDomainIfExists(Name domain)

The ALTER DOMAIN IF EXISTS statement.

@NotNull AlterIndexOnStep

DSLContext.alterIndex(String index)

The ALTER INDEX statement.

@NotNull AlterIndexOnStep

DSLContext.alterIndex(Index index)

The ALTER INDEX statement.

@NotNull AlterIndexOnStep

DSLContext.alterIndex(Name index)

The ALTER INDEX statement.

@NotNull AlterIndexOnStep

DSLContext.alterIndexIfExists(String index)

The ALTER INDEX IF EXISTS statement.

@NotNull AlterIndexOnStep

DSLContext.alterIndexIfExists(Index index)

The ALTER INDEX IF EXISTS statement.

@NotNull AlterIndexOnStep

DSLContext.alterIndexIfExists(Name index)

The ALTER INDEX IF EXISTS statement.

@NotNull AlterSchemaStep

DSLContext.alterSchema(String schema)

The ALTER SCHEMA statement.

@NotNull AlterSchemaStep

DSLContext.alterSchema(Name schema)

The ALTER SCHEMA statement.

@NotNull AlterSchemaStep

DSLContext.alterSchema(Schema schema)

The ALTER SCHEMA statement.

@NotNull AlterSchemaStep

DSLContext.alterSchemaIfExists(String schema)

The ALTER SCHEMA IF EXISTS statement.

@NotNull AlterSchemaStep

DSLContext.alterSchemaIfExists(Name schema)

The ALTER SCHEMA IF EXISTS statement.

@NotNull AlterSchemaStep

DSLContext.alterSchemaIfExists(Schema schema)

The ALTER SCHEMA IF EXISTS statement.

@NotNull AlterSequenceStep<Number>

DSLContext.alterSequence(String sequence)

The ALTER SEQUENCE statement.

@NotNull AlterSequenceStep<Number>

DSLContext.alterSequence(Name sequence)

The ALTER SEQUENCE statement.

<T extends Number>
@NotNull AlterSequenceStep<T>

DSLContext.alterSequence(Sequence<T> sequence)

The ALTER SEQUENCE statement.

@NotNull AlterSequenceStep<Number>

DSLContext.alterSequenceIfExists(String sequence)

The ALTER SEQUENCE IF EXISTS statement.

@NotNull AlterSequenceStep<Number>

DSLContext.alterSequenceIfExists(Name sequence)

The ALTER SEQUENCE IF EXISTS statement.

<T extends Number>
@NotNull AlterSequenceStep<T>

DSLContext.alterSequenceIfExists(Sequence<T> sequence)

The ALTER SEQUENCE IF EXISTS statement.

@NotNull AlterTableStep

DSLContext.alterTable(String table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

DSLContext.alterTable(Name table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

DSLContext.alterTable(Table<?> table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

DSLContext.alterTableIfExists(String table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

DSLContext.alterTableIfExists(Name table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

DSLContext.alterTableIfExists(Table<?> table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTypeStep

DSLContext.alterType(String type)

The ALTER TYPE statement.

@NotNull AlterTypeStep

DSLContext.alterType(Name type)

The ALTER TYPE statement.

@NotNull AlterViewStep

DSLContext.alterView(String view)

The ALTER VIEW statement.

@NotNull AlterViewStep

DSLContext.alterView(Name view)

The ALTER VIEW statement.

@NotNull AlterViewStep

DSLContext.alterView(Table<?> view)

The ALTER VIEW statement.

@NotNull AlterViewStep

DSLContext.alterViewIfExists(String view)

The ALTER VIEW IF EXISTS statement.

@NotNull AlterViewStep

DSLContext.alterViewIfExists(Name view)

The ALTER VIEW IF EXISTS statement.

@NotNull AlterViewStep

DSLContext.alterViewIfExists(Table<?> view)

The ALTER VIEW IF EXISTS statement.

@NotNull DeleteConditionStep<R>

DeleteConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull DeleteConditionStep<R>

DeleteConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull DeleteConditionStep<R>

DeleteConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull DeleteConditionStep<R>

DeleteConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull DeleteConditionStep<R>

DeleteConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull DeleteConditionStep<R>

DeleteConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.

@NotNull UpdateConditionStep<R>

UpdateConditionStep.and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull UpdateConditionStep<R>

UpdateConditionStep.and(String sql, Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull UpdateConditionStep<R>

UpdateConditionStep.and(String sql, QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull UpdateConditionStep<R>

UpdateConditionStep.and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull UpdateConditionStep<R>

UpdateConditionStep.and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull UpdateConditionStep<R>

UpdateConditionStep.and(SQL sql)

Combine the currently assembled conditions with another one using the Operator.AND operator

@NotNull DeleteConditionStep<R>

DeleteConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull UpdateConditionStep<R>

UpdateConditionStep.andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator

@NotNull DeleteConditionStep<R>

DeleteConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator

@NotNull DeleteConditionStep<R>

DeleteConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step.

@NotNull UpdateConditionStep<R>

UpdateConditionStep.andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator

@NotNull UpdateConditionStep<R>

UpdateConditionStep.andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator

@NotNull DeleteConditionStep<R>

DeleteConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator

@NotNull InsertOnConflictConditionStep<R>

InsertOnConflictConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull MergeOnConditionStep<R>

MergeOnConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectConditionStep<R>

SelectConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectHavingConditionStep<R>

SelectHavingConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectOnConditionStep<R>

SelectOnConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull SelectQualifyConditionStep<R>

SelectQualifyConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.

@NotNull UpdateConditionStep<R>

UpdateConditionStep.andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator

@NotNull Query

CallArgsStep.args(Collection<? extends Field<?>> args)

Add the ARGS clause to the CALL statement.

@NotNull Query

CallArgsStep.args(Field<?>... args)

Add the ARGS clause to the CALL statement.

<T> @NotNull CreateDomainDefaultStep<T>

CreateDomainAsStep.as(Class<T> dataType)

Add the AS clause to the CREATE DOMAIN statement.

<T> @NotNull CreateDomainDefaultStep<T>

CreateDomainAsStep.as(DataType<T> dataType)

Add the AS clause to the CREATE DOMAIN statement.

@NotNull DDLQuery

CreateFunctionAsStep.as(Collection<? extends Statement> body)

Add the AS clause to the CREATE FUNCTION statement.

@NotNull DDLQuery

CreateFunctionAsStep.as(Statement body)

Add the AS clause to the CREATE FUNCTION statement.

@NotNull DDLQuery

CreateFunctionAsStep.as(Statement... body)

Add the AS clause to the CREATE FUNCTION statement.

@NotNull DDLQuery

CreateProcedureAsStep.as(Collection<? extends Statement> body)

Add the AS clause to the CREATE PROCEDURE statement.

@NotNull DDLQuery

CreateProcedureAsStep.as(Statement body)

Add the AS clause to the CREATE PROCEDURE statement.

@NotNull DDLQuery

CreateProcedureAsStep.as(Statement... body)

Add the AS clause to the CREATE PROCEDURE statement.

@NotNull CreateTableWithDataStep

CreateTableAsStep.as(Select<? extends R> select)

Add an AS clause to the CREATE TABLE statement.

@NotNull DDLQuery

CreateTriggerActionStep.as(Collection<? extends Statement> body)

Add the AS clause to the CREATE TRIGGER statement.

@NotNull DDLQuery

CreateTriggerActionStep.as(Statement body)

Add the AS clause to the CREATE TRIGGER statement.

@NotNull DDLQuery

CreateTriggerActionStep.as(Statement... body)

Add the AS clause to the CREATE TRIGGER statement.

@NotNull CreateViewFinalStep

CreateViewAsStep.as(String sql)

Add an AS clause to the CREATE VIEW statement.

@NotNull CreateViewFinalStep

CreateViewAsStep.as(String sql, Object... bindings)

Add an AS clause to the CREATE VIEW statement.

@NotNull CreateViewFinalStep

CreateViewAsStep.as(String sql, QueryPart... parts)

Add an AS clause to the CREATE VIEW statement.

@NotNull CreateViewFinalStep

CreateViewAsStep.as(Select<? extends R> select)

Add an AS clause to the CREATE VIEW statement.

@NotNull CreateViewFinalStep

CreateViewAsStep.as(SQL sql)

Add an AS clause to the CREATE VIEW statement.

@NotNull WithStep

WithAsStep.as(ResultQuery<?> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep1.as(ResultQuery<? extends Record1<?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep10.as(ResultQuery<? extends Record10<?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep11.as(ResultQuery<? extends Record11<?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep12.as(ResultQuery<? extends Record12<?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep13.as(ResultQuery<? extends Record13<?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep14.as(ResultQuery<? extends Record14<?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep15.as(ResultQuery<? extends Record15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep16.as(ResultQuery<? extends Record16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep17.as(ResultQuery<? extends Record17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep18.as(ResultQuery<? extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep19.as(ResultQuery<? extends Record19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep2.as(ResultQuery<? extends Record2<?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep20.as(ResultQuery<? extends Record20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep21.as(ResultQuery<? extends Record21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep22.as(ResultQuery<? extends Record22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep3.as(ResultQuery<? extends Record3<?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep4.as(ResultQuery<? extends Record4<?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep5.as(ResultQuery<? extends Record5<?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep6.as(ResultQuery<? extends Record6<?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep7.as(ResultQuery<? extends Record7<?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep8.as(ResultQuery<? extends Record8<?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep9.as(ResultQuery<? extends Record9<?,?,?,?,?,?,?,?,?>> query)

Associate a subselect with a common table expression's table and column names.

@NotNull CreateTypeFinalStep

CreateTypeStep.asEnum()

Add the AS ENUM clause to the CREATE TYPE statement.

@NotNull CreateTypeFinalStep

CreateTypeStep.asEnum(String... values)

Add the AS ENUM clause to the CREATE TYPE statement.

@NotNull CreateTypeFinalStep

CreateTypeStep.asEnum(Collection<?> values)

Add the AS ENUM clause to the CREATE TYPE statement.

@NotNull CreateTypeFinalStep

CreateTypeStep.asEnum(Field<String>... values)

Add the AS ENUM clause to the CREATE TYPE statement.

@NotNull WithStep

WithAsStep.asMaterialized(ResultQuery<?> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep1.asMaterialized(ResultQuery<? extends Record1<?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep10.asMaterialized(ResultQuery<? extends Record10<?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep11.asMaterialized(ResultQuery<? extends Record11<?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep12.asMaterialized(ResultQuery<? extends Record12<?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep13.asMaterialized(ResultQuery<? extends Record13<?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep14.asMaterialized(ResultQuery<? extends Record14<?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep15.asMaterialized(ResultQuery<? extends Record15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep16.asMaterialized(ResultQuery<? extends Record16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep17.asMaterialized(ResultQuery<? extends Record17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep18.asMaterialized(ResultQuery<? extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep19.asMaterialized(ResultQuery<? extends Record19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep2.asMaterialized(ResultQuery<? extends Record2<?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep20.asMaterialized(ResultQuery<? extends Record20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep21.asMaterialized(ResultQuery<? extends Record21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep22.asMaterialized(ResultQuery<? extends Record22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep3.asMaterialized(ResultQuery<? extends Record3<?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep4.asMaterialized(ResultQuery<? extends Record4<?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep5.asMaterialized(ResultQuery<? extends Record5<?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep6.asMaterialized(ResultQuery<? extends Record6<?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep7.asMaterialized(ResultQuery<? extends Record7<?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep8.asMaterialized(ResultQuery<? extends Record8<?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep9.asMaterialized(ResultQuery<? extends Record9<?,?,?,?,?,?,?,?,?>> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep.asNotMaterialized(ResultQuery<?> query)

Associate a materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep1.asNotMaterialized(ResultQuery<? extends Record1<?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep10.asNotMaterialized(ResultQuery<? extends Record10<?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep11.asNotMaterialized(ResultQuery<? extends Record11<?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep12.asNotMaterialized(ResultQuery<? extends Record12<?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep13.asNotMaterialized(ResultQuery<? extends Record13<?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep14.asNotMaterialized(ResultQuery<? extends Record14<?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep15.asNotMaterialized(ResultQuery<? extends Record15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep16.asNotMaterialized(ResultQuery<? extends Record16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep17.asNotMaterialized(ResultQuery<? extends Record17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep18.asNotMaterialized(ResultQuery<? extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep19.asNotMaterialized(ResultQuery<? extends Record19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep2.asNotMaterialized(ResultQuery<? extends Record2<?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep20.asNotMaterialized(ResultQuery<? extends Record20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep21.asNotMaterialized(ResultQuery<? extends Record21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep22.asNotMaterialized(ResultQuery<? extends Record22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep3.asNotMaterialized(ResultQuery<? extends Record3<?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep4.asNotMaterialized(ResultQuery<? extends Record4<?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep5.asNotMaterialized(ResultQuery<? extends Record5<?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep6.asNotMaterialized(ResultQuery<? extends Record6<?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep7.asNotMaterialized(ResultQuery<? extends Record7<?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep8.asNotMaterialized(ResultQuery<? extends Record8<?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull WithStep

WithAsStep9.asNotMaterialized(ResultQuery<? extends Record9<?,?,?,?,?,?,?,?,?>> query)

Associate a non-materialized subselect with a common table expression's table and column names.

@NotNull SelectForJSONCommonDirectivesStep<R>

SelectForJSONStep.auto()

Add a SQL Server-style FOR JSON AUTO clause.

@NotNull SelectForXMLRawDirectivesStep<R>

SelectForXMLStep.auto()

Add a SQL Server-style FOR XML AUTO clause.

@NotNull BatchBindStep

DSLContext.batch(String sql)

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

@NotNull Batch

DSLContext.batch(String... queries)

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

@NotNull Batch

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

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

@NotNull Batch

DSLContext.batch(Collection<? extends Query> queries)

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

@NotNull Batch

DSLContext.batch(Queries queries)

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

@NotNull BatchBindStep

DSLContext.batch(Query query)

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

@NotNull Batch

DSLContext.batch(Query... queries)

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

@NotNull Batch

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

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

@NotNull LoaderOptionsStep<R>

LoaderOptionsStep.batchAfter(int number)

Batch a given number of bulk statements together.

@NotNull LoaderOptionsStep<R>

LoaderOptionsStep.batchAll()

Batch all bulk statements in one JDBC batch statement.

@NotNull Batch

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

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

@NotNull Batch

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

@NotNull Batch

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

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

@NotNull Batch

DSLContext.batchInsert(TableRecord<?>... records)

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

@NotNull Batch

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

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

@NotNull Batch

DSLContext.batchMerge(UpdatableRecord<?>... records)

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

@NotNull LoaderOptionsStep<R>

LoaderOptionsStep.batchNone()

Do not batch bulk statements together.

@NotNull Batch

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

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

@NotNull Batch

DSLContext.batchStore(UpdatableRecord<?>... records)

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

@NotNull Batch

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

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

@NotNull Batch

DSLContext.batchUpdate(UpdatableRecord<?>... records)

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

@NotNull AlterTableFinalStep

AlterTableAddStep.before(String columnName)

Add a BEFORE clause to ALTER TABLE … ADD ….

@NotNull AlterTableFinalStep

AlterTableAddStep.before(Field<?> columnName)

Add a BEFORE clause to ALTER TABLE … ADD ….

@NotNull AlterTableFinalStep

AlterTableAddStep.before(Name columnName)

Add a BEFORE clause to ALTER TABLE … ADD ….

@NotNull CreateTriggerEventOrStep

CreateTriggerEventStep.beforeDelete()

Add the BEFORE DELETE clause to the CREATE TRIGGER statement.

@NotNull CreateTriggerEventOrStep

CreateTriggerEventStep.beforeInsert()

Add the BEFORE INSERT clause to the CREATE TRIGGER statement.

@NotNull CreateTriggerEventOfStep

CreateTriggerEventStep.beforeUpdate()

Add the BEFORE UPDATE clause to the CREATE TRIGGER statement.

@NotNull Block

DSLContext.begin(Collection<? extends Statement> statements)

Wrap a collection of statements in an anoymous procedural block.

@NotNull Block

DSLContext.begin(Statement... statements)

Wrap a collection of statements in an anonymous procedural block.

@NotNull BetweenAndStep<R>

SelectCorrelatedSubqueryStep.between(Select<? extends R> minValue)

Check if this subquery is within a range of two subqueries.

@NotNull Condition

SelectCorrelatedSubqueryStep.between(Select<? extends R> minValue, Select<? extends R> maxValue)

Check if this subquery is within a range of two subqueries.

@NotNull BetweenAndStep<R>

SelectCorrelatedSubqueryStep.between(R minValue)

Check if this subquery is within a range of two records.

@NotNull Condition

SelectCorrelatedSubqueryStep.between(R minValue, R maxValue)

Check if this subquery is within a range of two records.

@NotNull BetweenAndStepR<R>

SelectCorrelatedSubqueryStep.betweenSymmetric(Select<? extends R> minValue)

Check if this subquery is within a symmetric range of two subqueries.

@NotNull Condition

SelectCorrelatedSubqueryStep.betweenSymmetric(Select<? extends R> minValue, Select<? extends R> maxValue)

Check if this subquery is within a symmetric range of two subqueries.

@NotNull BetweenAndStepR<R>

SelectCorrelatedSubqueryStep.betweenSymmetric(R minValue)

Check if this subquery is within a symmetric range of two records.

@NotNull Condition

SelectCorrelatedSubqueryStep.betweenSymmetric(R minValue, R maxValue)

Check if this subquery is within a symmetric range of two records.

@NotNull BatchBindStep

BatchBindStep.bind(Object... bindValues)

Set indexed bind values onto the batch statement.

@NotNull BatchBindStep

BatchBindStep.bind(Object[]... bindValues)

Set several indexed bind values onto the batch statement.

@NotNull BatchBindStep

BatchBindStep.bind(Map<String,Object> namedBindValues)

Set named bind values onto the batch statement.

@NotNull BatchBindStep

BatchBindStep.bind(Map<String,Object>... namedBindValues)

Set several named bind values onto the batch statement.

@NotNull LoaderOptionsStep<R>

LoaderOptionsStep.bulkAfter(int number)

Bulk-insert a given number of statements in a single multi-row bulk statement.

@NotNull LoaderOptionsStep<R>

LoaderOptionsStep.bulkAll()

Bulk-insert all rows in a single multi-row bulk statement.

@NotNull LoaderOptionsStep<R>

LoaderOptionsStep.bulkNone()

Do not bulk-insert rows in multi-row bulk statements.

@NotNull AlterSequenceFlagsStep<T>

AlterSequenceFlagsStep.cache(Field<T> cache)

Add the CACHE clause to the ALTER SEQUENCE statement.

@NotNull AlterSequenceFlagsStep<T>

AlterSequenceFlagsStep.cache(T cache)

Add the CACHE clause to the ALTER SEQUENCE statement.

@NotNull CreateSequenceFlagsStep

CreateSequenceFlagsStep.cache(Number cache)

Add the CACHE clause to the CREATE SEQUENCE statement.

@NotNull CreateSequenceFlagsStep

CreateSequenceFlagsStep.cache(Field<? extends Number> cache)

Add the CACHE clause to the CREATE SEQUENCE statement.

@NotNull CallArgsStep

DSLContext.call(String procedure)

The CALL statement.

@NotNull CallArgsStep

DSLContext.call(Name procedure)

The CALL statement.

@NotNull CreateFunctionCharacteristicsStep

CreateFunctionCharacteristicsStep.calledOnNullInput()

Add the CALLED ON NULL INPUT clause to the CREATE FUNCTION statement.

@NotNull AlterDomainFinalStep

AlterDomainDropConstraintCascadeStep.cascade()

Add the CASCADE clause to the ALTER DOMAIN statement.

@NotNull AlterTableFinalStep

AlterTableDropStep.cascade()

Add a CASCADE clause to the ALTER TABLE … DROP statement.

@NotNull DropDomainFinalStep

DropDomainCascadeStep.cascade()

Add the CASCADE clause to the DROP DOMAIN statement.

@NotNull DropIndexFinalStep

DropIndexCascadeStep.cascade()

Add the CASCADE clause to the DROP INDEX statement.

@NotNull DropSchemaFinalStep

DropSchemaStep.cascade()

Add the CASCADE clause to the DROP SCHEMA statement.

@NotNull DropTableFinalStep

DropTableStep.cascade()

Add the CASCADE clause to the DROP TABLE statement.

@NotNull DropTypeFinalStep

DropTypeStep.cascade()

Add the CASCADE clause to the DROP TYPE statement.

@NotNull TruncateFinalStep<R>

TruncateCascadeStep.cascade()

Add the CASCADE clause to the TRUNCATE statement.

@NotNull CreateTableConstraintStep

CreateTableConstraintStep.check(Condition condition)

Convenience method to add an unnamed (system named) CHECK constraint to the table.

@NotNull CreateTableColumnStep

CreateTableColumnStep.column(String field, DataType<?> type)

Add a column to the column list of the CREATE TABLE statement.

@NotNull CreateTableColumnStep

CreateTableColumnStep.column(Field<?> field)

Add a column to the column list of the CREATE TABLE statement.

<T> @NotNull CreateTableColumnStep

CreateTableColumnStep.column(Field<T> field, DataType<T> type)

Add a column to the column list of the CREATE TABLE statement.

@NotNull CreateTableColumnStep

CreateTableColumnStep.column(Name field, DataType<?> type)

Add a column to the column list of the CREATE TABLE statement.

@NotNull CreateTableColumnStep

CreateTableColumnStep.columns(String... fields)

Add several columns to the column list of the CREATE TABLE statement.

@NotNull CreateTableColumnStep

CreateTableColumnStep.columns(Collection<? extends Field<?>> fields)

Add several columns to the column list of the CREATE TABLE statement.

@NotNull CreateTableColumnStep

CreateTableColumnStep.columns(Field<?>... fields)

Add several columns to the column list of the CREATE TABLE statement.

@NotNull CreateTableColumnStep

CreateTableColumnStep.columns(Name... fields)

Add several columns to the column list of the CREATE TABLE statement.

@NotNull InsertValuesStepN<R>

InsertSetStep.columns(Collection<? extends Field<?>> fields)

Set the columns for insert.

@NotNull InsertValuesStepN<R>

InsertSetStep.columns(Field<?>... fields)

Set the columns for insert.

<T1> @NotNull InsertValuesStep1<R,T1>

InsertSetStep.columns(Field<T1> field1)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Set the columns for insert.

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

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

Set the columns for insert.

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

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

Set the columns for insert.

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

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

Set the columns for insert.

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

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

Set the columns for insert.

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

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

Set the columns for insert.

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

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

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, 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)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, 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)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, 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)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, 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)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, 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)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, 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)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, 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)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, 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)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, 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)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, 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)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, 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)

Set the columns for insert.

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

InsertSetStep.columns(Field<T1> field1, Field<T2> field2, 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)

Set the columns for insert.

@NotNull MergeKeyStepN<R>

MergeUsingStep.columns(Collection<? extends Field<?>> fields)

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

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

@NotNull MergeKeyStepN<R>

MergeUsingStep.columns(Field<?>... fields)

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

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

<T1> @NotNull MergeKeyStep1<R,T1>

MergeUsingStep.columns(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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, 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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, 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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, 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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, 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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, 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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, 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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, 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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, 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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, 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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, 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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, 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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, 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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, 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 DSLContext.mergeInto(Table)

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

MergeUsingStep.columns(Field<T1> field1, Field<T2> field2, 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 DSLContext.mergeInto(Table)

@NotNull AlterTableFinalStep

AlterTableStep.comment(String comment)

Specify a comment for a table using MySQL's syntax.

@NotNull AlterTableFinalStep

AlterTableStep.comment(Comment comment)

Specify a comment for a table using MySQL's syntax.

@NotNull AlterViewFinalStep

AlterViewStep.comment(String comment)

Add the COMMENT clause to the ALTER VIEW statement.

@NotNull AlterViewFinalStep

AlterViewStep.comment(Comment comment)

Add the COMMENT clause to the ALTER VIEW statement.

@NotNull CreateTableStorageStep

CreateTableCommentStep.comment(String comment)

Add a comment to the table.

@NotNull CreateTableStorageStep

CreateTableCommentStep.comment(Comment comment)

Add a comment to the table.

@NotNull CommentOnIsStep

DSLContext.commentOnColumn(String field)

The COMMENT ON COLUMN statement.

@NotNull CommentOnIsStep

DSLContext.commentOnColumn(Field<?> field)

The COMMENT ON COLUMN statement.

@NotNull CommentOnIsStep

DSLContext.commentOnColumn(Name field)

The COMMENT ON COLUMN statement.

@NotNull CommentOnIsStep

DSLContext.commentOnTable(String table)

The COMMENT ON TABLE statement.

@NotNull CommentOnIsStep

DSLContext.commentOnTable(Name table)

The COMMENT ON TABLE statement.

@NotNull CommentOnIsStep

DSLContext.commentOnTable(Table<?> table)

The COMMENT ON TABLE statement.

@NotNull CommentOnIsStep

DSLContext.commentOnView(String view)

The COMMENT ON VIEW statement.

@NotNull CommentOnIsStep

DSLContext.commentOnView(Name view)

The COMMENT ON VIEW statement.

@NotNull CommentOnIsStep

DSLContext.commentOnView(Table<?> view)

The COMMENT ON VIEW statement.

@NotNull LoaderOptionsStep<R>

LoaderOptionsStep.commitAfter(int number)

Commit after a certain number of batches.

@NotNull LoaderOptionsStep<R>

LoaderOptionsStep.commitAll()

Commit only after inserting all batches.

@NotNull LoaderOptionsStep<R>

LoaderOptionsStep.commitEach()

Commit each batch.

@NotNull LoaderOptionsStep<R>

LoaderOptionsStep.commitNone()

Leave committing / rollbacking up to client code.

@NotNull Condition

SelectCorrelatedSubqueryStep.compare(Comparator comparator, QuantifiedSelect<? extends R> select)

Compare this subquery with a quantified subquery using a dynamic comparator.

@NotNull Condition

SelectCorrelatedSubqueryStep.compare(Comparator comparator, Select<? extends R> select)

Compare this subquery with a subquery using a dynamic comparator.

@NotNull Condition

SelectCorrelatedSubqueryStep.compare(Comparator comparator, R record)

Compare this subquery with a record using a dynamic comparator.

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithStep.connectBy(String sql)

Add an Oracle-specific CONNECT BY clause to the query

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithStep.connectBy(String sql, Object... bindings)

Add an Oracle-specific CONNECT BY clause to the query

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithStep.connectBy(String sql, QueryPart... parts)

Add an Oracle-specific CONNECT BY clause to the query

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithStep.connectBy(Condition condition)

Add an Oracle-specific CONNECT BY clause to the query

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithStep.connectBy(Field<Boolean> condition)

Add an Oracle-specific CONNECT BY clause to the query

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithStep.connectBy(SQL sql)

Add an Oracle-specific CONNECT BY clause to the query

@NotNull SelectConnectByConditionStep<R>

SelectConnectByStep.connectBy(String sql)

Add an Oracle-specific CONNECT BY clause to the query.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByStep.connectBy(String sql, Object... bindings)

Add an Oracle-specific CONNECT BY clause to the query.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByStep.connectBy(String sql, QueryPart... parts)

Add an Oracle-specific CONNECT BY clause to the query.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByStep.connectBy(Condition condition)

Add an Oracle-specific CONNECT BY clause to the query.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByStep.connectBy(Field<Boolean> condition)

Add an Oracle-specific CONNECT BY clause to the query.

@NotNull SelectConnectByConditionStep<R>

SelectConnectByStep.connectBy(SQL sql)

Add an Oracle-specific CONNECT BY clause to the query.

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithStep.connectByNoCycle(String sql)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithStep.connectByNoCycle(String sql, Object... bindings)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithStep.connectByNoCycle(String sql, QueryPart... parts)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithStep.connectByNoCycle(Condition condition)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithStep.connectByNoCycle(Field<Boolean> condition)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query

@NotNull SelectConnectByAfterStartWithConditionStep<R>

SelectConnectByAfterStartWithStep.connectByNoCycle(SQL sql)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query

@NotNull SelectConnectByConditionStep<R>

SelectConnectByStep.connectByNoCycle(String sql)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query

@NotNull SelectConnectByConditionStep<R>

SelectConnectByStep.connectByNoCycle(String sql, Object... bindings)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query

@NotNull SelectConnectByConditionStep<R>

SelectConnectByStep.connectByNoCycle(String sql, QueryPart... parts)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query

@NotNull SelectConnectByConditionStep<R>

SelectConnectByStep.connectByNoCycle(Condition condition)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query

@NotNull SelectConnectByConditionStep<R>

SelectConnectByStep.connectByNoCycle(Field<Boolean> condition)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query

@NotNull SelectConnectByConditionStep<R>

SelectConnectByStep.connectByNoCycle(SQL sql)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query

@NotNull CreateTableConstraintStep

CreateTableConstraintStep.constraint(Constraint constraint)

Add a constraint to the table.

@NotNull CreateDomainConstraintStep

CreateDomainConstraintStep.constraints(Collection<? extends Constraint> constraints)

Add the CONSTRAINTS clause to the CREATE DOMAIN statement.

@NotNull CreateDomainConstraintStep

CreateDomainConstraintStep.constraints(Constraint... constraints)

Add the CONSTRAINTS clause to the CREATE DOMAIN statement.

@NotNull CreateTableConstraintStep

CreateTableConstraintStep.constraints(Collection<? extends Constraint> constraints)

Add constraints to the table.

@NotNull CreateTableConstraintStep

CreateTableConstraintStep.constraints(Constraint... constraints)

Add constraints to the table.

@NotNull CreateFunctionCharacteristicsStep

CreateFunctionCharacteristicsStep.containsSQL()

Add the CONTAINS SQL clause to the CREATE FUNCTION statement.

@NotNull CreateProcedureCharacteristicsStep

CreateProcedureCharacteristicsStep.containsSQL()

Add the CONTAINS SQL clause to the CREATE PROCEDURE statement.

@NotNull TruncateCascadeStep<R>

TruncateIdentityStep.continueIdentity()

Add the CONTINUE IDENTITY clause to the TRUNCATE statement.

@NotNull CreateDatabaseFinalStep

DSLContext.createDatabase(String database)

The CREATE DATABASE statement.

@NotNull CreateDatabaseFinalStep

DSLContext.createDatabase(Catalog database)

The CREATE DATABASE statement.

@NotNull CreateDatabaseFinalStep

DSLContext.createDatabase(Name database)

The CREATE DATABASE statement.

@NotNull CreateDatabaseFinalStep

DSLContext.createDatabaseIfNotExists(String database)

The CREATE DATABASE IF NOT EXISTS statement.

@NotNull CreateDatabaseFinalStep

DSLContext.createDatabaseIfNotExists(Catalog database)

The CREATE DATABASE IF NOT EXISTS statement.

@NotNull CreateDatabaseFinalStep

DSLContext.createDatabaseIfNotExists(Name database)

The CREATE DATABASE IF NOT EXISTS statement.

@NotNull CreateDomainAsStep

DSLContext.createDomain(String domain)

The CREATE DOMAIN statement.

@NotNull CreateDomainAsStep

DSLContext.createDomain(Domain<?> domain)

The CREATE DOMAIN statement.

@NotNull CreateDomainAsStep

DSLContext.createDomain(Name domain)

The CREATE DOMAIN statement.

@NotNull CreateDomainAsStep

DSLContext.createDomainIfNotExists(String domain)

The CREATE DOMAIN IF NOT EXISTS statement.

@NotNull CreateDomainAsStep

DSLContext.createDomainIfNotExists(Domain<?> domain)

The CREATE DOMAIN IF NOT EXISTS statement.

@NotNull CreateDomainAsStep

DSLContext.createDomainIfNotExists(Name domain)

The CREATE DOMAIN IF NOT EXISTS statement.

@NotNull CreateFunctionParametersStep

DSLContext.createFunction(String function)

The CREATE FUNCTION statement.

@NotNull CreateFunctionParametersStep

DSLContext.createFunction(Name function)

The CREATE FUNCTION statement.

@NotNull CreateTableColumnStep

DSLContext.createGlobalTemporaryTable(String table)

Create a new DSL CREATE GLOBAL TEMPORARY TABLE statement.

@NotNull CreateTableColumnStep

DSLContext.createGlobalTemporaryTable(Name table)

Create a new DSL CREATE GLOBAL TEMPORARY TABLE statement.

@NotNull CreateTableColumnStep

DSLContext.createGlobalTemporaryTable(Table<?> table)

Create a new DSL CREATE GLOBAL TEMPORARY TABLE statement.

@NotNull CreateIndexStep

DSLContext.createIndex()

The CREATE INDEX statement.

@NotNull CreateIndexStep

DSLContext.createIndex(String index)

The CREATE INDEX statement.

@NotNull CreateIndexStep

DSLContext.createIndex(Index index)

The CREATE INDEX statement.

@NotNull CreateIndexStep

DSLContext.createIndex(Name index)

The CREATE INDEX statement.

@NotNull CreateIndexStep

DSLContext.createIndexIfNotExists()

The CREATE INDEX IF NOT EXISTS statement.

@NotNull CreateIndexStep

DSLContext.createIndexIfNotExists(String index)

The CREATE INDEX IF NOT EXISTS statement.

@NotNull CreateIndexStep

DSLContext.createIndexIfNotExists(Index index)

The CREATE INDEX IF NOT EXISTS statement.

@NotNull CreateIndexStep

DSLContext.createIndexIfNotExists(Name index)

The CREATE INDEX IF NOT EXISTS statement.

@NotNull CreateFunctionParametersStep

DSLContext.createOrReplaceFunction(String function)

The CREATE OR REPLACE FUNCTION statement.

@NotNull CreateFunctionParametersStep

DSLContext.createOrReplaceFunction(Name function)

The CREATE OR REPLACE FUNCTION statement.

@NotNull CreateProcedureParametersStep

DSLContext.createOrReplaceProcedure(String procedure)

The CREATE OR REPLACE PROCEDURE statement.

@NotNull CreateProcedureParametersStep

DSLContext.createOrReplaceProcedure(Name procedure)

The CREATE OR REPLACE PROCEDURE statement.

@NotNull CreateTriggerEventStep

DSLContext.createOrReplaceTrigger(String trigger)

The CREATE OR REPLACE TRIGGER statement.

@NotNull CreateTriggerEventStep

DSLContext.createOrReplaceTrigger(Name trigger)

The CREATE OR REPLACE TRIGGER statement.

@NotNull CreateViewAsStep<Record>

DSLContext.createOrReplaceView(String view, String... fields)

Create a new DSL CREATE OR REPLACE VIEW statement.

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

DSLContext.createOrReplaceView(Name view, Name... fields)

Create a new DSL CREATE OR REPLACE VIEW statement.

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

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

Create a new DSL CREATE OR REPLACE VIEW statement.

@NotNull CreateProcedureParametersStep

DSLContext.createProcedure(String procedure)

The CREATE PROCEDURE statement.

@NotNull CreateProcedureParametersStep

DSLContext.createProcedure(Name procedure)

The CREATE PROCEDURE statement.

@NotNull CreateSchemaFinalStep

DSLContext.createSchema(String schema)

The CREATE SCHEMA statement.

@NotNull CreateSchemaFinalStep

DSLContext.createSchema(Name schema)

The CREATE SCHEMA statement.

@NotNull CreateSchemaFinalStep

DSLContext.createSchema(Schema schema)

The CREATE SCHEMA statement.

@NotNull CreateSchemaFinalStep

DSLContext.createSchemaIfNotExists(String schema)

The CREATE SCHEMA IF NOT EXISTS statement.

@NotNull CreateSchemaFinalStep

DSLContext.createSchemaIfNotExists(Name schema)

The CREATE SCHEMA IF NOT EXISTS statement.

@NotNull CreateSchemaFinalStep

DSLContext.createSchemaIfNotExists(Schema schema)

The CREATE SCHEMA IF NOT EXISTS statement.

@NotNull CreateSequenceFlagsStep

DSLContext.createSequence(String sequence)

The CREATE SEQUENCE statement.

@NotNull CreateSequenceFlagsStep

DSLContext.createSequence(Name sequence)

The CREATE SEQUENCE statement.

@NotNull CreateSequenceFlagsStep

DSLContext.createSequence(Sequence<?> sequence)

The CREATE SEQUENCE statement.

@NotNull CreateSequenceFlagsStep

DSLContext.createSequenceIfNotExists(String sequence)

The CREATE SEQUENCE IF NOT EXISTS statement.

@NotNull CreateSequenceFlagsStep

DSLContext.createSequenceIfNotExists(Name sequence)

The CREATE SEQUENCE IF NOT EXISTS statement.

@NotNull CreateSequenceFlagsStep

DSLContext.createSequenceIfNotExists(Sequence<?> sequence)

The CREATE SEQUENCE IF NOT EXISTS statement.

@NotNull CreateTableColumnStep

DSLContext.createTable(String table)

Create a new DSL CREATE TABLE statement.

@NotNull CreateTableColumnStep

DSLContext.createTable(Name table)

Create a new DSL CREATE TABLE statement.

@NotNull CreateTableColumnStep

DSLContext.createTable(Table<?> table)

Create a new DSL CREATE TABLE statement.

@NotNull CreateTableColumnStep

DSLContext.createTableIfNotExists(String table)

Create a new DSL CREATE TABLE statement.

@NotNull CreateTableColumnStep

DSLContext.createTableIfNotExists(Name table)

Create a new DSL CREATE TABLE statement.

@NotNull CreateTableColumnStep

DSLContext.createTableIfNotExists(Table<?> table)

Create a new DSL CREATE TABLE statement.

@NotNull CreateTableColumnStep

DSLContext.createTemporaryTable(String table)

Create a new DSL CREATE TEMPORARY TABLE statement.

@NotNull CreateTableColumnStep

DSLContext.createTemporaryTable(Name table)

Create a new DSL CREATE TEMPORARY TABLE statement.

@NotNull CreateTableColumnStep

DSLContext.createTemporaryTable(Table<?> table)

Create a new DSL CREATE TEMPORARY TABLE statement.

@NotNull CreateTableColumnStep

DSLContext.createTemporaryTableIfNotExists(String table)

Create a new DSL CREATE TEMPORARY TABLE IF NOT EXISTS statement.

@NotNull CreateTableColumnStep

DSLContext.createTemporaryTableIfNotExists(Name table)

Create a new DSL CREATE TEMPORARY TABLE IF NOT EXISTS statement.

@NotNull CreateTableColumnStep

DSLContext.createTemporaryTableIfNotExists(Table<?> table)

Create a new DSL CREATE TEMPORARY TABLE IF NOT EXISTS statement.

@NotNull CreateTriggerEventStep

DSLContext.createTrigger(String trigger)

The CREATE TRIGGER statement.

@NotNull CreateTriggerEventStep

DSLContext.createTrigger(Name trigger)

The CREATE TRIGGER statement.

@NotNull CreateTypeStep

DSLContext.createType(String type)

Create a new DSL CREATE TYPE statement.

@NotNull CreateTypeStep

DSLContext.createType(Name type)

Create a new DSL CREATE TYPE statement.

@NotNull CreateIndexStep

DSLContext.createUniqueIndex()

The CREATE UNIQUE INDEX statement.

@NotNull CreateIndexStep

DSLContext.createUniqueIndex(String index)

The CREATE UNIQUE INDEX statement.

@NotNull CreateIndexStep

DSLContext.createUniqueIndex(Index index)

The CREATE UNIQUE INDEX statement.

@NotNull CreateIndexStep

DSLContext.createUniqueIndex(Name index)

The CREATE UNIQUE INDEX statement.

@NotNull CreateIndexStep

DSLContext.createUniqueIndexIfNotExists()

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

@NotNull CreateIndexStep

DSLContext.createUniqueIndexIfNotExists(String index)

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

@NotNull CreateIndexStep

DSLContext.createUniqueIndexIfNotExists(Index index)

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

@NotNull CreateIndexStep

DSLContext.createUniqueIndexIfNotExists(Name index)

The CREATE UNIQUE INDEX IF NOT EXISTS statement.

@NotNull CreateViewAsStep<Record>

DSLContext.createView(String view, String... fields)

Create a new DSL CREATE VIEW statement.

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

DSLContext.createView(Name view, Name... fields)

Create a new DSL CREATE VIEW statement.

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

@NotNull CreateViewAsStep<Record>

DSLContext.createViewIfNotExists(String view, String... fields)

Create a new DSL CREATE VIEW statement.

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

DSLContext.createViewIfNotExists(Name view, Name... fields)

Create a new DSL CREATE VIEW statement.

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

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

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

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

@NotNull CreateViewAsStep<Record>

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

Create a new DSL CREATE VIEW statement.

@NotNull SelectJoinStep<R>

SelectJoinStep.crossApply(String sql)

CROSS APPLY a table to this table.

@NotNull SelectJoinStep<R>

SelectJoinStep.crossApply(String sql, Object... bindings)

CROSS APPLY a table to this table.

@NotNull SelectJoinStep<R>

SelectJoinStep.crossApply(String sql, QueryPart... parts)

CROSS APPLY a table to this table.

@NotNull SelectJoinStep<R>

SelectJoinStep.crossApply(Name name)

CROSS APPLY a table to this table.

@NotNull SelectJoinStep<R>

SelectJoinStep.crossApply(SQL sql)

CROSS APPLY a table to this table.

@NotNull SelectJoinStep<R>

SelectJoinStep.crossApply(TableLike<?> table)

CROSS APPLY a table to this table.

@NotNull SelectJoinStep<R>

SelectJoinStep.crossJoin(String sql)

Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table.crossJoin(String)

@NotNull SelectJoinStep<R>

SelectJoinStep.crossJoin(String sql, Object... bindings)

Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table.crossJoin(String, Object...)

@NotNull SelectJoinStep<R>

SelectJoinStep.crossJoin(String sql, QueryPart... parts)

Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table.crossJoin(String, QueryPart...)

@NotNull SelectJoinStep<R>

SelectJoinStep.crossJoin(Name name)

Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table.crossJoin(Name)

@NotNull SelectJoinStep<R>

SelectJoinStep.crossJoin(SQL sql)

Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table.crossJoin(String)

@NotNull SelectJoinStep<R>

SelectJoinStep.crossJoin(TableLike<?> table)

Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table.crossJoin(TableLike)

@NotNull AlterSequenceFlagsStep<T>

AlterSequenceFlagsStep.cycle()

Add the CYCLE clause to the ALTER SEQUENCE statement.

@NotNull CreateSequenceFlagsStep

CreateSequenceFlagsStep.cycle()

Add the CYCLE clause to the CREATE SEQUENCE statement.

@NotNull Queries

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

Convenience method for Meta.ddl().

@NotNull Queries

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

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

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

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

DSLContext.ddl(Catalog catalog)

Convenience method for Meta.ddl().

@NotNull Queries

DSLContext.ddl(Catalog schema, DDLExportConfiguration configuration)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

DSLContext.ddl(Catalog schema, DDLFlag... flags)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

DSLContext.ddl(Schema schema)

Convenience method for Meta.ddl().

@NotNull Queries

DSLContext.ddl(Schema schema, DDLExportConfiguration configuration)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

DSLContext.ddl(Schema schema, DDLFlag... flags)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

DSLContext.ddl(Table<?> table)

Convenience method for Meta.ddl().

@NotNull Queries

DSLContext.ddl(Table<?>... tables)

Convenience method for Meta.ddl().

@NotNull Queries

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

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

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

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

DSLContext.ddl(Table<?> table, DDLExportConfiguration configuration)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

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

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull AlterTableFinalStep

AlterTableAlterStep.default_(Field<T> expression)

Specify a new column DEFAULT.

@NotNull AlterTableFinalStep

AlterTableAlterStep.default_(T literal)

Specify a new column DEFAULT.

@NotNull CreateDomainConstraintStep

CreateDomainDefaultStep.default_(Field<T> default_)

Add the DEFAULT_ clause to the CREATE DOMAIN statement.

@NotNull CreateDomainConstraintStep

CreateDomainDefaultStep.default_(T default_)

Add the DEFAULT_ clause to the CREATE DOMAIN statement.

@NotNull AlterTableFinalStep

AlterTableAlterStep.defaultValue(Field<T> expression)

Specify a new column DEFAULT.

@NotNull AlterTableFinalStep

AlterTableAlterStep.defaultValue(T literal)

Specify a new column DEFAULT.

@NotNull InsertOnDuplicateStep<R>

InsertSetStep.defaultValues()

Add an empty record with default values.

<R extends Record>
@NotNull DeleteUsingStep<R>

DSLContext.delete(Table<R> table)

Create a new DSL delete statement.

<R extends Record>
@NotNull DeleteUsingStep<R>

WithStep.delete(Table<R> table)

Create a new DSL delete statement.

<R extends Record>
@NotNull DeleteUsingStep<R>

DSLContext.deleteFrom(Table<R> table)

Create a new DSL delete statement.

<R extends Record>
@NotNull DeleteQuery<R>

DSLContext.deleteQuery(Table<R> table)

Create a new DeleteQuery

@NotNull MergeMatchedStep<R>

MergeMatchedDeleteStep.deleteWhere(Condition condition)

Add an additional DELETE WHERE clause to the preceding WHEN MATCHED THEN UPDATE clause.

@NotNull MergeMatchedStep<R>

MergeMatchedDeleteStep.deleteWhere(Field<Boolean> condition)

Add an additional DELETE WHERE clause to the preceding WHEN MATCHED THEN UPDATE clause.

@NotNull CreateFunctionCharacteristicsStep

CreateFunctionCharacteristicsStep.deterministic()

Add the DETERMINISTIC clause to the CREATE FUNCTION statement.

@NotNull SelectIntoStep<R>

SelectDistinctOnStep.distinctOn(Collection<? extends SelectFieldOrAsterisk> fields)

Add the PostgreSQL-specific ON(…) clause to a SELECT DISTINCT ON (…) statement.

@NotNull SelectIntoStep<R>

SelectDistinctOnStep.distinctOn(SelectFieldOrAsterisk... fields)

Add the PostgreSQL-specific ON(…) clause to a SELECT DISTINCT ON (…) statement.

@NotNull InsertReturningStep<R>

InsertOnConflictDoUpdateStep.doNothing()

Add the DO NOTHING clause.

@NotNull InsertOnDuplicateSetStep<R>

InsertOnConflictDoUpdateStep.doUpdate()

Add the DO UPDATE clause.

@NotNull AlterTableDropStep

AlterTableStep.drop(String field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.drop(String... fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.drop(Collection<? extends Field<?>> fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.drop(Constraint constraint)

Add a DROP CONSTRAINT clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.drop(Field<?> field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.drop(Field<?>... fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.drop(Name field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.drop(Name... fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropColumn(String field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropColumn(Field<?> field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropColumn(Name field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropColumnIfExists(String field)

Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropColumnIfExists(Field<?> field)

Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropColumnIfExists(Name field)

Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropColumns(String... fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropColumns(Collection<? extends Field<?>> fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropColumns(Field<?>... fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropColumns(Name... fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

@NotNull AlterDomainDropConstraintCascadeStep

AlterDomainStep.dropConstraint(String dropConstraint)

Add the DROP CONSTRAINT clause to the ALTER DOMAIN statement.

@NotNull AlterDomainDropConstraintCascadeStep

AlterDomainStep.dropConstraint(Constraint dropConstraint)

Add the DROP CONSTRAINT clause to the ALTER DOMAIN statement.

@NotNull AlterDomainDropConstraintCascadeStep

AlterDomainStep.dropConstraint(Name dropConstraint)

Add the DROP CONSTRAINT clause to the ALTER DOMAIN statement.

@NotNull AlterTableDropStep

AlterTableStep.dropConstraint(String constraint)

Add a DROP CONSTRAINT clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropConstraint(Constraint constraint)

Add a DROP CONSTRAINT clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropConstraint(Name constraint)

Add a DROP CONSTRAINT clause to the ALTER TABLE statement.

@NotNull AlterDomainDropConstraintCascadeStep

AlterDomainStep.dropConstraintIfExists(String dropConstraint)

Add the DROP CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.

@NotNull AlterDomainDropConstraintCascadeStep

AlterDomainStep.dropConstraintIfExists(Constraint dropConstraint)

Add the DROP CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.

@NotNull AlterDomainDropConstraintCascadeStep

AlterDomainStep.dropConstraintIfExists(Name dropConstraint)

Add the DROP CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.

@NotNull AlterTableDropStep

AlterTableStep.dropConstraintIfExists(String constraint)

Add a DROP CONSTRAINT IF EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropConstraintIfExists(Constraint constraint)

Add a DROP CONSTRAINT IF EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropConstraintIfExists(Name constraint)

Add a DROP CONSTRAINT IF EXISTS clause to the ALTER TABLE statement.

@NotNull DropDatabaseFinalStep

DSLContext.dropDatabase(String database)

The DROP DATABASE statement.

@NotNull DropDatabaseFinalStep

DSLContext.dropDatabase(Catalog database)

The DROP DATABASE statement.

@NotNull DropDatabaseFinalStep

DSLContext.dropDatabase(Name database)

The DROP DATABASE statement.

@NotNull DropDatabaseFinalStep

DSLContext.dropDatabaseIfExists(String database)

The DROP DATABASE IF EXISTS statement.

@NotNull DropDatabaseFinalStep

DSLContext.dropDatabaseIfExists(Catalog database)

The DROP DATABASE IF EXISTS statement.

@NotNull DropDatabaseFinalStep

DSLContext.dropDatabaseIfExists(Name database)

The DROP DATABASE IF EXISTS statement.

@NotNull AlterDomainFinalStep

AlterDomainStep.dropDefault()

Add the DROP DEFAULT clause to the ALTER DOMAIN statement.

@NotNull AlterTableFinalStep

AlterTableAlterStep.dropDefault()

Drop the column DEFAULT.

@NotNull DropDomainCascadeStep

DSLContext.dropDomain(String domain)

The DROP DOMAIN statement.

@NotNull DropDomainCascadeStep

DSLContext.dropDomain(Domain<?> domain)

The DROP DOMAIN statement.

@NotNull DropDomainCascadeStep

DSLContext.dropDomain(Name domain)

The DROP DOMAIN statement.

@NotNull DropDomainCascadeStep

DSLContext.dropDomainIfExists(String domain)

The DROP DOMAIN IF EXISTS statement.

@NotNull DropDomainCascadeStep

DSLContext.dropDomainIfExists(Domain<?> domain)

The DROP DOMAIN IF EXISTS statement.

@NotNull DropDomainCascadeStep

DSLContext.dropDomainIfExists(Name domain)

The DROP DOMAIN IF EXISTS statement.

@NotNull AlterTableDropStep

AlterTableStep.dropForeignKey(String constraint)

Add a DROP FOREIGN KEY clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropForeignKey(Constraint constraint)

Add a DROP FOREIGN KEY clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropForeignKey(Name constraint)

Add a DROP FOREIGN KEY clause to the ALTER TABLE statement.

@NotNull DDLQuery

DSLContext.dropFunction(String function)

The DROP FUNCTION statement.

@NotNull DDLQuery

DSLContext.dropFunction(Name function)

The DROP FUNCTION statement.

@NotNull DDLQuery

DSLContext.dropFunctionIfExists(String function)

The DROP FUNCTION IF EXISTS statement.

@NotNull DDLQuery

DSLContext.dropFunctionIfExists(Name function)

The DROP FUNCTION IF EXISTS statement.

@NotNull AlterTableDropStep

AlterTableStep.dropIfExists(String field)

Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropIfExists(Constraint constraint)

Add a DROP CONSTRAINT IF EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropIfExists(Field<?> field)

Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropIfExists(Name field)

Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.

@NotNull DropIndexOnStep

DSLContext.dropIndex(String index)

The DROP INDEX statement.

@NotNull DropIndexOnStep

DSLContext.dropIndex(Index index)

The DROP INDEX statement.

@NotNull DropIndexOnStep

DSLContext.dropIndex(Name index)

The DROP INDEX statement.

@NotNull DropIndexOnStep

DSLContext.dropIndexIfExists(String index)

The DROP INDEX IF EXISTS statement.

@NotNull DropIndexOnStep

DSLContext.dropIndexIfExists(Index index)

The DROP INDEX IF EXISTS statement.

@NotNull DropIndexOnStep

DSLContext.dropIndexIfExists(Name index)

The DROP INDEX IF EXISTS statement.

@NotNull AlterDomainFinalStep

AlterDomainStep.dropNotNull()

Add the DROP NOT NULL clause to the ALTER DOMAIN statement.

@NotNull AlterTableFinalStep

AlterTableAlterStep.dropNotNull()

Make the column nullable.

@NotNull AlterTableDropStep

AlterTableStep.dropPrimaryKey()

Add a DROP PRIMARY KEY clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropPrimaryKey(String constraint)

Add a DROP PRIMARY KEY clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropPrimaryKey(Constraint constraint)

Add a DROP PRIMARY KEY clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropPrimaryKey(Name constraint)

Add a DROP PRIMARY KEY clause to the ALTER TABLE statement.

@NotNull DDLQuery

DSLContext.dropProcedure(String procedure)

The DROP PROCEDURE statement.

@NotNull DDLQuery

DSLContext.dropProcedure(Name procedure)

The DROP PROCEDURE statement.

@NotNull DDLQuery

DSLContext.dropProcedureIfExists(String procedure)

The DROP PROCEDURE IF EXISTS statement.

@NotNull DDLQuery

DSLContext.dropProcedureIfExists(Name procedure)

The DROP PROCEDURE IF EXISTS statement.

@NotNull DropSchemaStep

DSLContext.dropSchema(String schema)

The DROP SCHEMA statement.

@NotNull DropSchemaStep

DSLContext.dropSchema(Name schema)

The DROP SCHEMA statement.

@NotNull DropSchemaStep

DSLContext.dropSchema(Schema schema)

The DROP SCHEMA statement.

@NotNull DropSchemaStep

DSLContext.dropSchemaIfExists(String schema)

The DROP SCHEMA IF EXISTS statement.

@NotNull DropSchemaStep

DSLContext.dropSchemaIfExists(Name schema)

The DROP SCHEMA IF EXISTS statement.

@NotNull DropSchemaStep

DSLContext.dropSchemaIfExists(Schema schema)

The DROP SCHEMA IF EXISTS statement.

@NotNull DropSequenceFinalStep

DSLContext.dropSequence(String sequence)

The DROP SEQUENCE statement.

@NotNull DropSequenceFinalStep

DSLContext.dropSequence(Name sequence)

The DROP SEQUENCE statement.

@NotNull DropSequenceFinalStep

DSLContext.dropSequence(Sequence<?> sequence)

The DROP SEQUENCE statement.

@NotNull DropSequenceFinalStep

DSLContext.dropSequenceIfExists(String sequence)

The DROP SEQUENCE IF EXISTS statement.

@NotNull DropSequenceFinalStep

DSLContext.dropSequenceIfExists(Name sequence)

The DROP SEQUENCE IF EXISTS statement.

@NotNull DropSequenceFinalStep

DSLContext.dropSequenceIfExists(Sequence<?> sequence)

The DROP SEQUENCE IF EXISTS statement.

@NotNull DropTableStep

DSLContext.dropTable(String table)

The DROP TABLE statement.

@NotNull DropTableStep

DSLContext.dropTable(Name table)

The DROP TABLE statement.

@NotNull DropTableStep

DSLContext.dropTable(Table<?> table)

The DROP TABLE statement.

@NotNull DropTableStep

DSLContext.dropTableIfExists(String table)

The DROP TABLE IF EXISTS statement.

@NotNull DropTableStep

DSLContext.dropTableIfExists(Name table)

The DROP TABLE IF EXISTS statement.

@NotNull DropTableStep

DSLContext.dropTableIfExists(Table<?> table)

The DROP TABLE IF EXISTS statement.

@NotNull DropTableStep

DSLContext.dropTemporaryTable(String table)

The DROP TEMPORARY TABLE statement.

@NotNull DropTableStep

DSLContext.dropTemporaryTable(Name table)

The DROP TEMPORARY TABLE statement.

@NotNull DropTableStep

DSLContext.dropTemporaryTable(Table<?> table)

The DROP TEMPORARY TABLE statement.

@NotNull DropTableStep

DSLContext.dropTemporaryTableIfExists(String table)

The DROP TEMPORARY TABLE IF EXISTS statement.

@NotNull DropTableStep

DSLContext.dropTemporaryTableIfExists(Name table)

The DROP TEMPORARY TABLE IF EXISTS statement.

@NotNull DropTableStep

DSLContext.dropTemporaryTableIfExists(Table<?> table)

The DROP TEMPORARY TABLE IF EXISTS statement.

@NotNull DDLQuery

DSLContext.dropTrigger(String trigger)

The DROP TRIGGER statement.

@NotNull DDLQuery

DSLContext.dropTrigger(Name trigger)

The DROP TRIGGER statement.

@NotNull DDLQuery

DSLContext.dropTriggerIfExists(String trigger)

The DROP TRIGGER IF EXISTS statement.

@NotNull DDLQuery

DSLContext.dropTriggerIfExists(Name trigger)

The DROP TRIGGER IF EXISTS statement.

@NotNull DropTypeStep

DSLContext.dropType(String type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

DSLContext.dropType(String... type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

DSLContext.dropType(Collection<?> type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

DSLContext.dropType(Name type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

DSLContext.dropType(Name... type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

DSLContext.dropTypeIfExists(String type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

DSLContext.dropTypeIfExists(String... type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

DSLContext.dropTypeIfExists(Collection<?> type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

DSLContext.dropTypeIfExists(Name type)

Create a new DSL DROP TYPE statement.

@NotNull DropTypeStep

DSLContext.dropTypeIfExists(Name... type)

Create a new DSL DROP TYPE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropUnique(String constraint)

Add a DROP UNIQUE clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropUnique(Constraint constraint)

Add a DROP UNIQUE clause to the ALTER TABLE statement.

@NotNull AlterTableDropStep

AlterTableStep.dropUnique(Name constraint)

Add a DROP UNIQUE clause to the ALTER TABLE statement.

@NotNull DropViewFinalStep

DSLContext.dropView(String view)

The DROP VIEW statement.

@NotNull DropViewFinalStep

DSLContext.dropView(Name view)

The DROP VIEW statement.

@NotNull DropViewFinalStep

DSLContext.dropView(Table<?> view)

The DROP VIEW statement.

@NotNull DropViewFinalStep

DSLContext.dropViewIfExists(String view)

The DROP VIEW IF EXISTS statement.

@NotNull DropViewFinalStep

DSLContext.dropViewIfExists(Name view)

The DROP VIEW IF EXISTS statement.

@NotNull DropViewFinalStep

DSLContext.dropViewIfExists(Table<?> view)

The DROP VIEW IF EXISTS statement.

@NotNull SelectForXMLCommonDirectivesStep<R>

SelectForXMLPathDirectivesStep.elements()

Add a SQL Server-style FOR XML PATH, ELEMENTS clause.

@NotNull SelectForXMLCommonDirectivesStep<R>

SelectForXMLRawDirectivesStep.elements()

Add a SQL Server-style FOR XML RAW, ELEMENTS clause.

@NotNull SelectForXMLCommonDirectivesStep<R>

SelectForXMLPathDirectivesStep.elementsAbsent()

Add a SQL Server-style FOR XML PATH, ELEMENTS ABSENT clause.

@NotNull SelectForXMLCommonDirectivesStep<R>

SelectForXMLRawDirectivesStep.elementsAbsent()

Add a SQL Server-style FOR XML PATH, ELEMENTS ABSENT clause.

@NotNull SelectForXMLCommonDirectivesStep<R>

SelectForXMLPathDirectivesStep.elementsXsinil()

Add a SQL Server-style FOR XML PATH, ELEMENTS XSINIL clause.

@NotNull SelectForXMLCommonDirectivesStep<R>

SelectForXMLRawDirectivesStep.elementsXsinil()

Add a SQL Server-style FOR XML PATH, ELEMENTS XSINIL clause.

@NotNull AlterTableFinalStep

AlterTableAlterConstraintStep.enforced()

Add the ENFORCED clause to the constraint.

@NotNull Condition

SelectCorrelatedSubqueryStep.eq(QuantifiedSelect<? extends R> select)

Compare this subquery with a quanitified subquery for equality.

@NotNull Condition

SelectCorrelatedSubqueryStep.eq(Select<? extends R> select)

Compare this subquery with another record for equality.

@NotNull Condition

SelectCorrelatedSubqueryStep.eq(R record)

Compare this subquery with a record for equality.

@NotNull Condition

SelectCorrelatedSubqueryStep.equal(QuantifiedSelect<? extends R> select)

Compare this subquery with a quanitified subquery for equality.

@NotNull Condition

SelectCorrelatedSubqueryStep.equal(Select<? extends R> select)

Compare this subquery with another record for equality.

@NotNull Condition

SelectCorrelatedSubqueryStep.equal(R record)

Compare this subquery with a record for equality.

@NotNull List<LoaderError>

Loader.errors()

A list of errors that might have happened during the load.

@NotNull List<LoaderError>

LoaderContext.errors()

A list of errors that might have happened during the load.

@NotNull Condition

LikeEscapeStep.escape(char escape)

Add the ESCAPE clause to the LIKE function.

@NotNull Select<R>

Select.except(Select<? extends R> select)

Apply the EXCEPT (or MINUS) set operation.

@NotNull SelectOrderByStep<R>

SelectUnionStep.except(Select<? extends R> select)

Apply the EXCEPT (or MINUS) set operation.

@NotNull Select<R>

Select.exceptAll(Select<? extends R> select)

Apply the EXCEPT ALL set operation.

@NotNull SelectOrderByStep<R>

SelectUnionStep.exceptAll(Select<? extends R> select)

Apply the EXCEPT ALL set operation.

@NotNull CreateIndexFinalStep

CreateIndexWhereStep.excludeNullKeys()

Add the EXCLUDE NULL KEYS clause to the CREATE INDEX statement.

@NotNull Result<Record>

DSLContext.fetch(SQL sql)

Execute a new query holding plain SQL.

@NotNull LoaderCSVOptionsStep<R>

LoaderCSVStep.fields(Collection<? extends Field<?>> fields)

Specify the the fields to be loaded into the table in the correct order.

@NotNull LoaderCSVOptionsStep<R>

LoaderCSVStep.fields(Field<?>... fields)

Specify the the fields to be loaded into the table in the correct order.

@NotNull LoaderCSVOptionsStep<R>

LoaderCSVStep.fields(LoaderFieldMapper mapper)

Specify a function to apply on each input field to receive the target table's field.

@NotNull LoaderJSONOptionsStep<R>

LoaderJSONStep.fields(Collection<? extends Field<?>> fields)

Specify the fields to be loaded into the table in the correct order.

@NotNull LoaderJSONOptionsStep<R>

LoaderJSONStep.fields(Field<?>... fields)

Specify the fields to be loaded into the table in the correct order.

@NotNull LoaderJSONOptionsStep<R>

LoaderJSONStep.fields(LoaderFieldMapper mapper)

Specify a function to apply on each input field to receive the target table's field.

@NotNull LoaderListenerStep<R>

LoaderRowsStep.fields(Collection<? extends Field<?>> fields)

Specify the the fields to be loaded into the table in the correct order.

@NotNull LoaderListenerStep<R>

LoaderRowsStep.fields(Field<?>... fields)

Specify the the fields to be loaded into the table in the correct order.

@NotNull LoaderListenerStep<R>

LoaderRowsStep.fields(LoaderFieldMapper mapper)

Specify a function to apply on each input field to receive the target table's field.

@NotNull LoaderCSVOptionsStep<R>

LoaderCSVStep.fieldsCorresponding()

Indicate that all input fields which have a corresponding field in the target table (with the same name) should be loaded.

@NotNull LoaderCSVOptionsStep<R>

LoaderJSONStep.fieldsCorresponding()

Indicate that all input fields which have a corresponding field in the target table (with the same name) should be loaded.

@NotNull LoaderCSVOptionsStep<R>

LoaderRowsStep.fieldsCorresponding()

Indicate that all input fields which have a corresponding field in the target table (with the same name) should be loaded.

@NotNull LoaderCSVOptionsStep<R>

LoaderCSVStep.fieldsFromSource()

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

- 3.14.0 - [#10010] - Use LoaderCSVStep.fieldsCorresponding() instead.

@NotNull LoaderCSVOptionsStep<R>

LoaderJSONStep.fieldsFromSource()

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

- 3.14.0 - [#10010] - Use LoaderJSONStep.fieldsCorresponding() instead.

@NotNull LoaderCSVOptionsStep<R>

LoaderRowsStep.fieldsFromSource()

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

- 3.14.0 - [#10010] - Use LoaderRowsStep.fieldsCorresponding() instead.

@NotNull AlterTableFinalStep

AlterTableAddStep.first()

Add a FIRST clause to ALTER TABLE … ADD ….

@NotNull CreateTriggerWhenStep

CreateTriggerForStep.forEachRow()

Add the FOR EACH ROW clause to the CREATE TRIGGER statement.

@NotNull CreateTriggerWhenStep

CreateTriggerForStep.forEachStatement()

Add the FOR EACH STATEMENT clause to the CREATE TRIGGER statement.

@NotNull SelectForJSONStep<Record1<JSON>>

SelectForStep.forJSON()

Add a SQL Server-style FOR JSON clause.

@NotNull SelectForJSONStep<Record1<JSONB>>

SelectForStep.forJSONB()

Add a SQL Server-style FOR JSON clause.

@NotNull SelectForUpdateOfStep<R>

SelectForUpdateStep.forKeyShare()

Add a FOR KEY SHARE clause to the end of the query.

@NotNull SelectForUpdateOfStep<R>

SelectForUpdateStep.forNoKeyUpdate()

Add a FOR NO KEY UPDATE clause to the end of the query.

@NotNull SelectForUpdateOfStep<R>

SelectForUpdateStep.forShare()

Add a FOR SHARE clause to the end of the query.

@NotNull SelectForUpdateOfStep<R>

SelectForUpdateStep.forUpdate()

Add a FOR UPDATE clause to the end of the query.

@NotNull SelectForXMLStep<Record1<XML>>

SelectForStep.forXML()

Add a SQL Server-style FOR XML clause.

@NotNull RevokeFinalStep

RevokeFromStep.from(Role from)

Add the FROM clause to the REVOKE statement.

@NotNull RevokeFinalStep

RevokeFromStep.from(User from)

Add the FROM clause to the REVOKE statement.

@NotNull SelectJoinStep<R>

SelectFromStep.from(String sql)

Add a FROM clause to the query.

@NotNull SelectJoinStep<R>

SelectFromStep.from(String sql, Object... bindings)

Add a FROM clause to the query.

@NotNull SelectJoinStep<R>

SelectFromStep.from(String sql, QueryPart... parts)

Add a FROM clause to the query.

@NotNull SelectJoinStep<R>

SelectFromStep.from(Collection<? extends TableLike<?>> tables)

Add a FROM clause to the query.

@NotNull SelectJoinStep<R>

SelectFromStep.from(Name name)

Add a FROM clause to the query.

@NotNull SelectJoinStep<R>

SelectFromStep.from(SQL sql)

Add a FROM clause to the query.

@NotNull SelectJoinStep<R>

SelectFromStep.from(TableLike<?> table)

Add a FROM clause to the query.

@NotNull SelectJoinStep<R>

SelectFromStep.from(TableLike<?>... tables)

Add a FROM clause to the query.

@NotNull UpdateWhereStep<R>

UpdateFromStep.from(String sql)

Add a FROM clause to the query.

@NotNull UpdateWhereStep<R>

UpdateFromStep.from(String sql, Object... bindings)

Add a FROM clause to the query.

@NotNull UpdateWhereStep<R>

UpdateFromStep.from(String sql, QueryPart... parts)

Add a FROM clause to the query.

@NotNull UpdateWhereStep<R>

UpdateFromStep.from(Collection<? extends TableLike<?>> tables)

Add a FROM clause to the query.

@NotNull UpdateWhereStep<R>

UpdateFromStep.from(Name name)

Add a FROM clause to the query.

@NotNull UpdateWhereStep<R>

UpdateFromStep.from(SQL sql)

Add a FROM clause to the query.

@NotNull UpdateWhereStep<R>

UpdateFromStep.from(TableLike<?> table)

Add a FROM clause to the query.

@NotNull UpdateWhereStep<R>

UpdateFromStep.from(TableLike<?>... table)

Add a FROM clause to the query.

@NotNull RevokeFinalStep

RevokeFromStep.fromPublic()

Add the FROM PUBLIC clause to the REVOKE statement.

@NotNull SelectOnStep<R>

SelectJoinStep.fullJoin(String sql)

Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table.fullOuterJoin(String).

@NotNull SelectOnStep<R>

SelectJoinStep.fullJoin(String sql, Object... bindings)

Convenience method to FULL OUTER JOIN a tableto the last table added to the FROM clause using Table.fullOuterJoin(String, Object...).

@NotNull SelectOnStep<R>

SelectJoinStep.fullJoin(String sql, QueryPart... parts)

Convenience method to FULL OUTER JOIN a tableto the last table added to the FROM clause using Table.fullOuterJoin(String, QueryPart...).

@NotNull SelectOnStep<R>

SelectJoinStep.fullJoin(Name name)

Convenience method to FULL OUTER JOIN a tableto the last table added to the FROM clause using Table.fullOuterJoin(Name).

@NotNull SelectOnStep<R>

SelectJoinStep.fullJoin(SQL sql)

Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table.fullOuterJoin(String).

@NotNull SelectOnStep<R>

SelectJoinStep.fullJoin(TableLike<?> table)

Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table.fullOuterJoin(TableLike).

@NotNull SelectOnStep<R>

SelectJoinStep.fullOuterJoin(String sql)

Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table.fullOuterJoin(String)

@NotNull SelectOnStep<R>

SelectJoinStep.fullOuterJoin(String sql, Object... bindings)

Convenience method to FULL OUTER JOIN a tableto the last table added to the FROM clause using Table.fullOuterJoin(String, Object...)

@NotNull SelectOnStep<R>

SelectJoinStep.fullOuterJoin(String sql, QueryPart... parts)

Convenience method to FULL OUTER JOIN a tableto the last table added to the FROM clause using Table.fullOuterJoin(String, QueryPart...)

@NotNull SelectOnStep<R>

SelectJoinStep.fullOuterJoin(Name name)

Convenience method to FULL OUTER JOIN a tableto the last table added to the FROM clause using Table.fullOuterJoin(Name)

@NotNull SelectOnStep<R>

SelectJoinStep.fullOuterJoin(SQL sql)

Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table.fullOuterJoin(String)

@NotNull SelectOnStep<R>

SelectJoinStep.fullOuterJoin(TableLike<?> table)

Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table.fullOuterJoin(TableLike)

@NotNull Condition

SelectCorrelatedSubqueryStep.ge(QuantifiedSelect<? extends R> select)

Compare this subquery with a quanitified subquery for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.ge(Select<? extends R> select)

Compare this subquery with another record for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.ge(R record)

Compare this subquery with a record for order.

@NotNull SelectQuery<R>

SelectFinalStep.getQuery()

Get the underlying Query that is being constructed.

@NotNull List<Field<?>>

Select.getSelect()

All fields selected in this query

@NotNull GrantOnStep

DSLContext.grant(Collection<? extends Privilege> privileges)

The GRANT statement.

@NotNull GrantOnStep

DSLContext.grant(Privilege privileges)

The GRANT statement.

@NotNull GrantOnStep

DSLContext.grant(Privilege... privileges)

The GRANT statement.

@NotNull Condition

SelectCorrelatedSubqueryStep.greaterOrEqual(QuantifiedSelect<? extends R> select)

Compare this subquery with a quanitified subquery for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.greaterOrEqual(Select<? extends R> select)

Compare this subquery with another record for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.greaterOrEqual(R record)

Compare this subquery with a record for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.greaterThan(QuantifiedSelect<? extends R> select)

Compare this subquery with a quanitified subquery for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.greaterThan(Select<? extends R> select)

Compare this subquery with another record for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.greaterThan(R record)

Compare this subquery with a record for order.

@NotNull SelectHavingStep<R>

SelectGroupByStep.groupBy(Collection<? extends GroupField> fields)

Add a GROUP BY clause to the query

@NotNull SelectHavingStep<R>

SelectGroupByStep.groupBy(GroupField... fields)

Add a GROUP BY clause to the query

@NotNull SelectHavingStep<R>

SelectGroupByStep.groupByDistinct(Collection<? extends GroupField> fields)

Add a GROUP BY DISTINCT clause to the query

@NotNull SelectHavingStep<R>

SelectGroupByStep.groupByDistinct(GroupField... fields)

Add a GROUP BY DISTINCT clause to the query

@NotNull Condition

SelectCorrelatedSubqueryStep.gt(QuantifiedSelect<? extends R> select)

Compare this subquery with a quanitified subquery for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.gt(Select<? extends R> select)

Compare this subquery with another record for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.gt(R record)

Compare this subquery with a record for order.

@NotNull SelectHavingConditionStep<R>

SelectHavingStep.having(String sql)

Add a HAVING clause to the query.

@NotNull SelectHavingConditionStep<R>

SelectHavingStep.having(String sql, Object... bindings)

Add a HAVING clause to the query.

@NotNull SelectHavingConditionStep<R>

SelectHavingStep.having(String sql, QueryPart... parts)

Add a HAVING clause to the query.

@NotNull SelectHavingConditionStep<R>

SelectHavingStep.having(Collection<? extends Condition> conditions)

Add a HAVING clause to the query, connecting them with each other with Operator.AND.

@NotNull SelectHavingConditionStep<R>

SelectHavingStep.having(Condition condition)

Add a HAVING clause to the query, connecting them with each other with Operator.AND.

@NotNull SelectHavingConditionStep<R>

SelectHavingStep.having(Condition... conditions)

Add a HAVING clause to the query, connecting them with each other with Operator.AND.

@NotNull SelectHavingConditionStep<R>

SelectHavingStep.having(Field<Boolean> condition)

Add a HAVING clause to the query.

@NotNull SelectHavingConditionStep<R>

SelectHavingStep.having(SQL sql)

Add a HAVING clause to the query.

@NotNull SelectFromStep<R>

SelectFromStep.hint(String hint)

Add an Oracle-style hint to the preceding select clause.

@NotNull LoaderCSVOptionsStep<R>

LoaderCSVOptionsStep.ignoreRows(int number)

Specify that a certain number of rows should be ignored from the CSV file.

@NotNull LoaderJSONOptionsStep<R>

LoaderJSONOptionsStep.ignoreRows(int number)

Deprecated.

- [#4859] - This is not supported for JSON loading.

@NotNull Condition

SelectCorrelatedSubqueryStep.in(Select<? extends R> select)

Compare this subquery with another subquery for equality.

@NotNull Condition

SelectCorrelatedSubqueryStep.in(R... records)

Compare this subquery with a set of records for equality.

@NotNull CreateIndexWhereStep

CreateIndexIncludeStep.include(String... include)

Add the INCLUDE clause to the CREATE INDEX statement.

@NotNull CreateIndexWhereStep

CreateIndexIncludeStep.include(Collection<? extends Field<?>> include)

Add the INCLUDE clause to the CREATE INDEX statement.

@NotNull CreateIndexWhereStep

CreateIndexIncludeStep.include(Field<?>... include)

Add the INCLUDE clause to the CREATE INDEX statement.

@NotNull CreateIndexWhereStep

CreateIndexIncludeStep.include(Name... include)

Add the INCLUDE clause to the CREATE INDEX statement.

@NotNull SelectForJSONCommonDirectivesStep<R>

SelectForJSONCommonDirectivesStep.includeNullValues()

Add a SQL Server-style FOR JSON …, INCLUDE_NULL_VALUES clause.

@NotNull AlterSequenceFlagsStep<T>

AlterSequenceFlagsStep.incrementBy(Field<T> incrementBy)

Add the INCREMENT BY clause to the ALTER SEQUENCE statement.

@NotNull AlterSequenceFlagsStep<T>

AlterSequenceFlagsStep.incrementBy(T incrementBy)

Add the INCREMENT BY clause to the ALTER SEQUENCE statement.

@NotNull CreateSequenceFlagsStep

CreateSequenceFlagsStep.incrementBy(Number incrementBy)

Add the INCREMENT BY clause to the CREATE SEQUENCE statement.

@NotNull CreateSequenceFlagsStep

CreateSequenceFlagsStep.incrementBy(Field<? extends Number> incrementBy)

Add the INCREMENT BY clause to the CREATE SEQUENCE statement.

@NotNull CreateTableIndexStep

CreateTableIndexStep.index(Index index)

Add an index to the table.

@NotNull CreateTableIndexStep

CreateTableIndexStep.indexes(Collection<? extends Index> indexes)

Add indexes to the table.

@NotNull CreateTableIndexStep

CreateTableIndexStep.indexes(Index... indexes)

Add indexes to the table.

@NotNull SelectOnStep<R>

SelectJoinStep.innerJoin(String sql)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String).

@NotNull SelectOnStep<R>

SelectJoinStep.innerJoin(String sql, Object... bindings)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String, Object...).

@NotNull SelectOnStep<R>

SelectJoinStep.innerJoin(String sql, QueryPart... parts)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String, QueryPart...).

@NotNull SelectOnStep<R>

SelectJoinStep.innerJoin(Name name)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(Name).

@NotNull SelectOnStep<R>

SelectJoinStep.innerJoin(SQL sql)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String).

@NotNull SelectOnStep<R>

SelectJoinStep.innerJoin(TableLike<?> table)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(TableLike).

<R extends Record>
@NotNull InsertSetStep<R>

DSLContext.insertInto(Table<R> into)

Create a new DSL insert statement.

<R extends Record>
@NotNull InsertValuesStepN<R>

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

Create a new DSL insert statement.

<R extends Record>
@NotNull InsertValuesStepN<R>

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

<R extends Record>
@NotNull InsertSetStep<R>

WithStep.insertInto(Table<R> into)

Create a new DSL insert statement.

<R extends Record>
@NotNull InsertValuesStepN<R>

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

Create a new DSL insert statement.

<R extends Record>
@NotNull InsertValuesStepN<R>

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

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

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

Create a new DSL insert statement.

<R extends Record>
@NotNull InsertQuery<R>

DSLContext.insertQuery(Table<R> into)

Create a new InsertQuery

@NotNull CreateTriggerEventOrStep

CreateTriggerEventStep.insteadOfDelete()

Add the INSTEAD OF DELETE clause to the CREATE TRIGGER statement.

@NotNull CreateTriggerEventOrStep

CreateTriggerEventStep.insteadOfInsert()

Add the INSTEAD OF INSERT clause to the CREATE TRIGGER statement.

@NotNull CreateTriggerEventOfStep

CreateTriggerEventStep.insteadOfUpdate()

Add the INSTEAD OF UPDATE clause to the CREATE TRIGGER statement.

@NotNull Select<R>

Select.intersect(Select<? extends R> select)

Apply the INTERSECT set operation.

@NotNull SelectOrderByStep<R>

SelectUnionStep.intersect(Select<? extends R> select)

Apply the INTERSECT set operation.

@NotNull Select<R>

Select.intersectAll(Select<? extends R> select)

Apply the INTERSECT ALL set operation.

@NotNull SelectOrderByStep<R>

SelectUnionStep.intersectAll(Select<? extends R> select)

Apply the INTERSECT ALL set operation.

@NotNull SelectFromStep<R>

SelectIntoStep.into(Collection<? extends Variable<?>> variables)

Add a PL/SQL style INTO clause to the SELECT statement to assign the projection of a single row SELECT statement to local variables in a procedural context.

@NotNull SelectFromStep<Record>

SelectIntoStep.into(Table<?> table)

Add a T-SQL style INTO clause to the SELECT statement to create a new table from a SELECT statement.

@NotNull SelectFromStep<R>

SelectIntoStep.into(Variable<?>... variables)

Add a PL/SQL style INTO clause to the SELECT statement to assign the projection of a single row SELECT statement to local variables in a procedural context.

@NotNull CommentOnFinalStep

CommentOnIsStep.is(String comment)

Add the IS clause to the COMMENT ON TABLE statement.

@NotNull CommentOnFinalStep

CommentOnIsStep.is(Comment comment)

Add the IS clause to the COMMENT ON TABLE statement.

@NotNull Condition

SelectCorrelatedSubqueryStep.isDistinctFrom(QuantifiedSelect<? extends R> select)

Compare this subquery with another record for distinctness.

@NotNull Condition

SelectCorrelatedSubqueryStep.isDistinctFrom(Select<? extends R> select)

Compare this subquery with another record for distinctness.

@NotNull Condition

SelectCorrelatedSubqueryStep.isDistinctFrom(R record)

Compare this subquery with another record for distinctness.

@NotNull Condition

SelectCorrelatedSubqueryStep.isNotDistinctFrom(QuantifiedSelect<? extends R> select)

Compare this subquery with another record for distinctness.

@NotNull Condition

SelectCorrelatedSubqueryStep.isNotDistinctFrom(Select<? extends R> select)

Compare this subquery with another record for distinctness.

@NotNull Condition

SelectCorrelatedSubqueryStep.isNotDistinctFrom(R record)

Compare this subquery with another record for distinctness.

@NotNull Condition

SelectCorrelatedSubqueryStep.isNotNull()

Check if the result of this subquery IS NOT NULL

@NotNull Condition

SelectCorrelatedSubqueryStep.isNull()

Check if the result of this subquery IS NULL

@NotNull SelectOnStep<R>

SelectJoinStep.join(String sql)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String).

@NotNull SelectOnStep<R>

SelectJoinStep.join(String sql, Object... bindings)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String, Object...).

@NotNull SelectOnStep<R>

SelectJoinStep.join(String sql, QueryPart... parts)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String, QueryPart...).

@NotNull SelectOnStep<R>

SelectJoinStep.join(Name name)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(Name).

@NotNull SelectOnStep<R>

SelectJoinStep.join(SQL sql)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String).

@NotNull SelectOnStep<R>

SelectJoinStep.join(TableLike<?> table)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(TableLike).

@NotNull SelectOptionalOnStep<R>

SelectJoinStep.join(TableLike<?> table, JoinType type)

Convenience method to join a table to the last table added to the FROM clause using Table.join(TableLike, JoinType)

@NotNull MergeValuesStep1<R,T1>

MergeKeyStep1.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

@NotNull MergeValuesStep1<R,T1>

MergeKeyStep1.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep10.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep10.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep11.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep11.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep12.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep12.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep13.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep13.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep14.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep14.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep15.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep15.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep16.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep16.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep17.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep17.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep18.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep18.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep19.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep19.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

@NotNull MergeValuesStep2<R,T1,T2>

MergeKeyStep2.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

@NotNull MergeValuesStep2<R,T1,T2>

MergeKeyStep2.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep20.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep20.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep21.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep21.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep22.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep22.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

@NotNull MergeValuesStep3<R,T1,T2,T3>

MergeKeyStep3.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

@NotNull MergeValuesStep3<R,T1,T2,T3>

MergeKeyStep3.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

@NotNull MergeValuesStep4<R,T1,T2,T3,T4>

MergeKeyStep4.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

@NotNull MergeValuesStep4<R,T1,T2,T3,T4>

MergeKeyStep4.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

@NotNull MergeValuesStep5<R,T1,T2,T3,T4,T5>

MergeKeyStep5.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

@NotNull MergeValuesStep5<R,T1,T2,T3,T4,T5>

MergeKeyStep5.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

@NotNull MergeValuesStep6<R,T1,T2,T3,T4,T5,T6>

MergeKeyStep6.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

@NotNull MergeValuesStep6<R,T1,T2,T3,T4,T5,T6>

MergeKeyStep6.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep7.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep7.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep8.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep8.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep9.key(Collection<? extends Field<?>> keys)

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 DSLContext.mergeInto(Table)

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

MergeKeyStep9.key(Field<?>... keys)

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 DSLContext.mergeInto(Table)

@NotNull MergeValuesStepN<R>

MergeKeyStepN.key(Collection<? extends Field<?>> keys)

Specify an optional KEY clause.

@NotNull MergeValuesStepN<R>

MergeKeyStepN.key(Field<?>... keys)

Specify an optional KEY clause.

@NotNull Condition

SelectCorrelatedSubqueryStep.le(QuantifiedSelect<? extends R> select)

Compare this subquery with a quanitified subquery for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.le(Select<? extends R> select)

Compare this subquery with another record for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.le(R record)

Compare this subquery with a record for order.

@NotNull SelectOnStep<R>

SelectJoinStep.leftAntiJoin(TableLike<?> table)

A synthetic LEFT ANTI JOIN clause that translates to an equivalent NOT EXISTS predicate.

@NotNull SelectJoinPartitionByStep<R>

SelectJoinStep.leftJoin(String sql)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String).

@NotNull SelectJoinPartitionByStep<R>

SelectJoinStep.leftJoin(String sql, Object... bindings)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String, Object...).

@NotNull SelectJoinPartitionByStep<R>

SelectJoinStep.leftJoin(String sql, QueryPart... parts)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String, QueryPart...).

@NotNull SelectJoinPartitionByStep<R>

SelectJoinStep.leftJoin(Name name)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(Name).

@NotNull SelectJoinPartitionByStep<R>

SelectJoinStep.leftJoin(SQL sql)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String).

@NotNull SelectJoinPartitionByStep<R>

SelectJoinStep.leftJoin(TableLike<?> table)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(TableLike).

@NotNull SelectJoinPartitionByStep<R>

SelectJoinStep.leftOuterJoin(String sql)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String)

@NotNull SelectJoinPartitionByStep<R>

SelectJoinStep.leftOuterJoin(String sql, Object... bindings)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String, Object...)

@NotNull SelectJoinPartitionByStep<R>

SelectJoinStep.leftOuterJoin(String sql, QueryPart... parts)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String, QueryPart...)

@NotNull SelectJoinPartitionByStep<R>

SelectJoinStep.leftOuterJoin(Name name)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(Name)

@NotNull SelectJoinPartitionByStep<R>

SelectJoinStep.leftOuterJoin(SQL sql)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String)

@NotNull SelectJoinPartitionByStep<R>

SelectJoinStep.leftOuterJoin(TableLike<?> table)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(TableLike)

@NotNull SelectOnStep<R>

SelectJoinStep.leftSemiJoin(TableLike<?> table)

A synthetic LEFT SEMI JOIN clause that translates to an equivalent EXISTS predicate.

@NotNull Condition

SelectCorrelatedSubqueryStep.lessOrEqual(QuantifiedSelect<? extends R> select)

Compare this subquery with a quanitified subquery for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.lessOrEqual(Select<? extends R> select)

Compare this subquery with another record for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.lessOrEqual(R record)

Compare this subquery with a record for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.lessThan(QuantifiedSelect<? extends R> select)

Compare this subquery with a quanitified subquery for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.lessThan(Select<? extends R> select)

Compare this subquery with another record for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.lessThan(R record)

Compare this subquery with a record for order.

@NotNull DeleteReturningStep<R>

DeleteLimitStep.limit(Number numberOfRows)

Add a LIMIT clause to the query.

@NotNull DeleteReturningStep<R>

DeleteLimitStep.limit(Param<? extends Number> numberOfRows)

Add a LIMIT clause to the query using named parameters.

@NotNull SelectLimitPercentAfterOffsetStep<R>

SelectLimitAfterOffsetStep.limit(int numberOfRows)

Add a LIMIT clause to the query

@NotNull SelectLimitPercentAfterOffsetStep<R>

SelectLimitAfterOffsetStep.limit(Number numberOfRows)

Add a LIMIT clause to the query

@NotNull SelectLimitPercentAfterOffsetStep<R>

SelectLimitAfterOffsetStep.limit(Param<? extends Number> numberOfRows)

Add a LIMIT clause to the query using named parameters

@NotNull SelectLimitPercentStep<R>

SelectLimitStep.limit(int numberOfRows)

Add a LIMIT clause to the query

@NotNull SelectWithTiesAfterOffsetStep<R>

SelectLimitStep.limit(int offset, int numberOfRows)

Add a LIMIT clause to the query

@NotNull SelectLimitPercentAfterOffsetStep<R>

SelectLimitStep.limit(int offset, Param<Integer> numberOfRows)

Add a LIMIT clause to the query using named parameters

@NotNull SelectLimitPercentStep<R>

SelectLimitStep.limit(Number numberOfRows)

Add a LIMIT clause to the query

@NotNull SelectWithTiesAfterOffsetStep<R>

SelectLimitStep.limit(Number offset, Number numberOfRows)

Add a LIMIT clause to the query

@NotNull SelectLimitPercentAfterOffsetStep<R>

SelectLimitStep.limit(Number offset, Param<? extends Number> numberOfRows)

Add a LIMIT clause to the query using named parameters

@NotNull SelectLimitPercentStep<R>

SelectLimitStep.limit(Param<? extends Number> numberOfRows)

Add a LIMIT clause to the query using named parameters

@NotNull SelectLimitPercentAfterOffsetStep<R>

SelectLimitStep.limit(Param<? extends Number> offset, Number numberOfRows)

Add a LIMIT clause to the query using named parameters

@NotNull SelectLimitPercentAfterOffsetStep<R>

SelectLimitStep.limit(Param<? extends Number> offset, Param<? extends Number> numberOfRows)

Add a LIMIT clause to the query using named parameters

@NotNull SelectLimitPercentAfterOffsetStep<R>

SelectLimitStep.limit(Param<Integer> offset, int numberOfRows)

Add a LIMIT clause to the query using named parameters

@NotNull SelectForUpdateStep<R>

SelectSeekLimitStep.limit(int numberOfRows)

Add a LIMIT clause to the query.

@NotNull SelectForUpdateStep<R>

SelectSeekLimitStep.limit(Number numberOfRows)

Add a LIMIT clause to the query.

@NotNull SelectForUpdateStep<R>

SelectSeekLimitStep.limit(Param<? extends Number> numberOfRows)

Add a LIMIT clause to the query using named parameters.

@NotNull UpdateReturningStep<R>

UpdateLimitStep.limit(Number numberOfRows)

Add a LIMIT clause to the query.

@NotNull UpdateReturningStep<R>

UpdateLimitStep.limit(Param<? extends Number> numberOfRows)

Add a LIMIT clause to the query using named parameters.

@NotNull LoaderRowsStep<R>

LoaderSourceStep.loadArrays(Iterable<? extends Object[]> arrays)

Load in-memory data.

@NotNull LoaderRowsStep<R>

LoaderSourceStep.loadArrays(Object[]... arrays)

Load in-memory data.

@NotNull LoaderRowsStep<R>

LoaderSourceStep.loadArrays(Iterator<? extends Object[]> arrays)

Load in-memory data.

@NotNull LoaderRowsStep<R>

LoaderSourceStep.loadArrays(Stream<? extends Object[]> arrays)

Load in-memory data.

@NotNull LoaderCSVStep<R>

LoaderSourceStep.loadCSV(File file)

Load CSV data.

@NotNull LoaderCSVStep<R>

LoaderSourceStep.loadCSV(File file, String charsetName)

Load CSV data.

@NotNull LoaderCSVStep<R>

LoaderSourceStep.loadCSV(File file, Charset cs)

Load CSV data.

@NotNull LoaderCSVStep<R>

LoaderSourceStep.loadCSV(File file, CharsetDecoder dec)

Load CSV data.

@NotNull LoaderCSVStep<R>

LoaderSourceStep.loadCSV(InputStream stream)

Load CSV data.

@NotNull LoaderCSVStep<R>

LoaderSourceStep.loadCSV(InputStream stream, String charsetName)

Load CSV data.

@NotNull LoaderCSVStep<R>

LoaderSourceStep.loadCSV(InputStream stream, Charset cs)

Load CSV data.

@NotNull LoaderCSVStep<R>

LoaderSourceStep.loadCSV(InputStream stream, CharsetDecoder dec)

Load CSV data.

@NotNull LoaderCSVStep<R>

LoaderSourceStep.loadCSV(Reader reader)

Load CSV data.

@NotNull LoaderCSVStep<R>

LoaderSourceStep.loadCSV(String data)

Load CSV data.

@NotNull LoaderCSVStep<R>

LoaderSourceStep.loadCSV(Source source)

Load CSV data.

<R extends Record>
@NotNull LoaderOptionsStep<R>

DSLContext.loadInto(Table<R> table)

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

@NotNull LoaderJSONStep<R>

LoaderSourceStep.loadJSON(File file)

Load JSON data.

@NotNull LoaderJSONStep<R>

LoaderSourceStep.loadJSON(File file, String charsetName)

Load JSON data.

@NotNull LoaderJSONStep<R>

LoaderSourceStep.loadJSON(File file, Charset cs)

Load JSON data.

@NotNull LoaderJSONStep<R>

LoaderSourceStep.loadJSON(File file, CharsetDecoder dec)

Load JSON data.

@NotNull LoaderJSONStep<R>

LoaderSourceStep.loadJSON(InputStream stream)

Load JSON data.

@NotNull LoaderJSONStep<R>

LoaderSourceStep.loadJSON(InputStream stream, String charsetName)

Load JSON data.

@NotNull LoaderJSONStep<R>

LoaderSourceStep.loadJSON(InputStream stream, Charset cs)

Load JSON data.

@NotNull LoaderJSONStep<R>

LoaderSourceStep.loadJSON(InputStream stream, CharsetDecoder dec)

Load JSON data.

@NotNull LoaderJSONStep<R>

LoaderSourceStep.loadJSON(Reader reader)

Load JSON data.

@NotNull LoaderJSONStep<R>

LoaderSourceStep.loadJSON(String data)

Load JSON data.

@NotNull LoaderJSONStep<R>

LoaderSourceStep.loadJSON(Source source)

Load JSON data.

@NotNull LoaderRowsStep<R>

LoaderSourceStep.loadRecords(Iterable<? extends Record> records)

Load in-memory data.

@NotNull LoaderRowsStep<R>

LoaderSourceStep.loadRecords(Iterator<? extends Record> records)

Load in-memory data.

@NotNull LoaderRowsStep<R>

LoaderSourceStep.loadRecords(Stream<? extends Record> records)

Load in-memory data.

@NotNull LoaderRowsStep<R>

LoaderSourceStep.loadRecords(Record... records)

Load in-memory data.

@NotNull LoaderXMLStep<R>

LoaderSourceStep.loadXML(File file)

Load XML data.

@NotNull LoaderXMLStep<R>

LoaderSourceStep.loadXML(File file, String charsetName)

Load XML data.

@NotNull LoaderXMLStep<R>

LoaderSourceStep.loadXML(File file, Charset cs)

Load XML data.

@NotNull LoaderXMLStep<R>

LoaderSourceStep.loadXML(File file, CharsetDecoder dec)

Load XML data.

@NotNull LoaderXMLStep<R>

LoaderSourceStep.loadXML(InputStream stream)

Load XML data.

@NotNull LoaderXMLStep<R>

LoaderSourceStep.loadXML(InputStream stream, String charsetName)

Load XML data.

@NotNull LoaderXMLStep<R>

LoaderSourceStep.loadXML(InputStream stream, Charset cs)

Load XML data.

@NotNull LoaderXMLStep<R>

LoaderSourceStep.loadXML(InputStream stream, CharsetDecoder dec)

Load XML data.

@NotNull LoaderXMLStep<R>

LoaderSourceStep.loadXML(Reader reader)

Load XML data.

@NotNull LoaderXMLStep<R>

LoaderSourceStep.loadXML(String data)

Load XML data.

@NotNull LoaderXMLStep<R>

LoaderSourceStep.loadXML(Source source)

Load XML data.

@NotNull LoaderXMLStep<R>

LoaderSourceStep.loadXML(InputSource source)

Load XML data.

@NotNull Condition

SelectCorrelatedSubqueryStep.lt(QuantifiedSelect<? extends R> select)

Compare this subquery with a quanitified subquery for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.lt(Select<? extends R> select)

Compare this subquery with another record for order.

@NotNull Condition

SelectCorrelatedSubqueryStep.lt(R record)

Compare this subquery with a record for order.

@NotNull AlterSequenceFlagsStep<T>

AlterSequenceFlagsStep.maxvalue(Field<T> maxvalue)

Add the MAXVALUE clause to the ALTER SEQUENCE statement.

@NotNull AlterSequenceFlagsStep<T>

AlterSequenceFlagsStep.maxvalue(T maxvalue)

Add the MAXVALUE clause to the ALTER SEQUENCE statement.

@NotNull CreateSequenceFlagsStep

CreateSequenceFlagsStep.maxvalue(Number maxvalue)

Add the MAXVALUE clause to the CREATE SEQUENCE statement.

@NotNull CreateSequenceFlagsStep

CreateSequenceFlagsStep.maxvalue(Field<? extends Number> maxvalue)

Add the MAXVALUE clause to the CREATE SEQUENCE statement.

<R extends Record>
@NotNull MergeUsingStep<R>

DSLContext.mergeInto(Table<R> table)

Create a new DSL SQL standard MERGE statement.

<R extends Record>
@NotNull MergeKeyStepN<R>

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

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

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

<R extends Record>
@NotNull MergeKeyStepN<R>

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

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

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

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

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

DSLContext.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 DSLContext.mergeInto(Table)

<R extends Record>
@NotNull MergeUsingStep<R>

WithStep.mergeInto(Table<R> table)

Create a new DSL SQL standard MERGE statement.

<R extends Record>
@NotNull MergeKeyStepN<R>

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

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

<R extends Record>
@NotNull MergeKeyStepN<R>

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

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

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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

WithStep.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 WithStep.mergeInto(Table)

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