Oracle Associative Arrays ?

[afdbzindabad]

oracle associative arrays or varrays lo edi vadatam better to compare huge arrays?? 

[innovative]

i prefer associative array .. dhanlo key value pairs la store chesko vachu which is not the same with varray. So, max no of elements thelisthene varray use cheyyali and also associate array element position thelipoyna key ni batti access cheskovachu .. 

 

IMO .. my vote is for associate array .. 

 

 

[afdbzindabad]

i prefer associative array .. dhanlo key value pairs la store chesko vachu which is not the same with varray. So, max no of elements thelisthene varray use cheyyali and also associate array element position thelipoyna key ni batti access cheskovachu .. 

 

IMO .. my vote is for associate array .. 

nenu already oka stored proc lo varray vaduthunna ... kani problem entantey more number of elements vuntey performance taggipothundi 

[innovative]

nenu already oka stored proc lo varray vaduthunna ... kani problem entantey more number of elements vuntey performance taggipothundi 

 

true .. ekkuva elements do not use varray .. coz same time lo anni ni elements ni store chesi and retrieve cheyyali ante chala time padthadhi if you are accessing the elements sequentially ...