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

Home -> Community -> Usenet -> c.d.o.misc -> extracting keys from associative array in PL/SQL

extracting keys from associative array in PL/SQL

From: Filipe David Borba Manana <fdmanana_at_cern.ch>
Date: Tue, 20 Feb 2007 14:54:11 +0100
Message-ID: <ereui3$i0m$1@cernne03.cern.ch>


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:11 CST

Original text of this message

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