| Package | Description | 
|---|---|
| org.jooq | 
 The  
org.jooq package contains jOOQ's public API. | 
| org.jooq.impl | 
 The  
org.jooq.impl package contains jOOQ's implementation classes. | 
| org.jooq.util.h2 | 
 The  
org.jooq.util.ase package contains classes related to the
 SQLDialect.H2 dialect. | 
| org.jooq.util.hsqldb | 
 The  
org.jooq.util.ase package contains classes related to the
 SQLDialect.HSQLDB dialect. | 
| org.jooq.util.oracle | 
 The  
org.jooq.util.ase package contains classes related to the
 SQLDialect.ORACLE dialect. | 
| org.jooq.util.postgres | 
 The  
org.jooq.util.ase package contains classes related to the
 SQLDialect.POSTGRES dialect. | 
| Modifier and Type | Interface and Description | 
|---|---|
interface  | 
CommonTableExpression<R extends Record>
A common table expression is a table that can be supplied to
  
WITH clauses. | 
interface  | 
Cursor<R extends Record>
Cursors allow for lazy, sequential access to an underlying JDBC
  
ResultSet. | 
interface  | 
Delete<R extends Record>
A  
Query that can delete data in the database. | 
interface  | 
DeleteConditionStep<R extends Record>
This type is used for the  
Delete's DSL API. | 
interface  | 
DeleteFinalStep<R extends Record>
This type is used for the  
Delete's DSL API. | 
interface  | 
DeleteQuery<R extends Record>
A query used for deletion of data 
 | 
interface  | 
DeleteWhereStep<R extends Record>
This type is used for the  
Delete's DSL API. | 
interface  | 
ForeignKey<R extends Record,O extends Record>
A  
ForeignKey is an object referencing a UniqueKey. | 
interface  | 
ForeignKey<R extends Record,O extends Record>
A  
ForeignKey is an object referencing a UniqueKey. | 
interface  | 
FutureResult<R extends Record>
Deprecated. 
 
