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