Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with temporary tables

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US