Module org.jooq

Package org.jooq

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>

public 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.

Example:

 DSLContext create = DSL.using(configuration);

 create.mergeInto(table)
       .using(select)
       .on(condition)
       .whenMatchedThenUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .whenNotMatchedThenInsert(field1, field2)
       .values(value1, value2)
       .execute();
 

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
MergeNotMatchedWhereStep<R>	values(Collection<?> values)	Set VALUES for INSERT in the MERGE statement's WHEN NOT MATCHED THEN INSERT clause.
MergeNotMatchedWhereStep<R>	values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12, Field<T13> value13, Field<T14> value14, Field<T15> value15, Field<T16> value16, Field<T17> value17, Field<T18> value18, Field<T19> value19, Field<T20> value20)	Set VALUES for INSERT in the MERGE statement's WHEN NOT MATCHED THEN INSERT clause.
MergeNotMatchedWhereStep<R>	values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12, T13 value13, T14 value14, T15 value15, T16 value16, T17 value17, T18 value18, T19 value19, T20 value20)	Set VALUES for INSERT in the MERGE statement's WHEN NOT MATCHED THEN INSERT clause.

Method Detail

values

@Support({CUBRID,DB2,DERBY,FIREBIRD_3_0,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE,TERADATA,VERTICA})
MergeNotMatchedWhereStep<R> values(T1 value1,
                                   T2 value2,
                                   T3 value3,
                                   T4 value4,
                                   T5 value5,
                                   T6 value6,
                                   T7 value7,
                                   T8 value8,
                                   T9 value9,
                                   T10 value10,
                                   T11 value11,
                                   T12 value12,
                                   T13 value13,
                                   T14 value14,
                                   T15 value15,
                                   T16 value16,
                                   T17 value17,
                                   T18 value18,
                                   T19 value19,
                                   T20 value20)

Set VALUES for INSERT in the MERGE statement's WHEN NOT MATCHED THEN INSERT clause.

values

@Support({CUBRID,DB2,DERBY,FIREBIRD_3_0,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE,TERADATA,VERTICA})
MergeNotMatchedWhereStep<R> values(Field<T1> value1,
                                   Field<T2> value2,
                                   Field<T3> value3,
                                   Field<T4> value4,
                                   Field<T5> value5,
                                   Field<T6> value6,
                                   Field<T7> value7,
                                   Field<T8> value8,
                                   Field<T9> value9,
                                   Field<T10> value10,
                                   Field<T11> value11,
                                   Field<T12> value12,
                                   Field<T13> value13,
                                   Field<T14> value14,
                                   Field<T15> value15,
                                   Field<T16> value16,
                                   Field<T17> value17,
                                   Field<T18> value18,
                                   Field<T19> value19,
                                   Field<T20> value20)

Set VALUES for INSERT in the MERGE statement's WHEN NOT MATCHED THEN INSERT clause.

values

@Support({CUBRID,DB2,DERBY,FIREBIRD_3_0,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE,TERADATA,VERTICA})
MergeNotMatchedWhereStep<R> values(Collection<?> values)

Set VALUES for INSERT in the MERGE statement's WHEN NOT MATCHED THEN INSERT clause.