extracting keys from associative array

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 Received on Tue Feb 20 2007 - 07:54:39 CST