This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
is there a way to Express a One to Many Relationship in a Single Row using Sql-Oracle, in those cases where the returned data is repeated except for one column. Then it would be easier to return the distinct values from that column into a one single row with those values separated by commas.
I appreciate any help.
SCJP 1.4, SCJP 5.0, SCWCD 1.4, Oracle SQL Expert Exam 1Z0-047
IBM Test 255, IBM Test 730, IBM Test 142, ScrumManager® Certified.
What you're looking for is the GROUP_CONCAT() function which con combine a number of related rows into a single column with values separated by commas and/or whatever deliminator you need. Keep in mind, the name of the function in MySQL is GROUP_CONCAT, but its name likely changes between database systems as it is a non-standard command.