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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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.
    69,510 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following