Re: A SQL bug/feature? Non-existent column in select of in-list subquery returns rows instead of ORA-
- From: Thomas Day <tomdaytwo@xxxxxxxxx>
- To: strickland.mark@xxxxxxxxx
- Date: Tue, 29 Mar 2011 15:54:12 -0400
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@xxxxxxxxx>wrote:
> Hmm okay, I'll accept it, but I don't have to like it. Thanks for
> responding!
>
> Mark
>
Other related posts:
