Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: extracting keys from associative array
On Feb 20, 8:54 am, Filipe David Borba Manana <fdman..._at_cern.ch>
wrote:
> is there any function in PL/SQL to return an array containing all the
> keys from an associative array (hash table)?
>
> i want to do something like this in Perl:
>
> array = sort keys %myhash;
>
> but in PL/SQL of course...
>
> (and by the way, is there also a sorting function?)
>
> Many thanks
Look in the PL/SQL manual at Associative Arrays and the other
collection types.
Look at pipelined functions.
There is an order by clause for sorting.
HTH -- Mark D Powell -- Received on Tue Feb 20 2007 - 18:28:24 CST