Re: Can I do this ? (PL/SQL question)

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 19 Mar 2003 07:09:11 +0100
Message-ID: <qa2g7vsf9jcn8cdtkfr1emcbf7sdfm5gie@4ax.com>

On Wed, 19 Mar 2003 12:48:04 +0800, "M" <someone_at_microsoft.com> wrote:

>Hi all,
>
>In PL/SQL, can I define a "table" for storing temporary data. This "table"
>should be indexed and support key read, update and insert, like normal
>tables...
>
>The reason I would like to do this is to avoid inserting/updating "real"
>tables which consumes lots of system resourecs for I/O.
>
>I knew that PL/SQL table is some kind but it only support indexed by 1
>key --- the binary_integer.
>
>Thanks.
>

You need an in memory database. Oracle is not an in memory database. PL/SQL tables are basically arrays.
So just forget about it

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Mar 19 2003 - 00:09:11 CST