Home » SQL & PL/SQL » SQL & PL/SQL » Transpose functionality
Transpose functionality [message #248270] Thu, 28 June 2007 09:06 Go to next message
arunprasad_bh
Messages: 32
Registered: June 2007
Member
Hi,
If you need to display rows as columns and columns as rows
without knowing the columns numbers or rwo numbers, how would you do it?

Thanks,
Aruna
Re: Transpose functionality [message #248273 is a reply to message #248270] Thu, 28 June 2007 09:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First search, here, on AskTom, on Google
Then comes back if you don't find anything...

We'll then explain you how to use the search functions.

Regards
Michel
Re: Transpose functionality [message #248299 is a reply to message #248273] Thu, 28 June 2007 10:22 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
http://oraqa.com/2006/03/13/how-to-turn-rows-into-columns/
Re: Transpose functionality [message #248409 is a reply to message #248270] Thu, 28 June 2007 22:42 Go to previous message
SnippetyJoe
Messages: 63
Registered: March 2007
Location: Toronto, Canada
Member

SQL Snippets: SQL Techniques Tutorials - Columns to Rows

SQL Snippets: SQL Techniques Tutorials - Rows to Columns

--
Joe Fuda
SQL Snippets
Previous Topic: How to swap two rows ina table without creating any temporary storage?
Next Topic: Foreign Key Problem
Goto Forum:
  


Current Time: Wed Dec 07 05:01:41 CST 2016

Total time taken to generate the page: 0.16653 seconds