user_indexes join user_ind_columns ic using (table_name,index_name) : user_ind_columns « System Tables Data Dictionary « Oracle PL/SQL Tutorial





SQL>
SQL>
SQL>
SQL> col table_name  format a15
SQL> col index_name  format a15
SQL> col unq         format a9
SQL> col column_name format a15
SQL>
SQL> set linesize 80
SQL>
SQL> break on table_name skip 1 -
>       on index_name        -
>       on unq               -
>       on status
SQL>
SQL> select   table_name
  2  ,        index_name
  3  ,        i.uniqueness as unq
  4  ,        i.status
  5  ,        ic.column_name
  6  from     user_indexes     i  join
  7           user_ind_columns ic using (table_name,index_name)
  8  where    table_name in ('EMP','DEPARTMENTS')
  9  order by table_name
 10  ,        index_name
 11  ,        unq
 12  ,        ic.column_position;

no rows selected

SQL>
SQL> --clear breaks
SQL>










30.81.user_ind_columns
30.81.1.Getting Information on the Indexes on a Column
30.81.2.Query table_name,index_name, index.uniqueness,index.status by joining user_indexes and user_ind_columns
30.81.3.Output report for user_ind_columns
30.81.4.user_indexes join user_ind_columns ic using (table_name,index_name)