{"width":"100%","description":"\u203b\u8ffd\u8a18\uff1a\u30d1\u30fc\u30c82(http://d.hatena.ne.jp/gonsuke777/20140909/1410228639)\u3082\u898b\u3066\u306d\u3002 Oracle \u306e REGEXP_LIKE\u6761\u4ef6\u3092\u4f7f\u7528\u3057\u3066\u307f\u308b\u3002 WITH A AS ( SELECT 'A' AS COL1 FROM DUAL UNION SELECT '1' FROM DUAL UNION SELECT '2' FROM DUAL UNION SELECT '1A' FROM DUAL UNION SELECT '0123' FROM DUAL UNION SELECT 'a0123' FROM DUAL ) SELECT * FROM A\u2026","provider_url":"https://hatena.blog","version":"1.0","categories":["Oracle","Database"],"blog_title":"\u306d\u3089\uff5eIT\u30a8\u30f3\u30b8\u30cb\u30a2\u96d1\u8a18","published":"2012-02-15 19:30:35","title":"\u6570\u5b57\u306e\u307f\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u62bd\u51fa\u3059\u308bSQL(REGEXP_LIKE\u6761\u4ef6)","height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fgonsuke777.hatenablog.com%2Fentry%2F20120215%2F1329301835\" title=\"\u6570\u5b57\u306e\u307f\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u62bd\u51fa\u3059\u308bSQL(REGEXP_LIKE\u6761\u4ef6) - \u306d\u3089\uff5eIT\u30a8\u30f3\u30b8\u30cb\u30a2\u96d1\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"gonsuke777","url":"https://gonsuke777.hatenablog.com/entry/20120215/1329301835","blog_url":"https://gonsuke777.hatenablog.com/","provider_name":"Hatena Blog","type":"rich","image_url":null,"author_url":"https://blog.hatena.ne.jp/gonsuke777/"}