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: can I do this in SQL??

Re: can I do this in SQL??

From: John David Birch <john.birch_at_usa.net>
Date: Fri, 22 Oct 1999 12:35:43 GMT
Message-ID: <zSYP3.148$OO.4220@juliett.dax.net>


yes, certainly. Here is a little query to get you going: (It handles upto 4 members but you can see the pattern and how to extend it:

select i.index_name index_name,
(
 select c1.column_name from user_ind_columns c1  where i.index_name=c1.index_name
 AND rownum<=1
) column_name_1,
(
 select c2.column_name from user_ind_columns c2  where i.index_name=c2.index_name
 AND not c2.column_name in
 ( select c2a.column_name from user_ind_columns c2a    where i.index_name=c2a.index_name
 AND rownum<2 )
 AND rownum=1
) column_name_2,
(
 select c3.column_name from user_ind_columns c3  where i.index_name=c3.index_name
 AND NOT c3.column_name in
 ( select c3a.column_name from user_ind_columns c3a    where i.index_name=c3a.index_name
 AND rownum<3 )
 AND rownum=1
) column_name_3,
(
 select c4.column_name from user_ind_columns c4  where i.index_name=c4.index_name
 AND NOT c4.column_name in
 ( select c4a.column_name from user_ind_columns c4a    where i.index_name=c4a.index_name
 AND rownum<4 )
 AND rownum=1
) column_name_4
from user_indexes i
;

Have fun !
John David Birch

Jorge <pumuky22_at_usa.net> wrote in message news:7umovi$t98$1_at_diana.bcn.ttd.net...
> Hi everyone, I'm trying to do this select ....
> I have two tables (user_indexes and user_ind_columns) and I want this
> output:
>
>
> index1 column1 column2 column3
> by row
>
> thanks
>
>
Received on Fri Oct 22 1999 - 07:35:43 CDT

Original text of this message

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