SQL>create index i_bonus_ename on bonus(ename) reverse;


SQL> select * from user_indexes
        where index_name='i_bonus_ename';

INDEX_NAME      INDEX_TYPE    TABLE_OWNER      TABLE_NAME
----------------------------------------------------------
I_BONUS_ENAME  NORMAL/REV  SCOTT          BONUS