Re: Help: Temporary tables

From: <esiyuri_at_my-dejanews.com>
Date: Tue, 06 Oct 1998 15:37:29 GMT
Message-ID: <6vddfq$sov$1@nnrp1.dejanews.com>

In article <6vcsar$5i4$1_at_nnrp1.dejanews.com>, johnb_at_anvil.co.uk wrote:

> In sybase you can create a temporary table within a stored procedure and then
> use the temporary table in a query like any other table. Does oracle have the
> same feature ? if not how is this achieved.

John,

Oracle does not use temporary tables in the same way as Sybase.

If you *really* wanted to you could create a real table to store your intermediate results. This is generally a bad idea.

The normal way to do this in Oracle is by using a cursor which will return the same records that you would have placed in the temporary table, and then iterate over these records by reading from the cursor one row at a time.

--
Regards
Yuri McPhedran

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 06 1998 - 10:37:29 CDT