Simplify PL/SQL INDEX BY tables using text subscripts

September 14, 2006

[From Builder.com]

Associative arrays, formerly called INDEX BY tables, have been a feature of the PL/SQL language since version 2. They are sparse arrays, meaning that only the elements you load into them are stored. No space is reserved for in-between index values. One of their original limitations, however, was that subscripts (i.e., the "index" of INDEX BY) must be integers.

The article continues at http://builder.com.com/5100-6388_14-6114699.html?tag=sc