{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fbosssato.hatenablog.com%2Fentry%2F20091014%2F1247026802\" title=\"Oracle:DECODE\u3068CONCAT - \u521d\u3081\u3066\u306e\u30b7\u30b9\u30c6\u30e0\u3068\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","blog_url":"https://bosssato.hatenablog.com/","width":"100%","provider_name":"Hatena Blog","title":"Oracle:DECODE\u3068CONCAT","author_name":"boss_sato","author_url":"https://blog.hatena.ne.jp/boss_sato/","type":"rich","url":"https://bosssato.hatenablog.com/entry/20091014/1247026802","published":"2009-10-14 13:20:02","image_url":null,"provider_url":"https://hatena.blog","categories":[],"blog_title":"\u521d\u3081\u3066\u306e\u30b7\u30b9\u30c6\u30e0\u3068\u65e5\u8a18","description":"\u30fbDECODESQL\u306e\u4e2d\u3067IF\u6587\u306e\u3088\u3046\u306a\u6761\u4ef6\u5f0f\u3092\u4f7f\u3046\u306e\u306b\u5229\u7528\u3002\u4ed6\u306bCASE WHEN\u304c\u3042\u308b\u3002 select lastname, decode(sex,'1','\u7537','2','\u5973','\u4e0d\u660e') from employees) \u3053\u308c\u3060\u3068\u3001\u5217\uff62sex\uff63\u306b\u5bfe\u3057\u3001 \u30fb1 \u2192 \u7537 \u30fb2 \u2192 \u5973 \u30fb\u305d\u308c\u4ee5\u5916 \u2192 \u4e0d\u660e\u3092\u8868\u793a\u3059\u308b\u3002 \u30fbCONCATSQL\u306e\u4e2d\u30672\u3064\u306e\u6587\u5b57\u5217\u3092\u7d50\u5408\u3059\u308b\u3002 select concat('ABC','DEF') from dual \u6587\u5b57\u5217 \uff62ABC\uff63 \uff62DEF\uff63\u3092\u7d50\u5408\u3002\u7d50\u679c\u306f'ABCDEF'\u306b\u306a\u308b\u3002","height":"190"}