User pagh

SQL> SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

Transaction set.

SQL> CREATE TABLE Primes (p INT);

Table created.

SQL> GRANT SELECT, UPDATE, INSERT ON Primes to pagh2;

Grant succeeded.

SQL> SELECT * FROM Primes;

no rows selected





SQL> INSERT INTO Primes VALUES (41);

1 row created.







SQL> SELECT * FROM Primes;

         P
----------
        41

SQL> COMMIT;

Commit complete.



















SQL> SELECT * FROM pagh.Primes;

         P
----------
        41
        43














SQL> SET TRANSACTION ISOLATION LEVEL READ COMMITTED;

Transaction set.

SQL>  INSERT INTO Primes VALUES (2);

1 row created.




















SQL> COMMIT;

Commit complete.








SQL> SELECT * FROM Primes;

         P
----------
        41
        43
         2




SQL> SELECT * FROM Primes;

         P
----------
        41
        43
         2
      2003

SQL> INSERT INTO Primes VALUES (3);

1 row created.

SQL> ROLLBACK;

Rollback complete.

SQL> SELECT * FROM Primes;

         P
----------
        41
        43
         2
      2003
User pagh2

SQL> SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

Transaction set.













SQL> SELECT * FROM pagh.Primes;

no rows selected





SQL> INSERT INTO pagh.Primes VALUES (43);

1 row created.













SQL> SELECT * FROM pagh.Primes;

         P                                                                      
----------                                                                      
        43                                                                      

SQL> SELECT * FROM pagh.Primes;

         P                                                                      
----------                                                                      
        43                                                                      

SQL> COMMIT;

Commit complete.











SQL> SELECT * FROM pagh.Primes;

         P                                                                      
----------                                                                      
        41                                                                      
        43                                                                      






SQL> SET TRANSACTION ISOLATION LEVEL READ COMMITTED;

Transaction set.





SQL> SELECT * FROM pagh.Primes;

         P                                                                      
----------                                                                      
        41                                                                      
        43                                                                      

SQL> INSERT INTO pagh.Primes VALUES (2003);

1 row created.

SQL> SELECT * FROM pagh.Primes;

         P                                                                      
----------                                                                      
        41                                                                      
        43                                                                      
      2003                                                                      





SQL> SELECT * FROM pagh.Primes;

         P                                                                      
----------                                                                      
        41                                                                      
        43                                                                      
         2                                                                      
      2003                                                                      






SQL> COMMIT;

Commit complete.