You are not blind, well I don't actually know that, but you are correct in
that you cannot find it in the documentation. It is not there. It is an
undocumented feature, Oracle uses it for advance queuing. So of course,
they may remove it or change it in the future.
Jim
"Lothar Armbruester" <lothar.armbruester_at_t-online.de> wrote in message
news:PM000398798E029508_at_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 - 19:50:02 CST
