Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help! Question on PL/SQL
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