{"id":394,"date":"2020-08-13T19:43:22","date_gmt":"2020-08-13T10:43:22","guid":{"rendered":"https:\/\/outdoor-development.work\/index\/?p=394"},"modified":"2020-08-15T15:48:16","modified_gmt":"2020-08-15T06:48:16","slug":"%e3%80%90oracle%e3%80%91%e3%80%90pl-sql%e3%80%91%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e3%82%92%e3%81%be%e3%82%8b%e3%81%94%e3%81%a8%e3%82%b3%e3%83%94%e3%83%bc","status":"publish","type":"post","link":"https:\/\/outdoor-development.work\/index\/2020\/08\/13\/%e3%80%90oracle%e3%80%91%e3%80%90pl-sql%e3%80%91%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e3%82%92%e3%81%be%e3%82%8b%e3%81%94%e3%81%a8%e3%82%b3%e3%83%94%e3%83%bc\/","title":{"rendered":"\u3010Oracle\u3011\u3010PL\/SQL\u3011\u30c6\u30fc\u30d6\u30eb\u3092\u307e\u308b\u3054\u3068\u30b3\u30d4\u30fc"},"content":{"rendered":"\n<h1>\u30c6\u30fc\u30d6\u30eb\u3092\u307e\u308b\u3054\u3068\u30b3\u30d4\u30fc(CREATE TABLE SELECT)<\/h1>\n\n<h2>\u3084\u308a\u305f\u3044\u3053\u3068<\/h2>\n\n<p>\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u3084\u30c7\u30fc\u30bf\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u305f\u3081\u306b\u30b3\u30d4\u30fc\u3092\u884c\u3046\u3002<\/p>\n\n<h2>\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9<\/h2>\n\n<p><code>copy<\/code>\u30b3\u30de\u30f3\u30c9\u306a\u3069\u306f\u306a\u304f\u3001<code>CREATE TABLE<\/code>\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\n<code>NOLOGGING PARALLEL<\/code>\u3068\u3064\u3051\u308b\u3068\u9ad8\u901f\u5316\u3059\u308b\u3068\u601d\u3063\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n<pre><code class=\"language-SQL\">-- \u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u3001\u30c7\u30fc\u30bf\u3092\u542b\u3081\u30b3\u30d4\u30fc\nCREATE TABLE table_copy NOLOGGING PARALLEL\n AS SELECT * FROM table_original;\n<\/code><\/pre>\n\n<h2>\u6d3b\u7528\u4f8b<\/h2>\n\n<p>\u4e0b\u8a18URL\u306e\u5dee\u5206\u78ba\u8a8d\u306a\u3069\u3092\u4f7f\u7528\u3057\u3001\u540c\u3058\u30c6\u30fc\u30d6\u30eb\u3067\u51e6\u7406\u524d\u5f8c\u306e\u5dee\u5206\u6bd4\u8f03\u306a\u3069\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002<br>\n<a href=\"https:\/\/outdoor-development.work\/index\/2020\/08\/12\/%e3%83%87%e3%83%bc%e3%82%bf%e3%81%ae%e5%b7%ae%e5%88%86%e7%a2%ba%e8%aa%8dminus\/\">\u3010Oracle\u3011\u3010PL\/SQL\u3011\u30c7\u30fc\u30bf\u306e\u5dee\u5206\u78ba\u8a8d(MINUS)<\/a><br>\n\u30ec\u30b3\u30fc\u30c9\u6570\u304c\u591a\u3044\u5834\u5408\u306a\u3069\u3001\u6bd4\u8f03\u78ba\u8a8d\u304c\u96e3\u3057\u3044\u5834\u5408\u306b\u4fbf\u5229\u3067\u3059\u3002<\/p>\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%2F13%2F%25e3%2580%2590oracle%25e3%2580%2591%25e3%2580%2590pl-sql%25e3%2580%2591%25e3%2583%2586%25e3%2583%25bc%25e3%2583%2596%25e3%2583%25ab%25e3%2582%2592%25e3%2581%25be%25e3%2582%258b%25e3%2581%2594%25e3%2581%25a8%25e3%2582%25b3%25e3%2583%2594%25e3%2583%25bc%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>\u30c6\u30fc\u30d6\u30eb\u3092\u307e\u308b\u3054\u3068\u30b3\u30d4\u30fc(CREATE TABLE SELECT) \u3084\u308a\u305f\u3044\u3053\u3068 \u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u3084\u30c7\u30fc\u30bf\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u305f\u3081\u306b\u30b3\u30d4\u30fc\u3092\u884c\u3046\u3002 \u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9 copy\u30b3\u30de\u30f3\u30c9\u306a\u3069\u306f\u306a\u304f\u3001CREATE TABLE\u3092\u4f7f\u7528\u3057\u307e\u3059 [&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\/394"}],"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=394"}],"version-history":[{"count":8,"href":"https:\/\/outdoor-development.work\/index\/wp-json\/wp\/v2\/posts\/394\/revisions"}],"predecessor-version":[{"id":420,"href":"https:\/\/outdoor-development.work\/index\/wp-json\/wp\/v2\/posts\/394\/revisions\/420"}],"wp:attachment":[{"href":"https:\/\/outdoor-development.work\/index\/wp-json\/wp\/v2\/media?parent=394"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/outdoor-development.work\/index\/wp-json\/wp\/v2\/categories?post=394"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/outdoor-development.work\/index\/wp-json\/wp\/v2\/tags?post=394"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}