Uses of Interface
org.jooq.Record
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
JDBC tooling.
This package contains classes related to the
SQLDialect.AURORA_POSTGRES
dialect family.This package contains classes related to the
SQLDialect.EXASOL
dialect family.This package contains classes related to the
SQLDialect.H2
dialect family.This package contains classes related to the
SQLDialect.HSQLDB
dialect family.This package contains classes related to the
SQLDialect.ORACLE
dialect family.This package contains classes related to the
SQLDialect.POSTGRES
dialect family.This package contains classes related to the
SQLDialect.REDSHIFT
dialect family.This package contains classes related to the
SQLDialect.VERTICA
dialect family.This package contains classes related to the
SQLDialect.YUGABYTEDB
dialect family.-
Uses of Record in org.jooq
Modifier and TypeInterfaceDescriptioninterface
BetweenAndStepR<R extends Record>
An intermediate DSL type for the construction of aBETWEEN
predicate.interface
A check constraint.interface
CloseableResultQuery<R extends Record>
AResultQuery
that holds a reference to the underlyingPreparedStatement
without closing it, for reuse.interface
CommonTableExpression<R extends Record>
A common table expression.interface
CreateViewAsStep<R extends Record>
A step in the construction of theCREATE VIEW
statement.interface
Cursors allow for lazy, sequential access to an underlying JDBCResultSet
.interface
ADELETE
statement.interface
DeleteConditionStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
DeleteLimitStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteOrderByStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteQuery<R extends Record>
ADELETE
statement (model API).interface
DeleteResultStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteReturningStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteUsingStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteWhereStep<R extends Record>
This type is used for theDelete
's DSL API.interface
interface
ForeignKey<CHILD extends Record,
PARENT extends Record> AForeignKey
is an object referencing aUniqueKey
.interface
ForeignKey<CHILD extends Record,
PARENT extends Record> AForeignKey
is an object referencing aUniqueKey
.interface
A generator can be used withDataType.generatedAlwaysAs(Generator)
to implement dynamic, client side computed columns, i.e.interface
GeneratorContext<R extends Record,
X extends Table<R>, T> AGeneratorContext
is an argument object that is passed to aGenerator
when generating client side computed columns.interface
AnIdentity
is an object representing anIDENTITY
column as understood by the SQL:2003 standard.interface
AnINSERT
statement.interface
InsertFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
InsertOnConflictConditionStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnConflictDoUpdateStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnConflictWhereIndexPredicateStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnConflictWhereStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnDuplicateSetMoreStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnDuplicateSetStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnDuplicateStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertQuery<R extends Record>
AnINSERT
statement (model API).interface
InsertResultStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertReturningStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertSetMoreStep<R extends Record>
This type is used for theInsert
's alternative DSL API.interface
InsertSetStep<R extends Record>
This type is used for theInsert
's alternative DSL API.interface
InsertValuesStep1<R extends Record,
T1> This type is used for theInsert
's DSL API.interface
InsertValuesStep10<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> This type is used for theInsert
's DSL API.interface
InsertValuesStep11<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> This type is used for theInsert
's DSL API.interface
InsertValuesStep12<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> This type is used for theInsert
's DSL API.interface
InsertValuesStep13<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> This type is used for theInsert
's DSL API.interface
InsertValuesStep14<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> This type is used for theInsert
's DSL API.interface
InsertValuesStep15<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> This type is used for theInsert
's DSL API.interface
InsertValuesStep16<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> This type is used for theInsert
's DSL API.interface
InsertValuesStep17<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> This type is used for theInsert
's DSL API.interface
InsertValuesStep18<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> This type is used for theInsert
's DSL API.interface
InsertValuesStep19<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> This type is used for theInsert
's DSL API.interface
InsertValuesStep2<R extends Record,
T1, T2> This type is used for theInsert
's DSL API.interface
InsertValuesStep20<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> This type is used for theInsert
's DSL API.interface
InsertValuesStep21<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> This type is used for theInsert
's DSL API.interface
InsertValuesStep22<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> This type is used for theInsert
's DSL API.interface
InsertValuesStep3<R extends Record,
T1, T2, T3> This type is used for theInsert
's DSL API.interface
InsertValuesStep4<R extends Record,
T1, T2, T3, T4> This type is used for theInsert
's DSL API.interface
InsertValuesStep5<R extends Record,
T1, T2, T3, T4, T5> This type is used for theInsert
's DSL API.interface
InsertValuesStep6<R extends Record,
T1, T2, T3, T4, T5, T6> This type is used for theInsert
's DSL API.interface
InsertValuesStep7<R extends Record,
T1, T2, T3, T4, T5, T6, T7> This type is used for theInsert
's DSL API.interface
InsertValuesStep8<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8> This type is used for theInsert
's DSL API.interface
InsertValuesStep9<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9> This type is used for theInsert
's DSL API.interface
InsertValuesStepN<R extends Record>
This type is used for theInsert
's DSL API.interface
InverseForeignKey<PARENT extends Record,
CHILD extends Record> AnInverseForeignKey
is an inverseForeignKey
.interface
InverseForeignKey<PARENT extends Record,
CHILD extends Record> AnInverseForeignKey
is an inverseForeignKey
.interface
AKey
is an object representing aUNIQUE KEY
, aPRIMARY KEY
, or aFOREIGN KEY
.interface
TheLoader
API is used for configuring data loads.interface
LoaderCSVOptionsStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderCSVStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderJSONOptionsStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderJSONStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderListenerStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderLoadStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderOptionsStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderRowsStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderSourceStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderXMLStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
AMERGE
statement.interface
MergeFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
MergeKeyStep1<R extends Record,
T1> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep10<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep11<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep12<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep13<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep14<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep15<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep16<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep17<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep18<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep19<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep2<R extends Record,
T1, T2> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep20<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep21<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep22<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep3<R extends Record,
T1, T2, T3> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep4<R extends Record,
T1, T2, T3, T4> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep5<R extends Record,
T1, T2, T3, T4, T5> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep6<R extends Record,
T1, T2, T3, T4, T5, T6> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep7<R extends Record,
T1, T2, T3, T4, T5, T6, T7> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep8<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep9<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStepN<R extends Record>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeMatchedDeleteStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedSetMoreStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedSetStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedThenStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedWhereStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedSetMoreStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedSetStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep1<R extends Record,
T1> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep10<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep11<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep12<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep13<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep14<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep15<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep16<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep17<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep18<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep19<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep2<R extends Record,
T1, T2> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep20<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep21<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep22<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep3<R extends Record,
T1, T2, T3> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep4<R extends Record,
T1, T2, T3, T4> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep5<R extends Record,
T1, T2, T3, T4, T5> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep6<R extends Record,
T1, T2, T3, T4, T5, T6> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep7<R extends Record,
T1, T2, T3, T4, T5, T6, T7> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep8<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep9<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9> This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStepN<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedWhereStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeOnConditionStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeOnStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeUsingStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeValuesStep1<R extends Record,
T1> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep10<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep11<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep12<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep13<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep14<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep15<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep16<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep17<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep18<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep19<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep2<R extends Record,
T1, T2> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep20<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep21<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep22<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep3<R extends Record,
T1, T2, T3> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep4<R extends Record,
T1, T2, T3, T4> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep5<R extends Record,
T1, T2, T3, T4, T5> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep6<R extends Record,
T1, T2, T3, T4, T5, T6> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep7<R extends Record,
T1, T2, T3, T4, T5, T6, T7> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep8<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep9<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStepN<R extends Record>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
A relationship path.interface
A policy that applies row level security to a table.interface
QuantifiedSelect<R extends Record>
A quantified select for use in quantified comparison predicates.interface
RecordHandler<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- 3.15.0 - [#11902] - UseIterable.forEach(Consumer)
based methods, instead.interface
RecordMapper<R extends Record,
E> ARecordMapper
is a mapper that can receiveRecord
objects, when fetching data from the database, transforming them into a custom type<E>
.interface
RecordQualifier<R extends Record>
interface
RecordType<R extends Record>
interface
RecordUnmapper<E,
R extends Record> ARecordUnmapper
is a mapper that can receive user objects and convert them back toRecord
.interface
A wrapper for database results returned by
.SelectQuery
interface
ResultQuery<R extends Record>
A query that can return results.interface
ASELECT
statement.interface
SelectConditionStep<R extends Record>
interface
SelectConnectByAfterStartWithConditionStep<R extends Record>
interface
SelectConnectByAfterStartWithStep<R extends Record>
interface
SelectConnectByConditionStep<R extends Record>
interface
SelectConnectByStep<R extends Record>
interface
SelectCorrelatedSubqueryStep<R extends Record>
interface
SelectDistinctOnStep<R extends Record>
interface
SelectFinalStep<R extends Record>
interface
SelectForJSONCommonDirectivesStep<R extends Record>
interface
SelectForJSONStep<R extends Record>
interface
SelectForStep<R extends Record>
interface
SelectForUpdateOfStep<R extends Record>
interface
SelectForUpdateStep<R extends Record>
interface
SelectForUpdateWaitStep<R extends Record>
interface
SelectForXMLCommonDirectivesStep<R extends Record>
interface
SelectForXMLPathDirectivesStep<R extends Record>
interface
SelectForXMLRawDirectivesStep<R extends Record>
interface
SelectForXMLStep<R extends Record>
interface
SelectFromStep<R extends Record>
interface
SelectGroupByStep<R extends Record>
interface
SelectHavingConditionStep<R extends Record>
interface
SelectHavingStep<R extends Record>
interface
SelectIntoStep<R extends Record>
interface
SelectJoinPartitionByStep<R extends Record>
interface
SelectJoinStep<R extends Record>
interface
SelectLimitAfterOffsetStep<R extends Record>
interface
SelectLimitPercentAfterOffsetStep<R extends Record>
interface
SelectLimitPercentStep<R extends Record>
interface
SelectLimitStep<R extends Record>
interface
SelectOffsetStep<R extends Record>
interface
SelectOnConditionStep<R extends Record>
interface
SelectOnStep<R extends Record>
interface
SelectOptionalOnStep<R extends Record>
interface
SelectOptionStep<R extends Record>
interface
SelectOrderByStep<R extends Record>
interface
SelectQualifyConditionStep<R extends Record>
interface
SelectQualifyStep<R extends Record>
interface
SelectQuery<R extends Record>
ASELECT
statement (model API).interface
SelectSeekLimitStep<R extends Record>
interface
SelectSeekStep1<R extends Record,
T1> interface
SelectSeekStep10<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> interface
SelectSeekStep11<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> interface
SelectSeekStep12<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> interface
SelectSeekStep13<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> interface
SelectSeekStep14<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> interface
SelectSeekStep15<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> interface
SelectSeekStep16<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> interface
SelectSeekStep17<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> interface
SelectSeekStep18<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> interface
SelectSeekStep19<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> interface
SelectSeekStep2<R extends Record,
T1, T2> interface
SelectSeekStep20<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> interface
SelectSeekStep21<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> interface
SelectSeekStep22<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> interface
SelectSeekStep3<R extends Record,
T1, T2, T3> interface
SelectSeekStep4<R extends Record,
T1, T2, T3, T4> interface
SelectSeekStep5<R extends Record,
T1, T2, T3, T4, T5> interface
SelectSeekStep6<R extends Record,
T1, T2, T3, T4, T5, T6> interface
SelectSeekStep7<R extends Record,
T1, T2, T3, T4, T5, T6, T7> interface
SelectSeekStep8<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8> interface
SelectSeekStep9<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9> interface
SelectSeekStepN<R extends Record>
interface
SelectSelectStep<R extends Record>
interface
SelectStartWithStep<R extends Record>
interface
SelectUnionStep<R extends Record>
interface
SelectWhereStep<R extends Record>
interface
SelectWindowStep<R extends Record>
interface
SelectWithTiesAfterOffsetStep<R extends Record>
interface
SelectWithTiesStep<R extends Record>
interface
StoreQuery<R extends Record>
A query storing objects to the database.interface
A table.interface
TableField<R extends Record,
T> A field contained in a table.interface
An object that can behave like a table (a table-like object).interface
TableOnConditionStep<R extends Record>
An intermediate (optional) type for the construction of aJOIN
clause, where the join criteria is added using anON
clause (with aCondition
.interface
TableOnStep<R extends Record>
interface
TableOptionalOnStep<R extends Record>
interface
TableOuterJoinStep<R extends Record>
An intermediate type for the construction of a partitionedSQLDialect.ORACLE
OUTER JOIN
clause.interface
TablePartitionByStep<R extends Record>
An intermediate type for the construction of a partitionedSQLDialect.ORACLE
OUTER JOIN
clause.interface
A step in the construction of theTRUNCATE
statement.interface
TruncateCascadeStep<R extends Record>
A step in the construction of theTRUNCATE
statement.interface
TruncateFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
TruncateIdentityStep<R extends Record>
A step in the construction of theTRUNCATE
statement.interface
UDTPathField<R extends Record,
U extends UDTRecord<U>, T> A field dereferenced from a UDT path.interface
UDTPathTableField<R extends Record,
U extends UDTRecord<U>, T> A field dereferenced from a UDT path.interface
AUniqueKey
is an object representing aUNIQUE KEY
or aPRIMARY KEY
.interface
AnUPDATE
statement.interface
UpdateConditionStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
UpdateFromStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateLimitStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateOrderByStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateQuery<R extends Record>
AnUPDATE
statement (model API).interface
UpdateResultStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateReturningStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateSetFirstStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateSetMoreStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateSetStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateWhereStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
VersionsBetweenAndStep<R extends Record,
T> This type is used for the OracleVERSIONS
clause DSL API, providing access to the flashback versions query clauses.Modifier and TypeInterfaceDescriptioninterface
EmbeddableRecord<R extends EmbeddableRecord<R>>
An embeddable record.interface
QualifiedRecord<R extends QualifiedRecord<R>>
interface
Record1<T1>
A model type for a records with degree1
interface
Record10<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10> A model type for a records with degree10
interface
Record11<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> A model type for a records with degree11
interface
Record12<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> A model type for a records with degree12
interface
Record13<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> A model type for a records with degree13
interface
Record14<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> A model type for a records with degree14
interface
Record15<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> A model type for a records with degree15
interface
Record16<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> A model type for a records with degree16
interface
Record17<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> A model type for a records with degree17
interface
Record18<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> A model type for a records with degree18
interface
Record19<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> A model type for a records with degree19
interface
Record2<T1,
T2> A model type for a records with degree2
interface
Record20<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> A model type for a records with degree20
interface
Record21<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> A model type for a records with degree21
interface
Record22<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> A model type for a records with degree22
interface
Record3<T1,
T2, T3> A model type for a records with degree3
interface
Record4<T1,
T2, T3, T4> A model type for a records with degree4
interface
Record5<T1,
T2, T3, T4, T5> A model type for a records with degree5
interface
Record6<T1,
T2, T3, T4, T5, T6> A model type for a records with degree6
interface
Record7<T1,
T2, T3, T4, T5, T6, T7> A model type for a records with degree7
interface
Record8<T1,
T2, T3, T4, T5, T6, T7, T8> A model type for a records with degree8
interface
Record9<T1,
T2, T3, T4, T5, T6, T7, T8, T9> A model type for a records with degree9
interface
TableRecord<R extends TableRecord<R>>
A record originating from a single tableinterface
An object holding data of a UDTinterface
UpdatableRecord<R extends UpdatableRecord<R>>
A common interface for records that can be stored back to the database again.Modifier and TypeMethodDescription<R extends Record>
@NotNull CommonTableExpression<R>DerivedColumnList.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>Name.as
(ResultQuery<R> query) Specify a subselect to refer to by theName
to form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>DerivedColumnList.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>Name.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theName
to form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>DerivedColumnList.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>Name.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theName
to form a common table expression.<X extends Record>
@NotNull CloseableResultQuery<X><X extends Record>
@NotNull ResultQuery<X>Coerce the result record type of this query to that of a table.<R extends Record>
@NotNull DeleteUsingStep<R>Create a new DSL delete statement.<R extends Record>
@NotNull DeleteUsingStep<R>Create a new DSL delete statement.<R extends Record>
@NotNull DeleteUsingStep<R>DSLContext.deleteFrom
(Table<R> table) Create a new DSL delete statement.<R extends Record>
@NotNull DeleteQuery<R>DSLContext.deleteQuery
(Table<R> table) Create a newDeleteQuery
DSLContext.fetch
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return results.Execute and return all records forDSLContext.fetch
(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records forExecute and return all records forExecute and return all records for<R extends Record>
RExecute and return zero or one record for<R extends Record>
RDSLContext.fetchAny
(Table<R> table, Collection<? extends Condition> conditions) Execute and return zero or one record for<R extends Record>
RExecute and return zero or one record for<R extends Record>
RExecute and return zero or on e record for<Z extends Record>
ZResultQuery.fetchAnyInto
(Table<Z> table) Map resulting records onto a custom record.<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Executor executor, ResultQuery<R> query) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Executor executor, Table<R> table) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Executor executor, Table<R> table, Collection<? extends Condition> conditions) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Executor executor, Table<R> table, Condition condition) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Executor executor, Table<R> table, Condition... conditions) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(ResultQuery<R> query) Fetch results in a newCompletionStage
.<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Table<R> table) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Table<R> table, Collection<? extends Condition> condition) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Table<R> table, Condition condition) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Table<R> table, Condition... condition) Execute and return all records asynchronously forResultQuery.fetchGroups
(Table<S> table) Execute the query and return aMap
with the result grouped by the given table.ResultQuery.fetchGroups
(Table<S> table, Class<? extends E> type) Execute the query and return aMap
with results grouped by the given table and mapped into the given entity type.ResultQuery.fetchGroups
(Table<S> table, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given table and mapped by the given mapper.ResultQuery.fetchGroups
(Table<S> keyTable, Table<T> valueTable) Execute the query and return aMap
with the result grouped by the given table.ResultQuery.fetchGroups
(Table<S> keyTable, Table<T> valueTable) Execute the query and return aMap
with the result grouped by the given table.Map resulting records onto a custom record.Map resulting records onto a custom record.DSLContext.fetchLazy
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a cursor.Execute and return all records lazily forDSLContext.fetchLazy
(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records lazily forExecute and return all records lazily forExecute and return all records lazily forDSLContext.fetchMany
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a cursor.Execute the query and return aMap
with table as a map key and the corresponding record as value.Execute the query and return aMap
with results grouped by the given table and mapped into the given entity type.ResultQuery.fetchMap
(Table<S> table, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given table and mapped by the given mapper.Execute the query and return aMap
with table as a map key and the corresponding record as value.Execute the query and return aMap
with table as a map key and the corresponding record as value.<Z extends Record>
ZCursor.fetchNextInto
(Table<Z> table) Map the next resulting record onto a custom record.Cursor.fetchNextOptionalInto
(Table<Z> table) Map the next resulting record onto a custom record.<R extends Record>
RDSLContext.fetchOne
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a record.<R extends Record>
RExecute and return zero or one record for<R extends Record>
RDSLContext.fetchOne
(Table<R> table, Collection<? extends Condition> conditions) Execute and return zero or one record for<R extends Record>
RExecute and return zero or one record for<R extends Record>
RExecute and return zero or one record for<Z extends Record>
ZCursor.fetchOneInto
(Table<Z> table) Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6363] - UseCursor.fetchNextInto(Table)
instead.<Z extends Record>
ZResultQuery.fetchOneInto
(Table<Z> table) Map resulting records onto a custom record.DSLContext.fetchOptional
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a record.DSLContext.fetchOptional
(Table<R> table) Execute and return zero or one record forDSLContext.fetchOptional
(Table<R> table, Collection<? extends Condition> conditions) Execute and return zero or one record forDSLContext.fetchOptional
(Table<R> table, Condition condition) Execute and return zero or one record forDSLContext.fetchOptional
(Table<R> table, Condition... conditions) Execute and return zero or one record forCursor.fetchOptionalInto
(Table<Z> table) Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6363] - UseCursor.fetchNextOptionalInto(Table)
instead.ResultQuery.fetchOptionalInto
(Table<Z> table) Map resulting records onto a custom record.<R extends Record>
RDSLContext.fetchSingle
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a record.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table) Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Collection<? extends Condition> conditions) Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition condition) Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition... conditions) Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDisambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21, Condition c22) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...)
.<Z extends Record>
ZResultQuery.fetchSingleInto
(Table<Z> table) Map resulting records onto a custom record.DSLContext.fetchStream
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a stream.DSLContext.fetchStream
(Table<R> table) Execute and return all records lazily forDSLContext.fetchStream
(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records lazily forDSLContext.fetchStream
(Table<R> table, Condition condition) Execute and return all records lazily forDSLContext.fetchStream
(Table<R> table, Condition... conditions) Execute and return all records lazily forResultQuery.fetchStreamInto
(Table<Z> table) Stream this query, mapping records into a custom record.<O extends Record>
@NotNull List<ForeignKey<O,R>> Table.getReferencesFrom
(Table<O> other) Get a list ofFOREIGN KEY
's of a specific table, referencing a this table.<O extends Record>
@NotNull List<ForeignKey<R,O>> Table.getReferencesTo
(Table<O> other) Get a list ofFOREIGN KEY
's of this table, referencing a specific table.<R extends Record>
@NotNull InsertSetStep<R>DSLContext.insertInto
(Table<R> into) Create a new DSL insert statement.<R extends Record>
@NotNull InsertValuesStepN<R>DSLContext.insertInto
(Table<R> into, Collection<? extends Field<?>> fields) Create a new DSL insert statement.<R extends Record>
@NotNull InsertValuesStepN<R>DSLContext.insertInto
(Table<R> into, Field<?>... fields) Create a new DSL insert statement.<R extends Record,
T1>
@NotNull InsertValuesStep1<R,T1> DSLContext.insertInto
(Table<R> into, Field<T1> field1) Create a new DSL insert statement.<R extends Record,
T1, T2>
@NotNull InsertValuesStep2<R,T1, T2> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2) Create a new DSL insert statement.<R extends Record,
T1, T2, T3>
@NotNull InsertValuesStep3<R,T1, T2, T3> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4>
@NotNull InsertValuesStep4<R,T1, T2, T3, T4> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5>
@NotNull InsertValuesStep5<R,T1, T2, T3, T4, T5> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6>
@NotNull InsertValuesStep6<R,T1, T2, T3, T4, T5, T6> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7>
@NotNull InsertValuesStep7<R,T1, T2, T3, T4, T5, T6, T7> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull InsertValuesStep8<R,T1, T2, T3, T4, T5, T6, T7, T8> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull InsertValuesStep9<R,T1, T2, T3, T4, T5, T6, T7, T8, T9> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull InsertValuesStep10<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull InsertValuesStep11<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull InsertValuesStep12<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull InsertValuesStep13<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull InsertValuesStep14<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull InsertValuesStep15<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull InsertValuesStep16<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull InsertValuesStep17<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull InsertValuesStep18<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull InsertValuesStep19<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull InsertValuesStep20<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull InsertValuesStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull InsertValuesStep22<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> DSLContext.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Create a new DSL insert statement.<R extends Record>
@NotNull InsertSetStep<R>WithStep.insertInto
(Table<R> into) Create a new DSL insert statement.<R extends Record>
@NotNull InsertValuesStepN<R>WithStep.insertInto
(Table<R> into, Collection<? extends Field<?>> fields) Create a new DSL insert statement.<R extends Record>
@NotNull InsertValuesStepN<R>WithStep.insertInto
(Table<R> into, Field<?>... fields) Create a new DSL insert statement.<R extends Record,
T1>
@NotNull InsertValuesStep1<R,T1> WithStep.insertInto
(Table<R> into, Field<T1> field1) Create a new DSL insert statement.<R extends Record,
T1, T2>
@NotNull InsertValuesStep2<R,T1, T2> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2) Create a new DSL insert statement.<R extends Record,
T1, T2, T3>
@NotNull InsertValuesStep3<R,T1, T2, T3> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4>
@NotNull InsertValuesStep4<R,T1, T2, T3, T4> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5>
@NotNull InsertValuesStep5<R,T1, T2, T3, T4, T5> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6>
@NotNull InsertValuesStep6<R,T1, T2, T3, T4, T5, T6> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7>
@NotNull InsertValuesStep7<R,T1, T2, T3, T4, T5, T6, T7> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull InsertValuesStep8<R,T1, T2, T3, T4, T5, T6, T7, T8> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull InsertValuesStep9<R,T1, T2, T3, T4, T5, T6, T7, T8, T9> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull InsertValuesStep10<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull InsertValuesStep11<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull InsertValuesStep12<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull InsertValuesStep13<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull InsertValuesStep14<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull InsertValuesStep15<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull InsertValuesStep16<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull InsertValuesStep17<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull InsertValuesStep18<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull InsertValuesStep19<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull InsertValuesStep20<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull InsertValuesStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Create a new DSL insert statement.<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull InsertValuesStep22<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> WithStep.insertInto
(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Create a new DSL insert statement.<R extends Record>
@NotNull InsertQuery<R>DSLContext.insertQuery
(Table<R> into) Create a newInsertQuery
<R extends Record>
RMap resulting records onto a custom record type.Map resulting records onto a custom record.Create a collector that can collectRecord
resulting from aResultQuery
into an array of a mapped type.Create a collector that can collectRecord
resulting from aResultQuery
into an array of a mapped type.Records.intoGroups
(Function<? super R, ? extends K> keyMapper) Create a collector that can collectRecord
resulting from aResultQuery
into aMap
using the result of the argumentRecordMapper
as key collecting the records themselves into a list of values.Records.intoGroups
(Function<? super R, ? extends K> keyMapper, Function<? super R, ? extends V> valueMapper) Create a collector that can collectRecord
resulting from aResultQuery
into aMap
using the result of the argumentRecordMapper
as key collecting the result of another argumentRecordMapper
into a list of values.Result.intoGroups
(Table<S> table) Return aMap
with the result grouped by the given key table.Result.intoGroups
(Table<S> table, Class<? extends E> type) Return aMap
with results grouped by the given key table and mapped into the given entity type.Result.intoGroups
(Table<S> table, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given key table and mapped into the given entity type.Result.intoGroups
(Table<S> keyTable, Table<T> valueTable) Return aMap
with the result grouped by the given key table.Result.intoGroups
(Table<S> keyTable, Table<T> valueTable) Return aMap
with the result grouped by the given key table.Records.intoHierarchy
(Function<? super R, ? extends K> keyMapper, Function<? super R, ? extends K> parentKeyMapper, Function<? super R, ? extends E> nodeMapper, BiConsumer<? super E, ? super E> parentChildAppender) Create a collector that can collectRecord
resulting from aResultQuery
into a hierarchy of custom data types.Create a collector that can collectRecord
resulting from aResultQuery
into aList
of a mapped type.Create a collector that can collectRecord
resulting from aResultQuery
into aMap
using the result of the argumentRecordMapper
as key and the record itself as value.Records.intoMap
(Function<? super R, ? extends K> keyMapper, Function<? super R, ? extends V> valueMapper) Create a collector that can collectRecord
resulting from aResultQuery
into aMap
using the result of the argumentRecordMapper
as key and the result of another argumentRecordMapper
as value.Return aMap
with the given key table as a map key and the corresponding record as value.Return aMap
with results grouped by the given key table and mapped into the given entity type.Result.intoMap
(Table<S> table, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given key table and mapped by the given mapper.Return aMap
with the given key table as a map key and the corresponding record as value.Return aMap
with the given key table as a map key and the corresponding record as value.Records.intoResultGroups
(Function<? super R, ? extends K> keyMapper) Create a collector that can collectRecord
resulting from aResultQuery
into aMap
using the result of the argumentRecordMapper
as key collecting the records themselves into aResult
.Records.intoResultGroups
(Function<? super R, ? extends K> keyMapper, Function<? super R, ? extends V> valueMapper) Create a collector that can collectRecord
resulting from aResultQuery
into aMap
using the result of the argumentRecordMapper
as key collecting the result of another argumentRecordMapper
into aResult
of values.Records.intoResultGroups
(Function<? super R, ? extends K> keyMapper, Function<? super R, ? extends V> valueMapper) Create a collector that can collectRecord
resulting from aResultQuery
into aMap
using the result of the argumentRecordMapper
as key collecting the result of another argumentRecordMapper
into aResult
of values.Create a collector that can collectRecord
resulting from aResultQuery
into aSet
of a mapped type.<R extends Record>
@NotNull LoaderOptionsStep<R>Create a newLoader
object to load data from a CSV or XML source.Map a table to another one.Deprecated, for removal: This API element is subject to removal in a future version.Apply mapping to a given table<R extends Record>
@NotNull MergeUsingStep<R>Create a new DSL SQL standard MERGE statement.<R extends Record>
@NotNull MergeKeyStepN<R>DSLContext.mergeInto
(Table<R> table, Collection<? extends Field<?>> fields) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record>
@NotNull MergeKeyStepN<R>Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1>
@NotNull MergeKeyStep1<R,T1> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2>
@NotNull MergeKeyStep2<R,T1, T2> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3>
@NotNull MergeKeyStep3<R,T1, T2, T3> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4>
@NotNull MergeKeyStep4<R,T1, T2, T3, T4> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5>
@NotNull MergeKeyStep5<R,T1, T2, T3, T4, T5> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6>
@NotNull MergeKeyStep6<R,T1, T2, T3, T4, T5, T6> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7>
@NotNull MergeKeyStep7<R,T1, T2, T3, T4, T5, T6, T7> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull MergeKeyStep8<R,T1, T2, T3, T4, T5, T6, T7, T8> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull MergeKeyStep9<R,T1, T2, T3, T4, T5, T6, T7, T8, T9> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull MergeKeyStep10<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull MergeKeyStep11<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull MergeKeyStep12<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull MergeKeyStep13<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull MergeKeyStep14<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull MergeKeyStep15<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull MergeKeyStep16<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull MergeKeyStep17<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull MergeKeyStep18<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull MergeKeyStep19<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull MergeKeyStep20<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull MergeKeyStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull MergeKeyStep22<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> DSLContext.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record>
@NotNull MergeUsingStep<R>Create a new DSL SQL standard MERGE statement.<R extends Record>
@NotNull MergeKeyStepN<R>WithStep.mergeInto
(Table<R> table, Collection<? extends Field<?>> fields) Create a new DSL merge statement (H2-specific syntax).<R extends Record>
@NotNull MergeKeyStepN<R>Create a new DSL merge statement (H2-specific syntax).<R extends Record,
T1>
@NotNull MergeKeyStep1<R,T1> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2>
@NotNull MergeKeyStep2<R,T1, T2> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3>
@NotNull MergeKeyStep3<R,T1, T2, T3> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4>
@NotNull MergeKeyStep4<R,T1, T2, T3, T4> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5>
@NotNull MergeKeyStep5<R,T1, T2, T3, T4, T5> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6>
@NotNull MergeKeyStep6<R,T1, T2, T3, T4, T5, T6> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7>
@NotNull MergeKeyStep7<R,T1, T2, T3, T4, T5, T6, T7> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull MergeKeyStep8<R,T1, T2, T3, T4, T5, T6, T7, T8> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull MergeKeyStep9<R,T1, T2, T3, T4, T5, T6, T7, T8, T9> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull MergeKeyStep10<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull MergeKeyStep11<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull MergeKeyStep12<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull MergeKeyStep13<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull MergeKeyStep14<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull MergeKeyStep15<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull MergeKeyStep16<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull MergeKeyStep17<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull MergeKeyStep18<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull MergeKeyStep19<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull MergeKeyStep20<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull MergeKeyStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull MergeKeyStep22<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> WithStep.mergeInto
(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record>
RCreate a newRecord
that can be inserted into the corresponding table.<R extends Record>
RCreate a new pre-filledRecord
that can be inserted into the corresponding table.Create a new emptyResult
.Provide a list ofPolicy
for a table's row level security.<R extends Record,
E>
@NotNull RecordMapper<R,E> RecordMapperProvider.provide
(RecordType<R> recordType, Class<? extends E> type) Provide aRecordMapper
instance.<E,
R extends Record>
@NotNull RecordUnmapper<E,R> RecordUnmapperProvider.provide
(Class<? extends E> type, RecordType<R> recordType) Provide aRecordUnmapper
instance.<R extends Record>
@NotNull SelectWhereStep<R>DSLContext.selectFrom
(TableLike<R> table) Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
@NotNull SelectWhereStep<R>WithStep.selectFrom
(TableLike<R> table) Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
@NotNull SelectQuery<R>DSLContext.selectQuery
(TableLike<R> table) Create a newSelectQuery
<R extends Record>
@NotNull TruncateIdentityStep<R>TheTRUNCATE
statement.<R extends Record>
@NotNull TruncateIdentityStep<R>DSLContext.truncateTable
(Table<R> table) TheTRUNCATE TABLE
statement.<R extends Record>
@NotNull UpdateSetFirstStep<R>Create a new DSL update statement.<R extends Record>
@NotNull UpdateSetFirstStep<R>Create a new DSL update statement.<R extends Record>
@NotNull UpdateQuery<R>DSLContext.updateQuery
(Table<R> table) Create a newUpdateQuery
Modifier and TypeMethodDescription@NotNull Record @NotNull []
RecordContext.batchRecords()
TheRecord
(s) that are being manipulated in batch mode.@NotNull R @NotNull []
ResultQuery.fetchArray()
Execute the query and return the generated result as an array of records.@Nullable Record
Execute a new query holding plain SQL.@Nullable Record
Execute a new query holding plain SQL.@Nullable Record
Execute a new query holding plain SQL.@Nullable Record
@Nullable Record
@Nullable Record
@Nullable Record
@Nullable Record
Execute a new query holding plain SQL.@NotNull Record
DSLContext.fetchSingle
(String sql) Execute a new query holding plain SQL.@NotNull Record
DSLContext.fetchSingle
(String sql, Object... bindings) Execute a new query holding plain SQL.@NotNull Record
DSLContext.fetchSingle
(String sql, QueryPart... parts) Execute a new query holding plain SQL.@NotNull Record
DSLContext.fetchSingle
(ResultSet rs) @NotNull Record
DSLContext.fetchSingle
(ResultSet rs, Class<?>... types) @NotNull Record
DSLContext.fetchSingle
(ResultSet rs, DataType<?>... types) @NotNull Record
DSLContext.fetchSingle
(ResultSet rs, Field<?>... fields) @NotNull Record
DSLContext.fetchSingle
(Collection<? extends SelectField<?>> fields) Execute and return exactly one record for@NotNull Record
DSLContext.fetchSingle
(SelectField<?>... fields) Execute and return exactly one record for@NotNull Record
DSLContext.fetchSingle
(SQL sql) Execute a new query holding plain SQL.@NotNull Record
Copy this record into a new record holding only a subset of the previous fields, usingFields.field(Field)
for lookup.@NotNull Record
UpdatableRecord.key()
A Record copy holding values for theTable.getPrimaryKey()
.@NotNull Record
DSLContext.newRecord
(Collection<? extends Field<?>> fields) Create a new emptyRecord
.@NotNull Record
Create a new emptyRecord
.@NotNull Record
Record.original()
Get this record containing the original values as fetched from the database.@Nullable Record
ExecuteContext.record()
The last record that was fetched from the result set, ornull
if no record has been fetched.@NotNull Record
RecordContext.record()
TheRecord
that is being manipulated.<T> @NotNull Record
Set a value into this record, usingFields.field(Field)
for lookup.<T,
U> @NotNull Record Set a value into this record, usingFields.field(Field)
for lookup.Modifier and TypeMethodDescription@NotNull CloseableResultQuery<Record>
CloseableResultQuery.coerce
(Collection<? extends Field<?>> fields) @NotNull CloseableResultQuery<Record>
@NotNull ResultQuery<Record>
ResultQuery.coerce
(Collection<? extends Field<?>> fields) Coerce the result record type of this query to that of a set of fields.@NotNull ResultQuery<Record>
Coerce the result record type of this query to that of a set of fields.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedView
(String view, String... fields) TheCREATE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedView
(String view, Collection<? extends String> fields) TheCREATE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedView
(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedView
(Name view, Name... fields) TheCREATE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedView
(Table<?> view, Field<?>... fields) TheCREATE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedViewIfNotExists
(String view, String... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedViewIfNotExists
(String view, Collection<? extends String> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedViewIfNotExists
(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedViewIfNotExists
(Name view, Name... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedViewIfNotExists
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedViewIfNotExists
(Table<?> view, Field<?>... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceMaterializedView
(String view, String... fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceMaterializedView
(String view, Collection<? extends String> fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceMaterializedView
(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceMaterializedView
(Name view, Name... fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceMaterializedView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceMaterializedView
(Table<?> view, Field<?>... fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(String view, String... fields) TheCREATE OR REPLACE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(String view, Collection<? extends String> fields) TheCREATE OR REPLACE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Name view, Name... fields) TheCREATE OR REPLACE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE OR REPLACE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Table<?> view, Field<?>... fields) TheCREATE OR REPLACE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(String view, String... fields) TheCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(String view, Collection<? extends String> fields) TheCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Name view, Collection<? extends Name> fields) TheCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Name view, Name... fields) TheCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Table<?> view, Field<?>... fields) TheCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(String view, String... fields) TheCREATE VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(String view, Collection<? extends String> fields) TheCREATE VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Name view, Collection<? extends Name> fields) TheCREATE VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Name view, Name... fields) TheCREATE VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Table<?> view, Field<?>... fields) TheCREATE VIEW IF NOT EXISTS
statement.Table.crossApply
(String sql) CROSS APPLY
a table to this table.Table.crossApply
(String sql, Object... bindings) CROSS APPLY
a table to this table.Table.crossApply
(String sql, QueryPart... parts) CROSS APPLY
a table to this table.Table.crossApply
(Name name) CROSS APPLY
a table to this table.Table.crossApply
(SQL sql) CROSS APPLY
a table to this table.Table.crossApply
(TableLike<?> table) CROSS APPLY
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.Execute a new query holding plain SQL.Execute a new query holding plain SQL.Execute a new query holding plain SQL.Execute a new query holding plain SQL.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(String sql) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(String sql, Object... bindings) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(String sql, QueryPart... parts) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(ResultSet rs) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(ResultSet rs, Class<?>... types) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(ResultSet rs, DataType<?>... types) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(ResultSet rs, Field<?>... fields) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, String sql) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, String sql, Object... bindings) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, String sql, QueryPart... parts) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, ResultSet rs) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, ResultSet rs, Class<?>... types) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, ResultSet rs, DataType<?>... types) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, ResultSet rs, Field<?>... fields) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, SQL sql) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(SQL sql) Fetch results in a newCompletionStage
.DSLContext.fetchFromCSV
(String string) Fetch all data from a CSV string.DSLContext.fetchFromCSV
(String string, boolean header) Fetch all data from a CSV string.DSLContext.fetchFromCSV
(String string, boolean header, char delimiter) Fetch all data from a CSV string.DSLContext.fetchFromCSV
(String string, char delimiter) Fetch all data from a CSV string.DSLContext.fetchFromHTML
(String string) Convert an HTML table into a jOOQResult
.DSLContext.fetchFromJSON
(String string) Fetch all data from a JSON string.DSLContext.fetchFromStringData
(String[]... data) Fetch all data from a list of strings.DSLContext.fetchFromStringData
(List<String[]> data) Fetch all data from a list of strings.DSLContext.fetchFromStringData
(List<String[]> data, boolean header) Fetch all data from a list of strings.DSLContext.fetchFromTXT
(String string) Fetch all data from a formatted string.DSLContext.fetchFromTXT
(String string, String nullLiteral) Fetch all data from a formatted string.DSLContext.fetchFromXML
(String string) Fetch all data from an XML string.ResultQuery.fetchGroups
(int[] keyFieldIndexes) Execute the query and return aMap
with the result grouped by the given keys.ResultQuery.fetchGroups
(int[] keyFieldIndexes, int[] valueFieldIndexes) Execute the query and return aMap
with the result grouped by the given keys.ResultQuery.fetchGroups
(int[] keyFieldIndexes, int[] valueFieldIndexes) Execute the query and return aMap
with the result grouped by the given keys.ResultQuery.fetchGroups
(int[] keyFieldIndexes, Class<? extends E> type) Execute the query and return aMap
with results grouped by the given keys and mapped into the given entity type.ResultQuery.fetchGroups
(int[] keyFieldIndexes, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given keys and mapped by the given mapper.ResultQuery.fetchGroups
(String[] keyFieldNames) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(String)
for lookup.ResultQuery.fetchGroups
(String[] keyFieldNames, Class<? extends E> type) Execute the query and return aMap
with results grouped by the given keys and mapped into the given entity type, usingFields.field(String)
for lookup.ResultQuery.fetchGroups
(String[] keyFieldNames, String[] valueFieldNames) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(String)
for lookup.ResultQuery.fetchGroups
(String[] keyFieldNames, String[] valueFieldNames) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(String)
for lookup.ResultQuery.fetchGroups
(String[] keyFieldNames, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given keys and mapped by the given mapper, usingFields.field(String)
for lookup.ResultQuery.fetchGroups
(Field<?>[] keys) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(Field)
for lookup.ResultQuery.fetchGroups
(Field<?>[] keys, Class<? extends E> type) Execute the query and return aMap
with results grouped by the given keys and mapped into the given entity type, usingFields.field(Field)
for lookup.ResultQuery.fetchGroups
(Field<?>[] keys, Field<?>[] values) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(Field)
for lookup.ResultQuery.fetchGroups
(Field<?>[] keys, Field<?>[] values) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(Field)
for lookup.ResultQuery.fetchGroups
(Field<?>[] keys, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given keys and mapped by the given mapper, usingFields.field(Field)
for lookup.ResultQuery.fetchGroups
(Name[] keyFieldNames) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(Name)
for lookup.ResultQuery.fetchGroups
(Name[] keyFieldNames, Class<? extends E> type) Execute the query and return aMap
with results grouped by the given keys and mapped into the given entity type, usingFields.field(Name)
for lookup.ResultQuery.fetchGroups
(Name[] keyFieldNames, Name[] valueFieldNames) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(Name)
for lookup.ResultQuery.fetchGroups
(Name[] keyFieldNames, Name[] valueFieldNames) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(Name)
for lookup.ResultQuery.fetchGroups
(Name[] keyFieldNames, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given keys and mapped by the given mapper, usingFields.field(Name)
for lookup.Execute a new query holding plain SQL and "lazily" return the generated result.Execute a new query holding plain SQL and "lazily" return the generated result.Execute a new query holding plain SQL and "lazily" return the generated result.Execute a new query holding plain SQL and "lazily" return the generated result.ResultQuery.fetchMap
(int[] keyFieldIndexes) Execute the query and return aMap
with keys as a map key and the corresponding record as value.ResultQuery.fetchMap
(int[] keyFieldIndexes, int[] valueFieldIndexes) Execute the query and return aMap
with keys as a map key and the corresponding record as value.ResultQuery.fetchMap
(int[] keyFieldIndexes, int[] valueFieldIndexes) Execute the query and return aMap
with keys as a map key and the corresponding record as value.Execute the query and return aMap
with keys as a map key and the corresponding record as value, usingFields.field(String)
for lookup.Execute the query and return aMap
with keys as a map key and the corresponding record as value, usingFields.field(String)
for lookup.Execute the query and return aMap
with keys as a map key and the corresponding record as value, usingFields.field(String)
for lookup.Execute the query and return aMap
with keys as a map key and the corresponding record as value, usingFields.field(Field)
for lookup.Execute the query and return aMap
with keys as a map key and the corresponding record as value, usingFields.field(Field)
for lookup.Execute the query and return aMap
with keys as a map key and the corresponding record as value, usingFields.field(Field)
for lookup.Execute the query and return aMap
with keys as a map key and the corresponding record as value, usingFields.field(Name)
for lookup.Execute the query and return aMap
with keys as a map key and the corresponding record as value, usingFields.field(Name)
for lookup.Execute the query and return aMap
with keys as a map key and the corresponding record as value, usingFields.field(Name)
for lookup.DSLContext.fetchOptional
(String sql) Execute a new query holding plain SQL.DSLContext.fetchOptional
(String sql, Object... bindings) Execute a new query holding plain SQL.DSLContext.fetchOptional
(String sql, QueryPart... parts) Execute a new query holding plain SQL.DSLContext.fetchOptional
(ResultSet rs) DSLContext.fetchOptional
(ResultSet rs, Class<?>... types) DSLContext.fetchOptional
(ResultSet rs, DataType<?>... types) DSLContext.fetchOptional
(ResultSet rs, Field<?>... fields) DSLContext.fetchOptional
(SQL sql) Execute a new query holding plain SQL.DSLContext.fetchStream
(String sql) Execute a new query holding plain SQL and "lazily" return the generated result.DSLContext.fetchStream
(String sql, Object... bindings) Execute a new query holding plain SQL and "lazily" return the generated result.DSLContext.fetchStream
(String sql, QueryPart... parts) Execute a new query holding plain SQL and "lazily" return the generated result.DSLContext.fetchStream
(ResultSet rs) DSLContext.fetchStream
(ResultSet rs, Class<?>... types) DSLContext.fetchStream
(ResultSet rs, DataType<?>... types) DSLContext.fetchStream
(ResultSet rs, Field<?>... fields) DSLContext.fetchStream
(SQL sql) Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull TableOptionalOnStep<Record>
Table.fullHashJoin
(Path<?> path) FULL OUTER JOIN
a path to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
Table.fullHashJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
FULL OUTER JOIN
a path to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
Table.fullLoopJoin
(Path<?> path) FULL OUTER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TablePartitionByStep<Record>
Table.fullLoopJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull TableOptionalOnStep<Record>
Table.fullMergeJoin
(Path<?> path) FULL OUTER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TablePartitionByStep<Record>
Table.fullMergeJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull TableOptionalOnStep<Record>
Table.fullOuterHashJoin
(Path<?> path) FULL OUTER JOIN
a path to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
Table.fullOuterHashJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
Table.fullOuterJoin
(String sql) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.fullOuterJoin
(String sql, Object... bindings) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.fullOuterJoin
(String sql, QueryPart... parts) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.fullOuterJoin
(Name name) FULL OUTER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
Table.fullOuterJoin
(Path<?> path) FULL OUTER JOIN
a path to this table.@NotNull TablePartitionByStep<Record>
Table.fullOuterJoin
(SQL sql) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.fullOuterJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.fullOuterJoin
(String sql) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.fullOuterJoin
(String sql, Object... bindings) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.fullOuterJoin
(String sql, QueryPart... parts) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.fullOuterJoin
(Name name) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.fullOuterJoin
(SQL sql) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.fullOuterJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
Table.fullOuterLoopJoin
(Path<?> path) FULL OUTER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TablePartitionByStep<Record>
Table.fullOuterLoopJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull TableOptionalOnStep<Record>
Table.fullOuterMergeJoin
(Path<?> path) FULL OUTER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TablePartitionByStep<Record>
Table.fullOuterMergeJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.DataType.getRecordType()
Get the nested record's record type definition, if this is aDataType.isRecord()
, or aDataType.isMultiset()
, orNULL
otherwise.@NotNull TableOptionalOnStep<Record>
INNER JOIN
a path to this table with aQOM.JoinHint.HASH
hint.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.PivotInStep.in
(Collection<? extends Field<T>> fields) Specify the acceptable values for pivotingSpecify the acceptable values for pivotingSpecify the acceptable values for pivoting@NotNull TableOptionalOnStep<Record>
Table.innerHashJoin
(Path<?> path) INNER JOIN
a path to this table with aQOM.JoinHint.HASH
hint.@NotNull TableOnStep<Record>
Table.innerHashJoin
(TableLike<?> table) INNER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
INNER JOIN
a path to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
Table.innerLoopJoin
(Path<?> path) INNER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TableOnStep<Record>
Table.innerLoopJoin
(TableLike<?> table) INNER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull TableOptionalOnStep<Record>
Table.innerMergeJoin
(Path<?> path) INNER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TableOnStep<Record>
Table.innerMergeJoin
(TableLike<?> table) INNER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.@NotNull SelectFromStep<Record>
Add a T-SQL styleINTO
clause to theSELECT
statement to create a new table from aSELECT
statement.Result.intoGroups
(int[] keyFieldIndexes) Return aMap
with the result grouped by the given keys.Result.intoGroups
(int[] keyFieldIndexes, int[] valueFieldIndexes) Return aMap
with the result grouped by the given keys.Result.intoGroups
(int[] keyFieldIndexes, int[] valueFieldIndexes) Return aMap
with the result grouped by the given keys.Result.intoGroups
(int[] keyFieldIndexes, Class<? extends E> type) Return aMap
with results grouped by the given keys and mapped into the given entity type.Result.intoGroups
(int[] keyFieldIndexes, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given keys and mapped into the given entity type.Result.intoGroups
(String[] keyFieldNames) Return aMap
with the result grouped by the given keys, usingFields.field(String)
for lookup.Result.intoGroups
(String[] keyFieldNames, Class<? extends E> type) Return aMap
with results grouped by the given keys and mapped into the given entity type, usingFields.field(String)
for lookup.Result.intoGroups
(String[] keyFieldNames, String[] valueFieldNames) Return aMap
with the result grouped by the given keys, usingFields.field(String)
for lookup.Result.intoGroups
(String[] keyFieldNames, String[] valueFieldNames) Return aMap
with the result grouped by the given keys, usingFields.field(String)
for lookup.Result.intoGroups
(String[] keyFieldNames, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given keys and mapped into the given entity type, usingFields.field(String)
for lookup.Result.intoGroups
(Field<?>[] keys) Return aMap
with the result grouped by the given keys, usingFields.field(Field)
for lookup.Result.intoGroups
(Field<?>[] keys, Class<? extends E> type) Return aMap
with results grouped by the given keys and mapped into the given entity type, usingFields.field(Field)
for lookup.Result.intoGroups
(Field<?>[] keys, Field<?>[] values) Return aMap
with the result grouped by the given keys, usingFields.field(Field)
for lookup.Result.intoGroups
(Field<?>[] keys, Field<?>[] values) Return aMap
with the result grouped by the given keys, usingFields.field(Field)
for lookup.Result.intoGroups
(Field<?>[] keys, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given keys and mapped into the given entity type, usingFields.field(Field)
for lookup.Result.intoGroups
(Name[] keyFieldNames) Return aMap
with the result grouped by the given keys, usingFields.field(Name)
for lookup.Result.intoGroups
(Name[] keyFieldNames, Class<? extends E> type) Return aMap
with results grouped by the given keys and mapped into the given entity type, usingFields.field(Name)
for lookup.Result.intoGroups
(Name[] keyFieldNames, Name[] valueFieldNames) Return aMap
with the result grouped by the given keys, usingFields.field(Name)
for lookup.Result.intoGroups
(Name[] keyFieldNames, Name[] valueFieldNames) Return aMap
with the result grouped by the given keys, usingFields.field(Name)
for lookup.Result.intoGroups
(Name[] keyFieldNames, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given keys and mapped into the given entity type, usingFields.field(Name)
for lookup.Result.intoMap
(int[] keyFieldIndexes) Return aMap
with the given keys as a map key and the corresponding record as value.Result.intoMap
(int[] keyFieldIndexes, int[] valueFieldIndexes) Return aMap
with the given keys as a map key and the corresponding record as value.Result.intoMap
(int[] keyFieldIndexes, int[] valueFieldIndexes) Return aMap
with the given keys as a map key and the corresponding record as value.Return aMap
with the given keys as a map key and the corresponding record as value, usingFields.field(String)
for lookup.Return aMap
with the given keys as a map key and the corresponding record as value, usingFields.field(String)
for lookup.Return aMap
with the given keys as a map key and the corresponding record as value, usingFields.field(String)
for lookup.Return aMap
with the given keys as a map key and the corresponding record as value, usingFields.field(Field)
for lookup.Return aMap
with the given keys as a map key and the corresponding record as value, usingFields.field(Field)
for lookup.Return aMap
with the given keys as a map key and the corresponding record as value, usingFields.field(Field)
for lookup.Return aMap
with the given keys as a map key and the corresponding record as value, usingFields.field(Name)
for lookup.Return aMap
with the given keys as a map key and the corresponding record as value, usingFields.field(Name)
for lookup.Return aMap
with the given keys as a map key and the corresponding record as value, usingFields.field(Name)
for lookup.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
INNER JOIN
a path to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
Join a table to this table using aJoinType
.@NotNull TableOptionalOnStep<Record>
Table.join
(TableLike<?> table, JoinType type, QOM.JoinHint hint) Join a table to this table using aJoinType
andQOM.JoinHint
.@NotNull TablePartitionByStep<Record>
Join a table to this table using aJoinType
.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.join
(TableLike<?> table, JoinType type, QOM.JoinHint hint) Join a table to this table using aJoinType
and aQOM.JoinHint
.@NotNull TableOptionalOnStep<Record>
Table.leftHashJoin
(Path<?> path) LEFT OUTER JOIN
a path to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
Table.leftHashJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
LEFT OUTER JOIN
a path to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
Table.leftLoopJoin
(Path<?> path) LEFT OUTER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TablePartitionByStep<Record>
Table.leftLoopJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull TableOptionalOnStep<Record>
Table.leftMergeJoin
(Path<?> path) LEFT OUTER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TablePartitionByStep<Record>
Table.leftMergeJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull TableOptionalOnStep<Record>
Table.leftOuterHashJoin
(Path<?> path) LEFT OUTER JOIN
a path to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
Table.leftOuterHashJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
Table.leftOuterJoin
(String sql) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.leftOuterJoin
(String sql, Object... bindings) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.leftOuterJoin
(String sql, QueryPart... parts) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.leftOuterJoin
(Name name) LEFT OUTER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
Table.leftOuterJoin
(Path<?> path) LEFT OUTER JOIN
a path to this table.@NotNull TablePartitionByStep<Record>
Table.leftOuterJoin
(SQL sql) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.leftOuterJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.leftOuterJoin
(String sql) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.leftOuterJoin
(String sql, Object... bindings) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.leftOuterJoin
(String sql, QueryPart... parts) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.leftOuterJoin
(Name name) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.leftOuterJoin
(SQL sql) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.leftOuterJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
Table.leftOuterLoopJoin
(Path<?> path) LEFT OUTER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TablePartitionByStep<Record>
Table.leftOuterLoopJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull TableOptionalOnStep<Record>
Table.leftOuterMergeJoin
(Path<?> path) LEFT OUTER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TablePartitionByStep<Record>
Table.leftOuterMergeJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull TableOptionalOnStep<Record>
INNER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull TableOptionalOnStep<Record>
INNER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.Table.naturalFullOuterJoin
(String sql) NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin
(String sql, Object... bindings) NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin
(String sql, QueryPart... parts) NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin
(Name name) NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin
(SQL sql) NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin
(TableLike<?> table) NATURAL FULL OUTER JOIN
a table to this table.Table.naturalJoin
(String sql) NATURAL JOIN
a table to this table.Table.naturalJoin
(String sql, Object... bindings) NATURAL JOIN
a table to this table.Table.naturalJoin
(String sql, QueryPart... parts) NATURAL JOIN
a table to this table.Table.naturalJoin
(Name name) NATURAL JOIN
a table to this table.Table.naturalJoin
(SQL sql) NATURAL JOIN
a table to this table.Table.naturalJoin
(TableLike<?> table) NATURAL JOIN
a table to this table.Table.naturalLeftOuterJoin
(String sql) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin
(String sql, Object... bindings) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin
(String sql, QueryPart... parts) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin
(Name name) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin
(SQL sql) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin
(TableLike<?> table) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin
(String sql) NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin
(String sql, Object... bindings) NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin
(String sql, QueryPart... parts) NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin
(Name name) NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin
(SQL sql) NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin
(TableLike<?> table) NATURAL RIGHT OUTER JOIN
a table to this table.DSLContext.newResult
(Collection<? extends Field<?>> fields) Create a new emptyRecord
.Create a new emptyRecord
.Table.outerApply
(String sql) OUTER APPLY
a table to this table.Table.outerApply
(String sql, Object... bindings) OUTER APPLY
a table to this table.Table.outerApply
(String sql, QueryPart... parts) OUTER APPLY
a table to this table.Table.outerApply
(Name name) OUTER APPLY
a table to this table.Table.outerApply
(SQL sql) OUTER APPLY
a table to this table.Table.outerApply
(TableLike<?> table) OUTER APPLY
a table to this table.@NotNull TableOuterJoinStep<Record>
Table.partitionBy
(Collection<? extends Field<?>> fields) Add aPARTITION BY
clause to the left hand side of theOUTER JOIN
keywords@NotNull TableOuterJoinStep<Record>
Table.partitionBy
(Field<?>... fields) Add aPARTITION BY
clause to the left hand side of theOUTER JOIN
keywordsResultOrRows.result()
The result ornull
if there was no result.@NotNull ResultQuery<Record>
DSLContext.resultQuery
(String sql) Create a new query holding plain SQL.@NotNull ResultQuery<Record>
DSLContext.resultQuery
(String sql, Object... bindings) Create a new query holding plain SQL.@NotNull ResultQuery<Record>
DSLContext.resultQuery
(String sql, QueryPart... parts) Create a new query holding plain SQL.@NotNull ResultQuery<Record>
DSLContext.resultQuery
(SQL sql) Create a new query holding plain SQL.DivideByReturningStep.returning
(Collection<? extends Field<?>> fields) Specify the fields that you want the division to return from the dividendSpecify the fields that you want the division to return from the dividend@NotNull DeleteResultStep<Record>
DeleteReturningStep.returningResult
(Collection<? extends SelectFieldOrAsterisk> fields) Configure theDELETE
statement to return a list of fields inR
.@NotNull DeleteResultStep<Record>
DeleteReturningStep.returningResult
(SelectFieldOrAsterisk... fields) Configure theDELETE
statement to return a list of fields inR
.@NotNull InsertResultStep<Record>
InsertReturningStep.returningResult
(Collection<? extends SelectFieldOrAsterisk> fields) Configure theINSERT
statement to return a list of fields inR
.@NotNull InsertResultStep<Record>
InsertReturningStep.returningResult
(SelectFieldOrAsterisk... fields) Configure theINSERT
statement to return a list of fields inR
.@NotNull UpdateResultStep<Record>
UpdateReturningStep.returningResult
(Collection<? extends SelectFieldOrAsterisk> fields) Configure theUPDATE
statement to return a list of fields inR
.@NotNull UpdateResultStep<Record>
UpdateReturningStep.returningResult
(SelectFieldOrAsterisk... fields) Configure theUPDATE
statement to return a list of fields inR
.@NotNull TableOptionalOnStep<Record>
Table.rightHashJoin
(Path<?> path) RIGHT OUTER JOIN
a path to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
Table.rightHashJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
RIGHT OUTER JOIN
a path to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
Table.rightLoopJoin
(Path<?> path) RIGHT OUTER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TablePartitionByStep<Record>
Table.rightLoopJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull TableOptionalOnStep<Record>
Table.rightMergeJoin
(Path<?> path) RIGHT OUTER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TablePartitionByStep<Record>
Table.rightMergeJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull TableOptionalOnStep<Record>
Table.rightOuterHashJoin
(Path<?> path) RIGHT OUTER JOIN
a path to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
Table.rightOuterHashJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull TablePartitionByStep<Record>
Table.rightOuterJoin
(String sql) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.rightOuterJoin
(String sql, Object... bindings) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.rightOuterJoin
(String sql, QueryPart... parts) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.rightOuterJoin
(Name name) RIGHT OUTER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
Table.rightOuterJoin
(Path<?> path) RIGHT OUTER JOIN
a path to this table.@NotNull TablePartitionByStep<Record>
Table.rightOuterJoin
(SQL sql) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.rightOuterJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.rightOuterJoin
(String sql) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.rightOuterJoin
(String sql, Object... bindings) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.rightOuterJoin
(String sql, QueryPart... parts) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.rightOuterJoin
(Name name) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.rightOuterJoin
(SQL sql) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.rightOuterJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
Table.rightOuterLoopJoin
(Path<?> path) RIGHT OUTER JOIN
a path to this table with aQOM.JoinHint.LOOP
hint.@NotNull TablePartitionByStep<Record>
Table.rightOuterLoopJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull TableOptionalOnStep<Record>
Table.rightOuterMergeJoin
(Path<?> path) RIGHT OUTER JOIN
a path to this table with aQOM.JoinHint.MERGE
hint.@NotNull TablePartitionByStep<Record>
Table.rightOuterMergeJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull SelectSelectStep<Record>
DSLContext.select
(Collection<? extends SelectFieldOrAsterisk> fields) Create a new DSL select statement.@NotNull SelectSelectStep<Record>
DSLContext.select
(SelectFieldOrAsterisk... fields) Create a new DSL select statement.@NotNull SelectSelectStep<Record>
SelectSelectStep.select
(Collection<? extends SelectFieldOrAsterisk> fields) Add additional fields to theSELECT
clause of this query@NotNull SelectSelectStep<Record>
SelectSelectStep.select
(SelectFieldOrAsterisk... fields) Add additional fields to theSELECT
clause of this query@NotNull SelectSelectStep<Record>
WithStep.select
(Collection<? extends SelectFieldOrAsterisk> fields) Create a new DSL select statement.@NotNull SelectSelectStep<Record>
WithStep.select
(SelectFieldOrAsterisk... fields) Create a new DSL select statement.@NotNull SelectSelectStep<Record>
DSLContext.selectDistinct
(Collection<? extends SelectFieldOrAsterisk> fields) Create a new DSL select statement.@NotNull SelectSelectStep<Record>
DSLContext.selectDistinct
(SelectFieldOrAsterisk... fields) Create a new DSL select statement.@NotNull SelectSelectStep<Record>
WithStep.selectDistinct
(Collection<? extends SelectFieldOrAsterisk> fields) Create a new DSL select statement.@NotNull SelectSelectStep<Record>
WithStep.selectDistinct
(SelectFieldOrAsterisk... fields) Create a new DSL select statement.@NotNull SelectWhereStep<Record>
DSLContext.selectFrom
(String sql) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
DSLContext.selectFrom
(String sql, Object... bindings) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
DSLContext.selectFrom
(String sql, QueryPart... parts) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
DSLContext.selectFrom
(Name table) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
DSLContext.selectFrom
(SQL sql) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
WithStep.selectFrom
(String sql) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
WithStep.selectFrom
(String sql, Object... bindings) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
WithStep.selectFrom
(String sql, QueryPart... parts) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
WithStep.selectFrom
(Name table) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
WithStep.selectFrom
(SQL sql) Create a new DSL select statement, projecting*
.@NotNull SelectQuery<Record>
DSLContext.selectQuery()
Create a newSelectQuery
@NotNull TableOnStep<Record>
Table.straightJoin
(String sql) STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table.straightJoin
(String sql, Object... bindings) STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table.straightJoin
(String sql, QueryPart... parts) STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table.straightJoin
(Name name) STRAIGHT_JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
Table.straightJoin
(Path<?> path) STRAIGHT_JOIN
a path to this table.@NotNull TableOnStep<Record>
Table.straightJoin
(SQL sql) STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table.straightJoin
(TableLike<?> table) STRAIGHT_JOIN
a table to this table.@NotNull TruncateIdentityStep<Record>
TheTRUNCATE
statement.@NotNull TruncateIdentityStep<Record>
TheTRUNCATE
statement.@NotNull TruncateIdentityStep<Record>
DSLContext.truncate
(Collection<? extends Table<?>> table) TheTRUNCATE
statement.@NotNull TruncateIdentityStep<Record>
TheTRUNCATE
statement.@NotNull TruncateIdentityStep<Record>
TheTRUNCATE
statement.@NotNull TruncateIdentityStep<Record>
TheTRUNCATE
statement.@NotNull TruncateIdentityStep<Record>
DSLContext.truncateTable
(String table) TheTRUNCATE TABLE
statement.@NotNull TruncateIdentityStep<Record>
DSLContext.truncateTable
(String... table) TheTRUNCATE TABLE
statement.@NotNull TruncateIdentityStep<Record>
DSLContext.truncateTable
(Collection<? extends Table<?>> table) TheTRUNCATE TABLE
statement.@NotNull TruncateIdentityStep<Record>
DSLContext.truncateTable
(Name table) TheTRUNCATE TABLE
statement.@NotNull TruncateIdentityStep<Record>
DSLContext.truncateTable
(Name... table) TheTRUNCATE TABLE
statement.@NotNull TruncateIdentityStep<Record>
DSLContext.truncateTable
(Table<?>... table) TheTRUNCATE TABLE
statement.TableOnStep.using
(Collection<? extends Field<?>> fields) Join a table with theUSING(column [, column…])
syntax.Join a table with theUSING(column [, column…])
syntax.Table.withOrdinality()
Add theWITH ORDINALITY
clause.Modifier and TypeMethodDescription@NotNull Condition
Create a condition to check this field against some bounds@NotNull BetweenAndStepN
Check if this row value expression is within a range of two records.@NotNull Condition
Check if this row value expression is within a range of two records.@NotNull BetweenAndStepN
RowN.betweenSymmetric
(Record minValue) Check if this row value expression is within a symmetric range of two records.@NotNull Condition
RowN.betweenSymmetric
(Record minValue, Record maxValue) Check if this row value expression is within a symmetric range of two records.boolean
The inverse operation ofchanged(Field)
.Get a table expression representing the children of a record, given this foreign key.@NotNull Condition
RowN.compare
(Comparator comparator, Record record) Compare this row value expression with a record using a dynamic comparator.int
Compares thisRecord
with anotherRecord
according to their natural ordering.@NotNull Condition
Compare this row value expression with a record for equality.@NotNull Condition
Compare this row value expression with a record for equality.ForeignKey.fetchChildren
(PARENT... records) Fetch child records of a given set of records through this foreign keyForeignKey.fetchParents
(CHILD... records) Fetch parent records of a given set of record through this foreign keyThe inverse operation ofFields.field(Field)
.The inverse operation ofinto(Field)
.The inverse operation ofinto(Table)
.@NotNull Condition
Compare this row value expression with a record for order.The inverse operation ofget(Field)
.The inverse operation ofgetValue(Field)
.@NotNull Condition
RowN.greaterOrEqual
(Record record) Compare this row value expression with a record for order.@NotNull Condition
RowN.greaterThan
(Record record) Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this subquery with a set of records for equality.@NotNull Condition
RowN.isDistinctFrom
(Record record) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
RowN.isNotDistinctFrom
(Record record) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
RowN.lessOrEqual
(Record record) Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull LoaderRowsStep<R>
LoaderSourceStep.loadRecords
(Record... records) Load in-memory data.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with a record for non-equality.@NotNull BetweenAndStepN
RowN.notBetween
(Record minValue) Check if this row value expression is within a range of two records.@NotNull Condition
RowN.notBetween
(Record minValue, Record maxValue) Check if this row value expression is within a range of two records.@NotNull BetweenAndStepN
RowN.notBetweenSymmetric
(Record minValue) Check if this row value expression is not within a symmetric range of two records.@NotNull Condition
RowN.notBetweenSymmetric
(Record minValue, Record maxValue) Check if this row value expression is not within a symmetric range of two records.@NotNull Condition
Compare this row value expression with a record for non-equality@NotNull Condition
Compare this row value expression with a set of records for non-equality.@NotNull Condition
Compare this subquery with a set of records for non-equality.The inverse operation oforiginal(Field)
.Get a table expression representing the parents of a record, given this foreign key.void
Calling this has no effect.void
The inverse operation ofreset(Field)
.@NotNull InsertOnDuplicateSetMoreStep<R>
Set multiple values forUPDATE
in theINSERT
statement'sON DUPLICATE KEY UPDATE
orON CONFLICT … DO UPDATE
clause.@NotNull InsertSetMoreStep<R>
Set values in theINSERT
statement.@NotNull InsertSetMoreStep<R>
Set values in theINSERT
statement.@NotNull InsertSetMoreStep<R>
Set values in theINSERT
statement.@NotNull InsertSetMoreStep<R>
Set values in theINSERT
statement.@NotNull MergeMatchedSetMoreStep<R>
Set multiple values forUPDATE
in theMERGE
statement'sWHEN MATCHED
clause.@NotNull MergeNotMatchedSetMoreStep<R>
Set multiple values forINSERT
in theMERGE
statement'sWHEN NOT MATCHED
clause.@NotNull Statement
Assign a value to this set of variables.@NotNull UpdateSetMoreStep<R>
Set a value for a field in theUPDATE
statement.@NotNull InsertValuesStepN<R>
Add a single row of values to the insert statement.@NotNull InsertValuesStepN<R>
InsertValuesStepN.valuesOfRecords
(Record... values) Add multiple rows of values to the insert statement.Modifier and TypeMethodDescriptionvoid
Specify a multi-column set clause for theUPDATE
statement.@NotNull Condition
RowN.compare
(Comparator comparator, QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
RowN.compare
(Comparator comparator, Select<? extends Record> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
RowN.eq
(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
RowN.equal
(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
RowN.ge
(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
RowN.greaterOrEqual
(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull Condition
RowN.greaterOrEqual
(Select<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull Condition
RowN.greaterThan
(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull Condition
RowN.greaterThan
(Select<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull Condition
RowN.gt
(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
RowN.isDistinctFrom
(Select<? extends Record> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
RowN.isNotDistinctFrom
(Select<? extends Record> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
RowN.le
(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
RowN.lessOrEqual
(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull Condition
RowN.lessOrEqual
(Select<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull Condition
RowN.lessThan
(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull LoaderRowsStep<R>
LoaderSourceStep.loadRecords
(Iterable<? extends Record> records) Load in-memory data.@NotNull LoaderRowsStep<R>
LoaderSourceStep.loadRecords
(Iterator<? extends Record> records) Load in-memory data.@NotNull LoaderRowsStep<R>
LoaderSourceStep.loadRecords
(Stream<? extends Record> records) Load in-memory data.@NotNull Condition
RowN.lt
(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.<E> E
Record.map
(RecordMapper<Record, E> mapper) Map this record into a custom mapper callback.@NotNull Condition
RowN.ne
(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
RowN.notEqual
(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull InsertOnDuplicateStep<R>
Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertSetMoreStep<R>
InsertSetMoreStep.set
(Collection<? extends Record> records) Set values in theINSERT
statement.@NotNull InsertSetMoreStep<R>
InsertSetStep.set
(Collection<? extends Record> records) Set values in theINSERT
statement.@NotNull Statement
Assign a value to this set of variables.@NotNull UpdateFromStep<R>
Specify a multi-column set clause for theUPDATE
statement.@NotNull InsertValuesStepN<R>
InsertValuesStepN.valuesOfRecords
(Collection<? extends Record> values) Add multiple rows of values to the insert statement. -
Uses of Record in org.jooq.impl
Modifier and TypeClassDescriptionfinal class
AuditGenerator<R extends Record,
X extends Table<R>, T> AGenerator
that can be used for audit columns, whose values are defined byConfiguration.auditProvider()
.class
DefaultRecordMapper<R extends Record,
E> This is the default implementation forRecordMapper
types, which applies tointo(Class)
,Result.into(Class)
, and similar calls.class
DefaultRecordUnmapper<E,
R extends Record> A default implementation for unmapping a custom type to aRecord
.static interface
QOM.CreateView<R extends Record>
TheCREATE VIEW
statement.static interface
QOM.CrossApply<R extends Record>
static interface
QOM.CrossJoin<R extends Record>
static interface
QOM.DataChangeDeltaTable<R extends Record>
static interface
QOM.Delete<R extends Record>
TheDELETE
statement.static interface
QOM.DeleteReturning<R extends Record>
AnDELETE
statement with aRETURNING
clause.static interface
QOM.DerivedTable<R extends Record>
static interface
QOM.FullJoin<R extends Record>
static interface
QOM.HintedTable<R extends Record>
A table with a MySQL style index access hint.static interface
QOM.Insert<R extends Record>
TheINSERT
statement.static interface
QOM.InsertReturning<R extends Record>
AnINSERT
statement with aRETURNING
clause.static interface
static interface
QOM.JoinTable<R extends Record,
J extends QOM.JoinTable<R, J>> static interface
QOM.Lateral<R extends Record>
static interface
QOM.LeftAntiJoin<R extends Record>
static interface
QOM.LeftJoin<R extends Record>
static interface
QOM.LeftSemiJoin<R extends Record>
static interface
QOM.LinkedTable<R extends Record>
A table with a database link.static interface
QOM.Multiset<R extends Record>
static interface
QOM.MultisetAgg<R extends Record>
static interface
QOM.NaturalFullJoin<R extends Record>
static interface
QOM.NaturalJoin<R extends Record>
static interface
QOM.NaturalLeftJoin<R extends Record>
static interface
QOM.NaturalRightJoin<R extends Record>
static interface
QOM.OuterApply<R extends Record>
static interface
QOM.QualifiedJoin<R extends Record,
J extends QOM.QualifiedJoin<R, J>> static interface
QOM.QuantifiedSelect<R extends Record>
static interface
QOM.RightJoin<R extends Record>
static interface
QOM.RowAsField<R extends Record>
static interface
QOM.StraightJoin<R extends Record>
static interface
QOM.TableAlias<R extends Record>
static interface
QOM.TableAsField<R extends Record>
static interface
QOM.TableEq<R extends Record>
TheEQ
operator.static interface
QOM.TableNe<R extends Record>
TheNE
operator.static interface
QOM.Truncate<R extends Record>
TheTRUNCATE
statement.static interface
QOM.Update<R extends Record>
TheUPDATE
statement.static interface
QOM.UpdateReturning<R extends Record>
AnUPDATE
statement with aRETURNING
clause.static interface
QOM.Values<R extends Record>
static interface
QOM.WithOrdinalityTable<R extends Record>
A collection derived table or table valued function with aWITH ORDINALITY
clause.static interface
QOM.WithTable<R extends Record>
A table with a T-SQL styleWITH
hint.class
A common base type for tablesclass
UDTPathFieldImpl<R extends Record,
U extends UDTRecord<U>, T> A common base type for UDT path fields.class
UDTPathTableFieldImpl<R extends Record,
U extends UDTRecord<U>, T> A common base type for table fields that are alsoUDTPathField
.Modifier and TypeClassDescriptionclass
CustomRecord<R extends TableRecord<R>>
A base class for customTableRecord
implementations in client code.static class
static class
class
EmbeddableRecordImpl<R extends EmbeddableRecord<R>>
A record implementation for a record originating from a single tableclass
TableRecordImpl<R extends TableRecord<R>>
A record implementation for a record originating from a single tableclass
UDTRecordImpl<R extends UDTRecord<R>>
A record implementation for a record originating from a single UDTclass
UpdatableRecordImpl<R extends UpdatableRecord<R>>
A record implementation for a record holding a primary keyModifier and TypeFieldDescriptionSQLDataType.RECORD
TheTypes.STRUCT
type.SQLDataType.RESULT
TheResultSet
type.Modifier and TypeMethodDescription<O extends Record>
@NotNull QOM.HintedTable<O><O extends Record>
@NotNull QOM.LinkedTable<O><O extends Record>
@NotNull QOM.WithTable<O>static <R extends Record>
@NotNull QuantifiedSelect<R>Create anALL
quantified select to be used in quantified comparison predicate expressions.static <R extends Record>
@NotNull QuantifiedSelect<R>Create anANY
quantified select to be used in quantified comparison predicate expressions.final <R extends Record>
DefaultPolicyProviderDefaultPolicyProvider.append
(Table<R> table, Condition condition, Collection<? extends Path<R>> inherited) Add aPolicy
for aPolicy.table()
andPolicy.condition()
as well as a set ofPolicy.inherited()
paths.final <R extends Record>
DefaultPolicyProviderAdd aPolicy
for aPolicy.table()
andPolicy.condition()
as well as a set ofPolicy.inherited()
paths.Internal.createCheck
(Table<R> table, Name name, String condition) Factory method for check constraints.Internal.createCheck
(Table<R> table, Name name, String condition, boolean enforce