- 3.2.0 - [#2581] - This type will be removed in jOOQ 4.0 
 | 
interface  | 
Identity<R extends Record,T>
An  
Identity is an object representing an IDENTITY
 column as understood by the SQL:2003 standard. | 
interface  | 
Insert<R extends Record>
A  
Query that can insert data in the database. | 
interface  | 
InsertFinalStep<R extends Record>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertOnDuplicateSetMoreStep<R extends Record>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertOnDuplicateSetStep<R extends Record>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertOnDuplicateStep<R extends Record>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertQuery<R extends Record>
A query for data insertion 
 | 
interface  | 
InsertResultStep<R extends Record>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertReturningStep<R extends Record>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertSetMoreStep<R extends Record>
This type is used for the  
Insert's alternative DSL API. | 
interface  | 
InsertSetStep<R extends Record>
This type is used for the  
Insert's alternative DSL API. | 
interface  | 
InsertValuesStep1<R extends Record,T1>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep2<R extends Record,T1,T2>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep3<R extends Record,T1,T2,T3>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep4<R extends Record,T1,T2,T3,T4>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep5<R extends Record,T1,T2,T3,T4,T5>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
This type is used for the  
Insert's DSL API. | 
interface  | 
InsertValuesStepN<R extends Record>
This type is used for the  
Insert's DSL API. | 
interface  | 
Key<R extends Record>
A  
Key is an object representing a UNIQUE KEY, a
 PRIMARY KEY, or a FOREIGN KEY. | 
interface  | 
Merge<R extends Record>
A  
Query that can merge data in the database. | 
interface  | 
MergeFinalStep<R extends Record>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeKeyStep1<R extends Record,T1>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeKeyStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeKeyStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeKeyStep12<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 the  
Merge's DSL API. | 
interface  | 
MergeKeyStep13<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 the  
Merge's DSL API. | 
interface  | 
MergeKeyStep14<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 the  
Merge's DSL API. | 
interface  | 
MergeKeyStep15<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 the  
Merge's DSL API. | 
interface  | 
MergeKeyStep16<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 the  
Merge's DSL API. | 
interface  | 
MergeKeyStep17<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 the  
Merge's DSL API. | 
interface  | 
MergeKeyStep18<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 the  
Merge's DSL API. | 
interface  | 
MergeKeyStep19<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 the  
Merge's DSL API. | 
interface  | 
MergeKeyStep2<R extends Record,T1,T2>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeKeyStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeKeyStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeKeyStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeKeyStep3<R extends Record,T1,T2,T3>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeKeyStep4<R extends Record,T1,T2,T3,T4>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeKeyStep5<R extends Record,T1,T2,T3,T4,T5>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeKeyStep6<R extends Record,T1,T2,T3,T4,T5,T6>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeKeyStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeKeyStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeKeyStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeKeyStepN<R extends Record>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeMatchedDeleteStep<R extends Record>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeMatchedSetMoreStep<R extends Record>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeMatchedSetStep<R extends Record>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeMatchedStep<R extends Record>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeMatchedWhereStep<R extends Record>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedSetMoreStep<R extends Record>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedSetStep<R extends Record>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedStep<R extends Record>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep1<R extends Record,T1>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep2<R extends Record,T1,T2>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep3<R extends Record,T1,T2,T3>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep4<R extends Record,T1,T2,T3,T4>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep5<R extends Record,T1,T2,T3,T4,T5>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedValuesStepN<R extends Record>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeNotMatchedWhereStep<R extends Record>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeOnConditionStep<R extends Record>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeOnStep<R extends Record>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeUsingStep<R extends Record>
This type is used for the  
Merge's DSL API. | 
interface  | 
MergeValuesStep1<R extends Record,T1>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeValuesStep12<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 the  
Merge's DSL API. | 
interface  | 
MergeValuesStep13<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 the  
Merge's DSL API. | 
interface  | 
MergeValuesStep14<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 the  
Merge's DSL API. | 
interface  | 
MergeValuesStep15<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 the  
Merge's DSL API. | 
interface  | 
MergeValuesStep16<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 the  
Merge's DSL API. | 
interface  | 
MergeValuesStep17<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 the  
Merge's DSL API. | 
interface  | 
MergeValuesStep18<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 the  
Merge's DSL API. | 
interface  | 
MergeValuesStep19<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 the  
Merge's DSL API. | 
interface  | 
MergeValuesStep2<R extends Record,T1,T2>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeValuesStep3<R extends Record,T1,T2,T3>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeValuesStep4<R extends Record,T1,T2,T3,T4>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeValuesStep5<R extends Record,T1,T2,T3,T4,T5>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
MergeValuesStepN<R extends Record>
This type is used for the H2-specific variant of the  
Merge's DSL API. | 
interface  | 
QuantifiedSelect<R extends Record>
A participant of a quantified comparison predicate
 
 A  
QuantifiedSelect models the right hand side of a quantified
 comparison predicate. | 
interface  | 
RecordHandler<R extends Record>
A  
RecordHandler is a handler that can receive Record
 objects, when fetching data from the database. | 
interface  | 
RecordMapper<R extends Record,E>
A  
RecordMapper is a mapper that can receive Record
 objects, when fetching data from the database, transforming them into a
 custom type <E> | 
interface  | 
RecordType<R extends Record>
 | 
interface  | 
Result<R extends Record>
A wrapper for database results returned by  
 | 
interface  | 
ResultQuery<R extends Record>
A query that can return results. 
 | 
interface  | 
Select<R extends Record>
 | 
interface  | 
SelectConditionStep<R extends Record>
 | 
interface  | 
SelectConnectByConditionStep<R extends Record>
 | 
interface  | 
SelectConnectByStep<R extends Record>
 | 
interface  | 
SelectFinalStep<R extends Record>
 | 
interface  | 
SelectForUpdateOfStep<R extends Record>
 | 
interface  | 
SelectForUpdateStep<R extends Record>
 | 
interface  | 
SelectForUpdateWaitStep<R extends Record>
 | 
interface  | 
SelectFromStep<R extends Record>
 | 
interface  | 
SelectGroupByStep<R extends Record>
 | 
interface  | 
SelectHavingConditionStep<R extends Record>
 | 
interface  | 
SelectHavingStep<R extends Record>
 | 
interface  | 
SelectJoinPartitionByStep<R extends Record>
 | 
interface  | 
SelectJoinStep<R extends Record>
 | 
interface  | 
SelectLimitStep<R extends Record>
 | 
interface  | 
SelectOffsetStep<R extends Record>
 | 
interface  | 
SelectOnConditionStep<R extends Record>
 | 
interface  | 
SelectOnStep<R extends Record>
 | 
interface  | 
SelectOptionalOnStep<R extends Record>
 | 
interface  | 
SelectOptionStep<R extends Record>
 | 
interface  | 
SelectOrderByStep<R extends Record>
 | 
interface  | 
SelectQuery<R extends Record>
A query for data selection 
 | 
interface  | 
SelectSeekLimitStep<R extends Record>
 | 
interface  | 
SelectSeekStep1<R extends Record,T1>
 | 
interface  | 
SelectSeekStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
 | 
interface  | 
SelectSeekStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
 | 
interface  | 
SelectSeekStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
 | 
interface  | 
SelectSeekStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
 | 
interface  | 
SelectSeekStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
 | 
interface  | 
SelectSeekStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
 | 
interface  | 
SelectSeekStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
 | 
interface  | 
SelectSeekStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
 | 
interface  | 
SelectSeekStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
 | 
interface  | 
SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
 | 
interface  | 
SelectSeekStep2<R extends Record,T1,T2>
 | 
interface  | 
SelectSeekStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
 | 
interface  | 
SelectSeekStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
 | 
interface  | 
SelectSeekStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
 | 
interface  | 
SelectSeekStep3<R extends Record,T1,T2,T3>
 | 
interface  | 
SelectSeekStep4<R extends Record,T1,T2,T3,T4>
 | 
interface  | 
SelectSeekStep5<R extends Record,T1,T2,T3,T4,T5>
 | 
interface  | 
SelectSeekStep6<R extends Record,T1,T2,T3,T4,T5,T6>
 | 
interface  | 
SelectSeekStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
 | 
interface  | 
SelectSeekStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
 | 
interface  | 
SelectSeekStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
 | 
interface  | 
SelectSeekStepN<R extends Record>
 | 
interface  | 
SelectSelectStep<R extends Record>
 | 
interface  | 
SelectStartWithStep<R extends Record>
 | 
interface  | 
SelectWhereStep<R extends Record>
 | 
interface  | 
SelectWindowStep<R extends Record>
 | 
interface  | 
StoreQuery<R extends Record>
A query storing objects to the database. 
 | 
interface  | 
Table<R extends Record>
A table to be used in queries 
 | 
interface  | 
TableField<R extends Record,T>
A field contained in a table 
 | 
interface  | 
TableLike<R extends Record>
An object that can behave like a table (a table-like object) 
 | 
interface  | 
Truncate<R extends Record>
A  
Query that can truncate a table in the database. | 
interface  | 
TruncateCascadeStep<R extends Record>
A  
Query that can truncate a table in the database. | 
interface  | 
TruncateFinalStep<R extends Record>
A  
Query that can truncate a table in the database. | 
interface  | 
TruncateIdentityStep<R extends Record>
A  
Query that can truncate a table in the database. | 
interface  | 
UniqueKey<R extends Record>
A  
UniqueKey is an object representing a UNIQUE KEY
 or a PRIMARY KEY. | 
interface  | 
Update<R extends Record>
A  
Query that can update data in the database. | 
interface  | 
UpdateConditionStep<R extends Record>
This type is used for the  
Update's DSL API. | 
interface  | 
UpdateFinalStep<R extends Record>
This type is used for the  
Update's DSL API. | 
interface  | 
UpdateFromStep<R extends Record>
This type is used for the  
Update's DSL API. | 
interface  | 
UpdateQuery<R extends Record>
A query for data updating 
 | 
interface  | 
UpdateResultStep<R extends Record>
This type is used for the  
Update's DSL API. | 
interface  | 
UpdateReturningStep<R extends Record>
This type is used for the  
Update's DSL API. | 
interface  | 
UpdateSetFirstStep<R extends Record>
This type is used for the  
Update's DSL API. | 
interface  | 
UpdateSetMoreStep<R extends Record>
This type is used for the  
Update's DSL API. | 
interface  | 
UpdateSetStep<R extends Record>
This type is used for the  
Update's DSL API. | 
interface  | 
UpdateWhereStep<R extends Record>
This type is used for the  
Update's DSL API. | 
interface  | 
VersionsBetweenAndStep<R extends Record,T>
This type is used for the Oracle  
VERSIONS clause DSL API,
 providing access to the flashback versions query clauses. | 
| Modifier and Type | Interface and Description | 
|---|---|
interface  | 
Record1<T1>
A model type for a records with degree  
1 | 
interface  | 
Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
A model type for a records with degree  
10 | 
interface  | 
Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
A model type for a records with degree  
11 | 
interface  | 
Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
A model type for a records with degree  
12 | 
interface  | 
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
A model type for a records with degree  
13 | 
interface  | 
Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
A model type for a records with degree  
14 | 
interface  | 
Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
A model type for a records with degree  
15 | 
interface  | 
Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
A model type for a records with degree  
16 | 
interface  | 
Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
A model type for a records with degree  
17 | 
interface  | 
Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
A model type for a records with degree  
18 | 
interface  | 
Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
A model type for a records with degree  
19 | 
interface  | 
Record2<T1,T2>
A model type for a records with degree  
2 | 
interface  | 
Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
A model type for a records with degree  
20 | 
interface  | 
Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
A model type for a records with degree  
21 | 
interface  | 
Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
A model type for a records with degree  
22 | 
interface  | 
Record3<T1,T2,T3>
A model type for a records with degree  
3 | 
interface  | 
Record4<T1,T2,T3,T4>
A model type for a records with degree  
4 | 
interface  | 
Record5<T1,T2,T3,T4,T5>
A model type for a records with degree  
5 | 
interface  | 
Record6<T1,T2,T3,T4,T5,T6>
A model type for a records with degree  
6 | 
interface  | 
Record7<T1,T2,T3,T4,T5,T6,T7>
A model type for a records with degree  
7 | 
interface  | 
Record8<T1,T2,T3,T4,T5,T6,T7,T8>
A model type for a records with degree  
8 | 
interface  | 
Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
A model type for a records with degree  
9 | 
interface  | 
TableRecord<R extends TableRecord<R>>
A record originating from a single table 
 | 
interface  | 
UDTRecord<R extends UDTRecord<R>>
An object holding data of a UDT 
 | 
interface  | 
UpdatableRecord<R extends UpdatableRecord<R>>
A common interface for records that can be stored back to the database again. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
<R extends Record> | 
Name.as(Select<R> select)
Specify a subselect to refer to by the  
Name to form a common
 table expression. | 
<R extends Record> | 
DerivedColumnList.as(Select<R> select)
Specify a subselect to refer to by the  
DerivedColumnList to
 form a common table expression. | 
<R extends Record> | 
WithStep.delete(Table<R> table)
Create a new DSL delete statement. 
 | 
<R extends Record> | 
DSLContext.delete(Table<R> table)
Create a new DSL delete statement. 
 | 
<R extends Record> | 
DSLContext.deleteQuery(Table<R> table)
Create a new  
DeleteQuery | 
<R extends Record> | 
DSLContext.fetch(ResultQuery<R> query)
Execute a  
ResultQuery in the context of this DSLContext and return
 results. | 
<R extends Record> | 
DSLContext.fetch(Table<R> table)
Execute and return all records for
  
SELECT * FROM [table]. | 
<R extends Record> | 
DSLContext.fetch(Table<R> table,
     Condition condition)
Execute and return all records for
  
SELECT * FROM [table] WHERE [condition] . | 
<R extends Record> | 
DSLContext.fetchAny(Table<R> table)
Execute and return zero or one record for
  
SELECT * FROM [table] LIMIT 1. | 
<R extends Record> | 
DSLContext.fetchAny(Table<R> table,
        Condition condition)
Execute and return zero or one record for
  
SELECT * FROM [table] WHERE [condition] LIMIT 1. | 
<Z extends Record> | 
ResultQuery.fetchAnyInto(Table<Z> table)
Map resulting records onto a custom record. 
 | 
<Z extends Record> | 
ResultQuery.fetchInto(Table<Z> table)
Map resulting records onto a custom record. 
 | 
<Z extends Record> | 
Cursor.fetchInto(Table<Z> table)
Map resulting records onto a custom record. 
 | 
<R extends Record> | 
DSLContext.fetchLazy(ResultQuery<R> query)
Execute a  
ResultQuery in the context of this DSLContext and return
 a cursor. | 
<R extends Record> | 
DSLContext.fetchLazy(Table<R> table)
Execute and return all records lazily for
  
SELECT * FROM [table]. | 
<R extends Record> | 
DSLContext.fetchLazy(Table<R> table,
         Condition condition)
Execute and return all records lazily for
  
SELECT * FROM [table] WHERE [condition] . | 
<R extends Record> | 
DSLContext.fetchMany(ResultQuery<R> query)
Execute a  
ResultQuery in the context of this DSLContext and return
 a cursor. | 
<R extends Record> | 
DSLContext.fetchOne(ResultQuery<R> query)
Execute a  
ResultQuery in the context of this DSLContext and return
 a record. | 
<R extends Record> | 
DSLContext.fetchOne(Table<R> table)
Execute and return zero or one record for
  
SELECT * FROM [table]. | 
<R extends Record> | 
DSLContext.fetchOne(Table<R> table,
        Condition condition)
Execute and return zero or one record for
  
SELECT * FROM [table] WHERE [condition] . | 
<Z extends Record> | 
ResultQuery.fetchOneInto(Table<Z> table)
Map resulting records onto a custom record. 
 | 
<Z extends Record> | 
Cursor.fetchOneInto(Table<Z> table)
Map the next resulting record onto a custom record. 
 | 
<O extends Record> | 
Table.getReferencesFrom(Table<O> other)
Get a list of  
FOREIGN KEY's of a specific table, referencing
 a this table. | 
<O extends Record> | 
Table.getReferencesTo(Table<O> other)
Get a list of  
FOREIGN KEY's of this table, referencing a
 specific table. | 
<R extends Record> | 
WithStep.insertInto(Table<R> into)
Create a new DSL insert statement. 
 | 
<R extends Record> | 
DSLContext.insertInto(Table<R> into)
Create a new DSL insert statement. 
 | 
<R extends Record> | 
WithStep.insertInto(Table<R> into,
          Collection<? extends Field<?>> fields)
Create a new DSL insert statement. 
 | 
<R extends Record> | 
DSLContext.insertInto(Table<R> into,
          Collection<? extends Field<?>> fields)
Create a new DSL insert statement. 
 | 
<R extends Record> | 
WithStep.insertInto(Table<R> into,
          Field<?>... fields)
Create a new DSL insert statement. 
 | 
<R extends Record> | 
DSLContext.insertInto(Table<R> into,
          Field<?>... fields)
Create a new DSL insert statement. 
 | 
<R extends Record,T1> | 
WithStep.insertInto(Table<R> into,
          Field<T1> field1)
Create a new DSL insert statement. 
 | 
<R extends Record,T1> | 
DSLContext.insertInto(Table<R> into,
          Field<T1> field1)
Create a new DSL insert statement. 
 | 
<R extends Record,T1,T2> | 
WithStep.insertInto(Table<R> into,
          Field<T1> field1,
          Field<T2> field2)
Create a new DSL insert statement. 
 | 
<R extends Record,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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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> | 
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,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> | 
DSLContext.insertQuery(Table<R> into)
Create a new  
InsertQuery | 
<R extends Record> | 
Record.into(Table<R> table)
Map resulting records onto a custom record type. 
 | 
<Z extends Record> | 
Result.into(Table<Z> table)
Map resulting records onto a custom record. 
 | 
<R extends Record> | 
SchemaMapping.map(Table<R> table)
Deprecated.  
Apply mapping to a given table 
 | 
<R extends Record> | 
DSLContext.map(Table<R> table)
Map a table to another one. 
 | 
<R extends Record> | 
WithStep.mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement. 
 | 
<R extends Record> | 
DSLContext.mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement. 
 | 
<R extends Record> | 
WithStep.mergeInto(Table<R> table,
         Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record> | 
DSLContext.mergeInto(Table<R> table,
         Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record> | 
WithStep.mergeInto(Table<R> table,
         Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record> | 
DSLContext.mergeInto(Table<R> table,
         Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,T1> | 
WithStep.mergeInto(Table<R> table,
         Field<T1> field1)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,T1> | 
DSLContext.mergeInto(Table<R> table,
         Field<T1> field1)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,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> | 
DSLContext.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> | 
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> | 
DSLContext.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> | 
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> | 
DSLContext.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> | 
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> | 
DSLContext.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> | 
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> | 
DSLContext.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> | 
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> | 
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)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,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> | 
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)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,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> | 
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)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,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> | 
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)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,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> | 
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)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,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> | 
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)
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> | 
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> | 
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)
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> | 
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> | 
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)
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> | 
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> | 
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)
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> | 
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> | 
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)
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> | 
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> | 
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)
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> | 
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> | 
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)
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> | 
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> | 
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)
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> | 
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> | 
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)
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> | 
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> | 
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)
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> | 
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,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)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record> | 
DSLContext.newRecord(Table<R> table)
Create a new  
Record that can be inserted into the corresponding
 table. | 
