org.jooq
Interface MergeMatchedWhereStep<R extends Record>
- All Superinterfaces:
- Adapter, Attachable, Merge<R>, MergeFinalStep<R>, MergeNotMatchedStep<R>, Query, QueryPart, Serializable
- All Known Subinterfaces:
- MergeMatchedSetMoreStep<R>
public interface MergeMatchedWhereStep<R extends Record>
- extends MergeNotMatchedStep<R>
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();
- Author:
- Lukas Eder
where
MergeMatchedDeleteStep<R> where(Condition condition)
- Add an additional
WHERE
clause to the preceding
WHEN MATCHED THEN UPDATE
clause.
Note: This syntax is only available for the
SQLDialect.ORACLE
database!
See http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9016.
htm for a full definition of the Oracle MERGE
statement
Copyright © 2012. All Rights Reserved.