查看哪些列上建了索引

hr@ORCL> column column_name format a22 heading 'Column Name'
hr@ORCL> column index_name heading 'Index Name'
hr@ORCL> column column_position format 999999999 heading 'Pos#'
hr@ORCL> column descend format a5 heading 'Order' 
hr@ORCL> column column_expression format a40 heading 'Expression' 
hr@ORCL> break on index_name skip 1

select lower(b.index_name) index_name, b.column_position, 
 b.descend, lower(b.column_name) column_name 
from all_ind_columns b 
 where b.table_owner = 'HR' 
 and b.table_name = 'EMPLOYEES' 
 order by b.index_name, b.column_position, b.column_name 
 / 
Index Name Pos# Order Column Name 
------------------------------ ---------- ----- ------------------ 
emp_department_ix 1 ASC department_id 
emp_email_uk 1 ASC email 
emp_emp_id_pk 1 ASC employee_id 
emp_job_dept_ix 1 ASC department_id 
2 ASC job_id 
emp_job_ix 1 ASC job_id 
emp_manager_ix 1 ASC manager_id 
emp_name_ix 1 ASC last_name 
2 ASC first_name