Table of number index by varchar2
SQL> DECLARE 2 TYPE charTableType IS TABLE OF NUMBER INDEX BY VARCHAR2(64); 3 charTable charTableType; 4 stringTable charTableType; 5 howmany NUMBER; 6 which VARCHAR2(64); 7 8 BEGIN 9 charTable('A') := 1; 10 charTable('B') := 2; 11 howmany := charTable('A'); 12 13 stringTable('C') := 3; 14 stringTable('D') := 1000; 15 stringTable('D') := 1001; 16 which := stringTable.FIRST; 17 dbms_output.put_line(which); 18 which := stringTable.LAST; 19 dbms_output.put_line(which); 20 howmany := stringTable(stringTable.LAST); 21 dbms_output.put_line(howmany); 22 END; 23 / C D 1001 PL/SQL procedure successfully completed. SQL> SQL> SQL>