Check the index

• COLUMN index_name FORMAT A25

• COLUMN table_name FORMAT A20

• COLUMN column_name FORMAT A20

• COLUMN uniqueness FORMAT A10

• SELECT c.index_name

• ,c.table_name

• ,c.column_name

• ,i.uniqueness

• ,c.column_position Position

• FROM user_ind_columns c

• ,user_indexes i

• WHERE c.index_name = i.index_name and

• c.table_name = 'WORKLIST'

• order by c.index_name

• ,c.column_name;

Notes: