Re: A SQL bug/feature? Non-existent column in select of in-list subquery returns rows instead of ORA-

From: Jared Still <>
Date: Mon, 4 Apr 2011 18:31:28 -0700
Message-ID: <>

On Tue, Mar 29, 2011 at 11:27 AM, Bobak, Mark <>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: Home Page:

Received on Mon Apr 04 2011 - 20:31:28 CDT

Original text of this message