Re: Oracle 9i and Release 2

From: John Russell <netnews4_at_johnrussell.mailshell.com>
Date: Fri, 20 Sep 2002 00:24:49 GMT
Message-ID: <ttpkou4se0nh7u2vgrq0p59qh3a9134j6f@4ax.com>

On 15 Sep 2002 14:41:02 -0700, billiauk_at_yahoo.co.uk (Adrian Billington) wrote:
>There are several new features in 9i Release Two that you might be
>interested in as well as many bug fixes. It is not "just" an upgrade
>by any means. For example, you get associative arrays (HUGE HUGE HUGE
>feature - did I mention they were HUGE)...

I have my own uses for PL/SQL associative arrays, mostly derived from Perl. E.g. to run through an unordered list of items and check whether I've already seen one before. Or to store a set of function results so that the result for a given parameter can be retrieved without calling the function again. (Got rid of a few few big DECODE()s that way.)

Pre-9.2, I had to hash everything to a number because the index was numeric. Much more convenient in 9.2, where the index can be a string.

Just curious about the uses that you've found for for this feature.

John Received on Thu Sep 19 2002 - 19:24:49 CDT