Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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

SQL> SQL> desc all_ind_columns  Name                  Null?    Type  ----------------------  INDEX_OWNER           NOT NULL VARCHAR2(30)  INDEX_NAME            NOT NULL VARCHAR2(30)  TABLE_OWNER           NOT NULL VARCHAR2(30)  TABLE_NAME            NOT NULL VARCHAR2(30)  COLUMN_NAME                    VARCHAR2(4000)  COLUMN_POSITION       NOT NULL NUMBER  COLUMN_LENGTH         NOT NULL NUMBER  CHAR_LENGTH                    NUMBER  DESCEND                        VARCHAR2(4) SQL> SQL> --select * from all_ind_columns; SQL>