SQL> create table tab1
2 (col1 number,
3 col2 number,
4 col3 number);

Table created.

SQL> create index indx1 on tab1 (col1 desc);

Index created.