REPOST: Re: Where is select for update nowait skip locked documented?

Lothar Armbruester doodled thusly:

>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?
>

I believe it is intentionally undocumented. First time I came across it was by looking at the cached SQL in an Oracle Apps site. Oracle uses it quite liberally there, but doesn't talk about it at all. Not nice.

Having said that, I have a distinct re-collection it was mentioned at some stage in metaclick. Although I haven't seen it in ages.

In practice I've found it not to be of much use. It can be used effectively, but you're much better off addressing the design of the app so you never have to do it in the first place.

Why? Well, if you use it and Oracle pulls the rug from under your feet by removing it at a later stage, you won't be able to complain and you're up for re-design anyway. So, bite the bullet early and get rid of it now.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam

• WAS CANCELLED BY =======: From: nsouto_at_optushome.com.au.nospam (Nuno Souto) Control: cancel <3c5361c5.665015_at_news-vip.optusnet.com.au> Subject: cmsg cancel <3c5361c5.665015_at_news-vip.optusnet.com.au> Date: Sun, 27 Jan 2002 23:38:56 GMT Message-ID: <cancel.3c5361c5.665015_at_news-vip.optusnet.com.au> 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!news.ruhr-uni-bochum.de!news-koe1.dfn.de!news-was.dfn.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40720434

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 - 20:17:39 CST