ORACLE LISTAGG - NVARCHAR2 사용 방법

-- 기본

SELECT LISTAGG(컬럼, ‘구분자’) 
        WITHIN GROUP( 
        ORDER BY 정렬
        )
FROM 


-- NVARCHAR2 컬럼인 경우 

SELECT 
    UTL_RAW.CAST_TO_NVARCHAR2(LISTAGG(UTL_RAW.CAST_TO_RAW(컬럼), 
    UTL_RAW.CAST_TO_RAW(N‘구분자’)))
        WITHIN GROUP( 
                    ORDER BY 정렬
        ))
FROM 

-- NVARCHAR2 예시

SELECT 
    UTL_RAW.CAST_TO_NVARCHAR2(LISTAGG(UTL_RAW.CAST_TO_RAW(B.ATTACH_PATH || B.ATTACH_NAME_INT), 
    UTL_RAW.CAST_TO_RAW(N‘,’)))
        WITHIN GROUP( 
                    ORDER BY 
                                B.ATTACH_PATH || B.ATTACH_NAME_INT
        ))
FROM 
        SBB.TB_ATTACH_FILE B,
        SBB.TB_CBOARD_ATTACH_INT C