Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Transpose Oracle Table (Rows to columns)
Hi everybody,
Could u please help me in solving a problem.
The problem is to transpose columns to rows dynamically.
The original table is -
Proj Prot Pid Labcode Result
001 1 1 HGB 100.00 001 1 1 RBC 200.00 001 1 1 HCT 300.00 001 1 2 HGB 150.00 001 1 2 HCT 112.00 001 1 2 RBC 150.00 001 1 2 XYZ 102.00
So, there could be say 60 labcodes vertically for each pid.
Now, the above has to be transposed to -
Proj Prot Pid HGB RBC HCT XYZ 001 1 1 100.00 200.00 300.00 001 1 2 150.00 150.00 112.00 102.00
Any help towards a solution is highly appreciated.
Thanks.
Abhijit
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 02 1998 - 13:41:05 CST