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.interfaceCloseableResultQuery<R extends Record>AResultQuerythat holds a reference to the underlyingPreparedStatementwithout closing it, for reuse.interfaceCommonTableExpression<R extends Record>A common table expression.interfaceCreateViewAsStep<R extends Record>A step in the construction of theCREATE VIEWstatement.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<CHILD extends Record,PARENT extends Record> AForeignKeyis an object referencing aUniqueKey.interfaceForeignKey<CHILD extends Record,PARENT extends Record> AForeignKeyis an object referencing aUniqueKey.interfaceA generator can be used withDataType.generatedAlwaysAs(Generator)to implement dynamic, client side computed columns, i.e.interfaceGeneratorContext<R extends Record,X extends Table<R>, T> AGeneratorContextis an argument object that is passed to aGeneratorwhen generating client side computed columns.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.interfaceInverseForeignKey<PARENT extends Record,CHILD extends Record> AnInverseForeignKeyis an inverseForeignKey.interfaceInverseForeignKey<PARENT extends Record,CHILD extends Record> AnInverseForeignKeyis an inverseForeignKey.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.interfaceMergeColumnsStep<R extends Record>Deprecated, 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)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>Deprecated, 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)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.interfaceMergeNotMatchedThenStep<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>Deprecated, 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)interfaceA relationship path.interfaceA policy that applies row level security to a table.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.interfaceUDTPathField<R extends Record,U extends UDTRecord<U>, T> A field dereferenced from a UDT path.interfaceUDTPathTableField<R extends Record,U extends UDTRecord<U>, T> A field dereferenced from a UDT path.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>>An embeddable record.interfaceQualifiedRecord<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 CloseableResultQuery<X> <X extends Record>
@NotNull ResultQuery<X> Coerce the result record type of this query to that of a table.<R extends Record>
@NotNull DeleteUsingStep<R> Create a new DSL delete statement.<R extends Record>
@NotNull DeleteUsingStep<R> Create a new DSL delete statement.<R extends Record>
@NotNull DeleteUsingStep<R> DSLContext.deleteFrom(Table<R> table) Create a new DSL delete statement.<R extends Record>
@NotNull DeleteQuery<R> DSLContext.deleteQuery(Table<R> table) Create a 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<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDisambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21, Condition c22) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<Z extends Record>
ZResultQuery.fetchSingleInto(Table<Z> table) Map resulting records onto a custom record.DSLContext.fetchStream(ResultQuery<R> query) Execute 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.Records.intoHierarchy(Function<? super R, ? extends K> keyMapper, Function<? super R, ? extends K> parentKeyMapper, Function<? super R, ? extends E> nodeMapper, BiConsumer<? super E, ? super E> parentChildAppender) Create a collector that can collectRecordresulting from aResultQueryinto a hierarchy of custom data types.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.static final <R extends Record>
RecordMapper<R, @Nullable R> Records.nullOnAllNull()static final <R extends Record>
RecordMapper<R, @Nullable R> Records.nullOnAnyNull()Provide a list ofPolicyfor a table's row level security.<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(TableLike<R> table) Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
@NotNull SelectWhereStep<R> WithStep.selectFrom(TableLike<R> table) Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
@NotNull SelectQuery<R> DSLContext.selectQuery(TableLike<R> table) Create a newSelectQuery<R extends Record>
@NotNull TruncateIdentityStep<R> 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.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, usingFields.field(Field)for lookup.@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, usingFields.field(Field)for lookup.<T,U> @NotNull Record Set a value into this record, usingFields.field(Field)for lookup.Modifier and TypeMethodDescription@NotNull CloseableResultQuery<Record> CloseableResultQuery.coerce(Collection<? extends Field<?>> fields) @NotNull CloseableResultQuery<Record> @NotNull ResultQuery<Record> ResultQuery.coerce(Collection<? extends Field<?>> fields) Coerce the result record type of this query to that of a set of fields.@NotNull ResultQuery<Record> Coerce the result record type of this query to that of a set of fields.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedView(String view, String... fields) TheCREATE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedView(String view, Collection<? extends String> fields) TheCREATE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedView(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedView(Name view, Name... fields) TheCREATE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedView(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedView(Table<?> view, Field<?>... fields) TheCREATE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedViewIfNotExists(String view, String... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedViewIfNotExists(String view, Collection<? extends String> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedViewIfNotExists(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedViewIfNotExists(Name view, Name... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedViewIfNotExists(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedViewIfNotExists(Table<?> view, Field<?>... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceMaterializedView(String view, String... fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceMaterializedView(String view, Collection<? extends String> fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceMaterializedView(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceMaterializedView(Name view, Name... fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceMaterializedView(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceMaterializedView(Table<?> view, Field<?>... fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceView(String view, String... fields) TheCREATE OR REPLACE VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceView(String view, Collection<? extends String> fields) TheCREATE 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, Collection<? extends Name> fields) TheCREATE OR REPLACE VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceView(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceView(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceView(Name view, Name... fields) TheCREATE OR REPLACE VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceView(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE 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) TheCREATE OR REPLACE VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createView(String view, String... fields) TheCREATE VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createView(String view, Collection<? extends String> fields) TheCREATE 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, Collection<? extends Name> fields) TheCREATE VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createView(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record> DSLContext.createView(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record> DSLContext.createView(Name view, Name... fields) TheCREATE VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createView(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE 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) TheCREATE VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createViewIfNotExists(String view, String... fields) TheCREATE VIEW IF NOT EXISTSstatement.@NotNull CreateViewAsStep<Record> DSLContext.createViewIfNotExists(String view, Collection<? extends String> fields) TheCREATE VIEW IF NOT EXISTSstatement.@NotNull CreateViewAsStep<Record> DSLContext.createViewIfNotExists(String view, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record> DSLContext.createViewIfNotExists(String view, Function<? super Field<?>, ? extends String> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record> DSLContext.createViewIfNotExists(Name view, Collection<? extends Name> fields) TheCREATE VIEW IF NOT EXISTSstatement.@NotNull CreateViewAsStep<Record> DSLContext.createViewIfNotExists(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record> DSLContext.createViewIfNotExists(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record> DSLContext.createViewIfNotExists(Name view, Name... fields) TheCREATE VIEW IF NOT EXISTSstatement.@NotNull CreateViewAsStep<Record> DSLContext.createViewIfNotExists(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE VIEW IF NOT EXISTSstatement.@NotNull CreateViewAsStep<Record> DSLContext.createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record> DSLContext.createViewIfNotExists(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record> DSLContext.createViewIfNotExists(Table<?> view, Field<?>... fields) TheCREATE VIEW IF NOT EXISTSstatement.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, usingFields.field(String)for lookup.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, usingFields.field(String)for lookup.ResultQuery.fetchGroups(String[] keyFieldNames, String[] valueFieldNames) Execute the query and return aMapwith the result grouped by the given keys, usingFields.field(String)for lookup.ResultQuery.fetchGroups(String[] keyFieldNames, String[] valueFieldNames) Execute the query and return aMapwith the result grouped by the given keys, usingFields.field(String)for lookup.ResultQuery.fetchGroups(String[] keyFieldNames, RecordMapper<? super R, E> mapper) Execute the query and return aMapwith results grouped by the given keys and mapped by the given mapper, usingFields.field(String)for lookup.ResultQuery.fetchGroups(Field<?>[] keys) Execute the query and return aMapwith the result grouped by the given keys, usingFields.field(Field)for lookup.ResultQuery.fetchGroups(Field<?>[] keys, Class<? extends E> type) Execute the query and return aMapwith results grouped by the given keys and mapped into the given entity type, usingFields.field(Field)for lookup.ResultQuery.fetchGroups(Field<?>[] keys, Field<?>[] values) Execute the query and return aMapwith the result grouped by the given keys, usingFields.field(Field)for lookup.ResultQuery.fetchGroups(Field<?>[] keys, Field<?>[] values) Execute the query and return aMapwith the result grouped by the given keys, usingFields.field(Field)for lookup.ResultQuery.fetchGroups(Field<?>[] keys, RecordMapper<? super R, E> mapper) Execute the query and return aMapwith results grouped by the given keys and mapped by the given mapper, usingFields.field(Field)for lookup.ResultQuery.fetchGroups(Name[] keyFieldNames) Execute the query and return aMapwith the result grouped by the given keys, usingFields.field(Name)for lookup.ResultQuery.fetchGroups(Name[] keyFieldNames, Class<? extends E> type) Execute the query and return aMapwith results grouped by the given keys and mapped into the given entity type, usingFields.field(Name)for lookup.ResultQuery.fetchGroups(Name[] keyFieldNames, Name[] valueFieldNames) Execute the query and return aMapwith the result grouped by the given keys, usingFields.field(Name)for lookup.ResultQuery.fetchGroups(Name[] keyFieldNames, Name[] valueFieldNames) Execute the query and return aMapwith the result grouped by the given keys, usingFields.field(Name)for lookup.ResultQuery.fetchGroups(Name[] keyFieldNames, RecordMapper<? super R, E> mapper) Execute the query and return aMapwith results grouped by the given keys and mapped by the given mapper, usingFields.field(Name)for lookup.Execute a new query holding plain SQL and "lazily" return the generated result.Execute a new query holding plain SQL and "lazily" return the generated result.Execute a new query holding plain SQL and "lazily" return the generated result.Execute a new query holding plain SQL and "lazily" return the generated result.ResultQuery.fetchMap(int[] keyFieldIndexes) Execute the query and return 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, usingFields.field(String)for lookup.Execute the query and return aMapwith keys as a map key and the corresponding record as value, usingFields.field(String)for lookup.Execute the query and return aMapwith keys as a map key and the corresponding record as value, usingFields.field(String)for lookup.Execute the query and return aMapwith keys as a map key and the corresponding record as value, usingFields.field(Field)for lookup.Execute the query and return aMapwith keys as a map key and the corresponding record as value, usingFields.field(Field)for lookup.Execute the query and return aMapwith keys as a map key and the corresponding record as value, usingFields.field(Field)for lookup.Execute the query and return aMapwith keys as a map key and the corresponding record as value, usingFields.field(Name)for lookup.Execute the query and return aMapwith keys as a map key and the corresponding record as value, usingFields.field(Name)for lookup.Execute the query and return aMapwith keys as a map key and the corresponding record as value, usingFields.field(Name)for lookup.DSLContext.fetchOptional(String sql) Execute a new query holding plain SQL.DSLContext.fetchOptional(String sql, Object... bindings) Execute a new query holding plain SQL.DSLContext.fetchOptional(String sql, QueryPart... parts) Execute a new query holding plain SQL.DSLContext.fetchOptional(ResultSet rs) DSLContext.fetchOptional(ResultSet rs, Class<?>... types) DSLContext.fetchOptional(ResultSet rs, DataType<?>... types) DSLContext.fetchOptional(ResultSet rs, Field<?>... fields) DSLContext.fetchOptional(SQL sql) Execute a new query holding plain SQL.DSLContext.fetchStream(String sql) Execute a new query holding plain SQL and "lazily" return the generated result.DSLContext.fetchStream(String sql, Object... bindings) Execute a new query holding plain SQL and "lazily" return the generated result.DSLContext.fetchStream(String sql, QueryPart... parts) Execute a new query holding plain SQL and "lazily" return the generated result.DSLContext.fetchStream(ResultSet rs) DSLContext.fetchStream(ResultSet rs, Class<?>... types) DSLContext.fetchStream(ResultSet rs, DataType<?>... types) DSLContext.fetchStream(ResultSet rs, Field<?>... fields) DSLContext.fetchStream(SQL sql) Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull TableOptionalOnStep<Record> Table.fullHashJoin(Path<?> path) FULL OUTER JOINa path to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> Table.fullHashJoin(TableLike<?> table) FULL OUTER JOINa table to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TableOptionalOnStep<Record> FULL OUTER JOINa path to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TableOptionalOnStep<Record> Table.fullLoopJoin(Path<?> path) FULL OUTER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TablePartitionByStep<Record> Table.fullLoopJoin(TableLike<?> table) FULL OUTER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull TableOptionalOnStep<Record> Table.fullMergeJoin(Path<?> path) FULL OUTER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TablePartitionByStep<Record> Table.fullMergeJoin(TableLike<?> table) FULL OUTER JOINa table to this table with aQOM.JoinHint.MERGEhint.@NotNull TableOptionalOnStep<Record> Table.fullOuterHashJoin(Path<?> path) FULL OUTER JOINa path to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> Table.fullOuterHashJoin(TableLike<?> table) FULL OUTER JOINa table to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> Table.fullOuterJoin(String sql) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> Table.fullOuterJoin(String sql, Object... bindings) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> Table.fullOuterJoin(String sql, QueryPart... parts) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> Table.fullOuterJoin(Name name) FULL OUTER JOINa table to this table.@NotNull TableOptionalOnStep<Record> Table.fullOuterJoin(Path<?> path) FULL OUTER JOINa path to this table.@NotNull TablePartitionByStep<Record> Table.fullOuterJoin(SQL sql) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> Table.fullOuterJoin(TableLike<?> table) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.fullOuterJoin(String sql) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.fullOuterJoin(String sql, Object... bindings) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.fullOuterJoin(String sql, QueryPart... parts) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.fullOuterJoin(Name name) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.fullOuterJoin(SQL sql) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.fullOuterJoin(TableLike<?> table) FULL OUTER JOINa table to this table.@NotNull TableOptionalOnStep<Record> Table.fullOuterLoopJoin(Path<?> path) FULL OUTER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TablePartitionByStep<Record> Table.fullOuterLoopJoin(TableLike<?> table) FULL OUTER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull TableOptionalOnStep<Record> Table.fullOuterMergeJoin(Path<?> path) FULL OUTER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TablePartitionByStep<Record> Table.fullOuterMergeJoin(TableLike<?> table) FULL OUTER JOINa table to this table with aQOM.JoinHint.MERGEhint.DataType.getRecordType()Get the nested record's record type definition, if this is aDataType.isRecord(), or aDataType.isMultiset(), orNULLotherwise.@NotNull TableOptionalOnStep<Record> INNER JOINa path to this table with aQOM.JoinHint.HASHhint.@NotNull TableOnStep<Record> INNER JOINa table to this table with aQOM.JoinHint.HASHhint.PivotInStep.in(Collection<? extends Field<T>> fields) Specify the acceptable values for pivotingSpecify the acceptable values for pivotingSpecify the acceptable values for pivoting@NotNull TableOptionalOnStep<Record> Table.innerHashJoin(Path<?> path) INNER JOINa path to this table with aQOM.JoinHint.HASHhint.@NotNull TableOnStep<Record> Table.innerHashJoin(TableLike<?> table) INNER JOINa table to this table with aQOM.JoinHint.HASHhint.@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> INNER JOINa path to this table.@NotNull TableOnStep<Record> INNER JOINa table to this table.@NotNull TableOnStep<Record> INNER JOINa table to this table.@NotNull TableOptionalOnStep<Record> Table.innerLoopJoin(Path<?> path) INNER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TableOnStep<Record> Table.innerLoopJoin(TableLike<?> table) INNER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull TableOptionalOnStep<Record> Table.innerMergeJoin(Path<?> path) INNER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TableOnStep<Record> Table.innerMergeJoin(TableLike<?> table) INNER JOINa table to this table with aQOM.JoinHint.MERGEhint.Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)for lookup.@NotNull SelectFromStep<Record> Add a T-SQL 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, usingFields.field(String)for lookup.Result.intoGroups(String[] keyFieldNames, Class<? extends E> type) Return aMapwith results grouped by the given keys and mapped into the given entity type, usingFields.field(String)for lookup.Result.intoGroups(String[] keyFieldNames, String[] valueFieldNames) Return aMapwith the result grouped by the given keys, usingFields.field(String)for lookup.Result.intoGroups(String[] keyFieldNames, String[] valueFieldNames) Return aMapwith the result grouped by the given keys, usingFields.field(String)for lookup.Result.intoGroups(String[] keyFieldNames, RecordMapper<? super R, E> mapper) Return aMapwith results grouped by the given keys and mapped into the given entity type, usingFields.field(String)for lookup.Result.intoGroups(Field<?>[] keys) Return aMapwith the result grouped by the given keys, usingFields.field(Field)for lookup.Result.intoGroups(Field<?>[] keys, Class<? extends E> type) Return aMapwith results grouped by the given keys and mapped into the given entity type, usingFields.field(Field)for lookup.Result.intoGroups(Field<?>[] keys, Field<?>[] values) Return aMapwith the result grouped by the given keys, usingFields.field(Field)for lookup.Result.intoGroups(Field<?>[] keys, Field<?>[] values) Return aMapwith the result grouped by the given keys, usingFields.field(Field)for lookup.Result.intoGroups(Field<?>[] keys, RecordMapper<? super R, E> mapper) Return aMapwith results grouped by the given keys and mapped into the given entity type, usingFields.field(Field)for lookup.Result.intoGroups(Name[] keyFieldNames) Return aMapwith the result grouped by the given keys, usingFields.field(Name)for lookup.Result.intoGroups(Name[] keyFieldNames, Class<? extends E> type) Return aMapwith results grouped by the given keys and mapped into the given entity type, usingFields.field(Name)for lookup.Result.intoGroups(Name[] keyFieldNames, Name[] valueFieldNames) Return aMapwith the result grouped by the given keys, usingFields.field(Name)for lookup.Result.intoGroups(Name[] keyFieldNames, Name[] valueFieldNames) Return aMapwith the result grouped by the given keys, usingFields.field(Name)for lookup.Result.intoGroups(Name[] keyFieldNames, RecordMapper<? super R, E> mapper) Return aMapwith results grouped by the given keys and mapped into the given entity type, usingFields.field(Name)for lookup.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, usingFields.field(String)for lookup.Return aMapwith the given keys as a map key and the corresponding record as value, usingFields.field(String)for lookup.Return aMapwith the given keys as a map key and the corresponding record as value, usingFields.field(String)for lookup.Return aMapwith the given keys as a map key and the corresponding record as value, usingFields.field(Field)for lookup.Return aMapwith the given keys as a map key and the corresponding record as value, usingFields.field(Field)for lookup.Return aMapwith the given keys as a map key and the corresponding record as value, usingFields.field(Field)for lookup.Return aMapwith the given keys as a map key and the corresponding record as value, usingFields.field(Name)for lookup.Return aMapwith the given keys as a map key and the corresponding record as value, usingFields.field(Name)for lookup.Return aMapwith the given keys as a map key and the corresponding record as value, usingFields.field(Name)for lookup.@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> INNER JOINa path 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 TableOptionalOnStep<Record> Table.join(TableLike<?> table, JoinType type, QOM.JoinHint hint) Join a table to this table using aJoinTypeandQOM.JoinHint.@NotNull TablePartitionByStep<Record> Join a table to this table using aJoinType.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.join(TableLike<?> table, JoinType type, QOM.JoinHint hint) Join a table to this table using aJoinTypeand aQOM.JoinHint.@NotNull TableOptionalOnStep<Record> Table.leftHashJoin(Path<?> path) LEFT OUTER JOINa path to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> Table.leftHashJoin(TableLike<?> table) LEFT OUTER JOINa table to this table with aQOM.JoinHint.HASHhint.@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 TableOptionalOnStep<Record> LEFT OUTER JOINa path 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 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 TableOptionalOnStep<Record> Table.leftLoopJoin(Path<?> path) LEFT OUTER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TablePartitionByStep<Record> Table.leftLoopJoin(TableLike<?> table) LEFT OUTER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull TableOptionalOnStep<Record> Table.leftMergeJoin(Path<?> path) LEFT OUTER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TablePartitionByStep<Record> Table.leftMergeJoin(TableLike<?> table) LEFT OUTER JOINa table to this table with aQOM.JoinHint.MERGEhint.@NotNull TableOptionalOnStep<Record> Table.leftOuterHashJoin(Path<?> path) LEFT OUTER JOINa path to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> Table.leftOuterHashJoin(TableLike<?> table) LEFT OUTER JOINa table to this table with aQOM.JoinHint.HASHhint.@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 TableOptionalOnStep<Record> Table.leftOuterJoin(Path<?> path) LEFT OUTER JOINa path 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 TablePartitionByStep<Record> TableOuterJoinStep.leftOuterJoin(String sql) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.leftOuterJoin(String sql, Object... bindings) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.leftOuterJoin(String sql, QueryPart... parts) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.leftOuterJoin(Name name) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.leftOuterJoin(SQL sql) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.leftOuterJoin(TableLike<?> table) LEFT OUTER JOINa table to this table.@NotNull TableOptionalOnStep<Record> Table.leftOuterLoopJoin(Path<?> path) LEFT OUTER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TablePartitionByStep<Record> Table.leftOuterLoopJoin(TableLike<?> table) LEFT OUTER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull TableOptionalOnStep<Record> Table.leftOuterMergeJoin(Path<?> path) LEFT OUTER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TablePartitionByStep<Record> Table.leftOuterMergeJoin(TableLike<?> table) LEFT OUTER JOINa table to this table with aQOM.JoinHint.MERGEhint.@NotNull TableOptionalOnStep<Record> INNER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TableOnStep<Record> INNER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull TableOptionalOnStep<Record> INNER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TableOnStep<Record> INNER JOINa table to this table with aQOM.JoinHint.MERGEhint.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 TableOptionalOnStep<Record> Table.rightHashJoin(Path<?> path) RIGHT OUTER JOINa path to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> Table.rightHashJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table with aQOM.JoinHint.HASHhint.@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 TableOptionalOnStep<Record> RIGHT OUTER JOINa path 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 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 TableOptionalOnStep<Record> Table.rightLoopJoin(Path<?> path) RIGHT OUTER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TablePartitionByStep<Record> Table.rightLoopJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull TableOptionalOnStep<Record> Table.rightMergeJoin(Path<?> path) RIGHT OUTER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TablePartitionByStep<Record> Table.rightMergeJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table with aQOM.JoinHint.MERGEhint.@NotNull TableOptionalOnStep<Record> Table.rightOuterHashJoin(Path<?> path) RIGHT OUTER JOINa path to this table with aQOM.JoinHint.HASHhint.@NotNull TablePartitionByStep<Record> Table.rightOuterHashJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table with aQOM.JoinHint.HASHhint.@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 TableOptionalOnStep<Record> Table.rightOuterJoin(Path<?> path) RIGHT OUTER JOINa path 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 TablePartitionByStep<Record> TableOuterJoinStep.rightOuterJoin(String sql) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.rightOuterJoin(String sql, Object... bindings) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.rightOuterJoin(String sql, QueryPart... parts) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.rightOuterJoin(Name name) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.rightOuterJoin(SQL sql) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.rightOuterJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table.@NotNull TableOptionalOnStep<Record> Table.rightOuterLoopJoin(Path<?> path) RIGHT OUTER JOINa path to this table with aQOM.JoinHint.LOOPhint.@NotNull TablePartitionByStep<Record> Table.rightOuterLoopJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table with aQOM.JoinHint.LOOPhint.@NotNull TableOptionalOnStep<Record> Table.rightOuterMergeJoin(Path<?> path) RIGHT OUTER JOINa path to this table with aQOM.JoinHint.MERGEhint.@NotNull TablePartitionByStep<Record> Table.rightOuterMergeJoin(TableLike<?> table) RIGHT OUTER JOINa table to this table with aQOM.JoinHint.MERGEhint.@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 TableOptionalOnStep<Record> Table.straightJoin(Path<?> path) STRAIGHT_JOINa path 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.truncate(Collection<? extends Table<?>> table) TheTRUNCATEstatement.@NotNull TruncateIdentityStep<Record> TheTRUNCATEstatement.@NotNull TruncateIdentityStep<Record> TheTRUNCATEstatement.@NotNull TruncateIdentityStep<Record> TheTRUNCATEstatement.@NotNull TruncateIdentityStep<Record> DSLContext.truncateTable(String table) TheTRUNCATE TABLEstatement.@NotNull TruncateIdentityStep<Record> DSLContext.truncateTable(String... table) TheTRUNCATE TABLEstatement.@NotNull TruncateIdentityStep<Record> DSLContext.truncateTable(Collection<? extends Table<?>> table) TheTRUNCATE TABLEstatement.@NotNull TruncateIdentityStep<Record> DSLContext.truncateTable(Name table) TheTRUNCATE TABLEstatement.@NotNull TruncateIdentityStep<Record> DSLContext.truncateTable(Name... table) TheTRUNCATE TABLEstatement.@NotNull TruncateIdentityStep<Record> DSLContext.truncateTable(Table<?>... 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.Table.withOrdinality()Add theWITH ORDINALITYclause.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.booleanDeprecated, for removal: This API element is subject to removal in a future version.- [#12494] - 3.20.0 - UseField.touched(Record)instead.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(PARENT... records) Fetch child records of a given set of records through this foreign keyForeignKey.fetchParents(CHILD... records) Fetch parent records of a given set of record through this foreign keyThe inverse operation ofFields.field(Field).The inverse operation ofinto(Field).The inverse operation ofinto(Table).@NotNull 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.voidSet the last record that was fetched from the result set.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 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.booleanThe inverse operation oftouched(Field).@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 InsertSetMoreStep<R> InsertSetMoreStep.set(Collection<? extends Record> records) Set values in theINSERTstatement.@NotNull InsertSetMoreStep<R> InsertSetStep.set(Collection<? extends Record> records) Set values in 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 TypeClassDescriptionfinal classAuditGenerator<R extends Record,X extends Table<R>, T> AGeneratorthat can be used for audit columns, whose values are defined byConfiguration.auditProvider().classDefaultRecordMapper<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>TheCREATE VIEWstatement.static interfaceQOM.CrossApply<R extends Record>static interfaceQOM.CrossJoin<R extends Record>static interfaceQOM.DataChangeDeltaTable<R extends Record>static interfaceQOM.Delete<R extends Record>TheDELETEstatement.static interfaceQOM.DeleteReturning<R extends Record>AnDELETEstatement with aRETURNINGclause.static interfaceQOM.DerivedTable<R extends Record>static interfaceQOM.FullJoin<R extends Record>static interfaceQOM.HintedTable<R extends Record>A table with a MySQL style index access hint.static interfaceQOM.Insert<R extends Record>TheINSERTstatement.static interfaceQOM.InsertReturning<R extends Record>AnINSERTstatement with aRETURNINGclause.static interfacestatic interfaceQOM.JoinTable<R extends Record,J extends QOM.JoinTable<R, J>> static interfaceQOM.Lateral<R extends Record>static interfaceQOM.LeftAntiJoin<R extends Record>static interfaceQOM.LeftJoin<R extends Record>static interfaceQOM.LeftSemiJoin<R extends Record>static interfaceQOM.LinkedTable<R extends Record>A table with a database link.static interfacestatic interfaceQOM.Multiset<R extends Record>static interfaceQOM.MultisetAgg<R extends Record>static interfaceQOM.NaturalFullJoin<R extends Record>static interfaceQOM.NaturalJoin<R extends Record>static interfaceQOM.NaturalLeftJoin<R extends Record>static interfaceQOM.NaturalRightJoin<R extends Record>static interfaceQOM.OuterApply<R extends Record>static interfaceQOM.QualifiedJoin<R extends Record,J extends QOM.QualifiedJoin<R, J>> static interfaceQOM.QuantifiedSelect<R extends Record>static interfaceQOM.RightJoin<R extends Record>static interfaceQOM.RowAsField<R extends Record>static interfaceQOM.StraightJoin<R extends Record>static interfaceQOM.TableAlias<R extends Record>static interfaceQOM.TableAsField<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.Update<R extends Record>TheUPDATEstatement.static interfaceQOM.UpdateReturning<R extends Record>AnUPDATEstatement with aRETURNINGclause.static interfaceQOM.Values<R extends Record>static interfaceQOM.WithOrdinalityTable<R extends Record>A collection derived table or table valued function with aWITH ORDINALITYclause.static interfaceQOM.WithTable<R extends Record>A table with a T-SQL styleWITHhint.classA common base type for tablesclassUDTPathFieldImpl<R extends Record,U extends UDTRecord<U>, T> A common base type for UDT path fields.classUDTPathTableFieldImpl<R extends Record,U extends UDTRecord<U>, T> A common base type for table fields that are alsoUDTPathField.Classes 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 TypeMethodDescription<O extends Record>
@NotNull QOM.HintedTable<O> <O extends Record>
@NotNull QOM.LinkedTable<O> <O extends Record>
@NotNull QOM.WithTable<O> static <R extends Record>
@NotNull QuantifiedSelect<R> Create 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.final <R extends Record>
DefaultPolicyProviderDefaultPolicyProvider.append(Table<R> table, Condition condition, Collection<? extends Path<R>> inherited) Add aPolicyfor aPolicy.table()andPolicy.condition()as well as a set ofPolicy.inherited()paths.final <R extends Record>
DefaultPolicyProviderAdd aPolicyfor aPolicy.table()andPolicy.condition()as well as a set ofPolicy.inherited()paths.Internal.createCheck(Table<R> table, Name name, String condition) Factory method for check constraints.Internal.createCheck(Table<R> table, Name name, String condition, boolean 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) Deprecated.- 3.20.0 - [#9736] - Regenerate your code.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) Deprecated.- 3.20.0 - [#9736] - Regenerate your code.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, QOM.ForeignKeyRule deleteRule, QOM.ForeignKeyRule updateRule) 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, QOM.ForeignKeyRule deleteRule, QOM.ForeignKeyRule updateRule) 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) Deprecated.- 3.20.0 - [#9736] - Regenerate your code.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) Deprecated.- 3.20.0 - [#9736] - Regenerate your code.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, QOM.ForeignKeyRule deleteRule, QOM.ForeignKeyRule updateRule) 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, QOM.ForeignKeyRule deleteRule, QOM.ForeignKeyRule updateRule) 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, String name, TableField<R, ?>[] fields, boolean enforced, QOM.ForeignKeyRule deleteRule, QOM.ForeignKeyRule updateRule) 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, boolean enforced, QOM.ForeignKeyRule deleteRule, QOM.ForeignKeyRule updateRule) 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, 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.static final <R extends Record,T, P extends UDTPathTableField<R, ?, T>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, Table<R> table, Class<P> returnType) static final <R extends Record,T, P extends UDTPathTableField<R, ?, T>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, Table<R> table, String comment, Class<P> returnType) static final <R extends Record,T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, Table<R> table, String comment, Class<P> returnType, Binding<T, U> binding) static final <R extends Record,T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, Table<R> table, String comment, Class<P> returnType, Converter<T, U> converter) static final <R extends Record,T, X, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, Table<R> table, String comment, Class<P> returnType, Converter<X, U> converter, Binding<T, X> binding) static final <R extends Record,TR extends Table<R>, T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, TR table, String comment, Class<P> returnType, Binding<T, U> binding, Generator<R, TR, U> generator) static final <R extends Record,TR extends Table<R>, T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, TR table, String comment, Class<P> returnType, Converter<T, U> converter, Generator<R, TR, U> generator) static final <R extends Record,TR extends Table<R>, T, X, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, TR table, String comment, Class<P> returnType, Converter<X, U> converter, Binding<T, X> binding, Generator<R, TR, U> generator) static final <R extends Record,TR extends Table<R>, T, P extends UDTPathTableField<R, ?, T>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, TR table, String comment, Class<P> returnType, Generator<R, TR, T> generator) 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) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21) <R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21, Condition c22) DefaultDSLContext.fetchStream(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) Deprecated, 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>
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, viaDefaultDSLContext.mergeInto(Table)<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(TableLike<R> table) static <R extends Record>
@NotNull SelectWhereStep<R> DSL.selectFrom(TableLike<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.createMaterializedView(String view, String... fields) DefaultDSLContext.createMaterializedView(String view, Collection<? extends String> fields) DefaultDSLContext.createMaterializedView(Name view, Collection<? extends Name> fields) DefaultDSLContext.createMaterializedView(Name view, Name... fields) DefaultDSLContext.createMaterializedView(Table<?> view, Collection<? extends Field<?>> fields) DefaultDSLContext.createMaterializedView(Table<?> view, Field<?>... fields) static CreateViewAsStep<Record> DSL.createMaterializedView(String view, String... fields) TheCREATE MATERIALIZED VIEWstatement.static CreateViewAsStep<Record> DSL.createMaterializedView(String view, Collection<? extends String> fields) TheCREATE MATERIALIZED VIEWstatement.static CreateViewAsStep<Record> DSL.createMaterializedView(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEWstatement.static CreateViewAsStep<Record> DSL.createMaterializedView(Name view, Name... fields) TheCREATE MATERIALIZED VIEWstatement.static CreateViewAsStep<Record> DSL.createMaterializedView(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE MATERIALIZED VIEWstatement.static CreateViewAsStep<Record> DSL.createMaterializedView(Table<?> view, Field<?>... fields) TheCREATE MATERIALIZED VIEWstatement.DefaultDSLContext.createMaterializedViewIfNotExists(String view, String... fields) DefaultDSLContext.createMaterializedViewIfNotExists(String view, Collection<? extends String> fields) DefaultDSLContext.createMaterializedViewIfNotExists(Name view, Collection<? extends Name> fields) DefaultDSLContext.createMaterializedViewIfNotExists(Name view, Name... fields) DefaultDSLContext.createMaterializedViewIfNotExists(Table<?> view, Collection<? extends Field<?>> fields) DefaultDSLContext.createMaterializedViewIfNotExists(Table<?> view, Field<?>... fields) static CreateViewAsStep<Record> DSL.createMaterializedViewIfNotExists(String view, String... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.static CreateViewAsStep<Record> DSL.createMaterializedViewIfNotExists(String view, Collection<? extends String> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.static CreateViewAsStep<Record> DSL.createMaterializedViewIfNotExists(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.static CreateViewAsStep<Record> DSL.createMaterializedViewIfNotExists(Name view, Name... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.static CreateViewAsStep<Record> DSL.createMaterializedViewIfNotExists(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.static CreateViewAsStep<Record> DSL.createMaterializedViewIfNotExists(Table<?> view, Field<?>... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.DefaultDSLContext.createOrReplaceMaterializedView(String view, String... fields) DefaultDSLContext.createOrReplaceMaterializedView(String view, Collection<? extends String> fields) DefaultDSLContext.createOrReplaceMaterializedView(Name view, Collection<? extends Name> fields) DefaultDSLContext.createOrReplaceMaterializedView(Name view, Name... fields) DefaultDSLContext.createOrReplaceMaterializedView(Table<?> view, Collection<? extends Field<?>> fields) DefaultDSLContext.createOrReplaceMaterializedView(Table<?> view, Field<?>... fields) static CreateViewAsStep<Record> DSL.createOrReplaceMaterializedView(String view, String... fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.static CreateViewAsStep<Record> DSL.createOrReplaceMaterializedView(String view, Collection<? extends String> fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.static CreateViewAsStep<Record> DSL.createOrReplaceMaterializedView(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.static CreateViewAsStep<Record> DSL.createOrReplaceMaterializedView(Name view, Name... fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.static CreateViewAsStep<Record> DSL.createOrReplaceMaterializedView(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.static CreateViewAsStep<Record> DSL.createOrReplaceMaterializedView(Table<?> view, Field<?>... fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.DefaultDSLContext.createOrReplaceView(String view, String... fields) DefaultDSLContext.createOrReplaceView(String view, Collection<? extends 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, Collection<? extends Name> fields) 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, Collection<? extends Field<?>> fields) DefaultDSLContext.createOrReplaceView(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createOrReplaceView(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createOrReplaceView(Table<?> view, Field<?>... fields) static CreateViewAsStep<Record> DSL.createOrReplaceView(String view, String... fields) TheCREATE OR REPLACE VIEWstatement.static CreateViewAsStep<Record> DSL.createOrReplaceView(String view, Collection<? extends String> fields) TheCREATE OR REPLACE VIEWstatement.static @NotNull CreateViewAsStep<Record> DSL.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.static CreateViewAsStep<Record> DSL.createOrReplaceView(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE VIEWstatement.static @NotNull CreateViewAsStep<Record> DSL.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.static CreateViewAsStep<Record> DSL.createOrReplaceView(Name view, Name... fields) TheCREATE OR REPLACE VIEWstatement.static CreateViewAsStep<Record> DSL.createOrReplaceView(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE OR REPLACE VIEWstatement.static @NotNull CreateViewAsStep<Record> DSL.createOrReplaceView(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.static CreateViewAsStep<Record> DSL.createOrReplaceView(Table<?> view, Field<?>... fields) TheCREATE OR REPLACE VIEWstatement.DefaultDSLContext.createView(String view, String... fields) DefaultDSLContext.createView(String view, Collection<? extends 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, Collection<? extends Name> fields) 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, Collection<? extends Field<?>> fields) DefaultDSLContext.createView(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createView(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createView(Table<?> view, Field<?>... fields) static CreateViewAsStep<Record> DSL.createView(String view, String... fields) TheCREATE VIEWstatement.static CreateViewAsStep<Record> DSL.createView(String view, Collection<? extends String> fields) TheCREATE VIEWstatement.static @NotNull CreateViewAsStep<Record> DSL.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.static CreateViewAsStep<Record> DSL.createView(Name view, Collection<? extends Name> fields) TheCREATE VIEWstatement.static @NotNull CreateViewAsStep<Record> DSL.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.static CreateViewAsStep<Record> DSL.createView(Name view, Name... fields) TheCREATE VIEWstatement.static CreateViewAsStep<Record> DSL.createView(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE VIEWstatement.static @NotNull CreateViewAsStep<Record> DSL.createView(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.static CreateViewAsStep<Record> DSL.createView(Table<?> view, Field<?>... fields) TheCREATE VIEWstatement.DefaultDSLContext.createViewIfNotExists(String view, String... fields) DefaultDSLContext.createViewIfNotExists(String view, Collection<? extends 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, Collection<? extends Name> fields) 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, Collection<? extends Field<?>> fields) DefaultDSLContext.createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createViewIfNotExists(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) DefaultDSLContext.createViewIfNotExists(Table<?> view, Field<?>... fields) static CreateViewAsStep<Record> DSL.createViewIfNotExists(String view, String... fields) TheCREATE VIEW IF NOT EXISTSstatement.static CreateViewAsStep<Record> DSL.createViewIfNotExists(String view, Collection<? extends String> fields) TheCREATE VIEW IF NOT EXISTSstatement.static @NotNull CreateViewAsStep<Record> DSL.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.static CreateViewAsStep<Record> DSL.createViewIfNotExists(Name view, Collection<? extends Name> fields) TheCREATE VIEW IF NOT EXISTSstatement.static @NotNull CreateViewAsStep<Record> DSL.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.static CreateViewAsStep<Record> DSL.createViewIfNotExists(Name view, Name... fields) TheCREATE VIEW IF NOT EXISTSstatement.static CreateViewAsStep<Record> DSL.createViewIfNotExists(Table<?> view, Collection<? extends Field<?>> fields) TheCREATE VIEW IF NOT EXISTSstatement.static @NotNull CreateViewAsStep<Record> DSL.createViewIfNotExists(Table<?> view, Function<? super Field<?>, ? extends Field<?>> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.static CreateViewAsStep<Record> DSL.createViewIfNotExists(Table<?> view, Field<?>... fields) TheCREATE VIEW IF NOT EXISTSstatement.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) final TableOptionalOnStep<Record> final TableOptionalOnStep<Record> TableImpl.join(TableLike<?> table, JoinType type, QOM.JoinHint hint) static @NotNull ArrayAggOrderByStep<Result<Record>> DSL.multisetAgg(Collection<? extends SelectField<?>> fields) Get theMULTISET_AGGaggregate function to nest group contents.static @NotNull ArrayAggOrderByStep<Result<Record>> DSL.multisetAgg(Field<?>... fields) static @NotNull ArrayAggOrderByStep<Result<Record>> DSL.multisetAgg(SelectField<?>... fields) Get theMULTISET_AGGaggregate function to nest group contents.static @NotNull ArrayAggOrderByStep<Result<Record>> DSL.multisetAggDistinct(Collection<? extends Field<?>> fields) Get theMULTISET_AGG(DISTINCT)aggregate function to nest group contents.static @NotNull ArrayAggOrderByStep<Result<Record>> DSL.multisetAggDistinct(Field<?>... fields) Get theMULTISET_AGG(DISTINCT)aggregate 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.DefaultDSLContext.truncate(Collection<? extends Table<?>> table) static TruncateIdentityStep<Record> TheTRUNCATEstatement.static TruncateIdentityStep<Record> TheTRUNCATEstatement.static TruncateIdentityStep<Record> DSL.truncate(Collection<? extends Table<?>> table) TheTRUNCATEstatement.static TruncateIdentityStep<Record> TheTRUNCATEstatement.static TruncateIdentityStep<Record> TheTRUNCATEstatement.static TruncateIdentityStep<Record> TheTRUNCATEstatement.DefaultDSLContext.truncateTable(String table) DefaultDSLContext.truncateTable(String... table) DefaultDSLContext.truncateTable(Collection<? extends Table<?>> table) DefaultDSLContext.truncateTable(Name table) DefaultDSLContext.truncateTable(Name... table) DefaultDSLContext.truncateTable(Table<?>... table) static TruncateIdentityStep<Record> DSL.truncateTable(String table) TheTRUNCATE TABLEstatement.static TruncateIdentityStep<Record> DSL.truncateTable(String... table) TheTRUNCATE TABLEstatement.static TruncateIdentityStep<Record> DSL.truncateTable(Collection<? extends Table<?>> table) TheTRUNCATE TABLEstatement.static TruncateIdentityStep<Record> DSL.truncateTable(Name table) TheTRUNCATE TABLEstatement.static TruncateIdentityStep<Record> DSL.truncateTable(Name... table) TheTRUNCATE TABLEstatement.static TruncateIdentityStep<Record> DSL.truncateTable(Table<?>... 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.RECORDDeprecated, for removal: This API element is subject to removal in a future version.PostgresDataType.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