Collections Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Collections
  4. Defining our type to be a VARRAY with 10 elements, where each element is a varying character string of up to 15 characters
SQL>
SQL> CREATE OR REPLACE TYPE mem_type IS VARRAY(10) of VARCHAR2(15)
  2  /
SQL>
SQL> drop type mem_type;