Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Simplest way to create/use PLSQL collections

Re: Simplest way to create/use PLSQL collections

From: Tim Gorman <tim_at_evdbt.com>
Date: Tue, 17 May 2005 21:13:40 -0600
Message-ID: <BEB00F04.27767%tim@evdbt.com>


Ranko,

If your "browsing" has any degree of complexity, then instead of writing extensive PL/SQL to "browse" arrays, why not create a GLOBAL TEMPORARY table and insert rows into it and "browse" them with SELECT statements? You can set them up to clean themselves up after a COMMIT/ROLLBACK (i.e. end of transaction) or when your database session disconnects. A global temporary table is essentially an extension of a session's private memory.

Do away with all that PL/SQL code and do it in SQL instead?

Just my $0.02...

-Tim

on 5/17/05 2:47 PM, Ranko Mosic at ranko.mosic_at_gmail.com wrote:

> Hi,
> I need to quickly create array; then browse it.
> I am thinking of using index by binary_integer type of collection because
> they don't need to be extended etc.
> How do I traverse this type of array (how does for ... loop look like )?
>
> Regards, Ranko.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 17 2005 - 23:18:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US