Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Collections

 

Getting Information on Varrays

You can use the DESCRIBE command to get information on your varray types. SQL> CREATE or replace TYPE addressVarray AS VARRAY(2) OF VARCHAR2(50);   2  / Type created. SQL> SQL> DESCRIBE addressVarray;  addressVarray VARRAY(2) OF VARCHAR2(50) SQL>