<R extends Record> | 
DSLContext.newRecord(Table<R> table,
         Object source)
Create a new pre-filled  
Record that can be inserted into the
 corresponding table. | 
<R extends Record> | 
DSLContext.newResult(Table<R> table)
Create a new empty  
Result. | 
<R extends Record,E> | 
RecordMapperProvider.provide(RecordType<R> recordType,
       Class<? extends E> type)
Provide a  
RecordMapper instance. | 
<R extends Record> | 
WithStep.selectFrom(Table<R> table)
Create a new DSL select statement. 
 | 
<R extends Record> | 
DSLContext.selectFrom(Table<R> table)
Create a new DSL select statement. 
 | 
<R extends Record> | 
DSLContext.selectQuery(TableLike<R> table)
Create a new  
SelectQuery | 
<R extends Record> | 
DSLContext.truncate(Table<R> table)
Create a new DSL truncate statement. 
 | 
<R extends Record> | 
WithStep.update(Table<R> table)
Create a new DSL update statement. 
 | 
<R extends Record> | 
DSLContext.update(Table<R> table)
Create a new DSL update statement. 
 | 
<R extends Record> | 
DSLContext.updateQuery(Table<R> table)
Create a new  
UpdateQuery | 
| Modifier and Type | Method and Description | 
|---|---|
Record[] | 
RecordContext.batchRecords()
The  
Record(s) that are being manipulated in batch mode. | 
Record | 
DSLContext.fetchOne(ResultSet rs)
 | 
