Another option is to use a combination of a "before" trigger to set the context, a row-level trigger to capture the changes to each row, one at a time, and an "after" trigger to apply and commit the changes.
Dig deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.