COUNT : Varray Methods « Collections « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Collections
3. Varray Methods

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>