Collections (VARRAYS and Nested Tables)

  • Bulusu Lakshman


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.


Individual Element Object Type Count Loop Table Function Collection Variable 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Bulusu Lakshman 2003

Authors and Affiliations

  • Bulusu Lakshman

There are no affiliations available

Personalised recommendations