[  ¡Ý  5. oracle.sql.CLOB@  °á°ú ¿À·ù½Ã ]     

 
 

¿À¶óŬ ÇÔ¼öÁß 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>