set pages 200
col coluna format a35
break on table_name on index_name skip 1
SELECT i.table_name, i.index_name, lpad( c.column_position, 2, '0' )|| '-' || c.column_name coluna
FROM dba_indexes i join dba_ind_columns c on ( i.owner = c.index_owner and i.index_name = c.index_name )
WHERE owner='SCHEMA'
ORDER BY i.table_name, i.index_name, c.column_position
/

hostgator