Re: why does this guy use dual?

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Sat, 29 Jan 2011 21:19:05 +1100
Message-ID: <ii0ph7$u2l$1_at_news.eternal-september.org>



John Hurley wrote,on my timestamp of 29/01/2011 3:53 AM:

> # Probably a sloppy cut&paste from a 'standard' query to get the host-
> name from dual, adding the extra info from v$instance.
>
> ... Don't think so: http://oaktable.net/users/gpmilliken
>
> Maybe someone should submit this is as a question to the Oakies ...
> there sure are a lot of them lately.
>
> I have started my own relatively exclusive group the GROUNDHOGs
> ( GRumpy Old UNderachieving Dbas HOokup Group ) ... wouldn't a
> groundhog chew on the leg of an oak table?
>

LOL! Actually, all that information nowadays is much better obtained from the sys_context function. Received on Sat Jan 29 2011 - 04:19:05 CST

Original text of this message