Oracle® PL/SQL® Interactive Workbook, Second Edition

Lab 18.3 Multilevel Collections

Lab Objective After this Lab, you will be able to: ✓ Use Multilevel Collections

So far you have seen various examples of collections with the element type based on a scalar type, such as NUMBER and VARCHAR2. In Oracle 9i, PL/SQL provides you with the ability to create collections whose element type is based on a collection type. Such collections are called multilevel collections. You will recall that multilevel collections is a new feature and is not supported by Oracle versions prior to 9i.

Consider a varrray of varrays shown in Figure 18.3.

Figure 18.3. A Varray of Varrays

Figure 18.3 shows a varray of varrays ...