{"url":"https://husk.hatenablog.com/entry/2018/07/16/173206","blog_url":"https://husk.hatenablog.com/","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhusk.hatenablog.com%2Fentry%2F2018%2F07%2F16%2F173206\" title=\"\u3010SQL\u3011CLOB\u30c7\u30fc\u30bf\u5185\u5bb9\u306e\u5909\u66f4\uff08ORACLE\u5c02\u7528\uff09 - HUSKING - kotteri\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"HUSKING - kotteri","title":"\u3010SQL\u3011CLOB\u30c7\u30fc\u30bf\u5185\u5bb9\u306e\u5909\u66f4\uff08ORACLE\u5c02\u7528\uff09","type":"rich","version":"1.0","author_name":"huskworks53","height":"190","author_url":"https://blog.hatena.ne.jp/huskworks53/","provider_url":"https://hatena.blog","description":"REPLACE\u95a2\u6570\u3067CLOB\u5185\u6587\u5b57\u5217\u3092\u7f6e\u63db CLOB\u5f62\u5f0f\u3067\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308bXML\u30c7\u30fc\u30bf\u3092\u5909\u66f4\u3059\u308b\u969b\u306b\u4f7f\u7528\u3057\u305f\u65b9\u6cd5 UPDATE \u30c6\u30fc\u30d6\u30eb\u540d SET \u30ab\u30e9\u30e0\u540d = REPLACE(\u30ab\u30e9\u30e0\u540d, '\u7f6e\u63db\u524d\u6587\u5b57\u5217', '\u7f6e\u63db\u5f8c\u6587\u5b57\u5217') WHERE \u691c\u7d22\u6761\u4ef6; \u88dc\u8db3\uff1a\u7f6e\u63db\uff0b\u30c7\u30fc\u30bf\u53d6\u5f97\u65b9\u6cd5 SELECT REPLACE(\u30ab\u30e9\u30e0\u540d, '\u7f6e\u63db\u524d\u6587\u5b57\u5217', '\u7f6e\u63db\u5f8c\u6587\u5b57\u5217') AS DATA FROM \u30c6\u30fc\u30d6\u30eb\u540d WHERE \u691c\u7d22\u6761\u4ef6;","categories":["DB\u30fbSQL"],"published":"2018-07-16 17:32:06","width":"100%","image_url":null}