Oracle PL/SQL/System Tables Views/all indexes
ALL_INDEXES view contains information about the indexes
<source lang="sql">
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>
</source>