spool文件导出

数据库数据导出为文件

#!/bin/sh
monthFirWkDate = ''20210301"
filename = test.txt
dateSuffix = 'date +%Y%m%d'

clear 
>test.log
if [-f test.txt ];then
	rm test.txt
fi
if [-f test.sql ];then
	rm test.sql
fi

./home/test/bin/key.sh
serviceName = "myoracle_s"
userName = "oracleuser"
userPwd = "test123"

echo "测试数据库连接..."
echo "连接信息：[service:$serviceName],[user: