将一张表中符合条件的数据插入另一张表

exp dbuser/paswd@dbname tables=(HSC_ROUTE_NOSECT) query="where AREACODE ='ZS'" file=HSC_ROUTE_NOSECT_ZS.dmp log=HSC_ROUTE_NOSECT_ZS.log

GDHSC_YC.HSC_ROUTE_NOSECT
实例：将一张表中符合条件的数据插入另一张表。
create table HSC_ROUTE_NOSECT_ZS as select * from  GDHSC_YC.HSC_ROUTE_NOSECT where  AREACODE ='ZS';
create table HSC_ROUTE_NOSECT_ALL as select * from  GDHSC_YC.HSC_ROUTE_NOSECT where  AREACODE <>'ZS';

insert into HSC_ROUTE_NOSECT_ALL select * from  GDHSC_YC.HSC_ROUTE_NOSECT_ZS where rownum<598
结果，HSC_ROUTE_NOSECT_ALL 表中
--------------

 dbuser/dbpass@dbname
/*
insert into HSC_ROUTE_NOSECT select HSC_ROUTE_NOSECT_seq.nextval,BEGINNO,ENDNO,HSCNODE,ABMNODE,STATUS,AREACODE,INTIME,REGION,CBENODE from  GDHSC_YC.HSC_ROUTE_NOSECT_ZS where rownum<598;

alter table HSC_ROUTE_NOSECT add CBENODE  NUMBER(10);

 RECID   
 BEGINNO 
 ENDNO   
 HSCNODE 
 ABMNODE 
 STATUS  
 AREACODE
 INTIME  
 REGION 
 CBENODE