Re: URGENT: Temporary Tables

From: Kenneth C Stahl <kstahl_at_lucent.com>
Date: Fri, 25 Jun 1999 14:42:10 -0400
Message-ID: <3773CD82.911FC807@lucent.com>

Actually, it can be done and is, in fact, done all the time - just not in the way that you are probably thinking about.

If you create a view or define a cursor that performs a sort or a join in any way, a tempoary table is constructed in the tablespace designated as temporary tablespace for your login account. This table is read-only and only exists within the scope of the cursor that was used to query the data. You cannot directly manipulate this table - you can only read it through one time and when the cursor goes out of scopt the object is destroyed.

yitbsal_at_statcan.ca wrote:

> Hi,
>
> I want to create a temporary table -- visible only within a session
> -- in a stored procedure. Is this possible?
>
> Salaam
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Jun 25 1999 - 13:42:10 CDT