Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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;