Oracle 11gR2 introduces a new analytical and reporting function LISTAGG that orders data within each group based on the
Why Listagg AAAAARGH!? If I had taken the time 2 weeks ago to familiarize myself with the new features in 11gR2, I wouldn't have written a function to do exactly what LISTAGG does!
ORDER BY clause and then concatenates the values of the measure column. See Chapter 22 in the Oracle Data Warehousing Guide 11g Release 2. Why Listagg AAAAARGH!? If I had taken the time 2 weeks ago to familiarize myself with the new features in 11gR2, I wouldn't have written a function to do exactly what LISTAGG does!
No comments:
Post a Comment