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

From: D Rolfe <dwrolfeFRUITBAT_at_orindasoft.com>
Date: Thu, 22 Apr 2004 17:11:58 +0100
Message-ID: <4087EECE.3000409@orindasoft.com>

Volker,

It works for me with 9.0.1 and 10.1.0, but not 9.2.0. Hope this helps...

David Rolfe

In oracle 8.1.5:
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options
PL/SQL Release 8.1.5.0.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);
         all_tables t1 full outer join all_tables t2 on (t1.table_name = 
t2.table_name)
                       *

ERROR at line 3:
ORA-00933: SQL command not properly ended

In oracle 8.1.6:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option
JServer Release 8.1.6.0.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);
         all_tables t1 full outer join all_tables t2 on (t1.table_name = 
t2.table_name)
                       *

ERROR at line 3:
ORA-00933: SQL command not properly ended

In oracle 8.1.7:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production With the Partitioning option
JServer Release 8.1.7.0.0 - 64bit 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);
         all_tables t1 full outer join all_tables t2 on (t1.table_name = 
t2.table_name)
                       *

ERROR at line 3:
ORA-00933: SQL command not properly ended

In oracle 9.0.1:
Oracle9i Enterprise Edition Release 9.0.1.1.0 - 64bit Production With the Partitioning option
JServer Release 9.0.1.1.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);

{lots and lots of output}

In Oracle 9.2.0:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.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);
select t1.table_name, t2.table_name
*
ERROR at line 1:
ORA-00942: table or view does not exist

In oracle 10.1.0:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production With the Partitioning, OLAP and Data Mining options

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

(lots and lots of output)

> 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

Orinda Software make OrindaBuild, a program that looks at your data dictionary and writes java to run your PL/SQL.

www.orindasoft.com Received on Thu Apr 22 2004 - 11:11:58 CDT