ALL_IND_COLUMNS view contains information about the columns indexed by an index on a table : all_ind_columns « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. 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>

   
    
  

Related examples in the same category