Home » SQL & PL/SQL » SQL & PL/SQL » sql output (merged)
sql output (merged) [message #343836] Thu, 28 August 2008 05:52 Go to next message
saiphani723
Messages: 36
Registered: July 2006
Location: Hyderabad
Member
I have a table with one column and the data is like below

data
1
2
3
4
5
6
7
8
9

I want the output like below.

o/p - 1,2,3,4,5,6,7,8,9

can any body tell us the query to get the above output.
Re: Sql Output [message #343858 is a reply to message #343836] Thu, 28 August 2008 06:27 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
You have recieved no replies, not because your question is difficult, but because you have decided to completely ignore the posting guidelines (which you have already been pointed towards in a previous post). Go and read the guidelines again and try following them when you edit your post.
Sql Output [message #343893 is a reply to message #343836] Thu, 28 August 2008 07:18 Go to previous messageGo to next message
saiphani723
Messages: 36
Registered: July 2006
Location: Hyderabad
Member
data
1
2
3
4
table data was like above and i want the output 1,2,3,4
can any body tell us the query to get the above output.
Re: Sql Output [message #343910 is a reply to message #343893] Thu, 28 August 2008 07:44 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Check this link. You will understand how to do it.

http://www.orafaq.com/forum/t/124040/94420/

Regards

Raj
Re: Sql Output [message #343912 is a reply to message #343893] Thu, 28 August 2008 07:45 Go to previous message
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
You could have done little more Searching instead of posting your question second time.

http://www.uaex.edu/srea/Concatenating_Multiple_Rows_Into_A_Single_String.htm
Previous Topic: Find out nth highest salary from Employee Table?
Next Topic: ORA-01467: sort key too long
Goto Forum:
  


Current Time: Thu Dec 08 14:27:17 CST 2016

Total time taken to generate the page: 0.12151 seconds