关于FOR UPDATE NOWAIT

Question

再顶一下.
请大家给个肯定的答复

Answer 1

SQL> create table A(a number,b number);Table createdSQL> create table B(a number,C number);Table createdSQL> select * from A,B where A.a=B.a for update nowait;         A          B          A          C
---------- ---------- ---------- ----------SQL> select object_name from v$locked_object a,dba_objects b where a.OBJECT_ID=b.object_id; OBJECT_NAME
--------------------------------------------------------------------------------
A
B

Answer 2

楼上的意思是说A,B满足条件的记录都被锁住了?