oracle sql 数据库之间导入数据

1.导入别的表

insert into EMPI_IDENTIFY select id,empiid, name||‘:‘ ||idcardno,‘accidcardno‘,‘‘ from empi_main where empi_state =‘正常‘;

insert into EMPI_IDENTIFY
 select sys_guid(),empiid, name||‘:‘ ||tel,‘acctel‘,‘‘ from empi_main where empi_state =‘正常‘ and tel is not null;

oracle sql 数据库之间导入数据

原文：https://www.cnblogs.com/leolzi/p/10902471.html