SQL WM_CONCAT FUNCTION

SQL WM_CONCAT FUNCTION

This function will return the select column values concatenated in single line

Example 1: 

SELECT    WM_CONCAT (DISTINCT EMPLID)
FROM    PS_JOB WHERE DEPTID=’XXX’;

WM_CONCAT(DISTINCTENAME)
---------- -----------------------
CLARK,KING,MILLER

Example 2: 

SELECT    DEPTID, COUNT (*),   WM_CONCAT (DISTINCT EMPLID)
FROM    PS_JOB GROUP BY    DEPTID;

DEPTNO  COUNT   WM_CONCAT(DISTINCTENAME)
---------- --------   --------------------------------
10                3        CLARK,KING,MILLER
20                5        ADAMS,FORD,JONES,SCOTT,SMITH
30                6        ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARD