I made this function in order to obtain listagg functionality when querying an SQL database at work, but only concatenate distinct values. I've found it to be very helpful. By default it inserts ", " ...