ajexpert
asked on
Two dimensional array in oracle
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
2004,1
2004,2
2004,3
2005,1
2005,2
2005,3
2005,4
Example to accomplish above will be real good.
&.
&.
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
2004,1
2004,2
2004,3
2005,1
2005,2
2005,3
2005,4
Example to accomplish above will be real good.
&.
&.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have already seen this URL before posting question.
The way its described is in bit convoluted manner. The I assume there is simpler way of doing this.