oracle查表的索引

–查索引
select i.TABLE_NAME, i.index_name,i.uniqueness, ic.COLUMN_NAME,ic.COLUMN_POSITION
from dba_indexes i,dba_ind_columns ic
where i.TABLE_NAME=ic.table_name and i.TABLE_OWNER = ic.table_owner and i.owner = ic.INDEX_OWNER
and i.INDEX_NAME = ic.index_name
and i.table_name=‘UNIFIED_BILL_ORDER’ --表名
and i.owner=‘FINANCE’ --所有者

–查唯一索引
select i.TABLE_NAME, i.index_name,i.uniqueness, ic.COLUMN_NAME,ic.COLUMN_POSITION
from dba_indexes i,dba_ind_columns ic
where i.TABLE_NAME=ic.table_name and i.TABLE_OWNER = ic.table_owner and i.owner = ic.INDEX_OWNER
and i.INDEX_NAME = ic.index_name
and i.table_name=‘UNIFIED_BILL_ORDER’ --表名
and i.owner=‘FINANCE’ --所有者
and i.uniqueness=‘UNIQUE’ ;