Re: Temporary tables

From: Dave Fowler <d.fowler_at_cwix.com>
Date: Mon, 26 Apr 1999 00:55:30 GMT
Message-ID: <6QOU2.194$FA1.16920@news.cwix.com>

Try,
Create table temp as Select column_name from table_name;

this will leave table temp in user schema. User Must have create table privilege.
Check Oracle manual on select statement for more details.

HTH,
Dave Fowler
Oracle Developer DBA

<pcmerc_at_my-dejanews.com> wrote in message news:7fvqfp$lnn$1_at_nnrp1.dejanews.com...
> 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 Sun Apr 25 1999 - 19:55:30 CDT