Temp Tables

From: <rjkdev_at_rocketmail.com>
Date: Thu, 01 Apr 1999 16:49:46 GMT
Message-ID: <7e0836$d3g$1@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 Received on Thu Apr 01 1999 - 10:49:46 CST