POSTS

Oracle - Concatenate several columns in one cell separeted by newline

In order to concatenate the values of the same column across several records do:

_   select replace( wm_concat(), ‘,’, chr(13))
   from ;

_
Examples:

  • Add all distinct values in the same cell separated by “:”

         select distict(wm_concat(), ‘,’, ‘:‘)
         from ;

  • Add all values in the same cell separated by a new line “chr(13)”

_         replace(wm_concat(), ‘,’, chr(13))_