needed help in associative arrays indexed by varchar
Hi,i wanted to populate a associative array which is indexed by varchar,but i'm confused in incrementing the pointer so that next records gets inserted in the next available place.
sample data:
type ty_tb_tab_acc is record ( account varchar2(30));
type ty_tb_indx_acct is table of ty_tb_tab_acc index by varchar2(35);
cursor sampls_cursor is
select account from sam_tab where clause goes in here
say my cursor returns 20 accounts. now i want these 20 accounts to be inserted into the associative array ty_tb_indx_acct
how should i loop and incrment the array?
Please share ur thoughts