Re: why the query is not failing the syntax check

Hello

You should always alias your subquery

SQL> select * from dba_users where username in (select distinct a.username from sys.aud$ a);
select * from dba_users where username in (select distinct a.username from sys.aud$ a)

                                                           *

> Hello everyone,
>
> I have a strange one (at least for me), why the next query is not failing
> because column username does not exist in aud$?
>
> select * from dba_users where username in (select distinct username from
> sys.aud$);
>
> Thanks a lot.
>

-- 

Houri Mohamed

Oracle DBA-Developer-Performance & Tuning

Visit My         - Blog <http://www.hourim.wordpress.com/>

Let's Connect -
<http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*Linkedin
Profile <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*

My Twitter <https://twitter.com/MohamedHouri>      - MohamedHouri
<https://twitter.com/MohamedHouri>

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