DB
Oracle CLOB 타입
SELECT CLOBAGG(REPLACE(C.CAP_CTT,'|','') || ' ##### ' ) OVER (PARTITION BY A.MY_ARTCL_ID ORDER BY A.MY_ARTCL_ID RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS CAP_CTT FROM TB_MY_ARTCL_CAP C LEFT OUTER JOIN TB_MY_ARTCL A ON A.MY_ARTCL_ID = C.MY_ARTCL_ID WHERE A.INPUT_DTM BETWEEN TO_DATE ('20200501', 'YYYYMMDDHH') AND TO_DATE('20200709','YYYYMMDDHH'); 쿼리부터. CLOB 같은 대용량 텍스트를 listagg..
