Updating a recordset
A varray is appropriate when: To create a collection, you define a collection type and then declare variables of that type.
You can define a collection type either at schema level, inside a package, or inside a PL/SQL block.
For example: An associative array (formerly called an index-by table) is a set of key-value pairs.NLS Parameter Values Can Affect String Keys of Associative Arrays Associative arrays that are indexed by strings can be affected by National Language Support (NLS) parameters such as .If you must change these settings during your session, set them back to their original values before performing further operations on associative arrays that are indexed by strings.have internal components that you can treat as individual variables.You can pass composite variables to subprograms as parameters.
Example 5-1 declares an associative array that is indexed by a string, populates it, and prints it.