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
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: 283
Registered: December 2006
Location: Netherlands
Senior Member
search for pivoting in this forum.

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: 7062
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
Previous Topic: Seeing things (list partition)
Next Topic: Regarding Error with Trigger
Goto Forum:
  


Current Time: Tue Dec 06 02:56:22 CST 2016

Total time taken to generate the page: 0.16865 seconds