Record | 
DSLContext.fetchOne(ResultSet rs,
        Class<?>... types)
 | 
Record | 
DSLContext.fetchOne(ResultSet rs,
        DataType<?>... types)
 | 
Record | 
DSLContext.fetchOne(ResultSet rs,
        Field<?>... fields)
 | 
Record | 
DSLContext.fetchOne(String sql)
Execute a new query holding plain SQL. 
 | 
Record | 
DSLContext.fetchOne(String sql,
        Object... bindings)
Execute a new query holding plain SQL. 
 | 
Record | 
DSLContext.fetchOne(String sql,
        QueryPart... parts)
Execute a new query holding plain SQL. 
 | 
Record | 
UpdatableRecord.key()
A Record copy holding values for the  
Table.getPrimaryKey(). | 
Record | 
DSLContext.newRecord(Field<?>... fields)
Create a new empty  
Record. | 
Record | 
Record.original()
Get this record containing the original values as fetched from the
 database. 
 | 
Record | 
RecordContext.record()
The  
Record that is being manipulated. | 
Record | 
ExecuteContext.record()
The last record that was fetched from the result set, or
  
null if no record has been fetched. | 
| Modifier and Type | Method and Description | 
|---|---|
Table<Record> | 
Table.crossApply(String sql)
CROSS APPLY a table to this table. | 
Table<Record> | 
Table.crossApply(String sql,
          Object... bindings)
CROSS APPLY a table to this table. | 
Table<Record> | 
Table.crossApply(String sql,
          QueryPart... parts)
CROSS APPLY a table to this table. | 
Table<Record> | 
Table.crossApply(TableLike<?> table)
CROSS APPLY a table to this table. | 
Table<Record> | 
Table.crossJoin(String sql)
CROSS JOIN a table to this table. | 
Table<Record> | 
Table.crossJoin(String sql,
         Object... bindings)
CROSS JOIN a table to this table. | 
Table<Record> | 
Table.crossJoin(String sql,
         QueryPart... parts)
