@Generated(value="This class was generated using jOOQ-tools")
public 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>
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 |
|---|---|
MergeNotMatchedWhereStep<R> |
values(java.util.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,
Field<T21> value21,
Field<T22> value22)
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,
T21 value21,
T22 value22)
Set
VALUES for INSERT in the MERGE
statement's WHEN NOT MATCHED THEN INSERT clause. |
@Support(value={CUBRID,DB2,HSQLDB,ORACLE,SQLSERVER,SYBASE}) 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, T21 value21, T22 value22)
VALUES for INSERT in the MERGE
statement's WHEN NOT MATCHED THEN INSERT clause.@Support(value={CUBRID,DB2,HSQLDB,ORACLE,SQLSERVER,SYBASE}) 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, Field<T21> value21, Field<T22> value22)
VALUES for INSERT in the MERGE
statement's WHEN NOT MATCHED THEN INSERT clause.Copyright © 2014. All Rights Reserved.