{"image_url":null,"author_name":"posturan","url":"https://oboe2uran.hatenablog.com/entry/2025/12/02/205603","height":"190","description":"UNPIVOT \u306b\u8fd1\u3044\u3001\u308f\u3056\u308f\u3056SQL\u3067\u884c\u3046\u3053\u3068\u304c\u30ca\u30f3\u30bb\u30f3\u30b9\u306a\u6c17\u3082\u3057\u305f\u304c\u3001 split \u5bfe\u8c61\u306e\u6587\u5b57\u5217\u3092 mybatis \u306a\u3069\u304b\u3089\u52d5\u7684\u30d1\u30e9\u30e1\u30fc\u30bf\u3068\u3057\u3066\u6307\u5b9a\u3057\u3066\u7d50\u679c\u3092\u4ed6\u306e\u30c6\u30fc\u30d6\u30eb\u3068\u7d50\u5408\u3057\u3066 \u51e6\u7406\u3059\u308b\uff33\uff31\uff2c\u306a\u3069\u5fdc\u7528\u7bc4\u56f2\u306f\u5e83\u304c\u308b\u3068\u601d\u3063\u305f\u3002Oracle \u306e\u5834\u5408\u306e\u30b5\u30f3\u30d7\u30eb\u2019A,B,C' \u3092\u30ab\u30f3\u30de\u533a\u5207\u308a\u3067\u5206\u5272\u3001 WITH strings AS ( SELECT 'A,B,C' AS value FROM dual ) , splits AS ( SELECT lines.column_value AS position , REGEXP_SUBSTR(strings.value,'[^,]+', 1, li\u2026","blog_url":"https://oboe2uran.hatenablog.com/","type":"rich","published":"2025-12-02 20:56:03","title":"\u6587\u5b57\u5217\u306esplit \u21d2 \u884c\u51e6\u7406\u3059\u308bSQL \uff08ORACLE\uff09","categories":["SQL"],"provider_name":"Hatena Blog","version":"1.0","author_url":"https://blog.hatena.ne.jp/posturan/","width":"100%","provider_url":"https://hatena.blog","blog_title":"Oboe\u5439\u304d\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u9ed9\u793a\u9332","html":""}