Oracle 8i and 9i PL/SQL Collections and Records

DML with Collections

Retrieve nested table

Retrieve single entry in nested table

Insert nested table

Insert single entry into nested table

Update nested table

Update single entry into nested table

Delete nested table

Delete single entry from nested table


	Let’s look at the code seen in the paper, the rather morbid, whimsical model of soul tracking.

	To perform DML on collections, the collection must be unnested with TABLE.