ORACLE, SELECT, Строки в столбцы

SELECT
  WMSYS.WM_CONCAT(t.ALGORITM_ID) AS emp
FROM
  EMT_ALGORITM t
WHERE
  t.ALGORITM_TYPE_ID = 2
GROUP BY
  t.ALGORITM_TYPE_ID
-----------------------------
SELECT
t.dep,
wmsys.wm_concat(t.emp) AS emp
FROM
(SELECT 1 dep, 'A' emp FROM dual
UNION
SELECT 1 dep, 'B' emp FROM dual
UNION
SELECT 1 dep, 'C' emp FROM dual
UNION
SELECT 1 dep, 'D' emp FROM dual
UNION
SELECT 2 dep, 'E' emp FROM dual
UNION
SELECT 2 dep, 'F' emp FROM dual
UNION
SELECT 3 dep, 'G' emp FROM dual
UNION
SELECT 3 dep, 'H' emp FROM dual
UNION
SELECT 4 dep, 'J' emp FROM dual
)t
GROUP BY t.dep