What is Associative Array?

 Posted by Niladri.Biswas on 5/12/2013 | Category: Oracle Interview questions | Views: 3499 | Points: 40

Oracle 9i R2 has renamed the index-by tables available in earlier versions of Oracle to Associative Arrays.Like VArrays/Nested Tables, they are also 1D array and can be use either in a relational table or in functions. They can not exist in the database and rather are found only in PL/SQL memory structures.They are use for columns having multiple values.It is basically a two-Column table where the first column is the INDEX while the second column holds the DATA ELEMENT.They are UNBOUND since they don't have any upper limits to grow.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response