The most useful User-Defined Aggregate Functions

Yes. In Oracle I've implemented a kind of group_concat because it is unavailable in Oracle. I've made a couple different versions which do a simple concat with comma-delimiting strings. Another does the same, only sorted. And there's another one that doesn't use a comma, but a special character so the results can be processed more easily when the values themselves might contain comma's too.