Re: inconsistent results make me grumpy ( where is the 904? )

From: Noons <>
Date: Fri, 01 Jul 2011 20:03:31 +1000
Message-ID: <iuk618$tgt$>

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

Original text of this message