Handy Regexp trick for Listaggs

I use the listagg function to generate a comma separated list of employees who work in department 10 from the EMP table.

To make the list more readable, I want to substitute the last comma with the word and.

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *