Re: Building temporary result set in PL/SQL

On Mon, 13 May 2002 05:51:02 -0600, "Pablo Sanchez" <pablo_at_dev.null> wrote:
>What do you plan on doing with the 'temporary result set?' In Oracle,
>you typically aren't creating temporary tables ala Sybase/MS SQL. You
>can create a COLLECTION (see docs) in PL/SQL which can then be BULK
>INSERTED into the database - extremely efficient.
>
>Think of COLLECTIONs as being an array - you have the option of
>creating associative arrays too which is very nice, especially if you
>plan on de-dup'ing data.

I'd recommend using the 9i docs for learning about collections. That chapter in the PL/SQL Guide was extensively reworked to show simple examples of declaring, assigning elements, etc.

http://tahiti.oracle.com/pls/db901/db901.drilldown?remark=&word=collections&book=&preference=&method=LIKE&expand_all=1

The main 9i-only detail that an 8i user would have to skip is nested collections.

John

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/

The opinions expressed above are mine and do not
necessarily reflect those of Oracle Corporation.