|
SQL> DECLARE
2 TYPE numberVarray IS VARRAY(10)OF NUMBER;
3
4 v_numarray numberVarray :=numberVarray(10,20,30,40,50);
5
6 TYPE numberTableType IS TABLE OF NUMBER;
7
8 v_numlist numberTableType :=numberTableType(101,201,301,401);
9
10 BEGIN
11
12 DBMS_OUTPUT.PUT_LINE('Varray Count = '||TO_CHAR(v_numarray.COUNT));
13
14 DBMS_OUTPUT.PUT_LINE('Nested Table Count = '||TO_CHAR(v_numlist.COUNT));
15 END;
16 /
Varray Count = 5
Nested Table Count = 4
PL/SQL procedure successfully completed.
SQL>
SQL>
|