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
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2007