Home » SQL & PL/SQL » SQL & PL/SQL » Quer to select value of a column as comma seperated string
Quer to select value of a column as comma seperated string [message #231784] Wed, 18 April 2007 07:16 Go to next message
kukreja
Messages: 33
Registered: February 2007
Member
I have a table say emp having column name
This column has value like
prashat
kukreja
tom
kyte

now i want to write query such that when query this column output should like

prashant,kukreja,tom,kyte

Report message to a moderator

Re: Quer to select value of a column as comma seperated string [message #231785 is a reply to message #231784] Wed, 18 April 2007 07:20 Go to previous messageGo to next message
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
Senior Member
search for pivoting in this forum.

Report message to a moderator

Re: Quer to select value of a column as comma seperated string [message #231789 is a reply to message #231785] Wed, 18 April 2007 07:31 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Search terms you can try are: STRAGG, CONCAT_ALL, SYS_CONNECT_BY_PATH, pivot, ...

This one's closed.

http://www.orafaq.com/forum/fa/448/0/

MHE

Report message to a moderator

Previous Topic: Seeing things (list partition)
Next Topic: Regarding Error with Trigger
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 11 22:19:33 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.