To anyone with 9.2.0.5 or 10g...

Hi!
Could you please test the following statement (as a normal user) for me and tell me whether it works for you? It doesn't work in 9.2.0.4. (ORA-00942)

select t1.table_name, t2.table_name

    from

        all_tables t1 full outer join all_tables t2 on (t1.table_name = t2.table_name);

Lots of Thanks!
Volker Received on Thu Apr 22 2004 - 09:34:51 CDT