复制表数据 到 表

 

drop table HL_NPACB_bak;CREATE TABLE HL_NPACB_bak   (  AGE NUMBER(8,0),   SEX NUMBER(8,0),   PAYENDYEAR NUMBER(8,0),   POLYEAR NUMBER(8,0),   DVDL NUMBER(16,8),   DVDM NUMBER(16,8),   DVDH NUMBER(16,8)   );      insert into HL_NPACB_bak        select * from HL_NPACB;          -- 11108805.2739835858585920.358861652236735.4437382756133select count(*),avg(DVDL), avg(DVDM), avg(DVDH) from HL_NPACB_bak;-- 1554405.2739835858585920.358861652236735.4437382756133select count(*),avg(DVDL), avg(DVDM), avg(DVDH) from HL_NPACB;drop table HL_NPACB;CREATE TABLE HL_NPACB   (  AGE NUMBER(8,0),   SEX NUMBER(8,0),   PAYENDYEAR NUMBER(8,0),   POLYEAR NUMBER(8,0),   DVDL NUMBER(16,8),   DVDM NUMBER(16,8),   DVDH NUMBER(16,8),  primary key (age, sex, payendyear, polyear)   );      insert into HL_NPACB (age, sex, PayEndyear, polyear, dvdl, dvdm, dvdH)       select distinct age, sex, PayEndyear, polyear, dvdl, dvdm, dvdH        from HL_NPACB_bak;