Defining a VARRAY : Varray of Number « Collections « Oracle PL/SQL Tutorial






SQL>
SQL> DECLARE
  2
  3    TYPE numberVarray IS VARRAY(5)OF NUMBER;
  4
  5    v_numvarray numberVarray;
  6
  7  BEGIN
  8
  9    /*Do some processing */
 10
 11    null;
 12
 13  END;
 14  /

PL/SQL procedure successfully completed.

SQL>
SQL>








26.6.Varray of Number
26.6.1.Defining a VARRAY
26.6.2.Initializing a VARRAY
26.6.3.NULL VARRAYS and NULL Elements
26.6.4.Is a varray null value
26.6.5.Pass NULL value to varray
26.6.6.Accessing VARRAY elements
26.6.7.Multilevel Collections