Re: Help with temporary tables

From: <pravindamle_at_pop.ptld.uswest.net>
Date: Mon, 19 Apr 1999 07:41:38 -0500
Message-ID: <371B2482.961929E9@pop.ptld.uswest.net>

Oracle does not have the concept of a temp table as it exist in Sybase There is something similar to it( though not exactly it); It is a function returning a table type. probably that may help you.

Paul Wiles wrote:

> How do I rewrite this query in Transact SQL so it will work on Oracle
>
> select * into #temptable from MAIN_TABLE.
>
> I can't find any documentation on the usage of temporary tables in Oracle.
>
> Thanks
>
> Paul
Received on Mon Apr 19 1999 - 07:41:38 CDT