unix 用shell执行多个sql文件

来源:互联网 发布:乐语软件图标 编辑:程序博客网 时间:2024/06/08 19:27
#!/bin/sh


sqlplus 'user/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XXXX.c5xno4i0lfo4.ap-northeast-1.rds.amazonaws.com)(PORT=1521))(CONNECT_DATA=(SID=kgs)))' >>EOF


@/opt/DDL/SQL0001.sql;
@/opt/DDL/SQL0002.sql;


commit;


exit;