sql index of oracle code example

Example: how to select an index in oracle sql

SELECT  *
FROM    all_indexes
WHERE   table_name = 'COUNTRY';