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>