| Package | Description | 
|---|---|
| org.jooq | The  org.jooqpackage contains jOOQ's public API. | 
| org.jooq.impl | The  org.jooq.implpackage contains jOOQ's implementation classes. | 
| Modifier and Type | Method and Description | 
|---|---|
| <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Record. into(Field<T1> field1,
    Field<T2> field2,
    Field<T3> field3,
    Field<T4> field4,
    Field<T5> field5,
    Field<T6> field6,
    Field<T7> field7,
    Field<T8> field8,
    Field<T9> field9,
    Field<T10> field10,
    Field<T11> field11,
    Field<T12> field12)Copy this record into a new record holding only a subset of the previous
 fields. | 
| <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | DSLContext. newRecord(Field<T1> field1,
         Field<T2> field2,
         Field<T3> field3,
         Field<T4> field4,
         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 empty  Record. | 
| Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Record12. value1(T1 value)Set the first value. | 
| Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Record12. value10(T10 value)Set the tenth value. | 
| Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Record12. value11(T11 value)Set the eleventh value. | 
| Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Record12. value12(T12 value)Set the twelfth value. | 
| Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Record12. value2(T2 value)Set the second value. | 
| Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Record12. value3(T3 value)Set the third value. | 
| Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Record12. value4(T4 value)Set the fourth value. | 
| Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Record12. value5(T5 value)Set the fifth value. | 
| Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Record12. value6(T6 value)Set the sixth value. | 
| Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Record12. value7(T7 value)Set the seventh value. | 
| Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Record12. value8(T8 value)Set the eighth value. | 
| Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Record12. value9(T9 value)Set the ninth value. | 
| Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Record12. values(T1 t1,
      T2 t2,
      T3 t3,
      T4 t4,
      T5 t5,
      T6 t6,
      T7 t7,
      T8 t8,
      T9 t9,
      T10 t10,
      T11 t11,
      T12 t12)Set all values. | 
| Modifier and Type | Method and Description | 
|---|---|
| <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Result. into(Field<T1> field1,
    Field<T2> field2,
    Field<T3> field3,
    Field<T4> field4,
    Field<T5> field5,
    Field<T6> field6,
    Field<T7> field7,
    Field<T8> field8,
    Field<T9> field9,
    Field<T10> field10,
    Field<T11> field11,
    Field<T12> field12)Copy all records from this result into a new result with new records
 holding only a subset of the previous fields. | 
| <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | DSLContext. newResult(Field<T1> field1,
         Field<T2> field2,
         Field<T3> field3,
         Field<T4> field4,
         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 empty  Result. | 
| <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | WithStep. select(SelectField<T1> field1,
      SelectField<T2> field2,
      SelectField<T3> field3,
      SelectField<T4> field4,
      SelectField<T5> field5,
      SelectField<T6> field6,
      SelectField<T7> field7,
      SelectField<T8> field8,
      SelectField<T9> field9,
      SelectField<T10> field10,
      SelectField<T11> field11,
      SelectField<T12> field12)Create a new DSL select statement. | 
| <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | DSLContext. select(SelectField<T1> field1,
      SelectField<T2> field2,
      SelectField<T3> field3,
      SelectField<T4> field4,
      SelectField<T5> field5,
      SelectField<T6> field6,
      SelectField<T7> field7,
      SelectField<T8> field8,
      SelectField<T9> field9,
      SelectField<T10> field10,
      SelectField<T11> field11,
      SelectField<T12> field12)Create a new DSL select statement. | 
| <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | WithStep. selectDistinct(SelectField<T1> field1,
              SelectField<T2> field2,
              SelectField<T3> field3,
              SelectField<T4> field4,
              SelectField<T5> field5,
              SelectField<T6> field6,
              SelectField<T7> field7,
              SelectField<T8> field8,
              SelectField<T9> field9,
              SelectField<T10> field10,
              SelectField<T11> field11,
              SelectField<T12> field12)Create a new DSL select statement. | 
| <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | DSLContext. selectDistinct(SelectField<T1> field1,
              SelectField<T2> field2,
              SelectField<T3> field3,
              SelectField<T4> field4,
              SelectField<T5> field5,
              SelectField<T6> field6,
              SelectField<T7> field7,
              SelectField<T8> field8,
              SelectField<T9> field9,
              SelectField<T10> field10,
              SelectField<T11> field11,
              SelectField<T12> field12)Create a new DSL select statement. | 
| Modifier and Type | Method and Description | 
|---|---|
| Condition | BetweenAndStep12. and(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> maxValue)Create a condition to check this field against some bounds | 
| BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Row12. between(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue)Check if this row value expression is within a range of two records. | 
| Condition | Row12. between(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue,
       Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> maxValue)Check if this row value expression is within a range of two records. | 
| Condition | Row12. between(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue,
       Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> maxValue)Check if this row value expression is within a range of two records. | 
| BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Row12. betweenSymmetric(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue)Check if this row value expression is within a symmetric range of two
 records. | 
| Condition | Row12. betweenSymmetric(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue,
                Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> maxValue)Check if this row value expression is within a symmetric range of two
 records. | 
| Condition | Row12. betweenSymmetric(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue,
                Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> maxValue)Check if this row value expression is within a symmetric range of two
 records. | 
| Condition | Row12. compare(Comparator comparator,
       Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> record)Compare this row value expression with a record
 using a dynamic comparator. | 
| Condition | Row12. eq(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> record)Compare this row value expression with a record for equality. | 
| Condition | Row12. equal(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> record)Compare this row value expression with a record for equality. | 
| Condition | Row12. ge(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> record)Compare this row value expression with a record for order. | 
| Condition | Row12. greaterOrEqual(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> record)Compare this row value expression with a record for order. | 
| Condition | Row12. greaterThan(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> record)Compare this row value expression with a record for order. | 
| Condition | Row12. gt(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> record)Compare this row value expression with a record for order. | 
| Condition | Row12. in(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>... record)Compare this row value expression with a set of records for equality. | 
| Condition | Row12. le(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> record)Compare this row value expression with a record for order. | 
| Condition | Row12. lessOrEqual(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> record)Compare this row value expression with a record for order. | 
| Condition | Row12. lessThan(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> record)Compare this row value expression with a record for order. | 
| Condition | Row12. lt(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> record)Compare this row value expression with a record for order. | 
| Condition | Row12. ne(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> record)Compare this row value expression with a record for non-equality. | 
| BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Row12. notBetween(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue)Check if this row value expression is within a range of two records. | 
| Condition | Row12. notBetween(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue,
          Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> maxValue)Check if this row value expression is within a range of two records. | 
| Condition | Row12. notBetween(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue,
          Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> maxValue)Check if this row value expression is within a range of two records. | 
| BetweenAndStep12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | Row12. notBetweenSymmetric(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue)Check if this row value expression is not within a symmetric range of two
 records. | 
| Condition | Row12. notBetweenSymmetric(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue,
                   Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> maxValue)Check if this row value expression is not within a symmetric range of two
 records. | 
| Condition | Row12. notBetweenSymmetric(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> minValue,
                   Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> maxValue)Check if this row value expression is not within a symmetric range of two
 records. | 
| Condition | Row12. notEqual(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> record)Compare this row value expression with a record for non-equality | 
| Condition | Row12. notIn(Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>... record)Compare this row value expression with a set of records for non-equality. | 
| Modifier and Type | Method and Description | 
|---|---|
| <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | UpdateQuery. addValues(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> row,
         Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Specify a multi-column set clause for the  UPDATEstatement. | 
| Condition | Row12. compare(Comparator comparator,
       QuantifiedSelect<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect
 using a dynamic comparator. | 
| Condition | Row12. compare(Comparator comparator,
       Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect
 using a dynamic comparator. | 
| Condition | Row12. eq(QuantifiedSelect<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for equality. | 
| Condition | Row12. eq(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for equality. | 
| Condition | Row12. equal(QuantifiedSelect<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for equality. | 
| Condition | Row12. equal(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for equality. | 
| Condition | Row12. ge(QuantifiedSelect<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. ge(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. greaterOrEqual(QuantifiedSelect<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. greaterOrEqual(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. greaterThan(QuantifiedSelect<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. greaterThan(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. gt(QuantifiedSelect<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. gt(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. in(Result<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> result)Compare this row value expression with a set of records for
 equality. | 
| Condition | Row12. in(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for equality. | 
| Condition | Row12. le(QuantifiedSelect<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. le(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. lessOrEqual(QuantifiedSelect<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. lessOrEqual(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. lessThan(QuantifiedSelect<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. lessThan(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. lt(QuantifiedSelect<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. lt(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order. | 
| Condition | Row12. ne(QuantifiedSelect<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for non-equality. | 
| Condition | Row12. ne(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for non-equality. | 
| Condition | Row12. notEqual(QuantifiedSelect<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for non-equality. | 
| Condition | Row12. notEqual(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for non-equality. | 
| Condition | Row12. notIn(Result<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> result)Compare this row value expression with a set of records for
 equality. | 
| Condition | Row12. notIn(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for non-equality. | 
| Merge<R> | MergeValuesStep12. select(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Use a  SELECTstatement as the source of values for theMERGEstatement
 
 This variant of theMERGE .. | 
| Insert<R> | InsertValuesStep12. select(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Use a  SELECTstatement as the source of values for theINSERTstatement
 
 This variant of theINSERT .. | 
| <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | UpdateSetFirstStep. set(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> row,
   Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Specify a multi-column set clause for the  UPDATEstatement. | 
| Modifier and Type | Method and Description | 
|---|---|
| <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | DefaultDSLContext. newRecord(Field<T1> field1,
         Field<T2> field2,
         Field<T3> field3,
         Field<T4> field4,
         Field<T5> field5,
         Field<T6> field6,
         Field<T7> field7,
         Field<T8> field8,
         Field<T9> field9,
         Field<T10> field10,
         Field<T11> field11,
         Field<T12> field12) | 
| Modifier and Type | Method and Description | 
|---|---|
| static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | DSL. field(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> row)EXPERIMENTAL: Turn a row value expression of degree  12into aField. | 
| <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | DefaultDSLContext. newResult(Field<T1> field1,
         Field<T2> field2,
         Field<T3> field3,
         Field<T4> field4,
         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 <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | DSL. select(SelectField<T1> field1,
      SelectField<T2> field2,
      SelectField<T3> field3,
      SelectField<T4> field4,
      SelectField<T5> field5,
      SelectField<T6> field6,
      SelectField<T7> field7,
      SelectField<T8> field8,
      SelectField<T9> field9,
      SelectField<T10> field10,
      SelectField<T11> field11,
      SelectField<T12> field12)Create a new DSL subselect statement. | 
| <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | DefaultDSLContext. select(SelectField<T1> field1,
      SelectField<T2> field2,
      SelectField<T3> field3,
      SelectField<T4> field4,
      SelectField<T5> field5,
      SelectField<T6> field6,
      SelectField<T7> field7,
      SelectField<T8> field8,
      SelectField<T9> field9,
      SelectField<T10> field10,
      SelectField<T11> field11,
      SelectField<T12> field12) | 
| static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | DSL. selectDistinct(SelectField<T1> field1,
              SelectField<T2> field2,
              SelectField<T3> field3,
              SelectField<T4> field4,
              SelectField<T5> field5,
              SelectField<T6> field6,
              SelectField<T7> field7,
              SelectField<T8> field8,
              SelectField<T9> field9,
              SelectField<T10> field10,
              SelectField<T11> field11,
              SelectField<T12> field12)Create a new DSL subselect statement. | 
| <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | DefaultDSLContext. selectDistinct(SelectField<T1> field1,
              SelectField<T2> field2,
              SelectField<T3> field3,
              SelectField<T4> field4,
              SelectField<T5> field5,
              SelectField<T6> field6,
              SelectField<T7> field7,
              SelectField<T8> field8,
              SelectField<T9> field9,
              SelectField<T10> field10,
              SelectField<T11> field11,
              SelectField<T12> field12) | 
| static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> | DSL. values(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>... rows)Create a  VALUES()expression of degree12. | 
Copyright © 2015. All Rights Reserved.