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 -> Re: extracting keys from associative array

Re: extracting keys from associative array

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 20 Feb 2007 16:28:24 -0800
Message-ID: <1172017704.496968.51620@m58g2000cwm.googlegroups.com>


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

Original text of this message

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