Module org.jooq

Package org.jooq

Interface MergeNotMatchedValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

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

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)	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)	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)

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)

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.