Re: temporary tables in oracle

From: Ed Prochak <edprochak_at_interfacefamily.com>
Date: Tue, 02 Feb 1999 00:23:23 -0500
Message-ID: <36B68BCB.EDDEBF57@interfacefamily.com>

You can use PL/SQL tables, which are really more like sparse arrays. It should be in your PL/SQL book. These tables essentially stay in memory. The advantage over cursors here is when you need to refer to an entry in the table more than once. It is the closest thing to temp tables. A down side is that you cannot query PL/SQL tables. Upside is they are really tables, ie essentially unlimited storage.

Kent Eilers wrote:
>
> I come from sybase/sql-server where we used temp tables instead of
> cursors (big reason: giant performance increase). Do you Oracle gurus
> use temp tables in procedures? I have found little documentation on
> this in two Oracle books I have.
>
> Thanks.

--
Ed Prochak
Magic Interface, Ltd.
440-498-3702 Received on Mon Feb 01 1999 - 23:23:23 CST