{"categories":["DB"],"description":"Oracle10g\u3002\u96c6\u8a08\u95a2\u6570\u306eMIN\u3084MAX\u3063\u3066VARCHAR2\u9805\u76ee\u306b\u3082\u3064\u304b\u3048\u308b\u306e\u306d\u3002\u30b3\u30fc\u30c9\u5024\u306a\u3069\u3067\u8907\u6570\u30ec\u30b3\u30fc\u30c9\u306b\u5206\u3051\u3089\u308c\u3066\u308b\u30c7\u30fc\u30bf\u3092\uff11\u30ec\u30b3\u30fc\u30c9\u3067\u8868\u73fe\u3057\u305f\u3044\u3068\u3044\u3046\u3053\u3068\u304c\u7d50\u69cb\u3088\u304f\u3042\u308b\u3002 \u5e33\u7968\u7cfb\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u3068\u304b\u306d\u3002 \u3053\u3093\u306a\u304b\u3093\u3058\u3002 \uff29\uff24 \u30b3\u30fc\u30c9\u5024 \u540d\u79f0 1 A A\u540d\u79f0 1 B B\u540d\u79f0 1 C C\u540d\u79f0 \u2193\uff29\uff24 \u30b3\u30fc\u30c9\u5024\uff21 \u540d\u79f0\uff21 \u30b3\u30fc\u30c9\u5024\uff22 \u30b3\u30fc\u30c9\u5024\uff22 \u30b3\u30fc\u30c9\u5024\uff23 \u540d\u79f0\uff23 1 A A\u540d\u79f0 B B\u540d\u79f0 C C\u540d\u79f0 \u3053\u3046\u3044\u3046\u5834\u5408\u307e\u305aUNION ALL\u3068\u304bDECODE\u3092\u3064\u304b\u3063\u3066\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u72b6\u614b\u3092\u4f5c\u308b\u3002 \uff29\uff24 \u30b3\u30fc\u30c9\u5024\uff21 \u540d\u79f0\uff21 \u30b3\u30fc\u30c9\u5024\uff22 \u540d\u79f0\uff22 \u30b3\u30fc\u30c9\u5024\uff23 \u540d\u79f0\uff23 1 A A\u540d\u79f0 1 B B\u540d\u79f0 1 C\u2026","provider_name":"Hatena Blog","height":"190","author_url":"https://blog.hatena.ne.jp/kznb_u/","provider_url":"https://hatena.blog","version":"1.0","image_url":null,"title":"\u96c6\u8a08\u95a2\u6570MIN(),MAX()\u3092VARCHAR2\u9805\u76ee\u306b\u4f7f\u7528\u3059\u308b","type":"rich","author_name":"kznb_u","published":"2010-03-10 21:34:25","url":"https://kznb-u.hatenadiary.org/entry/20100310/1268224465","width":"100%","blog_url":"https://kznb-u.hatenadiary.org/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkznb-u.hatenadiary.org%2Fentry%2F20100310%2F1268224465\" title=\"\u96c6\u8a08\u95a2\u6570MIN(),MAX()\u3092VARCHAR2\u9805\u76ee\u306b\u4f7f\u7528\u3059\u308b - Poor Life \u301c\u6210\u308a\u4e0a\u304c\u308a(\u305f\u3044)\u30a8\u30f3\u30b8\u30cb\u30a2\u306e\u65e5\u8a18 \u301c\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"Poor Life \u301c\u6210\u308a\u4e0a\u304c\u308a(\u305f\u3044)\u30a8\u30f3\u30b8\u30cb\u30a2\u306e\u65e5\u8a18 \u301c"}