This Isolation also performs a lock and but the lock
is a table level lock and the table prohibits any insert and update on it. That
means the entire table is completely locked for any changes. No Inserts. No
Updates. You can examine this by taking the Set of queries shows in the
previous example. Make sure to change the Isolation level to serializable as
shown below:
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
Note
that the Isolation allows Select statements on the table.