Agregate function, like sum(), to concatenate strings in group by
Posted on 2003-11-21
Oracle8i Enterprise Edition Release 22.214.171.124.0
Let's say i have this data:
I want a query to generate this output:
Joe Read, Sports
Bob Videogames, Sports, Cook
This is pretty much an aggregate function that concatinates text across rows (like sum() adds numbers across rows). Is there such a function? Can I create such a function? Is there another way to do this? My ASPs run the query, but I don't want to have the ASP go through the data and do the grouping. It would be nice if the SQL just returns the data in a state ready to be displayed.