I was pondering since this weekend on what should I include in my blog until I found something exciting about the listagg, A built in function in oracle. Let us see what enhancement has been included on this function in oracle in 19c.
ListAgg is one the favorite choice of an interviewer, but very few of us would know that
With ORACLE 19c another gap in the listagg feature was filled. Now we are able to do a native distinct operation on the values in the list, so that the list no longer contains duplicates.
In prior releases we had to deduplicate the values before using them in the listagg, which was rather dreadful when doing other group functions in the same query.