Oracle PL/SQL/System Tables Views/all ind columns

ALL_IND_COLUMNS view contains information about the columns indexed by an index on a table

  
SQL>
SQL> select table_name, column_name from  all_ind_columns
  2  where index_name = "COUNTRY_C_ID_PK";
TABLE_NAME
------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COUNTRIES
COUNTRY_ID

SQL>