Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> REPOST: Where is select for update nowait skip locked documented?
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
![]() |
![]() |