Index and Indexed columns

From: <niranjan.sivaraman_at_gmail.com>
Date: 10 Jun 2005 07:55:43 -0700
Message-ID: <1118415343.191530.205540@g44g2000cwa.googlegroups.com>

Hello Folks ,
Can some one tell me how is it possible to combine both INDEX and the INDEXED columns to be returned in a single row esp for a composite index.
Eg : Assume there are 3 index for a table as shown below .

INDX_1 ----> column A , column B
INDX_2 ----> column C , Column D , Column E
INDX_3 -----> column A

Now is there a possible way in which i will be able to retreive INDEX_NAME and the COLUMNS that particular INDEX is on ,in a single row .
Sample Output :

INDEX_NAME                  COLUMNS_INDEXED
----------------------------------------------------------------
INDX_1                     column A , column B
INDX_2                   column C , Column D , Column E
INDX_3                      column A

As of now the data Dictionary that provides indexes information is ALL_IND_COLUMNS which again displays in case of COMPOSITE INDEX in N SEPARATE ROWS (N - Being the number of columns indexed).

Can the COlumn list indexed in a COMPOSITE index be available in a single row retrival is my question ?? Received on Fri Jun 10 2005 - 09:55:43 CDT