LIMIT : 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);
  5
  6  BEGIN
  7
  8    DBMS_OUTPUT.PUT_LINE('Varray Count = '||TO_CHAR(v_numarray.COUNT));
  9
 10    DBMS_OUTPUT.PUT_LINE('Varray Limit = '||TO_CHAR(v_numarray.LIMIT));
 11  END;
 12  /
Varray Count = 3
Varray Limit = 10

PL/SQL procedure successfully completed.

SQL>
SQL>