#!/bin/bash
# Author:Zhang Jian
# Date:2012/12/28
count=1
while [ ${count} -lt $1 ]
do
sqlplus -S kin/kin <<EOF
spool /tmp/result.log
@wait.sql
spool off
exit
EOF
count=`expr ${count} + 1`
cat /tmp/result.log >> /tmp/query.log
> /tmp/result.log
sleep 1
done
Oracle Script-Shell调用SQLplus输出结果
最新推荐文章于 2022-11-24 08:30:00 发布