How do you use arrays in PL/SQL?
In other programming language like Java and C# you simply define as following line:
int[] iArray = new int[5];
But in PL/SQL it’s not as easy as that. Why? Because there are three types of collections and we ought to know which collection type must use. Collections are expecially very useful for caching data of lookup tables. If data is cached then amount of context-switching will be less.
