dir=/home/me/oracle
conn=inter/inter123@billdb
#结果文件
v3=${dir}/oracle.tmp.txt
#执行sql
sql="select 1 from dual";
#清空结果文件
> $v3
#重定向sql执行结果到$v3文件中.
sqlplus -s ${conn} << ! >> $v3
set linesize 200
set pagesize 0
set newpage 0;
set trimspool on
set feedback off;
set termout off;
set heading off;
set term off;
set echo off;
${sql};
quit;
!
转载于:https://my.oschina.net/wmhx/blog/228792