👉LISTAGG(): aggregates the values of a column by concatenating them into one string. Adding overflow management for a very long list of values.😀😀😁😁😁😂😂😅😅🤣🤣🤣🤣😱💥💨
Documentation: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/LISTAGG.html#GUID-B6E50D8E-F467-425B-9436-F7F8BF38D466
Gist: https://gist.github.com/loiclefevre/1ae2e9f496e0156277feeff1b6e03242
Top comments (0)