Re: Temporary table

jtdennis_at_atl.mindspring.com (John Dennis) wrote:

>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,

We decided that the semi-permanent model with regular clean-up is the best approach for now. Still not nice, but I can live with it.

Ciao
Fuzzy
:-) Received on Mon Jul 15 1996 - 00:00:00 CEST