Re: SELECT NULL FROM DUAL FOR UPDATE NOWAIT

From: Alexander Fatkulin <afatkulin_at_gmail.com>
Date: Tue, 3 Jul 2007 10:45:23 -0400
Message-ID: <49d668000707030745k43f56065q785165c65d2e3432@mail.gmail.com>

Some old SQL*Plus versions did that to check if DB is read/write.

On 7/3/07, Sandra Becker <sbecker6925_at_gmail.com> wrote:
> RHEL4, 9.2.0.8
>

>
> SELECT NULL FROM DUAL FOR UPDATE NOWAIT;
>

3) Why would anyone write a statement like this? What would be the point? Since I don't know which developer wrote it and no one is owning up to it, I haven't been able to find out what the desired result was supposed to be.
> I appreciate any comments/suggestions.
>
> Sandy

-- 
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 03 2007 - 09:45:23 CDT