You would do somethingthing like:
CREATE temptable AS
SELECT * FROM invoice_header;
but you would need to drop it manually when you were done.
If you want to do it programmatically, use a cursor, such as
DECLARE
CURSOR c1 IS
SELECT * FROM invoice_header;
BEGIN
-- statements using c1
END;
and poof! the cursor goes away!
Steve Brown
<rjkdev_at_rocketmail.com> wrote in message
news: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
Received on Thu Apr 01 1999 - 23:11:36 CST
