Show indexes

SELECT
   TABLE_NAME,
   INDEX_NAME,
   COLUMN_NAME
FROM
   DBA_IND_COLUMNS
WHERE
   TABLE_OWNER='SCOTT'
ORDER BY
   TABLE_NAME,
   COLUMN_POSITION;