Thanks. Are there any alternatives?
"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
news:qa2g7vsf9jcn8cdtkfr1emcbf7sdfm5gie_at_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:18:34 CST
