Re: To anyone with 9.2.0.5 or 10g...

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Thu, 22 Apr 2004 19:25:46 +0100
Message-ID: <7f3g80tr4os7r5qcstsvstf2upkci159ju@4ax.com>

On Thu, 22 Apr 2004 16:34:51 +0200, "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote:

>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);

[oracle_at_testbox oracle]$ sqlplus test/test

SQL*Plus: Release 9.2.0.5.0 - Production on Thu Apr 22 18:25:18 2004

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production With the Partitioning option
JServer Release 9.2.0.5.0 - Production

SQL> select t1.table_name, t2.table_name

  2      from
  3          all_tables t1 full outer join all_tables t2 on (t1.table_name =

t2.table_name);

TABLE_NAME                     TABLE_NAME
------------------------------ ------------------------------
DUAL                           DUAL

... etc

--
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk         / http://www.andyhsoftware.co.uk/space

Received on Thu Apr 22 2004 - 13:25:46 CDT