Oracle PL/SQL Tutorial/System Tables Data Dictionary/all varrays

Get information on all the tables you have access to using all_varrays.

   <source lang="sql">

SQL> SQL> desc all_varrays;

Name           Null?    Type
OWNER                   VARCHAR2(30)
PARENT_TABLE_NAME       VARCHAR2(30)
PARENT_TABLE_COLUMN     VARCHAR2(4000)
TYPE_OWNER              VARCHAR2(30)
TYPE_NAME               VARCHAR2(30)
LOB_NAME                VARCHAR2(30)
STORAGE_SPEC            VARCHAR2(30)
RETURN_TYPE             VARCHAR2(20)
ELEMENT_SUBSTITUTABLE   VARCHAR2(25)

SQL> SQL> --select * from all_varrays;</source>