Re: why does this guy use dual?

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Wed, 26 Jan 2011 12:26:08 +1100
Message-ID: <ihnt66$h8c$1_at_news.eternal-september.org>



joel garry wrote,on my timestamp of 26/01/2011 11:42 AM:
> http://www.oracleobserver.com/?q=node/28 seems to have an unnecessary
> use of dual, or am I missing something?
>
> It seems to work fine for me without it.
>

Weird. Only thing I can think of is if v$instance is available and dual isn't, like in a startup? Nup, even then it wouldn't work: it's a cartesian product... Received on Tue Jan 25 2011 - 19:26:08 CST

Original text of this message