Re: howto traverse an associative array

bonminh lam wrote:

> Hello,
>
> since Oracle 9i, it is possible to use associativ array (or index by
> table) as in the following example taken from Oracle's PL/SQL User's
> Guide:
>

<snipped>
>
> My question is how to traverse or loop through for example the table
> variable country_population. Since the first und last predicate
> returns a varchar2 value, the syntax like this "for i in foo.first ..
> foo.last loop" does not work.
>
> I guess associative array is not designed to be used this way, but it
> would still be a nice-to-have thing.
>
> Anyone knows a solution?
>
> Bon-Minh Lam

http://www.psoug.org/reference/associative_arrays.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)