{"id":536,"date":"2018-01-14T23:20:35","date_gmt":"2018-01-14T14:20:35","guid":{"rendered":"https:\/\/a5m2.mmatsubara.com\/wp\/?p=536"},"modified":"2018-01-14T23:20:35","modified_gmt":"2018-01-14T14:20:35","slug":"a5sql-mk-2%e3%81%a7drop-table%e3%81%a8create-table%e3%82%92%e5%ae%9f%e8%a1%8c%e3%81%97%e3%81%a6%e3%82%82%e3%83%87%e3%83%bc%e3%82%bf%e3%81%8c%e6%b6%88%e3%81%88%e3%81%aa%e3%81%84%e3%82%88%e3%81%86","status":"publish","type":"post","link":"https:\/\/a5m2.mmatsubara.com\/wp\/?p=536","title":{"rendered":"A5:SQL Mk-2\u3067DROP TABLE\u3068CREATE TABLE\u3092\u5b9f\u884c\u3057\u3066\u3082\u30c7\u30fc\u30bf\u304c\u6d88\u3048\u306a\u3044\u3088\u3046\u306b\u3059\u308b\u6a5f\u80fd\u3092\u5b9f\u88c5"},"content":{"rendered":"<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u3092\u4fee\u6b63\u3057\u305f\u3089\u3001\u3044\u3063\u305f\u3093\u30c6\u30fc\u30d6\u30eb\u3092DROP TABLE\u3057\u3066\u304b\u3089\u3001CREATE TABLE\u3067\u4f5c\u308a\u76f4\u3059\u3053\u3068\u306a\u3069\u304c\u3088\u304f\u3042\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>\u3067\u3082\u3053\u306e\u6642\u60a9\u307e\u3057\u3044\u306e\u304c\u3001\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u30c6\u30fc\u30d6\u30eb\u30c7\u30fc\u30bf\u304c\u6d88\u3048\u3066\u3057\u307e\u3046\u3053\u3068\u3002<\/p>\n<p>\u3053\u3053\u3067 A5:SQL Mk-2 version 2.13.0 beta 35\u304b\u3089\u3001DROP TABLE\u306e\u524d\u306b\u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u3063\u3066\u30c7\u30fc\u30bf\u3092\u4fdd\u5b58\u3057\u3001CREATE TABLE\u306e\u5f8c\u306b\u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u3092\u30ed\u30fc\u30c9\uff06\u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u524a\u9664\u3059\u308b\u6a5f\u80fd\u3092\u4ed8\u3051\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n<p>\u4ee5\u4e0b\u306e\u3088\u3046\u306bBackupToTempTable, RestoreFromTempTable \u7591\u4f3c\u547d\u4ee4\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"lang:plsql decode:true\">--* BackupToTempTable\r\ndrop table TARGET_TABLE;\r\n\r\n--* RestoreFromTempTable\r\nCREATE TABLE TARGET_TABLE (\r\n  COL1 VARCHAR2(10) NOT NULL\r\n  , COL2 VARCHAR2(20) \r\n  , COL3 VARCHAR2(20) \r\n  , PRIMARY KEY (COL1)\r\n);<\/pre>\n<p>\u3053\u306e\u3088\u3046\u306b\u66f8\u304f\u3053\u3068\u3067\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u52d5\u304d\u3092\u3057\u307e\u3059\u3002<\/p>\n<p>\uff11\uff0e$$TARGET_TABLE\u3068\u3044\u3046\u540d\u524d\uff08\u73fe\u72b6\u3067\u306f\u5143\u30c6\u30fc\u30d6\u30eb\u306e\u524d\u306b$$\u3092\u4ed8\u3051\u305f\u540d\u524d\u3067\u56fa\u5b9a\uff09\u3067\u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u304c\u4f5c\u3089\u308c\u3001TARGET_TABLE\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u304c\u4fdd\u5b58\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\uff12\uff0eDROP TABLE\u304c\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\uff13\uff0eCREATE TABLE\u304c\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\uff14\uff0e$$TARGET_TABLE\u30c6\u30fc\u30d6\u30eb\u304b\u3089TARGET_TABLE\u306b\u30c7\u30fc\u30bf\u304c\u66f8\u304d\u623b\u3055\u308c\u3001\u6210\u529f\u3057\u305f\u3089\u3001$$TARGET_TABLE\u306f\u524a\u9664\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u6ce8\u610f\u70b9\u3068\u3057\u3066$$TARGET_TABLE\u304b\u3089TARGET_TABLE\u306b\u30c7\u30fc\u30bf\u304c\u66f8\u304d\u623b\u3055\u308c\u308b\u3068\u304d\u3001\u540c\u3058\u540d\u524d\u306e\u5217\u306e\u307f\u66f8\u304d\u623b\u3055\u308c\u307e\u3059\u3002\u65b0\u3057\u3044\u30c6\u30fc\u30d6\u30eb\u306e\u5217\u306e\u9577\u3055\u304c\u77ed\u304f\u306a\u308b\u306a\u3069\u3057\u3066\u3001\u66f8\u304d\u623b\u3059\u306e\u306b\u5931\u6557\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\u3053\u3068\u306b\u6ce8\u610f\u304c\u5fc5\u8981\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n<p>\u3042\u3068\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u91cf\u306f\u8003\u616e\u3057\u306a\u3044\u306e\u3067\u3001\u5de8\u5927\u306a\u30c6\u30fc\u30d6\u30eb\u3067\u306f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\uff06\u30ea\u30b9\u30c8\u30a2\u3067\u5927\u91cf\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304c\u767a\u751f\u3057\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u8ca0\u8377\u3092\u304b\u3051\u3066\u3057\u307e\u3046\u53ef\u80fd\u6027\u3082\u6ce8\u610f\u304c\u5fc5\u8981\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n<p>A5:SQL Mk-2 version 2.13.0 beta 35\u3067\u306fER\u30a8\u30c7\u30a3\u30bf\u304b\u3089\u751f\u6210\u3059\u308bDDL\u306b\u306f\u3053\u308c\u3089\u306e\u7591\u4f3c\u547d\u4ee4\u306f\u3064\u304b\u306a\u3044\u3067\u3059\u304c\u3001\u751f\u6210\u3059\u308bDDL\u306b\u6a19\u6e96\u3067\u3053\u308c\u3092\u4ed8\u3051\u308b\u3088\u3046\u306b\u3059\u308c\u3070\u3001\u7d50\u69cb\u4fbf\u5229\u304b\u3068\u601d\u3046\u306e\u3067\u3059\u304c\u3069\u3046\u3067\u3057\u3087\u3046\uff1f\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u3092\u4fee\u6b63\u3057\u305f\u3089\u3001\u3044\u3063\u305f\u3093\u30c6\u30fc\u30d6\u30eb\u3092DROP TABLE\u3057\u3066\u304b\u3089\u3001CREATE TABLE\u3067\u4f5c\u308a\u76f4\u3059\u3053\u3068\u306a\u3069\u304c\u3088\u304f\u3042\u308b\u3068\u601d\u3044\u307e\u3059\u3002 \u3067\u3082\u3053\u306e\u6642\u60a9\u307e\u3057\u3044\u306e\u304c\u3001\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u30c6\u30fc\u30d6\u30eb\u30c7\u30fc\u30bf\u304c\u6d88\u3048\u3066\u3057\u307e\u3046 &hellip; <a href=\"https:\/\/a5m2.mmatsubara.com\/wp\/?p=536\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-536","post","type-post","status-publish","format-standard","hentry","category-1"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=536"}],"version-history":[{"count":2,"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/536\/revisions"}],"predecessor-version":[{"id":538,"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/536\/revisions\/538"}],"wp:attachment":[{"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}