Uses of Interface
org.jooq.Table
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
This package contains classes related to the
SQLDialect.POSTGRES
dialect family.-
Uses of Table in org.jooq
Modifier and TypeInterfaceDescriptioninterface
A generator can be used withDataType.generatedAlwaysAs(Generator)
to implement dynamic, client side computed columns, i.e.interface
GeneratorContext<R extends Record,
X extends Table<R>, T> AGeneratorContext
is an argument object that is passed to aGenerator
when generating client side computed columns.Modifier and TypeInterfaceDescriptioninterface
CommonTableExpression<R extends Record>
A common table expression.interface
A step in the construction of anJSON_TABLE
expression.interface
A step in the construction of anJSON_TABLE
expression.interface
TableOnConditionStep<R extends Record>
An intermediate (optional) type for the construction of aJOIN
clause, where the join criteria is added using anON
clause (with aCondition
.interface
TableOptionalOnStep<R extends Record>
interface
A step in the construction of anXMLTABLE
expression.interface
A step in the construction of anXMLTABLE
expression.Modifier and TypeMethodDescription@Nullable Table<?>
Index.$table()
Experimental query object model accessor method, see alsoQOM
.@NotNull Table<?>
QualifiedAsterisk.$table()
Experimental query object model accessor method, see alsoQOM
.Add anAND
clause to the flashback versions query clause.Add anAND
clause to the flashback versions query clause.VersionsBetweenAndStep.andMaxvalue()
Add anAND MAXVALUE
clause to the flashback versions query clause.Create an alias for this table.Create an alias for this table and its fields.Table.as
(String alias, Collection<? extends String> fieldAliases) Create an alias for this table and its fields.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.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.Create an alias for this table.Table.as
(Name alias, Collection<? extends Name> fieldAliases) Create an alias for this table and its fields.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.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.Create an alias for this table and its fields.Create an alias for this table based on another table's name.Table.as
(Table<?> otherTable, Collection<? extends Field<?>> otherFields) Create an alias for this table based on another table's name.Table.as
(Table<?> otherTable, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> aliasFunction) 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.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.Create an alias for this table based on another table's name.Create anSQLDialect.ORACLE
flashback query clause from this table.Create anSQLDialect.ORACLE
flashback query clause from this table.Table.asOfTimestamp
(Timestamp timestamp) Create anSQLDialect.ORACLE
flashback query clause from this table.Table.asOfTimestamp
(Field<Timestamp> timestamp) Create anSQLDialect.ORACLE
flashback query clause from this table.TableLike.asTable()
The underlying table representation of this object.The underlying aliased table representation of this object.The underlying aliased table representation of this object.TableLike.asTable
(String alias, Collection<? extends String> fieldAliases) The underlying aliased table representation of this object.TableLike.asTable
(String alias, BiFunction<? super Field<?>, ? super Integer, ? extends String> aliasFunction) 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.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.The underlying aliased table representation of this object.TableLike.asTable
(Name alias, Collection<? extends Name> fieldAliases) The underlying aliased table representation of this object.The underlying aliased table representation of this object.The underlying aliased table representation of this object.TableLike.asTable
(Table<?> alias, Collection<? extends Field<?>> fieldAliases) The underlying aliased table representation of this object.The underlying aliased table representation of this object.A table reference of this table at a givenLink
.A table reference of this table at a givenLink
.A table reference of this table at a givenLink
.ForeignKey.children
(Collection<? extends PARENT> records) Get a table expression representing the children of a record, given this foreign key.Get a table expression representing the children of a record, given this foreign key.Get a table expression representing the children of a record, given this foreign key.<O extends TableRecord<O>>
@NotNull Table<O>Result.children
(ForeignKey<O, R> key) Get a table expression representing the children of all of this result's records, given a foreign key.<O extends TableRecord<O>>
@NotNull Table<O>UpdatableRecord.children
(ForeignKey<O, R> key) Get a table expression representing the children of this record, given a foreign key.Table.crossApply
(String sql) CROSS APPLY
a table to this table.Table.crossApply
(String sql, Object... bindings) CROSS APPLY
a table to this table.Table.crossApply
(String sql, QueryPart... parts) CROSS APPLY
a table to this table.Table.crossApply
(Name name) CROSS APPLY
a table to this table.Table.crossApply
(SQL sql) CROSS APPLY
a table to this table.Table.crossApply
(TableLike<?> table) CROSS APPLY
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.Table.for_
(PeriodSpecification periodSpecification) Create a reference to a temporal table with aPeriodSpecification
for usage inSelect
.Table.forceIndex
(String... indexes) Specify a MySQL style table hint for query optimisation.Table.forceIndexForGroupBy
(String... indexes) Specify a MySQL style table hint for query optimisation.Table.forceIndexForJoin
(String... indexes) Specify a MySQL style table hint for query optimisation.Table.forceIndexForOrderBy
(String... indexes) Specify a MySQL style table hint for query optimisation.Table.forPortionOf
(PeriodSpecification periodSpecification) Check.getTable()
TheKey
's owner tableDAO.getTable()
Get the underlying table.Identity.getTable()
TheIDENTITY
's owner table@Nullable Table<?>
Index.getTable()
The table on which this index is defined.Key.getTable()
TheKey
's owner table@Nullable Table<?>
Get a table by its name (case-sensitive) in this schema, ornull
if no such table exists.@Nullable Table<?>
Get a table by its qualified or unqualified name in this schema, ornull
if no such table exists.TableField.getTable()
TableRecord.getTable()
The table from which this record was read.@Nullable Table<?>
Trigger.getTable()
The table of the trigger.Table.ignoreIndex
(String... indexes) Specify a MySQL style table hint for query optimisation.Table.ignoreIndexForGroupBy
(String... indexes) Specify a MySQL style table hint for query optimisation.Table.ignoreIndexForJoin
(String... indexes) Specify a MySQL style table hint for query optimisation.Table.ignoreIndexForOrderBy
(String... indexes) Specify a MySQL style table hint for query optimisation.PivotInStep.in
(Collection<? extends Field<T>> fields) Specify the acceptable values for pivotingSpecify the acceptable values for pivotingSpecify the acceptable values for pivotingMap a table to another one.Deprecated, for removal: This API element is subject to removal in a future version.Apply mapping to a given tableTable.naturalFullOuterJoin
(String sql) NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin
(String sql, Object... bindings) NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin
(String sql, QueryPart... parts) NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin
(Name name) NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin
(SQL sql) NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin
(TableLike<?> table) NATURAL FULL OUTER JOIN
a table to this table.Table.naturalJoin
(String sql) NATURAL JOIN
a table to this table.Table.naturalJoin
(String sql, Object... bindings) NATURAL JOIN
a table to this table.Table.naturalJoin
(String sql, QueryPart... parts) NATURAL JOIN
a table to this table.Table.naturalJoin
(Name name) NATURAL JOIN
a table to this table.Table.naturalJoin
(SQL sql) NATURAL JOIN
a table to this table.Table.naturalJoin
(TableLike<?> table) NATURAL JOIN
a table to this table.Table.naturalLeftOuterJoin
(String sql) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin
(String sql, Object... bindings) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin
(String sql, QueryPart... parts) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin
(Name name) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin
(SQL sql) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin
(TableLike<?> table) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin
(String sql) NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin
(String sql, Object... bindings) NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin
(String sql, QueryPart... parts) NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin
(Name name) NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin
(SQL sql) NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin
(TableLike<?> table) NATURAL RIGHT OUTER JOIN
a table to this table.Table.outerApply
(String sql) OUTER APPLY
a table to this table.Table.outerApply
(String sql, Object... bindings) OUTER APPLY
a table to this table.Table.outerApply
(String sql, QueryPart... parts) OUTER APPLY
a table to this table.Table.outerApply
(Name name) OUTER APPLY
a table to this table.Table.outerApply
(SQL sql) OUTER APPLY
a table to this table.Table.outerApply
(TableLike<?> table) OUTER APPLY
a table to this table.Get a table expression representing the parent of a record, given this foreign key.<O extends UpdatableRecord<O>>
@NotNull Table<O>TableRecord.parent
(ForeignKey<R, O> key) Get a table expression representing the parent of this record, given a foreign key.Get a table expression representing the parents of a record, given this foreign key.ForeignKey.parents
(Collection<? extends CHILD> records) Get a table expression representing the parents of a record, given this foreign key.<O extends UpdatableRecord<O>>
@NotNull Table<O>Result.parents
(ForeignKey<R, O> key) Get a table expression representing the parents of all of this result's records, given a foreign key.@NotNull Table<?>
ParseContext.parseTable()
Parse aTable
expression or fail if the current expression is not a table.default @Nullable Table<?>
ParseListener.parseTable
(ParseContext ctx) Attempt to parse aTable
expression.@NotNull Table<?>
Parser.parseTable
(String sql) Parse a SQL string to a table.@NotNull Table<?>
Parser.parseTable
(String sql, Object... bindings) Parse a SQL string with bind variables to a table.@NotNull Table<?>
QualifiedAsterisk.qualifier()
The qualifier.DivideByReturningStep.returning
(Collection<? extends Field<?>> fields) Specify the fields that you want the division to return from the dividendSpecify the fields that you want the division to return from the dividendPolicy.table()
The table to apply the policy to.Specify a MySQL style table hint for query optimisation.Table.useIndexForGroupBy
(String... indexes) Specify a MySQL style table hint for query optimisation.Table.useIndexForJoin
(String... indexes) Specify a MySQL style table hint for query optimisation.Table.useIndexForOrderBy
(String... indexes) Specify a MySQL style table hint for query optimisation.TableOnStep.using
(Collection<? extends Field<?>> fields) Join a table with theUSING(column [, column…])
syntax.Join a table with theUSING(column [, column…])
syntax.Add aWHERE
clause to the table.Add aWHERE
clause to the table.Add aWHERE
clause to the table.Table.where
(Collection<? extends Condition> conditions) Add aWHERE
clause to the table, connecting them with each other withOperator.AND
.Add aWHERE
clause to the table, connecting them with each other withOperator.AND
.Add aWHERE
clause to the table, connecting them with each other withOperator.AND
.Add aWHERE
clause to the table.Add aWHERE
clause to the table.Table.whereExists
(Select<?> select) Add aWHERE EXISTS
clause to the table.Table.whereNotExists
(Select<?> select) Add aWHERE NOT EXISTS
clause to the table.Specify a SQL Server style table hint for query optimisation.Specify a SQL Server style table hint for query optimisation.Specify a SQL Server style table hint for query optimisation.Specify a SQL Server style table hint for query optimisation.Table.withOrdinality()
Add theWITH ORDINALITY
clause.Modifier and TypeMethodDescription@NotNull QOM.UnmodifiableList<? extends Table<?>>
Select.$from()
Experimental query object model accessor method, see alsoQOM
.Meta.getTables()
Get all table objects from the underlying meta data source.Get all table objects by name from the underlying meta data source.Get all table objects by name from the underlying meta data source.Schema.getTables()
List all tables contained in this schema.Schema.tableStream()
Stream all tables contained in this schema.Modifier and TypeMethodDescriptionvoid
Deprecated, for removal: This API element is subject to removal in a future version.Add tables to this mappingvoid
Deprecated, for removal: This API element is subject to removal in a future version.Add tables to this mapping@NotNull AlterViewStep
DSLContext.alterMaterializedView
(Table<?> view) TheALTER MATERIALIZED VIEW
statement.@NotNull AlterViewStep
DSLContext.alterMaterializedViewIfExists
(Table<?> view) TheALTER MATERIALIZED VIEW IF EXISTS
statement.@NotNull AlterTableStep
DSLContext.alterTable
(Table<?> table) Create a new DSLALTER TABLE
statement.@NotNull AlterTableStep
DSLContext.alterTableIfExists
(Table<?> table) Create a new DSLALTER TABLE
statement.@NotNull AlterViewStep
TheALTER VIEW
statement.@NotNull AlterViewStep
DSLContext.alterView
(Table<?> view, Collection<? extends Field<?>> fields) TheALTER VIEW
statement.@NotNull AlterViewStep
TheALTER VIEW
statement.@NotNull AlterViewStep
DSLContext.alterViewIfExists
(Table<?> view) TheALTER VIEW IF EXISTS
statement.Create an alias for this table based on another table's name.Table.as
(Table<?> otherTable, Collection<? extends Field<?>> otherFields) Create an alias for this table based on another table's name.Table.as
(Table<?> otherTable, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> aliasFunction) 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.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.Create an alias for this table based on another table's name.The underlying aliased table representation of this object.TableLike.asTable
(Table<?> alias, Collection<? extends Field<?>> fieldAliases) The underlying aliased table representation of this object.The underlying aliased table representation of this object.<X extends Record>
@NotNull CloseableResultQuery<X><X extends Record>
@NotNull ResultQuery<X>Coerce the result record type of this query to that of a table.@NotNull CommentOnIsStep
DSLContext.commentOnMaterializedView
(Table<?> view) TheCOMMENT ON MATERIALIZED VIEW
statement.@NotNull CommentOnIsStep
DSLContext.commentOnTable
(Table<?> table) TheCOMMENT ON TABLE
statement.@NotNull CommentOnIsStep
DSLContext.commentOnView
(Table<?> view) TheCOMMENT ON VIEW
statement.@NotNull CreateTableElementListStep
DSLContext.createGlobalTemporaryTable
(Table<?> table) TheCREATE GLOBAL TEMPORARY TABLE
statement.@NotNull CreateTableElementListStep
DSLContext.createGlobalTemporaryTableIfNotExists
(Table<?> table) TheCREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedView
(Table<?> view, Field<?>... fields) TheCREATE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedViewIfNotExists
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedViewIfNotExists
(Table<?> view, Field<?>... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceMaterializedView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceMaterializedView
(Table<?> view, Field<?>... fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE 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) TheCREATE OR REPLACE VIEW
statement.@NotNull CreateTableElementListStep
DSLContext.createTable
(Table<?> table) TheCREATE TABLE
statement.@NotNull CreateTableElementListStep
DSLContext.createTableIfNotExists
(Table<?> table) TheCREATE TABLE IF NOT EXISTS
statement.@NotNull CreateTableElementListStep
DSLContext.createTemporaryTable
(Table<?> table) TheCREATE TEMPORARY TABLE
statement.@NotNull CreateTableElementListStep
DSLContext.createTemporaryTableIfNotExists
(Table<?> table) TheCREATE TEMPORARY TABLE IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE 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) TheCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE VIEW IF NOT EXISTS
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) TheCREATE VIEW IF NOT EXISTS
statement.@NotNull Queries
Convenience method forMeta.ddl()
.@NotNull Queries
Convenience method forMeta.ddl()
.@NotNull Queries
DSLContext.ddl
(Table<?>[] tables, DDLExportConfiguration configuration) Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
DSLContext.ddl
(Table<?> table, DDLExportConfiguration configuration) Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
Convenience method forMeta.ddl(DDLExportConfiguration)
.<R extends Record>
@NotNull DeleteUsingStep<R>Create a new DSL delete statement.<R extends Record>
@NotNull DeleteUsingStep<R>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 newDeleteQuery
@NotNull DivideByOnStep
Create a newTABLE
reference from this table, applying relational division.@NotNull DropViewFinalStep
DSLContext.dropMaterializedView
(Table<?> view) TheDROP MATERIALIZED VIEW
statement.@NotNull DropViewFinalStep
DSLContext.dropMaterializedViewIfExists
(Table<?> view) TheDROP MATERIALIZED VIEW IF EXISTS
statement.@NotNull DropTableStep
TheDROP TABLE
statement.@NotNull DropTableStep
DSLContext.dropTableIfExists
(Table<?> table) TheDROP TABLE IF EXISTS
statement.@NotNull DropTableStep
DSLContext.dropTemporaryTable
(Table<?> table) TheDROP TEMPORARY TABLE
statement.@NotNull DropTableStep
DSLContext.dropTemporaryTableIfExists
(Table<?> table) TheDROP TEMPORARY TABLE IF EXISTS
statement.@NotNull DropViewFinalStep
TheDROP VIEW
statement.@NotNull DropViewFinalStep
DSLContext.dropViewIfExists
(Table<?> view) TheDROP VIEW IF EXISTS
statement.@NotNull Condition
TheEQ
operator.@NotNull Condition
TheEQUAL
operator, an alias for theEQ
operator.Execute and return all records forDSLContext.fetch
(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records forExecute and return all records forExecute and return all records for<R extends Record>
RExecute and return zero or one record for<R extends Record>
RDSLContext.fetchAny
(Table<R> table, Collection<? extends Condition> conditions) Execute and return zero or one record for<R extends Record>
RExecute and return zero or one record for<R extends Record>
RExecute and return zero or on e record for<Z extends Record>
ZResultQuery.fetchAnyInto
(Table<Z> table) Map resulting records onto a custom record.<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Executor executor, Table<R> table) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Executor executor, Table<R> table, Collection<? extends Condition> conditions) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Executor executor, Table<R> table, Condition condition) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Executor executor, Table<R> table, Condition... conditions) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Table<R> table) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Table<R> table, Collection<? extends Condition> condition) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Table<R> table, Condition condition) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Table<R> table, Condition... condition) Execute and return all records asynchronously forint
DSLContext.fetchCount
(Table<?> table) Count the number of records in a table.int
DSLContext.fetchCount
(Table<?> table, Collection<? extends Condition> conditions) Count the number of records in a table that satisfy a condition.int
DSLContext.fetchCount
(Table<?> table, Condition condition) Count the number of records in a table that satisfy a condition.int
DSLContext.fetchCount
(Table<?> table, Condition... conditions) Count the number of records in a table that satisfy a condition.boolean
DSLContext.fetchExists
(Table<?> table) Check if a table has any records.boolean
DSLContext.fetchExists
(Table<?> table, Collection<? extends Condition> conditions) Check if a table has any records that satisfy a condition.boolean
DSLContext.fetchExists
(Table<?> table, Condition condition) Check if a table has any records that satisfy a condition.boolean
DSLContext.fetchExists
(Table<?> table, Condition... conditions) Check if a table has any records that satisfy a condition.ResultQuery.fetchGroups
(Table<S> table) Execute the query and return aMap
with the result grouped by the given table.ResultQuery.fetchGroups
(Table<S> table, Class<? extends E> type) Execute the query and return aMap
with results grouped by the given table and mapped into the given entity type.ResultQuery.fetchGroups
(Table<S> table, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given table and mapped by the given mapper.ResultQuery.fetchGroups
(Table<S> keyTable, Table<T> valueTable) Execute the query and return aMap
with the result grouped by the given table.Map resulting records onto a custom record.Map resulting records onto a custom record.Execute and return all records lazily forDSLContext.fetchLazy
(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records lazily forExecute and return all records lazily forExecute and return all records lazily forExecute the query and return aMap
with table as a map key and the corresponding record as value.Execute the query and return aMap
with results grouped by the given table and mapped into the given entity type.ResultQuery.fetchMap
(Table<S> table, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given table and mapped by the given mapper.Execute the query and return aMap
with table as a map key and the corresponding record as value.<Z extends Record>
ZCursor.fetchNextInto
(Table<Z> table) Map the next resulting record onto a custom record.Cursor.fetchNextOptionalInto
(Table<Z> table) Map the next resulting record onto a custom record.<R extends Record>
RExecute and return zero or one record for<R extends Record>
RDSLContext.fetchOne
(Table<R> table, Collection<? extends Condition> conditions) Execute and return zero or one record for<R extends Record>
RExecute and return zero or one record for<R extends Record>
RExecute and return zero or one record for<Z extends Record>
ZCursor.fetchOneInto
(Table<Z> table) Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6363] - UseCursor.fetchNextInto(Table)
instead.<Z extends Record>
ZResultQuery.fetchOneInto
(Table<Z> table) Map resulting records onto a custom record.DSLContext.fetchOptional
(Table<R> table) Execute and return zero or one record forDSLContext.fetchOptional
(Table<R> table, Collection<? extends Condition> conditions) Execute and return zero or one record forDSLContext.fetchOptional
(Table<R> table, Condition condition) Execute and return zero or one record forDSLContext.fetchOptional
(Table<R> table, Condition... conditions) Execute and return zero or one record forCursor.fetchOptionalInto
(Table<Z> table) Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6363] - UseCursor.fetchNextOptionalInto(Table)
instead.ResultQuery.fetchOptionalInto
(Table<Z> table) Map resulting records onto a custom record.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table) Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Collection<? extends Condition> conditions) Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition condition) Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition... conditions) Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDisambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21, Condition c22) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<Z extends Record>
ZResultQuery.fetchSingleInto
(Table<Z> table) Map resulting records onto a custom record.DSLContext.fetchStream
(Table<R> table) Execute and return all records lazily forDSLContext.fetchStream
(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records lazily forDSLContext.fetchStream
(Table<R> table, Condition condition) Execute and return all records lazily forDSLContext.fetchStream
(Table<R> table, Condition... conditions) Execute and return all records lazily forResultQuery.fetchStreamInto
(Table<Z> table) Stream this query, mapping records into a custom record.<T> T
DSLContext.fetchValue
(Table<? extends Record1<T>> table) Fetch a single value from a single column table.<T> @NotNull List<T>
DSLContext.fetchValues
(Table<? extends Record1<T>> table) Fetch all values from a single column table.void
Formattable.formatInsert
(OutputStream stream, Table<?> table, Field<?>... fields) LikeFormattable.formatInsert(Table, Field...)
, but the data is output onto anOutputStream
.void
Formattable.formatInsert
(Writer writer, Table<?> table, Field<?>... fields) LikeFormattable.formatInsert(Table, Field...)
, but the data is output onto anWriter
.@NotNull String
Formattable.formatInsert
(Table<?> table, Field<?>... fields) Get this result as a set ofINSERT
statements.<O extends Record>
@NotNull List<ForeignKey<O,R>> Table.getReferencesFrom
(Table<O> other) Get a list ofFOREIGN KEY
's of a specific table, referencing a this table.<O extends Record>
@NotNull List<ForeignKey<R,O>> Table.getReferencesTo
(Table<O> other) Get a list ofFOREIGN KEY
's of this table, referencing a specific table.@NotNull InformationSchema
DSLContext.informationSchema
(Table<?> table) Convenience method forMeta.informationSchema()
.@NotNull InformationSchema
DSLContext.informationSchema
(Table<?>... table) Convenience method forMeta.informationSchema()
.<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 newInsertQuery
<R extends Record>
RMap resulting records onto a custom record type.Map resulting records onto a custom record.@NotNull SelectFromStep<Record>
Add a T-SQL styleINTO
clause to theSELECT
statement to create a new table from aSELECT
statement.Result.intoGroups
(Table<S> table) Return aMap
with the result grouped by the given key table.Result.intoGroups
(Table<S> table, Class<? extends E> type) Return aMap
with results grouped by the given key table and mapped into the given entity type.Result.intoGroups
(Table<S> table, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given key table and mapped into the given entity type.Result.intoGroups
(Table<S> keyTable, Table<T> valueTable) Return aMap
with the result grouped by the given key table.Return aMap
with the given key table as a map key and the corresponding record as value.Return aMap
with results grouped by the given key table and mapped into the given entity type.Result.intoMap
(Table<S> table, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given key table and mapped by the given mapper.Return aMap
with the given key table as a map key and the corresponding record as value.<R extends Record>
@NotNull LoaderOptionsStep<R>Create a newLoader
object to load data from a CSV or XML source.Map a table to another one.Deprecated, for removal: This API element is subject to removal in a future version.Apply mapping to a given tablestatic final @NotNull Replacer
Replacers.mappingTable
(Table<?> input, Table<?> output) AReplacer
that maps a pair of tables similar to the functionality offered bySettings.getRenderMapping()
.<R extends Record>
@NotNull MergeUsingStep<R>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, viaDSLContext.mergeInto(Table)
<R extends Record>
@NotNull MergeKeyStepN<R>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, viaDSLContext.mergeInto(Table)
<R extends Record,
T1>
@NotNull MergeKeyStep1<R,T1> 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, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2>
@NotNull MergeKeyStep2<R,T1, T2> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3>
@NotNull MergeKeyStep3<R,T1, T2, T3> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.mergeInto(Table)
<R extends Record>
@NotNull MergeUsingStep<R>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>Create a new DSL merge statement (H2-specific syntax).<R extends Record,
T1>
@NotNull MergeKeyStep1<R,T1> 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, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2>
@NotNull MergeKeyStep2<R,T1, T2> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3>
@NotNull MergeKeyStep3<R,T1, T2, T3> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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> 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, 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, viaWithStep.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> 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, 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, viaWithStep.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> 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, 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, viaWithStep.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> 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, 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, viaWithStep.mergeInto(Table)
@NotNull Meta
Access the database meta data from explicit table information.@NotNull Condition
TheNE
operator.<R extends Record>
RCreate a newRecord
that can be inserted into the corresponding table.<R extends Record>
RCreate a new pre-filledRecord
that can be inserted into the corresponding table.Create a new emptyResult
.@NotNull Condition
TheNOT_EQUAL
operator, an alias for theNE
operator.@NotNull SelectForUpdateWaitStep<R>
Add anOF
clause to theFOR <lock_mode>
clause at the end of the query.@NotNull AlterIndexStep
Add theON
clause to theALTER INDEX
statement.@NotNull CreateIndexIncludeStep
CreateIndexStep.on
(Table<?> table, Collection<? extends OrderField<?>> on) Add theON
clause to theCREATE INDEX
statement.@NotNull CreateIndexIncludeStep
CreateIndexStep.on
(Table<?> table, OrderField<?>... on) Add theON
clause to theCREATE INDEX
statement.@NotNull CreateTriggerReferencingStep
Add theON
clause to theCREATE TRIGGER
statement.@NotNull DropIndexCascadeStep
Add theON
clause to theDROP INDEX
statement.@NotNull DDLQuery
Add theON
clause to theDROP TRIGGER
statement.@NotNull GrantToStep
Add theON
clause to theGRANT
statement.@NotNull RevokeFromStep
Add theON
clause to theREVOKE
statement.Provide a list ofPolicy
for a table's row level security.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep1.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep1.references
(Table<?> table, Field<T1> field1) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep10.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep10.references
(Table<?> 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) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep11.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep11.references
(Table<?> 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) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep12.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep12.references
(Table<?> 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) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep13.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep13.references
(Table<?> 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) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep14.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep14.references
(Table<?> 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) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep15.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep15.references
(Table<?> 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) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep16.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep16.references
(Table<?> 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) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep17.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep17.references
(Table<?> 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) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep18.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep18.references
(Table<?> 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) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep19.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep19.references
(Table<?> 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) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep2.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep20.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep20.references
(Table<?> 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) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep21.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep21.references
(Table<?> 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) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep22.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep22.references
(Table<?> 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) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep3.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep3.references
(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep4.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep4.references
(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep5.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep5.references
(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep6.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep6.references
(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep7.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep7.references
(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep8.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep8.references
(Table<?> 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) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep9.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep9.references
(Table<?> 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) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStepN.references
(Table<?> table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStepN.references
(Table<?> table, Collection<? extends Field<?>> fields) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStepN.references
(Table<?> table, Field<?>... fields) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull AlterTableFinalStep
Add aRENAME TO
clause to theALTER TABLE
statement.@NotNull AlterViewFinalStep
Add theRENAME TO
clause to theALTER VIEW
statement.void
SelectQuery.setForLockModeOf
(Table<?>... tables) Some RDBMS allow for specifying the tables that should be locked by theFOR <lock_mode>
clause, instead of the full row.void
SelectQuery.setForUpdateOf
(Table<?>... tables) Deprecated, for removal: This API element is subject to removal in a future version.[#5218] - 3.14.0 - UseSelectQuery.setForLockModeOf(Table...)
void
Add a T-SQL styleINTO
clause to theSELECT
statement to create a new table from aSELECT
statement.@NotNull TruncateIdentityStep<Record>
TheTRUNCATE
statement.<R extends Record>
@NotNull TruncateIdentityStep<R>TheTRUNCATE
statement.@NotNull TruncateIdentityStep<Record>
DSLContext.truncateTable
(Table<?>... table) TheTRUNCATE TABLE
statement.<R extends Record>
@NotNull TruncateIdentityStep<R>DSLContext.truncateTable
(Table<R> table) TheTRUNCATE TABLE
statement.<R extends Record>
@NotNull UpdateSetFirstStep<R>Create a new DSL update statement.<R extends Record>
@NotNull UpdateSetFirstStep<R>Create a new DSL update statement.<R extends Record>
@NotNull UpdateQuery<R>DSLContext.updateQuery
(Table<R> table) Create a newUpdateQuery
Modifier and TypeMethodDescriptionSelect.$from
(Collection<? extends Table<?>> newFrom) Experimental query object model accessor method, see alsoQOM
.@NotNull Queries
DSLContext.ddl
(Collection<? extends Table<?>> tables) Convenience method forMeta.ddl()
.@NotNull Queries
DSLContext.ddl
(Collection<? extends Table<?>> tables, DDLExportConfiguration configuration) Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
DSLContext.ddl
(Collection<? extends Table<?>> tables, DDLFlag... flags) Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Meta
Meta.filterTables
(Predicate<? super Table<?>> filter) Create a wrapperMeta
instance filtering out some tables.static final @NotNull Replacer
Replacers.mappingTable
(Function<? super Table<?>, ? extends Table<?>> replacement) AReplacer
that maps tables similar to the functionality offered bySettings.getRenderMapping()
.static final @NotNull Replacer
Replacers.mappingTable
(Function<? super Table<?>, ? extends Table<?>> replacement) AReplacer
that maps tables similar to the functionality offered bySettings.getRenderMapping()
.static CallbackParseListener
ParseListener.onParseTable
(Function<? super ParseContext, ? extends Table<?>> onParseTable) Create aParseListener
with aParseListener.parseTable(ParseContext)
implementation.@NotNull TruncateIdentityStep<Record>
DSLContext.truncate
(Collection<? extends Table<?>> table) TheTRUNCATE
statement.@NotNull TruncateIdentityStep<Record>
DSLContext.truncateTable
(Collection<? extends Table<?>> table) TheTRUNCATE TABLE
statement. -
Uses of Table in org.jooq.impl
Modifier and TypeClassDescriptionfinal class
AuditGenerator<R extends Record,
X extends Table<R>, T> AGenerator
that can be used for audit columns, whose values are defined byConfiguration.auditProvider()
.Modifier and TypeInterfaceDescriptionstatic interface
QOM.CrossApply<R extends Record>
static interface
QOM.CrossJoin<R extends Record>
static interface
QOM.DataChangeDeltaTable<R extends Record>
static interface
QOM.DerivedTable<R extends Record>
static interface
static interface
QOM.FullJoin<R extends Record>
static interface
static interface
QOM.HintedTable<R extends Record>
A table with a MySQL style index access hint.static interface
static interface
QOM.JoinTable<R extends Record,
J extends QOM.JoinTable<R, J>> static interface
QOM.Lateral<R extends Record>
static interface
QOM.LeftAntiJoin<R extends Record>
static interface
QOM.LeftJoin<R extends Record>
static interface
QOM.LeftSemiJoin<R extends Record>
static interface
QOM.LinkedTable<R extends Record>
A table with a database link.static interface
QOM.NaturalFullJoin<R extends Record>
static interface
QOM.NaturalJoin<R extends Record>
static interface
QOM.NaturalLeftJoin<R extends Record>
static interface
QOM.NaturalRightJoin<R extends Record>
static interface
QOM.OuterApply<R extends Record>
static interface
QOM.QualifiedJoin<R extends Record,
J extends QOM.QualifiedJoin<R, J>> static interface
QOM.RightJoin<R extends Record>
static interface
static interface
QOM.StraightJoin<R extends Record>
static interface
QOM.TableAlias<R extends Record>
static interface
QOM.Values<R extends Record>
static interface
QOM.WithOrdinalityTable<R extends Record>
A collection derived table or table valued function with aWITH ORDINALITY
clause.static interface
QOM.WithTable<R extends Record>
A table with a T-SQL styleWITH
hint.Modifier and TypeClassDescriptionclass
CustomTable<R extends TableRecord<R>>
A base class for customTable
implementations in client code.class
A common base type for tablesModifier and TypeMethodDescriptionstatic final <R extends Record,
TR extends Table<R>, T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, TR table, String comment, Class<P> returnType, Binding<T, U> binding, Generator<R, TR, U> generator) static final <R extends Record,
TR extends Table<R>, T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, TR table, String comment, Class<P> returnType, Converter<T, U> converter, Generator<R, TR, U> generator) static final <R extends Record,
TR extends Table<R>, T, X, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, TR table, String comment, Class<P> returnType, Converter<X, U> converter, Binding<T, X> binding, Generator<R, TR, U> generator) static final <R extends Record,
TR extends Table<R>, T, P extends UDTPathTableField<R, ?, T>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, TR table, String comment, Class<P> returnType, Generator<R, TR, T> generator) Modifier and TypeMethodDescriptionQOM.TableAlias.$aliased()
TableImpl.$aliased()
QOM.Delete.$from()
QOM.Insert.$into()
@Nullable Table<?>
QOM.AlterIndex.$on()
@NotNull Table<?>
QOM.CreateTrigger.$on()
@Nullable Table<?>
QOM.DropIndex.$on()
@Nullable Table<?>
QOM.DropTrigger.$on()
@NotNull Table<?>
QOM.Grant.$on()
@NotNull Table<?>
QOM.Revoke.$on()
@Nullable Table<?>
QOM.AlterView.$renameTo()
@Nullable Table<?>
QOM.CommentOn.$table()
@NotNull Table<?>
QOM.CountTable.$table()
@Nullable Table<?>
QOM.CreateIndex.$table()
@NotNull Table<?>
QOM.CreateTable.$table()
@NotNull Table<?>
QOM.DropTable.$table()
QOM.HintedTable.$table()
QOM.LinkedTable.$table()
default @NotNull Table<?>
QOM.QualifiedRowid.$table()
QOM.TableAlias.$table()
QOM.TableAsField.$table()
QOM.Update.$table()
@NotNull Table<?>
QOM.WithOrdinalityTable.$table()
QOM.WithTable.$table()
@NotNull Table<?>
QOM.JoinTable.$table1()
@NotNull Table<?>
QOM.JoinTable.$table2()
@NotNull Table<?>
QOM.AlterView.$view()
@NotNull Table<?>
QOM.CreateView.$view()
@NotNull Table<?>
QOM.DropView.$view()
Subclasses may override this method to provide custom aliasing implementationsSubclasses may override this method to provide custom aliasing implementationsfinal <O extends TableRecord<O>>
Table<O>UpdatableRecordImpl.children
(ForeignKey<O, R> key) DSL.dual()
TheDUAL
table to be used for syntactic completeness.DSL.finalTable
(Insert<R> query) DSL.finalTable
(Merge<R> query) DSL.finalTable
(Update<R> query) DSL.generateSeries
(int from, int to) A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries
(int from, int to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(int from, int to, Field<Integer> step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(int from, Field<Integer> to) A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries
(int from, Field<Integer> to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(int from, Field<Integer> to, Field<Integer> step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(Field<Integer> from, int to) A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries
(Field<Integer> from, int to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(Field<Integer> from, int to, Field<Integer> step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(Field<Integer> from, Field<Integer> to) A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries
(Field<Integer> from, Field<Integer> to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DAOImpl.getTable()
final Table<?>
final Table<?>
final Table<?>
final Table<?>
TableRecordImpl.getTable()
UDTPathTableFieldImpl.getTable()
Create aLATERAL
joined table.static @NotNull Table<?>
DSL.noTable()
Return aTable
that behaves like no table being present.final <O extends UpdatableRecord<O>>
Table<O>TableRecordImpl.parent
(ForeignKey<R, O> key) final Table<?>
CallbackParseListener.parseTable
(ParseContext ctx) Create aROWS FROM (tables…)
expression.static @NotNull Table<?>
A synonym forDSL.unnest(Object[])
.A custom SQL clause that can render arbitrary table expressions.A custom SQL clause that can render arbitrary table expressions.A custom SQL clause that can render arbitrary table expressions.static @NotNull Table<?>
DSL.table
(Collection<?> list) A synonym forDSL.unnest(Collection)
.static @NotNull Table<?>
DSL.table
(ArrayRecord<?> array) A synonym forDSL.unnest(ArrayRecord)
.static @NotNull Table<?>
A synonym forDSL.unnest(Field)
.Create a qualified table, given its table name.Create a qualified table, given its table name.Use a previously obtained result as a newTable
that can be used in SQL statements throughDSL.values(RowN...)
.A synonym forTableLike.asTable()
, which might look a bit more fluent like this, to some users.A custom SQL clause that can render arbitrary table expressions.DSL.table
(R record) Use a previously obtained record as a new TableDSL.table
(R... records) Use a previously obtained set of records as a new Tablestatic @NotNull Table<?>
Create a table from an array of values.static @NotNull Table<?>
DSL.unnest
(Collection<?> list) Create a table from a list of values.static @NotNull Table<?>
DSL.unnest
(ArrayRecord<?> array) Create a table from an array of values.static @NotNull Table<?>
Create a table from a field.Create aVALUES()
expression of degree1
.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull Table<Record10<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10>> Create aVALUES()
expression of degree10
.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull Table<Record11<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> Create aVALUES()
expression of degree11
.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull Table<Record12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> Create aVALUES()
expression of degree12
.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull Table<Record13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> Create aVALUES()
expression of degree13
.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull Table<Record14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> Create aVALUES()
expression of degree14
.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull Table<Record15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> Create aVALUES()
expression of degree15
.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull Table<Record16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> Create aVALUES()
expression of degree16
.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull Table<Record17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> Create aVALUES()
expression of degree17
.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull Table<Record18<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> Create aVALUES()
expression of degree18
.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull Table<Record19<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> Create aVALUES()
expression of degree19
.Create aVALUES()
expression of degree2
.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull Table<Record20<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> Create aVALUES()
expression of degree20
.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull Table<Record21<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> DSL.values
(Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>... rows) Create aVALUES()
expression of degree21
.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull Table<Record22<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> DSL.values
(Row22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>... rows) Create aVALUES()
expression of degree22
.Create aVALUES()
expression of degree3
.Create aVALUES()
expression of degree4
.Create aVALUES()
expression of degree5
.Create aVALUES()
expression of degree6
.Create aVALUES()
expression of degree7
.Create aVALUES()
expression of degree8
.Create aVALUES()
expression of degree9
.Create aVALUES()
expression of arbitrary degree.Modifier and TypeMethodDescription@NotNull QOM.UnmodifiableList<? extends Table<?>>
QOM.Update.$from()
@NotNull QOM.UnmodifiableList<? extends Table<?>>
QOM.Truncate.$table()
@NotNull QOM.UnmodifiableList<? extends Table<?>>
QOM.RowsFrom.$tables()
@NotNull QOM.UnmodifiableList<? extends Table<?>>
QOM.Delete.$using()
LazySchema.getTables()
SchemaImpl.getTables()
List all tables contained in this schema.LazySchema.tableStream()
SchemaImpl.tableStream()
Modifier and TypeMethodDescription@NotNull QOM.Delete<?>
@NotNull QOM.Insert<?>
@NotNull QOM.AlterIndex
@NotNull QOM.CreateTrigger
@NotNull QOM.DropIndex
@NotNull QOM.DropTrigger
@NotNull QOM.Grant
@NotNull QOM.Revoke
@NotNull QOM.AlterView
@NotNull QOM.CommentOn
@NotNull QOM.CreateIndex
@NotNull QOM.CreateTable
@NotNull QOM.DropTable
<O extends Record>
@NotNull QOM.HintedTable<O><O extends Record>
@NotNull QOM.LinkedTable<O>default @NotNull QOM.QualifiedRowid
@NotNull QOM.Update<?>
@NotNull QOM.WithOrdinalityTable<?>
<O extends Record>
@NotNull QOM.WithTable<O>@NotNull QOM.AlterView
@NotNull QOM.CreateView<R>
@NotNull QOM.DropView
DefaultDSLContext.alterMaterializedView
(Table<?> view) static AlterViewStep
DSL.alterMaterializedView
(Table<?> view) TheALTER MATERIALIZED VIEW
statement.DefaultDSLContext.alterMaterializedViewIfExists
(Table<?> view) static AlterViewStep
DSL.alterMaterializedViewIfExists
(Table<?> view) TheALTER MATERIALIZED VIEW IF EXISTS
statement.DefaultDSLContext.alterTable
(Table<?> table) static @NotNull AlterTableStep
DSL.alterTable
(Table<?> table) Create a new DSLALTER TABLE
statement.DefaultDSLContext.alterTableIfExists
(Table<?> table) static @NotNull AlterTableStep
DSL.alterTableIfExists
(Table<?> table) Create a new DSLALTER TABLE
statement.DefaultDSLContext.alterView
(Table<?> view, Collection<? extends Field<?>> fields) static AlterViewStep
TheALTER VIEW
statement.static AlterViewStep
DSL.alterView
(Table<?> view, Collection<? extends Field<?>> fields) TheALTER VIEW
statement.static AlterViewStep
TheALTER VIEW
statement.DefaultDSLContext.alterViewIfExists
(Table<?> view) static AlterViewStep
DSL.alterViewIfExists
(Table<?> view) TheALTER VIEW IF EXISTS
statement.final DefaultPolicyProvider
final <R extends Record>
DefaultPolicyProviderDefaultPolicyProvider.append
(Table<R> table, Condition condition, Collection<? extends Path<R>> inherited) Add aPolicy
for aPolicy.table()
andPolicy.condition()
as well as a set ofPolicy.inherited()
paths.final <R extends Record>
DefaultPolicyProviderAdd aPolicy
for aPolicy.table()
andPolicy.condition()
as well as a set ofPolicy.inherited()
paths.DefaultDSLContext.commentOnMaterializedView
(Table<?> view) static CommentOnIsStep
DSL.commentOnMaterializedView
(Table<?> view) TheCOMMENT ON MATERIALIZED VIEW
statement.DefaultDSLContext.commentOnTable
(Table<?> table) static CommentOnIsStep
DSL.commentOnTable
(Table<?> table) TheCOMMENT ON TABLE
statement.DefaultDSLContext.commentOnView
(Table<?> view) static CommentOnIsStep
DSL.commentOnView
(Table<?> view) TheCOMMENT ON VIEW
statement.static @NotNull AggregateFunction<Integer>
Get the count(table) function.static @NotNull AggregateFunction<Integer>
DSL.countDistinct
(Table<?> table) Get the count(distinct table) function.Internal.createCheck
(Table<R> table, Name name, String condition) Factory method for check constraints.Internal.createCheck
(Table<R> table, Name name, String condition, boolean enforced) Factory method for check constraints.static final <R extends Record,
E extends EmbeddableRecord<E>>
@NotNull TableField<R,E> Internal.createEmbeddable
(Name name, Class<E> recordType, boolean replacesFields, Table<R> table, TableField<R, ?>... fields) Factory method for embeddable types.static final <R extends Record,
E extends EmbeddableRecord<E>>
@NotNull TableField<R,E> Internal.createEmbeddable
(Name name, Class<E> recordType, Table<R> table, TableField<R, ?>... fields) Factory method for embeddable types.static <R extends Record,
U extends Record>
ForeignKey<R,U> AbstractKeys.createForeignKey
(UniqueKey<U> key, Table<R> table, String name, TableField<R, ?>... fields) Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record,
U extends Record>
ForeignKey<R,U> AbstractKeys.createForeignKey
(UniqueKey<U> key, Table<R> table, TableField<R, ?>... fields) Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic final <R extends Record,
U extends Record>
@NotNull ForeignKey<R,U> Internal.createForeignKey
(Table<R> table, Name name, TableField<R, ?>[] fkFields, UniqueKey<U> uk, TableField<U, ?>[] ukFields, boolean enforced) Factory method for foreign keys.static final <R extends Record,
U extends Record, ER extends EmbeddableRecord<ER>>
@NotNull ForeignKey<R,U> Internal.createForeignKey
(Table<R> table, Name name, TableField<R, ER> fkEmbeddableField, UniqueKey<U> uk, TableField<U, ER> ukEmbeddableField, boolean enforced) Factory method for foreign keys.static final <R extends Record,
U extends Record>
@NotNull ForeignKey<R,U> Internal.createForeignKey
(UniqueKey<U> key, Table<R> table, String name, TableField<R, ?>... fields) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#9404] - Please re-generate your code.static final <R extends Record,
U extends Record>
@NotNull ForeignKey<R,U> Internal.createForeignKey
(UniqueKey<U> key, Table<R> table, String name, TableField<R, ?>[] fields, boolean enforced) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#9404] - Please re-generate your code.static final <R extends Record,
U extends Record>
@NotNull ForeignKey<R,U> Internal.createForeignKey
(UniqueKey<U> key, Table<R> table, TableField<R, ?>... fields) Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.DefaultDSLContext.createGlobalTemporaryTable
(Table<?> table) static CreateTableElementListStep
DSL.createGlobalTemporaryTable
(Table<?> table) TheCREATE GLOBAL TEMPORARY TABLE
statement.DefaultDSLContext.createGlobalTemporaryTableIfNotExists
(Table<?> table) static CreateTableElementListStep
DSL.createGlobalTemporaryTableIfNotExists
(Table<?> table) TheCREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS
statement.AbstractKeys.createIdentity
(Table<R> table, TableField<R, T> field) Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codeInternal.createIdentity
(Table<R> table, TableField<R, T> field) Factory method for identities.static Index
AbstractKeys.createIndex
(String name, Table<?> table, OrderField<?>[] sortFields, boolean unique) Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic final @NotNull Index
Internal.createIndex
(String name, Table<?> table, OrderField<?>[] sortFields, boolean unique) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#9404] - Please re-generate your code.static final @NotNull Index
Internal.createIndex
(Name name, Table<?> table, OrderField<?>[] sortFields, boolean unique) Factory method for indexes.DefaultDSLContext.createMaterializedView
(Table<?> view, Collection<? extends Field<?>> fields) DefaultDSLContext.createMaterializedView
(Table<?> view, Field<?>... fields) static CreateViewAsStep<Record>
DSL.createMaterializedView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE MATERIALIZED VIEW
statement.static CreateViewAsStep<Record>
DSL.createMaterializedView
(Table<?> view, Field<?>... fields) TheCREATE MATERIALIZED VIEW
statement.DefaultDSLContext.createMaterializedViewIfNotExists
(Table<?> view, Collection<? extends Field<?>> fields) DefaultDSLContext.createMaterializedViewIfNotExists
(Table<?> view, Field<?>... fields) static CreateViewAsStep<Record>
DSL.createMaterializedViewIfNotExists
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.static CreateViewAsStep<Record>
DSL.createMaterializedViewIfNotExists
(Table<?> view, Field<?>... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.DefaultDSLContext.createOrReplaceMaterializedView
(Table<?> view, Collection<? extends Field<?>> fields) DefaultDSLContext.createOrReplaceMaterializedView
(Table<?> view, Field<?>... fields) static CreateViewAsStep<Record>
DSL.createOrReplaceMaterializedView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.static CreateViewAsStep<Record>
DSL.createOrReplaceMaterializedView
(Table<?> view, Field<?>... fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.DefaultDSLContext.createOrReplaceView
(Table<?> view, Collection<? extends Field<?>> fields) DefaultDSLContext.createOrReplaceView
(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createOrReplaceView
(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createOrReplaceView
(Table<?> view, Field<?>... fields) static CreateViewAsStep<Record>
DSL.createOrReplaceView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE OR REPLACE VIEW
statement.static @NotNull CreateViewAsStep<Record>
DSL.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.static CreateViewAsStep<Record>
DSL.createOrReplaceView
(Table<?> view, Field<?>... fields) TheCREATE OR REPLACE VIEW
statement.static final @NotNull Name
Internal.createPathAlias
(Table<?> path, ForeignKey<?, ?> childPath, InverseForeignKey<?, ?> parentPath) Factory method for path aliases.DefaultDSLContext.createTable
(Table<?> table) static CreateTableElementListStep
DSL.createTable
(Table<?> table) TheCREATE TABLE
statement.DefaultDSLContext.createTableIfNotExists
(Table<?> table) static CreateTableElementListStep
DSL.createTableIfNotExists
(Table<?> table) TheCREATE TABLE IF NOT EXISTS
statement.DefaultDSLContext.createTemporaryTable
(Table<?> table) static CreateTableElementListStep
DSL.createTemporaryTable
(Table<?> table) TheCREATE TEMPORARY TABLE
statement.DefaultDSLContext.createTemporaryTableIfNotExists
(Table<?> table) static CreateTableElementListStep
DSL.createTemporaryTableIfNotExists
(Table<?> table) TheCREATE TEMPORARY TABLE IF NOT EXISTS
statement.static final @NotNull Trigger
Internal.createTrigger
(Schema schema, Table<?> table, List<Field<?>> fields, Name name, Comment comment, TriggerTime time, Set<TriggerEvent> events, TriggerExecution execution, Condition when, int actionOrder, Statement action) Factory method for trigger specifications.static final <R extends Record,
T, P extends UDTPathTableField<R, ?, T>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, Table<R> table, Class<P> returnType) static final <R extends Record,
T, P extends UDTPathTableField<R, ?, T>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, Table<R> table, String comment, Class<P> returnType) static final <R extends Record,
T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, Table<R> table, String comment, Class<P> returnType, Binding<T, U> binding) static final <R extends Record,
T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, Table<R> table, String comment, Class<P> returnType, Converter<T, U> converter) static final <R extends Record,
T, X, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, Table<R> table, String comment, Class<P> returnType, Converter<X, U> converter, Binding<T, X> binding) AbstractKeys.createUniqueKey
(Table<R> table, String name, TableField<R, ?>... fields) Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codeAbstractKeys.createUniqueKey
(Table<R> table, TableField<R, ?>... fields) Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codeInternal.createUniqueKey
(Table<R> table, String name, TableField<R, ?>... fields) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#9404] - Please re-generate your code.Internal.createUniqueKey
(Table<R> table, String name, TableField<R, ?>[] fields, boolean enforced) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#9404] - Please re-generate your code.Internal.createUniqueKey
(Table<R> table, Name name, TableField<R, ?>... fields) Factory method for unique keys.Internal.createUniqueKey
(Table<R> table, Name name, TableField<R, ?>[] fields, boolean enforced) Factory method for unique keys.static final <R extends Record,
ER extends EmbeddableRecord<ER>>
@NotNull UniqueKey<R>Internal.createUniqueKey
(Table<R> table, Name name, TableField<R, ER> embeddableField, boolean enforced) Factory method for unique keys.Internal.createUniqueKey
(Table<R> table, TableField<R, ?>... fields) Factory method for unique keys.DefaultDSLContext.createView
(Table<?> view, Collection<? extends Field<?>> fields) DefaultDSLContext.createView
(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createView
(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createView
(Table<?> view, Field<?>... fields) static CreateViewAsStep<Record>
DSL.createView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE VIEW
statement.static @NotNull CreateViewAsStep<Record>
DSL.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.static CreateViewAsStep<Record>
DSL.createView
(Table<?> view, Field<?>... fields) TheCREATE VIEW
statement.DefaultDSLContext.createViewIfNotExists
(Table<?> view, Collection<? extends Field<?>> fields) DefaultDSLContext.createViewIfNotExists
(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createViewIfNotExists
(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createViewIfNotExists
(Table<?> view, Field<?>... fields) static CreateViewAsStep<Record>
DSL.createViewIfNotExists
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE VIEW IF NOT EXISTS
statement.static @NotNull CreateViewAsStep<Record>
DSL.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.static CreateViewAsStep<Record>
DSL.createViewIfNotExists
(Table<?> view, Field<?>... fields) TheCREATE VIEW IF NOT EXISTS
statement.DefaultDSLContext.ddl
(Table[] tables, DDLExportConfiguration exportConfiguration) DefaultDSLContext.ddl
(Table<?> table, DDLExportConfiguration exportConfiguration) <R extends Record>
DeleteUsingStep<R>static <R extends Record>
@NotNull DeleteUsingStep<R>Create a new DSL delete statement.<R extends Record>
DeleteUsingStep<R>DefaultDSLContext.deleteFrom
(Table<R> table) static <R extends Record>
@NotNull DeleteUsingStep<R>DSL.deleteFrom
(Table<R> table) Create a new DSL delete statement.<R extends Record>
DeleteQuery<R>DefaultDSLContext.deleteQuery
(Table<R> table) DefaultDSLContext.dropMaterializedView
(Table<?> view) static DropViewFinalStep
DSL.dropMaterializedView
(Table<?> view) TheDROP MATERIALIZED VIEW
statement.DefaultDSLContext.dropMaterializedViewIfExists
(Table<?> view) static DropViewFinalStep
DSL.dropMaterializedViewIfExists
(Table<?> view) TheDROP MATERIALIZED VIEW IF EXISTS
statement.static DropTableStep
TheDROP TABLE
statement.DefaultDSLContext.dropTableIfExists
(Table<?> table) static DropTableStep
DSL.dropTableIfExists
(Table<?> table) TheDROP TABLE IF EXISTS
statement.DefaultDSLContext.dropTemporaryTable
(Table<?> table) static DropTableStep
DSL.dropTemporaryTable
(Table<?> table) TheDROP TEMPORARY TABLE
statement.DefaultDSLContext.dropTemporaryTableIfExists
(Table<?> table) static DropTableStep
DSL.dropTemporaryTableIfExists
(Table<?> table) TheDROP TEMPORARY TABLE IF EXISTS
statement.static DropViewFinalStep
TheDROP VIEW
statement.DefaultDSLContext.dropViewIfExists
(Table<?> view) static DropViewFinalStep
DSL.dropViewIfExists
(Table<?> view) TheDROP VIEW IF EXISTS
statement.DefaultDSLContext.fetch
(Table<R> table, Collection<? extends Condition> conditions) <R extends Record>
R<R extends Record>
RDefaultDSLContext.fetchAny
(Table<R> table, Collection<? extends Condition> conditions) <R extends Record>
R<R extends Record>
R<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Executor executor, Table<R> table) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Executor executor, Table<R> table, Collection<? extends Condition> conditions) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Executor executor, Table<R> table, Condition condition) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Executor executor, Table<R> table, Condition... conditions) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Table<R> table) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Table<R> table, Collection<? extends Condition> conditions) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Table<R> table, Condition condition) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Table<R> table, Condition... conditions) int
DefaultDSLContext.fetchCount
(Table<?> table) int
DefaultDSLContext.fetchCount
(Table<?> table, Collection<? extends Condition> conditions) int
DefaultDSLContext.fetchCount
(Table<?> table, Condition condition) int
DefaultDSLContext.fetchCount
(Table<?> table, Condition... conditions) boolean
DefaultDSLContext.fetchExists
(Table<?> table) boolean
DefaultDSLContext.fetchExists
(Table<?> table, Collection<? extends Condition> conditions) boolean
DefaultDSLContext.fetchExists
(Table<?> table, Condition condition) boolean
DefaultDSLContext.fetchExists
(Table<?> table, Condition... conditions) DefaultDSLContext.fetchLazy
(Table<R> table, Collection<? extends Condition> conditions) <R extends Record>
R<R extends Record>
RDefaultDSLContext.fetchOne
(Table<R> table, Collection<? extends Condition> conditions) <R extends Record>
R<R extends Record>
RDefaultDSLContext.fetchOptional
(Table<R> table) DefaultDSLContext.fetchOptional
(Table<R> table, Collection<? extends Condition> conditions) DefaultDSLContext.fetchOptional
(Table<R> table, Condition condition) DefaultDSLContext.fetchOptional
(Table<R> table, Condition... conditions) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Collection<? extends Condition> conditions) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition condition) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition... conditions) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21) <R extends Record>
RDefaultDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21, Condition c22) DefaultDSLContext.fetchStream
(Table<R> table) DefaultDSLContext.fetchStream
(Table<R> table, Collection<? extends Condition> conditions) DefaultDSLContext.fetchStream
(Table<R> table, Condition condition) DefaultDSLContext.fetchStream
(Table<R> table, Condition... conditions) <T> T
DefaultDSLContext.fetchValue
(Table<? extends Record1<T>> table) <T> List<T>
DefaultDSLContext.fetchValues
(Table<? extends Record1<T>> table) final void
ArrayRecordImpl.formatInsert
(Writer writer, Table<?> table, Field<?>... fields) final void
AssociativeArrayRecordImpl.formatInsert
(Writer writer, Table<?> table, Field<?>... fields) DefaultDSLContext.informationSchema
(Table<?> table) DefaultDSLContext.informationSchema
(Table<?>... tables) <R extends Record>
InsertSetStep<R>DefaultDSLContext.insertInto
(Table<R> into) <R extends Record>
InsertValuesStepN<R>DefaultDSLContext.insertInto
(Table<R> into, Collection<? extends Field<?>> fields) <R extends Record>
InsertValuesStepN<R>DefaultDSLContext.insertInto
(Table<R> into, Field<?>... fields) <R extends Record,
T1>
InsertValuesStep1<R,T1> DefaultDSLContext.insertInto
(Table<R> into, Field<T1> field1) <R extends Record,
T1, T2>
InsertValuesStep2<R,T1, T2> DefaultDSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2) <R extends Record,
T1, T2, T3>
InsertValuesStep3<R,T1, T2, T3> DefaultDSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3) <R extends Record,
T1, T2, T3, T4>
InsertValuesStep4<R,T1, T2, T3, T4> DefaultDSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) <R extends Record,
T1, T2, T3, T4, T5>
InsertValuesStep5<R,T1, T2, T3, T4, T5> DefaultDSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) <R extends Record,
T1, T2, T3, T4, T5, T6>
InsertValuesStep6<R,T1, T2, T3, T4, T5, T6> DefaultDSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) <R extends Record,
T1, T2, T3, T4, T5, T6, T7>
InsertValuesStep7<R,T1, T2, T3, T4, T5, T6, T7> DefaultDSLContext.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) <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8>
InsertValuesStep8<R,T1, T2, T3, T4, T5, T6, T7, T8> DefaultDSLContext.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) <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9>
InsertValuesStep9<R,T1, T2, T3, T4, T5, T6, T7, T8, T9> DefaultDSLContext.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) <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
InsertValuesStep10<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> DefaultDSLContext.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) <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
InsertValuesStep11<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> DefaultDSLContext.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) <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
InsertValuesStep12<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> DefaultDSLContext.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) <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
InsertValuesStep13<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> DefaultDSLContext.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) <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
InsertValuesStep14<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> DefaultDSLContext.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) <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
InsertValuesStep15<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> DefaultDSLContext.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) <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
InsertValuesStep16<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> DefaultDSLContext.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) <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
InsertValuesStep17<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> DefaultDSLContext.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) <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
InsertValuesStep18<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> DefaultDSLContext.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) <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
InsertValuesStep19<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> DefaultDSLContext.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) <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
InsertValuesStep20<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> DefaultDSLContext.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) <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
InsertValuesStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> DefaultDSLContext.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) <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
InsertValuesStep22<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> DefaultDSLContext.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) static <R extends Record>
@NotNull InsertSetStep<R>DSL.insertInto
(Table<R> into) Create a new DSL insert statement.static <R extends Record>
@NotNull InsertValuesStepN<R>DSL.insertInto
(Table<R> into, Collection<? extends Field<?>> fields) Create a new DSL insert statement.static <R extends Record>
@NotNull InsertValuesStepN<R>DSL.insertInto
(Table<R> into, Field<?>... fields) Create a new DSL insert statement.static <R extends Record,
T1>
@NotNull InsertValuesStep1<R,T1> DSL.insertInto
(Table<R> into, Field<T1> field1) Create a new DSL insert statement.static <R extends Record,
T1, T2>
@NotNull InsertValuesStep2<R,T1, T2> DSL.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2) Create a new DSL insert statement.static <R extends Record,
T1, T2, T3>
@NotNull InsertValuesStep3<R,T1, T2, T3> DSL.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3) Create a new DSL insert statement.static <R extends Record,
T1, T2, T3, T4>
@NotNull InsertValuesStep4<R,T1, T2, T3, T4> DSL.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Create a new DSL insert statement.static <R extends Record,
T1, T2, T3, T4, T5>
@NotNull InsertValuesStep5<R,T1, T2, T3, T4, T5> DSL.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.static <R extends Record,
T1, T2, T3, T4, T5, T6>
@NotNull InsertValuesStep6<R,T1, T2, T3, T4, T5, T6> DSL.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.static <R extends Record,
T1, T2, T3, T4, T5, T6, T7>
@NotNull InsertValuesStep7<R,T1, T2, T3, T4, T5, T6, T7> DSL.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.static <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull InsertValuesStep8<R,T1, T2, T3, T4, T5, T6, T7, T8> DSL.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.static <R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull InsertValuesStep9<R,T1, T2, T3, T4, T5, T6, T7, T8, T9> DSL.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.static <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> DSL.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.static <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> DSL.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.static <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> DSL.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.static <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> DSL.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.static <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> DSL.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.static <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> DSL.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.static <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> DSL.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.static <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> DSL.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.static <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> DSL.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.static <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> DSL.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.static <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> DSL.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.static <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> DSL.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.static <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> DSL.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Create a new DSL insert statement.<R extends Record>
InsertQuery<R>DefaultDSLContext.insertQuery
(Table<R> into) <R extends Record>
LoaderOptionsStep<R><R extends Record>
MergeUsingStep<R><R extends Record>
MergeKeyStepN<R>DefaultDSLContext.mergeInto
(Table<R> table, Collection<? extends Field<?>> fields) <R extends Record>
MergeKeyStepN<R><R extends Record,
T1>
MergeKeyStep1<R,T1> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2>
MergeKeyStep2<R,T1, T2> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3>
MergeKeyStep3<R,T1, T2, T3> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4>
MergeKeyStep4<R,T1, T2, T3, T4> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5>
MergeKeyStep5<R,T1, T2, T3, T4, T5> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6>
MergeKeyStep6<R,T1, T2, T3, T4, T5, T6> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7>
MergeKeyStep7<R,T1, T2, T3, T4, T5, T6, T7> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8>
MergeKeyStep8<R,T1, T2, T3, T4, T5, T6, T7, T8> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9>
MergeKeyStep9<R,T1, T2, T3, T4, T5, T6, T7, T8, T9> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
MergeKeyStep10<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
MergeKeyStep11<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
MergeKeyStep12<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
MergeKeyStep13<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
MergeKeyStep14<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
MergeKeyStep15<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
MergeKeyStep16<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
MergeKeyStep17<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
MergeKeyStep18<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
MergeKeyStep19<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
MergeKeyStep20<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
MergeKeyStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> DefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
MergeKeyStep22<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>