niranjan.sivaraman_at_gmail.com wrote:
> 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 ??
>
>
You can write a function that returns the columns as a varchar2 for a given index
Received on Fri Jun 10 2005 - 11:51:07 CDT
