Oracle merges multiple columns into a row wm_concat

Oracle merges multiple columns into a row wm_concat Oracle merges a column of the table after group by. The function of separating the columns by commas or merging a column of www.2cto.com in the entire table is as follows: merge a column in the table into a row select wm_concat (songid) from album_song; replace the comma in the result with "|" select replace (wm_concat (songid ),',', '|') from album_song; effect 3: name select albumid, wm_concat (songid) name from album_song group by albumid are merged by ID group; A listlistener function is added after oracle 11g, similar to select albumid, listparts (songid, ',') within group (order Albumid) albumid from album_song where albumid! = 1 group by albumid