{"id":358,"date":"2011-11-23T22:44:37","date_gmt":"2011-11-23T14:44:37","guid":{"rendered":"https:\/\/blog.rexdf.org\/?p=358"},"modified":"2011-11-23T22:44:37","modified_gmt":"2011-11-23T14:44:37","slug":"%e5%a6%82%e4%bd%95%e5%9c%a8oracle%e4%b8%ad%e5%a4%8d%e5%88%b6%e8%a1%a8%e7%bb%93%e6%9e%84%e5%92%8c%e8%a1%a8%e6%95%b0%e6%8d%ae","status":"publish","type":"post","link":"https:\/\/blog.rexdf.org\/en\/2011\/11\/%e5%a6%82%e4%bd%95%e5%9c%a8oracle%e4%b8%ad%e5%a4%8d%e5%88%b6%e8%a1%a8%e7%bb%93%e6%9e%84%e5%92%8c%e8%a1%a8%e6%95%b0%e6%8d%ae\/","title":{"rendered":"\u5982\u4f55\u5728Oracle\u4e2d\u590d\u5236\u8868\u7ed3\u6784\u548c\u8868\u6570\u636e"},"content":{"rendered":"<p>1. \u590d\u5236\u8868\u7ed3\u6784\u53ca\u5176\u6570\u636e\uff1a<\/p>\n<p>create table table_name_new as select * from table_name_old<\/p>\n<p>&nbsp;<\/p>\n<p>2. \u53ea\u590d\u5236\u8868\u7ed3\u6784\uff1a<\/p>\n<p>create table table_name_new as select * from table_name_old where 1=2;<\/p>\n<p>\u6216\u8005\uff1a<\/p>\n<p>create table table_name_new like table_name_old<\/p>\n<p>&nbsp;<\/p>\n<p>3. \u53ea\u590d\u5236\u8868\u6570\u636e\uff1a<\/p>\n<p>\u5982\u679c\u4e24\u4e2a\u8868\u7ed3\u6784\u4e00\u6837\uff1a<\/p>\n<p>insert into table_name_new\u00a0select * from\u00a0table_name_old<\/p>\n<p>\u5982\u679c\u4e24\u4e2a\u8868\u7ed3\u6784\u4e0d\u4e00\u6837\uff1a<\/p>\n<p>insert into table_name_new(column1,column2&#8230;)\u00a0select\u00a0column1,column2&#8230; from\u00a0table_name_old<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. \u590d\u5236\u8868\u7ed3\u6784\u53ca\u5176\u6570\u636e\uff1a create table table_name_new as select * from table_name_old &nbsp; 2. \u53ea\u590d\u5236\u8868\u7ed3\u6784\uff1a create table table_name_new as select * from table_name_old where 1=2; \u6216\u8005\uff1a create table table_name_new like table_name_old &nbsp; 3. \u53ea\u590d\u5236\u8868\u6570\u636e\uff1a \u5982\u679c\u4e24\u4e2a\u8868\u7ed3\u6784\u4e00\u6837\uff1a insert into table_name_new\u00a0select * from\u00a0table_name_old \u5982\u679c\u4e24\u4e2a\u8868\u7ed3\u6784\u4e0d\u4e00\u6837\uff1a insert &hellip; <a href=\"https:\/\/blog.rexdf.org\/en\/2011\/11\/%e5%a6%82%e4%bd%95%e5%9c%a8oracle%e4%b8%ad%e5%a4%8d%e5%88%b6%e8%a1%a8%e7%bb%93%e6%9e%84%e5%92%8c%e8%a1%a8%e6%95%b0%e6%8d%ae\/\">Continue reading <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":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[6],"tags":[50],"class_list":["post-358","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-2"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/posts\/358","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/comments?post=358"}],"version-history":[{"count":0,"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/posts\/358\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/media?parent=358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/categories?post=358"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/tags?post=358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}