Re: Temporary tables

From: <smiths_at_logica.com>
Date: Mon, 26 Apr 1999 10:19:44 -0400
Message-ID: <37247600.460B810B@logica.com>

The easiest way to do what you want is -

Create Table TEMP1 as
Select field1, field2
From Table1
Drop Table

pcmerc_at_my-dejanews.com wrote:

> Hi
> Can anyone please tell me how to create temporary table in Oracle.
> I know in sybase it can be done by saying
> select column_name from table_name into #temp_table_name.
>
> Thanks
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Apr 26 1999 - 09:19:44 CDT