Hi All,
Indexing an associative array by BINARY_INTEGER allows a particular element to be read directly without looping through the entire array.
however, this is possible only when the index value of the element being read is known beforehand.
Otherswise, this method proves to be somewhat inefficient.
this limitation is overcome by indexing the array by a VARCHAR2 value.
this gives random(direct) access to an element without having to loop through.
Please can u provide comments on the above statement.
If possible can anyone give examples for better understanding.
Thanks,