Create Comma Separated Value strings (rows) from an Oracle query. A CSV row will have the separator between each field (can be any separator character, but comma (',') and pipe ('|') are most common).

Have a stream column ID and Account numbers, would like to concatenate the Account# as comma separated list in one row. Below is the query in SQL which creates the comma separated list with group by ...