I am trying to get all the indexed column names from ALL_IND_COLUMNS table for a particular table.
What I need is if the column has composite index, (i.e. COUNT(IDX) > 1) the new column populated (INDEX_COLUMNS) should contain the column names separated by ",".
Here is the example of what I am expecting
COUNT(IDX) INDEX_NAME INDEX_COLUMNS
2 IDX_A_B A,B
3 IDX_A_B_C A,B,C
1 IDX_A A