December 2002
Intermediate to advanced
928 pages
85h 29m
English
Nested collections are collections contained in members that are collections themselves. Nesting collections is a powerful way to implement object-oriented programming constructs within PL/SQL programs. This discussion is beyond the scope of this chapter but is well described in Oracle PL/SQL Programming.
Here is a simple example of specifying a nested collection:
CREATE TYPE books IS TABLE OF VARCHAR2(64); CREATE TYPE our_books IS TABLE OF books;