|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface MergeNotMatchedSetStep<R extends Record>
This type is used for the Merge
's DSL API.
Example:
Factory create = new Factory();
create.mergeInto(table)
.using(select)
.on(condition)
.whenMatchedThenUpdate()
.set(field1, value1)
.set(field2, value2)
.whenNotMatchedThenInsert(field1, field2)
.values(value1, value2)
.execute();
Method Summary | ||
---|---|---|
|
set(Field<T> field,
Field<T> value)
Set values for INSERT in the MERGE statement's
WHEN NOT MATCHED clause |
|
|
set(Field<T> field,
T value)
Set values for INSERT in the MERGE statement's
WHEN NOT MATCHED clause |
|
MergeNotMatchedSetMoreStep<R> |
set(Map<? extends Field<?>,?> map)
Set multiple values for INSERT in the MERGE
statement's WHEN NOT MATCHED clause. |
Method Detail |
---|
<T> MergeNotMatchedSetMoreStep<R> set(Field<T> field, T value)
INSERT
in the MERGE
statement's
WHEN NOT MATCHED
clause
<T> MergeNotMatchedSetMoreStep<R> set(Field<T> field, Field<T> value)
INSERT
in the MERGE
statement's
WHEN NOT MATCHED clause
MergeNotMatchedSetMoreStep<R> set(Map<? extends Field<?>,?> map)
INSERT
in the MERGE
statement's WHEN NOT MATCHED
clause.
Please assure that key/value pairs have matching <T>
types. Values can either be of type <T>
or
Field<T>
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |