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

Home -> Community -> Usenet -> c.d.o.server -> Re: extracting keys from associative array

Re: extracting keys from associative array

From: joel garry <joel-garry_at_home.com>
Date: 20 Feb 2007 13:57:48 -0800
Message-ID: <1172008668.095060.27620@v33g2000cwv.googlegroups.com>


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

Original text of this message

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