A phantom read occurs when one user is repeating a read operation on the same records, but has new records in the results set, as shown in the following example.

                User A executes: 
	SELECT * FROM State; 
User B executes: 
	INSERT INTO pub.State (state, state_name, region) 
	VALUES (‘CT', 'Connecticut', ‘Northeast'); 
	COMMIT WORK; 
User A re-executes: 
	SELECT * FROM pub.State;
User 1 has new records in the results set.