Chapter 18. Collections

Team-Fly    

Oracle® PL/SQL® Interactive Workbook, Second Edition
By Benjamin Rosenzweig, Elena Silvestrova
Table of Contents


Chapter Objectives

In this Chapter, you will learn about:

  • PL/SQL Tables

  • Varrays

  • Multilevel Collections

Through out this book you have explored different types of PL/SQL identifiers or variables that represent individual elements (for example, a variable that represents a grade of a particular student). However, often in your programs you want to have the ability to represent a group of elements (for example, the grades for a class of students). In order to support this technique, PL/SQL provides collection datatypes that work just like arrays available in other third-generation programming languages.

A collection is a group of elements of the same datatype. Each element is identified by a unique subscript that represents its position in the collection. In this chapter you will learn about two collection datatypes: table and varray. In addition, you will learn about multilevel collections that have been introduced in Oracle 9i and are not supported by the previous releases.


    Team-Fly    
    Top
     



    Oracle PL. SQL Interactive Workbook
    Oracle PL/SQL Interactive Workbook (2nd Edition)
    ISBN: 0130473200
    EAN: 2147483647
    Year: 2002
    Pages: 146

    Similar book on Amazon

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net