Initializing 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 :=numberVarray(10,20,30,40);
  6
  7  BEGIN
  8
  9    dbms_output.put_line('The first element of v_numvarray is '|| TO_CHAR(v_numvarray(1)));
 10  END;
 11  /
The first element of v_numvarray is 10

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