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