Home » SQL & PL/SQL » SQL & PL/SQL » oracle transpose
oracle transpose [message #419520] Sun, 23 August 2009 20:16 Go to next message
neeharika1
Messages: 1
Registered: August 2009
Junior Member
hi I am working on oracle 10g i am looking for transpose ie converting rows to column. Please help if any one has worked on it.

Thanks
Neeharika
Re: oracle transpose [message #419521 is a reply to message #419520] Sun, 23 August 2009 20:59 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
try this

Example of Data Pivots in SQL (rows to columns and columns to rows)

There is also a new pivot function/operator in Oracle SQL. I believe it is available in 10g, but I have never used it.

Kevin
Re: oracle transpose [message #419523 is a reply to message #419521] Sun, 23 August 2009 22:08 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Kevin Meade wrote on Mon, 24 August 2009 11:59
There is also a new pivot function/operator in Oracle SQL. I believe it is available in 10g, but I have never used it.


11g
Previous Topic: ORA-06530: Reference to uninitialized composite
Next Topic: creatingf function
Goto Forum:
  


Current Time: Sat Dec 03 22:31:23 CST 2016

Total time taken to generate the page: 0.11915 seconds