关于FOR UPDATE NOWAIT

[ryuginka]

两表关连.
SELECT * FROM A,B WHERE A.A=B.B FOR UPDATE NOWAIT

这样是锁住了哪张表呢?如果是多表的关连呢?

请专家指教

[ryuginka]

up

[hsj20041004]

都锁了

[ryuginka]

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

[UandM]

都锁了吧？

[ryuginka]

up

[hippie1024]

SQL> create table A(a number,b number);

Table created

SQL> create table B(a number,C number);

Table created

SQL> 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

[ryuginka]

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

[hippie1024]

是的

[ryuginka]

有没有高手给个肯定答复.