Re: Temporary tables from Select statements...

Hi Luca,

        CREATE TABLE my_temp AS SELECT * FROM orders WHERE vat_rat >= 10;

You may have to quote the value, that is '10'.

Regards

Jerry

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)
 

-- 
Jerry Gitomer		Since I know how to spell DBA I became one. 
jgitomer_at_p3.net