which comes first delete or update when using merge

User_JNHXJ

hello i wanted to ask a simple question about merge when we specify update and delete on WHEN MATCHED which one comes first do we update the row first then delete the result or do we delete the result 1st then update.can anyone clarify this to me thanks

EdStevens

Uhm .... I believe you've wandered into a hardware store to get some Chinese takeout ..... 😉

This forum space deals with the oracle Recovery Manager (rman).

Perhaps we can get a moderator to move it to the appropriate forum (SQL & PL/SQL).