Collection In PL/SQL. Collection In PL/SQL is an ordered group of elements of a particular data types. It can be a collection of simple data type or complex data type (like user-defined or record types). In Collection each element is identified by a unique subscript that represents its position in the collection. PL/SQL Collection is of three Types 1. Index-By Table also known as Associative Arrays 2. Varrays 3. Nested Tables In Previous Blog we already discussed about Varrays so today we will discuss about Collection type Index - by Table and Nested table and take the same example which we take for Varrays. Index-by Table (Associative Arrays) Index-by-table is a collection in which the array size is not fixed. In Index –by Table each key is unique and is used to locate the corresponding value. Key can be an integer or a string. Unlike the other collection types...
