{"id":748,"date":"2012-04-10T05:59:07","date_gmt":"2012-04-10T05:59:07","guid":{"rendered":"http:\/\/brain.dailyon.net\/?p=748"},"modified":"2012-04-10T05:59:07","modified_gmt":"2012-04-10T05:59:07","slug":"oracle-%ed%91%9c%ed%98%84%ec%8b%9dregular-expression-%eb%ac%b8%ec%9e%90-%ec%9e%90%eb%a5%b4%ea%b8%b0-regexp_substr","status":"publish","type":"post","link":"https:\/\/blog.goorigo.com\/?p=748","title":{"rendered":"oracle : \ud45c\ud604\uc2dd(Regular Expression) \ubb38\uc790 \uc790\ub974\uae30 > REGEXP_SUBSTR()"},"content":{"rendered":"<p>SELECT REGEXP_SUBSTR(&#8216;\uccab\ubc88\uc9f8_\ub450\ubc88\uc9f8_\uc138\ubc88\uc9f8&#8217;,'[^_]+&#8217;,1,1) FROM DUAL;<\/p>\n<p>SELECT REGEXP_SUBSTR(&#8216;\uccab\ubc88\uc9f8_\ub450\ubc88\uc9f8_\uc138\ubc88\uc9f8&#8217;,'[^_]+&#8217;,1,2) FROM DUAL;<\/p>\n<p>SELECT REGEXP_SUBSTR(&#8216;\uccab\ubc88\uc9f8_\ub450\ubc88\uc9f8_\uc138\ubc88\uc9f8&#8217;,'[^_]+&#8217;,1,3) FROM DUAL;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT REGEXP_SUBSTR(&#8216;\uccab\ubc88\uc9f8_\ub450\ubc88\uc9f8_\uc138\ubc88\uc9f8&#8217;,'[^_]+&#8217;,1,1) FROM DUAL; SELECT REGEXP_SUBSTR(&#8216;\uccab\ubc88\uc9f8_\ub450\ubc88\uc9f8_\uc138\ubc88\uc9f8&#8217;,'[^_]+&#8217;,1,2) FROM DUAL; SELECT REGEXP_SUBSTR(&#8216;\uccab\ubc88\uc9f8_\ub450\ubc88\uc9f8_\uc138\ubc88\uc9f8&#8217;,'[^_]+&#8217;,1,3) FROM DUAL;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/748"}],"collection":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=748"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/748\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=748"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=748"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}