Re: Can I create temp table in Oracle.

Hey - yes you can -

create tablespace tmp temporary
:
.

create table temp
:
.
tablespace tmp;

Billy Verreynne wrote:
>
> news.ht.net.tw wrote in message <706l5n$8ft$1_at_ftp.ht.net.tw>...
> >In SQL Server, we can create a session temp table.
> >This temp table is indepandent with other session.
> >This table will auto destory when session closed.
> >Can I do it in Oracle?
> >How to do it.
>
> Simple answer. No. It's not a feature that's directly supported by Oracle.
>
> But then we can go into a whole debate as to the purpose of these temp
> tables in SQL-Server... :-)
>
> regards,
> Billy
Received on Thu Oct 29 1998 - 21:06:40 CST