|
SQL> DECLARE
2 TYPE numberVarray IS VARRAY(10)OF NUMBER;
3
4 v_numarray numberVarray :=numberVarray(NULL,NULL);
5
6 TYPE numberTableType IS TABLE OF NUMBER;
7
8 v_numlist numberTableType :=numberTableType(NULL);
9 BEGIN
10 v_numarray(1):=1001;
11
12 v_numarray(2):=1002;
13
14 v_numarray.EXTEND;
15
16 v_numarray(3):=1003;
17
18
19 v_numlist(1):=101;
20
21 v_numlist.EXTEND(5);
22
23 v_numlist(5):=105;
24 END;
25 /
PL/SQL procedure successfully completed.
SQL>
|