third and not so good option is, using two separate merge commands with the two different conditions in the 'on' condition itself.
regards Gopa On Jan 21, 2011 2:09 PM, "Gopakumar Pandarikkal" <pandarik...@gmail.com> wrote: Hi gayathri, 'on' keyword is just for joining the merge to table and 'using' query. it is generally keycolumn=keycolumn if you want additional conditions you may give it with update. when matched then update x=10 where yourcondition1 update y=12 where yourcondition2 i am not sure whether two updates will work. if it does'nt you may try giving when matched a second time and then giving the second update. in sqlserver we can give and condition with when matched when mathed and x=y then but that is not possible in oracle. update and delete works together but two updates? I have never tried. please share with us the results of these experiments. regards Gopa > > On Jan 21, 2011 11:24 AM, "gayathri Dev" <gd0...@gmail.com> wrote: > > Hi All, > > I want to ha... -- 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
