index

SELECT ui.index_name,
       ui.uniqueness,
       ui.status,
       ui.tablespace_name,
       uic.column_name,
       uic.column_position,
       uic.descend
FROM user_indexes ui
JOIN user_ind_columns uic
  ON ui.index_name = uic.index_name
WHERE ui.table_name = UPPER('SEQUENCE')  -- put your table name here
ORDER BY ui.index_name, uic.column_position;