Re: SQL vs PL/SQL: FROM clause incompatible?

From: Michael Reviakin <misha_at_percombank.kiev.ua>
Date: 1995/07/24
Message-ID: <AAwVu4mir4_at_percombank.kiev.ua>#1/1


In <comp.databases.oracle> "P. Smith" <pam.smith_at_jhuapl.edu> wrote:

>-- the following select statement is accepted by SQL*PLUS

> SELECT var2 FROM
> (SELECT var2, var3 FROM mytable WHERE var1 = 1
> UNION
> SELECT var2, var3 FROM mytable WHERE var1 = 2);
I tried more "transparent" construction: SELECT DUMMY FROM (SELECT DUMMY FROM DUAL);

and received

ORA-00903: invalid table name

which is the quite predictable result (on ORACLE SERVER V 7.0.16 I'm using). Perhaps you are using next version, like 7.1.X. Even so your PL/SQL is still V2.0 (2.X) and do not allow such advanced syntax.

Regards,

Michael Reviakin. Received on Mon Jul 24 1995 - 00:00:00 CEST

Original text of this message