How do I concatonate the data from the same field from multiple rows

5 pts.
Tags:
Oracle 9
Oracle 9 Database
Oracle Data Access
Oracle Developer
I need to concatonate data from the same field with multiple rows with a one to many relationship. For example:
oder_id     product 503          corn  503          beans 503     
Apples the end result wanted would be a single row order.
_id      products 503            corn, beans, apples



Software/Hardware used:
Oracle 9

Answer Wiki

Thanks. We'll let you know when a new response is added.

Take a look at this similar question: Concatenating rows of a column in Oracle 9i SQL.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • raj19
    where is answer?????????????????????????

    10 pointsBadges:
    report
  • rvijaya9
    pls explain in detail
    50 pointsBadges:
    report
  • carlosdl
    Click on the link provided in the Answer Wiki.  You will find a detailed answer there.
    77,155 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: