Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Collections

 

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;