CROSS JOIN a table to this table. | 
Table<Record> | 
Table.crossJoin(TableLike<?> table)
CROSS JOIN a table to this table. | 
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(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.fetchFromCSV(String string)
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.fetchFromJSON(String string)
Fetch all data from a JSON string. 
 | 
Result<Record> | 
DSLContext.fetchFromStringData(List<String[]> data)
Fetch all data from a list of strings. 
 | 
Result<Record> | 
DSLContext.fetchFromStringData(String[]... data)
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. 
 | 
Map<Record,Result<R>> | 
ResultQuery.fetchGroups(Field<?>[] keys)
Execute the query and return a  
Map with 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 a  
Map with results grouped by the
 given keys and mapped into the given entity type. | 
<E> Map<Record,List<E>> | 
ResultQuery.fetchGroups(Field<?>[] keys,
           RecordMapper<? super R,E> mapper)
Execute the query and return a  
Map with results grouped by the
 given keys and mapped by the given mapper. | 
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(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. 
 | 
List<Result<Record>> | 
ResultQuery.fetchMany()
Execute a query, possibly returning several result sets. 
 | 
<R extends Record> | 
DSLContext.fetchMany(ResultQuery<R> query)
Execute a  
ResultQuery in the context of this DSLContext and return
 a cursor. | 
List<Result<Record>> | 
DSLContext.fetchMany(String sql)
Execute a new query holding plain SQL, possibly returning several result
 sets. 
 | 
List<Result<Record>> | 
DSLContext.fetchMany(String sql,
         Object... bindings)
Execute a new query holding plain SQL, possibly returning several result
 sets. 
 | 
List<Result<Record>> | 
DSLContext.fetchMany(String sql,
         QueryPart... parts)
Execute a new query holding plain SQL, possibly returning several result
 sets. 
 | 
Map<Record,R> | 
ResultQuery.fetchMap(Field<?>[] keys)
Execute the query and return a  
Map with keys as a map key and the
 corresponding record as value. | 
Table<Record> | 
PivotInStep.in(Collection<? extends Field<T>> fields)
Specify the acceptable values for pivoting
 
 This clause is generally only supported by  
SQLDialect.ORACLE. | 
Table<Record> | 
PivotInStep.in(Field<?>... fields)
Specify the acceptable values for pivoting
 
 This clause is generally only supported by  
SQLDialect.ORACLE. | 
Table<Record> | 
PivotInStep.in(T... values)
Specify the acceptable values for pivoting 
 | 
Map<Record,Result<R>> | 
Result.intoGroups(Field<?>[] keys)
Return a  
Map with the result grouped by the given keys. | 
<E> Map<Record,List<E>> | 
Result.intoGroups(Field<?>[] keys,
          Class<? extends E> type)
Return a  
Map with results grouped by the given keys and mapped
 into the given entity type. | 
<E> Map<Record,List<E>> | 
Result.intoGroups(Field<?>[] keys,
          RecordMapper<? super R,E> mapper)
Return a  
Map with results grouped by the given keys and mapped
 into the given entity type. | 
Map<Record,R> | 
Result.intoMap(Field<?>[] keys)
Return a  
Map with the given keys as a map key and the
 corresponding record as value. | 
Table<Record> | 
Table.naturalJoin(String sql)
NATURAL JOIN a table to this table. | 
Table<Record> | 
Table.naturalJoin(String sql,
           Object... bindings)
NATURAL JOIN a table to this table. | 
Table<Record> | 
Table.naturalJoin(String sql,
           QueryPart... parts)
NATURAL JOIN a table to this table. | 
Table<Record> | 
Table.naturalJoin(TableLike<?> table)
NATURAL JOIN a table to this table. | 
Table<Record> | 
Table.naturalLeftOuterJoin(String sql)
NATURAL LEFT OUTER JOIN a table to this table. | 
Table<Record> | 
Table.naturalLeftOuterJoin(String sql,
                    Object... bindings)
NATURAL LEFT OUTER JOIN a table to this table. | 
Table<Record> | 
Table.naturalLeftOuterJoin(String sql,
                    QueryPart... parts)
NATURAL LEFT OUTER JOIN a table to this table. | 
Table<Record> | 
Table.naturalLeftOuterJoin(TableLike<?> table)
NATURAL LEFT OUTER JOIN a table to this table. | 
Table<Record> | 
Table.naturalRightOuterJoin(String sql)
NATURAL RIGHT OUTER JOIN a table to this table. | 
Table<Record> | 
Table.naturalRightOuterJoin(String sql,
                     Object... bindings)
NATURAL RIGHT OUTER JOIN a table to this table. | 
Table<Record> | 
Table.naturalRightOuterJoin(String sql,
                     QueryPart... parts)
NATURAL RIGHT OUTER JOIN a table to this table. | 
Table<Record> | 
Table.naturalRightOuterJoin(TableLike<?> table)
NATURAL RIGHT OUTER JOIN a table to this table. | 
Result<Record> | 
DSLContext.newResult(Field<?>... fields)
Create a new empty  
Record. | 
Table<Record> | 
Table.outerApply(String sql)
OUTER APPLY a table to this table. | 
Table<Record> | 
Table.outerApply(String sql,
          Object... bindings)
OUTER APPLY a table to this table. | 
Table<Record> | 
Table.outerApply(String sql,
          QueryPart... parts)
OUTER APPLY a table to this table. | 
Table<Record> | 
Table.outerApply(TableLike<?> table)
OUTER APPLY a table to this table. | 
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. 
 | 
Table<Record> | 
DivideByReturningStep.returning(Collection<? extends Field<?>> fields)
Specify the fields that you want the division to return from the dividend 
 | 
Table<Record> | 
DivideByReturningStep.returning(Field<?>... fields)
Specify the fields that you want the division to return from the dividend 
 | 
SelectSelectStep<Record> | 
WithStep.select(Collection<? extends Field<?>> fields)
Create a new DSL select statement. 
 | 
SelectSelectStep<Record> | 
SelectSelectStep.select(Collection<? extends Field<?>> fields)
Add additional fields to the  
SELECT clause of this query | 
SelectSelectStep<Record> | 
DSLContext.select(Collection<? extends Field<?>> fields)
Create a new DSL select statement. 
 | 
SelectSelectStep<Record> | 
WithStep.select(Field<?>... fields)
Create a new DSL select statement. 
 | 
SelectSelectStep<Record> | 
SelectSelectStep.select(Field<?>... fields)
Add additional fields to the  
SELECT clause of this query | 
SelectSelectStep<Record> | 
DSLContext.select(Field<?>... fields)
Create a new DSL select statement. 
 | 
SelectSelectStep<Record> | 
WithStep.selectDistinct(Collection<? extends Field<?>> fields)
Create a new DSL select statement. 
 | 
SelectSelectStep<Record> | 
DSLContext.selectDistinct(Collection<? extends Field<?>> fields)
Create a new DSL select statement. 
 | 
SelectSelectStep<Record> | 
WithStep.selectDistinct(Field<?>... fields)
Create a new DSL select statement. 
 | 
SelectSelectStep<Record> | 
DSLContext.selectDistinct(Field<?>... fields)
Create a new DSL select statement. 
 | 
SelectQuery<Record> | 
DSLContext.selectQuery()
Create a new  
SelectQuery | 
Table<Record> | 
TableOnStep.using(Collection<? extends Field<?>> fields)
Join a table with the  
USING(column [, column...]) | 
Table<Record> | 
TableOnStep.using(Field<?>... fields)
Join a table with the  
USING(column [, column...]) | 
| Modifier and Type | Method and Description | 
|---|---|
Condition | 
BetweenAndStepN.and(Record maxValue)
Create a condition to check this field against some bounds 
 | 
BetweenAndStepN | 
RowN.between(Record minValue)
Check if this row value expression is within a range of two records. 
 | 
Condition | 
RowN.between(Record minValue,
       Record maxValue)
Check if this row value expression is within a range of two records. 
 | 
BetweenAndStepN | 
RowN.betweenSymmetric(Record minValue)
Check if this row value expression is within a symmetric range of two
 records. 
 | 
Condition | 
RowN.betweenSymmetric(Record minValue,
                Record maxValue)
Check if this row value expression is within a symmetric range of two
 records. 
 | 
Condition | 
RowN.compare(Comparator comparator,
       Record record)
Compare this row value expression with a record record
 using a dynamic comparator. 
 | 
int | 
Record.compareTo(Record record)
Compares this  
Record with another Record
 according to their natural ordering. | 
Condition | 
RowN.eq(Record record)
Compare this row value expression with a record for equality. 
 | 
Condition | 
RowN.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 key
 
 This returns childs record referencing any record in a given set of
 records through this foreign key 
 | 
Result<O> | 
ForeignKey.fetchParents(R... records)
Fetch parent records of a given set of record through this foreign key
 
 This returns parent records referenced by any record in a given set of
 records through this foreign key. 
 | 
Condition | 
RowN.ge(Record record)
Compare this row value expression with a record for order. 
 | 
Condition | 
RowN.greaterOrEqual(Record record)
Compare this row value expression with a record for order. 
 | 
Condition | 
RowN.greaterThan(Record record)
Compare this row value expression with a record for order. 
 | 
Condition | 
RowN.gt(Record record)
Compare this row value expression with a record for order. 
 | 
Condition | 
RowN.in(Record... record)
Compare this row value expression with a set of records for equality. 
 | 
Condition | 
RowN.le(Record record)
Compare this row value expression with a record for order. 
 | 
Condition | 
RowN.lessOrEqual(Record record)
Compare this row value expression with a record for order. 
 | 
Condition | 
RowN.lessThan(Record record)
Compare this row value expression with a record for order. 
 | 
Condition | 
RowN.lt(Record record)
Compare this row value expression with a record for order. 
 | 
Condition | 
RowN.ne(Record record)
Compare this row value expression with a record for non-equality. 
 | 
BetweenAndStepN | 
RowN.notBetween(Record minValue)
Check if this row value expression is within a range of two records. 
 | 
Condition | 
RowN.notBetween(Record minValue,
          Record maxValue)
Check if this row value expression is within a range of two records. 
 | 
BetweenAndStepN | 
RowN.notBetweenSymmetric(Record minValue)
Check if this row value expression is not within a symmetric range of two
 records. 
 | 
Condition | 
RowN.notBetweenSymmetric(Record minValue,
                   Record maxValue)
Check if this row value expression is not within a symmetric range of two
 records. 
 | 
Condition | 
RowN.notEqual(Record record)
Compare this row value expression with a record for non-equality 
 | 
Condition | 
RowN.notIn(Record... record)
Compare this row value expression with a set of records for non-equality. 
 | 
void | 
ExecuteContext.record(Record record)
Calling this has no effect. 
 | 
UpdateSetMoreStep<R> | 
UpdateSetStep.set(Record record)
Set a value for a field in the  
UPDATE statement. | 
MergeNotMatchedSetMoreStep<R> | 
MergeNotMatchedSetStep.set(Record record)
Set multiple values for  
INSERT in the MERGE
 statement's WHEN NOT MATCHED clause. | 
MergeMatchedSetMoreStep<R> | 
MergeMatchedSetStep.set(Record record)
Set multiple values for  
UPDATE in the MERGE
 statement's WHEN MATCHED clause. | 
InsertSetMoreStep<R> | 
InsertSetStep.set(Record record)
Set values in the  
INSERT statement. | 
InsertSetMoreStep<R> | 
InsertSetMoreStep.set(Record record)
Set values in the  
INSERT statement. | 
InsertOnDuplicateSetMoreStep<R> | 
InsertOnDuplicateSetStep.set(Record record)
Set multiple values for  
UPDATE in the INSERT
 statement's ON DUPLICATE KEY UPDATE clause. | 
| Modifier and Type | Method and Description | 
|---|---|
Condition | 
RowN.eq(Select<? extends Record> select)
Compare this row value expression with a subselect for equality. 
 | 
Condition | 
RowN.equal(Select<? extends Record> select)
Compare this row value expression with a subselect for equality. 
 | 
Condition | 
RowN.ge(Select<? extends Record> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
RowN.greaterOrEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
RowN.greaterThan(Select<? extends Record> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
RowN.gt(Select<? extends Record> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
RowN.in(Select<? extends Record> select)
Compare this row value expression with a subselect for equality. 
 | 
Condition | 
RowN.le(Select<? extends Record> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
RowN.lessOrEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
RowN.lessThan(Select<? extends Record> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
RowN.lt(Select<? extends Record> select)
Compare this row value expression with a subselect for order. 
 | 
<E> E | 
Record.map(RecordMapper<Record,E> mapper)
Map this record into a custom mapper callback. 
 | 
Condition | 
RowN.ne(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality. 
 | 
Condition | 
RowN.notEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality. 
 | 
Condition | 
RowN.notIn(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality. 
 | 
| Modifier and Type | Class and Description | 
|---|---|
class  | 
DefaultRecordMapper<R extends Record,E>
This is the default implementation for  
RecordMapper types. | 
class  | 
TableImpl<R extends Record>
A common base type for tables
 
 This type is for JOOQ INTERNAL USE only. 
 | 
| Modifier and Type | Class and Description | 
|---|---|
class  | 
CustomRecord<R extends TableRecord<R>>
A base class for custom  
TableRecord implementations in client code. | 
class  | 
TableRecordImpl<R extends TableRecord<R>>
A record implementation for a record originating from a single table
 
 This type is for JOOQ INTERNAL USE only. 
 | 
class  | 
UDTRecordImpl<R extends UDTRecord<R>>
A record implementation for a record originating from a single UDT
 
 This type is for JOOQ INTERNAL USE only. 
 | 
class  | 
UpdatableRecordImpl<R extends UpdatableRecord<R>>
A record implementation for a record holding a primary key
 
 This type is for JOOQ INTERNAL USE only. 
 | 
| Modifier and Type | Field and Description | 
|---|---|
static DataType<Result<Record>> | 
SQLDataType.RESULT
The  
ResultSet type. | 
| Modifier and Type | Method and Description | 
|---|---|
static <R extends Record> | 
DSL.all(Select<R> select)
Create an  
ALL quantified select to be used in quantified
 comparison predicate expressions. | 
static <R extends Record> | 
DSL.any(Select<R> select)
Create an  
ANY quantified select to be used in quantified
 comparison predicate expressions. | 
protected static <R extends Record,U extends Record> | 
AbstractKeys.createForeignKey(UniqueKey<U> key,
                Table<R> table,
                TableField<R,?>... fields)
Factory method for foreign keys 
 | 
protected static <R extends Record,U extends Record> | 
AbstractKeys.createForeignKey(UniqueKey<U> key,
                Table<R> table,
                TableField<R,?>... fields)
Factory method for foreign keys 
 | 
protected static <R extends Record,T> | 
AbstractKeys.createIdentity(Table<R> table,
              TableField<R,T> field)
Factory method for identities 
 | 
protected static <R extends Record> | 
AbstractKeys.createUniqueKey(Table<R> table,
               TableField<R,?>... fields)
Factory method for unique keys 
 | 
static <R extends Record> | 
DSL.delete(Table<R> table)
Create a new DSL delete statement. 
 | 
<R extends Record> | 
DefaultDSLContext.delete(Table<R> table)  | 
<R extends Record> | 
DefaultDSLContext.deleteQuery(Table<R> table)  | 
<R extends Record> | 
DefaultDSLContext.fetch(ResultQuery<R> query)  | 
<R extends Record> | 
DefaultDSLContext.fetch(Table<R> table)  | 
<R extends Record> | 
DefaultDSLContext.fetch(Table<R> table,
     Condition condition)  | 
<R extends Record> | 
DefaultDSLContext.fetchAny(Table<R> table)  | 
<R extends Record> | 
DefaultDSLContext.fetchAny(Table<R> table,
        Condition condition)  | 
<R extends Record> | 
DefaultDSLContext.fetchLazy(ResultQuery<R> query)  | 
<R extends Record> | 
DefaultDSLContext.fetchLazy(Table<R> table)  | 
<R extends Record> | 
DefaultDSLContext.fetchLazy(Table<R> table,
         Condition condition)  | 
<R extends Record> | 
DefaultDSLContext.fetchMany(ResultQuery<R> query)  | 
<R extends Record> | 
DefaultDSLContext.fetchOne(ResultQuery<R> query)  | 
<R extends Record> | 
DefaultDSLContext.fetchOne(Table<R> table)  | 
<R extends Record> | 
DefaultDSLContext.fetchOne(Table<R> table,
        Condition condition)  | 
static <R extends Record> | 
DSL.insertInto(Table<R> into)
Create a new DSL insert statement. 
 | 
<R extends Record> | 
DefaultDSLContext.insertInto(Table<R> into)  | 
static <R extends Record> | 
DSL.insertInto(Table<R> into,
          Collection<? extends Field<?>> fields)
Create a new DSL insert statement. 
 | 
<R extends Record> | 
DefaultDSLContext.insertInto(Table<R> into,
          Collection<? extends Field<?>> fields)  | 
static <R extends Record> | 
DSL.insertInto(Table<R> into,
          Field<?>... fields)
Create a new DSL insert statement. 
 | 
<R extends Record> | 
DefaultDSLContext.insertInto(Table<R> into,
          Field<?>... fields)  | 
static <R extends Record,T1> | 
DSL.insertInto(Table<R> into,
          Field<T1> field1)
Create a new DSL insert statement. 
 | 
<R extends Record,T1> | 
DefaultDSLContext.insertInto(Table<R> into,
          Field<T1> field1)  | 
static <R extends Record,T1,T2> | 
DSL.insertInto(Table<R> into,
          Field<T1> field1,
          Field<T2> field2)
Create a new DSL insert statement. 
 | 
<R extends Record,T1,T2> | 
DefaultDSLContext.insertInto(Table<R> into,
          Field<T1> field1,
          Field<T2> field2)  | 
static <R extends Record,T1,T2,T3> | 
DSL.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> | 
DefaultDSLContext.insertInto(Table<R> into,
          Field<T1> field1,
          Field<T2> field2,
          Field<T3> field3)  | 
static <R extends Record,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. 
 | 
<R extends Record,T1,T2,T3,T4> | 
DefaultDSLContext.insertInto(Table<R> into,
          Field<T1> field1,
          Field<T2> field2,
          Field<T3> field3,
          Field<T4> field4)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
static <R extends Record,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. 
 | 
<R extends Record,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)  | 
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> | 
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. 
 | 
<R extends Record,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)  | 
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> | 
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,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)  | 
<R extends Record> | 
DefaultDSLContext.insertQuery(Table<R> into)  | 
static <R extends Record> | 
DSL.lateral(TableLike<R> table)
Create a  
LATERAL joined table. | 
<R extends Record> | 
DefaultDSLContext.map(Table<R> table)  | 
static <R extends Record> | 
DSL.mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement. 
 | 
<R extends Record> | 
DefaultDSLContext.mergeInto(Table<R> table)  | 
static <R extends Record> | 
DSL.mergeInto(Table<R> table,
         Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record> | 
DefaultDSLContext.mergeInto(Table<R> table,
         Collection<? extends Field<?>> fields)  | 
static <R extends Record> | 
DSL.mergeInto(Table<R> table,
         Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record> | 
DefaultDSLContext.mergeInto(Table<R> table,
         Field<?>... fields)  | 
static <R extends Record,T1> | 
DSL.mergeInto(Table<R> table,
         Field<T1> field1)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,T1> | 
DefaultDSLContext.mergeInto(Table<R> table,
         Field<T1> field1)  | 
static <R extends Record,T1,T2> | 
DSL.mergeInto(Table<R> table,
         Field<T1> field1,
         Field<T2> field2)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,T1,T2> | 
DefaultDSLContext.mergeInto(Table<R> table,
         Field<T1> field1,
         Field<T2> field2)  | 
static <R extends Record,T1,T2,T3> | 
DSL.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> | 
DefaultDSLContext.mergeInto(Table<R> table,
         Field<T1> field1,
         Field<T2> field2,
         Field<T3> field3)  | 
static <R extends Record,T1,T2,T3,T4> | 
DSL.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> | 
DefaultDSLContext.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> | 
DSL.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> | 
DefaultDSLContext.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> | 
DSL.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> | 
DefaultDSLContext.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> | 
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)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,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)  | 
static <R extends Record,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)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,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)  | 
static <R extends Record,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)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,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)  | 
static <R extends Record,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)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,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)  | 
static <R extends Record,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)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,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)  | 
static <R extends Record,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)
Create a new DSL merge statement (H2-specific syntax). 
 | 
