index in oracle sql code example

Example: how to select an index in oracle sql

SELECT  *
FROM    all_indexes
WHERE   table_name = 'COUNTRY';