Transaction Isolation - Part 7 [Serializable Isolation]

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.