VARRAY of varchar2 : Varray_of Varchar2 « Collections « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Collections
3. Varray_of Varchar2

SQL> DECLARE
  2    TYPE courseList IS VARRAY(3) OF varchar2(25);
  3    cl courseList;
  4  BEGIN
  5    cl := null;
  6    cl := courseList();
  7    cl := courseList('CS 111','CS 436');
  8    cl := courseList('CS 111',NULL,'CS 436');
  9  END;
 10  /

PL/SQL procedure successfully completed.

SQL>