오라클 13 인대..
wm_concat 함수가 안먹네요..
밑에 퀴리도 안돼고
select wm_concat(job) from emp 이것도 안되네요
문법 오류인가요??

WITH T_TABLE
AS (
    SELECT '서울' city, 'T1000' pid FROM DUAL UNION ALL
    SELECT '서울' city, 'T2000' pid FROM DUAL UNION ALL
    SELECT '부산' city, 'T2000' pid FROM DUAL UNION ALL
    SELECT '서울' city, 'T3000' pid FROM DUAL UNION ALL
    SELECT '제주' city, 'T3000' pid FROM DUAL UNION ALL
    SELECT '서울' city, 'T3000' pid FROM DUAL UNION ALL
    SELECT '제주' city, 'T3000' pid FROM DUAL
)
SELECT a.pid
       ,wm_concat(a.city) AS new_column
      --replace(wm_concat(city),',','|') AS new_column
FROM  T_TABLE a
GROUP BY a.pid