sql view index

1-- Oracle  (all_indexes: depending on grants, dba_indexes: for all indexes))
2SELECT index_name FROM user_indexes WHERE table_name = 'MY_TABLE';
3-- List of indexed columns:
4SELECT index_name, column_position, column_name
5FROM user_ind_columns 		-- or all_ind_columns / dba_ind_columns
6WHERE table_name = 'MY_TABLE'  
7ORDER BY index_name, column_order;