Re: Temporary tables from Select statements...

From: John Leggitt <johnml_at_istar.ca>
Date: 1998/04/03
Message-ID: <0AWU.33$4u5.654720@NewsRead.Toronto.iSTAR.net>#1/1

Yes. Use: CREATE TABLE my_temp_table AS

                    SELECT * FROM orders WHERE vat_rate >= 10;

This will create a new table and populate it with values from orders. You will have to drop that table before using the create again.

Good Luck
JohnL

Luca Minudel wrote in message <01bd5dab$14481120$0100007f_at_w95luca>... Is it possible with Oracle to automatically create temporary tables containing rows returned by a SELECT statement? Just like SELECT * FROM ORDERS

             WHERE
               VAT_RATE >= 10
             INTO MY_TEMP_TABLE

where MY_TEMP_TABLE doesn't exist before SELECT execution... Received on Fri Apr 03 1998 - 00:00:00 CST