|
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>
|