Re: Temporary tables

<pcmerc_at_my-dejanews.com> wrote in message news:7g4kg2$ss9$1_at_nnrp1.dejanews.com...
> 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

That's a new feature of Oracle8i, look up the documentation for CREATE TABLE (ie CREATE GLOBAL TEMPORARY TABLE) if you've got that.

HTH. Finn Received on Tue Apr 27 1999 - 16:58:31 CDT