Re: why does this guy use dual?

From: The Boss <nltaal_at_baasbovenbaas.demon.nl>
Date: Fri, 28 Jan 2011 04:53:25 -0800 (PST)
Message-ID: <f43cc25b-cffa-482d-b058-7a5c77d07a32_at_s11g2000yqh.googlegroups.com>

On Jan 28, 1:29 am, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> Joel:
>
> #http://www.oracleobserver.com/?q=node/28seemsto have an unnecessary
> use of dual, or am I missing something?

Probably a sloppy cut&paste from a 'standard' query to get the hostname  from dual, adding the extra info from v$instance.

>
> A new hire to a certain unnamed consulting group?

Don't think so:
http://oaktable.net/users/gpmilliken

--
J

Received on Fri Jan 28 2011 - 06:53:25 CST