Re: Temporary table

grant_at_towersoft.com.au (Fuzzy) wrote:

>People,
 

>In SQL Server and Sybase, there is the concept of a temporary table,
>that can be used as a holding space for results that will need further
>work.
 

>Is there such a beast in Oracle? I can't find any references in the
>doco, and I've thought about creating views on the fly, but this could
>get messy.

Nope. This is one my list of top-ten things I wish Oracle had that Sybase does. The opposite list is quite long so don't thing I'm a Sybaser. Anyway, no temp tables.

Options:

        Use dynamic SQL to create temp tables on the fly. It could also be improved to remove them later with DBMS_BATCH.

        Create semi-permenant table. On that is cleaned out on a regular basis. This can even include the session-id for use by multiple users.

Neither is pretty. You prob. already solved this problem. If it was a different solution let me know what it was.

John Dennis

John Dennis
Tactics, Inc
Atlanta, GA Received on Thu Jul 11 1996 - 00:00:00 CEST