Get information on all the tables you have access to using all_varrays. : all_varrays « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. all_varrays

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;