Oracle PL/SQL Tutorial/System Tables Data Dictionary/all nested tables

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

SQL>
SQL> desc all_nested_tables;
 Name          Null?    Type
 OWNER                  VARCHAR2(30)
 TABLE_NAME             VARCHAR2(30)
 TABLE_TYPE_OWNER       VARCHAR2(30)
 TABLE_TYPE_NAME        VARCHAR2(30)
 PARENT_TABLE_NAME      VARCHAR2(30)
 PARENT_TABLE_COLUMN    VARCHAR2(4000)
 STORAGE_SPEC           VARCHAR2(30)
 RETURN_TYPE            VARCHAR2(20)
 ELEMENT_SUBSTITUTABLE  VARCHAR2(25)
SQL>
SQL> --select * from all_nested_tables;