<R extends Record,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)  | 
static <R extends Record,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)
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> | 
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)  | 
static <R extends Record,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)
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> | 
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)  | 
static <R extends Record,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)
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> | 
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)  | 
static <R extends Record,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)
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> | 
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)  | 
static <R extends Record,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)
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> | 
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)  | 
static <R extends Record,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)
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> | 
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)  | 
static <R extends Record,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)
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> | 
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)  | 
static <R extends Record,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)
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> | 
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)  | 
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> | 
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)
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> | 
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)  | 
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> | 
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)
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> | 
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)  | 
<R extends Record> | 
DefaultDSLContext.newRecord(Table<R> table)  | 
<R extends Record> | 
DefaultDSLContext.newRecord(Table<R> table,
         Object source)  | 
<R extends Record> | 
DefaultDSLContext.newResult(Table<R> table)  | 
<R extends Record,E> | 
DefaultRecordMapperProvider.provide(RecordType<R> rowType,
       Class<? extends E> type)  | 
static <R extends Record> | 
DSL.selectFrom(Table<R> table)
Create a new DSL select statement. 
 | 
<R extends Record> | 
DefaultDSLContext.selectFrom(Table<R> table)  | 
<R extends Record> | 
DefaultDSLContext.selectQuery(TableLike<R> table)  | 
static <R extends Record> | 
DSL.table(Result<R> result)
Use a previously obtained result as a new  
Table that can be used
 in SQL statements through DSL.values(RowN...). | 
