Re: Temp tables?

From: -= <aquabubble_at_geocities.com>
Date: Fri, 22 Oct 1999 12:58:35 GMT
Message-ID: <7upn1q$qqm$1@nnrp1.deja.com>

In article <7ud9em$p4t$1_at_nslave1.tin.it>, "Francesco Baldi" <mail_at_francescobaldi.com> wrote:
> Hello,
> I'd like to know if it's possible to create temporary tables
> within stored procedures, like in MS SQL Server
> (select * into #temptable from sometable)

It depends what you mean. If you want to create a physical table on the database in a stored procedure then you can use dynamic SQL.

If you want to have a temporary storage area for processing then you might consider using PL/SQL tables. These are just like arrays, and work in the same way (with subscripts etc.), and are are stored in memory. If you want this temporary table to be visible to other programs at a different time, then you could create it as a public object and then populate it in a package. This will work very well so long as you don't pinch all the memory!

Hope this answers your question. If you need any details then let me know.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 22 1999 - 07:58:35 CDT