Re: I've now, officially, seen it all...

From: Andreas Sheriff <spamtrap_at_iion.com>
Date: Fri, 12 Jan 2007 14:38:12 -0800
Message-ID: <m5Uph.96$lF7.82@newsfe24.lga>

"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in message news:1168607299.321571.131450_at_v45g2000cwv.googlegroups.com...
>
> Andreas Sheriff wrote:
>> Of course, the subject of this post is completely fictitious, so don't
>> flame
>> me. :-D
>>
>> Does anyone have any idea why someone in their right mind would need a
>> SQL
>> statement such as the following:
>>
>> SELECT NULL FROM DUAL FOR UPDATE NOWAIT
>>
>> Does this make sense? Did I actually loose it?
>
> Looks like you found some code that the oracle development staff put
> into the database.
>
> Where did you find this from exactly?
>
> It doesn't surprise me that a developer might choose to put something
> like this in, nothing much surprises me there. What is surprising was
> that it was allowed to go into production like that!
>

I found this statement from gv$sql.

It didn't appear to come from a production app-server machine, but from SQL Developer & SQL PLUS, but it was executed several times over the last few days.

Andreas Received on Fri Jan 12 2007 - 16:38:12 CST