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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
