Re: Dummy tables in PL/SQL

The construct is called an inline view. It was introduced inofficially in version 7.1.6 of the database.
PL/SQL doesn´t support it before version 2.3 ( = version 7.3 of the database).

Torben Jeppesen

"Paul Routledge" <paul_at_earthbound.u-net.com> wrote:

>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?
>
>We have PL/SQL v2.1 on Oracle 7.1
>
>Paul Routledge
>
Received on Sat Nov 30 1996 - 00:00:00 CST