{"published":"2020-07-13 09:00:00","blog_title":"\u682a\u5f0f\u4f1a\u793e\u30b7\u30d9\u30b9\u30d4\u3000\u5f93\u696d\u54e1\u30d6\u30ed\u30b0","author_url":"https://blog.hatena.ne.jp/chivsp/","description":"\u3055\u3066\u3001\u4eca\u56de\u306fOracle\u3067\u30ab\u30e9\u30e0\u5185\u306b\u30ab\u30f3\u30de\u533a\u5207\u308a\u3067\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u30ec\u30b3\u30fc\u30c9\u3054\u3068\u306b\u5206\u5272\u3059\u308bSQL\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002\uff08LISTAGG\u306e\u9006\u3067\u3059\u306d\uff09\u30c6\u30fc\u30d6\u30eb\u306f\u3053\u3093\u306a\u611f\u3058 \u30b3\u30fc\u30c9 \u5024 1 \u30ea\u30f3\u30b4,\u30ec\u30e2\u30f3,\u30c8\u30de\u30c8 2 \u30b5\u30a4,\u30a4\u30cc,\u30c8\u30e9 \u4ee5\u4e0b\u3001SQL\u3067\u3059\u3002 WITH A AS ( SELECT code ,value FROM hoge ) , B AS ( SELECT A.code ,REGEXP_SUBSTR(A.value,'[^,]+', 1, lines.column_value) AS split_value FROM A ,TABLE( CAST(MULTISET( SELECT LEV\u2026","height":"190","type":"rich","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fchivsp.hatenablog.com%2Fentry%2F2020%2F07%2F13%2F090000\" title=\"\u30ab\u30e9\u30e0\u5185\u306b\u30ab\u30f3\u30de\u533a\u5207\u308a\u3067\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u5206\u5272\u3059\u308bSQL - \u682a\u5f0f\u4f1a\u793e\u30b7\u30d9\u30b9\u30d4\u3000\u5f93\u696d\u54e1\u30d6\u30ed\u30b0\" 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":"chivsp","provider_url":"https://hatena.blog","categories":["\u3084\u3063\u3066\u307f\u305f(\u6280\u8853\u7cfb)"],"image_url":null,"blog_url":"https://chivsp.hatenablog.com/","provider_name":"Hatena Blog","url":"https://chivsp.hatenablog.com/entry/2020/07/13/090000","version":"1.0","width":"100%","title":"\u30ab\u30e9\u30e0\u5185\u306b\u30ab\u30f3\u30de\u533a\u5207\u308a\u3067\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u5206\u5272\u3059\u308bSQL"}