Collections (VARRAYS and Nested Tables)
Oracle9 i supports three types of collection data types: index-by tables, VARRAYS (variable size arrays), and nested tables. Index-by tables are unbounded single-dimensional arrays. They were introduced in PL/SQL 2 (with Oracle7) and enhanced in PL/SQL 2.3 (with Oracle7.3) with the addition of table attributes. Chapter 3 covered index-by tables. This chapter highlights the features of the other two types of collections, VARRAYS and nested tables.
KeywordsIndividual Element Object Type Count Loop Table Function Collection Variable
Unable to display preview. Download preview PDF.