- All Superinterfaces:
Attachable
,AttachableQueryPart
,DMLQuery<R>
,Flow.Publisher<Integer>
,Merge<R>
,MergeFinalStep<R>
,Publisher<Integer>
,org.reactivestreams.Publisher<Integer>
,Query
,QueryPart
,RowCountQuery
,Serializable
,Statement
- All Known Subinterfaces:
MergeMatchedDeleteStep<R>
,MergeMatchedSetMoreStep<R>
,MergeMatchedStep<R>
,MergeMatchedWhereStep<R>
,MergeOnConditionStep<R>
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 TypeMethodDescription@NotNull MergeNotMatchedSetStep<R>
Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement.@NotNull MergeNotMatchedValuesStepN<R>
whenNotMatchedThenInsert
(Collection<? extends Field<?>> fields) Add theWHEN MATCHED THEN UPDATE
clause to theMERGE
statement@NotNull MergeNotMatchedValuesStepN<R>
whenNotMatchedThenInsert
(Field<?>... fields) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1> @NotNull MergeNotMatchedValuesStep1<R,
T1> whenNotMatchedThenInsert
(Field<T1> field1) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2> @NotNull MergeNotMatchedValuesStep2<R, T1, T2> whenNotMatchedThenInsert
(Field<T1> field1, Field<T2> field2) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3> @NotNull MergeNotMatchedValuesStep3<R, T1, T2, T3> whenNotMatchedThenInsert
(Field<T1> field1, Field<T2> field2, Field<T3> field3) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4>
@NotNull MergeNotMatchedValuesStep4<R,T1, T2, T3, T4> whenNotMatchedThenInsert
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5>
@NotNull MergeNotMatchedValuesStep5<R,T1, T2, T3, T4, T5> whenNotMatchedThenInsert
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull 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) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statementMethods inherited from interface org.jooq.Attachable
attach, configuration, detach
Methods inherited from interface org.jooq.AttachableQueryPart
getBindValues, getParam, getParams, getSQL, getSQL
Methods inherited from interface org.reactivestreams.Publisher
subscribe
Methods inherited from interface org.jooq.Query
bind, bind, cancel, execute, executeAsync, executeAsync, isExecutable, keepStatement, poolable, queryTimeout
-
Method Details
-
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull MergeNotMatchedSetStep<R> whenNotMatchedThenInsert()Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement.Unlike the
whenNotMatchedThenInsert(Field...)
andwhenNotMatchedThenInsert(Collection)
methods, this will give access to a MySQL-like API allowing forINSERT SET a = x, b = y
syntax. -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1> @NotNull MergeNotMatchedValuesStep1<R,T1> whenNotMatchedThenInsert(Field<T1> field1) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2> @NotNull MergeNotMatchedValuesStep2<R,T1, whenNotMatchedThenInsertT2> (Field<T1> field1, Field<T2> field2) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep3<R,T3> T1, whenNotMatchedThenInsertT2, T3> (Field<T1> field1, Field<T2> field2, Field<T3> field3) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep4<R,T3, T4> T1, whenNotMatchedThenInsertT2, T3, T4> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep5<R,T3, T4, T5> T1, whenNotMatchedThenInsertT2, T3, T4, T5> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep6<R,T3, T4, T5, T6> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep7<R,T3, T4, T5, T6, T7> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep8<R,T3, T4, T5, T6, T7, T8> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7, T8> (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 theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep9<R,T3, T4, T5, T6, T7, T8, T9> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7, T8, T9> (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 theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep10<R,T3, T4, T5, T6, T7, T8, T9, T10> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7, T8, T9, T10> (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 theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep11<R,T3, T4, T5, T6, T7, T8, T9, T10, T11> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7, T8, T9, T10, T11> (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 theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep12<R,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> (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 theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep13<R,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> (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 theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep14<R,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> (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 theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep15<R,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> (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 theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep16<R,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> (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 theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep17<R,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> (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 theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep18<R,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> (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 theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep19<R,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> (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 theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep20<R,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> (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 theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep21<R,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> (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 theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <T1,T2, @NotNull MergeNotMatchedValuesStep22<R,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> T1, whenNotMatchedThenInsertT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> (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 theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull MergeNotMatchedValuesStepN<R> whenNotMatchedThenInsert(Field<?>... fields) Add theWHEN NOT MATCHED THEN INSERT
clause to theMERGE
statement -
whenNotMatchedThenInsert
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull MergeNotMatchedValuesStepN<R> whenNotMatchedThenInsert(Collection<? extends Field<?>> fields) Add theWHEN MATCHED THEN UPDATE
clause to theMERGE
statement
-