Re: Commit processing order of DML statements?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 16 Dec 1998 13:51:22 GMT
Message-ID: <3678baa0.11606308@192.86.155.100>

A copy of this was sent to "John Haskins" <76054.334_at_compuserve.com> (if that email address didn't require changing) On Wed, 16 Dec 1998 00:32:57 -0800, you wrote:

>In what order are INSERT, UPDATE, and DELETE commands processed if they are
>all part of a single COMMIT? Does anyone know?
>
>Thanks.
>

In the order you execute them. If you go:

insert into T1...
update T2 ...
delete from T3 ...
commit

it will be insert, update and then delete. the dml happens as soon as it is submitted, it doesn't wait for the commit to happen.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Dec 16 1998 - 07:51:22 CST