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






user_indexes join user_ind_columns ic using (table_name,index_name)

    
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>

   
    
    
    
  








Related examples in the same category

1.Decode column position
2.Query user_indexes and user_ind_columns table
3.Check index column and contraints for just created table