How do I implement a two dimensional array in PL/SQL.
Please note that I do not know the upper bound and I dont want to use varray for the same reason.
Is there anyway I can define a record type, add elements to the record and loop the collection when required?
All I want to implement in PL/SQL, and all TYPE OBJECTS should be declared in PL/SQL block only.
I will store this kind of data into array. I will populate the year (1st dimension) and the units (2nd dimension) based on the calculated parameters
Example to accomplish above will be real good.