shell脚本sql赋值

 以下脚本功能是用shell脚本登录sqlplus连接oracle，将执行sql语句查询的结果赋值给shell脚本中的变量

#!/bin/bash
echo "开始连接数据库..."
sqlplus -S "name/password" << !
set pagesize 0
set verify off
set feedback off
set echo off
col coun new_value v_coun
select count(*) coun from src.global_info where batchdate='20180309' and status='0';
exit v_coun
!
value="$?"
echo '查询总数为:'$value
if [ $value == 0 ];
then
echo "数据库状态错误，开始更新batchdate和status"
sqlplus -S "nbms_user2/nbms_user2" << !
update src.global_info set batchdate='20180305', status='0' where id =1;
select count(*) coun from src.global_info where batchdate='20180309' and status='0';
exit
!
echo "开始调用跑批脚本"
else
                echo "数据库状态正确!开始调用跑批脚本"
                #sh BMSRUNALL.sh
fi