Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: i have a problem
"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