associative array in pl sql
DECLARE
-- declare an associative array type
TYPE t_capital_type
IS TABLE OF VARCHAR2(100)
INDEX BY VARCHAR2(50);
-- declare a variable of the t_capital_type
t_capital t_capital_type;
-- local variable
l_country VARCHAR2(50);
BEGIN
t_capital('USA') := 'Washington, D.C.';
t_capital('United Kingdom') := 'London';
t_capital('Japan') := 'Tokyo';
l_country := t_capital.FIRST;
WHILE l_country IS NOT NULL LOOP
dbms_output.put_line('The capital of ' ||
l_country ||
' is ' ||
t_capital(l_country));
l_country := t_capital.NEXT(l_country);
END LOOP;
END;
/