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

From: Thomas Day <tomdaytwo_at_gmail.com>
Date: Tue, 29 Mar 2011 15:54:12 -0400
Message-ID: <AANLkTinVQPi9UBymbLXnM=2tjo4q2e7Rk2RpoQoYYd1e_at_mail.gmail.com>

However,

 select unique a.* from dba_users a where username in (select username from dba_tables b);

Does produce a result, not an error.

BANNER

---

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for 64-bit Windows: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production

On Tue, Mar 29, 2011 at 2:36 PM, Mark Strickland <strickland.mark_at_gmail.com>wrote:

> Hmm okay, I'll accept it, but I don't have to like it. Thanks for
> responding!
>
> Mark
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 29 2011 - 14:54:12 CDT