ORACLE 常用查询

查询表索引字段

select t.*,i.index_type from all_ind_columns t,all_indexes i where t.index_name = i.index_name and t.table_name=upper('pu_contract_detail');