Re: Can I create temp table in Oracle.

From: Thomas Pall <tpall_at_bga.com>
Date: 19 Oct 98 22:09:57 GMT
Message-ID: <362bb8b5.0@feed1.realtime.net>

This question was discussed at length a while ago on the Oracle DBA listserver. (To read about this listserver, go to http://www.lazydba.com, to join, send mail to ORACLEDBA-REQUEST_at_MailingList.net
and put the word SUBSCRIBE in the email body.)

One can create pl*sql tables. However these are actually arrays of records, accessed by record number. One can create tables and then drop them. Someone even suggested creating a table and inserting into it but not committing, thereby, hopefully, avoiding creation of rollback data. However rollback consists of a whole lot more than just committed transactions.

The conclusion? No. Not available right now in Oracle.

news.ht.net.tw (jjkkma_at_mail.ht.net.tw) wrote:
: 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 Mon Oct 19 1998 - 17:09:57 CDT