--■インデックス対象列参照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 /
・実行結果
INDEX_NAME IND_COLUMN ------------------------------ ---------------------------------------------------------------------------------------------------- TEST_TBL_IDX1 COL01,COL02,COL03,COL04,COL05 TEST_TBL_IDX2 PK01,COL01 TEST_TBL_IDX3 PK01,PK02,COL01 TEST_TBL_IDX4 PK01,PK02,COL02,COL03
