Phantom Read 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. |