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;