{"id":5008,"date":"2025-02-27T17:03:36","date_gmt":"2025-02-27T09:03:36","guid":{"rendered":"https:\/\/qaqaq.top\/?p=5008"},"modified":"2025-02-27T17:13:52","modified_gmt":"2025-02-27T09:13:52","slug":"oracle-%e4%b8%ad%e4%bd%bf%e7%94%a8%e6%ad%a3%e5%88%99%e8%a1%a8%e8%be%be%e5%bc%8f%e5%8c%b9%e9%85%8d%e4%b8%ad%e6%96%87","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=5008","title":{"rendered":"ORACLE \u4e2d\u4f7f\u7528\u6b63\u5219\u8868\u8fbe\u5f0f\u5339\u914d\u4e2d\u6587"},"content":{"rendered":"\n<p>ORACLE \u4e2d\u7684\u6b63\u5219\u8868\u8fbe\u5f0f\u6709\u5173\u7684\u51fd\u6570\u662f\u4e0d\u80fd\u50cf\u5176\u4ed6\u8bed\u8a00\u4e00\u6837\u4f7f\u7528 [\\u4e00-\\u9fa5] \u6765\u5339\u914d\u4e2d\u6587\u7684<\/p>\n\n\n\n<p>REGEXP_INSTR\uff0cREGEXP_SUBSTR\uff0cREGEXP_REPLACE\uff0cREGEXP_COUNT\uff0cREGEXP_LIKE<\/p>\n\n\n\n<p>\u9700\u8981\u5148\u4f7f\u7528 <em>UNISTR<\/em> \u51fd\u6570\u5c06 Unicode \u8f6c\u6362\u4e3a Unicode \u4ee3\u7801\u70b9\uff08\u4e2d\u6587\uff09\uff0c\u7136\u540e\u4f7f\u7528\u8f6c\u6362\u540e\u7684\u6b63\u5219\u8868\u8fbe\u5f0f\u6765\u5339\u914d\u4e2d\u6587<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- ORACLE \u4e2d\u4f7f\u7528\u6b63\u5219\u8868\u8fbe\u5f0f\u5339\u914d\u4e2d\u6587\nSELECT REGEXP_INSTR('abc\u4e2d\u6587\u6d4b\u8bd5','&#91;' || UNISTR('\\4e00') || '-' || UNISTR('\\9fa5') || ']') FROM dual;<\/code><\/pre>\n\n\n\n<p>\u5339\u914d\u4e2d\u6587\u8f6c\u6362\u540e\u7684\u6b63\u5219\u8868\u8fbe\u5f0f\u4e3a [\u4e00-\u9fa5]<\/p>\n\n\n\n<p>ASCIISTR \u51fd\u6570\uff0c\u8fd4\u56de\u5b57\u7b26\u4e32\u7684\u89c4\u5219\u8868\u73b0\u5f62\u5f0f\uff0c\u82f1\u6587\u548c\u6570\u5b57\u53d8\u4e3a\u89c4\u5219\u7684\uff0c\u4e2d\u6587\u5219\u524d\u9762\u6709 \u201f\\\u201f \u7b26\u53f7\uff0c\u8fd4\u56de Unicode \u7f16\u7801\u5f62\u5f0f\uff0c\u4e0e <em>UNISTR<\/em> \u51fd\u6570\u529f\u80fd\u76f8\u53cd\uff0c<em>UNISTR<\/em> \u51fd\u6570\u5c06 Unicode \u7f16\u7801\u8f6c\u6362\u4e3a\u5b57\u7b26<\/p>\n","protected":false},"excerpt":{"rendered":"<p>ORACLE \u4e2d\u7684\u6b63\u5219\u8868\u8fbe\u5f0f\u6709\u5173\u7684\u51fd\u6570\u662f\u4e0d\u80fd\u50cf\u5176\u4ed6\u8bed\u8a00\u4e00\u6837\u4f7f\u7528 [\\u4e00-\\u9fa5] \u6765\u5339\u914d\u4e2d\u6587\u7684  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[199],"tags":[196],"class_list":["post-5008","post","type-post","status-publish","format-standard","hentry","category-oracle-","tag-oracle"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/5008"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5008"}],"version-history":[{"count":5,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/5008\/revisions"}],"predecessor-version":[{"id":5013,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/5008\/revisions\/5013"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}