December 2002
Intermediate to advanced
928 pages
85h 29m
English
Once you have declared any of these collections, you must create an instance of the collection, as in:
TYPE index_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; indtab index_table;
where indtab is an instance of index_table.
You can use the %TYPE attribute of a collection to link another collection’s datatype to it—for example:
TYPE varray1 IS VARRAY(20) OF NUMBER; v1 varray1; v2 v1%type;
If the definition of v1 changes, the definition of v2 will change along with it.