47 of 62
Associative Arrays - Example 2b
uProcess data and present results
...
for r_emp in c_emp loop
v_list_aa(r_emp.deptno||'|'||r_emp.q_nr):=
list_aa(r_emp.deptno||'|'||r_emp.q_nr)||
'
'||r_emp.ename;
end loop;
v_key_tx:=v_list_aa.first;
loop
DBMS_OUTPUT.put_line
(v_list_aa(v_key_tx));
v_key_tx:=v_list_aa.next(v_key_tx);
exit when v_key_tx is
null;
end loop;
end;