Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

Re: SELECT NULL FROM DUAL FOR UPDATE NOWAIT

From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
To: sbecker6925@xxxxxxxxx
Date: Tue, 3 Jul 2007 10:45:23 -0400

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

On 7/3/07, Sandra Becker <sbecker6925@xxxxxxxxx> 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

References:

SELECT NULL FROM DUAL FOR UPDATE NOWAIT
From: Sandra Becker

Other related posts:

SELECT NULL FROM DUAL FOR UPDATE NOWAIT

Re: SELECT NULL FROM DUAL FOR UPDATE NOWAIT