Collections Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Collections
  4. 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>