Viewing Keys (indexes) at Oracle Level

From Michael's blog.

select * from system.dba_ind_columns where table_name='ps_table_name';