| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help! Question on PL/SQL
I think you mean temp-tables.
In this way oracle doesn't have any temp Tables.
You can do it in the following way
create table temp1 as select .... from .... where .....,;
create table temp2 as select .... from .... where ....;
Don't forget to drop the table temp1,temp2,,,, manually. The will not be droppped automatically.
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
--
 |
 |