Aggregating Related Text Data

[tariq malik]

i have a table with fields FILE_ID and COMMENTS. I want to show all comments in one field depending on a specific FILE_ID key in ORACLE 10G, Can u help me? I will be very grate ful to u.

[rski]

select distinct file_id,wm_concat(comments) from test group by file_id

[nbiswas]

Have a look at String Aggregation Techniques in Oracle. This will give you more ways of doing so