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 -> REPOST: Where is select for update nowait skip locked documented?

REPOST: 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: <9$--$%%%_$$--%_%_$@news.noc.cabal.int>


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

========= WAS CANCELLED BY =======:
From: Lothar Armbruester <lothar.armbruester_at_t-online.de>
Control: cancel <PM000398798E029508_at_hades.none.local>
Subject: cmsg cancel <PM000398798E029508_at_hades.none.local>
Date: Mon, 28 Jan 2002 02:56:00 GMT
Message-ID: <cancel.PM000398798E029508_at_hades.none.local>
X-No-Archive: yes
Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server
NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88
Lines: 1         
Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.easynews.net!easynews.net!newsfeed.freenet.de!peer.news.opaltelecom.net!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40720780

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.
Received on Sat Jan 26 2002 - 13:19:31 CST

Original text of this message

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