public interface MergeNotMatchedValuesStepN<R extends Record>
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 MergeNotMatchedWhereStep<R>
SetVALUES
forINSERT
in theMERGE
statement'sWHEN NOT MATCHED THEN INSERT
clause.@NotNull MergeNotMatchedWhereStep<R>
values
(Collection<?> values) SetVALUES
forINSERT
in theMERGE
statement'sWHEN NOT MATCHED THEN INSERT
clause.@NotNull MergeNotMatchedWhereStep<R>
SetVALUES
forINSERT
in theMERGE
statement'sWHEN NOT MATCHED THEN INSERT
clause.
-
Method Details
-
values
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull MergeNotMatchedWhereStep<R> values(Object... values) SetVALUES
forINSERT
in theMERGE
statement'sWHEN NOT MATCHED THEN INSERT
clause. -
values
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull MergeNotMatchedWhereStep<R> values(Field<?>... values) SetVALUES
forINSERT
in theMERGE
statement'sWHEN NOT MATCHED THEN INSERT
clause. -
values
@NotNull @CheckReturnValue @Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull MergeNotMatchedWhereStep<R> values(Collection<?> values) SetVALUES
forINSERT
in theMERGE
statement'sWHEN NOT MATCHED THEN INSERT
clause.
-