여러개의 row를 하나의 row로.

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:;