Query user_indexes and user_ind_columns table : user_ind_columns « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. user_ind_columns

Query user_indexes and user_ind_columns table

   
SQL>
SQL>
SQL> SELECT dic.table_name, dic.index_name,
  2         DECODE(di.uniqueness, 'UNIQUE', 'YES', 'NO')uniqueness,
  3         dic.column_position, dic.column_name
  4  FROM   user_indexes di, user_ind_columns dic
  5  WHERE  dic.table_name  = di.table_name
  6  AND    dic.index_name  = di.index_name
  7  and    rownum < 50
  8  ORDER BY dic.table_name, dic.index_name,
  9           di.uniqueness desc, dic.column_position;

no rows selected

SQL>








Related examples in the same category

1.Decode column position
2.user_indexes join user_ind_columns ic using (table_name,index_name)
3.Check index column and contraints for just created table