concatenation

[Quoted] I am hoping someone out there can help me with this problem. In an oracle database I would like to concatenate all the data from different entries in one field into one large entry.

I have a a column called diary.notes which has many entries for each call it is related to. I am trying to take all the diary.notes for each call and concatenate them into one large entry. How can I do this.

If you can help me please write to me at hagenj_at_mail.dec.com

                                                                                                        Thank You Received on Mon Aug 11 1997 - 00:00:00 CEST