oracle查看表索引的sql语句

select distinct a.table_name, a.index_name, b.index_type, listagg(a.column_name, ',') within group(order by a.column_position asc) over(partition by a.index_name) column_names from user_ind_columns a, user_indexes b where a.index_name = b.index_name and a.TABLE_NAME = b.table_name and a.table_name = upper('tb_dept_article_statics') order by a.index_name asc;