Associative arrays : Table of Number « Collections « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Collections
3. Table of Number

SQL> DECLARE
  2    TYPE site_array IS TABLE OF NUMBER INDEX BY VARCHAR2(20);
  3    v_example_array site_array;
  4  BEGIN
  5    v_example_array('E'):=10;
  6    v_example_array('B'):=11;
  7    v_example_array('S'):=12;
  8    dbms_output.put_line(v_example_array.FIRST);
  9    dbms_output.put_line(v_example_array.LAST);
 10    dbms_output.put_line(TO_CHAR(v_example_array(v_example_array.FIRST)));
 11  END;
 12  /
B
S
11

PL/SQL procedure successfully completed.

SQL>
SQL>