{"id":376,"date":"2020-08-12T20:00:04","date_gmt":"2020-08-12T11:00:04","guid":{"rendered":"https:\/\/outdoor-development.work\/index\/?p=376"},"modified":"2020-08-12T21:49:51","modified_gmt":"2020-08-12T12:49:51","slug":"select%e7%b5%90%e6%9e%9c%e3%81%a7update%e3%81%99%e3%82%8bupdate-select","status":"publish","type":"post","link":"https:\/\/outdoor-development.work\/index\/2020\/08\/12\/select%e7%b5%90%e6%9e%9c%e3%81%a7update%e3%81%99%e3%82%8bupdate-select\/","title":{"rendered":"\u3010Oracle\u3011\u3010PL\/SQL\u3011SELECT\u7d50\u679c\u3067UPDATE\u3059\u308b(UPDATE SELECT)"},"content":{"rendered":"\n<h1>SELECT\u7d50\u679c\u3067UPDATE\u3059\u308b(UPDATE SELECT)<\/h1>\n\n<h2>\u3084\u308a\u305f\u3044\u3053\u3068<\/h2>\n\n<p>SELECT\u7d50\u679c\u3092UPDATE\u6587\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002\nUPDATE\u6587\u306e\u57fa\u672c\u7684\u306a\u69cb\u6210\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3001\n<strong>[\u66f4\u65b0\u5bfe\u8c61\u5217\u540d]=[\u5024]<\/strong>\n\u3068\u306a\u308a\u307e\u3059\u304c\u3001\u3053\u306e\u5024\u306bSELECT\u7d50\u679c\u3092\u4f7f\u7528\u3059\u308b\u30a4\u30e1\u30fc\u30b8\u3068\u306a\u308a\u307e\u3059\u3002\n\u30c7\u30fc\u30bf\u306e\u65b0\u898f\u767b\u9332\u306e\u5834\u5408\u306f\u4e0b\u8a18\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n<a href=\"https:\/\/qiita.com\/t-kikuchi\/items\/4a6eb4dc453d3f427557\">\u3010PL\/SQL\u3011SELECT\u7d50\u679c\u3067INSERT\u3059\u308b(INSERT SELECT)<\/a><\/p>\n\n<pre><code class=\"language-SQL:\">UPDATE {\u30c6\u30fc\u30d6\u30eb}\nSET {\u52171} = \u50241\n   ,{\u52172} = \u50242\nWHERE {\u6761\u4ef6};\n<\/code><\/pre>\n\n<h2>\u30b3\u30fc\u30c9<\/h2>\n\n<p>\u4ee5\u4e0b\u306e\u4f8b\u3067\u306fSELECT\u7d50\u679c\u30922\u3064\u306e\u9805\u76ee\u306bUPDATE\u3057\u3066\u3044\u307e\u3059\u3002\n\u7d44\u307f\u5408\u308f\u305b\u306b\u3088\u3063\u3066\u306f\u3001\u69d8\u3005\u306a\u60c5\u5831\u3092\u53d6\u5f97\u3057\u3066UPDATE\u306b\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n\n<pre><code class=\"language-SQL\">--SELECT\u3057\u305f\u7d50\u679c\u3067UPDATE\u3059\u308b\nUPDATE emp_mst\nSET (address,add_no) = \n    (SELECT address,add_no \n     FROM addno \n     WHERE add_no = '111-1111')\nWHERE emp_cd = 'A001';\n<\/code><\/pre>\n<div class=\"veu_socialSet veu_contentAddSection\"><script>window.twttr=(function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],t=window.twttr||{};if(d.getElementById(id))return t;js=d.createElement(s);js.id=id;js.src=\"https:\/\/platform.twitter.com\/widgets.js\";fjs.parentNode.insertBefore(js,fjs);t._e=[];t.ready=function(f){t._e.push(f);};return t;}(document,\"script\",\"twitter-wjs\"));<\/script><ul><li class=\"sb_twitter sb_icon\"><a href=\"\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Foutdoor-development.work%2Findex%2F2020%2F08%2F12%2Fselect%25e7%25b5%2590%25e6%259e%259c%25e3%2581%25a7update%25e3%2581%2599%25e3%2582%258bupdate-select%2F&amp;text=Outdoor+Development\" target=\"_blank\" ><span class=\"vk_icon_w_r_sns_twitter icon_sns\"><\/span><span class=\"sns_txt\">twitter<\/span><\/a><\/li><\/ul><\/div><!-- [ \/.socialSet ] -->","protected":false},"excerpt":{"rendered":"<p>SELECT\u7d50\u679c\u3067UPDATE\u3059\u308b(UPDATE SELECT) \u3084\u308a\u305f\u3044\u3053\u3068 SELECT\u7d50\u679c\u3092UPDATE\u6587\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002 UPDATE\u6587\u306e\u57fa\u672c\u7684\u306a\u69cb\u6210\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3001 [\u66f4\u65b0\u5bfe\u8c61\u5217\u540d]=[\u5024] \u3068\u306a\u308a\u307e\u3059\u304c\u3001\u3053\u306e\u5024 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[44],"tags":[49,47,48,50,51],"_links":{"self":[{"href":"https:\/\/outdoor-development.work\/index\/wp-json\/wp\/v2\/posts\/376"}],"collection":[{"href":"https:\/\/outdoor-development.work\/index\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/outdoor-development.work\/index\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/outdoor-development.work\/index\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/outdoor-development.work\/index\/wp-json\/wp\/v2\/comments?post=376"}],"version-history":[{"count":2,"href":"https:\/\/outdoor-development.work\/index\/wp-json\/wp\/v2\/posts\/376\/revisions"}],"predecessor-version":[{"id":380,"href":"https:\/\/outdoor-development.work\/index\/wp-json\/wp\/v2\/posts\/376\/revisions\/380"}],"wp:attachment":[{"href":"https:\/\/outdoor-development.work\/index\/wp-json\/wp\/v2\/media?parent=376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/outdoor-development.work\/index\/wp-json\/wp\/v2\/categories?post=376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/outdoor-development.work\/index\/wp-json\/wp\/v2\/tags?post=376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}