Multilevel collections. : Object Type « PL SQL « Oracle PL / SQL

1. Oracle PL / SQL
2. PL SQL
3. Object Type

Multilevel collections.

 
SQL>
SQL> DECLARE
  2    TYPE t_Numbers IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
  3
  4    TYPE t_MultiNumbers IS TABLE OF t_Numbers INDEX BY BINARY_INTEGER;
  5
  6    TYPE t_MultiVarray IS VARRAY(10) OF t_Numbers;
  7
  8    TYPE t_MultiNested IS TABLE OF t_Numbers;
  9
 10    v_MultiNumbers t_MultiNumbers;
 11  BEGIN
 12    v_MultiNumbers(1)(1) := 12345;
 13  END;
 14  /

PL/SQL procedure successfully completed.

SQL>

 

Related examples in the same category