Oracle Database Discussions

Hi,

My question is related to the architecture. I don't find much information on google.

The question is how Oracle update statement works on the background? My friend and myself had a debate that update works internally as delete and insert statements. It means when you run update, first it deletes the row and insert the row with new update values.

But I don't agree his view on this.

Can anyone of you clarify how oracle update statement works internally? Thanks in advance..

Regards,
Robin