--■インデックス対象列参照SQL set line 150 set pages 1000 col index_name for a30 col ind_column for a100 SELECT index_name ,LISTAGG(column_name,',') within group (order by column_position) as ind_column FROM dba_ind_columns WHERE 1=1 AND table_name in ('TEST_TBL') GROUP BY index_name ORDER BY index_name / ・実行結果…