Re: Temp Tables

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Fri, 2 Apr 1999 12:05:02 +0100
Message-ID: <7e24ob$40c$1@news.inet.tele.dk>

rjkdev_at_rocketmail.com wrote in message <7e0836$d3g$1_at_nnrp1.dejanews.com>...
>
>
>Is there a way to create a temporary table, on the fly in Oracle.
>
>In MS Sql Server, you can do something like:
>
>Select * into #temptable from Invoice_Header
>
>And then "#TempTable" is automatically dropped when the connection to the
>server is dropped.
>
>Is there anything similar in Oracle?
>
>
>Thanks,
>
>Robbie K
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Oracle8i supports temporary tables.

Finn Received on Fri Apr 02 1999 - 05:05:02 CST