An associative array is faster than a database table. You create one define as a TABLE OF
A nested table is a table within a table. This does seem a bit weird at first. You make a column in the outer table of type TABLE OF
Finally a VARRAY is created in a two stage process. First you define a type such as CREATE TYPE m_type AS VARRAY(10) OF
There are a couple ways to set the data in these collections. You can use a constructor. Maybe I will give you an example of that later. You can also get the data from the database. Finally you can assign one collection to another one.
Get ready as next time I am going to cover cursors. This includes REFCURSORS.