Re: A SQL bug/feature? Non-existent column in select of in-list subquery returns rows instead of ORA-
From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 4 Apr 2011 18:31:28 -0700
Message-ID: <BANLkTinvvbNbA3pJ4DGKxvK7tSTQDZHwHw_at_mail.gmail.com>
On Tue, Mar 29, 2011 at 11:27 AM, Bobak, Mark <Mark.Bobak_at_proquest.com>wrote:
Date: Mon, 4 Apr 2011 18:31:28 -0700
Message-ID: <BANLkTinvvbNbA3pJ4DGKxvK7tSTQDZHwHw_at_mail.gmail.com>
On Tue, Mar 29, 2011 at 11:27 AM, Bobak, Mark <Mark.Bobak_at_proquest.com>wrote:
> Right. Which is why you should *ALWAYS* use table aliases.
>
>
>
In addition, Oracle has warned in the docs about doing this since 7.3.4 or
so, informing
careful readers that SQL queries without table aliases may not work
correctly 'in the future'.
Since pretty much forever. :)
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 04 2011 - 20:31:28 CDT