Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: extracting keys from associative array
On Feb 20, 5:47 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
Search on asktom.oracle.com for "associative array" (with the quotes). Do the same search at tahiti.oracle.com. And see http://www.psoug.org/reference/associative_arrays.html
Now send me as much money as you think that is worth.
jg
-- @home.com is bogus. http://www.tombstonehearse.com/Received on Tue Feb 20 2007 - 15:57:48 CST