Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: i have a problem
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? Received on Wed May 02 2007 - 07:19:51 CDT
![]() |
![]() |