Re: Temporary tables

Correct me if i am wrong,but i thought that this statement creates a table called 'temp' but doesn't make it a temporary table.The burden of deleting this table lies on the user.What i need is a statement that creates a table that lasts the length of the transaction and gets deleted by the system at the end of the transaction.

In article <6QOU2.194$FA1.16920_at_news.cwix.com>,   "Dave Fowler" <d.fowler_at_cwix.com> wrote:
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 27 1999 - 10:18:31 CDT