Temporary Tables

From: Jim Ricker <rickerj_at_msn.com>
Date: 1997/08/09
Message-ID: <01bca4e4$ba1aab60$0100a8c0@ricker_nt>#1/1

Often for complex queries it is better to create a temporary table than to use UNION or sub-queries. SqlServer and Sybase have a faciltiy for creating temporary tables which have the following properties:

Temporary tables created are only accessible from the active session. Therefore, if the same user id has two active log-ons, only the session issuing the CREATE TABLE can access the table. A table created via a "normal" CREATE TABLE is accessable from all sessions of the same user id.
Temporary tables are automatically deleted when a session is disconnected.

How do you folks out there handle this in Oracle? Any suggestions? Received on Sat Aug 09 1997 - 00:00:00 CDT