truncate隐性commit
truncate隐性commit同事让帮忙查一问题,procedure中途exception跳出并rollback, 但仍然有一些table commit了,但rollback前并未见有commit语句.仍然是DDL隐性commit的问题,具体测试例子如下:sql>create table t1(seq number);sql>create table t2(seq number);开session 1:insert into t1 values(1);此时,不做commit;另开session 2;select * from t1;此时为0 rows select.回到session 1,runtruncate table t2;再到session 2:SQL>select * from t1;SEQ----------1