Recently we began investigating the Oracle listAgg string aggregate in our Oracle environments. I looked out for suggestions and vote status and found this link here:
It seems to me like this is a common question that comes up in this forum frequently. Yes, I am fully aware that the XML method provides a reasonable workaround for this issue; however, the advantage of the listAgg() aggregate (or whatever it might
be called) is that it simplifies coding. I admit that this is not a "top priority" issue for me; however, based on questions that I have seen here over the past 4 years It seems like a useful addition to T-SQL.
A couple of things:
- Is this too peripheral for ANSI purists?
- Am I off base in assessing that this is a "very common issue"?
- What is your take on this issue?
Please! Mudslinging comments and insults are welcome!
View Complete Post