Home » SQL & PL/SQL » SQL & PL/SQL » Concatenation
Concatenation [message #226760] Mon, 26 March 2007 08:30 Go to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi
how can i Concatenation two value of the same column

select * from goods
i get goods_name
1.milk
2.food
i need to Concatenation milk food as a single word
thanxs
Re: Concatenation [message #226766 is a reply to message #226760] Mon, 26 March 2007 08:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Search for STRAGG on http://asktom.oracle.com

Regards
Michel
Re: Concatenation [message #226775 is a reply to message #226766] Mon, 26 March 2007 08:58 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
We have a search button too. It works. Search for CONCAT_ALL.

edit: one link.

MHE

[Updated on: Mon, 26 March 2007 09:00]

Report message to a moderator

Re: Concatenation [message #226951 is a reply to message #226760] Tue, 27 March 2007 00:25 Go to previous messageGo to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi
show all values of a column in single row through SQL
ie:

1.milk
2.food
3.other's
column name type_goods
milk,food,others
Re: Concatenation [message #226979 is a reply to message #226951] Tue, 27 March 2007 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Read the answers above.
Why do you repost the same question?
The answers will be the same ones.

Regards
Michel
Re: Concatenation [message #226983 is a reply to message #226979] Tue, 27 March 2007 01:01 Go to previous message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,

Quote:
maheer wrote
We have a search button too. It works.



i go with maheer. yes it works fine.
when i used it ,i found the below

search1

search2

search3


regards,
shanth.

Previous Topic: PL/SQL
Next Topic: How to use trigger on blob column
Goto Forum:
  


Current Time: Mon Dec 05 14:59:15 CST 2016

Total time taken to generate the page: 0.08394 seconds