Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Where is select for update nowait skip locked documented?

Where is select for update nowait skip locked documented?

From: Lothar Armbruester <lothar.armbruester_at_t-online.de>
Date: Sat, 26 Jan 2002 20:19:31 +0100
Message-ID: <PM000398798E029508@hades.none.local>


Hello out there,

some time ago I read here in this newsgroup that the following SQL is valid:

select * from my_table for update nowait skip locked;

I checked it out and it works. But it seems to be missing in the documentation.
I Looked the SQL reference of 8.1.7 and 9i but it's not there. Then I had a look at the index of the documentation searching for "skip" but again no success.
Now the questuion is: Is the SQL intentionally undocumented or is that simply a mistake? Or am I too blind to find it in the docs?

Regards,
Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de
Received on Sat Jan 26 2002 - 13:19:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US