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