select COLUMN_NAME from all_ind_columns a where TABLE_OWNER='用户名' and a.INDEX_NAME=(select b.INDEX_NAME from all_indexes b where OWNER='用户名' and TABLE_NAME='表名' and UNIQUENESS='UNIQUE');
两张有关的表all_indexes: 系统视图存放是索引的名称以及该索引是否是唯一索引等信息。all_ind_columns: 系统视图存放的是索引名称,对应的表和列等。获取唯一索引select COLUMN_NAME from all_ind_columns a where TABLE_OWNER='用户名' and a.INDEX_NAME=(select b.INDEX_NAME from all_indexes b where OWNER='用户名' and TABLE_NAME