{"id":4140,"date":"2018-08-23T10:23:36","date_gmt":"2018-08-23T01:23:36","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4140"},"modified":"2018-08-23T10:23:56","modified_gmt":"2018-08-23T01:23:56","slug":"clob-select-%ec%8b%9c-hugeclob-%ec%9c%bc%eb%a1%9c-%ed%91%9c%ec%8b%9c-%eb%90%a0-%eb%95%8c-%eb%82%b4%ec%9a%a9-%eb%b3%b4%eb%8a%94-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4140","title":{"rendered":"clob select \uc2dc hugeclob \uc73c\ub85c \ud45c\uc2dc \ub420 \ub54c \ub0b4\uc6a9 \ubcf4\ub294 \ubc29\ubc95"},"content":{"rendered":"

HUGE CLOB\u00a0<\/span><\/strong>\ub370\uc774\ud130\ud0c0\uc785\uc740 \uc77c\ubc18 \ucffc\ub9ac\ub85c \ubd88\ub7ec\uc62c \uacbd\uc6b0 HUGE CLOB \uc758 \ub0b4\uc6a9\uc774 \ubcf4\uc774\uc9c0 \uc54a\ub294\ub2e4.<\/span><\/p>\n

 <\/p>\n

\n

\ub54c\ubb38\uc5d0 \uc544\ub798\uc640 \uac19\uc774<\/p>\n


\n<\/span><\/span><\/p>\n<\/div>\n

\n

SELECT\u00a0DBMS_LOB.SUBSTR<\/strong>( \uceec\ub7fc, 500) FROM\u00a0TABLE<\/span><\/p>\n

\uc0ac\uc6a9\ud558\uc5ec SELECT \ud55c\ub2e4.<\/p>\n

 <\/p>\n

SELECT\u00a0DBMS_LOB.SUBSTR(<\/strong>\uce7c\ub7fc\uba85, DBMS_LOB.GETLENGTH(\uce7c\ub7fc\uba85), 1)<\/strong>\u00a0\u00a0 –> \uc804\uccb4 row\u00a0\ubfcc\ub9ac\uae30
\n,\u00a0DBMS_LOB.INSTR(<\/strong>\uce7c\ub7fc\uba85, ‘test’, 1, 1)\u00a0\u00a0<\/strong>\u00a0–> \uac80\uc0c9\ub41c \ub0b4\uc6a9\uc5d0 \ub300\ud55c \ub514\uc2a4\ud50c\ub808\uc774
\nFROM\u00a0 \ud14c\uc774\ube14\uba85
\nWHERE\u00a0 DBMS_LOB.INSTR(\uce7c\ub7fc\uba85, ‘test’, 1, 1) <> 0;<\/p>\n

 <\/p>\n

\uc0ac\uc6a9\ubc95
\nDBMS_LOB.SUBSTR(CLOB\uce7c\ub7fc, \uc804\uccb4\u00a0row \uac00\uc838\uc624\ub294 \uae38\uc774, offset)
\nDBMS_LOB.INSTR(CLOB\uce7c\ub7fc, \uac80\uc0c9\ub41c \ub2e8\uc5b4, offset, \uba87 \ubc88\uc9f8\uc5d0 \uc788\ub294 \uac80\uc0c9\ub41c \ub2e8\uc5b4)<\/p>\n<\/div>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

HUGE CLOB\u00a0\ub370\uc774\ud130\ud0c0\uc785\uc740 \uc77c\ubc18 \ucffc\ub9ac\ub85c \ubd88\ub7ec\uc62c \uacbd\uc6b0 HUGE CLOB \uc758 \ub0b4\uc6a9\uc774 \ubcf4\uc774\uc9c0 \uc54a\ub294\ub2e4.   \ub54c\ubb38\uc5d0 \uc544\ub798\uc640 \uac19\uc774 SELECT\u00a0DBMS_LOB.SUBSTR( \uceec\ub7fc, 500) FROM\u00a0TABLE \uc0ac\uc6a9\ud558\uc5ec SELECT \ud55c\ub2e4.   SELECT\u00a0DBMS_LOB.SUBSTR(\uce7c\ub7fc\uba85, DBMS_LOB.GETLENGTH(\uce7c\ub7fc\uba85), 1)\u00a0\u00a0 –> \uc804\uccb4 row\u00a0\ubfcc\ub9ac\uae30 ,\u00a0DBMS_LOB.INSTR(\uce7c\ub7fc\uba85, ‘test’, 1, 1)\u00a0\u00a0\u00a0–> \uac80\uc0c9\ub41c \ub0b4\uc6a9\uc5d0 \ub300\ud55c \ub514\uc2a4\ud50c\ub808\uc774 FROM\u00a0 \ud14c\uc774\ube14\uba85 WHERE\u00a0 DBMS_LOB.INSTR(\uce7c\ub7fc\uba85, ‘test’, 1, 1) <> 0;   \uc0ac\uc6a9\ubc95 DBMS_LOB.SUBSTR(CLOB\uce7c\ub7fc, \uc804\uccb4\u00a0row \uac00\uc838\uc624\ub294 \uae38\uc774, offset) DBMS_LOB.INSTR(CLOB\uce7c\ub7fc, […]<\/p>\n","protected":false},"author":1,"featured_media":4141,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[14],"tags":[1124,1125,1126],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/08\/oracletips.jpg?fit=650%2C361","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4140"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4140"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4140\/revisions"}],"predecessor-version":[{"id":4143,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4140\/revisions\/4143"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/4141"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4140"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}