how are you running it, f9 or f5?
on windows? don't you need a cr/lf pair?
always better to show us with code and screenshots
It does work if I run it using f5, but not f9. I've tried cr/lf pair too.
LISTAGG(type|| ': ' ||amount, ', ' || CHR(10)) WITHIN GROUP(ORDER BY orderno)
Will it work using f5?
You won't see the linebreak in the grid unless you open the cell editor