SHELL调用SQLPLUS一例

[oracle@rac1 script]$ more 1.sql
select * from t;
select * from dual;
select 'aaa' from dual;

[oracle@rac1 script]$ more conn.sh
#!/usr/bin

sqlplus -s test/test <
set feedback off;
set pagesize 0;
select * from dual;
drop table t;
create table t (id integer);
insert into t values (1);
commit;
select * from t;
@/home/oracle/script/1.sql--执行指定位置的SQL脚本

EOF

[oracle@rac1 script]$

测试结果
[oracle@rac1 script]$ sh conn.sh
X
         1
         1
X
aaa
[oracle@rac1 script]$

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15720542/viewspace-743215/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15720542/viewspace-743215/