how to check index column in oracle table code example
Example: oracle show index columns
SELECT TABLE_NAME, INDEX_NAME, COLUMN_NAME
FROM DBA_IND_COLUMNS -- or ALL_IND_COLUMNS
WHERE TABLE_OWNER = 'MY_SCHEMA' AND TABLE_NAME = 'MY_TABLE'
ORDER BY TABLE_NAME, COLUMN_POSITION;