Temporary tables from Select statements...

From: Luca Minudel <luca.minudel_at_nline.it>
Date: 1998/04/01
Message-ID: <01bd5dab$14481120$0100007f@w95luca>#1/1

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...

Please let me know.

                                                   
 Luca Minudel                    software designer
 Italy                             Conegliano (TV)
 voice & fax                     +39 (0)438 412280
 e-mail                      luca.minudel_at_nline.it
 WWW                       (italian language used)

Received on Wed Apr 01 1998 - 00:00:00 CST