Re: Help! Question on PL/SQL

From: Tom Best <Tom.Best_at_bentley.com>
Date: Fri, 21 Jan 2000 11:58:33 -0500
Message-ID: <38889039.A2DC97AF@bentley.com>

Oracle did not implement temp tables until 8i. If you don;'t have that, then you could do something like this:

select * from (select * from table1) a, (select * from table2) b WHERE... and the subselects are what would have normally been in the select into stmts.

Dana Jian wrote:

> Hi,
>
> I'm converting one procedure from SQL server to Oracle procedure.
>
> Here's the simplified statements in the SQL proc,
>
> SELECT ... INTO #temp1 FROM....WHERE..
>
> SELECT ... INTO #temp2 FROM... WHERE
>
> SELECT ... FROM #temp1, #temp2 , .... WHERE ...
>
> How to do this in Oracle PL/SQL?
>
> Any comments/help will be highly appreciated!!
>
> Dana
> djian_at_trasa.com
Received on Fri Jan 21 2000 - 10:58:33 CST