Hi Guys
Can the MERGE statement in PL/SQL be used with Bulk Binding FORALL like with inserting and if so how? Or if not whats a good work around?
Cheers
Printable View
Hi Guys
Can the MERGE statement in PL/SQL be used with Bulk Binding FORALL like with inserting and if so how? Or if not whats a good work around?
Cheers
Did you try it out? If so, what's the error you got?Quote:
Originally Posted by yodah
Tamil
A Merge command can be baed on a table, view or subquery, so if you could use a pipelined function to read the contents of your collection and cast it into a table then you might have some luck. Otherwise bulk insert your data into a global temporary table and base the MERGE on that.