Uses of Interface
org.jooq.Record
-
Packages that use Record Package Description org.jooq This package contains jOOQ's public API.org.jooq.impl This package contains jOOQ's implementation classes.org.jooq.tools.jdbc This package contains compatibility classes to bridge between JDBC 4.0 and JDBC 4.1.org.jooq.util.aurorapostgres This package contains classes related to theSQLDialect.AURORA_POSTGRESdialect family.org.jooq.util.h2 This package contains classes related to theSQLDialect.H2dialect family.org.jooq.util.hsqldb This package contains classes related to theSQLDialect.HSQLDBdialect family.org.jooq.util.oracle This package contains classes related to theSQLDialect.ORACLEdialect family.org.jooq.util.postgres This package contains classes related to theSQLDialect.POSTGRESdialect family.org.jooq.util.redshift This package contains classes related to theSQLDialect.REDSHIFTdialect family.org.jooq.util.vertica This package contains classes related to theSQLDialect.VERTICAdialect family. -
-
Uses of Record in org.jooq
Classes in org.jooq with type parameters of type Record Modifier and Type Interface Description interfaceBetweenAndStepR<R extends Record>An intermediate DSL type for the construction of aBETWEENpredicate.interfaceCheck<R extends Record>A check constraint.interfaceCommonTableExpression<R extends Record>A common table expression.interfaceCreateTableAsStep<R extends Record>AQuerythat can create tables.interfaceCreateViewAsStep<R extends Record>AQuerythat can create views.interfaceCursor<R extends Record>Cursors allow for lazy, sequential access to an underlying JDBCResultSet.interfaceDelete<R extends Record>ADELETEstatement.interfaceDeleteConditionStep<R extends Record>This type is used for theDelete's DSL API.interfaceDeleteFinalStep<R extends Record>This type is used for theDelete's DSL API.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.interfaceForeignKey<R extends Record,O extends Record>AForeignKeyis an object referencing aUniqueKey.interfaceForeignKey<R extends Record,O extends Record>AForeignKeyis an object referencing aUniqueKey.interfaceFutureResult<R extends Record>Deprecated.- 3.2.0 - [#2581] - This type will be removed in jOOQ 4.0interfaceIdentity<R extends Record,T>AnIdentityis an object representing anIDENTITYcolumn as understood by the SQL:2003 standard.interfaceInsert<R extends Record>AnINSERTstatement.interfaceInsertFinalStep<R extends Record>This type is used for theInsert's DSL API.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.interfaceKey<R extends Record>AKeyis an object representing aUNIQUE KEY, aPRIMARY KEY, or aFOREIGN KEY.interfaceLoader<R extends Record>TheLoaderAPI 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.interfaceMerge<R extends Record>AMERGEstatement.interfaceMergeFinalStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeKeyStep1<R extends Record,T1>Deprecated.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)interfaceMergeKeyStep2<R extends Record,T1,T2>Deprecated.- [#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.- [#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.- [#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.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)interfaceMergeKeyStep3<R extends Record,T1,T2,T3>Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)interfaceMergeKeyStep4<R extends Record,T1,T2,T3,T4>Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)interfaceMergeKeyStep5<R extends Record,T1,T2,T3,T4,T5>Deprecated.- [#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.- [#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.- [#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.- [#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.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)interfaceMergeKeyStepN<R extends Record>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeMatchedDeleteStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeMatchedSetMoreStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeMatchedSetStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeMatchedStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeMatchedThenStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeMatchedWhereStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeNotMatchedSetMoreStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeNotMatchedSetStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeNotMatchedStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep1<R extends Record,T1>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep2<R extends Record,T1,T2>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep3<R extends Record,T1,T2,T3>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep4<R extends Record,T1,T2,T3,T4>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep5<R extends Record,T1,T2,T3,T4,T5>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>This type is used for theMerge's DSL API.interfaceMergeNotMatchedValuesStepN<R extends Record>This type is used for theMerge's DSL API.interfaceMergeNotMatchedWhereStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeOnConditionStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeOnStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeUsingStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeValuesStep1<R extends Record,T1>Deprecated.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)interfaceMergeValuesStep2<R extends Record,T1,T2>Deprecated.- [#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.- [#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.- [#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.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)interfaceMergeValuesStep3<R extends Record,T1,T2,T3>Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)interfaceMergeValuesStep4<R extends Record,T1,T2,T3,T4>Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)interfaceMergeValuesStep5<R extends Record,T1,T2,T3,T4,T5>Deprecated.- [#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.- [#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.- [#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.- [#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.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)interfaceMergeValuesStepN<R extends Record>This type is used for the H2-specific variant of theMerge's DSL API.interfaceQuantifiedSelect<R extends Record>A quantified select for use in quantified comparison predicates.interfaceRecordHandler<R extends Record>ARecordHandleris a handler that can receiveRecordobjects, when fetching data from the database.interfaceRecordMapper<R extends Record,E>ARecordMapperis a mapper that can receiveRecordobjects, when fetching data from the database, transforming them into a custom type<E>.interfaceRecordType<R extends Record>interfaceRecordUnmapper<E,R extends Record>ARecordUnmapperis a mapper that can receive user objects and convert them back toRecord.interfaceResult<R extends Record>A wrapper for database results returned by.SelectQueryinterfaceResultQuery<R extends Record>A query that can return results.interfaceSelect<R extends Record>ASELECTstatement.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.interfaceTable<R extends Record>A table.interfaceTableField<R extends Record,T>A field contained in a table.interfaceTableLike<R extends Record>An 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.interfaceTruncate<R extends Record>ATRUNCATEstatement.interfaceTruncateCascadeStep<R extends Record>AQuerythat can truncate a table in the database.interfaceTruncateFinalStep<R extends Record>AQuerythat can truncate a table in the database.interfaceTruncateIdentityStep<R extends Record>AQuerythat can truncate a table in the database.interfaceUniqueKey<R extends Record>AUniqueKeyis an object representing aUNIQUE KEYor aPRIMARY KEY.interfaceUpdate<R extends Record>AnUPDATEstatement.interfaceUpdateConditionStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateFinalStep<R extends Record>This type is used for theUpdate's DSL API.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.Subinterfaces of Record in org.jooq Modifier and Type Interface Description interfaceEmbeddableRecord<R extends EmbeddableRecord<R>>A record originating from a single tableinterfaceRecord1<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 tableinterfaceUDTRecord<R extends UDTRecord<R>>An object holding data of a UDTinterfaceUpdatableRecord<R extends UpdatableRecord<R>>A common interface for records that can be stored back to the database again.Methods in org.jooq with type parameters of type Record Modifier and Type Method Description <R extends Record>
@NotNull CommonTableExpression<R>DerivedColumnList. as(Select<R> select)Specify a subselect to refer to by theDerivedColumnListto form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>Name. as(Select<R> select)Specify a subselect to refer to by theNameto form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>DerivedColumnList. asMaterialized(Select<R> select)Specify a materialized subselect to refer to by theDerivedColumnListto form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>Name. asMaterialized(Select<R> select)Specify a materialized subselect to refer to by theNameto form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>DerivedColumnList. asNotMaterialized(Select<R> select)Specify a non-materialized subselect to refer to by theDerivedColumnListto form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>Name. asNotMaterialized(Select<R> select)Specify a non-materialized subselect to refer to by theNameto form a common table expression.<X extends Record>
@NotNull ResultQuery<X>ResultQuery. coerce(Table<X> table)Coerce the result record type of this query to that of a table.<R extends Record>
@NotNull DeleteUsingStep<R>DSLContext. delete(Table<R> table)Create a new DSL delete statement.<R extends Record>
@NotNull DeleteUsingStep<R>WithStep. delete(Table<R> table)Create a new DSL delete statement.<R extends Record>
@NotNull DeleteUsingStep<R>DSLContext. deleteFrom(Table<R> table)Create a new DSL delete statement.<R extends Record>
@NotNull DeleteQuery<R>DSLContext. deleteQuery(Table<R> table)Create a newDeleteQuery<R extends Record>
@NotNull Result<R>DSLContext. fetch(ResultQuery<R> query)Execute aResultQueryin the context of thisDSLContextand return results.<R extends Record>
@NotNull Result<R>DSLContext. fetch(Table<R> table)Execute and return all records for<R extends Record>
@NotNull Result<R>DSLContext. fetch(Table<R> table, Collection<? extends Condition> conditions)Execute and return all records for<R extends Record>
@NotNull Result<R>DSLContext. fetch(Table<R> table, Condition condition)Execute and return all records for<R extends Record>
@NotNull Result<R>DSLContext. fetch(Table<R> table, Condition... conditions)Execute and return all records for<R extends Record>
RDSLContext. fetchAny(Table<R> table)Execute 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>
RDSLContext. fetchAny(Table<R> table, Condition condition)Execute and return zero or one record for<R extends Record>
RDSLContext. fetchAny(Table<R> table, Condition... conditions)Execute 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 for<S extends Record>
@NotNull Map<S,Result<R>>ResultQuery. fetchGroups(Table<S> table)Execute the query and return aMapwith the result grouped by the given table.<E,S extends Record>
@NotNull Map<S,List<E>>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.<E,S extends Record>
@NotNull Map<S,List<E>>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.<S extends Record,T extends Record>
@NotNull Map<S,Result<T>>ResultQuery. fetchGroups(Table<S> keyTable, Table<T> valueTable)Execute the query and return aMapwith the result grouped by the given table.<S extends Record,T extends Record>
@NotNull Map<S,Result<T>>ResultQuery. fetchGroups(Table<S> keyTable, Table<T> valueTable)Execute the query and return aMapwith the result grouped by the given table.<Z extends Record>
@NotNull Result<Z>Cursor. fetchInto(Table<Z> table)Map resulting records onto a custom record.<Z extends Record>
@NotNull Result<Z>ResultQuery. fetchInto(Table<Z> table)Map resulting records onto a custom record.<R extends Record>
@NotNull Cursor<R>DSLContext. fetchLazy(ResultQuery<R> query)Execute aResultQueryin the context of thisDSLContextand return a cursor.<R extends Record>
@NotNull Cursor<R>DSLContext. fetchLazy(Table<R> table)Execute and return all records lazily for<R extends Record>
@NotNull Cursor<R>DSLContext. fetchLazy(Table<R> table, Collection<? extends Condition> conditions)Execute and return all records lazily for<R extends Record>
@NotNull Cursor<R>DSLContext. fetchLazy(Table<R> table, Condition condition)Execute and return all records lazily for<R extends Record>
@NotNull Cursor<R>DSLContext. fetchLazy(Table<R> table, Condition... conditions)Execute and return all records lazily for<R extends Record>
@NotNull ResultsDSLContext. fetchMany(ResultQuery<R> query)Execute aResultQueryin the context of thisDSLContextand return a cursor.<S extends Record>
@NotNull Map<S,R>ResultQuery. fetchMap(Table<S> table)Execute the query and return aMapwith table as a map key and the corresponding record as value.<E,S extends Record>
@NotNull Map<S,E>ResultQuery. fetchMap(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.<E,S extends Record>
@NotNull Map<S,E>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.<S extends Record,T extends Record>
@NotNull Map<S,T>ResultQuery. fetchMap(Table<S> keyTable, Table<T> valueTable)Execute the query and return aMapwith table as a map key and the corresponding record as value.<S extends Record,T extends Record>
@NotNull Map<S,T>ResultQuery. fetchMap(Table<S> keyTable, Table<T> valueTable)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.<Z extends Record>
@NotNull Optional<Z>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>
RDSLContext. fetchOne(Table<R> table)Execute 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>
RDSLContext. fetchOne(Table<R> table, Condition condition)Execute and return zero or one record for<R extends Record>
RDSLContext. fetchOne(Table<R> table, Condition... conditions)Execute and return zero or one record for<Z extends Record>
ZCursor. fetchOneInto(Table<Z> table)Deprecated.- 3.10 - [#6363] - UseCursor.fetchNextInto(Table)instead.<Z extends Record>
ZResultQuery. fetchOneInto(Table<Z> table)Map resulting records onto a custom record.<R extends Record>
@NotNull Optional<R>DSLContext. fetchOptional(ResultQuery<R> query)Execute aResultQueryin the context of thisDSLContextand return a record.<R extends Record>
@NotNull Optional<R>DSLContext. fetchOptional(Table<R> table)Execute and return zero or one record for<R extends Record>
@NotNull Optional<R>DSLContext. fetchOptional(Table<R> table, Collection<? extends Condition> conditions)Execute and return zero or one record for<R extends Record>
@NotNull Optional<R>DSLContext. fetchOptional(Table<R> table, Condition condition)Execute and return zero or one record for<R extends Record>
@NotNull Optional<R>DSLContext. fetchOptional(Table<R> table, Condition... conditions)Execute and return zero or one record for<Z extends Record>
@NotNull Optional<Z>Cursor. fetchOptionalInto(Table<Z> table)Deprecated.- 3.10 - [#6363] - UseCursor.fetchNextOptionalInto(Table)instead.<Z extends Record>
@NotNull Optional<Z>ResultQuery. fetchOptionalInto(Table<Z> table)Map resulting records onto a custom record.<R extends Record>
RDSLContext. fetchSingle(ResultQuery<R> query)Execute aResultQueryin the context of thisDSLContextand return a record.<R extends Record>
RDSLContext. fetchSingle(Table<R> table)Execute and return exactly one record for<R extends Record>
RDSLContext. fetchSingle(Table<R> table, Collection<? extends Condition> conditions)Execute and return exactly one record for<R extends Record>
RDSLContext. fetchSingle(Table<R> table, Condition condition)Execute and return exactly one record for<R extends Record>
RDSLContext. fetchSingle(Table<R> table, Condition... conditions)Execute and return exactly one record for<Z extends Record>
ZResultQuery. fetchSingleInto(Table<Z> table)Map resulting records onto a custom record.<R extends Record>
@NotNull Stream<R>DSLContext. fetchStream(ResultQuery<R> query)Execute aResultQueryin the context of thisDSLContextand return a stream.<R extends Record>
@NotNull Stream<R>DSLContext. fetchStream(Table<R> table)Execute and return all records lazily for<R extends Record>
@NotNull Stream<R>DSLContext. fetchStream(Table<R> table, Collection<? extends Condition> conditions)Execute and return all records lazily for<R extends Record>
@NotNull Stream<R>DSLContext. fetchStream(Table<R> table, Condition condition)Execute and return all records lazily for<R extends Record>
@NotNull Stream<R>DSLContext. fetchStream(Table<R> table, Condition... conditions)Execute and return all records lazily for<Z extends Record>
@NotNull Stream<Z>ResultQuery. 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>
RRecord. into(Table<R> table)Map resulting records onto a custom record type.<Z extends Record>
@NotNull Result<Z>Result. into(Table<Z> table)Map resulting records onto a custom record.<S extends Record>
@NotNull Map<S,Result<R>>Result. intoGroups(Table<S> table)Return aMapwith the result grouped by the given key table.<E,S extends Record>
@NotNull Map<S,List<E>>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.<E,S extends Record>
@NotNull Map<S,List<E>>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.<S extends Record,T extends Record>
@NotNull Map<S,Result<T>>Result. intoGroups(Table<S> keyTable, Table<T> valueTable)Return aMapwith the result grouped by the given key table.<S extends Record,T extends Record>
@NotNull Map<S,Result<T>>Result. intoGroups(Table<S> keyTable, Table<T> valueTable)Return aMapwith the result grouped by the given key table.<S extends Record>
@NotNull Map<S,R>Result. intoMap(Table<S> table)Return aMapwith the given key table as a map key and the corresponding record as value.<E,S extends Record>
@NotNull Map<S,E>Result. intoMap(Table<S> table, Class<? extends E> type)Return aMapwith results grouped by the given key table and mapped into the given entity type.<E,S extends Record>
@NotNull Map<S,E>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.<S extends Record,T extends Record>
@NotNull Map<S,T>Result. intoMap(Table<S> keyTable, Table<T> valueTable)Return aMapwith the given key table as a map key and the corresponding record as value.<S extends Record,T extends Record>
@NotNull Map<S,T>Result. intoMap(Table<S> keyTable, Table<T> valueTable)Return aMapwith the given key table as a map key and the corresponding record as value.<R extends Record>
@NotNull LoaderOptionsStep<R>DSLContext. loadInto(Table<R> table)Create a newLoaderobject to load data from a CSV or XML source.<R extends Record>
@Nullable Table<R>DSLContext. map(Table<R> table)Map a table to another one.<R extends Record>
@Nullable Table<R>SchemaMapping. map(Table<R> table)Deprecated.Apply mapping to a given table<R extends Record>
@NotNull MergeUsingStep<R>DSLContext. mergeInto(Table<R> table)Create a new DSL SQL standard MERGE statement.<R extends Record>
@NotNull MergeKeyStepN<R>DSLContext. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)<R extends Record>
@NotNull MergeKeyStepN<R>DSLContext. mergeInto(Table<R> table, Field<?>... fields)Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)<R extends Record,T1>
@NotNull MergeKeyStep1<R,T1>DSLContext. mergeInto(Table<R> table, Field<T1> field1)Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)<R extends Record,T1,T2>
@NotNull MergeKeyStep2<R,T1,T2>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)Deprecated.- [#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>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)Deprecated.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)<R extends Record>
@NotNull MergeUsingStep<R>WithStep. mergeInto(Table<R> table)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>WithStep. mergeInto(Table<R> table, Field<?>... fields)Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1>
@NotNull MergeKeyStep1<R,T1>WithStep. mergeInto(Table<R> table, Field<T1> field1)Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)<R extends Record,T1,T2>
@NotNull MergeKeyStep2<R,T1,T2>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)Deprecated.- [#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>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)Deprecated.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)<R extends Record>
RDSLContext. newRecord(Table<R> table)Create a newRecordthat can be inserted into the corresponding table.<R extends Record>
RDSLContext. newRecord(Table<R> table, Object source)Create a new pre-filledRecordthat can be inserted into the corresponding table.<R extends Record>
@NotNull Result<R>DSLContext. newResult(Table<R> table)Create a new emptyResult.<R extends Record,E>
@NotNull RecordMapper<R,E>RecordMapperProvider. provide(RecordType<R> recordType, Class<? extends E> type)Provide aRecordMapperinstance.<E,R extends Record>
@NotNull RecordUnmapper<E,R>RecordUnmapperProvider. provide(Class<? extends E> type, RecordType<R> recordType)Provide aRecordUnmapperinstance.<R extends Record>
@NotNull SelectWhereStep<R>DSLContext. selectFrom(Table<R> table)Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
@NotNull SelectWhereStep<R>WithStep. selectFrom(Table<R> table)Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
@NotNull SelectQuery<R>DSLContext. selectQuery(TableLike<R> table)Create a newSelectQuery<R extends Record>
@NotNull TruncateIdentityStep<R>DSLContext. truncate(Table<R> table)Create a new DSL truncate statement.<R extends Record>
@NotNull TruncateIdentityStep<R>DSLContext. truncateTable(Table<R> table)Create a new DSL truncate statement.<R extends Record>
@NotNull UpdateSetFirstStep<R>DSLContext. update(Table<R> table)Create a new DSL update statement.<R extends Record>
@NotNull UpdateSetFirstStep<R>WithStep. update(Table<R> table)Create a new DSL update statement.<R extends Record>
@NotNull UpdateQuery<R>DSLContext. updateQuery(Table<R> table)Create a newUpdateQueryMethods in org.jooq that return Record Modifier and Type Method Description @NotNull Record[]RecordContext. batchRecords()TheRecord(s) that are being manipulated in batch mode.@NotNull R[]ResultQuery. fetchArray()Execute the query and return the generated result as an array of records.@Nullable RecordDSLContext. fetchOne(String sql)Execute a new query holding plain SQL.@Nullable RecordDSLContext. fetchOne(String sql, Object... bindings)Execute a new query holding plain SQL.@Nullable RecordDSLContext. fetchOne(String sql, QueryPart... parts)Execute a new query holding plain SQL.@Nullable RecordDSLContext. fetchOne(ResultSet rs)@Nullable RecordDSLContext. fetchOne(ResultSet rs, Class<?>... types)@Nullable RecordDSLContext. fetchOne(ResultSet rs, DataType<?>... types)@Nullable RecordDSLContext. fetchOne(ResultSet rs, Field<?>... fields)@Nullable RecordDSLContext. fetchOne(SQL sql)Execute 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 RecordRecord. into(Field<?>... fields)Copy this record into a new record holding only a subset of the previous fields.@NotNull RecordUpdatableRecord. key()A Record copy holding values for theTable.getPrimaryKey().@NotNull RecordDSLContext. newRecord(Collection<? extends Field<?>> fields)Create a new emptyRecord.@NotNull RecordDSLContext. newRecord(Field<?>... fields)Create 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 RecordRecord. with(Field<T> field, T value)Set a value into this record.<T,U>
@NotNull RecordRecord. with(Field<T> field, U value, Converter<? extends T,? super U> converter)Set a value into this record.Methods in org.jooq that return types with arguments of type Record Modifier and Type Method Description @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>ResultQuery. coerce(Field<?>... fields)Coerce the result record type of this query to that of a set of fields.@NotNull CreateViewAsStep<Record>DSLContext. createOrReplaceView(String view, String... fields)Create a new DSLCREATE OR REPLACE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext. createOrReplaceView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)Deprecated.- 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.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext. createOrReplaceView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)Deprecated.- 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.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext. createOrReplaceView(Name view, Name... fields)Create a new DSLCREATE OR REPLACE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext. createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)Deprecated.- 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.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext. createOrReplaceView(Table<?> view, Field<?>... fields)Create a new DSLCREATE OR REPLACE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext. createView(String view, String... fields)Create a new DSLCREATE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext. createView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)Deprecated.- 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.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext. createView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)Deprecated.- 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.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext. createView(Name view, Name... fields)Create a new DSLCREATE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext. createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)Deprecated.- 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.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext. createView(Table<?> view, Field<?>... fields)Create a new DSLCREATE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext. createViewIfNotExists(String view, String... fields)Create a new DSLCREATE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext. createViewIfNotExists(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)Deprecated.- 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.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext. createViewIfNotExists(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)Deprecated.- 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.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext. createViewIfNotExists(Name view, Name... fields)Create a new DSLCREATE VIEWstatement.@NotNull CreateViewAsStep<Record>DSLContext. createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)Deprecated.- 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.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>DSLContext. createViewIfNotExists(Table<?> view, Field<?>... fields)Create a new DSLCREATE VIEWstatement.@NotNull Table<Record>Table. crossApply(String sql)CROSS APPLYa table to this table.@NotNull Table<Record>Table. crossApply(String sql, Object... bindings)CROSS APPLYa table to this table.@NotNull Table<Record>Table. crossApply(String sql, QueryPart... parts)CROSS APPLYa table to this table.@NotNull Table<Record>Table. crossApply(Name name)CROSS APPLYa table to this table.@NotNull Table<Record>Table. crossApply(SQL sql)CROSS APPLYa table to this table.@NotNull Table<Record>Table. crossApply(TableLike<?> table)CROSS APPLYa table to this table.@NotNull Table<Record>Table. crossJoin(String sql)CROSS JOINa table to this table.@NotNull Table<Record>Table. crossJoin(String sql, Object... bindings)CROSS JOINa table to this table.@NotNull Table<Record>Table. crossJoin(String sql, QueryPart... parts)CROSS JOINa table to this table.@NotNull Table<Record>Table. crossJoin(Name name)CROSS JOINa table to this table.@NotNull Table<Record>Table. crossJoin(SQL sql)CROSS JOINa table to this table.@NotNull Table<Record>Table. crossJoin(TableLike<?> table)CROSS JOINa table to this table.@NotNull Result<Record>DSLContext. fetch(String sql)Execute a new query holding plain SQL.@NotNull Result<Record>DSLContext. fetch(String sql, Object... bindings)Execute a new query holding plain SQL.@NotNull Result<Record>DSLContext. fetch(String sql, QueryPart... parts)Execute a new query holding plain SQL.@NotNull Result<Record>DSLContext. fetch(ResultSet rs)@NotNull Result<Record>DSLContext. fetch(ResultSet rs, Class<?>... types)@NotNull Result<Record>DSLContext. fetch(ResultSet rs, DataType<?>... types)@NotNull Result<Record>DSLContext. fetch(ResultSet rs, Field<?>... fields)@NotNull Result<Record>DSLContext. fetch(SQL 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.@NotNull Result<Record>DSLContext. fetchFromCSV(String string)Fetch all data from a CSV string.@NotNull Result<Record>DSLContext. fetchFromCSV(String string, boolean header)Fetch all data from a CSV string.@NotNull Result<Record>DSLContext. fetchFromCSV(String string, boolean header, char delimiter)Fetch all data from a CSV string.@NotNull Result<Record>DSLContext. fetchFromCSV(String string, char delimiter)Fetch all data from a CSV string.@NotNull Result<Record>DSLContext. fetchFromHTML(String string)Convert an HTML table into a jOOQResult.@NotNull Result<Record>DSLContext. fetchFromJSON(String string)Fetch all data from a JSON string.@NotNull Result<Record>DSLContext. fetchFromStringData(String[]... data)Fetch all data from a list of strings.@NotNull Result<Record>DSLContext. fetchFromStringData(List<String[]> data)Fetch all data from a list of strings.@NotNull Result<Record>DSLContext. fetchFromStringData(List<String[]> data, boolean header)Fetch all data from a list of strings.@NotNull Result<Record>DSLContext. fetchFromTXT(String string)Fetch all data from a formatted string.@NotNull Result<Record>DSLContext. fetchFromTXT(String string, String nullLiteral)Fetch all data from a formatted string.@NotNull Result<Record>DSLContext. fetchFromXML(String string)Fetch all data from an XML string.@NotNull Map<Record,Result<R>>ResultQuery. fetchGroups(int[] keyFieldIndexes)Execute the query and return aMapwith the result grouped by the given keys.@NotNull Map<Record,Result<Record>>ResultQuery. fetchGroups(int[] keyFieldIndexes, int[] valueFieldIndexes)Execute the query and return aMapwith the result grouped by the given keys.@NotNull Map<Record,Result<Record>>ResultQuery. fetchGroups(int[] keyFieldIndexes, int[] valueFieldIndexes)Execute the query and return aMapwith the result grouped by the given keys.<E> @NotNull Map<Record,List<E>>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.<E> @NotNull Map<Record,List<E>>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.@NotNull Map<Record,Result<R>>ResultQuery. fetchGroups(String[] keyFieldNames)Execute the query and return aMapwith the result grouped by the given keys.<E> @NotNull Map<Record,List<E>>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.@NotNull Map<Record,Result<Record>>ResultQuery. fetchGroups(String[] keyFieldNames, String[] valueFieldNames)Execute the query and return aMapwith the result grouped by the given keys.@NotNull Map<Record,Result<Record>>ResultQuery. fetchGroups(String[] keyFieldNames, String[] valueFieldNames)Execute the query and return aMapwith the result grouped by the given keys.<E> @NotNull Map<Record,List<E>>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.@NotNull Map<Record,Result<R>>ResultQuery. fetchGroups(Field<?>[] keys)Execute the query and return aMapwith the result grouped by the given keys.<E> @NotNull Map<Record,List<E>>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.@NotNull Map<Record,Result<Record>>ResultQuery. fetchGroups(Field<?>[] keys, Field<?>[] values)Execute the query and return aMapwith the result grouped by the given keys.@NotNull Map<Record,Result<Record>>ResultQuery. fetchGroups(Field<?>[] keys, Field<?>[] values)Execute the query and return aMapwith the result grouped by the given keys.<E> @NotNull Map<Record,List<E>>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.@NotNull Map<Record,Result<R>>ResultQuery. fetchGroups(Name[] keyFieldNames)Execute the query and return aMapwith the result grouped by the given keys.<E> @NotNull Map<Record,List<E>>ResultQuery. fetchGroups(Name[] keyFieldNames, Class<? extends E> type)Execute the query and return aMapwith results grouped by the given keys and mapped into the given entity type.@NotNull Map<Record,Result<Record>>ResultQuery. fetchGroups(Name[] keyFieldNames, Name[] valueFieldNames)Execute the query and return aMapwith the result grouped by the given keys.@NotNull Map<Record,Result<Record>>ResultQuery. fetchGroups(Name[] keyFieldNames, Name[] valueFieldNames)Execute the query and return aMapwith the result grouped by the given keys.<E> @NotNull Map<Record,List<E>>ResultQuery. fetchGroups(Name[] keyFieldNames, RecordMapper<? super R,E> mapper)Execute the query and return aMapwith results grouped by the given keys and mapped by the given mapper.@NotNull Cursor<Record>DSLContext. fetchLazy(String sql)Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull Cursor<Record>DSLContext. fetchLazy(String sql, Object... bindings)Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull Cursor<Record>DSLContext. fetchLazy(String sql, QueryPart... parts)Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull Cursor<Record>DSLContext. fetchLazy(ResultSet rs)@NotNull Cursor<Record>DSLContext. fetchLazy(ResultSet rs, Class<?>... types)@NotNull Cursor<Record>DSLContext. fetchLazy(ResultSet rs, DataType<?>... types)@NotNull Cursor<Record>DSLContext. fetchLazy(ResultSet rs, Field<?>... fields)@NotNull Cursor<Record>DSLContext. fetchLazy(SQL sql)Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull Map<Record,R>ResultQuery. fetchMap(int[] keyFieldIndexes)Execute the query and return aMapwith keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>ResultQuery. fetchMap(int[] keyFieldIndexes, int[] valueFieldIndexes)Execute the query and return aMapwith keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>ResultQuery. fetchMap(int[] keyFieldIndexes, int[] valueFieldIndexes)Execute the query and return aMapwith keys as a map key and the corresponding record as value.@NotNull Map<Record,R>ResultQuery. fetchMap(String[] keyFieldNames)Execute the query and return aMapwith keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>ResultQuery. fetchMap(String[] keyFieldNames, String[] valueFieldNames)Execute the query and return aMapwith keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>ResultQuery. fetchMap(String[] keyFieldNames, String[] valueFieldNames)Execute the query and return aMapwith keys as a map key and the corresponding record as value.@NotNull Map<Record,R>ResultQuery. fetchMap(Field<?>[] keys)Execute the query and return aMapwith keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>ResultQuery. fetchMap(Field<?>[] keys, Field<?>[] values)Execute the query and return aMapwith keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>ResultQuery. fetchMap(Field<?>[] keys, Field<?>[] values)Execute the query and return aMapwith keys as a map key and the corresponding record as value.@NotNull Map<Record,R>ResultQuery. fetchMap(Name[] keyFieldNames)Execute the query and return aMapwith keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>ResultQuery. fetchMap(Name[] keyFieldNames, Name[] valueFieldNames)Execute the query and return aMapwith keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>ResultQuery. fetchMap(Name[] keyFieldNames, Name[] valueFieldNames)Execute the query and return aMapwith keys as a map key and the corresponding record as value.@NotNull Optional<Record>DSLContext. fetchOptional(String sql)Execute a new query holding plain SQL.@NotNull Optional<Record>DSLContext. fetchOptional(String sql, Object... bindings)Execute a new query holding plain SQL.@NotNull Optional<Record>DSLContext. fetchOptional(String sql, QueryPart... parts)Execute a new query holding plain SQL.@NotNull Optional<Record>DSLContext. fetchOptional(ResultSet rs)@NotNull Optional<Record>DSLContext. fetchOptional(ResultSet rs, Class<?>... types)@NotNull Optional<Record>DSLContext. fetchOptional(ResultSet rs, DataType<?>... types)@NotNull Optional<Record>DSLContext. fetchOptional(ResultSet rs, Field<?>... fields)@NotNull Optional<Record>DSLContext. fetchOptional(SQL sql)Execute a new query holding plain SQL.@NotNull Stream<Record>DSLContext. fetchStream(String sql)Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull Stream<Record>DSLContext. fetchStream(String sql, Object... bindings)Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull Stream<Record>DSLContext. fetchStream(String sql, QueryPart... parts)Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull Stream<Record>DSLContext. fetchStream(ResultSet rs)@NotNull Stream<Record>DSLContext. fetchStream(ResultSet rs, Class<?>... types)@NotNull Stream<Record>DSLContext. fetchStream(ResultSet rs, DataType<?>... types)@NotNull Stream<Record>DSLContext. fetchStream(ResultSet rs, Field<?>... fields)@NotNull Stream<Record>DSLContext. fetchStream(SQL sql)Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull TableOnStep<Record>Table. fullJoin(String sql)FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table. fullJoin(String sql, Object... bindings)FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table. fullJoin(String sql, QueryPart... parts)FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table. fullJoin(Name name)FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table. fullJoin(SQL sql)FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table. fullJoin(TableLike<?> table)FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table. fullOuterJoin(String sql)FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table. fullOuterJoin(String sql, Object... bindings)FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table. fullOuterJoin(String sql, QueryPart... parts)FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table. fullOuterJoin(Name name)FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table. fullOuterJoin(SQL sql)FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table. fullOuterJoin(TableLike<?> table)FULL OUTER JOINa table to this table.@NotNull Table<Record>PivotInStep. in(Collection<? extends Field<T>> fields)Specify the acceptable values for pivoting@NotNull Table<Record>PivotInStep. in(Field<?>... fields)Specify the acceptable values for pivoting@NotNull Table<Record>PivotInStep. in(T... values)Specify the acceptable values for pivoting@NotNull TableOnStep<Record>Table. innerJoin(String sql)INNER JOINa table to this table.@NotNull TableOnStep<Record>Table. innerJoin(String sql, Object... bindings)INNER JOINa table to this table.@NotNull TableOnStep<Record>Table. innerJoin(String sql, QueryPart... parts)INNER JOINa table to this table.@NotNull TableOnStep<Record>Table. innerJoin(Name name)INNER JOINa table to this table.@NotNull TableOnStep<Record>Table. innerJoin(SQL sql)INNER JOINa table to this table.@NotNull TableOnStep<Record>Table. innerJoin(TableLike<?> table)INNER JOINa table to this table.@NotNull Result<Record>Result. into(Field<?>... fields)Copy all records from this result into a new result with new records holding only a subset of the previous fields.@NotNull SelectFromStep<Record>SelectIntoStep. into(Table<?> table)Add anINTOclause to theSELECTstatement.@NotNull Map<Record,Result<R>>Result. intoGroups(int[] keyFieldIndexes)Return aMapwith the result grouped by the given keys.@NotNull Map<Record,Result<Record>>Result. intoGroups(int[] keyFieldIndexes, int[] valueFieldIndexes)Return aMapwith the result grouped by the given keys.@NotNull Map<Record,Result<Record>>Result. intoGroups(int[] keyFieldIndexes, int[] valueFieldIndexes)Return aMapwith the result grouped by the given keys.<E> @NotNull Map<Record,List<E>>Result. intoGroups(int[] keyFieldIndexes, Class<? extends E> type)Return aMapwith results grouped by the given keys and mapped into the given entity type.<E> @NotNull Map<Record,List<E>>Result. intoGroups(int[] keyFieldIndexes, RecordMapper<? super R,E> mapper)Return aMapwith results grouped by the given keys and mapped into the given entity type.@NotNull Map<Record,Result<R>>Result. intoGroups(String[] keyFieldNames)Return aMapwith the result grouped by the given keys.<E> @NotNull Map<Record,List<E>>Result. intoGroups(String[] keyFieldNames, Class<? extends E> type)Return aMapwith results grouped by the given keys and mapped into the given entity type.@NotNull Map<Record,Result<Record>>Result. intoGroups(String[] keyFieldNames, String[] valueFieldNames)Return aMapwith the result grouped by the given keys.@NotNull Map<Record,Result<Record>>Result. intoGroups(String[] keyFieldNames, String[] valueFieldNames)Return aMapwith the result grouped by the given keys.<E> @NotNull Map<Record,List<E>>Result. intoGroups(String[] keyFieldNames, RecordMapper<? super R,E> mapper)Return aMapwith results grouped by the given keys and mapped into the given entity type.@NotNull Map<Record,Result<R>>Result. intoGroups(Field<?>[] keys)Return aMapwith the result grouped by the given keys.<E> @NotNull Map<Record,List<E>>Result. intoGroups(Field<?>[] keys, Class<? extends E> type)Return aMapwith results grouped by the given keys and mapped into the given entity type.@NotNull Map<Record,Result<Record>>Result. intoGroups(Field<?>[] keys, Field<?>[] values)Return aMapwith the result grouped by the given keys.@NotNull Map<Record,Result<Record>>Result. intoGroups(Field<?>[] keys, Field<?>[] values)Return aMapwith the result grouped by the given keys.<E> @NotNull Map<Record,List<E>>Result. intoGroups(Field<?>[] keys, RecordMapper<? super R,E> mapper)Return aMapwith results grouped by the given keys and mapped into the given entity type.@NotNull Map<Record,Result<R>>Result. intoGroups(Name[] keyFieldNames)Return aMapwith the result grouped by the given keys.<E> @NotNull Map<Record,List<E>>Result. intoGroups(Name[] keyFieldNames, Class<? extends E> type)Return aMapwith results grouped by the given keys and mapped into the given entity type.@NotNull Map<Record,Result<Record>>Result. intoGroups(Name[] keyFieldNames, Name[] valueFieldNames)Return aMapwith the result grouped by the given keys.@NotNull Map<Record,Result<Record>>Result. intoGroups(Name[] keyFieldNames, Name[] valueFieldNames)Return aMapwith the result grouped by the given keys.<E> @NotNull Map<Record,List<E>>Result. intoGroups(Name[] keyFieldNames, RecordMapper<? super R,E> mapper)Return aMapwith results grouped by the given keys and mapped into the given entity type.@NotNull Map<Record,R>Result. intoMap(int[] keyFieldIndexes)Return aMapwith the given keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>Result. intoMap(int[] keyFieldIndexes, int[] valueFieldIndexes)Return aMapwith the given keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>Result. intoMap(int[] keyFieldIndexes, int[] valueFieldIndexes)Return aMapwith the given keys as a map key and the corresponding record as value.@NotNull Map<Record,R>Result. intoMap(String[] keyFieldNames)Return aMapwith the given keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>Result. intoMap(String[] keyFieldNames, String[] valueFieldNames)Return aMapwith the given keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>Result. intoMap(String[] keyFieldNames, String[] valueFieldNames)Return aMapwith the given keys as a map key and the corresponding record as value.@NotNull Map<Record,R>Result. intoMap(Field<?>[] keys)Return aMapwith the given keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>Result. intoMap(Field<?>[] keys, Field<?>[] values)Return aMapwith the given keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>Result. intoMap(Field<?>[] keys, Field<?>[] values)Return aMapwith the given keys as a map key and the corresponding record as value.@NotNull Map<Record,R>Result. intoMap(Name[] keyFieldNames)Return aMapwith the given keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>Result. intoMap(Name[] keyFieldNames, Name[] valueFieldNames)Return aMapwith the given keys as a map key and the corresponding record as value.@NotNull Map<Record,Record>Result. intoMap(Name[] keyFieldNames, Name[] valueFieldNames)Return aMapwith the given keys as a map key and the corresponding record as value.@NotNull TableOnStep<Record>Table. join(String sql)INNER JOINa table to this table.@NotNull TableOnStep<Record>Table. join(String sql, Object... bindings)INNER JOINa table to this table.@NotNull TableOnStep<Record>Table. join(String sql, QueryPart... parts)INNER JOINa table to this table.@NotNull TableOnStep<Record>Table. join(Name name)INNER JOINa table to this table.@NotNull TableOnStep<Record>Table. join(SQL sql)INNER JOINa table to this table.@NotNull TableOnStep<Record>Table. join(TableLike<?> table)INNER JOINa table to this table.@NotNull TableOptionalOnStep<Record>Table. join(TableLike<?> table, JoinType type)Join a table to this table using aJoinType@NotNull TableOnStep<Record>TableOuterJoinStep. join(TableLike<?> table, JoinType type)Join a table to this table using aJoinType.@NotNull TablePartitionByStep<Record>Table. leftJoin(String sql)LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. leftJoin(String sql, Object... bindings)LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. leftJoin(String sql, QueryPart... parts)LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. leftJoin(Name name)LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. leftJoin(SQL sql)LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. leftJoin(TableLike<?> table)LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. leftJoin(String sql)LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. leftJoin(String sql, Object... bindings)LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. leftJoin(String sql, QueryPart... parts)LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. leftJoin(Name name)LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. leftJoin(SQL sql)LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. leftJoin(TableLike<?> table)LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. leftOuterJoin(String sql)LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. leftOuterJoin(String sql, Object... bindings)LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. leftOuterJoin(String sql, QueryPart... parts)LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. leftOuterJoin(Name name)LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. leftOuterJoin(SQL sql)LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. leftOuterJoin(TableLike<?> table)LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. leftOuterJoin(String sql)LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. leftOuterJoin(String sql, Object... bindings)LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. leftOuterJoin(String sql, QueryPart... parts)LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. leftOuterJoin(Name name)LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. leftOuterJoin(SQL sql)LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. leftOuterJoin(TableLike<?> table)LEFT OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalFullOuterJoin(String sql)NATURAL FULL OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalFullOuterJoin(String sql, Object... bindings)NATURAL FULL OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalFullOuterJoin(String sql, QueryPart... parts)NATURAL FULL OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalFullOuterJoin(Name name)NATURAL FULL OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalFullOuterJoin(SQL sql)NATURAL FULL OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalFullOuterJoin(TableLike<?> table)NATURAL FULL OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalJoin(String sql)NATURAL JOINa table to this table.@NotNull Table<Record>Table. naturalJoin(String sql, Object... bindings)NATURAL JOINa table to this table.@NotNull Table<Record>Table. naturalJoin(String sql, QueryPart... parts)NATURAL JOINa table to this table.@NotNull Table<Record>Table. naturalJoin(Name name)NATURAL JOINa table to this table.@NotNull Table<Record>Table. naturalJoin(SQL sql)NATURAL JOINa table to this table.@NotNull Table<Record>Table. naturalJoin(TableLike<?> table)NATURAL JOINa table to this table.@NotNull Table<Record>Table. naturalLeftOuterJoin(String sql)NATURAL LEFT OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalLeftOuterJoin(String sql, Object... bindings)NATURAL LEFT OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalLeftOuterJoin(String sql, QueryPart... parts)NATURAL LEFT OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalLeftOuterJoin(Name name)NATURAL LEFT OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalLeftOuterJoin(SQL sql)NATURAL LEFT OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalLeftOuterJoin(TableLike<?> table)NATURAL LEFT OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalRightOuterJoin(String sql)NATURAL RIGHT OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalRightOuterJoin(String sql, Object... bindings)NATURAL RIGHT OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalRightOuterJoin(String sql, QueryPart... parts)NATURAL RIGHT OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalRightOuterJoin(Name name)NATURAL RIGHT OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalRightOuterJoin(SQL sql)NATURAL RIGHT OUTER JOINa table to this table.@NotNull Table<Record>Table. naturalRightOuterJoin(TableLike<?> table)NATURAL RIGHT OUTER JOINa table to this table.@NotNull Result<Record>DSLContext. newResult(Collection<? extends Field<?>> fields)Create a new emptyRecord.@NotNull Result<Record>DSLContext. newResult(Field<?>... fields)Create a new emptyRecord.@NotNull Table<Record>Table. outerApply(String sql)OUTER APPLYa table to this table.@NotNull Table<Record>Table. outerApply(String sql, Object... bindings)OUTER APPLYa table to this table.@NotNull Table<Record>Table. outerApply(String sql, QueryPart... parts)OUTER APPLYa table to this table.@NotNull Table<Record>Table. outerApply(Name name)OUTER APPLYa table to this table.@NotNull Table<Record>Table. outerApply(SQL sql)OUTER APPLYa table to this table.@NotNull Table<Record>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 JOINkeywordsResult<Record>ResultOrRows. 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.@NotNull Table<Record>DivideByReturningStep. returning(Collection<? extends Field<?>> fields)Specify the fields that you want the division to return from the dividend@NotNull Table<Record>DivideByReturningStep. returning(Field<?>... fields)Specify the fields that you want the division to return from the dividend@NotNull DeleteResultStep<Record>DeleteReturningStep. returningResult(Collection<? extends SelectFieldOrAsterisk> fields)Configure theDELETEstatement to return a list of fields inR.@NotNull DeleteResultStep<Record>DeleteReturningStep. returningResult(SelectFieldOrAsterisk... fields)Configure theDELETEstatement to return a list of fields inR.@NotNull InsertResultStep<Record>InsertReturningStep. returningResult(Collection<? extends SelectFieldOrAsterisk> fields)Configure theINSERTstatement to return a list of fields inR.@NotNull InsertResultStep<Record>InsertReturningStep. returningResult(SelectFieldOrAsterisk... fields)Configure theINSERTstatement to return a list of fields inR.@NotNull UpdateResultStep<Record>UpdateReturningStep. returningResult(Collection<? extends SelectFieldOrAsterisk> fields)Configure theUPDATEstatement to return a list of fields inR.@NotNull UpdateResultStep<Record>UpdateReturningStep. returningResult(SelectFieldOrAsterisk... fields)Configure theUPDATEstatement to return a list of fields inR.@NotNull TablePartitionByStep<Record>Table. rightJoin(String sql)RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. rightJoin(String sql, Object... bindings)RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. rightJoin(String sql, QueryPart... parts)RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. rightJoin(Name name)RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. rightJoin(SQL sql)RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. rightJoin(TableLike<?> table)RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. rightJoin(String sql)RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. rightJoin(String sql, Object... bindings)RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. rightJoin(String sql, QueryPart... parts)RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. rightJoin(Name name)RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. rightJoin(SQL sql)RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. rightJoin(TableLike<?> table)RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. rightOuterJoin(String sql)RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. rightOuterJoin(String sql, Object... bindings)RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. rightOuterJoin(String sql, QueryPart... parts)RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. rightOuterJoin(Name name)RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. rightOuterJoin(SQL sql)RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table. rightOuterJoin(TableLike<?> table)RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. rightOuterJoin(String sql)RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. rightOuterJoin(String sql, Object... bindings)RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. rightOuterJoin(String sql, QueryPart... parts)RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. rightOuterJoin(Name name)RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. rightOuterJoin(SQL sql)RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep. rightOuterJoin(TableLike<?> table)RIGHT OUTER JOINa table to this table.@NotNull SelectSelectStep<Record>DSLContext. select(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL select statement.@NotNull SelectSelectStep<Record>DSLContext. select(SelectFieldOrAsterisk... fields)Create a new DSL select statement.@NotNull SelectSelectStep<Record>SelectSelectStep. select(Collection<? extends SelectFieldOrAsterisk> fields)Add additional fields to theSELECTclause of this query@NotNull SelectSelectStep<Record>SelectSelectStep. select(SelectFieldOrAsterisk... fields)Add additional fields to theSELECTclause of this query@NotNull SelectSelectStep<Record>WithStep. select(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL select statement.@NotNull SelectSelectStep<Record>WithStep. select(SelectFieldOrAsterisk... fields)Create a new DSL select statement.@NotNull SelectSelectStep<Record>DSLContext. selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL select statement.@NotNull SelectSelectStep<Record>DSLContext. selectDistinct(SelectFieldOrAsterisk... fields)Create a new DSL select statement.@NotNull SelectSelectStep<Record>WithStep. selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL select statement.@NotNull SelectSelectStep<Record>WithStep. selectDistinct(SelectFieldOrAsterisk... fields)Create a new DSL select statement.@NotNull SelectWhereStep<Record>DSLContext. selectFrom(String sql)Create a new DSL select statement, projecting*.@NotNull SelectWhereStep<Record>DSLContext. selectFrom(String sql, Object... bindings)Create a new DSL select statement, projecting*.@NotNull SelectWhereStep<Record>DSLContext. selectFrom(String sql, QueryPart... parts)Create a new DSL select statement, projecting*.@NotNull SelectWhereStep<Record>DSLContext. selectFrom(Name table)Create a new DSL select statement, projecting*.@NotNull SelectWhereStep<Record>DSLContext. selectFrom(SQL sql)Create a new DSL select statement, projecting*.@NotNull SelectWhereStep<Record>WithStep. selectFrom(String sql)Create a new DSL select statement, projecting*.@NotNull SelectWhereStep<Record>WithStep. selectFrom(String sql, Object... bindings)Create a new DSL select statement, projecting*.@NotNull SelectWhereStep<Record>WithStep. selectFrom(String sql, QueryPart... parts)Create a new DSL select statement, projecting*.@NotNull SelectWhereStep<Record>WithStep. selectFrom(Name table)Create a new DSL select statement, projecting*.@NotNull SelectWhereStep<Record>WithStep. selectFrom(SQL sql)Create a new DSL select statement, projecting*.@NotNull SelectQuery<Record>DSLContext. selectQuery()Create a newSelectQuery@NotNull TableOnStep<Record>Table. straightJoin(String sql)STRAIGHT_JOINa table to this table.@NotNull TableOnStep<Record>Table. straightJoin(String sql, Object... bindings)STRAIGHT_JOINa table to this table.@NotNull TableOnStep<Record>Table. straightJoin(String sql, QueryPart... parts)STRAIGHT_JOINa table to this table.@NotNull TableOnStep<Record>Table. straightJoin(Name name)STRAIGHT_JOINa table to this table.@NotNull TableOnStep<Record>Table. straightJoin(SQL sql)STRAIGHT_JOINa table to this table.@NotNull TableOnStep<Record>Table. straightJoin(TableLike<?> table)STRAIGHT_JOINa table to this table.@NotNull TruncateIdentityStep<Record>DSLContext. truncate(String table)Create a new DSL truncate statement.@NotNull TruncateIdentityStep<Record>DSLContext. truncate(Name table)Create a new DSL truncate statement.@NotNull TruncateIdentityStep<Record>DSLContext. truncateTable(String table)Create a new DSL truncate statement.@NotNull TruncateIdentityStep<Record>DSLContext. truncateTable(Name table)Create a new DSL truncate statement.@NotNull Table<Record>TableOnStep. using(Collection<? extends Field<?>> fields)Join a table with theUSING(column [, column...])syntax.@NotNull Table<Record>TableOnStep. using(Field<?>... fields)Join a table with theUSING(column [, column...])syntax.Methods in org.jooq with parameters of type Record Modifier and Type Method Description @NotNull ConditionBetweenAndStepN. and(Record maxValue)Create a condition to check this field against some bounds@NotNull BetweenAndStepNRowN. between(Record minValue)Check if this row value expression is within a range of two records.@NotNull ConditionRowN. between(Record minValue, Record maxValue)Check 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.booleanField. changed(Record record)The inverse operation ofchanged(Field).@NotNull Table<R>ForeignKey. children(O... records)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.intRecord. compareTo(Record record)Compares thisRecordwith anotherRecordaccording to their natural ordering.@NotNull ConditionRowN. eq(Record record)Compare this row value expression with a record for equality.@NotNull ConditionRowN. equal(Record record)Compare this row value expression with a record for equality.@NotNull Result<R>ForeignKey. fetchChildren(O... records)Fetch child records of a given set of records through this foreign key@NotNull Result<O>ForeignKey. fetchParents(R... records)Fetch parent records of a given set of record through this foreign key@Nullable Field<T>Field. field(Record record)The inverse operation offield(Field).@Nullable Record1<T>Field. from(Record record)The inverse operation ofinto(Field).RTable. from(Record record)The inverse operation ofinto(Table).@NotNull ConditionRowN. ge(Record record)Compare this row value expression with a record for order.TField. get(Record record)The inverse operation ofget(Field).TField. getValue(Record record)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 ConditionRowN. gt(Record record)Compare this row value expression with a record for order.@NotNull ConditionRowN. in(Record... record)Compare this row value expression with a set of records for equality.@NotNull ConditionSelectCorrelatedSubqueryStep. in(R... records)Compare 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 ConditionRowN. le(Record record)Compare 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 ConditionRowN. lessThan(Record record)Compare this row value expression with a record for order.@NotNull LoaderRowsStep<R>LoaderSourceStep. loadRecords(Record... records)Load in-memory data.@NotNull ConditionRowN. lt(Record record)Compare this row value expression with a record for order.@NotNull ConditionRowN. ne(Record record)Compare 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 ConditionRowN. notEqual(Record record)Compare this row value expression with a record for non-equality@NotNull ConditionRowN. notIn(Record... record)Compare this row value expression with a set of records for non-equality.@NotNull ConditionSelectCorrelatedSubqueryStep. notIn(R... records)Compare this subquery with a set of records for non-equality.TField. original(Record record)The inverse operation oforiginal(Field).@NotNull Table<O>ForeignKey. parents(R... records)Get a table expression representing the parents of a record, given this foreign key.voidExecuteContext. record(Record record)Calling this has no effect.voidField. reset(Record record)The inverse operation ofreset(Field).@NotNull InsertOnDuplicateSetMoreStep<R>InsertOnDuplicateSetStep. set(Record record)Set multiple values forUPDATEin theINSERTstatement'sON DUPLICATE KEY UPDATEorON CONFLICT ...@NotNull InsertSetMoreStep<R>InsertSetMoreStep. set(Record record)Set values in theINSERTstatement.@NotNull InsertSetMoreStep<R>InsertSetStep. set(Record record)Set values in theINSERTstatement.@NotNull MergeMatchedSetMoreStep<R>MergeMatchedSetStep. set(Record record)Set multiple values forUPDATEin theMERGEstatement'sWHEN MATCHEDclause.@NotNull MergeNotMatchedSetMoreStep<R>MergeNotMatchedSetStep. set(Record record)Set multiple values forINSERTin theMERGEstatement'sWHEN NOT MATCHEDclause.@NotNull UpdateSetMoreStep<R>UpdateSetStep. set(Record record)Set a value for a field in theUPDATEstatement.Method parameters in org.jooq with type arguments of type Record Modifier and Type Method Description @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 ConditionRowN. eq(Select<? extends Record> select)Compare 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 ConditionRowN. equal(Select<? extends Record> select)Compare 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 ConditionRowN. ge(Select<? extends Record> select)Compare 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 ConditionRowN. gt(Select<? extends Record> select)Compare this row value expression with a subselect for order.@NotNull ConditionRowN. in(Result<? extends Record> result)Compare this row value expression with a set of records for equality.@NotNull ConditionRowN. in(Select<? extends Record> select)Compare 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 ConditionRowN. le(Select<? extends Record> select)Compare 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 ConditionRowN. lessThan(Select<? extends Record> select)Compare this row value expression with a subselect for order.@NotNull LoaderRowsStep<R>LoaderSourceStep. loadRecords(Iterable<? extends Record> records)Load in-memory data.@NotNull LoaderRowsStep<R>LoaderSourceStep. loadRecords(Iterator<? extends Record> records)Load in-memory data.@NotNull LoaderRowsStep<R>LoaderSourceStep. loadRecords(Stream<? extends Record> records)Load in-memory data.@NotNull ConditionRowN. lt(QuantifiedSelect<? extends Record> select)Compare this row value expression with a subselect for order.@NotNull ConditionRowN. lt(Select<? extends Record> select)Compare 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 ConditionRowN. ne(Select<? extends Record> select)Compare 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 ConditionRowN. notEqual(Select<? extends Record> select)Compare this row value expression with a subselect for non-equality.@NotNull ConditionRowN. notIn(Result<? extends Record> result)Compare this row value expression with a set of records for equality.@NotNull ConditionRowN. notIn(Select<? extends Record> select)Compare this row value expression with a subselect for non-equality. -
Uses of Record in org.jooq.impl
Classes in org.jooq.impl with type parameters of type Record Modifier and Type Class Description 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.classTableImpl<R extends Record>A common base type for tablesClasses in org.jooq.impl that implement Record Modifier and Type Class Description classCustomRecord<R extends TableRecord<R>>A base class for customTableRecordimplementations in client code.classEmbeddableRecordImpl<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 Record Modifier and Type Field Description static DataType<Record>SQLDataType. RECORDTheTypes.STRUCTtype.static DataType<Result<Record>>SQLDataType. RESULTTheResultSettype.Methods in org.jooq.impl with type parameters of type Record Modifier and Type Method Description static <R extends Record>
@NotNull QuantifiedSelect<R>DSL. all(Select<R> select)Create anALLquantified select to be used in quantified comparison predicate expressions.static <R extends Record>
@NotNull QuantifiedSelect<R>DSL. any(Select<R> select)Create anANYquantified select to be used in quantified comparison predicate expressions.static <R extends Record>
@NotNull Check<R>Internal. createCheck(Table<R> table, Name name, String condition)Factory method for check constraints.static <R extends Record>
@NotNull Check<R>Internal. createCheck(Table<R> table, Name name, String condition, boolean enforced)Factory method for check constraints.static <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 <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 <R extends Record,U extends Record>
@NotNull ForeignKey<R,U>Internal. createForeignKey(Table<R> table, Name name, TableField<R,?>[] fkFields, UniqueKey<U> uk, TableField<U,?>[] ukFields, boolean enforced)Factory method for foreign keys.static <R extends Record,U extends Record>
@NotNull ForeignKey<R,U>Internal. createForeignKey(Table<R> table, Name name, TableField<R,?>[] fkFields, UniqueKey<U> uk, TableField<U,?>[] ukFields, boolean enforced)Factory method for foreign keys.static <R extends Record,U extends Record,ER extends EmbeddableRecord<ER>>
@NotNull ForeignKey<R,U>Internal. createForeignKey(Table<R> table, Name name, TableField<R,ER> fkEmbeddableField, UniqueKey<U> uk, TableField<U,ER> ukEmbeddableField, boolean enforced)Factory method for foreign keys.static <R extends Record,U extends Record,ER extends EmbeddableRecord<ER>>
@NotNull ForeignKey<R,U>Internal. createForeignKey(Table<R> table, Name name, TableField<R,ER> fkEmbeddableField, UniqueKey<U> uk, TableField<U,ER> ukEmbeddableField, boolean enforced)Factory method for foreign keys.static <R extends Record,U extends Record>
@NotNull ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>... fields)Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.static <R extends Record,U extends Record>
@NotNull ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>... fields)Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.static <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.- 3.14.0 - [#9404] - Please re-generate your code.static <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.- 3.14.0 - [#9404] - Please re-generate your code.static <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 <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 <R extends Record,T>
Identity<R,T>AbstractKeys. createIdentity(Table<R> table, TableField<R,T> field)Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record,T>
@NotNull Identity<R,T>Internal. createIdentity(Table<R> table, TableField<R,T> field)Factory method for identities.static <R extends Record>
UniqueKey<R>AbstractKeys. createUniqueKey(Table<R> table, String name, TableField<R,?>... fields)Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record>
UniqueKey<R>AbstractKeys. createUniqueKey(Table<R> table, TableField<R,?>... fields)Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record>
@NotNull UniqueKey<R>Internal. createUniqueKey(Table<R> table, String name, TableField<R,?>... fields)Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.static <R extends Record>
@NotNull UniqueKey<R>Internal. createUniqueKey(Table<R> table, String name, TableField<R,?>[] fields, boolean enforced)Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.static <R extends Record>
@NotNull UniqueKey<R>Internal. createUniqueKey(Table<R> table, Name name, TableField<R,?>... fields)Factory method for unique keys.static <R extends Record>
@NotNull UniqueKey<R>Internal. createUniqueKey(Table<R> table, Name name, TableField<R,?>[] fields, boolean enforced)Factory method for unique keys.static <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.static <R extends Record>
@NotNull UniqueKey<R>Internal. createUniqueKey(Table<R> table, TableField<R,?>... fields)Factory method for unique keys.<R extends Record>
DeleteUsingStep<R>DefaultDSLContext. delete(Table<R> table)static <R extends Record>
@NotNull DeleteUsingStep<R>DSL. delete(Table<R> table)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)<R extends Record>
Result<R>DefaultDSLContext. fetch(ResultQuery<R> query)<R extends Record>
Result<R>DefaultDSLContext. fetch(Table<R> table)<R extends Record>
Result<R>DefaultDSLContext. fetch(Table<R> table, Collection<? extends Condition> conditions)<R extends Record>
Result<R>DefaultDSLContext. fetch(Table<R> table, Condition condition)<R extends Record>
Result<R>DefaultDSLContext. fetch(Table<R> table, Condition... conditions)<R extends Record>
RDefaultDSLContext. fetchAny(Table<R> table)<R extends Record>
RDefaultDSLContext. fetchAny(Table<R> table, Collection<? extends Condition> conditions)<R extends Record>
RDefaultDSLContext. fetchAny(Table<R> table, Condition condition)<R extends Record>
RDefaultDSLContext. fetchAny(Table<R> table, Condition... conditions)<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)<R extends Record>
Cursor<R>DefaultDSLContext. fetchLazy(ResultQuery<R> query)<R extends Record>
Cursor<R>DefaultDSLContext. fetchLazy(Table<R> table)<R extends Record>
Cursor<R>DefaultDSLContext. fetchLazy(Table<R> table, Collection<? extends Condition> conditions)<R extends Record>
Cursor<R>DefaultDSLContext. fetchLazy(Table<R> table, Condition condition)<R extends Record>
Cursor<R>DefaultDSLContext. fetchLazy(Table<R> table, Condition... conditions)<R extends Record>
ResultsDefaultDSLContext. fetchMany(ResultQuery<R> query)<R extends Record>
RDefaultDSLContext. fetchOne(ResultQuery<R> query)<R extends Record>
RDefaultDSLContext. fetchOne(Table<R> table)<R extends Record>
RDefaultDSLContext. fetchOne(Table<R> table, Collection<? extends Condition> conditions)<R extends Record>
RDefaultDSLContext. fetchOne(Table<R> table, Condition condition)<R extends Record>
RDefaultDSLContext. fetchOne(Table<R> table, Condition... conditions)<R extends Record>
Optional<R>DefaultDSLContext. fetchOptional(ResultQuery<R> query)<R extends Record>
Optional<R>DefaultDSLContext. fetchOptional(Table<R> table)<R extends Record>
Optional<R>DefaultDSLContext. fetchOptional(Table<R> table, Collection<? extends Condition> conditions)<R extends Record>
Optional<R>DefaultDSLContext. fetchOptional(Table<R> table, Condition condition)<R extends Record>
Optional<R>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>
Stream<R>DefaultDSLContext. fetchStream(ResultQuery<R> query)<R extends Record>
Stream<R>DefaultDSLContext. fetchStream(Table<R> table)<R extends Record>
Stream<R>DefaultDSLContext. fetchStream(Table<R> table, Collection<? extends Condition> conditions)<R extends Record>
Stream<R>DefaultDSLContext. fetchStream(Table<R> table, Condition condition)<R extends Record>
Stream<R>DefaultDSLContext. fetchStream(Table<R> table, Condition... conditions)static <R extends Record,ER extends EmbeddableRecord<ER>>
@NotNull TableField<R,?>[]Internal. fields(TableField<R,ER> embeddableField)Deprecated.- [#11058] - 3.14.5 - Please re-generate your code.static <R extends Record,ER extends EmbeddableRecord<ER>>
@NotNull RowInternal. fieldsRow(TableField<R,ER> embeddableField)Get the fields row of an embeddable type.<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)static <R extends Record>
@NotNull Table<R>DSL. lateral(TableLike<R> table)Create aLATERALjoined table.<R extends Record>
LoaderOptionsStep<R>DefaultDSLContext. loadInto(Table<R> table)<R extends Record>
Table<R>DefaultDSLContext. map(Table<R> table)<R extends Record>
MergeUsingStep<R>DefaultDSLContext. mergeInto(Table<R> table)<R extends Record>
MergeKeyStepN<R>DefaultDSLContext. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)<R extends Record>
MergeKeyStepN<R>DefaultDSLContext. mergeInto(Table<R> table, Field<?>... fields)<R extends Record,T1>
MergeKeyStep1<R,T1>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1)Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)<R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)Deprecated.- [#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>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)Deprecated.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)static <R extends Record>
@NotNull MergeUsingStep<R>DSL. mergeInto(Table<R> table)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.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)static <R extends Record>
@NotNull MergeKeyStepN<R>DSL. mergeInto(Table<R> table, Field<?>... fields)Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)static <R extends Record,T1>
@NotNull MergeKeyStep1<R,T1>DSL. mergeInto(Table<R> table, Field<T1> field1)Deprecated.- [#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>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)Deprecated.- [#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>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)Deprecated.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#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.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)<R extends Record>
RDefaultDSLContext. newRecord(Table<R> table)<R extends Record>
RDefaultDSLContext. newRecord(Table<R> table, Object source)<R extends Record>
Result<R>DefaultDSLContext. newResult(Table<R> table)<R extends Record,E>
RecordMapper<R,E>DefaultRecordMapperProvider. provide(RecordType<R> rowType, Class<? extends E> type)<E,R extends Record>
RecordUnmapper<E,R>DefaultRecordUnmapperProvider. provide(Class<? extends E> type, RecordType<R> rowType)<R extends Record>
SelectWhereStep<R>DefaultDSLContext. selectFrom(Table<R> table)static <R extends Record>
@NotNull SelectWhereStep<R>DSL. selectFrom(Table<R> table)Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
SelectQuery<R>DefaultDSLContext. selectQuery(TableLike<R> table)static <R extends Record>
@NotNull Table<R>DSL. table(Result<R> result)Use a previously obtained result as a newTablethat can be used in SQL statements throughDSL.values(RowN...).static <R extends Record>
@NotNull Table<R>DSL. table(Select<R> select)A synonym forTableLike.asTable(), which might look a bit more fluent like this, to some users.static <R extends Record>
@NotNull Table<R>DSL. table(R record)Use a previously obtained record as a new Tablestatic <R extends Record>
@NotNull Table<R>DSL. table(R... records)Use a previously obtained set of records as a new Table<R extends Record>
TruncateIdentityStep<R>DefaultDSLContext. truncate(Table<R> table)static <R extends Record>
@NotNull TruncateIdentityStep<R>DSL. truncate(Table<R> table)Create a new DSL truncate statement.<R extends Record>
TruncateIdentityStep<R>DefaultDSLContext. truncateTable(Table<R> table)static <R extends Record>
@NotNull TruncateIdentityStep<R>DSL. truncateTable(Table<R> table)Create a new DSL truncate statement.<R extends Record>
UpdateSetFirstStep<R>DefaultDSLContext. update(Table<R> table)static <R extends Record>
@NotNull UpdateSetFirstStep<R>DSL. update(Table<R> table)Create a new DSL update statement.<R extends Record>
UpdateQuery<R>DefaultDSLContext. updateQuery(Table<R> table)Methods in org.jooq.impl that return Record Modifier and Type Method Description RecordDefaultDSLContext. fetchOne(String sql)RecordDefaultDSLContext. fetchOne(String sql, Object... bindings)RecordDefaultDSLContext. fetchOne(String sql, QueryPart... parts)RecordDefaultDSLContext. fetchOne(ResultSet rs)RecordDefaultDSLContext. fetchOne(ResultSet rs, Class<?>... types)RecordDefaultDSLContext. fetchOne(ResultSet rs, DataType<?>... types)RecordDefaultDSLContext. fetchOne(ResultSet rs, Field<?>... fields)RecordDefaultDSLContext. fetchOne(SQL sql)RecordDefaultDSLContext. fetchSingle(String sql)RecordDefaultDSLContext. fetchSingle(String sql, Object... bindings)RecordDefaultDSLContext. fetchSingle(String sql, QueryPart... parts)RecordDefaultDSLContext. fetchSingle(ResultSet rs)RecordDefaultDSLContext. fetchSingle(ResultSet rs, Class<?>... types)RecordDefaultDSLContext. fetchSingle(ResultSet rs, DataType<?>... types)RecordDefaultDSLContext. fetchSingle(ResultSet rs, Field<?>... fields)RecordDefaultDSLContext. fetchSingle(Collection<? extends SelectField<?>> fields)RecordDefaultDSLContext. fetchSingle(SelectField<?>... fields)RecordDefaultDSLContext. fetchSingle(SQL sql)RecordUpdatableRecordImpl. key()RecordDefaultDSLContext. newRecord(Collection<? extends Field<?>> fields)RecordDefaultDSLContext. newRecord(Field<?>... fields)Methods in org.jooq.impl that return types with arguments of type Record Modifier and Type Method Description CreateViewAsStep<Record>DefaultDSLContext. createOrReplaceView(String view, String... fields)CreateViewAsStep<Record>DefaultDSLContext. createOrReplaceView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createOrReplaceView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createOrReplaceView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createOrReplaceView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createOrReplaceView(Name view, Name... fields)CreateViewAsStep<Record>DefaultDSLContext. createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createOrReplaceView(Table<?> view, Field<?>... fields)CreateViewAsStep<Record>DefaultDSLContext. createView(String view, String... fields)CreateViewAsStep<Record>DefaultDSLContext. createView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createView(Name view, Name... fields)CreateViewAsStep<Record>DefaultDSLContext. createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createView(Table<?> view, Field<?>... fields)CreateViewAsStep<Record>DefaultDSLContext. createViewIfNotExists(String view, String... fields)CreateViewAsStep<Record>DefaultDSLContext. createViewIfNotExists(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createViewIfNotExists(String view, Function<? super Field<?>,? extends String> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createViewIfNotExists(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createViewIfNotExists(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createViewIfNotExists(Name view, Name... fields)CreateViewAsStep<Record>DefaultDSLContext. createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)CreateViewAsStep<Record>DefaultDSLContext. createViewIfNotExists(Table<?> view, Field<?>... fields)static @NotNull Table<Record>DSL. dual()TheDUALtable to be used for syntactic completeness.Result<Record>DefaultDSLContext. fetch(String sql)Result<Record>DefaultDSLContext. fetch(String sql, Object... bindings)Result<Record>DefaultDSLContext. fetch(String sql, QueryPart... parts)Result<Record>DefaultDSLContext. fetch(ResultSet rs)Result<Record>DefaultDSLContext. fetch(ResultSet rs, Class<?>... types)Result<Record>DefaultDSLContext. fetch(ResultSet rs, DataType<?>... types)Result<Record>DefaultDSLContext. fetch(ResultSet rs, Field<?>... fields)Result<Record>DefaultDSLContext. fetch(SQL sql)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(String sql)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(String sql, Object... bindings)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(String sql, QueryPart... parts)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(ResultSet rs)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(ResultSet rs, Class<?>... types)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(ResultSet rs, DataType<?>... types)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(ResultSet rs, Field<?>... fields)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(Executor executor, String sql)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(Executor executor, String sql, Object... bindings)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(Executor executor, String sql, QueryPart... parts)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(Executor executor, ResultSet rs)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(Executor executor, ResultSet rs, Class<?>... types)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(Executor executor, ResultSet rs, DataType<?>... types)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(Executor executor, ResultSet rs, Field<?>... fields)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(Executor executor, SQL sql)CompletionStage<Result<Record>>DefaultDSLContext. fetchAsync(SQL sql)Result<Record>DefaultDSLContext. fetchFromCSV(String string)Result<Record>DefaultDSLContext. fetchFromCSV(String string, boolean header)Result<Record>DefaultDSLContext. fetchFromCSV(String string, boolean header, char delimiter)Result<Record>DefaultDSLContext. fetchFromCSV(String string, char delimiter)Result<Record>DefaultDSLContext. fetchFromHTML(String string)Result<Record>DefaultDSLContext. fetchFromJSON(String string)Result<Record>DefaultDSLContext. fetchFromStringData(String[]... strings)Result<Record>DefaultDSLContext. fetchFromStringData(List<String[]> strings)Result<Record>DefaultDSLContext. fetchFromStringData(List<String[]> strings, boolean header)Result<Record>DefaultDSLContext. fetchFromTXT(String string)Result<Record>DefaultDSLContext. fetchFromTXT(String string, String nullLiteral)Result<Record>DefaultDSLContext. fetchFromXML(String string)Cursor<Record>DefaultDSLContext. fetchLazy(String sql)Cursor<Record>DefaultDSLContext. fetchLazy(String sql, Object... bindings)Cursor<Record>DefaultDSLContext. fetchLazy(String sql, QueryPart... parts)Cursor<Record>DefaultDSLContext. fetchLazy(ResultSet rs)Cursor<Record>DefaultDSLContext. fetchLazy(ResultSet rs, Class<?>... types)Cursor<Record>DefaultDSLContext. fetchLazy(ResultSet rs, DataType<?>... types)Cursor<Record>DefaultDSLContext. fetchLazy(ResultSet rs, Field<?>... fields)Cursor<Record>DefaultDSLContext. fetchLazy(SQL sql)Optional<Record>DefaultDSLContext. fetchOptional(String sql)Optional<Record>DefaultDSLContext. fetchOptional(String sql, Object... bindings)Optional<Record>DefaultDSLContext. fetchOptional(String sql, QueryPart... parts)Optional<Record>DefaultDSLContext. fetchOptional(ResultSet rs)Optional<Record>DefaultDSLContext. fetchOptional(ResultSet rs, Class<?>... types)Optional<Record>DefaultDSLContext. fetchOptional(ResultSet rs, DataType<?>... types)Optional<Record>DefaultDSLContext. fetchOptional(ResultSet rs, Field<?>... fields)Optional<Record>DefaultDSLContext. fetchOptional(SQL sql)Stream<Record>DefaultDSLContext. fetchStream(String sql)Stream<Record>DefaultDSLContext. fetchStream(String sql, Object... bindings)Stream<Record>DefaultDSLContext. fetchStream(String sql, QueryPart... parts)Stream<Record>DefaultDSLContext. fetchStream(ResultSet rs)Stream<Record>DefaultDSLContext. fetchStream(ResultSet rs, Class<?>... types)Stream<Record>DefaultDSLContext. fetchStream(ResultSet rs, DataType<?>... types)Stream<Record>DefaultDSLContext. fetchStream(ResultSet rs, Field<?>... fields)Stream<Record>DefaultDSLContext. fetchStream(SQL sql)Result<Record>DefaultDSLContext. newResult(Collection<? extends Field<?>> fields)Result<Record>DefaultDSLContext. newResult(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.ResultQuery<Record>DefaultDSLContext. resultQuery(String sql)ResultQuery<Record>DefaultDSLContext. resultQuery(String sql, Object... bindings)ResultQuery<Record>DefaultDSLContext. resultQuery(String sql, QueryPart... parts)ResultQuery<Record>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.static @NotNull Field<Record>DSL. rowField(RowN row)EXPERIMENTAL: Turn a row value expression of arbitrary degree into aField.static @NotNull Table<Record>DSL. rowsFrom(Table<?>... tables)Create aROWS FROM (tables...)expression.SelectSelectStep<Record>DefaultDSLContext. select(Collection<? extends SelectFieldOrAsterisk> fields)SelectSelectStep<Record>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.SelectSelectStep<Record>DefaultDSLContext. selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)SelectSelectStep<Record>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.SelectWhereStep<Record>DefaultDSLContext. selectFrom(String sql)SelectWhereStep<Record>DefaultDSLContext. selectFrom(String sql, Object... bindings)SelectWhereStep<Record>DefaultDSLContext. selectFrom(String sql, QueryPart... parts)SelectWhereStep<Record>DefaultDSLContext. selectFrom(Name table)SelectWhereStep<Record>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*.SelectQuery<Record>DefaultDSLContext. selectQuery()static @NotNull Table<Record>DSL. table(String sql)A custom SQL clause that can render arbitrary table expressions.static @NotNull Table<Record>DSL. table(String sql, Object... bindings)A custom SQL clause that can render arbitrary table expressions.static @NotNull Table<Record>DSL. table(String sql, QueryPart... parts)A custom SQL clause that can render arbitrary table expressions.static @NotNull Table<Record>DSL. table(Name name)Create a qualified table, given its table name.static @NotNull Table<Record>DSL. table(Name name, Comment comment)Create a qualified table, given its table name.static @NotNull Table<Record>DSL. table(SQL sql)A custom SQL clause that can render arbitrary table expressions.static @NotNull Table<Record>DSL. tableByName(String... qualifiedName)Deprecated.- [#3843] - 3.6.0 - useDSL.table(Name)insteadTruncateIdentityStep<Record>DefaultDSLContext. truncate(String table)TruncateIdentityStep<Record>DefaultDSLContext. truncate(Name table)static @NotNull TruncateIdentityStep<Record>DSL. truncate(String table)Create a new DSL truncate statement.static @NotNull TruncateIdentityStep<Record>DSL. truncate(Name table)Create a new DSL truncate statement.TruncateIdentityStep<Record>DefaultDSLContext. truncateTable(String table)TruncateIdentityStep<Record>DefaultDSLContext. truncateTable(Name table)static @NotNull TruncateIdentityStep<Record>DSL. truncateTable(String table)Create a new DSL truncate statement.static @NotNull TruncateIdentityStep<Record>DSL. truncateTable(Name table)Create a new DSL truncate statement.static @NotNull Table<Record>DSL. values(RowN... rows)Create aVALUES()expression of arbitrary degree.Methods in org.jooq.impl with parameters of type Record Modifier and Type Method Description static @NotNull ConditionDSL. condition(Record record)static <R extends Record>
@NotNull Table<R>DSL. table(R... records)Use a previously obtained set of records as a new Table -
Uses of Record in org.jooq.tools.jdbc
Methods in org.jooq.tools.jdbc with parameters of type Record Modifier and Type Method Description static MockDataProviderMock. of(Record record)Create a newMockDataProviderthat always returns a single record for all queries.Constructors in org.jooq.tools.jdbc with parameters of type Record Constructor Description MockResult(Record data)Create a newMockResult. -
Uses of Record in org.jooq.util.aurorapostgres
Fields in org.jooq.util.aurorapostgres with type parameters of type Record Modifier and Type Field Description static DataType<Result<Record>>AuroraPostgresDataType. REFCURSORDeprecated. -
Uses of Record in org.jooq.util.h2
Fields in org.jooq.util.h2 with type parameters of type Record Modifier and Type Field Description protected static DataType<Result<Record>>H2DataType. __RESULTDeprecated. -
Uses of Record in org.jooq.util.hsqldb
Fields in org.jooq.util.hsqldb with type parameters of type Record Modifier and Type Field Description static DataType<Result<Record>>HSQLDBDataType. ROWDeprecated. -
Uses of Record in org.jooq.util.oracle
Fields in org.jooq.util.oracle with type parameters of type Record Modifier and Type Field Description static DataType<Result<Record>>OracleDataType. REF_CURSORDeprecated. -
Uses of Record in org.jooq.util.postgres
Fields in org.jooq.util.postgres with type parameters of type Record Modifier and Type Field Description static DataType<Result<Record>>PostgresDataType. REFCURSORDeprecated.Methods in org.jooq.util.postgres that return types with arguments of type Record Modifier and Type Method Description static @NotNull Table<Record>PostgresDSL. only(Table<?> table)Get the PostgreSQL-specificONLY [table]clause for use with table inheritance.Methods in org.jooq.util.postgres with parameters of type Record Modifier and Type Method Description static 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 Modifier and Type Field Description static DataType<Result<Record>>RedshiftDataType. REFCURSORDeprecated. -
Uses of Record in org.jooq.util.vertica
Fields in org.jooq.util.vertica with type parameters of type Record Modifier and Type Field Description static DataType<Result<Record>>VerticaDataType. ROWDeprecated.
-