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

Home -> Community -> Usenet -> c.d.o.server -> Re: i have a problem

Re: i have a problem

From: Oxnard <oxnard_at_carolina.rr.com>
Date: Sat, 5 May 2007 10:37:29 -0400
Message-ID: <463c96aa$0$1427$4c368faf@roadrunner.com>

"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in message news:1178108391.812423.185950_at_h2g2000hsg.googlegroups.com...
> On May 2, 2:05 am, phoenix <abhishek.purkayas..._at_gmail.com> wrote:
>> hi,
>> i have a problem,which i am unable to solve since yesterday.The
>> problem is:-
>> i have a table with coulmns A,B,C,D,E
>> and along with data it looks like A B C D E
>> 10 20
>> 30 40 50
>> 20 100 1000
>> 40 40
>> and so
>> on ... ... .... .... ...
>>
>> i want a query by which i can get a output like
>> A 10 20 ... ....
>> B 20 100 .... ...
>> C 30 1000.... ....
>> D 40 40 ....
>> E 50 40
>>
>> i.e basically converting the columns into rows.
>>
>> can anyone suggest me a solution for the above problem??
>
> Did you look at using analytic functions?
>

do a seach on goggle for 'pivot queries' Received on Sat May 05 2007 - 09:37:29 CDT

Original text of this message

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