It's not quite clear in your request: what is the criteria to select which exactly row to be used for inserting and which for updating. And which row should be the updated one?
On Thursday, August 27, 2015 at 12:00:30 AM UTC+3, GD wrote: > > Hi All, > > I have a scenario similar to "ORA-30926: unable to get a stable set of > rows in the source tables" error that we get in the Merge statement. > i.e., 1 row in the Target table result in Multiple rows in the source > table. > > say if 2 rows are returned by the source table, then i need to update 1 > row in the target and insert 1 row to target as well. > > Is there a way to do that? Please suggest? > > Thanks, > -- -- 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 unsubscribe from this group and stop receiving emails from it, send an email to oracle-plsql+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.