connected to oracle9i enterprise edition release 9.2.0.4.0 connected as eygle
sql> create table t as select * from dba_users;
table created
sql> create index idx_username_desc on t(username desc);
index created
sql> select index_name,table_name,index_type from user_indexes where table_name='t';
index_name table_name index_type ------------------------------ ------------------------------ --------------------------- idx_username_desc t function-based normal
sql> select column_name,column_position,descend from user_ind_columns 2 where table_name='t';
