Oracle-L: Re: desc order index

From: <Rick_Cale_at_teamhealth.com>
Date: Tue, 22 Oct 2002 06:24:33 -0800
Message-ID: <F001.004EFC0B.20021022062433@fatcity.com>

I am not positive but since you are creating a function-based index Oracle generates its only index column name.

Rick

                                                                                                                             
                    "Rahul Mehendale"                                                                                        
                    <rahul.mehendale_at_tatainf       To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    otech.com>                     cc:                                                                       
                    Sent by:                       Subject:     desc order index                                             
                    root_at_fatcity.com                                                                                         
                                                                                                                             
                                                                                                                             
                    10/22/2002 09:58 AM                                                                                      
                    Please respond to                                                                                        
                    ORACLE-L

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul Mehendale
  INET: rahul.mehendale_at_tatainfotech.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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Rick_Cale_at_teamhealth.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).

Received on Tue Oct 22 2002 - 09:24:33 CDT