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.

   <source lang="sql">

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;</source>