How do I concatonate the data from the same field from multiple rows
Home > IT Answers > Oracle > How do I concatonate the data from the same f...
Linus66
5 pts.
0
Q:
How do I concatonate the data from the same field from multiple rows
Oracle Developer, Oracle Data Access, Oracle 9 Database, Oracle 9
I need to concatonate data from the same field with multiplre rows witha one to many relationship.
As and example:

oder_id     product

503          corn 

503          beans

503         apples


the end result wanted would be asingle row

order_id      products

503            corn, beans, apples

Software/Hardware used:
Oracle 9
ASKED: Oct 13 2009  5:34 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carlosdl
29855 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Take a look at this similar question
Last Answered: Oct 13 2009  10:30 PM GMT by Carlosdl   29855 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0