| Package | Description |
|---|---|
| org.jooq |
The
org.jooq package contains jOOQ's public API. |
| org.jooq.impl |
The
org.jooq.impl package contains jOOQ's implementation classes. |
| Modifier and Type | Method and Description |
|---|---|
Name |
Name.append(Name name)
Appends
name (all of its parts()) to this name. |
Name |
Name.append(String name)
Appends
name to this name. |
Name |
Named.getQualifiedName()
The qualified name of this object.
|
Name |
Named.getUnqualifiedName()
The unqualified name of this object.
|
Name |
Parser.parseName(String sql)
Parse a SQL string to a name.
|
Name |
Parser.parseName(String sql,
Object... bindings)
Parse a SQL string with bind variables to a name.
|
Name[] |
Name.parts()
Get the individual, unqualified name parts of this name.
|
Name |
Name.qualifier()
This name's qualifier (if it is
qualified()), or null. |
Name |
Name.quotedName()
This name, quoted.
|
Name |
Name.unqualifiedName()
This name, unqualified.
|
Name |
Name.unquotedName()
This name, unquoted.
|
| Modifier and Type | Method and Description |
|---|---|
AlterTableFinalStep |
AlterTableStep.add(Name field,
DataType<?> type)
Add an
ADD COLUMN clause to the ALTER TABLE
statement. |
AlterTableFinalStep |
AlterTableStep.addColumn(Name field,
DataType<?> type)
Add an
ADD COLUMN clause to the ALTER TABLE
statement. |
AlterTableFinalStep |
AlterTableStep.addColumnIfNotExists(Name field,
DataType<?> type)
Add an
ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE
statement. |
AlterTableFinalStep |
AlterTableStep.addIfNotExists(Name field,
DataType<?> type)
Add an
ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE
statement. |
AlterTableAlterStep<Object> |
AlterTableStep.alter(Name field)
Add an
ALTER COLUMN clause to the ALTER TABLE
statement. |
AlterTableAlterStep<Object> |
AlterTableStep.alterColumn(Name field)
Add an
ALTER COLUMN clause to the ALTER TABLE
statement. |
AlterIndexOnStep |
DSLContext.alterIndex(Name index)
Create a new DSL
ALTER INDEX statement. |
AlterIndexStep |
DSLContext.alterIndexIfExists(Name index)
Create a new DSL
ALTER INDEX statement. |
AlterSchemaStep |
DSLContext.alterSchema(Name schema)
Create a new DSL
ALTER SCHEMA statement. |
AlterSchemaStep |
DSLContext.alterSchemaIfExists(Name schema)
Create a new DSL
ALTER SCHEMA statement. |
AlterSequenceStep<BigInteger> |
DSLContext.alterSequence(Name sequence)
Create a new DSL
ALTER SEQUENCE statement. |
AlterSequenceStep<BigInteger> |
DSLContext.alterSequenceIfExists(Name sequence)
Create a new DSL
ALTER SEQUENCE statement. |
AlterTableStep |
DSLContext.alterTable(Name table)
Create a new DSL
ALTER TABLE statement. |
AlterTableStep |
DSLContext.alterTableIfExists(Name table)
Create a new DSL
ALTER TABLE statement. |
AlterViewStep |
DSLContext.alterView(Name view)
Create a new DSL
ALTER VIEW statement. |
AlterViewStep |
DSLContext.alterViewIfExists(Name view)
Create a new DSL
ALTER VIEW statement. |
Name |
Name.append(Name name)
Appends
name (all of its parts()) to this name. |
Table<R> |
Table.as(Name alias)
Create an alias for this table.
|
Field<T> |
Field.as(Name alias)
Create an alias for this field.
|
Table<R> |
Table.as(Name alias,
BiFunction<? super Field<?>,? super Integer,? extends Name> aliasFunction)
Create an alias for this table and its fields.
|
Table<R> |
Table.as(Name alias,
Function<? super Field<?>,? extends Name> aliasFunction)
Create an alias for this table and its fields.
|
Table<R> |
Table.as(Name alias,
Name... fieldAliases)
Create an alias for this table and its fields.
|
Table<R> |
Table.as(Name alias,
Name... fieldAliases)
Create an alias for this table and its fields.
|
Table<R> |
Table.at(Name link)
A table reference of this table at a given
Link. |
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.
|
Field<String> |
Field.collate(Name collation)
Apply a collation operator to this column expression.
|
CreateTableColumnStep |
CreateTableColumnStep.column(Name field,
DataType<?> type)
Add a column to the column list of the
CREATE TABLE statement. |
CreateTableColumnStep |
CreateTableAsStep.column(Name field,
DataType<?> type)
Add a column to the column list of the
CREATE TABLE statement. |
CommentOnIsStep |
DSLContext.commentOnColumn(Name columnName)
Create a new DSL
COMMENT ON COLUMN statement. |
CommentOnIsStep |
DSLContext.commentOnTable(Name tableName)
Create a new DSL
COMMENT ON TABLE statement. |
CommentOnIsStep |
DSLContext.commentOnView(Name viewName)
Create a new DSL
COMMENT ON VIEW statement. |
CreateTableAsStep<Record> |
DSLContext.createGlobalTemporaryTable(Name table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateIndexStep |
DSLContext.createIndex(Name index)
Create a new DSL
CREATE INDEX statement. |
CreateIndexStep |
DSLContext.createIndexIfNotExists(Name index)
Create a new DSL
CREATE INDEX IF NOT EXISTS statement. |
CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(Name view,
Name... fields)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(Name view,
Name... fields)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateSchemaFinalStep |
DSLContext.createSchema(Name schema)
Create a new DSL
CREATE SCHEMA statement. |
CreateSchemaFinalStep |
DSLContext.createSchemaIfNotExists(Name schema)
Create a new DSL
CREATE SCHEMA statement. |
CreateSequenceFinalStep |
DSLContext.createSequence(Name sequence)
Create a new DSL
CREATE SEQUENCE statement. |
CreateSequenceFinalStep |
DSLContext.createSequenceIfNotExists(Name sequence)
Create a new DSL
CREATE SEQUENCE statement. |
CreateTableAsStep<Record> |
DSLContext.createTable(Name table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DSLContext.createTableIfNotExists(Name table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DSLContext.createTemporaryTable(Name table)
Create a new DSL
CREATE TEMPORARY TABLE statement. |
CreateIndexStep |
DSLContext.createUniqueIndex(Name index)
Create a new DSL
CREATE UNIQUE INDEX statement. |
CreateIndexStep |
DSLContext.createUniqueIndexIfNotExists(Name index)
Create a new DSL
CREATE UNIQUE INDEX statement. |
CreateViewAsStep<Record> |
DSLContext.createView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createView(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createView(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
Table<Record> |
Table.crossApply(Name name)
CROSS APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossApply(Name name)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossJoin(Name name)
CROSS JOIN a table to this table. |
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)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN. |
BigInteger |
DSLContext.currval(Name sequence)
Convenience method to fetch the CURRVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
DataType<?> |
Row.dataType(Name fieldName)
Get the data type for a given field name.
|
DataType<?> |
RecordType.dataType(Name fieldName)
Get the data type for a given field name.
|
AlterTableDropStep |
AlterTableStep.drop(Name... fields)
Add an
DROP COLUMN clause to the ALTER TABLE
statement. |
AlterTableDropStep |
AlterTableStep.drop(Name field)
Add an
DROP COLUMN clause to the ALTER TABLE
statement. |
AlterTableDropStep |
AlterTableStep.dropColumn(Name field)
Add an
DROP COLUMN clause to the ALTER TABLE
statement. |
AlterTableDropStep |
AlterTableStep.dropColumnIfExists(Name field)
Add an
DROP COLUMN IF EXISTS clause to the ALTER TABLE
statement. |
AlterTableDropStep |
AlterTableStep.dropColumns(Name... fields)
Add an
DROP COLUMN clause to the ALTER TABLE
statement. |
AlterTableFinalStep |
AlterTableStep.dropConstraint(Name constraint)
Add a
DROP CONSTRAINT clause to the ALTER TABLE
statement. |
AlterTableDropStep |
AlterTableStep.dropIfExists(Name field)
Add an
DROP COLUMN IF EXISTS clause to the
ALTER TABLE statement. |
DropIndexOnStep |
DSLContext.dropIndex(Name index)
Create a new DSL
DROP INDEX statement. |
DropIndexOnStep |
DSLContext.dropIndexIfExists(Name index)
Create a new DSL
DROP INDEX IF EXISTS statement. |
DropSchemaStep |
DSLContext.dropSchema(Name schema)
Create a new DSL
DROP SCHEMA statement. |
DropSchemaStep |
DSLContext.dropSchemaIfExists(Name schema)
Create a new DSL
DROP SCHEMA statement. |
DropSequenceFinalStep |
DSLContext.dropSequence(Name sequence)
Create a new DSL
DROP SEQUENCE statement. |
DropSequenceFinalStep |
DSLContext.dropSequenceIfExists(Name sequence)
Create a new DSL
DROP SEQUENCE IF EXISTS statement. |
DropTableStep |
DSLContext.dropTable(Name table)
Create a new DSL
DROP TABLE statement. |
DropTableStep |
DSLContext.dropTableIfExists(Name table)
Create a new DSL
DROP TABLE IF EXISTS statement. |
DropTableStep |
DSLContext.dropTemporaryTable(Name table)
Create a new DSL
DROP TEMPORARY TABLE statement. |
DropViewFinalStep |
DSLContext.dropView(Name view)
Create a new DSL
DROP VIEW statement. |
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.
|
List<?> |
ResultQuery.fetch(Name fieldName)
Execute the query and return all values for a field name from the
generated result.
|
<T> List<T> |
ResultQuery.fetch(Name fieldName,
Class<? extends T> type)
Execute the query and return all values for a field name from the
generated result.
|
<U> 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.
|
Object |
ResultQuery.fetchAny(Name fieldName)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchAny(Name fieldName,
Class<? extends T> 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.
|
Object[] |
ResultQuery.fetchArray(Name fieldName)
Execute the query and return all values for a field name from the
generated result.
|
<T> T[] |
ResultQuery.fetchArray(Name fieldName,
Class<? extends T> type)
Execute the query and return all values for a field name from the
generated result.
|
<U> U[] |
ResultQuery.fetchArray(Name fieldName,
Converter<?,? extends U> converter)
Execute the query and return all values for a field name from the
generated result.
|
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. |
Map<Record,Result<R>> |
ResultQuery.fetchGroups(Name[] keyFieldNames)
Execute the query and return a
Map with the result grouped by the
given keys. |
<E> 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. |
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. |
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> 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> 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. |
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
Unlike ResultQuery.fetchMap(Name, Name), this method allows for
non-unique keys in the result set. |
<E> 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. |
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. |
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> 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. |
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. |
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> 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> 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. |
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
An exception is thrown, if the key turns out to be non-unique in the
result set. |
<E> 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. |
Object |
ResultQuery.fetchOne(Name fieldName)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchOne(Name fieldName,
Class<? extends T> 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.
|
Optional<?> |
ResultQuery.fetchOptional(Name fieldName)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> Optional<T> |
ResultQuery.fetchOptional(Name fieldName,
Class<? extends T> type)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> 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.
|
Set<?> |
ResultQuery.fetchSet(Name fieldName)
Execute the query and return all values for a field name from the
generated result.
|
<T> Set<T> |
ResultQuery.fetchSet(Name fieldName,
Class<? extends T> type)
Execute the query and return all values for a field name from the
generated result.
|
<U> 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.
|
Object |
ResultQuery.fetchSingle(Name fieldName)
Execute the query and return exactly one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchSingle(Name fieldName,
Class<? extends T> 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.
|
Field<?> |
UDT.field(Name name)
Get a specific field from this UDT.
|
Field<?> |
TableLike.field(Name name)
Get a specific field from this table, if this table knows its field
references.
|
Field<?> |
Row.field(Name fieldName)
Get a specific field from this row.
|
Field<?> |
Result.field(Name name)
Get a specific field from this Result.
|
Field<?> |
RecordType.field(Name fieldName)
Get a specific qualified field from this record type.
|
Field<?> |
Record.field(Name name)
Get a specific qualified field from this Record.
|
Field<?> |
Cursor.field(Name name)
Get a specific qualified field from this Cursor.
|
<T> 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> Field<T> |
Row.field(Name fieldName,
Class<T> type)
Get a specific field from this row and coerce it to
type. |
<T> Field<T> |
Result.field(Name name,
Class<T> type)
Get a specific field from this Result, coerced to
type. |
<T> Field<T> |
RecordType.field(Name fieldName,
Class<T> type)
Get a specific field from this record type coerced to
type. |
<T> 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. |
<T> Field<T> |
Row.field(Name fieldName,
DataType<T> dataType)
Get a specific field from this row and coerce it to
dataType. |
<T> Field<T> |
Result.field(Name name,
DataType<T> dataType)
Get a specific field from this Result, coerced to
dataType. |
<T> Field<T> |
RecordType.field(Name fieldName,
DataType<T> dataType)
Get a specific field from this record type coerced to
dataType. |
Field<?>[] |
UDT.fields(Name... fieldNames)
Get all fields from this UDT, providing some field names.
|
Field<?>[] |
TableLike.fields(Name... fieldNames)
Get all fields from this table, providing some field names, if this table
knows its field references.
|
Field<?>[] |
Row.fields(Name... fieldNames)
Get all fields from this row, providing some field names.
|
Field<?>[] |
Result.fields(Name... fieldNames)
Get all fields from this Result, providing some field names.
|
Field<?>[] |
RecordType.fields(Name... fieldNames)
Get all fields from this record type, providing some field names.
|
Field<?>[] |
Record.fields(Name... fieldNames)
Get all fields from this Record, providing some field names.
|
DerivedColumnList |
Name.fields(Name... fieldNames)
Add a list of fields to this name to make this name a
DerivedColumnList. |
Field<?>[] |
Cursor.fields(Name... fieldNames)
Get all fields from this Cursor, providing some field names.
|
DerivedColumnList1 |
Name.fields(Name fieldName1)
Add a list of fields to this name to make this name a
DerivedColumnList. |
DerivedColumnList2 |
Name.fields(Name fieldName1,
Name fieldName2)
Add a list of fields to this name to make this name a
DerivedColumnList. |
DerivedColumnList3 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3)
Add a list of fields to this name to make this name a
DerivedColumnList. |
DerivedColumnList4 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4)
Add a list of fields to this name to make this name a
DerivedColumnList. |
DerivedColumnList5 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5)
Add a list of fields to this name to make this name a
DerivedColumnList. |
DerivedColumnList6 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6)
Add a list of fields to this name to make this name a
DerivedColumnList. |
DerivedColumnList7 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7)
Add a list of fields to this name to make this name a
DerivedColumnList. |
DerivedColumnList8 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8)
Add a list of fields to this name to make this name a
DerivedColumnList. |
DerivedColumnList9 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9)
Add a list of fields to this name to make this name a
DerivedColumnList. |
DerivedColumnList10 |
Name.fields(Name fieldName1,
Name fieldName2,
Name fieldName3,
Name fieldName4,
Name fieldName5,
Name fieldName6,
Name fieldName7,
Name fieldName8,
Name fieldName9,
Name fieldName10)
Add a list of fields to this name to make this name a
DerivedColumnList. |
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)
Add a list of fields to this name to make this name a
DerivedColumnList. |
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)
Add a list of fields to this name to make this name a
DerivedColumnList. |
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)
Add a list of fields to this name to make this name a
DerivedColumnList. |
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)
Add a list of fields to this name to make this name a
DerivedColumnList. |
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)
Add a list of fields to this name to make this name a
DerivedColumnList. |
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)
Add a list of fields to this name to make this name a
DerivedColumnList. |
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)
Add a list of fields to this name to make this name a
DerivedColumnList. |
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)
Add a list of fields to this name to make this name a
DerivedColumnList. |
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)
Add a list of fields to this name to make this name a
DerivedColumnList. |
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)
Add a list of fields to this name to make this name a
DerivedColumnList. |
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)
Add a list of fields to this name to make this name a
DerivedColumnList. |
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)
Add a list of fields to this name to make this name a
DerivedColumnList. |
ConstraintForeignKeyReferencesStepN |
ConstraintTypeStep.foreignKey(Name... fields)
Add a
FOREIGN KEY clause to the CONSTRAINT. |
ConstraintForeignKeyReferencesStep1<?> |
ConstraintTypeStep.foreignKey(Name field1)
Add a
FOREIGN KEY clause to the CONSTRAINT. |
ConstraintForeignKeyReferencesStep2<?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2)
Add a
FOREIGN KEY clause to the CONSTRAINT. |
ConstraintForeignKeyReferencesStep3<?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3)
Add a
FOREIGN KEY clause to the CONSTRAINT. |
ConstraintForeignKeyReferencesStep4<?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4)
Add a
FOREIGN KEY clause to the CONSTRAINT. |
ConstraintForeignKeyReferencesStep5<?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5)
Add a
FOREIGN KEY clause to the CONSTRAINT. |
ConstraintForeignKeyReferencesStep6<?,?,?,?,?,?> |
ConstraintTypeStep.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6)
Add a
FOREIGN KEY clause to the CONSTRAINT. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
UpdateWhereStep<R> |
UpdateFromStep.from(Name name)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(Name name)
Add a
FROM clause to the query. |
void |
Record.from(Object source,
Name... fieldNames)
Load data into this record from a source, providing some field names.
|
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.
|
TableOnStep<Record> |
Table.fullJoin(Name name)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullJoin(Name name)
Convenience method to
FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table.fullOuterJoin(Name). |
TableOnStep<Record> |
Table.fullOuterJoin(Name name)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(Name name)
Convenience method to
FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table.fullOuterJoin(Name)
This is only possible where the underlying RDBMS supports it |
Object |
Record.get(Name fieldName)
Get a value from this Record, providing a field name.
|
<T> T |
Record.get(Name fieldName,
Class<? extends T> 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.
|
Catalog |
Meta.getCatalog(Name name)
Get a catalog object by name from the underlying meta data source, or
null if no such object exists. |
List<Schema> |
Meta.getSchemas(Name name)
Get all schema objects by name from the underlying meta data source.
|
List<Sequence<?>> |
Meta.getSequences(Name name)
Get all sequence objects by name from the underlying meta data source.
|
List<Table<?>> |
Meta.getTables(Name name)
Get all table objects by name from the underlying meta data source.
|
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.
|
List<?> |
Result.getValues(Name fieldName)
Convenience method to fetch all values for a given field.
|
<T> List<T> |
Result.getValues(Name fieldName,
Class<? extends T> type)
Convenience method to fetch all values for a given field.
|
<U> List<U> |
Result.getValues(Name fieldName,
Converter<?,? extends U> converter)
Convenience method to fetch all values for a given field.
|
CreateIndexWhereStep |
CreateIndexIncludeStep.include(Name... fields)
Add an
INCLUDE clause to include columns in an index. |
int |
Row.indexOf(Name fieldName)
Get a field's index from this row.
|
int |
RecordType.indexOf(Name fieldName)
Get a field's index from this record type.
|
TableOnStep<Record> |
Table.innerJoin(Name name)
INNER JOIN a table to this table. |
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). |
ResultQuery<R> |
ResultQuery.intern(Name... fieldNames)
Deprecated.
- 3.10 - [#6254] - This functionality is no longer supported
and will be removed in 4.0
|
Result<R> |
Result.intern(Name... fieldNames)
Deprecated.
- 3.10 - [#6254] - This functionality is no longer supported
and will be removed in 4.0
|
Object[] |
Result.intoArray(Name fieldName)
Return all values for a field name from the result.
|
<T> T[] |
Result.intoArray(Name fieldName,
Class<? extends T> type)
Return all values for a field name from the result.
|
<U> U[] |
Result.intoArray(Name fieldName,
Converter<?,? extends U> converter)
Return all values for a field name from the result.
|
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. |
Map<Record,Result<R>> |
Result.intoGroups(Name[] keyFieldNames)
Return a
Map with the result grouped by the given keys. |
<E> 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. |
Map<Record,Result<Record>> |
Result.intoGroups(Name[] keyFieldNames,
Name[] valueFieldNames)
Return a
Map with the result grouped by the given keys. |
Map<Record,Result<Record>> |
Result.intoGroups(Name[] keyFieldNames,
Name[] valueFieldNames)
Return a
Map with the result grouped by the given keys. |
<E> 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> 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. |
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> 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. |
Map<?,R> |
Result.intoMap(Name keyFieldName)
Return a
Map with one of the result's columns as key and the
corresponding records as value. |
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> 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. |
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. |
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> 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> 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. |
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
An InvalidResultException is thrown, if the key turns out to be
non-unique in the result set. |
<E> 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. |
Set<?> |
Result.intoSet(Name fieldName)
Return all values for a field name from the result.
|
<T> Set<T> |
Result.intoSet(Name fieldName,
Class<? extends T> type)
Return all values for a field name from the result.
|
<U> Set<U> |
Result.intoSet(Name fieldName,
Converter<?,? extends U> converter)
Return all values for a field name from the result.
|
TableOnStep<Record> |
Table.join(Name name)
INNER JOIN a table to this table. |
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). |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(Name name)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftJoin(Name name)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(Name name)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(Name). |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(Name name)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftOuterJoin(Name name)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(Name name)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(Name) |
Table<Record> |
Table.naturalJoin(Name name)
NATURAL JOIN a table to this table. |
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)
Natural joins are supported by most RDBMS. |
Table<Record> |
Table.naturalLeftOuterJoin(Name name)
NATURAL LEFT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(Name name)
Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(Name)
Natural joins are supported by most RDBMS. |
Table<Record> |
Table.naturalRightOuterJoin(Name name)
NATURAL RIGHT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(Name name)
Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(Name)
Natural joins are supported by most RDBMS. |
BigInteger |
DSLContext.nextval(Name sequence)
Convenience method to fetch the NEXTVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
RevokeFromStep |
RevokeOnStep.on(Name table)
Revoke a privilege on a table.
|
GrantToStep |
GrantOnStep.on(Name table)
Grant a privilege on a table.
|
DropIndexFinalStep |
DropIndexOnStep.on(Name tableName)
Specify the table expression on which to drop an index.
|
AlterIndexStep |
AlterIndexOnStep.on(Name tableName)
Specify the table expression on which to alter an index.
|
CreateIndexIncludeStep |
CreateIndexStep.on(Name tableName,
Collection<? extends Name> fieldNames)
Specify the table and column expressions on which to create an index.
|
CreateIndexIncludeStep |
CreateIndexStep.on(Name tableName,
Name... fieldNames)
Specify the table and column expressions on which to create an index.
|
CreateIndexIncludeStep |
CreateIndexStep.on(Name tableName,
Name... fieldNames)
Specify the table and column expressions on which to create an index.
|
void |
InsertQuery.onConflictOnConstraint(Name constraint)
Whether use a
On CONFLICT or
ON CONFLICT ON CONSTRAINT clause in this INSERT
statement. |
InsertOnConflictDoUpdateStep<R> |
InsertOnDuplicateStep.onConflictOnConstraint(Name constraint)
Add a
ON CONFLICT ON CONSTRAINT clause to this query. |
Object |
Record.original(Name fieldName)
Get an original value from this record as fetched from the database.
|
Table<Record> |
Table.outerApply(Name name)
OUTER APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.outerApply(Name name)
OUTER APPLY a table to this table. |
WindowFinalStep<T> |
WindowOverStep.over(Name name)
Turn this aggregate function into a window function referencing a window
name.
|
ConstraintFinalStep |
ConstraintTypeStep.primaryKey(Name... fields)
Create a
PRIMARY KEY constraint. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStepN.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep9.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep8.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep7.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep6.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep5.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep4.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep3.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep22.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep21.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep20.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep2.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep19.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep18.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep17.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep16.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep15.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep14.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep13.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep12.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep11.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep10.references(Name table)
Add a
REFERENCES clause to the CONSTRAINT,
implicitly referencing the primary key. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep1.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. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStepN.references(Name table,
Name... fields)
Add a
REFERENCES clause to the CONSTRAINT,
referencing a key by column names. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep1.references(Name table,
Name field1)
Add a
REFERENCES clause to the CONSTRAINT,
referencing a key by column names. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep2.references(Name table,
Name field1,
Name field2)
Add a
REFERENCES clause to the CONSTRAINT,
referencing a key by column names. |
ConstraintForeignKeyOnStep |
ConstraintForeignKeyReferencesStep3.references(Name table,
Name field1,
Name field2,
Name field3)
Add a
REFERENCES clause to the CONSTRAINT,
referencing a key by column names. |
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. |
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. |
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. |
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. |
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. |
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 |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
AlterTableRenameColumnToStep |
AlterTableStep.renameColumn(Name oldName)
Add a
RENAME COLUMN clause to the ALTER TABLE
statement. |
AlterTableRenameConstraintToStep |
AlterTableStep.renameConstraint(Name oldName)
Add a
RENAME CONSTRAINT clause to the ALTER TABLE
statement. |
AlterTableRenameIndexToStep |
AlterTableStep.renameIndex(Name oldName)
Add a
RENAME INDEX clause to the ALTER TABLE
statement. |
AlterViewFinalStep |
AlterViewStep.renameTo(Name newName)
Add a
RENAME TO clause to the ALTER VIEW
statement. |
AlterTableFinalStep |
AlterTableStep.renameTo(Name newName)
Add a
RENAME TO clause to the ALTER TABLE
statement. |
AlterSequenceFinalStep |
AlterSequenceStep.renameTo(Name newName)
Add a
RENAME TO clause to the ALTER SEQUENCE
statement. |
AlterSchemaFinalStep |
AlterSchemaStep.renameTo(Name newName)
Add a
RENAME TO clause to the ALTER SCHEMA
statement. |
AlterIndexFinalStep |
AlterIndexStep.renameTo(Name newName)
Add a
RENAME TO clause to the ALTER INDEX
statement. |
void |
Record.reset(Name fieldName)
|
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(Name name)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightJoin(Name name)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightJoin(Name name)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(Name). |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(Name name)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightOuterJoin(Name name)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(Name name)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(Name)
This is only possible where the underlying RDBMS supports it |
<R extends Record> |
WithStep.selectFrom(Name table)
Create a new DSL select statement.
|
<R extends Record> |
DSLContext.selectFrom(Name table)
Create a new DSL select statement.
|
Query |
DSLContext.setCatalog(Name catalog)
Set the current catalog to a new value.
|
Query |
DSLContext.setSchema(Name schema)
Set the current schema to a new value.
|
Result<R> |
Result.sortAsc(Name fieldName)
Sort this result by one of its contained fields.
|
Result<R> |
Result.sortAsc(Name fieldName,
Comparator<?> comparator)
Sort this result by one of its contained fields using a comparator.
|
Result<R> |
Result.sortDesc(Name fieldName)
Reverse-sort this result by one of its contained fields.
|
Result<R> |
Result.sortDesc(Name fieldName,
Comparator<?> comparator)
Reverse-sort this result by one of its contained fields using a
comparator.
|
TableOnStep<Record> |
Table.straightJoin(Name name)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(Name name)
STRAIGHT_JOIN a table to this table. |
AlterTableFinalStep |
AlterTableRenameIndexToStep.to(Name newName)
Specify a new index name.
|
AlterTableFinalStep |
AlterTableRenameConstraintToStep.to(Name newName)
Specify a new constraint name.
|
AlterTableFinalStep |
AlterTableRenameColumnToStep.to(Name newName)
Specify a new column name.
|
TruncateIdentityStep<Record> |
DSLContext.truncate(Name table)
Create a new DSL truncate statement.
|
Class<?> |
Row.type(Name fieldName)
Get the type for a given field name.
|
Class<?> |
RecordType.type(Name fieldName)
Get the type for a given field name.
|
ConstraintFinalStep |
ConstraintTypeStep.unique(Name... fields)
Create a
UNIQUE constraint. |
AlterTableFinalStep |
AlterTableUsingIndexStep.usingIndex(Name index)
Add the
USING INDEX clause to the statement. |
WithAsStep |
WithStep.with(Name alias)
Add another common table expression to the
WITH clause. |
WithAsStep |
DSLContext.with(Name alias)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
WithStep.with(Name alias,
Name... fieldAliases)
Add another common table expression to the
WITH clause. |
WithAsStep |
WithStep.with(Name alias,
Name... fieldAliases)
Add another common table expression to the
WITH clause. |
WithAsStep |
DSLContext.with(Name alias,
Name... fieldAliases)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
DSLContext.with(Name alias,
Name... fieldAliases)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep1 |
WithStep.with(Name alias,
Name fieldAlias1)
Add another common table expression to the
WITH clause. |
WithAsStep1 |
DSLContext.with(Name alias,
Name fieldAlias1)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep2 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2)
Add another common table expression to the
WITH clause. |
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. |
WithAsStep3 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3)
Add another common table expression to the
WITH clause. |
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. |
WithAsStep4 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4)
Add another common table expression to the
WITH clause. |
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. |
WithAsStep5 |
WithStep.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5)
Add another common table expression to the
WITH clause. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
WithAsStep |
DSLContext.withRecursive(Name alias)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
DSLContext.withRecursive(Name alias,
Name... fieldAliases)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
DSLContext.withRecursive(Name alias,
Name... fieldAliases)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep1 |
DSLContext.withRecursive(Name alias,
Name fieldAlias1)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
| Modifier and Type | Method and Description |
|---|---|
Table<R> |
Table.as(Name alias,
BiFunction<? super Field<?>,? super Integer,? extends Name> aliasFunction)
Create an alias for this table and its fields.
|
Table<R> |
Table.as(Name alias,
Function<? super Field<?>,? extends Name> aliasFunction)
Create an alias for this table and its fields.
|
CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateIndexIncludeStep |
CreateIndexStep.on(Name tableName,
Collection<? extends Name> fieldNames)
Specify the table and column expressions on which to create an index.
|
| Modifier and Type | Method and Description |
|---|---|
static Name |
Internal.createPathAlias(Table<?> child,
ForeignKey<?,?> path)
Factory method for path aliases.
|
static Name |
DSL.name(Collection<String> qualifiedName)
Create a new SQL identifier using a qualified name.
|
static Name |
DSL.name(Name... nameParts)
Create a new SQL identifier using a qualified name.
|
static Name |
DSL.name(String... qualifiedName)
Create a new SQL identifier using a qualified name.
|
static Name |
DSL.name(String unqualifiedName)
Create a new SQL identifier using an unqualified name.
|
static Name |
DSL.quotedName(Collection<String> qualifiedName)
Create a new SQL identifier using a qualified, quoted name.
|
static Name |
DSL.quotedName(String... qualifiedName)
Create a new SQL identifier using a qualified, quoted name.
|
static Name |
DSL.quotedName(String unqualifiedName)
Create a new SQL identifier using an unqualified, quoted name.
|
static Name |
DSL.unquotedName(Collection<String> qualifiedName)
Create a new SQL identifier using a qualified, quoted name.
|
static Name |
DSL.unquotedName(String... qualifiedName)
Create a new SQL identifier using a qualified, quoted name.
|
static Name |
DSL.unquotedName(String unqualifiedName)
Create a new SQL identifier using an unqualified, quoted name.
|
| Modifier and Type | Method and Description |
|---|---|
static AlterIndexOnStep |
DSL.alterIndex(Name index)
Create a new DSL
ALTER INDEX statement. |
AlterIndexOnStep |
DefaultDSLContext.alterIndex(Name index) |
static AlterIndexStep |
DSL.alterIndexIfExists(Name index)
Create a new DSL
ALTER INDEX statement. |
AlterIndexStep |
DefaultDSLContext.alterIndexIfExists(Name index) |
static AlterSchemaStep |
DSL.alterSchema(Name schema)
Create a new DSL
ALTER SCHEMA statement. |
AlterSchemaStep |
DefaultDSLContext.alterSchema(Name schema) |
static AlterSchemaStep |
DSL.alterSchemaIfExists(Name schema)
Create a new DSL
ALTER SCHEMA statement. |
AlterSchemaStep |
DefaultDSLContext.alterSchemaIfExists(Name schema) |
static AlterSequenceStep<BigInteger> |
DSL.alterSequence(Name sequence)
Create a new DSL
ALTER SEQUENCE statement. |
AlterSequenceStep<BigInteger> |
DefaultDSLContext.alterSequence(Name sequence) |
static AlterSequenceStep<BigInteger> |
DSL.alterSequenceIfExists(Name sequence)
Create a new DSL
ALTER SEQUENCE statement. |
AlterSequenceStep<BigInteger> |
DefaultDSLContext.alterSequenceIfExists(Name sequence) |
static AlterTableStep |
DSL.alterTable(Name table)
Create a new DSL
ALTER TABLE statement. |
AlterTableStep |
DefaultDSLContext.alterTable(Name table) |
static AlterTableStep |
DSL.alterTableIfExists(Name table)
Create a new DSL
ALTER TABLE statement. |
AlterTableStep |
DefaultDSLContext.alterTableIfExists(Name table) |
static AlterViewStep |
DSL.alterView(Name view)
Create a new DSL
ALTER VIEW statement. |
AlterViewStep |
DefaultDSLContext.alterView(Name table) |
static AlterViewStep |
DSL.alterViewIfExists(Name view)
Create a new DSL
ALTER VIEW statement. |
AlterViewStep |
DefaultDSLContext.alterViewIfExists(Name table) |
Table<R> |
TableImpl.as(Name as)
Subclasses may override this method to provide custom aliasing
implementations
Create an alias for this table.
|
Field<T> |
CustomField.as(Name alias) |
Table<R> |
TableImpl.as(Name as,
Name... fieldAliases)
Subclasses may override this method to provide custom aliasing
implementations
Create an alias for this table and its fields.
|
Table<R> |
TableImpl.as(Name as,
Name... fieldAliases)
Subclasses may override this method to provide custom aliasing
implementations
Create an alias for this table and its fields.
|
static Catalog |
DSL.catalog(Name name)
Create a qualified catalog, given its catalog name.
|
static Collation |
DSL.collation(Name collation)
Create a collation by its qualified name.
|
static CommentOnIsStep |
DSL.commentOnColumn(Name columnName)
Create a new DSL
COMMENT ON COLUMN statement. |
CommentOnIsStep |
DefaultDSLContext.commentOnColumn(Name columnName) |
static CommentOnIsStep |
DSL.commentOnTable(Name tableName)
Create a new DSL
COMMENT ON TABLE statement. |
CommentOnIsStep |
DefaultDSLContext.commentOnTable(Name tableName) |
static CommentOnIsStep |
DSL.commentOnView(Name viewName)
Create a new DSL
COMMENT ON VIEW statement. |
CommentOnIsStep |
DefaultDSLContext.commentOnView(Name viewName) |
static ConstraintTypeStep |
DSL.constraint(Name name)
Create a
CONSTRAINT specification. |
static CreateTableAsStep<Record> |
DSL.createGlobalTemporaryTable(Name table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createGlobalTemporaryTable(Name table) |
static CreateIndexStep |
DSL.createIndex(Name index)
Create a new DSL
CREATE INDEX statement. |
CreateIndexStep |
DefaultDSLContext.createIndex(Name index) |
static Index |
Internal.createIndex(Name name,
Table<?> table,
OrderField<?>[] sortFields,
boolean unique)
Factory method for indexes.
|
static CreateIndexStep |
DSL.createIndexIfNotExists(Name index)
Create a new DSL
CREATE INDEX IF NOT EXISTS statement. |
CreateIndexStep |
DefaultDSLContext.createIndexIfNotExists(Name index) |
CreateViewAsStep<Record> |
DefaultDSLContext.createOrReplaceView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction) |
static CreateViewAsStep |
DSL.createOrReplaceView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DefaultDSLContext.createOrReplaceView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction) |
static CreateViewAsStep |
DSL.createOrReplaceView(Name view,
Name... fields)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
static CreateViewAsStep |
DSL.createOrReplaceView(Name view,
Name... fields)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DefaultDSLContext.createOrReplaceView(Name view,
Name... fields) |
CreateViewAsStep<Record> |
DefaultDSLContext.createOrReplaceView(Name view,
Name... fields) |
static CreateSchemaFinalStep |
DSL.createSchema(Name table)
Create a new DSL
CREATE SCHEMA statement. |
CreateSchemaFinalStep |
DefaultDSLContext.createSchema(Name schema) |
static CreateSchemaFinalStep |
DSL.createSchemaIfNotExists(Name table)
Create a new DSL
CREATE SCHEMA statement. |
CreateSchemaFinalStep |
DefaultDSLContext.createSchemaIfNotExists(Name schema) |
static CreateSequenceFinalStep |
DSL.createSequence(Name sequence)
Create a new DSL
CREATE SEQUENCE statement. |
CreateSequenceFinalStep |
DefaultDSLContext.createSequence(Name sequence) |
static CreateSequenceFinalStep |
DSL.createSequenceIfNotExists(Name sequence)
Create a new DSL
CREATE SEQUENCE IF NOT EXISTS statement. |
CreateSequenceFinalStep |
DefaultDSLContext.createSequenceIfNotExists(Name sequence) |
static CreateTableAsStep<Record> |
DSL.createTable(Name table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createTable(Name table) |
static CreateTableAsStep<Record> |
DSL.createTableIfNotExists(Name table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createTableIfNotExists(Name table) |
static CreateTableAsStep<Record> |
DSL.createTemporaryTable(Name table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createTemporaryTable(Name table) |
static CreateIndexStep |
DSL.createUniqueIndex(Name index)
Create a new DSL
CREATE UNIQUE INDEX statement. |
CreateIndexStep |
DefaultDSLContext.createUniqueIndex(Name index) |
static CreateIndexStep |
DSL.createUniqueIndexIfNotExists(Name index)
Create a new DSL
CREATE UNIQUE INDEX IF NOT EXISTS statement. |
CreateIndexStep |
DefaultDSLContext.createUniqueIndexIfNotExists(Name index) |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction) |
static CreateViewAsStep |
DSL.createView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction) |
static CreateViewAsStep |
DSL.createView(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
static CreateViewAsStep |
DSL.createView(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(Name view,
Name... fields) |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(Name view,
Name... fields) |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction) |
static CreateViewAsStep |
DSL.createViewIfNotExists(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW IF NOT EXISTS statement. |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction) |
static CreateViewAsStep |
DSL.createViewIfNotExists(Name view,
Name... fields)
Create a new DSL
CREATE VIEW IF NOT EXISTS statement. |
static CreateViewAsStep |
DSL.createViewIfNotExists(Name view,
Name... fields)
Create a new DSL
CREATE VIEW IF NOT EXISTS statement. |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(Name view,
Name... fields) |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(Name view,
Name... fields) |
BigInteger |
DefaultDSLContext.currval(Name sequence) |
static DropIndexOnStep |
DSL.dropIndex(Name index)
Create a new DSL
DROP INDEX statement. |
DropIndexOnStep |
DefaultDSLContext.dropIndex(Name index) |
static DropIndexOnStep |
DSL.dropIndexIfExists(Name index)
Create a new DSL
DROP INDEX IF EXISTS statement. |
DropIndexOnStep |
DefaultDSLContext.dropIndexIfExists(Name index) |
static DropSchemaStep |
DSL.dropSchema(Name schema)
Create a new DSL
DROP SCHEMA statement. |
DropSchemaStep |
DefaultDSLContext.dropSchema(Name schema) |
static DropSchemaStep |
DSL.dropSchemaIfExists(Name schema)
Create a new DSL
DROP SCHEMA statement. |
DropSchemaStep |
DefaultDSLContext.dropSchemaIfExists(Name schema) |
DropSequenceFinalStep |
DefaultDSLContext.dropSequence(Name sequence) |
static <T extends Number> |
DSL.dropSequence(Name sequence)
Create a new DSL
DROP SEQUENCE statement. |
DropSequenceFinalStep |
DefaultDSLContext.dropSequenceIfExists(Name sequence) |
static <T extends Number> |
DSL.dropSequenceIfExists(Name sequence)
Create a new DSL
DROP SEQUENCE IF EXISTS statement. |
static DropTableStep |
DSL.dropTable(Name table)
Create a new DSL
DROP TABLE statement. |
DropTableStep |
DefaultDSLContext.dropTable(Name table) |
static DropTableStep |
DSL.dropTableIfExists(Name table)
Create a new DSL
DROP TABLE IF EXISTS statement. |
DropTableStep |
DefaultDSLContext.dropTableIfExists(Name table) |
static DropTableStep |
DSL.dropTemporaryTable(Name table)
Create a new DSL
DROP TEMPORARY TABLE statement. |
DropTableStep |
DefaultDSLContext.dropTemporaryTable(Name table) |
static DropViewFinalStep |
DSL.dropView(Name view)
Create a new DSL
DROP VIEW statement. |
DropViewFinalStep |
DefaultDSLContext.dropView(Name view) |
static DropViewFinalStep |
DSL.dropViewIfExists(Name view)
Create a new DSL
DROP VIEW IF EXISTS statement. |
DropViewFinalStep |
DefaultDSLContext.dropViewIfExists(Name view) |
Field<?> |
UDTImpl.field(Name fieldName) |
static Field<Object> |
DSL.field(Name name)
Create a qualified field, given its (qualified) field name.
|
static <T> Field<T> |
DSL.field(Name name,
Class<T> type)
Create a qualified field, given its (qualified) field name.
|
static <T> Field<T> |
DSL.field(Name name,
DataType<T> type)
Create a qualified field, given its (qualified) field name.
|
static <T> Field<T> |
DSL.field(Name name,
DataType<T> type,
Comment comment)
Create a qualified field, given its (qualified) field name.
|
Field<?>[] |
UDTImpl.fields(Name... fieldNames) |
static ConstraintForeignKeyReferencesStepN |
DSL.foreignKey(Name... fields)
Add a
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep1<?> |
DSL.foreignKey(Name field1)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep2<?,?> |
DSL.foreignKey(Name field1,
Name field2)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep3<?,?,?> |
DSL.foreignKey(Name field1,
Name field2,
Name field3)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep4<?,?,?,?> |
DSL.foreignKey(Name field1,
Name field2,
Name field3,
Name field4)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep5<?,?,?,?,?> |
DSL.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep6<?,?,?,?,?,?> |
DSL.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep7<?,?,?,?,?,?,?> |
DSL.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep8<?,?,?,?,?,?,?,?> |
DSL.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep9<?,?,?,?,?,?,?,?,?> |
DSL.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep10<?,?,?,?,?,?,?,?,?,?> |
DSL.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep11<?,?,?,?,?,?,?,?,?,?,?> |
DSL.foreignKey(Name field1,
Name field2,
Name field3,
Name field4,
Name field5,
Name field6,
Name field7,
Name field8,
Name field9,
Name field10,
Name field11)
Add an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep12<?,?,?,?,?,?,?,?,?,?,?,?> |
DSL.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 an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep13<?,?,?,?,?,?,?,?,?,?,?,?,?> |
DSL.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 an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep14<?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
DSL.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 an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
DSL.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 an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
DSL.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 an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
DSL.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 an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
DSL.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 an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
DSL.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 an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
DSL.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 an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
DSL.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 an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static ConstraintForeignKeyReferencesStep22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?> |
DSL.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 an unnamed (system named)
FOREIGN KEY clause to the CONSTRAINT. |
static <T> Field<T> |
DSL.function(Name name,
Class<T> type,
Field<?>... arguments)
function() can be used to access native or user-defined
functions that are not yet or insufficiently supported by jOOQ. |
static <T> Field<T> |
DSL.function(Name name,
DataType<T> type,
Field<?>... arguments)
function() can be used to access native or user-defined
functions that are not yet or insufficiently supported by jOOQ. |
static Index |
DSL.index(Name name)
Create a qualified index reference by name.
|
static Link |
DSL.link(Name name)
Create a database link reference.
|
static Name |
DSL.name(Name... nameParts)
Create a new SQL identifier using a qualified name.
|
BigInteger |
DefaultDSLContext.nextval(Name sequence) |
static ConstraintFinalStep |
DSL.primaryKey(Name... fields)
Create an unnamed (system named)
PRIMARY KEY constraint. |
Table<R> |
TableImpl.rename(Name rename) |
static Role |
DSL.role(Name name)
Create a new role reference.
|
static Schema |
DSL.schema(Name name)
Create a qualified schema, given its schema name.
|
static <R extends Record> |
DSL.selectFrom(Name table)
Create a new DSL select statement.
|
<R extends Record> |
DefaultDSLContext.selectFrom(Name table) |
static Sequence<BigInteger> |
DSL.sequence(Name name)
Create a qualified sequence, given its sequence name.
|
static <T extends Number> |
DSL.sequence(Name name,
Class<T> type)
Create a qualified sequence, given its sequence name.
|
static <T extends Number> |
DSL.sequence(Name name,
DataType<T> type)
Create a qualified sequence, given its sequence name.
|
static Query |
DSL.setCatalog(Name catalog)
Set the current catalog to a new value.
|
Query |
DefaultDSLContext.setCatalog(Name catalog) |
static Query |
DSL.setSchema(Name schema)
Set the current schema to a new value.
|
Query |
DefaultDSLContext.setSchema(Name schema) |
static Table<Record> |
DSL.table(Name name)
Create a qualified table, given its table name.
|
static Table<Record> |
DSL.table(Name name,
Comment comment)
Create a qualified table, given its table name.
|
static TruncateIdentityStep<Record> |
DSL.truncate(Name table)
Create a new DSL truncate statement.
|
TruncateIdentityStep<Record> |
DefaultDSLContext.truncate(Name table) |
static ConstraintFinalStep |
DSL.unique(Name... fields)
Create an unnamed (system named)
UNIQUE constraint. |
static User |
DSL.user(Name name)
Create a new user reference.
|
static WithAsStep |
DSL.with(Name alias)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
DefaultDSLContext.with(Name alias) |
static WithAsStep |
DSL.with(Name alias,
Name... fieldAliases)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
static WithAsStep |
DSL.with(Name alias,
Name... fieldAliases)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
DefaultDSLContext.with(Name alias,
Name... fieldAliases) |
WithAsStep |
DefaultDSLContext.with(Name alias,
Name... fieldAliases) |
static WithAsStep1 |
DSL.with(Name alias,
Name fieldAlias1)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep1 |
DefaultDSLContext.with(Name alias,
Name fieldAlias1) |
static WithAsStep2 |
DSL.with(Name alias,
Name fieldAlias1,
Name fieldAlias2)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep2 |
DefaultDSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2) |
static WithAsStep3 |
DSL.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. |
WithAsStep3 |
DefaultDSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3) |
static WithAsStep4 |
DSL.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. |
WithAsStep4 |
DefaultDSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4) |
static WithAsStep5 |
DSL.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. |
WithAsStep5 |
DefaultDSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5) |
static WithAsStep6 |
DSL.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. |
WithAsStep6 |
DefaultDSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6) |
static WithAsStep7 |
DSL.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. |
WithAsStep7 |
DefaultDSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7) |
static WithAsStep8 |
DSL.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. |
WithAsStep8 |
DefaultDSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8) |
static WithAsStep9 |
DSL.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. |
WithAsStep9 |
DefaultDSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9) |
static WithAsStep10 |
DSL.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. |
WithAsStep10 |
DefaultDSLContext.with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10) |
static WithAsStep11 |
DSL.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. |
WithAsStep11 |
DefaultDSLContext.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) |
static WithAsStep12 |
DSL.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. |
WithAsStep12 |
DefaultDSLContext.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) |
static WithAsStep13 |
DSL.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. |
WithAsStep13 |
DefaultDSLContext.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) |
static WithAsStep14 |
DSL.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. |
WithAsStep14 |
DefaultDSLContext.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) |
static WithAsStep15 |
DSL.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. |
WithAsStep15 |
DefaultDSLContext.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) |
static WithAsStep16 |
DSL.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. |
WithAsStep16 |
DefaultDSLContext.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) |
static WithAsStep17 |
DSL.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. |
WithAsStep17 |
DefaultDSLContext.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) |
static WithAsStep18 |
DSL.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. |
WithAsStep18 |
DefaultDSLContext.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) |
static WithAsStep19 |
DSL.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. |
WithAsStep19 |
DefaultDSLContext.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) |
static WithAsStep20 |
DSL.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. |
WithAsStep20 |
DefaultDSLContext.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) |
static WithAsStep21 |
DSL.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. |
WithAsStep21 |
DefaultDSLContext.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) |
static WithAsStep22 |
DSL.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. |
WithAsStep22 |
DefaultDSLContext.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) |
static WithAsStep |
DSL.withRecursive(Name alias)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
DefaultDSLContext.withRecursive(Name alias) |
static WithAsStep |
DSL.withRecursive(Name alias,
Name... fieldAliases)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
static WithAsStep |
DSL.withRecursive(Name alias,
Name... fieldAliases)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
DefaultDSLContext.withRecursive(Name alias,
Name... fieldAliases) |
WithAsStep |
DefaultDSLContext.withRecursive(Name alias,
Name... fieldAliases) |
static WithAsStep1 |
DSL.withRecursive(Name alias,
Name fieldAlias1)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep1 |
DefaultDSLContext.withRecursive(Name alias,
Name fieldAlias1) |
static WithAsStep2 |
DSL.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep2 |
DefaultDSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2) |
static WithAsStep3 |
DSL.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. |
WithAsStep3 |
DefaultDSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3) |
static WithAsStep4 |
DSL.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. |
WithAsStep4 |
DefaultDSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4) |
static WithAsStep5 |
DSL.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. |
WithAsStep5 |
DefaultDSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5) |
static WithAsStep6 |
DSL.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. |
WithAsStep6 |
DefaultDSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6) |
static WithAsStep7 |
DSL.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. |
WithAsStep7 |
DefaultDSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7) |
static WithAsStep8 |
DSL.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. |
WithAsStep8 |
DefaultDSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8) |
static WithAsStep9 |
DSL.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. |
WithAsStep9 |
DefaultDSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9) |
static WithAsStep10 |
DSL.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. |
WithAsStep10 |
DefaultDSLContext.withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10) |
static WithAsStep11 |
DSL.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. |
WithAsStep11 |
DefaultDSLContext.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) |
static WithAsStep12 |
DSL.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. |
WithAsStep12 |
DefaultDSLContext.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) |
static WithAsStep13 |
DSL.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. |
WithAsStep13 |
DefaultDSLContext.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) |
static WithAsStep14 |
DSL.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. |
WithAsStep14 |
DefaultDSLContext.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) |
static WithAsStep15 |
DSL.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. |
WithAsStep15 |
DefaultDSLContext.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) |
static WithAsStep16 |
DSL.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. |
WithAsStep16 |
DefaultDSLContext.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) |
static WithAsStep17 |
DSL.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. |
WithAsStep17 |
DefaultDSLContext.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) |
static WithAsStep18 |
DSL.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. |
WithAsStep18 |
DefaultDSLContext.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) |
static WithAsStep19 |
DSL.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. |
WithAsStep19 |
DefaultDSLContext.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) |
static WithAsStep20 |
DSL.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. |
WithAsStep20 |
DefaultDSLContext.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) |
static WithAsStep21 |
DSL.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. |
WithAsStep21 |
DefaultDSLContext.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) |
static WithAsStep22 |
DSL.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. |
WithAsStep22 |
DefaultDSLContext.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) |
| Modifier and Type | Method and Description |
|---|---|
CreateViewAsStep<Record> |
DefaultDSLContext.createOrReplaceView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction) |
static CreateViewAsStep |
DSL.createOrReplaceView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DefaultDSLContext.createOrReplaceView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction) |
static CreateViewAsStep |
DSL.createView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction) |
static CreateViewAsStep |
DSL.createViewIfNotExists(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW IF NOT EXISTS statement. |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction) |
| Constructor and Description |
|---|
CatalogImpl(Name name) |
CatalogImpl(Name name,
Comment comment) |
CustomField(Name name,
DataType<T> type) |
CustomTable(Name name) |
CustomTable(Name name,
Schema schema) |
SchemaImpl(Name name) |
SchemaImpl(Name name,
Catalog catalog) |
SchemaImpl(Name name,
Catalog catalog,
Comment comment) |
TableImpl(Name name) |
TableImpl(Name name,
Schema schema) |
TableImpl(Name name,
Schema schema,
Table<?> child,
ForeignKey<?,R> path,
Table<R> aliased,
Field<?>[] parameters,
Comment comment) |
TableImpl(Name name,
Schema schema,
Table<R> aliased) |
TableImpl(Name name,
Schema schema,
Table<R> aliased,
Field<?>[] parameters) |
TableImpl(Name name,
Schema schema,
Table<R> aliased,
Field<?>[] parameters,
Comment comment) |
TableImpl(Name name,
Schema schema,
Table<R> aliased,
Field<?>[] parameters,
String comment)
Deprecated.
- 3.11 - [#7027] - Use
TableImpl.TableImpl(Name, Schema, Table, Field[], Comment) instead. |
Copyright © 2019. All rights reserved.