Query to Check to see what Columns are Indexed on a Table

The relevant query is as follows:

SELECT column_name, index_name

FROM     all_ind_columns

WHERE  table_name = ‘<TABLE_NAME>’;

U = unique index

N = non-unique index