17,382
社区成员




create table test(a number,b number);
insert into test values(1,2);
insert into test values(3,4);
insert into test values(8,9);
commit;
---session 1 模拟选中一个号码
SQL> select * from test where a =1 for update skip locked;
A B
---------- ----------
1 2
---session 2 对a=1再进行select
SQL> select * from test where a = 1 for update skip locked;
未选定行
-- session 3 全表select
SQL> select * from test for update skip locked;
A B
---------- ----------
3 4
8 9
SQL>