----------共8条记录 1条记录修改未提交
SELECT T.*,T.ROWID from temp_zhangxb_20151224 T;
----------另外窗口可查到7条记录 跳过1条
SELECT * from temp_zhangxb_20151224 t where t.textchar in ('1','2','3') FOR UPDATE SKIP LOCKED;
commit;
SELECT T.*,T.ROWID from temp_zhangxb_20151224 T;
----------另外窗口可查到7条记录 跳过1条
SELECT * from temp_zhangxb_20151224 t where t.textchar in ('1','2','3') FOR UPDATE SKIP LOCKED;
commit;