Hi All,
I want to have multiple ON condition and corresponding Update statements in
Merge command. Is it possible?
Eg:
Merge into cust C
using (select o1, o2, o3 from Order ) O
on (
(C.c1 = O.o1 and C.c2 = O.o2) --- condition 1
OR
(C.c1 = O.o1 and C.c2 = O.o2) --- condition 2
)
when matched then
Update c1, c2 -- for condition1 match
Update c3, c4 -- for condition2 match
when not matched then
Insert
;
Or is there any other better way to do this?
Appreciate if I can get a solution at the earliest.
Thanks
G
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
