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';
