This content has been marked as final. Show 2 replies
Why do you need bulk update? You have table main with columns connecting and update_me, right? And you have table staging with columns connecting and new_value. Then use:1 person found this helpful
merge into main m using staging s on ( s.connecting = m.connecting ) when matched then update set m.update_me = s.new_value /
I agree with your return question but just to specifically address the OP's question you can write a FORALL MERGE.