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 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.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>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep17<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 the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep18<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 the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep19<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 the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep2<R extends Record,T1,T2>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep20<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 the H2-specific variant of theMerge's DSL API.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>This type is used for the H2-specific variant of theMerge's DSL API.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>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep3<R extends Record,T1,T2,T3>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep4<R extends Record,T1,T2,T3,T4>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep5<R extends Record,T1,T2,T3,T4,T5>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep6<R extends Record,T1,T2,T3,T4,T5,T6>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeKeyStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>This type is used for the H2-specific variant of theMerge's DSL API.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.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>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep17<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 the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep18<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 the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep19<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 the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep2<R extends Record,T1,T2>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep20<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 the H2-specific variant of theMerge's DSL API.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>This type is used for the H2-specific variant of theMerge's DSL API.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>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep3<R extends Record,T1,T2,T3>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep4<R extends Record,T1,T2,T3,T4>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep5<R extends Record,T1,T2,T3,T4,T5>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>This type is used for the H2-specific variant of theMerge's DSL API.interfaceMergeValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>This type is used for the H2-specific variant of theMerge's DSL API.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 bySelectQueryinterfaceResultQuery<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>interfaceSelectDistinctOnStep<R extends Record>interfaceSelectFinalStep<R extends Record>interfaceSelectForUpdateOfStep<R extends Record>interfaceSelectForUpdateStep<R extends Record>interfaceSelectForUpdateWaitStep<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>
CommonTableExpression<R>DerivedColumnList. as(Select<R> select)Specify a subselect to refer to by theDerivedColumnListto form a common table expression.<R extends Record>
CommonTableExpression<R>Name. as(Select<R> select)Specify a subselect to refer to by theNameto form a common table expression.<X extends Record>
ResultQuery<X>ResultQuery. coerce(Table<X> table)Coerce the result record type of this query to that of a table.<R extends Record>
DeleteUsingStep<R>DSLContext. delete(Table<R> table)Create a new DSL delete statement.<R extends Record>
DeleteUsingStep<R>WithStep. delete(Table<R> table)Create a new DSL delete statement.<R extends Record>
DeleteUsingStep<R>DSLContext. deleteFrom(Table<R> table)Create a new DSL delete statement.<R extends Record>
DeleteQuery<R>DSLContext. deleteQuery(Table<R> table)Create a newDeleteQuery<R extends Record>
Result<R>DSLContext. fetch(ResultQuery<R> query)Execute aResultQueryin the context of thisDSLContextand return results.<R extends Record>
Result<R>DSLContext. fetch(Table<R> table)Execute and return all records for<R extends Record>
Result<R>DSLContext. fetch(Table<R> table, Collection<? extends Condition> conditions)Execute and return all records for<R extends Record>
Result<R>DSLContext. fetch(Table<R> table, Condition condition)Execute and return all records for<R extends Record>
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 one record for<Z extends Record>
ZResultQuery. fetchAnyInto(Table<Z> table)Map resulting records onto a custom record.<R extends Record>
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>
CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table)Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table, Collection<? extends Condition> conditions)Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table, Condition condition)Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table, Condition... conditions)Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(ResultQuery<R> query)Fetch results in a newCompletionStage.<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table)Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table, Collection<? extends Condition> condition)Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table, Condition condition)Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table, Condition... condition)Execute and return all records asynchronously for<S extends Record>
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>
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>
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>
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>
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>
Result<Z>Cursor. fetchInto(Table<Z> table)Map resulting records onto a custom record.<Z extends Record>
Result<Z>ResultQuery. fetchInto(Table<Z> table)Map resulting records onto a custom record.<R extends Record>
Cursor<R>DSLContext. fetchLazy(ResultQuery<R> query)Execute aResultQueryin the context of thisDSLContextand return a cursor.<R extends Record>
Cursor<R>DSLContext. fetchLazy(Table<R> table)Execute and return all records lazily for<R extends Record>
Cursor<R>DSLContext. fetchLazy(Table<R> table, Collection<? extends Condition> conditions)Execute and return all records lazily for<R extends Record>
Cursor<R>DSLContext. fetchLazy(Table<R> table, Condition condition)Execute and return all records lazily for<R extends Record>
Cursor<R>DSLContext. fetchLazy(Table<R> table, Condition... conditions)Execute and return all records lazily for<R extends Record>
ResultsDSLContext. fetchMany(ResultQuery<R> query)Execute aResultQueryin the context of thisDSLContextand return a cursor.<S extends Record>
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>
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>
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>
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>
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>
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>
Optional<R>DSLContext. fetchOptional(ResultQuery<R> query)Execute aResultQueryin the context of thisDSLContextand return a record.<R extends Record>
Optional<R>DSLContext. fetchOptional(Table<R> table)Execute and return zero or one record for<R extends Record>
Optional<R>DSLContext. fetchOptional(Table<R> table, Collection<? extends Condition> conditions)Execute and return zero or one record for<R extends Record>
Optional<R>DSLContext. fetchOptional(Table<R> table, Condition condition)Execute and return zero or one record for<R extends Record>
Optional<R>DSLContext. fetchOptional(Table<R> table, Condition... conditions)Execute and return zero or one record for<Z extends Record>
Optional<Z>Cursor. fetchOptionalInto(Table<Z> table)Deprecated.- 3.10 - [#6363] - UseCursor.fetchNextOptionalInto(Table)instead.<Z extends Record>
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>
Stream<R>DSLContext. fetchStream(ResultQuery<R> query)Execute aResultQueryin the context of thisDSLContextand return a stream.<R extends Record>
Stream<R>DSLContext. fetchStream(Table<R> table)Execute and return all records lazily for<R extends Record>
Stream<R>DSLContext. fetchStream(Table<R> table, Collection<? extends Condition> conditions)Execute and return all records lazily for<R extends Record>
Stream<R>DSLContext. fetchStream(Table<R> table, Condition condition)Execute and return all records lazily for<R extends Record>
Stream<R>DSLContext. fetchStream(Table<R> table, Condition... conditions)Execute and return all records lazily for<Z extends Record>
Stream<Z>ResultQuery. fetchStreamInto(Table<Z> table)Stream this query, mapping records into a custom record.<O extends Record>
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>
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>
InsertSetStep<R>DSLContext. insertInto(Table<R> into)Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R>DSLContext. insertInto(Table<R> into, Collection<? extends Field<?>> fields)Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R>DSLContext. insertInto(Table<R> into, Field<?>... fields)Create a new DSL insert statement.<R extends Record,T1>
InsertValuesStep1<R,T1>DSLContext. insertInto(Table<R> into, Field<T1> field1)Create a new DSL insert statement.<R extends Record,T1,T2>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
InsertSetStep<R>WithStep. insertInto(Table<R> into)Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R>WithStep. insertInto(Table<R> into, Collection<? extends Field<?>> fields)Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R>WithStep. insertInto(Table<R> into, Field<?>... fields)Create a new DSL insert statement.<R extends Record,T1>
InsertValuesStep1<R,T1>WithStep. insertInto(Table<R> into, Field<T1> field1)Create a new DSL insert statement.<R extends Record,T1,T2>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
Result<Z>Result. into(Table<Z> table)Map resulting records onto a custom record.<S extends Record>
Map<S,Result<R>>Result. intoGroups(Table<S> table)Return aMapwith the result grouped by the given key table.<E,S extends Record>
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>
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>
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>
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>
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>
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>
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>
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>
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>
LoaderOptionsStep<R>DSLContext. loadInto(Table<R> table)Create a newLoaderobject to load data from a CSV or XML source.<R extends Record>
Table<R>DSLContext. map(Table<R> table)Map a table to another one.<R extends Record>
Table<R>SchemaMapping. map(Table<R> table)Deprecated.Apply mapping to a given table<R extends Record>
MergeUsingStep<R>DSLContext. mergeInto(Table<R> table)Create a new DSL SQL standard MERGE statement.<R extends Record>
MergeKeyStepN<R>DSLContext. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)Create a new DSL merge statement (H2-specific syntax).<R extends Record>
MergeKeyStepN<R>DSLContext. mergeInto(Table<R> table, Field<?>... fields)<R extends Record,T1>
MergeKeyStep1<R,T1>DSLContext. mergeInto(Table<R> table, Field<T1> field1)<R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)<R extends Record,T1,T2,T3>
MergeKeyStep3<R,T1,T2,T3>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)<R extends Record,T1,T2,T3,T4>
MergeKeyStep4<R,T1,T2,T3,T4>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)<R extends Record,T1,T2,T3,T4,T5>
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)<R extends Record,T1,T2,T3,T4,T5,T6>
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)<R extends Record,T1,T2,T3,T4,T5,T6,T7>
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)<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
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)<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
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)<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>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)<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>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)<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>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)<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>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)<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>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)<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>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)<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>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)<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>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)<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>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)<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>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)<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>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)<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>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)<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>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)<R extends Record>
MergeUsingStep<R>WithStep. mergeInto(Table<R> table)Create a new DSL SQL standard MERGE statement.<R extends Record>
MergeKeyStepN<R>WithStep. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)Create a new DSL merge statement (H2-specific syntax).<R extends Record>
MergeKeyStepN<R>WithStep. mergeInto(Table<R> table, Field<?>... fields)Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1>
MergeKeyStep1<R,T1>WithStep. mergeInto(Table<R> table, Field<T1> field1)Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3>
MergeKeyStep3<R,T1,T2,T3>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4>
MergeKeyStep4<R,T1,T2,T3,T4>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5>
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)Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6>
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)Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7>
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)Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
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)Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
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)Create a new DSL merge statement (H2-specific syntax).<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>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)Create a new DSL merge statement (H2-specific syntax).<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>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)Create a new DSL merge statement (H2-specific syntax).<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>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)Create a new DSL merge statement (H2-specific syntax).<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>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)Create a new DSL merge statement (H2-specific syntax).<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>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)Create a new DSL merge statement (H2-specific syntax).<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>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)Create a new DSL merge statement (H2-specific syntax).<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>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)Create a new DSL merge statement (H2-specific syntax).<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>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)Create a new DSL merge statement (H2-specific syntax).<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>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)Create a new DSL merge statement (H2-specific syntax).<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>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)Create a new DSL merge statement (H2-specific syntax).<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>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)Create a new DSL merge statement (H2-specific syntax).<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>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)Create a new DSL merge statement (H2-specific syntax).<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>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)Create a new DSL merge statement (H2-specific syntax).<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>
Result<R>DSLContext. newResult(Table<R> table)Create a new emptyResult.<R extends Record,E>
RecordMapper<R,E>RecordMapperProvider. provide(RecordType<R> recordType, Class<? extends E> type)Provide aRecordMapperinstance.<E,R extends Record>
RecordUnmapper<E,R>RecordUnmapperProvider. provide(Class<? extends E> type, RecordType<R> recordType)Provide aRecordUnmapperinstance.<R extends Record>
SelectWhereStep<R>DSLContext. selectFrom(Table<R> table)Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
SelectWhereStep<R>WithStep. selectFrom(Table<R> table)Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
SelectQuery<R>DSLContext. selectQuery(TableLike<R> table)Create a newSelectQuery<R extends Record>
TruncateIdentityStep<R>DSLContext. truncate(Table<R> table)Create a new DSL truncate statement.<R extends Record>
TruncateIdentityStep<R>DSLContext. truncateTable(Table<R> table)Create a new DSL truncate statement.<R extends Record>
UpdateSetFirstStep<R>DSLContext. update(Table<R> table)Create a new DSL update statement.<R extends Record>
UpdateSetFirstStep<R>WithStep. update(Table<R> table)Create a new DSL update statement.<R extends Record>
UpdateQuery<R>DSLContext. updateQuery(Table<R> table)Create a newUpdateQueryMethods in org.jooq that return Record Modifier and Type Method Description Record[]RecordContext. batchRecords()TheRecord(s) that are being manipulated in batch mode.R[]ResultQuery. fetchArray()Execute the query and return the generated result as an array of records.RecordDSLContext. fetchOne(String sql)Execute a new query holding plain SQL.RecordDSLContext. fetchOne(String sql, Object... bindings)Execute a new query holding plain SQL.RecordDSLContext. fetchOne(String sql, QueryPart... parts)Execute a new query holding plain SQL.RecordDSLContext. fetchOne(ResultSet rs)RecordDSLContext. fetchOne(ResultSet rs, Class<?>... types)RecordDSLContext. fetchOne(ResultSet rs, DataType<?>... types)RecordDSLContext. fetchOne(ResultSet rs, Field<?>... fields)RecordDSLContext. fetchOne(SQL sql)Execute a new query holding plain SQL.RecordDSLContext. fetchSingle(String sql)Execute a new query holding plain SQL.RecordDSLContext. fetchSingle(String sql, Object... bindings)Execute a new query holding plain SQL.RecordDSLContext. fetchSingle(String sql, QueryPart... parts)Execute a new query holding plain SQL.RecordDSLContext. fetchSingle(ResultSet rs)RecordDSLContext. fetchSingle(ResultSet rs, Class<?>... types)RecordDSLContext. fetchSingle(ResultSet rs, DataType<?>... types)RecordDSLContext. fetchSingle(ResultSet rs, Field<?>... fields)RecordDSLContext. fetchSingle(Collection<? extends SelectField<?>> fields)Execute and return exactly one record forRecordDSLContext. fetchSingle(SelectField<?>... fields)Execute and return exactly one record forRecordDSLContext. fetchSingle(SQL sql)Execute a new query holding plain SQL.RecordRecord. into(Field<?>... fields)Copy this record into a new record holding only a subset of the previous fields.RecordUpdatableRecord. key()A Record copy holding values for theTable.getPrimaryKey().RecordDSLContext. newRecord(Collection<? extends Field<?>> fields)Create a new emptyRecord.RecordDSLContext. newRecord(Field<?>... fields)Create a new emptyRecord.RecordRecord. original()Get this record containing the original values as fetched from the database.RecordExecuteContext. record()The last record that was fetched from the result set, ornullif no record has been fetched.RecordRecordContext. record()TheRecordthat is being manipulated.<T> RecordRecord. with(Field<T> field, T value)Set a value into this record.<T,U>
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 ResultQuery<Record>ResultQuery. coerce(Collection<? extends Field<?>> fields)Coerce the result record type of this query to that of a set of fields.ResultQuery<Record>ResultQuery. coerce(Field<?>... fields)Coerce the result record type of this query to that of a set of fields.CreateViewAsStep<Record>DSLContext. createOrReplaceView(String view, String... fields)Create a new DSLCREATE OR REPLACE VIEWstatement.CreateViewAsStep<Record>DSLContext. createOrReplaceView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)Create a new DSLCREATE OR REPLACE VIEWstatement.CreateViewAsStep<Record>DSLContext. createOrReplaceView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)Create a new DSLCREATE OR REPLACE VIEWstatement.CreateViewAsStep<Record>DSLContext. createOrReplaceView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)Create a new DSLCREATE OR REPLACE VIEWstatement.CreateViewAsStep<Record>DSLContext. createOrReplaceView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)Create a new DSLCREATE OR REPLACE VIEWstatement.CreateViewAsStep<Record>DSLContext. createOrReplaceView(Name view, Name... fields)Create a new DSLCREATE OR REPLACE VIEWstatement.CreateViewAsStep<Record>DSLContext. createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)Create a new DSLCREATE OR REPLACE VIEWstatement.CreateViewAsStep<Record>DSLContext. createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)Create a new DSLCREATE OR REPLACE VIEWstatement.CreateViewAsStep<Record>DSLContext. createOrReplaceView(Table<?> view, Field<?>... fields)Create a new DSLCREATE OR REPLACE VIEWstatement.CreateViewAsStep<Record>DSLContext. createView(String view, String... fields)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createView(Name view, Name... fields)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createView(Table<?> view, Field<?>... fields)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createViewIfNotExists(String view, String... fields)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createViewIfNotExists(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createViewIfNotExists(String view, Function<? super Field<?>,? extends String> fieldNameFunction)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createViewIfNotExists(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createViewIfNotExists(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createViewIfNotExists(Name view, Name... fields)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)Create a new DSLCREATE VIEWstatement.CreateViewAsStep<Record>DSLContext. createViewIfNotExists(Table<?> view, Field<?>... fields)Create a new DSLCREATE VIEWstatement.Table<Record>Table. crossApply(String sql)CROSS APPLYa table to this table.Table<Record>Table. crossApply(String sql, Object... bindings)CROSS APPLYa table to this table.Table<Record>Table. crossApply(String sql, QueryPart... parts)CROSS APPLYa table to this table.Table<Record>Table. crossApply(Name name)CROSS APPLYa table to this table.Table<Record>Table. crossApply(SQL sql)CROSS APPLYa table to this table.Table<Record>Table. crossApply(TableLike<?> table)CROSS APPLYa table to this table.Table<Record>Table. crossJoin(String sql)CROSS JOINa table to this table.Table<Record>Table. crossJoin(String sql, Object... bindings)CROSS JOINa table to this table.Table<Record>Table. crossJoin(String sql, QueryPart... parts)CROSS JOINa table to this table.Table<Record>Table. crossJoin(Name name)CROSS JOINa table to this table.Table<Record>Table. crossJoin(SQL sql)CROSS JOINa table to this table.Table<Record>Table. crossJoin(TableLike<?> table)CROSS JOINa table to this table.Result<Record>DSLContext. fetch(String sql)Execute a new query holding plain SQL.Result<Record>DSLContext. fetch(String sql, Object... bindings)Execute a new query holding plain SQL.Result<Record>DSLContext. fetch(String sql, QueryPart... parts)Execute a new query holding plain SQL.Result<Record>DSLContext. fetch(ResultSet rs)Result<Record>DSLContext. fetch(ResultSet rs, Class<?>... types)Result<Record>DSLContext. fetch(ResultSet rs, DataType<?>... types)Result<Record>DSLContext. fetch(ResultSet rs, Field<?>... fields)Result<Record>DSLContext. fetch(SQL sql)Execute a new query holding plain SQL.CompletionStage<Result<Record>>DSLContext. fetchAsync(String sql)Fetch results in a newCompletionStage.CompletionStage<Result<Record>>DSLContext. fetchAsync(String sql, Object... bindings)Fetch results in a newCompletionStage.CompletionStage<Result<Record>>DSLContext. fetchAsync(String sql, QueryPart... parts)Fetch results in a newCompletionStage.CompletionStage<Result<Record>>DSLContext. fetchAsync(ResultSet rs)Fetch results in a newCompletionStage.CompletionStage<Result<Record>>DSLContext. fetchAsync(ResultSet rs, Class<?>... types)Fetch results in a newCompletionStage.CompletionStage<Result<Record>>DSLContext. fetchAsync(ResultSet rs, DataType<?>... types)Fetch results in a newCompletionStage.CompletionStage<Result<Record>>DSLContext. fetchAsync(ResultSet rs, Field<?>... fields)Fetch results in a newCompletionStage.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.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.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.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.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.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.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.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.CompletionStage<Result<Record>>DSLContext. fetchAsync(SQL sql)Fetch results in a newCompletionStage.Result<Record>DSLContext. fetchFromCSV(String string)Fetch all data from a CSV string.Result<Record>DSLContext. fetchFromCSV(String string, boolean header)Fetch all data from a CSV string.Result<Record>DSLContext. fetchFromCSV(String string, boolean header, char delimiter)Fetch all data from a CSV string.Result<Record>DSLContext. fetchFromCSV(String string, char delimiter)Fetch all data from a CSV string.Result<Record>DSLContext. fetchFromHTML(String string)Convert an HTML table into a jOOQResult.Result<Record>DSLContext. fetchFromJSON(String string)Fetch all data from a JSON string.Result<Record>DSLContext. fetchFromStringData(String[]... data)Fetch all data from a list of strings.Result<Record>DSLContext. fetchFromStringData(List<String[]> data)Fetch all data from a list of strings.Result<Record>DSLContext. fetchFromStringData(List<String[]> data, boolean header)Fetch all data from a list of strings.Result<Record>DSLContext. fetchFromTXT(String string)Fetch all data from a formatted string.Result<Record>DSLContext. fetchFromTXT(String string, String nullLiteral)Fetch all data from a formatted string.Result<Record>DSLContext. fetchFromXML(String string)Fetch all data from an XML string.Map<Record,Result<R>>ResultQuery. fetchGroups(int[] keyFieldIndexes)Execute the query and return aMapwith the result grouped by the given keys.Map<Record,Result<Record>>ResultQuery. fetchGroups(int[] keyFieldIndexes, int[] valueFieldIndexes)Execute the query and return aMapwith the result grouped by the given keys.Map<Record,Result<Record>>ResultQuery. fetchGroups(int[] keyFieldIndexes, int[] valueFieldIndexes)Execute the query and return aMapwith the result grouped by the given keys.<E> 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> 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.Map<Record,Result<R>>ResultQuery. fetchGroups(String[] keyFieldNames)Execute the query and return aMapwith the result grouped by the given keys.<E> 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.Map<Record,Result<Record>>ResultQuery. fetchGroups(String[] keyFieldNames, String[] valueFieldNames)Execute the query and return aMapwith the result grouped by the given keys.Map<Record,Result<Record>>ResultQuery. fetchGroups(String[] keyFieldNames, String[] valueFieldNames)Execute the query and return aMapwith the result grouped by the given keys.<E> 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.Map<Record,Result<R>>ResultQuery. fetchGroups(Field<?>[] keys)Execute the query and return aMapwith the result grouped by the given keys.<E> 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.Map<Record,Result<Record>>ResultQuery. fetchGroups(Field<?>[] keys, Field<?>[] values)Execute the query and return aMapwith the result grouped by the given keys.Map<Record,Result<Record>>ResultQuery. fetchGroups(Field<?>[] keys, Field<?>[] values)Execute the query and return aMapwith the result grouped by the given keys.<E> 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.Map<Record,Result<R>>ResultQuery. fetchGroups(Name[] keyFieldNames)Execute the query and return aMapwith the result grouped by the given keys.<E> Map<Record,List<E>>ResultQuery. fetchGroups(Name[] keyFieldNames, Class<? extends E> type)Execute the query and return aMapwith results grouped by the given keys and mapped into the given entity type.Map<Record,Result<Record>>ResultQuery. fetchGroups(Name[] keyFieldNames, Name[] valueFieldNames)Execute the query and return aMapwith the result grouped by the given keys.Map<Record,Result<Record>>ResultQuery. fetchGroups(Name[] keyFieldNames, Name[] valueFieldNames)Execute the query and return aMapwith the result grouped by the given keys.<E> Map<Record,List<E>>ResultQuery. fetchGroups(Name[] keyFieldNames, RecordMapper<? super R,E> mapper)Execute the query and return aMapwith results grouped by the given keys and mapped by the given mapper.Cursor<Record>DSLContext. fetchLazy(String sql)Execute a new query holding plain SQL and "lazily" return the generated result.Cursor<Record>DSLContext. fetchLazy(String sql, Object... bindings)Execute a new query holding plain SQL and "lazily" return the generated result.Cursor<Record>DSLContext. fetchLazy(String sql, QueryPart... parts)Execute a new query holding plain SQL and "lazily" return the generated result.Cursor<Record>DSLContext. fetchLazy(ResultSet rs)Cursor<Record>DSLContext. fetchLazy(ResultSet rs, Class<?>... types)Cursor<Record>DSLContext. fetchLazy(ResultSet rs, DataType<?>... types)Cursor<Record>DSLContext. fetchLazy(ResultSet rs, Field<?>... fields)Cursor<Record>DSLContext. fetchLazy(SQL sql)Execute a new query holding plain SQL and "lazily" return the generated result.Map<Record,R>ResultQuery. fetchMap(int[] keyFieldIndexes)Execute the query and return aMapwith keys as a map key and the corresponding record as value.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.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.Map<Record,R>ResultQuery. fetchMap(String[] keyFieldNames)Execute the query and return aMapwith keys as a map key and the corresponding record as value.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.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.Map<Record,R>ResultQuery. fetchMap(Field<?>[] keys)Execute the query and return aMapwith keys as a map key and the corresponding record as value.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.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.Map<Record,R>ResultQuery. fetchMap(Name[] keyFieldNames)Execute the query and return aMapwith keys as a map key and the corresponding record as value.Map<Record,Record>ResultQuery. fetchMap(Name[] keyFieldNames, Name[] valueFieldNames)Execute the query and return aMapwith keys as a map key and the corresponding record as value.Map<Record,Record>ResultQuery. fetchMap(Name[] keyFieldNames, Name[] valueFieldNames)Execute the query and return aMapwith keys as a map key and the corresponding record as value.Optional<Record>DSLContext. fetchOptional(String sql)Execute a new query holding plain SQL.Optional<Record>DSLContext. fetchOptional(String sql, Object... bindings)Execute a new query holding plain SQL.Optional<Record>DSLContext. fetchOptional(String sql, QueryPart... parts)Execute a new query holding plain SQL.Optional<Record>DSLContext. fetchOptional(ResultSet rs)Optional<Record>DSLContext. fetchOptional(ResultSet rs, Class<?>... types)Optional<Record>DSLContext. fetchOptional(ResultSet rs, DataType<?>... types)Optional<Record>DSLContext. fetchOptional(ResultSet rs, Field<?>... fields)Optional<Record>DSLContext. fetchOptional(SQL sql)Execute a new query holding plain SQL.Stream<Record>DSLContext. fetchStream(String sql)Execute a new query holding plain SQL and "lazily" return the generated result.Stream<Record>DSLContext. fetchStream(String sql, Object... bindings)Execute a new query holding plain SQL and "lazily" return the generated result.Stream<Record>DSLContext. fetchStream(String sql, QueryPart... parts)Execute a new query holding plain SQL and "lazily" return the generated result.Stream<Record>DSLContext. fetchStream(ResultSet rs)Stream<Record>DSLContext. fetchStream(ResultSet rs, Class<?>... types)Stream<Record>DSLContext. fetchStream(ResultSet rs, DataType<?>... types)Stream<Record>DSLContext. fetchStream(ResultSet rs, Field<?>... fields)Stream<Record>DSLContext. fetchStream(SQL sql)Execute a new query holding plain SQL and "lazily" return the generated result.TableOnStep<Record>Table. fullJoin(String sql)FULL OUTER JOINa table to this table.TableOnStep<Record>Table. fullJoin(String sql, Object... bindings)FULL OUTER JOINa table to this table.TableOnStep<Record>Table. fullJoin(String sql, QueryPart... parts)FULL OUTER JOINa table to this table.TableOnStep<Record>Table. fullJoin(Name name)FULL OUTER JOINa table to this table.TableOnStep<Record>Table. fullJoin(SQL sql)FULL OUTER JOINa table to this table.TableOnStep<Record>Table. fullJoin(TableLike<?> table)FULL OUTER JOINa table to this table.TableOnStep<Record>Table. fullOuterJoin(String sql)FULL OUTER JOINa table to this table.TableOnStep<Record>Table. fullOuterJoin(String sql, Object... bindings)FULL OUTER JOINa table to this table.TableOnStep<Record>Table. fullOuterJoin(String sql, QueryPart... parts)FULL OUTER JOINa table to this table.TableOnStep<Record>Table. fullOuterJoin(Name name)FULL OUTER JOINa table to this table.TableOnStep<Record>Table. fullOuterJoin(SQL sql)FULL OUTER JOINa table to this table.TableOnStep<Record>Table. fullOuterJoin(TableLike<?> table)FULL OUTER JOINa table to this table.Table<Record>PivotInStep. in(Collection<? extends Field<T>> fields)Specify the acceptable values for pivotingTable<Record>PivotInStep. in(Field<?>... fields)Specify the acceptable values for pivotingTable<Record>PivotInStep. in(T... values)Specify the acceptable values for pivotingTableOnStep<Record>Table. innerJoin(String sql)INNER JOINa table to this table.TableOnStep<Record>Table. innerJoin(String sql, Object... bindings)INNER JOINa table to this table.TableOnStep<Record>Table. innerJoin(String sql, QueryPart... parts)INNER JOINa table to this table.TableOnStep<Record>Table. innerJoin(Name name)INNER JOINa table to this table.TableOnStep<Record>Table. innerJoin(SQL sql)INNER JOINa table to this table.TableOnStep<Record>Table. innerJoin(TableLike<?> table)INNER JOINa table to this table.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.SelectFromStep<Record>SelectIntoStep. into(Table<?> table)Add anINTOclause to theSELECTstatement.Map<Record,Result<R>>Result. intoGroups(int[] keyFieldIndexes)Return aMapwith the result grouped by the given keys.Map<Record,Result<Record>>Result. intoGroups(int[] keyFieldIndexes, int[] valueFieldIndexes)Return aMapwith the result grouped by the given keys.Map<Record,Result<Record>>Result. intoGroups(int[] keyFieldIndexes, int[] valueFieldIndexes)Return aMapwith the result grouped by the given keys.<E> 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> 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.Map<Record,Result<R>>Result. intoGroups(String[] keyFieldNames)Return aMapwith the result grouped by the given keys.<E> 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.Map<Record,Result<Record>>Result. intoGroups(String[] keyFieldNames, String[] valueFieldNames)Return aMapwith the result grouped by the given keys.Map<Record,Result<Record>>Result. intoGroups(String[] keyFieldNames, String[] valueFieldNames)Return aMapwith the result grouped by the given keys.<E> 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.Map<Record,Result<R>>Result. intoGroups(Field<?>[] keys)Return aMapwith the result grouped by the given keys.<E> 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.Map<Record,Result<Record>>Result. intoGroups(Field<?>[] keys, Field<?>[] values)Return aMapwith the result grouped by the given keys.Map<Record,Result<Record>>Result. intoGroups(Field<?>[] keys, Field<?>[] values)Return aMapwith the result grouped by the given keys.<E> 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.Map<Record,Result<R>>Result. intoGroups(Name[] keyFieldNames)Return aMapwith the result grouped by the given keys.<E> 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.Map<Record,Result<Record>>Result. intoGroups(Name[] keyFieldNames, Name[] valueFieldNames)Return aMapwith the result grouped by the given keys.Map<Record,Result<Record>>Result. intoGroups(Name[] keyFieldNames, Name[] valueFieldNames)Return aMapwith the result grouped by the given keys.<E> 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.Map<Record,R>Result. intoMap(int[] keyFieldIndexes)Return aMapwith the given keys as a map key and the corresponding record as value.Map<Record,Record>Result. intoMap(int[] keyFieldIndexes, int[] valueFieldIndexes)Return aMapwith the given keys as a map key and the corresponding record as value.Map<Record,Record>Result. intoMap(int[] keyFieldIndexes, int[] valueFieldIndexes)Return aMapwith the given keys as a map key and the corresponding record as value.Map<Record,R>Result. intoMap(String[] keyFieldNames)Return aMapwith the given keys as a map key and the corresponding record as value.Map<Record,Record>Result. intoMap(String[] keyFieldNames, String[] valueFieldNames)Return aMapwith the given keys as a map key and the corresponding record as value.Map<Record,Record>Result. intoMap(String[] keyFieldNames, String[] valueFieldNames)Return aMapwith the given keys as a map key and the corresponding record as value.Map<Record,R>Result. intoMap(Field<?>[] keys)Return aMapwith the given keys as a map key and the corresponding record as value.Map<Record,Record>Result. intoMap(Field<?>[] keys, Field<?>[] values)Return aMapwith the given keys as a map key and the corresponding record as value.Map<Record,Record>Result. intoMap(Field<?>[] keys, Field<?>[] values)Return aMapwith the given keys as a map key and the corresponding record as value.Map<Record,R>Result. intoMap(Name[] keyFieldNames)Return aMapwith the given keys as a map key and the corresponding record as value.Map<Record,Record>Result. intoMap(Name[] keyFieldNames, Name[] valueFieldNames)Return aMapwith the given keys as a map key and the corresponding record as value.Map<Record,Record>Result. intoMap(Name[] keyFieldNames, Name[] valueFieldNames)Return aMapwith the given keys as a map key and the corresponding record as value.TableOnStep<Record>Table. join(String sql)INNER JOINa table to this table.TableOnStep<Record>Table. join(String sql, Object... bindings)INNER JOINa table to this table.TableOnStep<Record>Table. join(String sql, QueryPart... parts)INNER JOINa table to this table.TableOnStep<Record>Table. join(Name name)INNER JOINa table to this table.TableOnStep<Record>Table. join(SQL sql)INNER JOINa table to this table.TableOnStep<Record>Table. join(TableLike<?> table)INNER JOINa table to this table.TableOptionalOnStep<Record>Table. join(TableLike<?> table, JoinType type)Join a table to this table using aJoinTypeTableOnStep<Record>TableOuterJoinStep. join(TableLike<?> table, JoinType type)Join a table to this table using aJoinType.TablePartitionByStep<Record>Table. leftJoin(String sql)LEFT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. leftJoin(String sql, Object... bindings)LEFT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. leftJoin(String sql, QueryPart... parts)LEFT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. leftJoin(Name name)LEFT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. leftJoin(SQL sql)LEFT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. leftJoin(TableLike<?> table)LEFT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. leftJoin(String sql)LEFT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. leftJoin(String sql, Object... bindings)LEFT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. leftJoin(String sql, QueryPart... parts)LEFT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. leftJoin(Name name)LEFT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. leftJoin(SQL sql)LEFT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. leftJoin(TableLike<?> table)LEFT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. leftOuterJoin(String sql)LEFT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. leftOuterJoin(String sql, Object... bindings)LEFT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. leftOuterJoin(String sql, QueryPart... parts)LEFT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. leftOuterJoin(Name name)LEFT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. leftOuterJoin(SQL sql)LEFT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. leftOuterJoin(TableLike<?> table)LEFT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. leftOuterJoin(String sql)LEFT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. leftOuterJoin(String sql, Object... bindings)LEFT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. leftOuterJoin(String sql, QueryPart... parts)LEFT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. leftOuterJoin(Name name)LEFT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. leftOuterJoin(SQL sql)LEFT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. leftOuterJoin(TableLike<?> table)LEFT OUTER JOINa table to this table.Table<Record>Table. naturalFullOuterJoin(String sql)NATURAL FULL OUTER JOINa table to this table.Table<Record>Table. naturalFullOuterJoin(String sql, Object... bindings)NATURAL FULL OUTER JOINa table to this table.Table<Record>Table. naturalFullOuterJoin(String sql, QueryPart... parts)NATURAL FULL OUTER JOINa table to this table.Table<Record>Table. naturalFullOuterJoin(Name name)NATURAL FULL OUTER JOINa table to this table.Table<Record>Table. naturalFullOuterJoin(SQL sql)NATURAL FULL OUTER JOINa table to this table.Table<Record>Table. naturalFullOuterJoin(TableLike<?> table)NATURAL FULL OUTER JOINa table to this table.Table<Record>Table. naturalJoin(String sql)NATURAL JOINa table to this table.Table<Record>Table. naturalJoin(String sql, Object... bindings)NATURAL JOINa table to this table.Table<Record>Table. naturalJoin(String sql, QueryPart... parts)NATURAL JOINa table to this table.Table<Record>Table. naturalJoin(Name name)NATURAL JOINa table to this table.Table<Record>Table. naturalJoin(SQL sql)NATURAL JOINa table to this table.Table<Record>Table. naturalJoin(TableLike<?> table)NATURAL JOINa table to this table.Table<Record>Table. naturalLeftOuterJoin(String sql)NATURAL LEFT OUTER JOINa table to this table.Table<Record>Table. naturalLeftOuterJoin(String sql, Object... bindings)NATURAL LEFT OUTER JOINa table to this table.Table<Record>Table. naturalLeftOuterJoin(String sql, QueryPart... parts)NATURAL LEFT OUTER JOINa table to this table.Table<Record>Table. naturalLeftOuterJoin(Name name)NATURAL LEFT OUTER JOINa table to this table.Table<Record>Table. naturalLeftOuterJoin(SQL sql)NATURAL LEFT OUTER JOINa table to this table.Table<Record>Table. naturalLeftOuterJoin(TableLike<?> table)NATURAL LEFT OUTER JOINa table to this table.Table<Record>Table. naturalRightOuterJoin(String sql)NATURAL RIGHT OUTER JOINa table to this table.Table<Record>Table. naturalRightOuterJoin(String sql, Object... bindings)NATURAL RIGHT OUTER JOINa table to this table.Table<Record>Table. naturalRightOuterJoin(String sql, QueryPart... parts)NATURAL RIGHT OUTER JOINa table to this table.Table<Record>Table. naturalRightOuterJoin(Name name)NATURAL RIGHT OUTER JOINa table to this table.Table<Record>Table. naturalRightOuterJoin(SQL sql)NATURAL RIGHT OUTER JOINa table to this table.Table<Record>Table. naturalRightOuterJoin(TableLike<?> table)NATURAL RIGHT OUTER JOINa table to this table.Result<Record>DSLContext. newResult(Collection<? extends Field<?>> fields)Create a new emptyRecord.Result<Record>DSLContext. newResult(Field<?>... fields)Create a new emptyRecord.Table<Record>Table. outerApply(String sql)OUTER APPLYa table to this table.Table<Record>Table. outerApply(String sql, Object... bindings)OUTER APPLYa table to this table.Table<Record>Table. outerApply(String sql, QueryPart... parts)OUTER APPLYa table to this table.Table<Record>Table. outerApply(Name name)OUTER APPLYa table to this table.Table<Record>Table. outerApply(SQL sql)OUTER APPLYa table to this table.Table<Record>Table. outerApply(TableLike<?> table)OUTER APPLYa table to this table.TableOuterJoinStep<Record>Table. partitionBy(Collection<? extends Field<?>> fields)Add aPARTITION BYclause to the left hand side of theOUTER JOINkeywordsTableOuterJoinStep<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.ResultQuery<Record>DSLContext. resultQuery(String sql)Create a new query holding plain SQL.ResultQuery<Record>DSLContext. resultQuery(String sql, Object... bindings)Create a new query holding plain SQL.ResultQuery<Record>DSLContext. resultQuery(String sql, QueryPart... parts)Create a new query holding plain SQL.ResultQuery<Record>DSLContext. resultQuery(SQL sql)Create a new query holding plain SQL.Table<Record>DivideByReturningStep. returning(Collection<? extends Field<?>> fields)Specify the fields that you want the division to return from the dividendTable<Record>DivideByReturningStep. returning(Field<?>... fields)Specify the fields that you want the division to return from the dividendDeleteResultStep<Record>DeleteReturningStep. returningResult(Collection<? extends SelectFieldOrAsterisk> fields)Configure theDELETEstatement to return a list of fields inR.DeleteResultStep<Record>DeleteReturningStep. returningResult(SelectFieldOrAsterisk... fields)Configure theDELETEstatement to return a list of fields inR.InsertResultStep<Record>InsertReturningStep. returningResult(Collection<? extends SelectFieldOrAsterisk> fields)Configure theINSERTstatement to return a list of fields inR.InsertResultStep<Record>InsertReturningStep. returningResult(SelectFieldOrAsterisk... fields)Configure theINSERTstatement to return a list of fields inR.UpdateResultStep<Record>UpdateReturningStep. returningResult(Collection<? extends SelectFieldOrAsterisk> fields)Configure theUPDATEstatement to return a list of fields inR.UpdateResultStep<Record>UpdateReturningStep. returningResult(SelectFieldOrAsterisk... fields)Configure theUPDATEstatement to return a list of fields inR.TablePartitionByStep<Record>Table. rightJoin(String sql)RIGHT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. rightJoin(String sql, Object... bindings)RIGHT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. rightJoin(String sql, QueryPart... parts)RIGHT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. rightJoin(Name name)RIGHT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. rightJoin(SQL sql)RIGHT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. rightJoin(TableLike<?> table)RIGHT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. rightJoin(String sql)RIGHT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. rightJoin(String sql, Object... bindings)RIGHT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. rightJoin(String sql, QueryPart... parts)RIGHT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. rightJoin(Name name)RIGHT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. rightJoin(SQL sql)RIGHT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. rightJoin(TableLike<?> table)RIGHT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. rightOuterJoin(String sql)RIGHT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. rightOuterJoin(String sql, Object... bindings)RIGHT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. rightOuterJoin(String sql, QueryPart... parts)RIGHT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. rightOuterJoin(Name name)RIGHT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. rightOuterJoin(SQL sql)RIGHT OUTER JOINa table to this table.TablePartitionByStep<Record>Table. rightOuterJoin(TableLike<?> table)RIGHT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. rightOuterJoin(String sql)RIGHT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. rightOuterJoin(String sql, Object... bindings)RIGHT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. rightOuterJoin(String sql, QueryPart... parts)RIGHT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. rightOuterJoin(Name name)RIGHT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. rightOuterJoin(SQL sql)RIGHT OUTER JOINa table to this table.TableOnStep<Record>TableOuterJoinStep. rightOuterJoin(TableLike<?> table)RIGHT OUTER JOINa table to this table.SelectSelectStep<Record>DSLContext. select(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL select statement.SelectSelectStep<Record>DSLContext. select(SelectFieldOrAsterisk... fields)Create a new DSL select statement.SelectSelectStep<Record>SelectSelectStep. select(Collection<? extends SelectFieldOrAsterisk> fields)Add additional fields to theSELECTclause of this querySelectSelectStep<Record>SelectSelectStep. select(SelectFieldOrAsterisk... fields)Add additional fields to theSELECTclause of this querySelectSelectStep<Record>WithStep. select(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL select statement.SelectSelectStep<Record>WithStep. select(SelectFieldOrAsterisk... fields)Create a new DSL select statement.SelectSelectStep<Record>DSLContext. selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL select statement.SelectSelectStep<Record>DSLContext. selectDistinct(SelectFieldOrAsterisk... fields)Create a new DSL select statement.SelectSelectStep<Record>WithStep. selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL select statement.SelectSelectStep<Record>WithStep. selectDistinct(SelectFieldOrAsterisk... fields)Create a new DSL select statement.SelectWhereStep<Record>DSLContext. selectFrom(String sql)Create a new DSL select statement, projecting*.SelectWhereStep<Record>DSLContext. selectFrom(String sql, Object... bindings)Create a new DSL select statement, projecting*.SelectWhereStep<Record>DSLContext. selectFrom(String sql, QueryPart... parts)Create a new DSL select statement, projecting*.SelectWhereStep<Record>DSLContext. selectFrom(Name table)Create a new DSL select statement, projecting*.SelectWhereStep<Record>DSLContext. selectFrom(SQL sql)Create a new DSL select statement, projecting*.SelectWhereStep<Record>WithStep. selectFrom(String sql)Create a new DSL select statement, projecting*.SelectWhereStep<Record>WithStep. selectFrom(String sql, Object... bindings)Create a new DSL select statement, projecting*.SelectWhereStep<Record>WithStep. selectFrom(String sql, QueryPart... parts)Create a new DSL select statement, projecting*.SelectWhereStep<Record>WithStep. selectFrom(Name table)Create a new DSL select statement, projecting*.SelectWhereStep<Record>WithStep. selectFrom(SQL sql)Create a new DSL select statement, projecting*.SelectQuery<Record>DSLContext. selectQuery()Create a newSelectQueryTableOnStep<Record>Table. straightJoin(String sql)STRAIGHT_JOINa table to this table.TableOnStep<Record>Table. straightJoin(String sql, Object... bindings)STRAIGHT_JOINa table to this table.TableOnStep<Record>Table. straightJoin(String sql, QueryPart... parts)STRAIGHT_JOINa table to this table.TableOnStep<Record>Table. straightJoin(Name name)STRAIGHT_JOINa table to this table.TableOnStep<Record>Table. straightJoin(SQL sql)STRAIGHT_JOINa table to this table.TableOnStep<Record>Table. straightJoin(TableLike<?> table)STRAIGHT_JOINa table to this table.TruncateIdentityStep<Record>DSLContext. truncate(String table)Create a new DSL truncate statement.TruncateIdentityStep<Record>DSLContext. truncate(Name table)Create a new DSL truncate statement.TruncateIdentityStep<Record>DSLContext. truncateTable(String table)Create a new DSL truncate statement.TruncateIdentityStep<Record>DSLContext. truncateTable(Name table)Create a new DSL truncate statement.Table<Record>TableOnStep. using(Collection<? extends Field<?>> fields)Join a table with theUSING(column [, column...])syntax.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 ConditionBetweenAndStepN. and(Record maxValue)Create a condition to check this field against some boundsBetweenAndStepNRowN. between(Record minValue)Check if this row value expression is within a range of two records.ConditionRowN. between(Record minValue, Record maxValue)Check if this row value expression is within a range of two records.BetweenAndStepNRowN. betweenSymmetric(Record minValue)Check if this row value expression is within a symmetric range of two records.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).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.ConditionRowN. eq(Record record)Compare this row value expression with a record for equality.ConditionRowN. equal(Record record)Compare this row value expression with a record for equality.Result<R>ForeignKey. fetchChildren(O... records)Fetch child records of a given set of records through this foreign keyResult<O>ForeignKey. fetchParents(R... records)Fetch parent records of a given set of record through this foreign keyField<T>Field. field(Record record)The inverse operation offield(Field).Record1<T>Field. from(Record record)The inverse operation ofinto(Field).RTable. from(Record record)The inverse operation ofinto(Table).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).ConditionRowN. greaterOrEqual(Record record)Compare this row value expression with a record for order.ConditionRowN. greaterThan(Record record)Compare this row value expression with a record for order.ConditionRowN. gt(Record record)Compare this row value expression with a record for order.ConditionRowN. in(Record... record)Compare this row value expression with a set of records for equality.ConditionRowN. isDistinctFrom(Record record)Compare this row value expression with another row value expression for distinctness.ConditionRowN. isNotDistinctFrom(Record record)Compare this row value expression with another row value expression for distinctness.ConditionRowN. le(Record record)Compare this row value expression with a record for order.ConditionRowN. lessOrEqual(Record record)Compare this row value expression with a record for order.ConditionRowN. lessThan(Record record)Compare this row value expression with a record for order.LoaderRowsStep<R>LoaderSourceStep. loadRecords(Record... records)Load in-memory data.ConditionRowN. lt(Record record)Compare this row value expression with a record for order.ConditionRowN. ne(Record record)Compare this row value expression with a record for non-equality.BetweenAndStepNRowN. notBetween(Record minValue)Check if this row value expression is within a range of two records.ConditionRowN. notBetween(Record minValue, Record maxValue)Check if this row value expression is within a range of two records.BetweenAndStepNRowN. notBetweenSymmetric(Record minValue)Check if this row value expression is not within a symmetric range of two records.ConditionRowN. notBetweenSymmetric(Record minValue, Record maxValue)Check if this row value expression is not within a symmetric range of two records.ConditionRowN. notEqual(Record record)Compare this row value expression with a record for non-equalityConditionRowN. notIn(Record... record)Compare this row value expression with a set of records for non-equality.TField. original(Record record)The inverse operation oforiginal(Field).voidExecuteContext. record(Record record)Calling this has no effect.voidField. reset(Record record)The inverse operation ofreset(Field).InsertOnDuplicateSetMoreStep<R>InsertOnDuplicateSetStep. set(Record record)Set multiple values forUPDATEin theINSERTstatement'sON DUPLICATE KEY UPDATEorON CONFLICT ...InsertSetMoreStep<R>InsertSetMoreStep. set(Record record)Set values in theINSERTstatement.InsertSetMoreStep<R>InsertSetStep. set(Record record)Set values in theINSERTstatement.MergeMatchedSetMoreStep<R>MergeMatchedSetStep. set(Record record)Set multiple values forUPDATEin theMERGEstatement'sWHEN MATCHEDclause.MergeNotMatchedSetMoreStep<R>MergeNotMatchedSetStep. set(Record record)Set multiple values forINSERTin theMERGEstatement'sWHEN NOT MATCHEDclause.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 ConditionRowN. compare(Comparator comparator, QuantifiedSelect<? extends Record> select)Compare this row value expression with a subselect using a dynamic comparator.ConditionRowN. compare(Comparator comparator, Select<? extends Record> select)Compare this row value expression with a subselect using a dynamic comparator.ConditionRowN. eq(QuantifiedSelect<? extends Record> select)Compare this row value expression with a subselect for equality.ConditionRowN. eq(Select<? extends Record> select)Compare this row value expression with a subselect for equality.ConditionRowN. equal(QuantifiedSelect<? extends Record> select)Compare this row value expression with a subselect for equality.ConditionRowN. equal(Select<? extends Record> select)Compare this row value expression with a subselect for equality.ConditionRowN. ge(QuantifiedSelect<? extends Record> select)Compare this row value expression with a subselect for order.ConditionRowN. ge(Select<? extends Record> select)Compare this row value expression with a subselect for order.ConditionRowN. greaterOrEqual(QuantifiedSelect<? extends Record> select)Compare this row value expression with a subselect for order.ConditionRowN. greaterOrEqual(Select<? extends Record> select)Compare this row value expression with a subselect for order.ConditionRowN. greaterThan(QuantifiedSelect<? extends Record> select)Compare this row value expression with a subselect for order.ConditionRowN. greaterThan(Select<? extends Record> select)Compare this row value expression with a subselect for order.ConditionRowN. gt(QuantifiedSelect<? extends Record> select)Compare this row value expression with a subselect for order.ConditionRowN. gt(Select<? extends Record> select)Compare this row value expression with a subselect for order.ConditionRowN. in(Result<? extends Record> result)Compare this row value expression with a set of records for equality.ConditionRowN. in(Select<? extends Record> select)Compare this row value expression with a subselect for equality.ConditionRowN. le(QuantifiedSelect<? extends Record> select)Compare this row value expression with a subselect for order.ConditionRowN. le(Select<? extends Record> select)Compare this row value expression with a subselect for order.ConditionRowN. lessOrEqual(QuantifiedSelect<? extends Record> select)Compare this row value expression with a subselect for order.ConditionRowN. lessOrEqual(Select<? extends Record> select)Compare this row value expression with a subselect for order.ConditionRowN. lessThan(QuantifiedSelect<? extends Record> select)Compare this row value expression with a subselect for order.ConditionRowN. lessThan(Select<? extends Record> select)Compare this row value expression with a subselect for order.LoaderRowsStep<R>LoaderSourceStep. loadRecords(Iterable<? extends Record> records)Load in-memory data.LoaderRowsStep<R>LoaderSourceStep. loadRecords(Iterator<? extends Record> records)Load in-memory data.LoaderRowsStep<R>LoaderSourceStep. loadRecords(Stream<? extends Record> records)Load in-memory data.ConditionRowN. lt(QuantifiedSelect<? extends Record> select)Compare this row value expression with a subselect for order.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.ConditionRowN. ne(QuantifiedSelect<? extends Record> select)Compare this row value expression with a subselect for non-equality.ConditionRowN. ne(Select<? extends Record> select)Compare this row value expression with a subselect for non-equality.ConditionRowN. notEqual(QuantifiedSelect<? extends Record> select)Compare this row value expression with a subselect for non-equality.ConditionRowN. notEqual(Select<? extends Record> select)Compare this row value expression with a subselect for non-equality.ConditionRowN. notIn(Result<? extends Record> result)Compare this row value expression with a set of records for equality.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>
QuantifiedSelect<R>DSL. all(Select<R> select)Create anALLquantified select to be used in quantified comparison predicate expressions.static <R extends Record>
QuantifiedSelect<R>DSL. any(Select<R> select)Create anANYquantified select to be used in quantified comparison predicate expressions.static <R extends Record>
Check<R>Internal. createCheck(Table<R> table, Name name, String condition)Factory method for check constraints.static <R extends Record>
Check<R>Internal. createCheck(Table<R> table, Name name, String condition, boolean enforced)Factory method for check constraints.static <R extends Record,T extends Record>
TableField<R,T>Internal. createEmbeddable(Name name, Class<T> recordType, Table<R> table, TableField<R,?>... fields)Factory method for embeddable types.static <R extends Record,T extends Record>
TableField<R,T>Internal. createEmbeddable(Name name, Class<T> 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>
ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>... fields)Factory method for foreign keys.static <R extends Record,U extends Record>
ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>... fields)Factory method for foreign keys.static <R extends Record,U extends Record>
ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>[] fields, boolean enforced)Factory method for foreign keys.static <R extends Record,U extends Record>
ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>[] fields, boolean enforced)Factory method for foreign keys.static <R extends Record,U extends Record>
ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R,?>... fields)Factory method for foreign keys.static <R extends Record,U extends Record>
ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R,?>... fields)Factory method for foreign keys.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>
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>
UniqueKey<R>Internal. createUniqueKey(Table<R> table, String name, TableField<R,?>... fields)Factory method for unique keys.static <R extends Record>
UniqueKey<R>Internal. createUniqueKey(Table<R> table, String name, TableField<R,?>[] fields, boolean enforced)Factory method for unique keys.static <R extends Record>
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>
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>
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)<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>
InsertSetStep<R>DSL. insertInto(Table<R> into)Create a new DSL insert statement.static <R extends Record>
InsertValuesStepN<R>DSL. insertInto(Table<R> into, Collection<? extends Field<?>> fields)Create a new DSL insert statement.static <R extends Record>
InsertValuesStepN<R>DSL. insertInto(Table<R> into, Field<?>... fields)Create a new DSL insert statement.static <R extends Record,T1>
InsertValuesStep1<R,T1>DSL. insertInto(Table<R> into, Field<T1> field1)Create a new DSL insert statement.static <R extends Record,T1,T2>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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)<R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)<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)<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)<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)<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)<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)<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)<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)<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)<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)<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)<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)<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)<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)<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)<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)<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)<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)<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)<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)<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)static <R extends Record>
MergeUsingStep<R>DSL. mergeInto(Table<R> table)Create a new DSL SQL standard MERGE statement.static <R extends Record>
MergeKeyStepN<R>DSL. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)Create a new DSL merge statement (H2-specific syntax).static <R extends Record>
MergeKeyStepN<R>DSL. mergeInto(Table<R> table, Field<?>... fields)Create a new DSL merge statement (H2-specific syntax).static <R extends Record,T1>
MergeKeyStep1<R,T1>DSL. mergeInto(Table<R> table, Field<T1> field1)static <R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)static <R extends Record,T1,T2,T3>
MergeKeyStep3<R,T1,T2,T3>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)static <R extends Record,T1,T2,T3,T4>
MergeKeyStep4<R,T1,T2,T3,T4>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)static <R extends Record,T1,T2,T3,T4,T5>
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)static <R extends Record,T1,T2,T3,T4,T5,T6>
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)static <R extends Record,T1,T2,T3,T4,T5,T6,T7>
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)static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
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)static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
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)static <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>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)static <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>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)static <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>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)static <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>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)static <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>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)static <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>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)static <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>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)static <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>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)static <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>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)static <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>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)static <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>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)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>
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)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>
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)<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>
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>
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>
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>
Table<R>DSL. table(R record)Use a previously obtained record as a new Tablestatic <R extends Record>
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>
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>
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>
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 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> RecordType<Record>DSL. recordType(Collection<? extends Field<?>> fields)Create aRecordTypeof an arbitrary degree.static <T1> 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 ResultQuery<Record>DSL. resultQuery(String sql)Create a new query holding plain SQL.static ResultQuery<Record>DSL. resultQuery(String sql, Object... bindings)Create a new query holding plain SQL.static ResultQuery<Record>DSL. resultQuery(String sql, QueryPart... parts)Create a new query holding plain SQL.static ResultQuery<Record>DSL. resultQuery(SQL sql)Create a new query holding plain SQL.static Field<Record>DSL. rowField(RowN row)EXPERIMENTAL: Turn a row value expression of arbitrary degree into aField.static 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 SelectSelectStep<Record>DSL. select(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL subselect statement.static 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 SelectSelectStep<Record>DSL. selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL subselect statement.static 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 SelectWhereStep<Record>DSL. selectFrom(String sql)Create a new DSL select statement, projecting*.static SelectWhereStep<Record>DSL. selectFrom(String sql, Object... bindings)Create a new DSL select statement, projecting*.static SelectWhereStep<Record>DSL. selectFrom(String sql, QueryPart... parts)Create a new DSL select statement, projecting*.static SelectWhereStep<Record>DSL. selectFrom(Name table)Create a new DSL select statement, projecting*.static SelectWhereStep<Record>DSL. selectFrom(SQL sql)Create a new DSL select statement, projecting*.SelectQuery<Record>DefaultDSLContext. selectQuery()static Table<Record>DSL. table(String sql)A custom SQL clause that can render arbitrary table expressions.static Table<Record>DSL. table(String sql, Object... bindings)A custom SQL clause that can render arbitrary table expressions.static Table<Record>DSL. table(String sql, QueryPart... parts)A custom SQL clause that can render arbitrary table expressions.static Table<Record>DSL. table(Name name)Create a qualified table, given its table name.static Table<Record>DSL. table(Name name, Comment comment)Create a qualified table, given its table name.static Table<Record>DSL. table(SQL sql)A custom SQL clause that can render arbitrary table expressions.static 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 TruncateIdentityStep<Record>DSL. truncate(String table)Create a new DSL truncate statement.static 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 TruncateIdentityStep<Record>DSL. truncateTable(String table)Create a new DSL truncate statement.static TruncateIdentityStep<Record>DSL. truncateTable(Name table)Create a new DSL truncate statement.static 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 ConditionDSL. condition(Record record)static <R extends Record>
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 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.
-