Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Index and Indexed columns

Re: Index and Indexed columns

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Fri, 10 Jun 2005 18:51:07 +0200
Message-ID: <42a9c35d$0$24262$ba620e4c@news.skynet.be>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US