@NotNull AlterTableAddStep |
AlterTableStep.add(Name field,
DataType<?> type) |
Add an ADD COLUMN clause to the ALTER TABLE
statement.
|
@NotNull AlterTableAddStep |
AlterTableStep.addColumn(Name field,
DataType<?> type) |
Add an ADD COLUMN clause to the ALTER TABLE
statement.
|
@NotNull AlterTableAddStep |
AlterTableStep.addColumnIfNotExists(Name field,
DataType<?> type) |
Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE
statement.
|
@NotNull AlterTableAddStep |
AlterTableStep.addIfNotExists(Name field,
DataType<?> type) |
Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE
statement.
|
@NotNull AlterTableFinalStep |
AlterTableAddStep.after(Name columnName) |
Add a AFTER clause to ALTER TABLE ..
|
@NotNull AlterTableAlterStep<Object> |
AlterTableStep.alter(Name field) |
Add an ALTER COLUMN clause to the ALTER TABLE
statement.
|
@NotNull AlterTableAlterStep<Object> |
AlterTableStep.alterColumn(Name field) |
Add an ALTER COLUMN clause to the ALTER TABLE
statement.
|
@NotNull AlterTableAlterConstraintStep |
AlterTableStep.alterConstraint(Name constraint) |
Add an ALTER CONSTRAINT clause to the ALTER TABLE
statement.
|
@NotNull AlterDatabaseStep |
DSLContext.alterDatabase(Name database) |
The ALTER DATABASE statement.
|
@NotNull AlterDatabaseStep |
DSLContext.alterDatabaseIfExists(Name database) |
The ALTER DATABASE IF EXISTS statement.
|
<T> @NotNull AlterDomainStep<T> |
DSLContext.alterDomain(Name domain) |
The ALTER DOMAIN statement.
|
<T> @NotNull AlterDomainStep<T> |
DSLContext.alterDomainIfExists(Name domain) |
The ALTER DOMAIN IF EXISTS statement.
|
@NotNull AlterIndexOnStep |
DSLContext.alterIndex(Name index) |
Create a new DSL ALTER INDEX statement.
|
@NotNull AlterIndexStep |
DSLContext.alterIndexIfExists(Name index) |
Create a new DSL ALTER INDEX statement.
|
@NotNull AlterSchemaStep |
DSLContext.alterSchema(Name schema) |
The ALTER SCHEMA statement.
|
@NotNull AlterSchemaStep |
DSLContext.alterSchemaIfExists(Name schema) |
The ALTER SCHEMA IF EXISTS statement.
|
@NotNull AlterSequenceStep<BigInteger> |
DSLContext.alterSequence(Name sequence) |
Create a new DSL ALTER SEQUENCE statement.
|
@NotNull AlterSequenceStep<BigInteger> |
DSLContext.alterSequenceIfExists(Name sequence) |
Create a new DSL ALTER SEQUENCE statement.
|
@NotNull AlterTableStep |
DSLContext.alterTable(Name table) |
Create a new DSL ALTER TABLE statement.
|
@NotNull AlterTableStep |
DSLContext.alterTableIfExists(Name table) |
Create a new DSL ALTER TABLE statement.
|
@NotNull AlterTypeStep |
DSLContext.alterType(Name type) |
Create a new DSL ALTER TYPE statement.
|
@NotNull AlterViewStep |
DSLContext.alterView(Name view) |
Create a new DSL ALTER VIEW statement.
|
@NotNull AlterViewStep |
DSLContext.alterViewIfExists(Name view) |
Create a new DSL ALTER VIEW statement.
|
@NotNull Name |
Name.append(Name name) |
Appends name (all of its parts()) to this name. |
@NotNull Field<T> |
Field.as(Name alias) |
Create an alias for this field.
|
@NotNull Table<R> |
Table.as(Name alias) |
Create an alias for this table.
|
@NotNull Table<R> |
Table.as(Name alias,
BiFunction<? super Field<?>,? super Integer,? extends Name> aliasFunction) |
Deprecated.
|
@NotNull Table<R> |
Table.as(Name alias,
Function<? super Field<?>,? extends Name> aliasFunction) |
Deprecated.
|
@NotNull Table<R> |
Table.as(Name alias,
Name... fieldAliases) |
Create an alias for this table and its fields.
|
@NotNull Table<R> |
TableLike.asTable(Name alias) |
The underlying aliased table representation of this object.
|
@NotNull Table<R> |
TableLike.asTable(Name alias,
Name... fieldAliases) |
The underlying aliased table representation of this object.
|
@NotNull Table<R> |
Table.at(Name link) |
A table reference of this table at a given Link. |
@NotNull AlterTableFinalStep |
AlterTableAddStep.before(Name columnName) |
Add a BEFORE clause to ALTER TABLE ..
|
boolean |
Record.changed(Name fieldName) |
Check if a field's value has been changed from its original as fetched
from the database.
|
void |
Record.changed(Name fieldName,
boolean changed) |
Set this record's internal changed flag to the supplied value for a given
field.
|
@NotNull Field<String> |
Field.collate(Name collation) |
Apply a collation operator to this column expression.
|
@NotNull CreateTableColumnStep |
CreateTableColumnStep.column(Name field,
DataType<?> type) |
Add a column to the column list of the CREATE TABLE statement.
|
@NotNull JSONTableColumnForOrdinalityStep |
JSONTableColumnsFirstStep.column(Name name) |
Add a column to the COLUMNS clause of the
JSON_TABLE expression.
|
@NotNull JSONTableColumnPathStep |
JSONTableColumnsFirstStep.column(Name name,
DataType<?> type) |
Add a column to the COLUMNS clause of the
JSON_TABLE expression.
|
@NotNull XMLTableColumnForOrdinalityStep |
XMLTableColumnsFirstStep.column(Name name) |
Add a column to the COLUMNS clause of the
XMLTABLE expression.
|
@NotNull XMLTableColumnPathStep |
XMLTableColumnsFirstStep.column(Name name,
DataType<?> type) |
Add a column to the COLUMNS clause of the
XMLTABLE expression.
|
@NotNull CreateTableColumnStep |
CreateTableColumnStep.columns(Name... fields) |
Add several columns to the column list of the CREATE TABLE
statement.
|
@NotNull CommentOnIsStep |
DSLContext.commentOnColumn(Name columnName) |
Create a new DSL COMMENT ON COLUMN statement.
|
@NotNull CommentOnIsStep |
DSLContext.commentOnTable(Name tableName) |
Create a new DSL COMMENT ON TABLE statement.
|
@NotNull CommentOnIsStep |
DSLContext.commentOnView(Name viewName) |
Create a new DSL COMMENT ON VIEW statement.
|
int |
Name.compareTo(Name o) |
|
@NotNull CreateDatabaseFinalStep |
DSLContext.createDatabase(Name database) |
The CREATE DATABASE statement.
|
@NotNull CreateDatabaseFinalStep |
DSLContext.createDatabaseIfNotExists(Name database) |
The CREATE DATABASE IF NOT EXISTS statement.
|
@NotNull CreateDomainAsStep |
DSLContext.createDomain(Name domain) |
The CREATE DOMAIN statement.
|
@NotNull CreateDomainAsStep |
DSLContext.createDomainIfNotExists(Name domain) |
The CREATE DOMAIN IF NOT EXISTS statement.
|
@NotNull CreateTableColumnStep |
DSLContext.createGlobalTemporaryTable(Name table) |
Create a new DSL CREATE GLOBAL TEMPORARY TABLE statement.
|
@NotNull CreateIndexStep |
DSLContext.createIndex(Name index) |
Create a new DSL CREATE INDEX statement.
|
@NotNull CreateIndexStep |
DSLContext.createIndexIfNotExists(Name index) |
Create a new DSL CREATE INDEX IF NOT EXISTS statement.
|
@NotNull CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction) |
Deprecated.
|
@NotNull CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction) |
Deprecated.
|
@NotNull CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(Name view,
Name... fields) |
Create a new DSL CREATE OR REPLACE VIEW statement.
|
@NotNull CreateSchemaFinalStep |
DSLContext.createSchema(Name schema) |
The CREATE SCHEMA statement.
|
@NotNull CreateSchemaFinalStep |
DSLContext.createSchemaIfNotExists(Name schema) |
The CREATE SCHEMA IF NOT EXISTS statement.
|
@NotNull CreateSequenceFlagsStep |
DSLContext.createSequence(Name sequence) |
The CREATE SEQUENCE statement.
|
@NotNull CreateSequenceFlagsStep |
DSLContext.createSequenceIfNotExists(Name sequence) |
The CREATE SEQUENCE IF NOT EXISTS statement.
|
@NotNull CreateTableColumnStep |
DSLContext.createTable(Name table) |
Create a new DSL CREATE TABLE statement.
|
@NotNull CreateTableColumnStep |
DSLContext.createTableIfNotExists(Name table) |
Create a new DSL CREATE TABLE statement.
|
@NotNull CreateTableColumnStep |
DSLContext.createTemporaryTable(Name table) |
Create a new DSL CREATE TEMPORARY TABLE statement.
|
@NotNull CreateTableColumnStep |
DSLContext.createTemporaryTableIfNotExists(Name table) |
Create a new DSL CREATE TEMPORARY TABLE IF NOT EXISTS statement.
|
@NotNull CreateTypeStep |
DSLContext.createType(Name type) |
Create a new DSL CREATE TYPE statement.
|
@NotNull CreateIndexStep |
DSLContext.createUniqueIndex(Name index) |
Create a new DSL CREATE UNIQUE INDEX statement.
|
@NotNull CreateIndexStep |
DSLContext.createUniqueIndexIfNotExists(Name index) |
Create a new DSL CREATE UNIQUE INDEX statement.
|
@NotNull CreateViewAsStep<Record> |
DSLContext.createView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction) |
Deprecated.
|
@NotNull CreateViewAsStep<Record> |
DSLContext.createView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction) |
Deprecated.
|
@NotNull CreateViewAsStep<Record> |
DSLContext.createView(Name view,
Name... fields) |
Create a new DSL CREATE VIEW statement.
|
@NotNull CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction) |
Deprecated.
|
@NotNull CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction) |
Deprecated.
|
@NotNull CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Name view,
Name... fields) |
Create a new DSL CREATE VIEW statement.
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.crossApply(Name name) |
CROSS APPLY a table to this table.
|
@NotNull Table<Record> |
Table.crossApply(Name name) |
CROSS APPLY a table to this table.
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.crossJoin(Name name) |
Convenience method to CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(Name) |
@NotNull Table<Record> |
Table.crossJoin(Name name) |
CROSS JOIN a table to this table.
|
@NotNull BigInteger |
DSLContext.currval(Name sequence) |
Convenience method to fetch the CURRVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
@Nullable DataType<?> |
RecordType.dataType(Name fieldName) |
Get the data type for a given field name.
|
@Nullable DataType<?> |
Row.dataType(Name fieldName) |
Get the data type for a given field name.
|
@NotNull AlterTableDropStep |
AlterTableStep.drop(Name field) |
Add an DROP COLUMN clause to the ALTER TABLE
statement.
|
@NotNull AlterTableDropStep |
AlterTableStep.drop(Name... fields) |
Add an DROP COLUMN clause to the ALTER TABLE
statement.
|
@NotNull AlterTableDropStep |
AlterTableStep.dropColumn(Name field) |
Add an DROP COLUMN clause to the ALTER TABLE
statement.
|
@NotNull AlterTableDropStep |
AlterTableStep.dropColumnIfExists(Name field) |
Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE
statement.
|
@NotNull AlterTableDropStep |
AlterTableStep.dropColumns(Name... fields) |
Add an DROP COLUMN clause to the ALTER TABLE
statement.
|
@NotNull AlterDomainDropConstraintCascadeStep |
AlterDomainStep.dropConstraint(Name dropConstraint) |
Add the DROP CONSTRAINT clause to the ALTER DOMAIN statement.
|
@NotNull AlterTableDropStep |
AlterTableStep.dropConstraint(Name constraint) |
Add a DROP CONSTRAINT clause to the ALTER TABLE
statement.
|
@NotNull AlterDomainDropConstraintCascadeStep |
AlterDomainStep.dropConstraintIfExists(Name dropConstraint) |
Add the DROP CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.
|
@NotNull AlterTableDropStep |
AlterTableStep.dropConstraintIfExists(Name constraint) |
Add a DROP CONSTRAINT IF EXISTS clause to the ALTER TABLE
statement.
|
@NotNull DropDatabaseFinalStep |
DSLContext.dropDatabase(Name database) |
The DROP DATABASE statement.
|
@NotNull DropDatabaseFinalStep |
DSLContext.dropDatabaseIfExists(Name database) |
The DROP DATABASE IF EXISTS statement.
|
@NotNull DropDomainCascadeStep |
DSLContext.dropDomain(Name domain) |
The DROP DOMAIN statement.
|
@NotNull DropDomainCascadeStep |
DSLContext.dropDomainIfExists(Name domain) |
The DROP DOMAIN IF EXISTS statement.
|
@NotNull AlterTableDropStep |
AlterTableStep.dropForeignKey(Name constraint) |
Add a DROP FOREIGN KEY clause to the ALTER TABLE
statement.
|
@NotNull AlterTableDropStep |
AlterTableStep.dropIfExists(Name field) |
Add an DROP COLUMN IF EXISTS clause to the
ALTER TABLE statement.
|
@NotNull DropIndexOnStep |
DSLContext.dropIndex(Name index) |
Create a new DSL DROP INDEX statement.
|
@NotNull DropIndexOnStep |
DSLContext.dropIndexIfExists(Name index) |
Create a new DSL DROP INDEX IF EXISTS statement.
|
@NotNull AlterTableDropStep |
AlterTableStep.dropPrimaryKey(Name constraint) |
Add a DROP PRIMARY KEY clause to the ALTER TABLE
statement.
|
@NotNull DropSchemaStep |
DSLContext.dropSchema(Name schema) |
The DROP SCHEMA statement.
|
@NotNull DropSchemaStep |
DSLContext.dropSchemaIfExists(Name schema) |
The DROP SCHEMA IF EXISTS statement.
|
@NotNull DropSequenceFinalStep |
DSLContext.dropSequence(Name sequence) |
The DROP SEQUENCE statement.
|
@NotNull DropSequenceFinalStep |
DSLContext.dropSequenceIfExists(Name sequence) |
The DROP SEQUENCE IF EXISTS statement.
|
@NotNull DropTableStep |
DSLContext.dropTable(Name table) |
Create a new DSL DROP TABLE statement.
|
@NotNull DropTableStep |
DSLContext.dropTableIfExists(Name table) |
Create a new DSL DROP TABLE IF EXISTS statement.
|
@NotNull DropTableStep |
DSLContext.dropTemporaryTable(Name table) |
Create a new DSL DROP TEMPORARY TABLE statement.
|
@NotNull DropTableStep |
DSLContext.dropTemporaryTableIfExists(Name table) |
Create a new DSL DROP TEMPORARY TABLE IF EXISTS statement.
|
@NotNull DropTypeStep |
DSLContext.dropType(Name type) |
Create a new DSL DROP TYPE statement.
|
@NotNull DropTypeStep |
DSLContext.dropType(Name... type) |
Create a new DSL DROP TYPE statement.
|
@NotNull DropTypeStep |
DSLContext.dropTypeIfExists(Name type) |
Create a new DSL DROP TYPE statement.
|
@NotNull DropTypeStep |
DSLContext.dropTypeIfExists(Name... type) |
Create a new DSL DROP TYPE statement.
|
@NotNull AlterTableDropStep |
AlterTableStep.dropUnique(Name constraint) |
Add a DROP UNIQUE clause to the ALTER TABLE
statement.
|
@NotNull DropViewFinalStep |
DSLContext.dropView(Name view) |
Create a new DSL DROP VIEW statement.
|
@NotNull DropViewFinalStep |
DSLContext.dropViewIfExists(Name view) |
Create a new DSL DROP VIEW IF EXISTS statement.
|
boolean |
Name.equalsIgnoreCase(Name other) |
Compare this name with another one ignoring case.
|
@NotNull Asterisk |
Asterisk.except(Name... fieldNames) |
The asterisk (*) to be used in SELECT clauses.
|
@NotNull QualifiedAsterisk |
QualifiedAsterisk.except(Name... fieldNames) |
The qualified asterisk (t.* EXCEPT (fields)) expression to
be used in SELECT clauses.
|
@NotNull List<?> |
ResultQuery.fetch(Name fieldName) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull List<U> |
ResultQuery.fetch(Name fieldName,
Class<? extends U> type) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull List<U> |
ResultQuery.fetch(Name fieldName,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field name from the
generated result.
|
@Nullable Object |
ResultQuery.fetchAny(Name fieldName) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchAny(Name fieldName,
Class<? extends U> type) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchAny(Name fieldName,
Converter<?,? extends U> converter) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
@NotNull Object[] |
ResultQuery.fetchArray(Name fieldName) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull U[] |
ResultQuery.fetchArray(Name fieldName,
Class<? extends U> type) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull U[] |
ResultQuery.fetchArray(Name fieldName,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field name from the
generated result.
|
@NotNull Map<?,Result<R>> |
ResultQuery.fetchGroups(Name keyFieldName) |
Execute the query and return a Map with one of the result's
columns as key and a list of corresponding records as value. |
@NotNull Map<Record,Result<R>> |
ResultQuery.fetchGroups(Name[] keyFieldNames) |
Execute the query and return a Map with the result grouped by the
given keys. |
<E> @NotNull Map<Record,List<E>> |
ResultQuery.fetchGroups(Name[] keyFieldNames,
Class<? extends E> type) |
Execute the query and return a Map with results grouped by the
given keys and mapped into the given entity type. |
@NotNull Map<Record,Result<Record>> |
ResultQuery.fetchGroups(Name[] keyFieldNames,
Name[] valueFieldNames) |
Execute the query and return a Map with the result grouped by the
given keys. |
<E> @NotNull Map<Record,List<E>> |
ResultQuery.fetchGroups(Name[] keyFieldNames,
RecordMapper<? super R,E> mapper) |
Execute the query and return a Map with results grouped by the
given keys and mapped by the given mapper. |
<E> @NotNull Map<?,List<E>> |
ResultQuery.fetchGroups(Name keyFieldName,
Class<? extends E> type) |
Return a Map with results grouped by the given key and mapped
into the given entity type. |
@NotNull Map<?,List<?>> |
ResultQuery.fetchGroups(Name keyFieldName,
Name valueFieldName) |
Execute the query and return a Map with one of the result's
columns as key and another one of the result's columns as value |
<E> @NotNull Map<?,List<E>> |
ResultQuery.fetchGroups(Name keyFieldName,
RecordMapper<? super R,E> mapper) |
Return a Map with results grouped by the given key and mapped by
the given mapper. |
@NotNull Map<?,R> |
ResultQuery.fetchMap(Name keyFieldName) |
Execute the query and return a Map with one of the result's
columns as key and the corresponding records as value. |
@NotNull Map<Record,R> |
ResultQuery.fetchMap(Name[] keyFieldNames) |
Execute the query and return a Map with keys as a map key and the
corresponding record as value. |
<E> @NotNull Map<List<?>,E> |
ResultQuery.fetchMap(Name[] keyFieldNames,
Class<? extends E> type) |
Execute the query and return a Map with results grouped by the
given keys and mapped into the given entity type. |
@NotNull Map<Record,Record> |
ResultQuery.fetchMap(Name[] keyFieldNames,
Name[] valueFieldNames) |
Execute the query and return a Map with keys as a map key and the
corresponding record as value. |
<E> @NotNull Map<List<?>,E> |
ResultQuery.fetchMap(Name[] keyFieldNames,
RecordMapper<? super R,E> mapper) |
Execute the query and return a Map with results grouped by the
given keys and mapped by the given mapper. |
<E> @NotNull Map<?,E> |
ResultQuery.fetchMap(Name keyFieldName,
Class<? extends E> type) |
Execute the query and return a Map with results grouped by the
given key and mapped into the given entity type. |
@NotNull Map<?,?> |
ResultQuery.fetchMap(Name keyFieldName,
Name valueFieldName) |
Execute the query and return a Map with one of the result's
columns as key and another one of the result's columns as value |
<E> @NotNull Map<?,E> |
ResultQuery.fetchMap(Name keyFieldName,
RecordMapper<? super R,E> mapper) |
Execute the query and return a Map with results grouped by the
given key and mapped by the given mapper. |
@Nullable Object |
ResultQuery.fetchOne(Name fieldName) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchOne(Name fieldName,
Class<? extends U> type) |
Execute the query and return at most one resulting value for a field name
from the generated result.
|
<U> U |
ResultQuery.fetchOne(Name fieldName,
Converter<?,? extends U> converter) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
@NotNull Optional<?> |
ResultQuery.fetchOptional(Name fieldName) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> @NotNull Optional<U> |
ResultQuery.fetchOptional(Name fieldName,
Class<? extends U> type) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> @NotNull Optional<U> |
ResultQuery.fetchOptional(Name fieldName,
Converter<?,? extends U> converter) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
@NotNull Set<?> |
ResultQuery.fetchSet(Name fieldName) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull Set<U> |
ResultQuery.fetchSet(Name fieldName,
Class<? extends U> type) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull Set<U> |
ResultQuery.fetchSet(Name fieldName,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field name from the
generated result.
|
@Nullable Object |
ResultQuery.fetchSingle(Name fieldName) |
Execute the query and return exactly one resulting value for a field name
from the generated result.
|
<U> U |
ResultQuery.fetchSingle(Name fieldName,
Class<? extends U> type) |
Execute the query and return exactly one resulting value for a field name
from the generated result.
|
<U> U |
ResultQuery.fetchSingle(Name fieldName,
Converter<?,? extends U> converter) |
Execute the query and return exactly one resulting value for a field name
from the generated result.
|
@Nullable Field<?> |
Cursor.field(Name name) |
Get a specific qualified field from this Cursor.
|
@Nullable Field<?> |
Record.field(Name name) |
Get a specific qualified field from this Record.
|
@Nullable Field<?> |
RecordType.field(Name fieldName) |
Get a specific qualified field from this record type.
|
<T> @Nullable Field<T> |
RecordType.field(Name fieldName,
Class<T> type) |
Get a specific field from this record type coerced to type.
|
<T> @Nullable Field<T> |
RecordType.field(Name fieldName,
DataType<T> dataType) |
Get a specific field from this record type coerced to dataType.
|
@Nullable Field<?> |
Result.field(Name name) |
Get a specific field from this Result.
|
<T> @Nullable Field<T> |
Result.field(Name name,
Class<T> type) |
Get a specific field from this Result, coerced to type.
|
<T> @Nullable Field<T> |
Result.field(Name name,
DataType<T> dataType) |
Get a specific field from this Result, coerced to dataType.
|
@Nullable Field<?> |
Row.field(Name fieldName) |
Get a specific field from this row.
|
<T> @Nullable Field<T> |
Row.field(Name fieldName,
Class<T> type) |
Get a specific field from this row and coerce it to type.
|
<T> @Nullable Field<T> |
Row.field(Name fieldName,
DataType<T> dataType) |
Get a specific field from this row and coerce it to dataType.
|
@Nullable Field<?> |
TableLike.field(Name name) |
Get a specific field from this table, if this table knows its field
references.
|
<T> @Nullable Field<T> |
TableLike.field(Name name,
Class<T> type) |
Get a specific field from this table and coerce it to type,
if this table knows its field references.
|
<T> @Nullable Field<T> |
TableLike.field(Name name,
DataType<T> dataType) |
Get a specific field from this table and coerce it to
dataType, if this table knows its field references.
|
@Nullable Field<?> |
UDT.field(Name name) |
Get a specific field from this UDT.
|
@NotNull Field<?>[] |
Cursor.fields(Name... fieldNames) |
Get all fields from this Cursor, providing some field names.
|
@NotNull DerivedColumnList1 |
Name.fields(Name fieldName1) |
|
@NotNull DerivedColumnList |
Name.fields(Name... fieldNames) |
|
@NotNull DerivedColumnList2 |
Name.fields(Name fieldName1,
Name fieldName2) |
|
@NotNull DerivedColumnList3 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3) |
|
@NotNull DerivedColumnList4 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4) |
|
@NotNull DerivedColumnList5 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5) |
|
@NotNull DerivedColumnList6 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6) |
|
@NotNull DerivedColumnList7 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7) |
|
@NotNull DerivedColumnList8 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8) |
|
@NotNull DerivedColumnList9 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9) |
|
@NotNull DerivedColumnList10 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9,
Name fieldName10) |
|
@NotNull DerivedColumnList11 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9,
Name fieldName10,
Name fieldName11) |
|
@NotNull DerivedColumnList12 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9,
Name fieldName10,
Name fieldName11,
Name fieldName12) |
|
@NotNull DerivedColumnList13 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9,
Name fieldName10,
Name fieldName11,
Name fieldName12,
Name fieldName13) |
|
@NotNull DerivedColumnList14 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9,
Name fieldName10,
Name fieldName11,
Name fieldName12,
Name fieldName13,
Name fieldName14) |
|
@NotNull DerivedColumnList15 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9,
Name fieldName10,
Name fieldName11,
Name fieldName12,
Name fieldName13,
Name fieldName14,
Name fieldName15) |
|
@NotNull DerivedColumnList16 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9,
Name fieldName10,
Name fieldName11,
Name fieldName12,
Name fieldName13,
Name fieldName14,
Name fieldName15,
Name fieldName16) |
|
@NotNull DerivedColumnList17 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9,
Name fieldName10,
Name fieldName11,
Name fieldName12,
Name fieldName13,
Name fieldName14,
Name fieldName15,
Name fieldName16,
Name fieldName17) |
|
@NotNull DerivedColumnList18 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9,
Name fieldName10,
Name fieldName11,
Name fieldName12,
Name fieldName13,
Name fieldName14,
Name fieldName15,
Name fieldName16,
Name fieldName17,
Name fieldName18) |
|
@NotNull DerivedColumnList19 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9,
Name fieldName10,
Name fieldName11,
Name fieldName12,
Name fieldName13,
Name fieldName14,
Name fieldName15,
Name fieldName16,
Name fieldName17,
Name fieldName18,
Name fieldName19) |
|
@NotNull DerivedColumnList20 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9,
Name fieldName10,
Name fieldName11,
Name fieldName12,
Name fieldName13,
Name fieldName14,
Name fieldName15,
Name fieldName16,
Name fieldName17,
Name fieldName18,
Name fieldName19,
Name fieldName20) |
|
@NotNull DerivedColumnList21 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9,
Name fieldName10,
Name fieldName11,
Name fieldName12,
Name fieldName13,
Name fieldName14,
Name fieldName15,
Name fieldName16,
Name fieldName17,
Name fieldName18,
Name fieldName19,
Name fieldName20,
Name fieldName21) |
|
@NotNull DerivedColumnList22 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9,
Name fieldName10,
Name fieldName11,
Name fieldName12,
Name fieldName13,
Name fieldName14,
Name fieldName15,
Name fieldName16,
Name fieldName17,
Name fieldName18,
Name fieldName19,
Name fieldName20,
Name fieldName21,
Name fieldName22) |
|
@NotNull Field<?>[] |
Record.fields(Name... fieldNames) |
Get all fields from this Record, providing some field names.
|
@NotNull Field<?>[] |
RecordType.fields(Name... fieldNames) |
Get all fields from this record type, providing some field names.
|
@NotNull Field<?>[] |
Result.fields(Name... fieldNames) |
Get all fields from this Result, providing some field names.
|
@NotNull Field<?>[] |
Row.fields(Name... fieldNames) |
Get all fields from this row, providing some field names.
|
@NotNull Field<?>[] |
TableLike.fields(Name... fieldNames) |
Get all fields from this table, providing some field names, if this table
knows its field references.
|
@Nullable Field<?>[] |
UDT.fields(Name... fieldNames) |
Get all fields from this UDT, providing some field names.
|
@NotNull ConstraintForeignKeyReferencesStep1<?> |
ConstraintTypeStep.foreignKey(Name field1) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStepN |
ConstraintTypeStep.foreignKey(Name... fields) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep2<?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep3<?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep4<?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep5<?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep6<?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep7<?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep8<?,?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep9<?,?,?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep10<?,?,?,?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep11<?,?,?,?,?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep12<?,?,?,?,?,?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep13<?,?,?,?,?,?,?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep14<?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15,
Name field16) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15,
Name field16,
Name field17) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15,
Name field16,
Name field17,
Name field18) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15,
Name field16,
Name field17,
Name field18,
Name field19) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15,
Name field16,
Name field17,
Name field18,
Name field19,
Name field20) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15,
Name field16,
Name field17,
Name field18,
Name field19,
Name field20,
Name field21) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
@NotNull ConstraintForeignKeyReferencesStep22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15,
Name field16,
Name field17,
Name field18,
Name field19,
Name field20,
Name field21,
Name field22) |
Add a FOREIGN KEY clause to the CONSTRAINT.
|
void |
Record.from(Object source,
Name... fieldNames) |
Load data into this record from a source, providing some field names.
|
@NotNull SelectJoinStep<R> |
SelectFromStep.from(Name name) |
Add a FROM clause to the query.
|
@NotNull UpdateWhereStep<R> |
UpdateFromStep.from(Name name) |
Add a FROM clause to the query.
|
void |
Record.fromArray(Object[] array,
Name... fieldNames) |
Load data from an array into this record, providing some fields names.
|
void |
Record.fromMap(Map<String,?> map,
Name... fieldNames) |
Load data from a map into this record, providing some field names.
|
@NotNull SelectOnStep<R> |
SelectJoinStep.fullJoin(Name name) |
|
@NotNull TableOnStep<Record> |
Table.fullJoin(Name name) |
FULL OUTER JOIN a table to this table.
|
@NotNull SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(Name name) |
|
@NotNull TableOnStep<Record> |
Table.fullOuterJoin(Name name) |
FULL OUTER JOIN a table to this table.
|
@Nullable Object |
Record.get(Name fieldName) |
Get a value from this Record, providing a field name.
|
<U> U |
Record.get(Name fieldName,
Class<? extends U> type) |
Get a converted value from this Record, providing a field name.
|
<U> U |
Record.get(Name fieldName,
Converter<?,? extends U> converter) |
Get a converted value from this Record, providing a field name.
|
@NotNull Catalog |
Meta.getCatalog(Name name) |
Get a catalog object by name from the underlying meta data source, or
null if no such object exists.
|
@Nullable Domain<?> |
Schema.getDomain(Name name) |
Get a domain by its qualified or unqualified name in this schema, or
null if no such domain exists.
|
@NotNull List<Domain<?>> |
Meta.getDomains(Name name) |
Get all domain objects by name from the underlying meta data source.
|
@Nullable Schema |
Catalog.getSchema(Name name) |
Get a schema by its qualified or unqualified name in this catalog, or
null if no such schema exists.
|
@NotNull List<Schema> |
Meta.getSchemas(Name name) |
Get all schema objects by name from the underlying meta data source.
|
@Nullable Sequence<?> |
Schema.getSequence(Name name) |
Get a sequence by its qualified or unqualified name in this schema, or
null if no such sequence exists.
|
@NotNull List<Sequence<?>> |
Meta.getSequences(Name name) |
Get all sequence objects by name from the underlying meta data source.
|
@Nullable Table<?> |
Schema.getTable(Name name) |
Get a table by its qualified or unqualified name in this schema, or
null if no such table exists.
|
@NotNull List<Table<?>> |
Meta.getTables(Name name) |
Get all table objects by name from the underlying meta data source.
|
@Nullable UDT<?> |
Schema.getUDT(Name name) |
Get a UDT by its qualified or unqualified name in this schema, or
null if no such UDT exists.
|
Object |
Record.getValue(Name fieldName) |
Get a value from this Record, providing a field name.
|
<T> T |
Record.getValue(Name fieldName,
Class<? extends T> type) |
Get a converted value from this Record, providing a field name.
|
<U> U |
Record.getValue(Name fieldName,
Converter<?,? extends U> converter) |
Get a converted value from this Record, providing a field name.
|
@NotNull List<?> |
Result.getValues(Name fieldName) |
Convenience method to fetch all values for a given field.
|
<U> @NotNull List<U> |
Result.getValues(Name fieldName,
Class<? extends U> type) |
Convenience method to fetch all values for a given field.
|
<U> @NotNull List<U> |
Result.getValues(Name fieldName,
Converter<?,? extends U> converter) |
Convenience method to fetch all values for a given field.
|
@NotNull CreateIndexWhereStep |
CreateIndexIncludeStep.include(Name... fields) |
Add an INCLUDE clause to include columns in an index.
|
int |
Cursor.indexOf(Name fieldName) |
Get a field's index from this cursor.
|
int |
Record.indexOf(Name fieldName) |
Get a field's index from this record.
|
int |
RecordType.indexOf(Name fieldName) |
Get a field's index from this record type.
|
int |
Result.indexOf(Name fieldName) |
Get a field's index from this result.
|
int |
Row.indexOf(Name fieldName) |
Get a field's index from this row.
|
int |
TableLike.indexOf(Name fieldName) |
Get a field's index from this table.
|
int |
UDT.indexOf(Name fieldName) |
Get a field's index from this udt.
|
@NotNull SelectOnStep<R> |
SelectJoinStep.innerJoin(Name name) |
Convenience method to INNER JOIN a table to the last table
added to the FROM clause using
Table.join(Name). |
@NotNull TableOnStep<Record> |
Table.innerJoin(Name name) |
INNER JOIN a table to this table.
|
@NotNull Result<R> |
Result.intern(Name... fieldNames) |
Deprecated.
|
@NotNull ResultQuery<R> |
ResultQuery.intern(Name... fieldNames) |
Deprecated.
|
@NotNull Object[] |
Result.intoArray(Name fieldName) |
Return all values for a field name from the result.
|
<U> @NotNull U[] |
Result.intoArray(Name fieldName,
Class<? extends U> type) |
Return all values for a field name from the result.
|
<U> @NotNull U[] |
Result.intoArray(Name fieldName,
Converter<?,? extends U> converter) |
Return all values for a field name from the result.
|
@NotNull Map<?,Result<R>> |
Result.intoGroups(Name keyFieldName) |
Return a Map with one of the result's columns as key and a list
of corresponding records as value. |
@NotNull Map<Record,Result<R>> |
Result.intoGroups(Name[] keyFieldNames) |
Return a Map with the result grouped by the given keys. |
<E> @NotNull Map<Record,List<E>> |
Result.intoGroups(Name[] keyFieldNames,
Class<? extends E> type) |
Return a Map with results grouped by the given keys and mapped
into the given entity type. |
@NotNull Map<Record,Result<Record>> |
Result.intoGroups(Name[] keyFieldNames,
Name[] valueFieldNames) |
Return a Map with the result grouped by the given keys. |
<E> @NotNull Map<Record,List<E>> |
Result.intoGroups(Name[] keyFieldNames,
RecordMapper<? super R,E> mapper) |
Return a Map with results grouped by the given keys and mapped
into the given entity type. |
<E> @NotNull Map<?,List<E>> |
Result.intoGroups(Name keyFieldName,
Class<? extends E> type) |
Return a Map with results grouped by the given key and mapped
into the given entity type. |
@NotNull Map<?,List<?>> |
Result.intoGroups(Name keyFieldName,
Name valueFieldName) |
Return a Map with one of the result's columns as key and another
one of the result's columns as value. |
<E> @NotNull Map<?,List<E>> |
Result.intoGroups(Name keyFieldName,
RecordMapper<? super R,E> mapper) |
Return a Map with results grouped by the given key and mapped by
the given mapper. |
@NotNull Map<?,R> |
Result.intoMap(Name keyFieldName) |
Return a Map with one of the result's columns as key and the
corresponding records as value. |
@NotNull Map<Record,R> |
Result.intoMap(Name[] keyFieldNames) |
Return a Map with the given keys as a map key and the
corresponding record as value. |
<E> @NotNull Map<List<?>,E> |
Result.intoMap(Name[] keyFieldNames,
Class<? extends E> type) |
Return a Map with results grouped by the given keys and mapped
into the given entity type. |
@NotNull Map<Record,Record> |
Result.intoMap(Name[] keyFieldNames,
Name[] valueFieldNames) |
Return a Map with the given keys as a map key and the
corresponding record as value. |
<E> @NotNull Map<List<?>,E> |
Result.intoMap(Name[] keyFieldNames,
RecordMapper<? super R,E> mapper) |
Return a Map with results grouped by the given keys and mapped by
the given mapper. |
<E> @NotNull Map<?,E> |
Result.intoMap(Name keyFieldName,
Class<? extends E> type) |
Return a Map with results grouped by the given key and mapped
into the given entity type. |
@NotNull Map<?,?> |
Result.intoMap(Name keyFieldName,
Name valueFieldName) |
Return a Map with one of the result's columns as key and another
one of the result's columns as value |
<E> @NotNull Map<?,E> |
Result.intoMap(Name keyFieldName,
RecordMapper<? super R,E> mapper) |
Return a Map with results grouped by the given key and mapped by
the given mapper. |
@NotNull Set<?> |
Result.intoSet(Name fieldName) |
Return all values for a field name from the result.
|
<U> @NotNull Set<U> |
Result.intoSet(Name fieldName,
Class<? extends U> type) |
Return all values for a field name from the result.
|
<U> @NotNull Set<U> |
Result.intoSet(Name fieldName,
Converter<?,? extends U> converter) |
Return all values for a field name from the result.
|
@NotNull SelectOnStep<R> |
SelectJoinStep.join(Name name) |
Convenience method to INNER JOIN a table to the last table
added to the FROM clause using
Table.join(Name). |
@NotNull TableOnStep<Record> |
Table.join(Name name) |
INNER JOIN a table to this table.
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(Name name) |
|
@NotNull TablePartitionByStep<Record> |
Table.leftJoin(Name name) |
LEFT OUTER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
TableOuterJoinStep.leftJoin(Name name) |
LEFT OUTER JOIN a table to this table.
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(Name name) |
|
@NotNull TablePartitionByStep<Record> |
Table.leftOuterJoin(Name name) |
LEFT OUTER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(Name name) |
LEFT OUTER JOIN a table to this table.
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalFullOuterJoin(Name name) |
|
@NotNull Table<Record> |
Table.naturalFullOuterJoin(Name name) |
NATURAL FULL OUTER JOIN a table to this table.
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalJoin(Name name) |
Convenience method to NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(Name) |
@NotNull Table<Record> |
Table.naturalJoin(Name name) |
NATURAL JOIN a table to this table.
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(Name name) |
|
@NotNull Table<Record> |
Table.naturalLeftOuterJoin(Name name) |
NATURAL LEFT OUTER JOIN a table to this table.
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(Name name) |
|
@NotNull Table<Record> |
Table.naturalRightOuterJoin(Name name) |
NATURAL RIGHT OUTER JOIN a table to this table.
|
@NotNull BigInteger |
DSLContext.nextval(Name sequence) |
Convenience method to fetch the NEXTVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
@NotNull AlterIndexStep |
AlterIndexOnStep.on(Name tableName) |
Specify the table expression on which to alter an index.
|
@NotNull CreateIndexIncludeStep |
CreateIndexStep.on(Name tableName,
Collection<? extends Name> fieldNames) |
Specify the table and column expressions on which to create an index.
|
@NotNull CreateIndexIncludeStep |
CreateIndexStep.on(Name tableName,
Name... fieldNames) |
Specify the table and column expressions on which to create an index.
|
@NotNull DropIndexCascadeStep |
DropIndexOnStep.on(Name tableName) |
Specify the table expression on which to drop an index.
|
@NotNull GrantToStep |
GrantOnStep.on(Name on) |
Add the ON clause to the GRANT statement.
|
@NotNull RevokeFromStep |
RevokeOnStep.on(Name on) |
Add the ON clause to the REVOKE statement.
|
@NotNull InsertOnConflictDoUpdateStep<R> |
InsertOnDuplicateStep.onConflictOnConstraint(Name constraint) |
Add a ON CONFLICT ON CONSTRAINT clause to this INSERT statement.
|
void |
InsertQuery.onConflictOnConstraint(Name constraint) |
Whether use a ON CONFLICT or
ON CONFLICT ON CONSTRAINT clause in this INSERT
statement.
|
@Nullable Object |
Record.original(Name fieldName) |
Get an original value from this record as fetched from the database.
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.outerApply(Name name) |
OUTER APPLY a table to this table.
|
@NotNull Table<Record> |
Table.outerApply(Name name) |
OUTER APPLY a table to this table.
|
@NotNull WindowFinalStep<T> |
WindowOverStep.over(Name name) |
Turn this aggregate function into a window function referencing a window
name.
|
@NotNull ConstraintEnforcementStep |
ConstraintTypeStep.primaryKey(Name... fields) |
Create a PRIMARY KEY constraint.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep1.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep1.references(Name table,
Name field1) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep10.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep10.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep11.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep11.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep12.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep12.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep13.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep13.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep14.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep14.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep15.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep15.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep16.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep16.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15,
Name field16) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep17.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep17.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15,
Name field16,
Name field17) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep18.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep18.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15,
Name field16,
Name field17,
Name field18) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep19.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep19.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15,
Name field16,
Name field17,
Name field18,
Name field19) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep2.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep2.references(Name table,
Name field1,
Name field2) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep20.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep20.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15,
Name field16,
Name field17,
Name field18,
Name field19,
Name field20) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep21.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep21.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15,
Name field16,
Name field17,
Name field18,
Name field19,
Name field20,
Name field21) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep22.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep22.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11,
Name field12,
Name field13,
Name field14,
Name field15,
Name field16,
Name field17,
Name field18,
Name field19,
Name field20,
Name field21,
Name field22) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep3.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep3.references(Name table,
Name field1,
Name field2,
Name field3) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep4.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep4.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep5.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep5.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep6.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep6.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep7.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep7.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep8.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep8.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep9.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
@NotNull ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep9.references(Name table,
Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStepN.references(Name table) |
Add a REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key.
|
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStepN.references(Name table,
Name... fields) |
Add a REFERENCES clause to the CONSTRAINT,
referencing a key by column names.
|
@NotNull AlterTableRenameColumnToStep |
AlterTableStep.renameColumn(Name oldName) |
Add a RENAME COLUMN clause to the ALTER TABLE
statement.
|
@NotNull AlterDomainRenameConstraintStep |
AlterDomainStep.renameConstraint(Name renameConstraint) |
Add the RENAME CONSTRAINT clause to the ALTER DOMAIN statement.
|
@NotNull AlterTableRenameConstraintToStep |
AlterTableStep.renameConstraint(Name oldName) |
Add a RENAME CONSTRAINT clause to the ALTER TABLE
statement.
|
@NotNull AlterDomainRenameConstraintStep |
AlterDomainStep.renameConstraintIfExists(Name renameConstraint) |
Add the RENAME CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.
|
@NotNull AlterTableRenameIndexToStep |
AlterTableStep.renameIndex(Name oldName) |
Add a RENAME INDEX clause to the ALTER TABLE
statement.
|
@NotNull AlterDatabaseFinalStep |
AlterDatabaseStep.renameTo(Name renameTo) |
Add the RENAME TO clause to the ALTER DATABASE statement.
|
@NotNull AlterDomainFinalStep |
AlterDomainStep.renameTo(Name renameTo) |
Add the RENAME TO clause to the ALTER DOMAIN statement.
|
@NotNull AlterIndexFinalStep |
AlterIndexStep.renameTo(Name newName) |
Add a RENAME TO clause to the ALTER INDEX
statement.
|
@NotNull AlterSchemaFinalStep |
AlterSchemaStep.renameTo(Name renameTo) |
Add the RENAME TO clause to the ALTER SCHEMA statement.
|
@NotNull AlterSequenceFinalStep |
AlterSequenceStep.renameTo(Name newName) |
Add a RENAME TO clause to the ALTER SEQUENCE
statement.
|
@NotNull AlterTableFinalStep |
AlterTableStep.renameTo(Name newName) |
Add a RENAME TO clause to the ALTER TABLE
statement.
|
@NotNull AlterTypeFinalStep |
AlterTypeStep.renameTo(Name newName) |
Add the ALTER TYPE ..
|
@NotNull AlterViewFinalStep |
AlterViewStep.renameTo(Name newName) |
Add a RENAME TO clause to the ALTER VIEW
statement.
|
void |
Record.reset(Name fieldName) |
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.rightJoin(Name name) |
|
@NotNull TablePartitionByStep<Record> |
Table.rightJoin(Name name) |
RIGHT OUTER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
TableOuterJoinStep.rightJoin(Name name) |
RIGHT OUTER JOIN a table to this table.
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(Name name) |
|
@NotNull TablePartitionByStep<Record> |
Table.rightOuterJoin(Name name) |
RIGHT OUTER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(Name name) |
RIGHT OUTER JOIN a table to this table.
|
@NotNull SelectWhereStep<Record> |
DSLContext.selectFrom(Name table) |
Create a new DSL select statement, projecting *.
|
@NotNull SelectWhereStep<Record> |
WithStep.selectFrom(Name table) |
Create a new DSL select statement, projecting *.
|
@NotNull RowCountQuery |
DSLContext.set(Name name,
Param<?> param) |
Set a vendor specific flag to a new value.
|
@NotNull RowCountQuery |
DSLContext.setCatalog(Name catalog) |
Set the current catalog to a new value.
|
@NotNull AlterTypeFinalStep |
AlterTypeStep.setSchema(Name newSchema) |
Add the ALTER TYPE ..
|
@NotNull RowCountQuery |
DSLContext.setSchema(Name schema) |
Set the current schema to a new value.
|
@NotNull Result<R> |
Result.sortAsc(Name fieldName) |
Sort this result by one of its contained fields.
|
@NotNull Result<R> |
Result.sortAsc(Name fieldName,
Comparator<?> comparator) |
Sort this result by one of its contained fields using a comparator.
|
@NotNull Result<R> |
Result.sortDesc(Name fieldName) |
Reverse-sort this result by one of its contained fields.
|
@NotNull Result<R> |
Result.sortDesc(Name fieldName,
Comparator<?> comparator) |
Reverse-sort this result by one of its contained fields using a
comparator.
|
@NotNull SelectOnStep<R> |
SelectJoinStep.straightJoin(Name name) |
STRAIGHT_JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
Table.straightJoin(Name name) |
STRAIGHT_JOIN a table to this table.
|
@NotNull AlterDomainFinalStep |
AlterDomainRenameConstraintStep.to(Name renameConstraintTo) |
Add the TO clause to the ALTER DOMAIN statement.
|
@NotNull AlterTableFinalStep |
AlterTableRenameColumnToStep.to(Name newName) |
Specify a new column name.
|
AlterTableFinalStep |
AlterTableRenameConstraintToStep.to(Name newName) |
Specify a new constraint name.
|
@NotNull AlterTableFinalStep |
AlterTableRenameIndexToStep.to(Name newName) |
Specify a new index name.
|
@NotNull TruncateIdentityStep<Record> |
DSLContext.truncate(Name table) |
Create a new DSL truncate statement.
|
@NotNull TruncateIdentityStep<Record> |
DSLContext.truncateTable(Name table) |
Create a new DSL truncate statement.
|
@Nullable Class<?> |
RecordType.type(Name fieldName) |
Get the type for a given field name.
|
@Nullable Class<?> |
Row.type(Name fieldName) |
Get the type for a given field name.
|
@NotNull ConstraintEnforcementStep |
ConstraintTypeStep.unique(Name... fields) |
Create a UNIQUE constraint.
|
@NotNull DeleteWhereStep<R> |
DeleteUsingStep.using(Name name) |
Add a USING clause to the query.
|
@NotNull AlterTableFinalStep |
AlterTableUsingIndexStep.usingIndex(Name index) |
Add the USING INDEX clause to the statement.
|
@NotNull WithAsStep |
DSLContext.with(Name alias) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep |
DSLContext.with(Name alias,
Collection<? extends Name> fieldAliases) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep1 |
DSLContext.with(Name alias,
Name fieldAlias1) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep |
DSLContext.with(Name alias,
Name... fieldAliases) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep2 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep3 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep4 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep5 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep6 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep7 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep8 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep9 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep10 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep11 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep12 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep13 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep14 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep15 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep16 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep17 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep18 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep19 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep20 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19,
Name fieldAlias20) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep21 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19,
Name fieldAlias20,
Name fieldAlias21) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep22 |
DSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19,
Name fieldAlias20,
Name fieldAlias21,
Name fieldAlias22) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep |
WithStep.with(Name alias) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep |
WithStep.with(Name alias,
Collection<? extends Name> fieldAliases) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep1 |
WithStep.with(Name alias,
Name fieldAlias1) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep |
WithStep.with(Name alias,
Name... fieldAliases) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep2 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep3 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep4 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep5 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep6 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep7 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep8 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep9 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep10 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep11 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep12 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep13 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep14 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep15 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep16 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep17 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep18 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep19 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep20 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19,
Name fieldAlias20) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep21 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19,
Name fieldAlias20,
Name fieldAlias21) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep22 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19,
Name fieldAlias20,
Name fieldAlias21,
Name fieldAlias22) |
Add another common table expression to the WITH clause.
|
@NotNull WithAsStep |
DSLContext.withRecursive(Name alias) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep |
DSLContext.withRecursive(Name alias,
Collection<? extends Name> fieldAliases) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep1 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep |
DSLContext.withRecursive(Name alias,
Name... fieldAliases) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep2 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep3 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep4 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep5 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep6 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep7 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep8 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep9 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep10 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep11 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep12 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep13 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep14 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep15 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep16 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep17 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep18 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep19 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep20 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19,
Name fieldAlias20) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep21 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19,
Name fieldAlias20,
Name fieldAlias21) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
@NotNull WithAsStep22 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19,
Name fieldAlias20,
Name fieldAlias21,
Name fieldAlias22) |
Create a WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |