Home » SQL & PL/SQL » SQL & PL/SQL » Transposing a table with SQL
Transposing a table with SQL [message #19726] Thu, 04 April 2002 21:00 Go to next message
Jan Hoffmann
Messages: 1
Registered: April 2002
Junior Member
hi

I'd like to transpose a table (columns to rows, rows to columns). Is there anybody who can help me?

Report message to a moderator

Re: Transposing a table with SQL [message #19745 is a reply to message #19726] Fri, 05 April 2002 07:42 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Here is an example of a pivot (rows to columns):

http://asktom.oracle.com/pls/ask/f?p=4950:8:663836::NO::F4950_P8_DISPLAYID

Report message to a moderator

Previous Topic: User_objects
Next Topic: Cursor Related issue.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 03 17:48:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.