Last post Dec 13, 2011 02:38 AM by wmec
Dec 06, 2011 11:20 AM|ying87|LINK
Dec 06, 2011 11:34 AM|ddelella|LINK
This link is written for Microsoft SQL Server but it should help provide some general concepts that will work in Oracle. The XML methods probably won't though. Hope it helps!
Dec 11, 2011 12:34 AM|olybobo|LINK
if you are using oracle 11g, you could use listagg for that...see link below
Dec 13, 2011 02:38 AM|wmec|LINK
<div sizcache="7" sizset="0">Hi *,
I have 1 query and result display as following table:
I want to combine ProductsName and Suppliers columns for duplicate ID and separate by comma, if the column has same result like Suppliers for ID=001, it will display once as following table:
Please guide me how to solve it.
Thanks in advanced.</div>
1) you can have query to only select distinct supplier
2) select all ProductsName and concat them for the given supplier