Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Get information on all the tables you have access to using 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;