Re: inconsistent results make me grumpy ( where is the 904? )
From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Fri, 01 Jul 2011 20:03:31 +1000
Message-ID: <iuk618$tgt$1_at_dont-email.me>
Jonathan Lewis wrote,on my timestamp of 1/07/2011 6:23 AM:
Date: Fri, 01 Jul 2011 20:03:31 +1000
Message-ID: <iuk618$tgt$1_at_dont-email.me>
Jonathan Lewis wrote,on my timestamp of 1/07/2011 6:23 AM:
>
>
> It's expected behaviour. Think correlated subqueries.
>
> If a column referenced inside a subquery does not belong to any of the
> tables in the subquery then Oracle assumes that it is a correlating column
> that comes from the next layer out.
>
>
Yup, that's what I'm seeing as well.
(A case of Oracle trying to be too smart for its own good?)
Received on Fri Jul 01 2011 - 05:03:31 CDT