Re: desc order index

Rahul Mehendale wrote:
>
> Hi
>
> I create a table as follows:
>
> create table a ( a number(1));
>
> Then I create index as :
>
> create index ia on a(a desc);
>
> If i see the index columns as :
>
> select index_name, table_name, column_name, column_position from
> all_ind_columns where table_name = 'A';
>
> index_name table_name column_name column_position
> IA A SYS_NC00002$ 1
>
> What is the reason for the change in the column name of the index. How to
> avoid this?
>
> TIA
>
> -rM
>
>

Rahul,

   You may find the following script useful :

     http://www.oriole.com/scripts/oriole_ind_columns.sql

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).