[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]$
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/