Re: Temporary tables from Select statements...

Yes, with Oracle 7.3.x and later you can do:

CREATE TABLE MY_TEMP_TABLE AS
  SELECT ... Luca Minudel wrote:
>
> 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