{"id":606,"date":"2012-06-26T15:52:37","date_gmt":"2012-06-26T06:52:37","guid":{"rendered":"http:\/\/www.whoocus.com\/blog\/?p=606"},"modified":"2012-06-26T15:53:00","modified_gmt":"2012-06-26T06:53:00","slug":"case%e6%96%87%e3%81%aeupdate","status":"publish","type":"post","link":"https:\/\/www.blowfish.co.jp\/?p=606","title":{"rendered":"CASE\u6587\u306eUPDATE"},"content":{"rendered":"<p>\u4eca\u307e\u3067\u7279\u306b\u610f\u8b58\u7684\u306b\u306f\u4f7f\u7528\u3057\u3066\u3044\u306a\u304b\u3063\u305fCASE\u6587<\/p>\n<p>[sql]<br \/>\nUPDATE TARGET_TBL<br \/>\nSET COL1 =<br \/>\n(CASE COL2<br \/>\n  WHEN 201103 then 201203<br \/>\n  WHEN 201102 then 201202<br \/>\n  ELSE 201201<br \/>\n END<br \/>\n);<br \/>\n[\/sql]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4eca\u307e\u3067\u7279\u306b\u610f\u8b58\u7684\u306b\u306f\u4f7f\u7528\u3057\u3066\u3044\u306a\u304b\u3063\u305fCASE\u6587 [sql] UPDATE TARGET_TBL SET COL1 = (CASE COL2 WHEN 201103 then 201203 WHEN 201102 the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"saved_in_kubio":false,"footnotes":""},"categories":[12,4],"tags":[],"class_list":["post-606","post","type-post","status-publish","format-standard","hentry","category-oracle","category-tech"],"_links":{"self":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/606","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=606"}],"version-history":[{"count":2,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/606\/revisions"}],"predecessor-version":[{"id":608,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/606\/revisions\/608"}],"wp:attachment":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}