Oracle PL/SQL/System Tables Views/all indexes

ALL_INDEXES view contains information about the indexes

  
SQL>
SQL> select table_name, index_name, uniqueness from all_indexes
  2  where table_name = "COUNTRIES";
TABLE_NAME                     INDEX_NAME                     UNIQUENES
------------------------------ ------------------------------ ---------
COUNTRIES                      COUNTRY_C_ID_PK                UNIQUE
SQL>
SQL>