|
¿À¶óŬ ÇÔ¼öÁß WM_CONCAT() ÇÔ¼ö¸¦ »ç¿ëÇÏ¸é ±âº»ÀûÀ¸·Î VARCHAR typeÀ¸·Î returnÇÑ´Ù. ±×·±µ¥, °á°ú°ªÀÌ ³Ê¹« ±æ °æ¿ì ¿À¶óŬÀº CLOB typeÀ¸·Î returnÇÏ°Ô µÇ°í, myBatis, JAVA¿¡¼´Â CLOB typeÀÌ ¾ø±â ¶§¹®¿¡ ÃÖÁ¾°á°ú´Â "oracle.sql.CLOB@ ..."¿Í °°Àº ¿À·ù°ªÀÌ RETURN µÈ´Ù.
ÇØ°á¹æ¹ý : ¿ø·¡ clob typeÀ» stringÀ¸·Î º¯È¯ÇÏ´Â Mybatis ±¸¹®ÀÌ ÀÖÁö¸¸ ÀÌ»óÇÏ°Ô WM_CONCAT()ÇÔ¼ö °á°ú Ä÷³¿¡ ´ëÇØ¼´Â Àû¿ëµÇÁö ¾Ê´Â´Ù. ±×·¡¼ TO_CHAR( WB_CONCAT(. ... ) ) ¿Í °°¾Æ . TO_CHAT()ÇÔ¼ö·Î ¹¾î ÁØ´Ù. ¹®¾à, TO_CHAR()ÇԷεµ ¾ÈµÇ¸é TO_CHAR(SUBSTR(Ä÷³¸í, 1, 2000)) AS Ä÷³¸í °ú °°ÀÌ SUBSTR(0ÇÔ¼öµµ »ç¿ëÇÏ¸é µÈ´Ù.
<sqlMap namespace="BPPA0080"> <select id="selectShopList" parameterClass="java.util.HashMap" resultClass="java.util.HashMap" > SELECT /* BPPA0080.shopList */ AREA2_CLS_CD , AREA2_CLS_NM , SHOP_CLS_NM , TO_CHAR(SUBSTR(BEF_YY_LIST, 1, 4000)) AS BEF_YY_LIST , TO_CHAR(SUBSTR(NEXT_YY_OPEN_LIST, 1, 2000)) AS NEXT_YY_OPEN_LIST FROM TABLE_NAME </select> </sqlMap>
|