Transaction Isolation1.htm |
Two processes SQL Plus and SQL Developer
|
Let us create a table S1; with sql-developer I clicked on Commit to
enroll this table
|
|
Next I would insert few rows:
Now run a query and don't use COMMIT," ignore ugly column formatting", Now format the columns
Since Auto commit feature of Oracle was turned OFF, locally in this SQL*Plus application Pane, other application / processes would not have any information about the data inserted @ this SQL*Plus. |
Now Open another SQL * Plus command terminal /pane and execute
"select * from s1", note the report "no rows selected" in the screen
shot below.
The application, Oracle SQL developer, did not have any information, either, about the data insertions in phase happening else where, till the transaction was enforced to commit. ( shown in the next document) |