LISTAGG1 [DB] CUBRID GROUP_CONCAT을 ORACLE로 전환 [CUBRID] SELECT (select IFNULL(GROUP_CONCAT(file_id SEPARATOR '|'), null) from ntb_file where parent_id = a.post_id) as file_content FROM ntb_post a WHERE BOARD_ID =11 [ORACLE] SELECT (SELECT NULLIF(LISTAGG (ATCH_FILE_ID, '|') WITHIN GROUP (ORDER BY ATCH_FILE_ID),'') FROM TN_FILEDETAIL WHERE ATCH_FILE_ID = a.ATCH_FILE_ID) as file_content FROM ntb_post a WHERE BOARD_ID =11 2022. 7. 29. 이전 1 다음