associative array in oracle with example
Example: associative array in pl sql
DECLARE
TYPE t_capital_type
IS TABLE OF VARCHAR2(100)
INDEX BY VARCHAR2(50);
t_capital t_capital_type;
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;
/