Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Get information on all the indexes you have access to using all_views

SQL> SQL> desc all_views;  Name                       Null?    Type  ---------------------------  OWNER                      NOT NULL VARCHAR2(30)  VIEW_NAME                  NOT NULL VARCHAR2(30)  TEXT_LENGTH                         NUMBER  TEXT                                LONG  TYPE_TEXT_LENGTH                    NUMBER  TYPE_TEXT                           VARCHAR2(4000)  OID_TEXT_LENGTH                     NUMBER  OID_TEXT                            VARCHAR2(4000)  VIEW_TYPE_OWNER                     VARCHAR2(30)  VIEW_TYPE                           VARCHAR2(30)  SUPERVIEW_NAME                      VARCHAR2(30) SQL> SQL> --select * from all_views; SQL>