Re: temporary tables

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Sat, 15 Jan 2000 21:20:50 +0000
Message-ID: <3880E4B2.2D4AA619@rdbms.freeserve.co.uk>

Mike,

Temporary tables managed by the database are introduced in Oracle8i.

So in 7.3.4 we have to manage our own using CREATE TABLE xx AS .. where xx is our unique generated table name. Remember to use the storage clause...

Chris.

I remember being able to do this in Informix 2.1 10 years ago ....

trumpet999_at_my-deja.com wrote:
>
> How do you create a temporary table within a stored procedure? I
> remember being able to do this in SQL Server but I cannot find a way
> to do it in Oracle v 7.3.4.
>
> Can someone post an example ?
>
> Thanks.
>
> Mike
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Jan 15 2000 - 15:20:50 CST