Phantom Read

From: dd <dd_at_dd.com>
Date: Wed, 8 Jun 2005 11:29:47 +0800
Message-ID: <42a66987$1_1@rain.i-cable.com>

I am a bit confused by exactly what constitute a Phantom Read. Does it include ONLY the case where ADDITIONAL rows have been added during 2 queries. Then what about rows DELETED between 2 queries? I have this concern because many textbooks do define Phantom read as addition of rows but never mention anything about removed rows.

If Oracle or any database says its Serializable isolation level does prevent Phantom Read, can I assume that it means no rows inserted nor DELETED between 2 queries?

Thanks for any advice. Received on Tue Jun 07 2005 - 22:29:47 CDT