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

Home -> Community -> Usenet -> c.d.o.misc -> Oracle transaction question

Oracle transaction question

From: Bill <bli01_at_yahoo.com>
Date: Fri, 3 Dec 2004 12:13:04 -0600
Message-ID: <C02sd.16$%V3.9@fe04.lga>


Hi all,
Can someone help with this question?

In a program, 2 SQL statements are executed in the same transaction. The first is a SELECT statement based on a status column in a table equals to "X", e.g. SELECT * FROM TABLE1 WHERE STATUS='X'. The second is a DELETE statement, deleting all rows with STATUS='X', e.g. DELETE FROM TABLE1 WHERE STATUS='X'. Both are in one transaction.

During the execution of this transaction, after the SELECT but before the DELETE, another program inserts another row into TABLE1 with STATUS='X'. Will the newly inserted row also be deleted?

Thanks,
Bill Received on Fri Dec 03 2004 - 12:13:04 CST

Original text of this message

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