Tutorial: Understanding phantom rows

In this tutorial, you will observe the appearance of a phantom row.

Note

For this tutorial to work properly, the Automatically Release Database Locks option must not be selected in Interactive SQL (Tools » Options » SQL Anywhere).


Lesson 1: Creating phantom rows
Lesson 2: Avoiding phantom rows