As far as I know, you can't. The only tables that are automatically
destroyed are created by Oracle itself (e.g. for sorting a large number
of rows).
> -----Original Message-----
> From: news.ht.net.tw [SMTP:jjkkma_at_mail.ht.net.tw]
> Posted At: Friday, October 16, 1998 8:25 AM
> Posted To: server
> Conversation: Can I create temp table in Oracle.
> Subject: Can I create temp table in Oracle.
>
> 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.
>
> jjkk_at_mail.ht.net.tw
>
Received on Fri Oct 23 1998 - 13:01:31 CDT