static <R extends Record> | 
DSL.table(Select<R> select)
A synonym for  
TableLike.asTable(), which might look a bit more fluent
 like this, to some users. | 
static <R extends Record> | 
DSL.truncate(Table<R> table)
Create a new DSL truncate statement. 
 | 
<R extends Record> | 
DefaultDSLContext.truncate(Table<R> table)  | 
static <R extends Record> | 
DSL.update(Table<R> table)
Create a new DSL update statement. 
 | 
<R extends Record> | 
DefaultDSLContext.update(Table<R> table)  | 
<R extends Record> | 
DefaultDSLContext.updateQuery(Table<R> table)  | 
| Modifier and Type | Method and Description | 
|---|---|
Record | 
DefaultDSLContext.fetchOne(ResultSet rs)  | 
Record | 
DefaultDSLContext.fetchOne(ResultSet rs,
        Class<?>... types)  | 
Record | 
DefaultDSLContext.fetchOne(ResultSet rs,
        DataType<?>... types)  | 
Record | 
DefaultDSLContext.fetchOne(ResultSet rs,
        Field<?>... fields)  | 
Record | 
DefaultDSLContext.fetchOne(String sql)  | 
Record | 
DefaultDSLContext.fetchOne(String sql,
        Object... bindings)  | 
Record | 
DefaultDSLContext.fetchOne(String sql,
        QueryPart... parts)  | 
