实验如下:
session1 :
create table test(col1 number);
insert into test values(1);
insert into test value(2);
commit;
set transcation read only
select * from test;
结果为
1
2
session2执行:
insert into test value(3);
commit;
session1执行
select * from test;
结果为
1
2
3
按照书上所说,应该为两条记录。因为使用只读事务,session2上面的更改session1应该看不到才对
你的TRANSACTION拼写错了。
会话1:
create table test(col1 number);
insert into test values(1);
insert into test values(2);
commit;
SET TRANSACTION READ ONLY;
SELECT * FROM TEST;
COL1
----------
1
2
会话2:
INSERT INTO TEST VALUES(3);
1 row created.
COMMIT;