여러개의 row를 하나의 row로.
DB/Oracle
2018. 3. 27. 09:08
반응형
SELECT LISTAGG(userInfo, '') WITHIN GROUP(ORDER BY userInfo) USERINFOLIST
FROM (
--------------------------------------------------------------------------
SELECT login_id || ':' || grade_cd ||':'|| user_point ||':;' userInfo
FROM TBL_USER
WHERE common_id = 'hongkill'
ORDER BY login_id DESC
-- 결과
-- hongkilldong:G001:62:;
-- hongkillsook:G002:5001:;
--------------------------------------------------------------------------
) A
-- 결과
-- hongkilldong:G001:62:;hongkillsook:G002:5001:;
반응형