Using an ampersand in the Oracle LISTAGG function

I needed to add a few HTML-rendered spaces to a LISTAGG … which meant I needed to figure out a way of getting an ampersand into the glue string. Using the concat (||) feature, I was able to glom ‘&’ and ‘nbsp;’ together as the glue:

Leave a Reply

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

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.