46 of 62
Associative Arrays - Example 2a
uPrepare memory structure
udeclare
u type list_aa is
table of VARCHAR2(2000)
u index by
VARCHAR2(256);
u v_list_aa list_aa;
cursor c_emp is
select ename,
deptno,to_char(hiredate,'q') q_nr
from emp;
v_key_tx
VARCHAR2(256);
begin
for r_d in (select
deptno from dept order by 1) loop
v_list_aa(r_d.deptno||'|1'):=
'Q1 Dept#'
||r_d.deptno||':';
v_list_aa(r_d.deptno||'|2'):=
'Q2 Dept#'
||r_d.deptno||':';
...
end loop;