Re: Temporary table
Date: 1996/07/03
Message-ID: <DtyxGq.6D3_at_intruder.daytonoh.ncr.com>#1/1
Views probably won't do you any good for temp storage. If the
user running the
stuff has create/drop table privs, you could create a table on
the fly and then delete
it. You might also check out PL/SQL tables to do what you want.
HTH
Jim Gregory
>==========Fuzzy, 7/2/96==========
>
>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.
>
>Ciao
>Fuzzy
>:-)
>
>
>
Opinions expressed are mine and do not reflect those of my company or clients. Received on Wed Jul 03 1996 - 00:00:00 CEST