Home » SQL & PL/SQL » SQL & PL/SQL » horizontal data by column name
horizontal data by column name [message #193848] Tue, 19 September 2006 12:23 Go to next message
rajuakula
Messages: 63
Registered: March 2005
Member
Hi,

I have the o/p

empno ename sal
1 aa 100
2 bb 200
3 cc 150

now I need my output as

empno 1,2,3
ename aa,bb,cc
sal 100,200,150

thanks
Re: horizontal data by column name [message #193853 is a reply to message #193848] Tue, 19 September 2006 12:54 Go to previous messageGo to next message
scerch
Messages: 38
Registered: September 2004
Member
Look here:

http://www.orafaq.com/forum/t/6048/0/
Re: horizontal data by column name [message #193858 is a reply to message #193853] Tue, 19 September 2006 13:35 Go to previous messageGo to next message
rajuakula
Messages: 63
Registered: March 2005
Member
Is there a simple way rather than this I am confused
Re: horizontal data by column name [message #193878 is a reply to message #193858] Tue, 19 September 2006 15:42 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Barbara suggested 4 (four) methods. Which one confuses you the most? Don't use that one. Use the one that confuses you the least.
Previous Topic: How to find out no rows in a SQL
Next Topic: How to execute the result
Goto Forum:
  


Current Time: Thu Dec 08 16:40:04 CST 2016

Total time taken to generate the page: 0.09341 seconds