Dummy tables in PL/SQL

From: Paul Routledge <paul_at_earthbound.u-net.com>
Date: 1996/11/25
Message-ID: <01bbdb17$2505f9e0$b08577c2@earthbound.u-net.com>#1/1

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 Mon Nov 25 1996 - 00:00:00 CST