@Generated(value="This class was generated using jOOQ-tools") public interface MergeNotMatchedValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
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(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)
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)
Set
VALUES for INSERT in the MERGE
statement's WHEN NOT MATCHED THEN INSERT clause. |
@Support(value={CUBRID,DB2,FIREBIRD_3_0,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)
VALUES
for INSERT
in the MERGE
statement's WHEN NOT MATCHED THEN INSERT
clause.@Support(value={CUBRID,DB2,FIREBIRD_3_0,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)
VALUES
for INSERT
in the MERGE
statement's WHEN NOT MATCHED THEN INSERT
clause.@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE}) MergeNotMatchedWhereStep<R> values(Collection<?> values)
VALUES
for INSERT
in the MERGE
statement's WHEN NOT MATCHED THEN INSERT
clause.Copyright © 2019. All rights reserved.