Record | 
UpdatableRecordImpl.key()  | 
Record | 
DefaultDSLContext.newRecord(Field<?>... fields)  | 
| Modifier and Type | Method and Description | 
|---|---|
static Table<Record> | 
DSL.dual()
The  
DUAL table to be used for syntactic completeness. | 
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(String sql)  | 
Result<Record> | 
DefaultDSLContext.fetch(String sql,
     Object... bindings)  | 
Result<Record> | 
DefaultDSLContext.fetch(String sql,
     QueryPart... parts)  | 
Result<Record> | 
DefaultDSLContext.fetchFromCSV(String string)  | 
Result<Record> | 
DefaultDSLContext.fetchFromCSV(String string,
            char delimiter)  | 
Result<Record> | 
DefaultDSLContext.fetchFromJSON(String string)  | 
Result<Record> | 
DefaultDSLContext.fetchFromStringData(List<String[]> data)  | 
Result<Record> | 
DefaultDSLContext.fetchFromStringData(String[]... data)  | 
Result<Record> | 
DefaultDSLContext.fetchFromTXT(String string)  | 
Result<Record> | 
DefaultDSLContext.fetchFromTXT(String string,
            String nullLiteral)  | 
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(String sql)  | 
Cursor<Record> | 
DefaultDSLContext.fetchLazy(String sql,
         Object... bindings)  | 
Cursor<Record> | 
DefaultDSLContext.fetchLazy(String sql,
         QueryPart... parts)  | 
<R extends Record> | 
DefaultDSLContext.fetchMany(ResultQuery<R> query)  | 
List<Result<Record>> | 
DefaultDSLContext.fetchMany(String sql)  | 
List<Result<Record>> | 
DefaultDSLContext.fetchMany(String sql,
         Object... bindings)  | 
List<Result<Record>> | 
DefaultDSLContext.fetchMany(String sql,
         QueryPart... parts)  | 
Result<Record> | 
DefaultDSLContext.newResult(Field<?>... fields)  | 
ResultQuery<Record> | 
DefaultDSLContext.resultQuery(String sql)  | 
ResultQuery<Record> | 
DefaultDSLContext.resultQuery(String sql,
           Object... bindings)  | 
ResultQuery<Record> | 
DefaultDSLContext.resultQuery(String sql,
           QueryPart... parts)  | 
static SelectSelectStep<Record> | 
DSL.select(Collection<? extends Field<?>> fields)
Create a new DSL subselect statement. 
 | 
SelectSelectStep<Record> | 
DefaultDSLContext.select(Collection<? extends Field<?>> fields)  | 
static SelectSelectStep<Record> | 
DSL.select(Field<?>... fields)
Create a new DSL subselect statement. 
 | 
SelectSelectStep<Record> | 
DefaultDSLContext.select(Field<?>... fields)  | 
static SelectSelectStep<Record> | 
DSL.selectDistinct(Collection<? extends Field<?>> fields)
Create a new DSL subselect statement. 
 | 
SelectSelectStep<Record> | 
DefaultDSLContext.selectDistinct(Collection<? extends Field<?>> fields)  | 
static SelectSelectStep<Record> | 
DSL.selectDistinct(Field<?>... fields)
Create a new DSL subselect statement. 
 | 
SelectSelectStep<Record> | 
DefaultDSLContext.selectDistinct(Field<?>... fields)  | 
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.tableByName(String... qualifiedName)
Create a qualified table, given its table name. 
 | 
static Table<Record> | 
DSL.values(RowN... rows)
Create a  
VALUES() expression of arbitrary degree. | 
| Modifier and Type | Field and Description | 
|---|---|
protected static DataType<Result<Record>> | 
H2DataType.__RESULT  | 
| Modifier and Type | Field and Description | 
|---|---|
static DataType<Result<Record>> | 
HSQLDBDataType.ROW  | 
| Modifier and Type | Field and Description | 
|---|---|
static DataType<Result<Record>> | 
OracleDataType.REF_CURSOR  | 
| Modifier and Type | Field and Description | 
|---|---|
static DataType<Result<Record>> | 
PostgresDataType.REFCURSOR  | 
| Modifier and Type | Method and Description | 
|---|---|
static Table<Record> | 
PostgresDSL.only(Table<?> table)
Get the PostgreSQL-specific  
ONLY [table] clause for use with
 table inheritance. | 
Copyright © 2015. All Rights Reserved.