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

"M" <someone_at_microsoft.com> wrote in message news:<b58tgi$29i4$1_at_news.hgc.com.hk>...
> 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.

There is no PL/SQL construct that can be accessed like a table. You could create a GLOBAL TEMPORARY TABLE, or you could create a TYPE that acts like a table (with some additional syntax) but does not have an index. Received on Wed Mar 19 2003 - 13:16:54 CET