EXTEND : 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(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>