Home » SQL & PL/SQL » SQL & PL/SQL » rows into columns and columns into rows
rows into columns and columns into rows [message #287693] Thu, 13 December 2007 03:34 Go to next message
johnpm
Messages: 1
Registered: December 2007
Junior Member
i have a table having three columns and four rows
how do i display rows into columns and columns into rows?
Re: rows into columns and columns into rows [message #287701 is a reply to message #287693] Thu, 13 December 2007 03:45 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
you will find many examples:
its called pivot

regards,

[Updated on: Thu, 13 December 2007 03:46]

Report message to a moderator

Re: rows into columns and columns into rows [message #287703 is a reply to message #287693] Thu, 13 December 2007 03:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/m/286447/102589/?srch=sqlsnippets#msg_286447

Regards
Michel
Re: rows into columns and columns into rows [message #288095 is a reply to message #287693] Fri, 14 December 2007 15:31 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
you should be searching ORAFaq, you would have found this...

http://www.orafaq.com/node/1871

Good luck, Kevin
Previous Topic: Sequencing help
Next Topic: definition of view
Goto Forum:
  


Current Time: Fri Dec 09 21:29:42 CST 2016

Total time taken to generate the page: 0.21997 seconds