Re: inconsistent results make me grumpy ( where is the 904? )

>
> This query returns an error:
>
> select table_name from dba_users;
> Error at line 1
> ORA-00904: "TABLE_NAME": invalid identifier
>

I don't have an instance to play with ATM, but does dba_users have a table_name column?
>
> This query executes ( not very well but ... ):
> select * from dba_tables where table_name in
> ( select table_name from dba_users );

I believe dba_tables does have a table_name column.

So if you use synonyms

i.e. (untested)

Select * from dba_tables dt where dt.table_name in (select du.table_name from dba_users du );

You should get the same error.

[...]

-- 
S. Anthony Sequeira
+44 7542 455 233
++
If you have to ask what jazz is, you'll never know.
		-- Louis Armstrong
++