Table of numbers and varray of numbers
SQL>
SQL> DECLARE
2 TYPE t_IndexBy IS TABLE OF NUMBER
3 INDEX BY BINARY_INTEGER;
4 TYPE t_Nested IS TABLE OF NUMBER;
5 TYPE t_Varray IS VARRAY(10) OF NUMBER;
6
7 v_IndexBy t_IndexBy;
8 v_Nested t_Nested;
9 v_Varray t_Varray;
10 BEGIN
11 v_IndexBy(1) := 1;
12 v_IndexBy(2) := 2;
13 v_Nested := t_Nested(1, 2, 3, 4, 5);
14 v_Varray := t_Varray(1, 2);
15 END;
16 /
PL/SQL procedure successfully completed.
SQL>
SQL>
Related examples in the same category