In article <01bbdb17$2505f9e0$b08577c2_at_earthbound.u-net.com>, Paul
Routledge <paul_at_earthbound.u-net.com> writes
>Why is that I can do this in SQL*Plus
>
>select table2.column2
>from (select table1.column1 as column2
> from table1) table2;
>
>but I can't do this in PL/SQL
>
>begin
>select table2.column2
>from (select table1.column1 as column2
> from table1) table2;
>end;
>/
>
>Does PL/SQL not allow this creating a pseduo temp table on the fly like
>this. Even in the standard Oracle SQL manual it makes no mention of this
>technique but it does work in SQL*Plus. What's the rules here?
>
Your problem may be that in PL/SQL you must have an INTO clause in a
select statement.
--
Jim Smith
Received on Fri Nov 29 1996 - 00:00:00 CST
