Oracle 数据库查看数据表的索引信息

col INDEX_NAME for a45;
col COLUMN_NAME for a45;
set linesize 280;
select dba_ind_columns.index_name,
       dba_ind_columns.column_name,
       dba_ind_columns.column_position,
       dba_indexes.uniqueness
  from dba_ind_columns, dba_indexes
 where dba_ind_columns.index_name = dba_indexes.index_name
   and dba_ind_columns.table_name = 'TABLE_NAME';