Re: CREATE GLOBAL TEMPORARY TABLE AS SELECT * FROM.....

Andrew -

Yes, it's certainly possible. Try something like this:

SQL> create global temporary table emp100 on commit

    preserve rows as select * from emp;

It worked like a charm for me on version 8.1.7.2.

TG

Andrew Tindle wrote:

> Hi,
>
> I'm trying to create a temporary table using the 'CREATE GLOBAL
> TEMPORARY TABLE AS SELECT <col1>,<col2>.... FROM <tab1>......' syntax.
>
> Can anyone tell me if it's possible to extend this syntax so that the
> table keeps the data for the session, not just the transaction; i.e
> replicate the 'ON COMMIT PRESERVE ROWS' clause that would be used if
> creating the temp table with the explicit columns defined.
>
> TIA
>
> Andrew
Received on Tue May 28 2002 - 12:06:26 CDT