Lothar Armbruester <lothar.armbruester_at_t-online.de> wrote in message news:<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 =======:
Lothar, it appears to be an undocumented feature of Oracle, at least
in version 8.1. I have read on metalink that the version 9i SQL
manual does document the new 'wait n' parameter which allows you to
wait x number of seconds.
Received on Tue Jan 29 2002 - 08:16:30 CST
