오라클 가로를 세로로, LISTAGG… WITH GROUP…

■ 오라클 가로를 세로로, LISTAGG… WITH GROUP…
 
 
 

WITH BASE AS (
    SELECT '최유신' AS NAME FROM DUAL UNION ALL
    SELECT '손유신' AS NAME FROM DUAL UNION ALL
    SELECT '김유신' AS NAME FROM DUAL UNION ALL
    SELECT '이유신' AS NAME FROM DUAL UNION ALL
    SELECT '박유신' AS NAME FROM DUAL
)
SELECT LISTAGG(BASE.NAME,'^')
       WITHIN GROUP ( ORDER BY BASE.NAME desc )
       AS NAME
  FROM BASE

 
 
 

LISTAGG WITHIN GROUP