Uses of Interface
org.jooq.Record
Packages that use 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 TypeInterfaceDescriptioninterfaceBetweenAndStepR<R extends Record>An intermediate DSL type for the construction of aBETWEENpredicate.interfaceA check constraint.interfaceCommonTableExpression<R extends Record>A common table expression.interfaceCreateTableAsStep<R extends Record>AQuerythat can create tables.interfaceCreateViewAsStep<R extends Record>AQuerythat can create views.interfaceCursors allow for lazy, sequential access to an underlying JDBCResultSet.interfaceADELETEstatement.interfaceDeleteConditionStep<R extends Record>This type is used for theDelete's DSL API.interfaceDeleteFinalStep<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.interfaceDeleteLimitStep<R extends Record>This type is used for theDelete's DSL API.interfaceDeleteOrderByStep<R extends Record>This type is used for theDelete's DSL API.interfaceDeleteQuery<R extends Record>ADELETEstatement (model API).interfaceDeleteResultStep<R extends Record>This type is used for theDelete's DSL API.interfaceDeleteReturningStep<R extends Record>This type is used for theDelete's DSL API.interfaceDeleteUsingStep<R extends Record>This type is used for theDelete's DSL API.interfaceDeleteWhereStep<R extends Record>This type is used for theDelete's DSL API.interfaceinterfaceForeignKey<R extends Record,O extends Record> AForeignKeyis an object referencing aUniqueKey.interfaceForeignKey<R extends Record,O extends Record> AForeignKeyis an object referencing aUniqueKey.interfaceAnIdentityis an object representing anIDENTITYcolumn as understood by the SQL:2003 standard.interfaceAnINSERTstatement.interfaceInsertFinalStep<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.interfaceInsertOnConflictConditionStep<R extends Record>This type is used for theInsert's DSL API.interfaceInsertOnConflictDoUpdateStep<R extends Record>This type is used for theInsert's DSL API.interfaceInsertOnConflictWhereIndexPredicateStep<R extends Record>This type is used for theInsert's DSL API.interfaceInsertOnConflictWhereStep<R extends Record>This type is used for theInsert's DSL API.interfaceInsertOnDuplicateSetMoreStep<R extends Record>This type is used for theInsert's DSL API.interfaceInsertOnDuplicateSetStep<R extends Record>This type is used for theInsert's DSL API.interfaceInsertOnDuplicateStep<R extends Record>This type is used for theInsert's DSL API.interfaceInsertQuery<R extends Record>AnINSERTstatement (model API).interfaceInsertResultStep<R extends Record>This type is used for theInsert's DSL API.interfaceInsertReturningStep<R extends Record>This type is used for theInsert's DSL API.interfaceInsertSetMoreStep<R extends Record>This type is used for theInsert's alternative DSL API.interfaceInsertSetStep<R extends Record>This type is used for theInsert's alternative DSL API.interfaceInsertValuesStep1<R extends Record,T1> This type is used for theInsert's DSL API.interfaceInsertValuesStep10<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> This type is used for theInsert's DSL API.interfaceInsertValuesStep11<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> This type is used for theInsert's DSL API.interfaceInsertValuesStep12<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> This type is used for theInsert's DSL API.interfaceInsertValuesStep13<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.interfaceInsertValuesStep14<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.interfaceInsertValuesStep15<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.interfaceInsertValuesStep16<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.interfaceInsertValuesStep17<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.interfaceInsertValuesStep18<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.interfaceInsertValuesStep19<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.interfaceInsertValuesStep2<R extends Record,T1, T2> This type is used for theInsert's DSL API.interfaceInsertValuesStep20<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.interfaceInsertValuesStep21<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.interfaceInsertValuesStep22<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.interfaceInsertValuesStep3<R extends Record,T1, T2, T3> This type is used for theInsert's DSL API.interfaceInsertValuesStep4<R extends Record,T1, T2, T3, T4> This type is used for theInsert's DSL API.interfaceInsertValuesStep5<R extends Record,T1, T2, T3, T4, T5> This type is used for theInsert's DSL API.interfaceInsertValuesStep6<R extends Record,T1, T2, T3, T4, T5, T6> This type is used for theInsert's DSL API.interfaceInsertValuesStep7<R extends Record,T1, T2, T3, T4, T5, T6, T7> This type is used for theInsert's DSL API.interfaceInsertValuesStep8<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8> This type is used for theInsert's DSL API.interfaceInsertValuesStep9<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9> This type is used for theInsert's DSL API.interfaceInsertValuesStepN<R extends Record>This type is used for theInsert's DSL API.interfaceAKeyis an object representing aUNIQUE KEY, aPRIMARY KEY, or aFOREIGN KEY.interfaceTheLoaderAPI is used for configuring data loads.interfaceLoaderCSVOptionsStep<R extends Record>TheLoaderAPI is used for configuring data loads.interfaceLoaderCSVStep<R extends Record>TheLoaderAPI is used for configuring data loads.interfaceLoaderJSONOptionsStep<R extends Record>TheLoaderAPI is used for configuring data loads.interfaceLoaderJSONStep<R extends Record>TheLoaderAPI is used for configuring data loads.interfaceLoaderListenerStep<R extends Record>TheLoaderAPI is used for configuring data loads.interfaceLoaderLoadStep<R extends Record>TheLoaderAPI is used for configuring data loads.interfaceLoaderOptionsStep<R extends Record>TheLoaderAPI is used for configuring data loads.interfaceLoaderRowsStep<R extends Record>TheLoaderAPI is used for configuring data loads.interfaceLoaderSourceStep<R extends Record>TheLoaderAPI is used for configuring data loads.interfaceLoaderXMLStep<R extends Record>TheLoaderAPI is used for configuring data loads.interfaceAMERGEstatement.interfaceMergeFinalStep<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.interfaceMergeKeyStep1<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)interfaceMergeKeyStep10<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)interfaceMergeKeyStep11<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)interfaceMergeKeyStep12<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)interfaceMergeKeyStep13<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)interfaceMergeKeyStep14<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)interfaceMergeKeyStep15<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)interfaceMergeKeyStep16<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)interfaceMergeKeyStep17<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)interfaceMergeKeyStep18<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)interfaceMergeKeyStep19<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)interfaceMergeKeyStep2<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)interfaceMergeKeyStep20<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)interfaceMergeKeyStep21<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)interfaceMergeKeyStep22<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)interfaceMergeKeyStep3<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)interfaceMergeKeyStep4<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)interfaceMergeKeyStep5<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)interfaceMergeKeyStep6<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)interfaceMergeKeyStep7<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)interfaceMergeKeyStep8<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)interfaceMergeKeyStep9<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)interfaceMergeKeyStepN<R extends Record>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeMatchedDeleteStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeMatchedSetMoreStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeMatchedSetStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeMatchedStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeMatchedThenStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeMatchedWhereStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeNotMatchedSetMoreStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeNotMatchedSetStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeNotMatchedStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep1<R extends Record,T1> This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep10<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep11<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep12<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep13<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.interfaceMergeNotMatchedValuesStep14<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.interfaceMergeNotMatchedValuesStep15<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.interfaceMergeNotMatchedValuesStep16<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.interfaceMergeNotMatchedValuesStep17<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.interfaceMergeNotMatchedValuesStep18<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.interfaceMergeNotMatchedValuesStep19<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.interfaceMergeNotMatchedValuesStep2<R extends Record,T1, T2> This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep20<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.interfaceMergeNotMatchedValuesStep21<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.interfaceMergeNotMatchedValuesStep22<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.interfaceMergeNotMatchedValuesStep3<R extends Record,T1, T2, T3> This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep4<R extends Record,T1, T2, T3, T4> This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep5<R extends Record,T1, T2, T3, T4, T5> This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep6<R extends Record,T1, T2, T3, T4, T5, T6> This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep7<R extends Record,T1, T2, T3, T4, T5, T6, T7> This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep8<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8> This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep9<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9> This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStepN<R extends Record>This type is used for theMerge's DSL API.interfaceMergeNotMatchedWhereStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeOnConditionStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeOnStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeUsingStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeValuesStep1<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)interfaceMergeValuesStep10<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)interfaceMergeValuesStep11<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)interfaceMergeValuesStep12<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)interfaceMergeValuesStep13<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)interfaceMergeValuesStep14<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)interfaceMergeValuesStep15<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)interfaceMergeValuesStep16<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)interfaceMergeValuesStep17<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)interfaceMergeValuesStep18<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)interfaceMergeValuesStep19<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)interfaceMergeValuesStep2<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)interfaceMergeValuesStep20<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)interfaceMergeValuesStep21<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)interfaceMergeValuesStep22<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)interfaceMergeValuesStep3<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)interfaceMergeValuesStep4<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)interfaceMergeValuesStep5<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)interfaceMergeValuesStep6<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)interfaceMergeValuesStep7<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)interfaceMergeValuesStep8<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)interfaceMergeValuesStep9<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)interfaceMergeValuesStepN<R extends Record>This type is used for the H2-specific variant of theMerge's DSL API.interfaceQuantifiedSelect<R extends Record>A quantified select for use in quantified comparison predicates.interfaceRecordHandler<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.interfaceRecordMapper<R extends Record,E> ARecordMapperis a mapper that can receiveRecordobjects, when fetching data from the database, transforming them into a custom type<E>.interfaceRecordQualifier<R extends Record>interfaceRecordType<R extends Record>interfaceRecordUnmapper<E,R extends Record> ARecordUnmapperis a mapper that can receive user objects and convert them back toRecord.interfaceA wrapper for database results returned by.SelectQueryinterfaceResultQuery<R extends Record>A query that can return results.interfaceASELECTstatement.interfaceSelectConditionStep<R extends Record>interfaceSelectConnectByAfterStartWithConditionStep<R extends Record>interfaceSelectConnectByAfterStartWithStep<R extends Record>interfaceSelectConnectByConditionStep<R extends Record>interfaceSelectConnectByStep<R extends Record>interfaceSelectCorrelatedSubqueryStep<R extends Record>interfaceSelectDistinctOnStep<R extends Record>interfaceSelectFinalStep<R extends Record>interfaceSelectForJSONCommonDirectivesStep<R extends Record>interfaceSelectForJSONStep<R extends Record>interfaceSelectForStep<R extends Record>interfaceSelectForUpdateOfStep<R extends Record>interfaceSelectForUpdateStep<R extends Record>interfaceSelectForUpdateWaitStep<R extends Record>interfaceSelectForXMLCommonDirectivesStep<R extends Record>interfaceSelectForXMLPathDirectivesStep<R extends Record>interfaceSelectForXMLRawDirectivesStep<R extends Record>interfaceSelectForXMLStep<R extends Record>interfaceSelectFromStep<R extends Record>interfaceSelectGroupByStep<R extends Record>interfaceSelectHavingConditionStep<R extends Record>interfaceSelectHavingStep<R extends Record>interfaceSelectIntoStep<R extends Record>interfaceSelectJoinPartitionByStep<R extends Record>interfaceSelectJoinStep<R extends Record>interfaceSelectLimitAfterOffsetStep<R extends Record>interfaceSelectLimitPercentAfterOffsetStep<R extends Record>interfaceSelectLimitPercentStep<R extends Record>interfaceSelectLimitStep<R extends Record>interfaceSelectOffsetStep<R extends Record>interfaceSelectOnConditionStep<R extends Record>interfaceSelectOnStep<R extends Record>interfaceSelectOptionalOnStep<R extends Record>interfaceSelectOptionStep<R extends Record>interfaceSelectOrderByStep<R extends Record>interfaceSelectQualifyConditionStep<R extends Record>interfaceSelectQualifyStep<R extends Record>interfaceSelectQuery<R extends Record>ASELECTstatement (model API).interfaceSelectSeekLimitStep<R extends Record>interfaceSelectSeekStep1<R extends Record,T1> interfaceSelectSeekStep10<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> interfaceSelectSeekStep11<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> interfaceSelectSeekStep12<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> interfaceSelectSeekStep13<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> interfaceSelectSeekStep14<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> interfaceSelectSeekStep15<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> interfaceSelectSeekStep16<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> interfaceSelectSeekStep17<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> interfaceSelectSeekStep18<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> interfaceSelectSeekStep19<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> interfaceSelectSeekStep2<R extends Record,T1, T2> interfaceSelectSeekStep20<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> interfaceSelectSeekStep21<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> interfaceSelectSeekStep22<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> interfaceSelectSeekStep3<R extends Record,T1, T2, T3> interfaceSelectSeekStep4<R extends Record,T1, T2, T3, T4> interfaceSelectSeekStep5<R extends Record,T1, T2, T3, T4, T5> interfaceSelectSeekStep6<R extends Record,T1, T2, T3, T4, T5, T6> interfaceSelectSeekStep7<R extends Record,T1, T2, T3, T4, T5, T6, T7> interfaceSelectSeekStep8<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8> interfaceSelectSeekStep9<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9> interfaceSelectSeekStepN<R extends Record>interfaceSelectSelectStep<R extends Record>interfaceSelectStartWithStep<R extends Record>interfaceSelectUnionStep<R extends Record>interfaceSelectWhereStep<R extends Record>interfaceSelectWindowStep<R extends Record>interfaceSelectWithTiesAfterOffsetStep<R extends Record>interfaceSelectWithTiesStep<R extends Record>interfaceStoreQuery<R extends Record>A query storing objects to the database.interfaceA table.interfaceTableField<R extends Record,T> A field contained in a table.interfaceAn object that can behave like a table (a table-like object).interfaceTableOnConditionStep<R extends Record>An intermediate (optional) type for the construction of aJOINclause, where the join criteria is added using anONclause (with aCondition.interfaceTableOnStep<R extends Record>interfaceTableOptionalOnStep<R extends Record>interfaceTableOuterJoinStep<R extends Record>An intermediate type for the construction of a partitionedSQLDialect.ORACLEOUTER JOINclause.interfaceTablePartitionByStep<R extends Record>An intermediate type for the construction of a partitionedSQLDialect.ORACLEOUTER JOINclause.interfaceA step in the construction of theTRUNCATEstatement.interfaceTruncateCascadeStep<R extends Record>A step in the construction of theTRUNCATEstatement.interfaceTruncateFinalStep<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.interfaceTruncateIdentityStep<R extends Record>A step in the construction of theTRUNCATEstatement.interfaceAUniqueKeyis an object representing aUNIQUE KEYor aPRIMARY KEY.interfaceAnUPDATEstatement.interfaceUpdateConditionStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateFinalStep<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.interfaceUpdateFromStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateLimitStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateOrderByStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateQuery<R extends Record>AnUPDATEstatement (model API).interfaceUpdateResultStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateReturningStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateSetFirstStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateSetMoreStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateSetStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateWhereStep<R extends Record>This type is used for theUpdate's DSL API.interfaceVersionsBetweenAndStep<R extends Record,T> This type is used for the OracleVERSIONSclause DSL API, providing access to the flashback versions query clauses.Modifier and TypeInterfaceDescriptioninterfaceEmbeddableRecord<R extends EmbeddableRecord<R>>A record originating from a single tableinterfaceQualifiedRecord<R extends QualifiedRecord<R>>interfaceRecord1<T1>A model type for a records with degree1interfaceRecord10<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10> A model type for a records with degree10interfaceRecord11<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> A model type for a records with degree11interfaceRecord12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> A model type for a records with degree12interfaceRecord13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> A model type for a records with degree13interfaceRecord14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> A model type for a records with degree14interfaceRecord15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> A model type for a records with degree15interfaceRecord16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> A model type for a records with degree16interfaceRecord17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> A model type for a records with degree17interfaceRecord18<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 degree18interfaceRecord19<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 degree19interfaceRecord2<T1,T2> A model type for a records with degree2interfaceRecord20<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 degree20interfaceRecord21<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 degree21interfaceRecord22<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 degree22interfaceRecord3<T1,T2, T3> A model type for a records with degree3interfaceRecord4<T1,T2, T3, T4> A model type for a records with degree4interfaceRecord5<T1,T2, T3, T4, T5> A model type for a records with degree5interfaceRecord6<T1,T2, T3, T4, T5, T6> A model type for a records with degree6interfaceRecord7<T1,T2, T3, T4, T5, T6, T7> A model type for a records with degree7interfaceRecord8<T1,T2, T3, T4, T5, T6, T7, T8> A model type for a records with degree8interfaceRecord9<T1,T2, T3, T4, T5, T6, T7, T8, T9> A model type for a records with degree9interfaceTableRecord<R extends TableRecord<R>>A record originating from a single tableinterfaceAn object holding data of a UDTinterfaceUpdatableRecord<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 theDerivedColumnListto form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>Name.as(ResultQuery<R> query) Specify a subselect to refer to by theNameto form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>DerivedColumnList.asMaterialized(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnListto form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>Name.asMaterialized(ResultQuery<R> query) Specify a materialized subselect to refer to by theNameto 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 theDerivedColumnListto 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 theNameto form a common table expression.<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 newDeleteQueryDSLContext.fetch(ResultQuery<R> query) Execute aResultQueryin the context of thisDSLContextand 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 newCompletionStagethat 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 aMapwith the result grouped by the given table.ResultQuery.fetchGroups(Table<S> table, Class<? extends E> type) Execute the query and return aMapwith 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 aMapwith 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 aMapwith the result grouped by the given table.ResultQuery.fetchGroups(Table<S> keyTable, Table<T> valueTable) Execute the query and return aMapwith 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 aResultQueryin the context of thisDSLContextand 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 aResultQueryin the context of thisDSLContextand return a cursor.Execute the query and return aMapwith table as a map key and the corresponding record as value.Execute the query and return aMapwith 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 aMapwith results grouped by the given table and mapped by the given mapper.Execute the query and return aMapwith table as a map key and the corresponding record as value.Execute the query and return aMapwith 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 aResultQueryin the context of thisDSLContextand 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 aResultQueryin the context of thisDSLContextand 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 aResultQueryin the context of thisDSLContextand 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<Z extends Record>
ZResultQuery.fetchSingleInto(Table<Z> table) Map resulting records onto a custom record.DSLContext.fetchStream(ResultQuery<R> query) Execute aResultQueryin the context of thisDSLContextand 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 collectRecordresulting from aResultQueryinto an array of a mapped type.Create a collector that can collectRecordresulting from aResultQueryinto an array of a mapped type.Records.intoGroups(Function<? super R, ? extends K> keyMapper) Create a collector that can collectRecordresulting from aResultQueryinto aMapusing the result of the argumentRecordMapperas 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 collectRecordresulting from aResultQueryinto aMapusing the result of the argumentRecordMapperas key collecting the result of another argumentRecordMapperinto a list of values.Result.intoGroups(Table<S> table) Return aMapwith the result grouped by the given key table.Result.intoGroups(Table<S> table, Class<? extends E> type) Return aMapwith 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 aMapwith results grouped by the given key table and mapped into the given entity type.Result.intoGroups(Table<S> keyTable, Table<T> valueTable) Return aMapwith the result grouped by the given key table.Result.intoGroups(Table<S> keyTable, Table<T> valueTable) Return aMapwith the result grouped by the given key table.Create a collector that can collectRecordresulting from aResultQueryinto aListof a mapped type.Create a collector that can collectRecordresulting from aResultQueryinto aMapusing the result of the argumentRecordMapperas 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 collectRecordresulting from aResultQueryinto aMapusing the result of the argumentRecordMapperas key and the result of another argumentRecordMapperas value.Return aMapwith the given key table as a map key and the corresponding record as value.Return aMapwith 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 aMapwith results grouped by the given key table and mapped by the given mapper.Return aMapwith the given key table as a map key and the corresponding record as value.Return aMapwith 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 collectRecordresulting from aResultQueryinto aMapusing the result of the argumentRecordMapperas 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 collectRecordresulting from aResultQueryinto aMapusing the result of the argumentRecordMapperas key collecting the result of another argumentRecordMapperinto aResultof values.Records.intoResultGroups(Function<? super R, ? extends K> keyMapper, Function<? super R, ? extends V> valueMapper) Create a collector that can collectRecordresulting from aResultQueryinto aMapusing the result of the argumentRecordMapperas key collecting the result of another argumentRecordMapperinto aResultof values.Create a collector that can collectRecordresulting from aResultQueryinto aSetof a mapped type.<R extends Record>
@NotNull LoaderOptionsStep<R>Create a newLoaderobject 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 newRecordthat can be inserted into the corresponding table.<R extends Record>
RCreate a new pre-filledRecordthat can be inserted into the corresponding table.Create a new emptyResult.<R extends Record,E>
@NotNull RecordMapper<R,E> RecordMapperProvider.provide(RecordType<R> recordType, Class<? extends E> type) Provide aRecordMapperinstance.<E,R extends Record>
@NotNull RecordUnmapper<E,R> RecordUnmapperProvider.provide(Class<? extends E> type, RecordType<R> recordType) Provide aRecordUnmapperinstance.<R extends Record>
@NotNull SelectWhereStep<R>DSLContext.selectFrom(Table<R> table) Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
@NotNull SelectWhereStep<R>WithStep.selectFrom(Table<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>TheTRUNCATEstatement.<R extends Record>
@NotNull TruncateIdentityStep<R>DSLContext.truncateTable(Table<R> table) TheTRUNCATE TABLEstatement.<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 newUpdateQueryModifier 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 RecordExecute a new query holding plain SQL.@Nullable RecordExecute a new query holding plain SQL.@Nullable RecordExecute a new query holding plain SQL.@Nullable Record@Nullable Record@Nullable Record@Nullable Record@Nullable RecordExecute a new query holding plain SQL.@NotNull RecordDSLContext.fetchSingle(String sql) Execute a new query holding plain SQL.@NotNull RecordDSLContext.fetchSingle(String sql, Object... bindings) Execute a new query holding plain SQL.@NotNull RecordDSLContext.fetchSingle(String sql, QueryPart... parts) Execute a new query holding plain SQL.@NotNull RecordDSLContext.fetchSingle(ResultSet rs) @NotNull RecordDSLContext.fetchSingle(ResultSet rs, Class<?>... types) @NotNull RecordDSLContext.fetchSingle(ResultSet rs, DataType<?>... types) @NotNull RecordDSLContext.fetchSingle(ResultSet rs, Field<?>... fields) @NotNull RecordDSLContext.fetchSingle(Collection<? extends SelectField<?>> fields) Execute and return exactly one record for@NotNull RecordDSLContext.fetchSingle(SelectField<?>... fields) Execute and return exactly one record for@NotNull RecordDSLContext.fetchSingle(SQL sql) Execute a new query holding plain SQL.@NotNull RecordCopy this record into a new record holding only a subset of the previous fields.@NotNull RecordUpdatableRecord.key()A Record copy holding values for theTable.getPrimaryKey().@NotNull RecordDSLContext.newRecord(Collection<? extends Field<?>> fields) Create a new emptyRecord.@NotNull RecordCreate a new emptyRecord.@NotNull RecordRecord.original()Get this record containing the original values as fetched from the database.@Nullable RecordExecuteContext.record()The last record that was fetched from the result set, ornullif no record has been fetched.@NotNull RecordRecordContext.record()TheRecordthat is being manipulated.<T> @NotNull RecordSet a value into this record.<T,U> @NotNull Record Set a value into this record.Modifier and TypeMethodDescription@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.createOrReplaceView(String view, String... fields) Create a new DSLCREATE OR REPLACE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext.createOrReplaceView(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createOrReplaceView(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createOrReplaceView(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createOrReplaceView(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createOrReplaceView(Name view, Name... fields) Create a new DSLCREATE OR REPLACE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext.createOrReplaceView(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createOrReplaceView(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createOrReplaceView(Table<?> view, Field<?>... fields) Create a new DSLCREATE OR REPLACE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext.createView(String view, String... fields) Create a new DSLCREATE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext.createView(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createView(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createView(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createView(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createView(Name view, Name... fields) Create a new DSLCREATE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext.createView(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createView(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createView(Table<?> view, Field<?>... fields) Create a new DSLCREATE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext.createViewIfNotExists(String view, String... fields) Create a new DSLCREATE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext.createViewIfNotExists(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createViewIfNotExists(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createViewIfNotExists(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createViewIfNotExists(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createViewIfNotExists(Name view, Name... fields) Create a new DSLCREATE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext.createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createViewIfNotExists(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext.createViewIfNotExists(Table<?> view, Field<?>... fields) Create a new DSLCREATE VIEWstatement.Table.crossApply(String sql) CROSS APPLYa table to this table.Table.crossApply(String sql, Object... bindings) CROSS APPLYa table to this table.Table.crossApply(String sql, QueryPart... parts) CROSS APPLYa table to this table.Table.crossApply(Name name) CROSS APPLYa table to this table.Table.crossApply(SQL sql) CROSS APPLYa table to this table.Table.crossApply(TableLike<?> table) CROSS APPLYa table to this table.CROSS JOINa table to this table.CROSS JOINa table to this table.CROSS JOINa table to this table.CROSS JOINa table to this table.CROSS JOINa table to this table.CROSS JOINa 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 newCompletionStagethat 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 newCompletionStagethat 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 newCompletionStagethat 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 newCompletionStagethat 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 newCompletionStagethat 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 newCompletionStagethat 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 newCompletionStagethat 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 newCompletionStagethat 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 aMapwith the result grouped by the given keys.ResultQuery.fetchGroups(int[] keyFieldIndexes, int[] valueFieldIndexes) Execute the query and return aMapwith the result grouped by the given keys.ResultQuery.fetchGroups(int[] keyFieldIndexes, int[] valueFieldIndexes) Execute the query and return aMapwith the result grouped by the given keys.ResultQuery.fetchGroups(int[] keyFieldIndexes, Class<? extends E> type) Execute the query and return aMapwith 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 aMapwith results grouped by the given keys and mapped by the given mapper.ResultQuery.fetchGroups(String[] keyFieldNames) Execute the query and return aMapwith the result grouped by the given keys.ResultQuery.fetchGroups(String[] keyFieldNames, Class<? extends E> type) Execute the query and return aMapwith results grouped by the given keys and mapped into the given entity type.ResultQuery.fetchGroups(String[] keyFieldNames, String[] valueFieldNames) Execute the query and return aMapwith the result grouped by the given keys.ResultQuery.fetchGroups(String[] keyFieldNames, String[] valueFieldNames) Execute the query and return aMapwith the result grouped by the given keys.ResultQuery.fetchGroups(String[] keyFieldNames, RecordMapper<? super R, E> mapper) Execute the query and return aMapwith results grouped by the given keys and mapped by the given mapper.ResultQuery.fetchGroups(Field<?>[] keys) Execute the query and return aMapwith the result grouped by the given keys.ResultQuery.fetchGroups(Field<?>[] keys, Class<? extends E> type) Execute the query and return aMapwith results grouped by the given keys and mapped into the given entity type.ResultQuery.fetchGroups(Field<?>[] keys, Field<?>[] values) Execute the query and return aMapwith the result grouped by the given keys.ResultQuery.fetchGroups(Field<?>[] keys, Field<?>[] values) Execute the query and return aMapwith the result grouped by the given keys.ResultQuery.fetchGroups(Field<?>[] keys, RecordMapper<? super R, E> mapper) Execute the query and return aMapwith results grouped by the given keys and mapped by the given mapper.ResultQuery.fetchGroups(Name[] keyFieldNames) Execute the query and return aMapwith the result grouped by the given keys.ResultQuery.fetchGroups(Name[] keyFieldNames, Class<? extends E> type) Execute the query and return aMapwith results grouped by the given keys and mapped into the given entity type.ResultQuery.fetchGroups(Name[] keyFieldNames, Name[] valueFieldNames) Execute the query and return aMapwith the result grouped by the given keys.ResultQuery.fetchGroups(Name[] keyFieldNames, Name[] valueFieldNames) Execute the query and return aMapwith the result grouped by the given keys.ResultQuery.fetchGroups(Name[] keyFieldNames, RecordMapper<? super R, E> mapper) Execute the query and return aMapwith results grouped by the given keys and mapped by the given mapper.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 aMapwith keys as a map key and the corresponding record as value.ResultQuery.fetchMap(int[] keyFieldIndexes, int[] valueFieldIndexes) Execute the query and return aMapwith keys as a map key and the corresponding record as value.ResultQuery.fetchMap(int[] keyFieldIndexes, int[] valueFieldIndexes) Execute the query and return aMapwith keys as a map key and the corresponding record as value.Execute the query and return aMapwith keys as a map key and the corresponding record as value.Execute the query and return aMapwith keys as a map key and the corresponding record as value.Execute the query and return aMapwith keys as a map key and the corresponding record as value.Execute the query and return aMapwith keys as a map key and the corresponding record as value.Execute the query and return aMapwith keys as a map key and the corresponding record as value.Execute the query and return aMapwith keys as a map key and the corresponding record as value.Execute the query and return aMapwith keys as a map key and the corresponding record as value.Execute the query and return aMapwith keys as a map key and the corresponding record as value.Execute the query and return aMapwith keys as a map key and the corresponding record as value.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 TableOnStep<Record>FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table.fullOuterJoin(String sql) FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table.fullOuterJoin(String sql, Object... bindings) FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table.fullOuterJoin(String sql, QueryPart... parts) FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table.fullOuterJoin(Name name) FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table.fullOuterJoin(SQL sql) FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table.fullOuterJoin(TableLike<?> table) FULL OUTER JOINa table to this table.DataType.getRecordType()Get the nested record's record type definition, if this is aDataType.isRecord(), or aDataType.isMultiset(), orNULLotherwise.PivotInStep.in(Collection<? extends Field<T>> fields) Specify the acceptable values for pivotingSpecify the acceptable values for pivotingSpecify the acceptable values for pivoting@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.Copy all records from this result into a new result with new records holding only a subset of the previous fields.@NotNull SelectFromStep<Record>Add a T-SQL styleINTOclause to theSELECTstatement to create a new table from aSELECTstatement.Result.intoGroups(int[] keyFieldIndexes) Return aMapwith the result grouped by the given keys.Result.intoGroups(int[] keyFieldIndexes, int[] valueFieldIndexes) Return aMapwith the result grouped by the given keys.Result.intoGroups(int[] keyFieldIndexes, int[] valueFieldIndexes) Return aMapwith the result grouped by the given keys.Result.intoGroups(int[] keyFieldIndexes, Class<? extends E> type) Return aMapwith results grouped by the given keys and mapped into the given entity type.Result.intoGroups(int[] keyFieldIndexes, RecordMapper<? super R, E> mapper) Return aMapwith results grouped by the given keys and mapped into the given entity type.Result.intoGroups(String[] keyFieldNames) Return aMapwith the result grouped by the given keys.Result.intoGroups(String[] keyFieldNames, Class<? extends E> type) Return aMapwith results grouped by the given keys and mapped into the given entity type.Result.intoGroups(String[] keyFieldNames, String[] valueFieldNames) Return aMapwith the result grouped by the given keys.Result.intoGroups(String[] keyFieldNames, String[] valueFieldNames) Return aMapwith the result grouped by the given keys.Result.intoGroups(String[] keyFieldNames, RecordMapper<? super R, E> mapper) Return aMapwith results grouped by the given keys and mapped into the given entity type.Result.intoGroups(Field<?>[] keys) Return aMapwith the result grouped by the given keys.Result.intoGroups(Field<?>[] keys, Class<? extends E> type) Return aMapwith results grouped by the given keys and mapped into the given entity type.Result.intoGroups(Field<?>[] keys, Field<?>[] values) Return aMapwith the result grouped by the given keys.Result.intoGroups(Field<?>[] keys, Field<?>[] values) Return aMapwith the result grouped by the given keys.Result.intoGroups(Field<?>[] keys, RecordMapper<? super R, E> mapper) Return aMapwith results grouped by the given keys and mapped into the given entity type.Result.intoGroups(Name[] keyFieldNames) Return aMapwith the result grouped by the given keys.Result.intoGroups(Name[] keyFieldNames, Class<? extends E> type) Return aMapwith results grouped by the given keys and mapped into the given entity type.Result.intoGroups(Name[] keyFieldNames, Name[] valueFieldNames) Return aMapwith the result grouped by the given keys.Result.intoGroups(Name[] keyFieldNames, Name[] valueFieldNames) Return aMapwith the result grouped by the given keys.Result.intoGroups(Name[] keyFieldNames, RecordMapper<? super R, E> mapper) Return aMapwith results grouped by the given keys and mapped into the given entity type.Result.intoMap(int[] keyFieldIndexes) Return aMapwith the given keys as a map key and the corresponding record as value.Result.intoMap(int[] keyFieldIndexes, int[] valueFieldIndexes) Return aMapwith the given keys as a map key and the corresponding record as value.Result.intoMap(int[] keyFieldIndexes, int[] valueFieldIndexes) Return aMapwith the given keys as a map key and the corresponding record as value.Return aMapwith the given keys as a map key and the corresponding record as value.Return aMapwith the given keys as a map key and the corresponding record as value.Return aMapwith the given keys as a map key and the corresponding record as value.Return aMapwith the given keys as a map key and the corresponding record as value.Return aMapwith the given keys as a map key and the corresponding record as value.Return aMapwith the given keys as a map key and the corresponding record as value.Return aMapwith the given keys as a map key and the corresponding record as value.Return aMapwith the given keys as a map key and the corresponding record as value.Return aMapwith the given keys as a map key and the corresponding record as value.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOptionalOnStep<Record>Join a table to this table using aJoinType@NotNull TableOnStep<Record>Join a table to this table using aJoinType.@NotNull TablePartitionByStep<Record>LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.leftOuterJoin(String sql) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.leftOuterJoin(String sql, Object... bindings) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.leftOuterJoin(String sql, QueryPart... parts) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.leftOuterJoin(Name name) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.leftOuterJoin(SQL sql) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.leftOuterJoin(TableLike<?> table) LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.leftOuterJoin(String sql) LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.leftOuterJoin(String sql, Object... bindings) LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.leftOuterJoin(String sql, QueryPart... parts) LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.leftOuterJoin(Name name) LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.leftOuterJoin(SQL sql) LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.leftOuterJoin(TableLike<?> table) LEFT OUTER JOINa table to this table.Table.naturalFullOuterJoin(String sql) NATURAL FULL OUTER JOINa table to this table.Table.naturalFullOuterJoin(String sql, Object... bindings) NATURAL FULL OUTER JOINa table to this table.Table.naturalFullOuterJoin(String sql, QueryPart... parts) NATURAL FULL OUTER JOINa table to this table.Table.naturalFullOuterJoin(Name name) NATURAL FULL OUTER JOINa table to this table.Table.naturalFullOuterJoin(SQL sql) NATURAL FULL OUTER JOINa table to this table.Table.naturalFullOuterJoin(TableLike<?> table) NATURAL FULL OUTER JOINa table to this table.Table.naturalJoin(String sql) NATURAL JOINa table to this table.Table.naturalJoin(String sql, Object... bindings) NATURAL JOINa table to this table.Table.naturalJoin(String sql, QueryPart... parts) NATURAL JOINa table to this table.Table.naturalJoin(Name name) NATURAL JOINa table to this table.Table.naturalJoin(SQL sql) NATURAL JOINa table to this table.Table.naturalJoin(TableLike<?> table) NATURAL JOINa table to this table.Table.naturalLeftOuterJoin(String sql) NATURAL LEFT OUTER JOINa table to this table.Table.naturalLeftOuterJoin(String sql, Object... bindings) NATURAL LEFT OUTER JOINa table to this table.Table.naturalLeftOuterJoin(String sql, QueryPart... parts) NATURAL LEFT OUTER JOINa table to this table.Table.naturalLeftOuterJoin(Name name) NATURAL LEFT OUTER JOINa table to this table.Table.naturalLeftOuterJoin(SQL sql) NATURAL LEFT OUTER JOINa table to this table.Table.naturalLeftOuterJoin(TableLike<?> table) NATURAL LEFT OUTER JOINa table to this table.Table.naturalRightOuterJoin(String sql) NATURAL RIGHT OUTER JOINa table to this table.Table.naturalRightOuterJoin(String sql, Object... bindings) NATURAL RIGHT OUTER JOINa table to this table.Table.naturalRightOuterJoin(String sql, QueryPart... parts) NATURAL RIGHT OUTER JOINa table to this table.Table.naturalRightOuterJoin(Name name) NATURAL RIGHT OUTER JOINa table to this table.Table.naturalRightOuterJoin(SQL sql) NATURAL RIGHT OUTER JOINa table to this table.Table.naturalRightOuterJoin(TableLike<?> table) NATURAL RIGHT OUTER JOINa table to this table.DSLContext.newResult(Collection<? extends Field<?>> fields) Create a new emptyRecord.Create a new emptyRecord.Table.outerApply(String sql) OUTER APPLYa table to this table.Table.outerApply(String sql, Object... bindings) OUTER APPLYa table to this table.Table.outerApply(String sql, QueryPart... parts) OUTER APPLYa table to this table.Table.outerApply(Name name) OUTER APPLYa table to this table.Table.outerApply(SQL sql) OUTER APPLYa table to this table.Table.outerApply(TableLike<?> table) OUTER APPLYa table to this table.@NotNull TableOuterJoinStep<Record>Table.partitionBy(Collection<? extends Field<?>> fields) Add aPARTITION BYclause to the left hand side of theOUTER JOINkeywords@NotNull TableOuterJoinStep<Record>Table.partitionBy(Field<?>... fields) Add aPARTITION BYclause to the left hand side of theOUTER JOINkeywordsResultOrRows.result()The result ornullif 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 theDELETEstatement to return a list of fields inR.@NotNull DeleteResultStep<Record>DeleteReturningStep.returningResult(SelectFieldOrAsterisk... fields) Configure theDELETEstatement to return a list of fields inR.@NotNull InsertResultStep<Record>InsertReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields) Configure theINSERTstatement to return a list of fields inR.@NotNull InsertResultStep<Record>InsertReturningStep.returningResult(SelectFieldOrAsterisk... fields) Configure theINSERTstatement to return a list of fields inR.@NotNull UpdateResultStep<Record>UpdateReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields) Configure theUPDATEstatement to return a list of fields inR.@NotNull UpdateResultStep<Record>UpdateReturningStep.returningResult(SelectFieldOrAsterisk... fields) Configure theUPDATEstatement to return a list of fields inR.@NotNull TablePartitionByStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.rightOuterJoin(String sql) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.rightOuterJoin(String sql, Object... bindings) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.rightOuterJoin(String sql, QueryPart... parts) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.rightOuterJoin(Name name) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.rightOuterJoin(SQL sql) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.rightOuterJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.rightOuterJoin(String sql) RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.rightOuterJoin(String sql, Object... bindings) RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.rightOuterJoin(String sql, QueryPart... parts) RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.rightOuterJoin(Name name) RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.rightOuterJoin(SQL sql) RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.rightOuterJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table.@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 theSELECTclause of this query@NotNull SelectSelectStep<Record>SelectSelectStep.select(SelectFieldOrAsterisk... fields) Add additional fields to theSELECTclause 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_JOINa table to this table.@NotNull TableOnStep<Record>Table.straightJoin(String sql, Object... bindings) STRAIGHT_JOINa table to this table.@NotNull TableOnStep<Record>Table.straightJoin(String sql, QueryPart... parts) STRAIGHT_JOINa table to this table.@NotNull TableOnStep<Record>Table.straightJoin(Name name) STRAIGHT_JOINa table to this table.@NotNull TableOnStep<Record>Table.straightJoin(SQL sql) STRAIGHT_JOINa table to this table.@NotNull TableOnStep<Record>Table.straightJoin(TableLike<?> table) STRAIGHT_JOINa table to this table.@NotNull TruncateIdentityStep<Record>TheTRUNCATEstatement.@NotNull TruncateIdentityStep<Record>TheTRUNCATEstatement.@NotNull TruncateIdentityStep<Record>DSLContext.truncateTable(String table) TheTRUNCATE TABLEstatement.@NotNull TruncateIdentityStep<Record>DSLContext.truncateTable(Name table) TheTRUNCATE TABLEstatement.TableOnStep.using(Collection<? extends Field<?>> fields) Join a table with theUSING(column [, column…])syntax.Join a table with theUSING(column [, column…])syntax.Modifier and TypeMethodDescription@NotNull ConditionCreate a condition to check this field against some bounds@NotNull BetweenAndStepNCheck if this row value expression is within a range of two records.@NotNull ConditionCheck if this row value expression is within a range of two records.@NotNull BetweenAndStepNRowN.betweenSymmetric(Record minValue) Check if this row value expression is within a symmetric range of two records.@NotNull ConditionRowN.betweenSymmetric(Record minValue, Record maxValue) Check if this row value expression is within a symmetric range of two records.booleanThe inverse operation ofchanged(Field).Get a table expression representing the children of a record, given this foreign key.@NotNull ConditionRowN.compare(Comparator comparator, Record record) Compare this row value expression with a record using a dynamic comparator.intCompares thisRecordwith anotherRecordaccording to their natural ordering.@NotNull ConditionCompare this row value expression with a record for equality.@NotNull ConditionCompare this row value expression with a record for equality.ForeignKey.fetchChildren(O... records) Fetch child records of a given set of records through this foreign keyForeignKey.fetchParents(R... 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 ConditionCompare this row value expression with a record for order.The inverse operation ofget(Field).The inverse operation ofgetValue(Field).@NotNull ConditionRowN.greaterOrEqual(Record record) Compare this row value expression with a record for order.@NotNull ConditionRowN.greaterThan(Record record) Compare this row value expression with a record for order.@NotNull ConditionCompare this row value expression with a record for order.@NotNull ConditionCompare this row value expression with a set of records for equality.@NotNull ConditionCompare this subquery with a set of records for equality.@NotNull ConditionRowN.isDistinctFrom(Record record) Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRowN.isNotDistinctFrom(Record record) Compare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with a record for order.@NotNull ConditionRowN.lessOrEqual(Record record) Compare this row value expression with a record for order.@NotNull ConditionCompare this row value expression with a record for order.@NotNull LoaderRowsStep<R>LoaderSourceStep.loadRecords(Record... records) Load in-memory data.@NotNull ConditionCompare this row value expression with a record for order.@NotNull ConditionCompare this row value expression with a record for non-equality.@NotNull BetweenAndStepNRowN.notBetween(Record minValue) Check if this row value expression is within a range of two records.@NotNull ConditionRowN.notBetween(Record minValue, Record maxValue) Check if this row value expression is within a range of two records.@NotNull BetweenAndStepNRowN.notBetweenSymmetric(Record minValue) Check if this row value expression is not within a symmetric range of two records.@NotNull ConditionRowN.notBetweenSymmetric(Record minValue, Record maxValue) Check if this row value expression is not within a symmetric range of two records.@NotNull ConditionCompare this row value expression with a record for non-equality@NotNull ConditionCompare this row value expression with a set of records for non-equality.@NotNull ConditionCompare 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.voidCalling this has no effect.voidThe inverse operation ofreset(Field).@NotNull InsertOnDuplicateSetMoreStep<R>Set multiple values forUPDATEin theINSERTstatement'sON DUPLICATE KEY UPDATEorON CONFLICT … DO UPDATEclause.@NotNull InsertSetMoreStep<R>Set values in theINSERTstatement.@NotNull InsertSetMoreStep<R>Set values in theINSERTstatement.@NotNull MergeMatchedSetMoreStep<R>Set multiple values forUPDATEin theMERGEstatement'sWHEN MATCHEDclause.@NotNull MergeNotMatchedSetMoreStep<R>Set multiple values forINSERTin theMERGEstatement'sWHEN NOT MATCHEDclause.@NotNull StatementAssign a value to this set of variables.@NotNull UpdateSetMoreStep<R>Set a value for a field in theUPDATEstatement.@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 TypeMethodDescriptionvoidSpecify a multi-column set clause for theUPDATEstatement.@NotNull ConditionRowN.compare(Comparator comparator, QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionRowN.compare(Comparator comparator, Select<? extends Record> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionRowN.eq(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionRowN.equal(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionRowN.ge(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRowN.greaterOrEqual(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull ConditionRowN.greaterOrEqual(Select<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull ConditionRowN.greaterThan(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull ConditionRowN.greaterThan(Select<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull ConditionRowN.gt(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a set of records for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionRowN.isDistinctFrom(Select<? extends Record> select) Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRowN.isNotDistinctFrom(Select<? extends Record> select) Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRowN.le(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRowN.lessOrEqual(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull ConditionRowN.lessOrEqual(Select<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull ConditionRowN.lessThan(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull ConditionCompare 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 ConditionRowN.lt(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.<E> ERecord.map(RecordMapper<Record, E> mapper) Map this record into a custom mapper callback.@NotNull ConditionRowN.ne(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionRowN.notEqual(QuantifiedSelect<? extends Record> select) Compare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a set of records for equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull InsertOnDuplicateStep<R>Use aSELECTstatement as the source of values for theINSERTstatement@NotNull StatementAssign a value to this set of variables.@NotNull UpdateFromStep<R>Specify a multi-column set clause for theUPDATEstatement.@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
Classes in org.jooq.impl with type parameters of type RecordModifier and TypeClassDescriptionclassDefaultRecordMapper<R extends Record,E> This is the default implementation forRecordMappertypes, which applies tointo(Class),Result.into(Class), and similar calls.classDefaultRecordUnmapper<E,R extends Record> A default implementation for unmapping a custom type to aRecord.static interfaceQOM.CreateView<R extends Record>static interfaceQOM.DataChangeDeltaTable<R extends Record>static interfaceQOM.DerivedTable<R extends Record>static interfaceQOM.Lateral<R extends Record>static interfaceQOM.LinkedTable<R extends Record>static interfaceQOM.Multiset<R extends Record>static interfaceQOM.MultisetAgg<R extends Record>static interfaceQOM.RowField<R extends Record>static interfaceQOM.TableAlias<R extends Record>static interfaceQOM.TableEq<R extends Record>TheEQoperator.static interfaceQOM.TableNe<R extends Record>TheNEoperator.static interfaceQOM.Truncate<R extends Record>TheTRUNCATEstatement.static interfaceQOM.Values<R extends Record>classA common base type for tablesClasses in org.jooq.impl that implement RecordModifier and TypeClassDescriptionclassCustomRecord<R extends TableRecord<R>>A base class for customTableRecordimplementations in client code.static classstatic classclassEmbeddableRecordImpl<R extends EmbeddableRecord<R>>A record implementation for a record originating from a single tableclassTableRecordImpl<R extends TableRecord<R>>A record implementation for a record originating from a single tableclassUDTRecordImpl<R extends UDTRecord<R>>A record implementation for a record originating from a single UDTclassUpdatableRecordImpl<R extends UpdatableRecord<R>>A record implementation for a record holding a primary keyFields in org.jooq.impl with type parameters of type RecordModifier and TypeFieldDescriptionSQLDataType.RECORDTheTypes.STRUCTtype.SQLDataType.RESULTTheResultSettype.Methods in org.jooq.impl with type parameters of type RecordModifier and TypeMethodDescriptionstatic <R extends Record>
@NotNull QuantifiedSelect<R>Create anALLquantified select to be used in quantified comparison predicate expressions.static <R extends Record>
@NotNull QuantifiedSelect<R>Create anANYquantified select to be used in quantified comparison predicate expressions.Internal.createCheck(Table<R> table, Name name, String condition) Factory method for check constraints.Internal.createCheck(Table<R> table, Name name, String condition, boolean enforced) Factory method for check constraints.static final <R extends Record,E extends EmbeddableRecord<E>>
@NotNull TableField<R,E> Internal.createEmbeddable(Name name, Class<E> recordType, boolean replacesFields, Table<R> table, TableField<R, ?>... fields) Factory method for embeddable types.static final <R extends Record,E extends EmbeddableRecord<E>>
@NotNull TableField<R,E> Internal.createEmbeddable(Name name, Class<E> recordType, Table<R> table, TableField<R, ?>... fields) Factory method for embeddable types.static <R extends Record,U extends Record>
ForeignKey<R,U> AbstractKeys.createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R, ?>... fields) Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record,U extends Record>
ForeignKey<R,U> AbstractKeys.createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R, ?>... fields) Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record,U extends Record>
ForeignKey<R,U> AbstractKeys.createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R, ?>... fields) Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record,U extends Record>
ForeignKey<R,U> AbstractKeys.createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R, ?>... fields) Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic final <R extends Record,U extends Record>
@NotNull ForeignKey<R,U> Internal.createForeignKey(Table<R> table, Name name, TableField<R, ?>[] fkFields, UniqueKey<U> uk, TableField<U, ?>[] ukFields, boolean enforced) Factory method for foreign keys.static final <R extends Record,U extends Record>
@NotNull ForeignKey<R,U> Internal.createForeignKey(Table<R> table, Name name, TableField<R, ?>[] fkFields, UniqueKey<U> uk, TableField<U, ?>[] ukFields, boolean enforced) Factory method for foreign keys.static final <R extends Record,U extends Record, ER extends EmbeddableRecord<ER>>
@NotNull ForeignKey<R,U> Internal.createForeignKey(Table<R> table, Name name, TableField<R, ER> fkEmbeddableField, UniqueKey<U> uk, TableField<U, ER> ukEmbeddableField, boolean enforced) Factory method for foreign keys.static final <R extends Record,U extends Record, ER extends EmbeddableRecord<ER>>
@NotNull ForeignKey<R,U> Internal.createForeignKey(Table<R> table, Name name, TableField<R, ER> fkEmbeddableField, UniqueKey<U> uk, TableField<U, ER> ukEmbeddableField, boolean enforced) Factory method for foreign keys.static final <R extends Record,U extends Record>
@NotNull ForeignKey<R,U> Internal.createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R, ?>... fields) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#9404] - Please re-generate your code.static final <R extends Record,U extends Record>
@NotNull ForeignKey<R,U> Internal.createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R, ?>... fields) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#9404] - Please re-generate your code.static final <R extends Record,U extends Record>
@NotNull ForeignKey<R,U> Internal.createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R, ?>[] fields, boolean enforced) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#9404] - Please re-generate your code.static final <R extends Record,U extends Record>
@NotNull ForeignKey<R,U> Internal.createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R, ?>[] fields, boolean enforced) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#9404] - Please re-generate your code.static final <R extends Record,U extends Record>
@NotNull ForeignKey<R,U> Internal.createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R, ?>... fields) Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.static final <R extends Record,U extends Record>
@NotNull ForeignKey<R,U> Internal.createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R, ?>... fields) Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.AbstractKeys.createIdentity(Table<R> table, TableField<R, T> field) Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codeInternal.createIdentity(Table<R> table, TableField<R, T> field) Factory method for identities.AbstractKeys.createUniqueKey(Table<R> table, String name, TableField<R, ?>... fields) Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codeAbstractKeys.createUniqueKey(Table<R> table, TableField<R, ?>... fields) Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codeInternal.createUniqueKey(Table<R> table, String name, TableField<R, ?>... fields) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#9404] - Please re-generate your code.Internal.createUniqueKey(Table<R> table, String name, TableField<R, ?>[] fields, boolean enforced) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#9404] - Please re-generate your code.Internal.createUniqueKey(Table<R> table, Name name, TableField<R, ?>... fields) Factory method for unique keys.Internal.createUniqueKey(Table<R> table, Name name, TableField<R, ?>[] fields, boolean enforced) Factory method for unique keys.static final <R extends Record,ER extends EmbeddableRecord<ER>>
@NotNull UniqueKey<R>Internal.createUniqueKey(Table<R> table, Name name, TableField<R, ER> embeddableField, boolean enforced) Factory method for unique keys.Internal.createUniqueKey(Table<R> table, TableField<R, ?>... fields) Factory method for unique keys.<R extends Record>
DeleteUsingStep<R>static <R extends Record>
@NotNull DeleteUsingStep<R>Create a new DSL delete statement.<R extends Record>
DeleteUsingStep<R>DefaultDSLContext.deleteFrom(Table<R> table) static <R extends Record>
@NotNull DeleteUsingStep<R>DSL.deleteFrom(Table<R> table) Create a new DSL delete statement.<R extends Record>
DeleteQuery<R>DefaultDSLContext.deleteQuery(Table<R> table) DefaultDSLContext.fetch(ResultQuery<R> query) DefaultDSLContext.fetch(Table<R> table, Collection<? extends Condition> conditions) <R extends Record>
R<R extends Record>
RDefaultDSLContext.fetchAny(Table<R> table, Collection<? extends Condition> conditions) <R extends Record>
R<R extends Record>
R<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync(Executor executor, ResultQuery<R> query) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync(Executor executor, Table<R> table) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync(Executor executor, Table<R> table, Collection<? extends Condition> conditions) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync(Executor executor, Table<R> table, Condition condition) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync(Executor executor, Table<R> table, Condition... conditions) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync(ResultQuery<R> query) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync(Table<R> table) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync(Table<R> table, Collection<? extends Condition> conditions) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync(Table<R> table, Condition condition) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync(Table<R> table, Condition... conditions) DefaultDSLContext.fetchLazy(ResultQuery<R> query) DefaultDSLContext.fetchLazy(Table<R> table, Collection<? extends Condition> conditions) DefaultDSLContext.fetchMany(ResultQuery<R> query) <R extends Record>
RDefaultDSLContext.fetchOne(ResultQuery<R> query) <R extends Record>
R<R extends Record>
RDefaultDSLContext.fetchOne(Table<R> table, Collection<? extends Condition> conditions) <R extends Record>
R<R extends Record>
RDefaultDSLContext.fetchOptional(ResultQuery<R> query) DefaultDSLContext.fetchOptional(Table<R> table) DefaultDSLContext.fetchOptional(Table<R> table, Collection<? extends Condition> conditions) DefaultDSLContext.fetchOptional(Table<R> table, Condition condition) DefaultDSLContext.fetchOptional(Table<R> table, Condition... conditions) <R extends Record>
RDefaultDSLContext.fetchSingle(ResultQuery<R> query) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Collection<? extends Condition> conditions) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition condition) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition... conditions) DefaultDSLContext.fetchStream(ResultQuery<R> query) DefaultDSLContext.fetchStream(Table<R> table) DefaultDSLContext.fetchStream(Table<R> table, Collection<? extends Condition> conditions) DefaultDSLContext.fetchStream(Table<R> table, Condition condition) DefaultDSLContext.fetchStream(Table<R> table, Condition... conditions) static final <R extends Record,ER extends EmbeddableRecord<ER>>
@NotNull TableField<R,?>[] Internal.fields(TableField<R, ER> embeddableField) Deprecated, for removal: This API element is subject to removal in a future version.- [#11058] - 3.14.5 - Please re-generate your code.static final <R extends Record,ER extends EmbeddableRecord<ER>>
@NotNull RowInternal.fieldsRow(TableField<R, ER> embeddableField) Deprecated, for removal: This API element is subject to removal in a future version.- [#12238] - 3.16.0 - Please re-generate your code.DSL.finalTable(Insert<R> query) DSL.finalTable(Merge<R> query) DSL.finalTable(Update<R> query) <R extends Record>
InsertSetStep<R>DefaultDSLContext.insertInto(Table<R> into) <R extends Record>
InsertValuesStepN<R>DefaultDSLContext.insertInto(Table<R> into, Collection<? extends Field<?>> fields) <R extends Record>
InsertValuesStepN<R>DefaultDSLContext.insertInto(Table<R> into, Field<?>... fields) <R extends Record,T1>
InsertValuesStep1<R,T1> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1) <R extends Record,T1, T2>
InsertValuesStep2<R,T1, T2> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2) <R extends Record,T1, T2, T3>
InsertValuesStep3<R,T1, T2, T3> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3) <R extends Record,T1, T2, T3, T4>
InsertValuesStep4<R,T1, T2, T3, T4> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) <R extends Record,T1, T2, T3, T4, T5>
InsertValuesStep5<R,T1, T2, T3, T4, T5> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) <R extends Record,T1, T2, T3, T4, T5, T6>
InsertValuesStep6<R,T1, T2, T3, T4, T5, T6> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) <R extends Record,T1, T2, T3, T4, T5, T6, T7>
InsertValuesStep7<R,T1, T2, T3, T4, T5, T6, T7> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8>
InsertValuesStep8<R,T1, T2, T3, T4, T5, T6, T7, T8> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9>
InsertValuesStep9<R,T1, T2, T3, T4, T5, T6, T7, T8, T9> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
InsertValuesStep10<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
InsertValuesStep11<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
InsertValuesStep12<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
InsertValuesStep13<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
InsertValuesStep14<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
InsertValuesStep15<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
InsertValuesStep16<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
InsertValuesStep17<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
InsertValuesStep18<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
InsertValuesStep19<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
InsertValuesStep20<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
InsertValuesStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
InsertValuesStep22<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) static <R extends Record>
@NotNull InsertSetStep<R>DSL.insertInto(Table<R> into) Create a new DSL insert statement.static <R extends Record>
@NotNull InsertValuesStepN<R>DSL.insertInto(Table<R> into, Collection<? extends Field<?>> fields) Create a new DSL insert statement.static <R extends Record>
@NotNull InsertValuesStepN<R>DSL.insertInto(Table<R> into, Field<?>... fields) Create a new DSL insert statement.static <R extends Record,T1>
@NotNull InsertValuesStep1<R,T1> DSL.insertInto(Table<R> into, Field<T1> field1) Create a new DSL insert statement.static <R extends Record,T1, T2>
@NotNull InsertValuesStep2<R,T1, T2> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2) Create a new DSL insert statement.static <R extends Record,T1, T2, T3>
@NotNull InsertValuesStep3<R,T1, T2, T3> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4>
@NotNull InsertValuesStep4<R,T1, T2, T3, T4> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5>
@NotNull InsertValuesStep5<R,T1, T2, T3, T4, T5> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6>
@NotNull InsertValuesStep6<R,T1, T2, T3, T4, T5, T6> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7>
@NotNull InsertValuesStep7<R,T1, T2, T3, T4, T5, T6, T7> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull InsertValuesStep8<R,T1, T2, T3, T4, T5, T6, T7, T8> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull InsertValuesStep9<R,T1, T2, T3, T4, T5, T6, T7, T8, T9> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull InsertValuesStep10<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull InsertValuesStep11<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull InsertValuesStep12<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull InsertValuesStep13<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull InsertValuesStep14<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull InsertValuesStep15<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull InsertValuesStep16<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull InsertValuesStep17<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull InsertValuesStep18<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull InsertValuesStep19<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull InsertValuesStep20<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull InsertValuesStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Create a new DSL insert statement.static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull InsertValuesStep22<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Create a new DSL insert statement.<R extends Record>
InsertQuery<R>DefaultDSLContext.insertQuery(Table<R> into) Create aLATERALjoined table.<R extends Record>
LoaderOptionsStep<R><R extends Record>
MergeUsingStep<R><R extends Record>
MergeKeyStepN<R>DefaultDSLContext.mergeInto(Table<R> table, Collection<? extends Field<?>> fields) <R extends Record>
MergeKeyStepN<R><R extends Record,T1>
MergeKeyStep1<R,T1> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2>
MergeKeyStep2<R,T1, T2> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3>
MergeKeyStep3<R,T1, T2, T3> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4>
MergeKeyStep4<R,T1, T2, T3, T4> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5>
MergeKeyStep5<R,T1, T2, T3, T4, T5> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6>
MergeKeyStep6<R,T1, T2, T3, T4, T5, T6> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7>
MergeKeyStep7<R,T1, T2, T3, T4, T5, T6, T7> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8>
MergeKeyStep8<R,T1, T2, T3, T4, T5, T6, T7, T8> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9>
MergeKeyStep9<R,T1, T2, T3, T4, T5, T6, T7, T8, T9> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
MergeKeyStep10<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
MergeKeyStep11<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
MergeKeyStep12<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
MergeKeyStep13<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
MergeKeyStep14<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
MergeKeyStep15<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
MergeKeyStep16<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
MergeKeyStep17<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
MergeKeyStep18<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
MergeKeyStep19<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
MergeKeyStep20<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
MergeKeyStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
MergeKeyStep22<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, 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, viaDefaultDSLContext.mergeInto(Table)static <R extends Record>
@NotNull MergeUsingStep<R>Create a new DSL SQL standard MERGE statement.static <R extends Record>
@NotNull MergeKeyStepN<R>DSL.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, viaDSL.mergeInto(Table)static <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, viaDSL.mergeInto(Table)static <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, viaDSL.mergeInto(Table)static <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, viaDSL.mergeInto(Table)static <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, viaDSL.mergeInto(Table)static <R extends Record,T1, T2, T3, T4>
@NotNull MergeKeyStep4<R,T1, T2, T3, T4> DSL.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, viaDSL.mergeInto(Table)static <R extends Record,T1, T2, T3, T4, T5>
@NotNull MergeKeyStep5<R,T1, T2, T3, T4, T5> DSL.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, viaDSL.mergeInto(Table)static <R extends Record,T1, T2, T3, T4, T5, T6>
@NotNull MergeKeyStep6<R,T1, T2, T3, T4, T5, T6> DSL.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, viaDSL.mergeInto(Table)static <R extends Record,T1, T2, T3, T4, T5, T6, T7>
@NotNull MergeKeyStep7<R,T1, T2, T3, T4, T5, T6, T7> DSL.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, viaDSL.mergeInto(Table)static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull MergeKeyStep8<R,T1, T2, T3, T4, T5, T6, T7, T8> DSL.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, viaDSL.mergeInto(Table)static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull MergeKeyStep9<R,T1, T2, T3, T4, T5, T6, T7, T8, T9> DSL.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, viaDSL.mergeInto(Table)static <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> DSL.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, viaDSL.mergeInto(Table)static <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> DSL.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, viaDSL.mergeInto(Table)static <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> DSL.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, viaDSL.mergeInto(Table)static <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> DSL.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, viaDSL.mergeInto(Table)static <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> DSL.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, viaDSL.mergeInto(Table)static <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> DSL.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, viaDSL.mergeInto(Table)static <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> DSL.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, viaDSL.mergeInto(Table)static <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> DSL.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, viaDSL.mergeInto(Table)static <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> DSL.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, viaDSL.mergeInto(Table)static <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> DSL.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, viaDSL.mergeInto(Table)static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull MergeKeyStep20<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> DSL.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, viaDSL.mergeInto(Table)static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull MergeKeyStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> DSL.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, viaDSL.mergeInto(Table)static <R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull MergeKeyStep22<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> DSL.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, viaDSL.mergeInto(Table)Get theMULTISEToperator to nest subqueries.<R extends Record>
R<R extends Record>
Rfinal <R extends Record,E>
RecordMapper<R,E> DefaultRecordMapperProvider.provide(RecordType<R> rowType, Class<? extends E> type) final <E,R extends Record>
RecordUnmapper<E,R> DefaultRecordUnmapperProvider.provide(Class<? extends E> type, RecordType<R> rowType) Internal.result(R record) Create an empty result from aRecordusing its row type.<R extends Record>
SelectWhereStep<R>DefaultDSLContext.selectFrom(Table<R> table) static <R extends Record>
@NotNull SelectWhereStep<R>DSL.selectFrom(Table<R> table) Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
SelectQuery<R>DefaultDSLContext.selectQuery(TableLike<R> table) Use a previously obtained result as a newTablethat can be used in SQL statements throughDSL.values(RowN...).A synonym forTableLike.asTable(), which might look a bit more fluent like this, to some users.DSL.table(R record) Use a previously obtained record as a new TableDSL.table(R... records) Use a previously obtained set of records as a new Table<R extends Record>
TruncateIdentityStep<R>static <R extends Record>
TruncateIdentityStep<R>TheTRUNCATEstatement.<R extends Record>
TruncateIdentityStep<R>DefaultDSLContext.truncateTable(Table<R> table) static <R extends Record>
TruncateIdentityStep<R>DSL.truncateTable(Table<R> table) TheTRUNCATE TABLEstatement.<R extends Record>
UpdateSetFirstStep<R>static <R extends Record>
@NotNull UpdateSetFirstStep<R>Create a new DSL update statement.<R extends Record>
UpdateQuery<R>DefaultDSLContext.updateQuery(Table<R> table) Methods in org.jooq.impl that return RecordModifier and TypeMethodDescriptionDefaultDSLContext.fetchSingle(String sql) DefaultDSLContext.fetchSingle(String sql, Object... bindings) DefaultDSLContext.fetchSingle(String sql, QueryPart... parts) DefaultDSLContext.fetchSingle(ResultSet rs) DefaultDSLContext.fetchSingle(ResultSet rs, Class<?>... types) DefaultDSLContext.fetchSingle(ResultSet rs, DataType<?>... types) DefaultDSLContext.fetchSingle(ResultSet rs, Field<?>... fields) DefaultDSLContext.fetchSingle(Collection<? extends SelectField<?>> fields) DefaultDSLContext.fetchSingle(SelectField<?>... fields) DefaultDSLContext.fetchSingle(SQL sql) UpdatableRecordImpl.key()DefaultDSLContext.newRecord(Collection<? extends Field<?>> fields) Methods in org.jooq.impl that return types with arguments of type RecordModifier and TypeMethodDescriptionDefaultDSLContext.createOrReplaceView(String view, String... fields) DefaultDSLContext.createOrReplaceView(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) DefaultDSLContext.createOrReplaceView(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) DefaultDSLContext.createOrReplaceView(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) DefaultDSLContext.createOrReplaceView(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) DefaultDSLContext.createOrReplaceView(Name view, Name... fields) DefaultDSLContext.createOrReplaceView(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createOrReplaceView(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createOrReplaceView(Table<?> view, Field<?>... fields) DefaultDSLContext.createView(String view, String... fields) DefaultDSLContext.createView(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) DefaultDSLContext.createView(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) DefaultDSLContext.createView(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) DefaultDSLContext.createView(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) DefaultDSLContext.createView(Name view, Name... fields) DefaultDSLContext.createView(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createView(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createView(Table<?> view, Field<?>... fields) DefaultDSLContext.createViewIfNotExists(String view, String... fields) DefaultDSLContext.createViewIfNotExists(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) DefaultDSLContext.createViewIfNotExists(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) DefaultDSLContext.createViewIfNotExists(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) DefaultDSLContext.createViewIfNotExists(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) DefaultDSLContext.createViewIfNotExists(Name view, Name... fields) DefaultDSLContext.createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createViewIfNotExists(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createViewIfNotExists(Table<?> view, Field<?>... fields) DSL.dual()TheDUALtable to be used for syntactic completeness.DefaultDSLContext.fetchAsync(String sql) DefaultDSLContext.fetchAsync(String sql, Object... bindings) DefaultDSLContext.fetchAsync(String sql, QueryPart... parts) DefaultDSLContext.fetchAsync(ResultSet rs) DefaultDSLContext.fetchAsync(ResultSet rs, Class<?>... types) DefaultDSLContext.fetchAsync(ResultSet rs, DataType<?>... types) DefaultDSLContext.fetchAsync(ResultSet rs, Field<?>... fields) DefaultDSLContext.fetchAsync(Executor executor, String sql) DefaultDSLContext.fetchAsync(Executor executor, String sql, Object... bindings) DefaultDSLContext.fetchAsync(Executor executor, String sql, QueryPart... parts) DefaultDSLContext.fetchAsync(Executor executor, ResultSet rs) DefaultDSLContext.fetchAsync(Executor executor, ResultSet rs, Class<?>... types) DefaultDSLContext.fetchAsync(Executor executor, ResultSet rs, DataType<?>... types) DefaultDSLContext.fetchAsync(Executor executor, ResultSet rs, Field<?>... fields) DefaultDSLContext.fetchAsync(Executor executor, SQL sql) DefaultDSLContext.fetchAsync(SQL sql) DefaultDSLContext.fetchFromCSV(String string) DefaultDSLContext.fetchFromCSV(String string, boolean header) DefaultDSLContext.fetchFromCSV(String string, boolean header, char delimiter) DefaultDSLContext.fetchFromCSV(String string, char delimiter) DefaultDSLContext.fetchFromHTML(String string) DefaultDSLContext.fetchFromJSON(String string) DefaultDSLContext.fetchFromStringData(String[]... strings) DefaultDSLContext.fetchFromStringData(List<String[]> strings) DefaultDSLContext.fetchFromStringData(List<String[]> strings, boolean header) DefaultDSLContext.fetchFromTXT(String string) DefaultDSLContext.fetchFromTXT(String string, String nullLiteral) DefaultDSLContext.fetchFromXML(String string) DefaultDSLContext.fetchOptional(String sql) DefaultDSLContext.fetchOptional(String sql, Object... bindings) DefaultDSLContext.fetchOptional(String sql, QueryPart... parts) DefaultDSLContext.fetchOptional(ResultSet rs) DefaultDSLContext.fetchOptional(ResultSet rs, Class<?>... types) DefaultDSLContext.fetchOptional(ResultSet rs, DataType<?>... types) DefaultDSLContext.fetchOptional(ResultSet rs, Field<?>... fields) DefaultDSLContext.fetchOptional(SQL sql) DefaultDSLContext.fetchStream(String sql) DefaultDSLContext.fetchStream(String sql, Object... bindings) DefaultDSLContext.fetchStream(String sql, QueryPart... parts) DefaultDSLContext.fetchStream(ResultSet rs) DefaultDSLContext.fetchStream(ResultSet rs, Class<?>... types) DefaultDSLContext.fetchStream(ResultSet rs, DataType<?>... types) DefaultDSLContext.fetchStream(ResultSet rs, Field<?>... fields) DefaultDSLContext.fetchStream(SQL sql) static @NotNull ArrayAggOrderByStep<Result<Record>>DSL.multisetAgg(Collection<? extends Field<?>> fields) Get theMULTISET_AGGaggregate function to nest group contents.static @NotNull ArrayAggOrderByStep<Result<Record>>DSL.multisetAgg(Field<?>... fields) Get theMULTISET_AGGaggregate function to nest group contents.DefaultDSLContext.newResult(Collection<? extends Field<?>> fields) static <T1> @NotNull RecordType<Record>DSL.recordType(Collection<? extends Field<?>> fields) Create aRecordTypeof an arbitrary degree.static <T1> @NotNull RecordType<Record>DSL.recordType(Field<?>[] fields) Create aRecordTypeof an arbitrary degree.DefaultDSLContext.resultQuery(String sql) DefaultDSLContext.resultQuery(String sql, Object... bindings) DefaultDSLContext.resultQuery(String sql, QueryPart... parts) DefaultDSLContext.resultQuery(SQL sql) static @NotNull ResultQuery<Record>DSL.resultQuery(String sql) Create a new query holding plain SQL.static @NotNull ResultQuery<Record>DSL.resultQuery(String sql, Object... bindings) Create a new query holding plain SQL.static @NotNull ResultQuery<Record>DSL.resultQuery(String sql, QueryPart... parts) Create a new query holding plain SQL.static @NotNull ResultQuery<Record>DSL.resultQuery(SQL sql) Create a new query holding plain SQL.Deprecated, for removal: This API element is subject to removal in a future version.- [#11812] - 3.15.0 - UseRowNas aSelectFielddirectly, instead.Create aROWS FROM (tables…)expression.DefaultDSLContext.select(Collection<? extends SelectFieldOrAsterisk> fields) DefaultDSLContext.select(SelectFieldOrAsterisk... fields) static @NotNull SelectSelectStep<Record>DSL.select(Collection<? extends SelectFieldOrAsterisk> fields) Create a new DSL subselect statement.static @NotNull SelectSelectStep<Record>DSL.select(SelectFieldOrAsterisk... fields) Create a new DSL subselect statement.DefaultDSLContext.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields) DefaultDSLContext.selectDistinct(SelectFieldOrAsterisk... fields) static @NotNull SelectSelectStep<Record>DSL.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields) Create a new DSL subselect statement.static @NotNull SelectSelectStep<Record>DSL.selectDistinct(SelectFieldOrAsterisk... fields) Create a new DSL subselect statement.DefaultDSLContext.selectFrom(String sql) DefaultDSLContext.selectFrom(String sql, Object... bindings) DefaultDSLContext.selectFrom(String sql, QueryPart... parts) DefaultDSLContext.selectFrom(Name table) DefaultDSLContext.selectFrom(SQL sql) static @NotNull SelectWhereStep<Record>DSL.selectFrom(String sql) Create a new DSL select statement, projecting*.static @NotNull SelectWhereStep<Record>DSL.selectFrom(String sql, Object... bindings) Create a new DSL select statement, projecting*.static @NotNull SelectWhereStep<Record>DSL.selectFrom(String sql, QueryPart... parts) Create a new DSL select statement, projecting*.static @NotNull SelectWhereStep<Record>DSL.selectFrom(Name table) Create a new DSL select statement, projecting*.static @NotNull SelectWhereStep<Record>DSL.selectFrom(SQL sql) Create a new DSL select statement, projecting*.DefaultDSLContext.selectQuery()A custom SQL clause that can render arbitrary table expressions.A custom SQL clause that can render arbitrary table expressions.A custom SQL clause that can render arbitrary table expressions.Create a qualified table, given its table name.Create a qualified table, given its table name.A custom SQL clause that can render arbitrary table expressions.static TruncateIdentityStep<Record>TheTRUNCATEstatement.static TruncateIdentityStep<Record>TheTRUNCATEstatement.DefaultDSLContext.truncateTable(String table) DefaultDSLContext.truncateTable(Name table) static TruncateIdentityStep<Record>DSL.truncateTable(String table) TheTRUNCATE TABLEstatement.static TruncateIdentityStep<Record>DSL.truncateTable(Name table) TheTRUNCATE TABLEstatement.Create aVALUES()expression of arbitrary degree.Methods in org.jooq.impl with parameters of type Record -
Uses of Record in org.jooq.tools.jdbc
Methods in org.jooq.tools.jdbc with parameters of type RecordModifier and TypeMethodDescriptionstatic final MockDataProviderCreate a newMockDataProviderthat always returns a single record for all queries.Constructors in org.jooq.tools.jdbc with parameters of type Record -
Uses of Record in org.jooq.util.aurorapostgres
Fields in org.jooq.util.aurorapostgres with type parameters of type Record -
Uses of Record in org.jooq.util.exasol
Fields in org.jooq.util.exasol with type parameters of type Record -
Uses of Record in org.jooq.util.h2
Fields in org.jooq.util.h2 with type parameters of type Record -
Uses of Record in org.jooq.util.hsqldb
Fields in org.jooq.util.hsqldb with type parameters of type Record -
Uses of Record in org.jooq.util.oracle
Fields in org.jooq.util.oracle with type parameters of type RecordModifier and TypeFieldDescriptionOracleDataType.REF_CURSORDeprecated, for removal: This API element is subject to removal in a future version. -
Uses of Record in org.jooq.util.postgres
Fields in org.jooq.util.postgres with type parameters of type RecordModifier and TypeFieldDescriptionPostgresDataType.REFCURSORDeprecated, for removal: This API element is subject to removal in a future version.Methods in org.jooq.util.postgres that return types with arguments of type RecordModifier and TypeMethodDescriptionGet the PostgreSQL-specificONLY [table]clause for use with table inheritance.Methods in org.jooq.util.postgres with parameters of type RecordModifier and TypeMethodDescriptionstatic StringPostgresUtils.toPGString(Record r) Create a PostgreSQL string representation of a record. -
Uses of Record in org.jooq.util.redshift
Fields in org.jooq.util.redshift with type parameters of type Record -
Uses of Record in org.jooq.util.vertica
Fields in org.jooq.util.vertica with type parameters of type Record -
Uses of Record in org.jooq.util.yugabytedb
Fields in org.jooq.util.yugabytedb with type parameters of type Record