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;
oracle查看表索引的sql语句
最新推荐文章于 2024-08-18 15:07:14 发布