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