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

   <source lang="sql">
 

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>

 </source>