Username in the inner query referenced dba_users since it can't find such a column in dba_tables. Harel Safra Sent from my phone. On Mar 29, 2011 6:50 PM, "Mark Strickland" <strickland.mark@xxxxxxxxx> wrote: > 11.2.0.1 and 11.2.0.2 on OEL. > > Try "select * from dba_users where username in (select username from > dba_tables)". It returns all the rows from dba_users instead of returning > an error. Perhaps this is consistent with SQL 92 but I don't see how. Did > Dr. Codd really intend this? If it is expected behavior, I'm willing to > except the shunning and ridicule (even from Mladen). One of our developers > discovered this yesterday with application tables and I confirmed it with an > equivalent query of data dictionary tables and opened an SR. Can someone > confirm this in 10g? > > Mark Strickland > Seattle, WA