Oracle PL/SQL之SET TRANSACTION READ ONLY(事务隔离性)

2014-11-24 18:15:02 · 作者: · 浏览: 0

Test Code:


Step 1, @session 1(SET TRANSACTION READ ONLY):



Step 2, @session 2(DML, insert a new record):



step 3, @session 1(query the same object and get the same result):



Step 4, @session 1(autonomous transaction is not permitted):



Step 5, @session 1(commit current transaction and we get the change):