Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Commit processing order of DML statements?

Re: Commit processing order of DML statements?

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 19 Dec 1998 01:38:45 GMT
Message-ID: <368400d5.9362730@netnews.worldnet.att.net>


On Wed, 16 Dec 1998 00:32:57 -0800, "John Haskins" <76054.334_at_compuserve.com> wrote:

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

The statements are processed in the order in which you issue them. They will also be processed _when_ you issue them. The COMMIT statement simply marks the end of the transaction, and tells Oracle that you really meant to do what you did.

Jonathan Received on Fri Dec 18 1998 - 19:38:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US