why the query is not failing the syntax check
From: Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
Date: Wed, 21 Sep 2022 14:41:10 +0300
Message-ID: <CA+riqSWk3=Qdni-Ge0hFfB78fJ515Q1tgAcQFXuWXxtRbmO5rg_at_mail.gmail.com>
Hello everyone,
Date: Wed, 21 Sep 2022 14:41:10 +0300
Message-ID: <CA+riqSWk3=Qdni-Ge0hFfB78fJ515Q1tgAcQFXuWXxtRbmO5rg_at_mail.gmail.com>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 21 2022 - 13:41:10 CEST