ÀÌ ¸§
¹®¼Á¾·ù
Text ¹®¼
, Html ¹®¼
Á¦ ¸ñ
³» ¿ë
1. À¥¿¡¼ º¸´Â ¹æ¹ý... ===================== select dbms_lob.substr(Ä÷³¸í, dbms_lob.getlength(Ä÷³¸í),1) Ä÷³º°Äª from TableName where ..... 2. ÇÁ·ÒÇÁÆ®¿¡¼ º¸´Â ¹æ¹ý. ========================= SQL> set long 10000 SQL> select * from clob1 where dbms_lob.instr(clobcol, 'Oracle9i Application Server')>0;
ºñ¹Ð¹øÈ£
##
ºÎµ¿»êÇÁ·Î±×·¥Àº ºÎµ¿»ê°æ¸Å ¹× °è¾à¼¸¦ Àü¹®À¸·Î Á¦°øÇÏ´Â ¾÷üÀÔ´Ï´Ù.
¢Î 02 - 838 - 1402, Fax: 0303 - 0799 - 0135.