@Generated(value="This class was generated using jOOQ-tools") public interface MergeNotMatchedStep<R extends Record> extends MergeFinalStep<R>
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();
Modifier and Type | Method and Description |
---|---|
MergeNotMatchedSetStep<R> |
whenNotMatchedThenInsert()
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement. |
MergeNotMatchedValuesStepN<R> |
whenNotMatchedThenInsert(Collection<? extends Field<?>> fields)
Add the
WHEN MATCHED THEN UPDATE clause to the
MERGE statement |
MergeNotMatchedValuesStepN<R> |
whenNotMatchedThenInsert(Field<?>... fields)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1> MergeNotMatchedValuesStep1<R,T1> |
whenNotMatchedThenInsert(Field<T1> field1)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2> MergeNotMatchedValuesStep2<R,T1,T2> |
whenNotMatchedThenInsert(Field<T1> field1,
Field<T2> field2)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3> MergeNotMatchedValuesStep3<R,T1,T2,T3> |
whenNotMatchedThenInsert(Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4> |
whenNotMatchedThenInsert(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5> |
whenNotMatchedThenInsert(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6> |
whenNotMatchedThenInsert(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7> |
whenNotMatchedThenInsert(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7,T8> |
whenNotMatchedThenInsert(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
whenNotMatchedThenInsert(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)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
whenNotMatchedThenInsert(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)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
whenNotMatchedThenInsert(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)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
whenNotMatchedThenInsert(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)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
whenNotMatchedThenInsert(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)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
whenNotMatchedThenInsert(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)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
whenNotMatchedThenInsert(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)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
whenNotMatchedThenInsert(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)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
whenNotMatchedThenInsert(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)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
whenNotMatchedThenInsert(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)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
whenNotMatchedThenInsert(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)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
whenNotMatchedThenInsert(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)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
whenNotMatchedThenInsert(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)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
whenNotMatchedThenInsert(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)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, queryTimeout
attach, detach
@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) MergeNotMatchedSetStep<R> whenNotMatchedThenInsert()
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement.
Unlike the whenNotMatchedThenInsert(Field...)
and
whenNotMatchedThenInsert(Collection)
methods, this will give
access to a MySQL-like API allowing for
INSERT SET a = x, b = y
syntax.
@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1> MergeNotMatchedValuesStep1<R,T1> whenNotMatchedThenInsert(Field<T1> field1)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2> MergeNotMatchedValuesStep2<R,T1,T2> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3> MergeNotMatchedValuesStep3<R,T1,T2,T3> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4> MergeNotMatchedValuesStep4<R,T1,T2,T3,T4> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5> MergeNotMatchedValuesStep5<R,T1,T2,T3,T4,T5> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6> MergeNotMatchedValuesStep6<R,T1,T2,T3,T4,T5,T6> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7> MergeNotMatchedValuesStep7<R,T1,T2,T3,T4,T5,T6,T7> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7,T8> MergeNotMatchedValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7,T8,T9> MergeNotMatchedValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9> whenNotMatchedThenInsert(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)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> MergeNotMatchedValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> whenNotMatchedThenInsert(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)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> MergeNotMatchedValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> whenNotMatchedThenInsert(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)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> MergeNotMatchedValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> whenNotMatchedThenInsert(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)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> MergeNotMatchedValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> whenNotMatchedThenInsert(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)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> MergeNotMatchedValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> whenNotMatchedThenInsert(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)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> MergeNotMatchedValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> whenNotMatchedThenInsert(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)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> MergeNotMatchedValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> whenNotMatchedThenInsert(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)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> MergeNotMatchedValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> whenNotMatchedThenInsert(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)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> MergeNotMatchedValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> whenNotMatchedThenInsert(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)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> MergeNotMatchedValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> whenNotMatchedThenInsert(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)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> MergeNotMatchedValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> whenNotMatchedThenInsert(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)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> MergeNotMatchedValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> whenNotMatchedThenInsert(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)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> MergeNotMatchedValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> whenNotMatchedThenInsert(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)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) MergeNotMatchedValuesStepN<R> whenNotMatchedThenInsert(Field<?>... fields)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) MergeNotMatchedValuesStepN<R> whenNotMatchedThenInsert(Collection<? extends Field<?>> fields)
WHEN MATCHED THEN UPDATE
clause to the
MERGE
statementCopyright © 2017. All Rights Reserved.