oracle 执行批处理脚本语句

通过SQLPLUS 执行数据批处理

1、如addAutoData.sql文件的内容。

@"E:\workspace\naas\dbscript\transsystem\datasql\equipment.sql"

@"E:\workspace\naas\dbscript\transsystem\datasql\equipframe.sql"

@"E:\workspace\naas\dbscript\transsystem\datasql\equipslot.sql"

@"E:\workspace\naas\dbscript\transsystem\datasql\equippack.sql"

@"E:\workspace\naas\dbscript\transsystem\datasql\equiplogicport.sql" @"E:\workspace\naas\dbscript\transsystem\datasql\cc.sql"

@"E:\workspace\naas\dbscript\transsystem\datasql\en_topolink.sql"

@"E:\workspace\naas\dbscript\transsystem\datasql\re_sys_equip.sql"

@"E:\workspace\naas\dbscript\transsystem\datasql\domain_equip.sql"

2、如deleteAutoData.sql文件的内容

delete from cc;

delete from en_topolink;

delete from domain_equip;

delete from re_sys_equip;

delete from equiplogicport;

delete from equippack;

delete from equipslot;

delete from equipframe;

delete from equipment;

commit;

3、如deplay.sql文件的内容

@"E:\workspace\naas\dbscript\transsystem\datasql\deleteAutoData.sql" @"E:\workspace\naas\dbscript\transsystem\datasql\addAutoData.sql"

4、如文件的内容更

sqlplus naascs/naascs@naasdb10 @"E:\workspace\naas\dbscript\transsystem\datasql\deplay.sql"

5、在服务器上执行文件4，便可将上面表中的数据先清空后在比处理式的插入。