no its not possible On 1/21/11, gayathri Dev <gd0...@gmail.com> wrote: > 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 Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en
-- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
