shell 裡執行sql 例子

DBSTR="busi/xxxx@crm"

send_sms()

{
PCOUNT=0
for phone in $PHONELIST
do
TIME="INF"`date +'%y%m%d%H%M%S'`
COMM_SN="${TIME}$1${PCOUNT}"
echo "COMM_SN=${COMM_SN}"

SQL="insert into busi.log_sms_pay values('"$COMM_SN"','alarm','"$phone"',to_char(sysdate,'YYYYMMDDHH24MISS'),'IOC_ALARM','2',to_char(sysdate,'YYYYMMDDHH24MISS'),'"$2"',0,0,0)"
exesql "$SQL"
SQL="insert into busi.sms_pay values('"$COMM_SN"','alarm','"$phone"',to_char(sysdate,'YYYYMMDDHH24MISS'),'IOC_ALARM','2',to_char(sysdate,'YYYYMMDDHH24MISS'),'"$2"',0,0,0)"
exesql "$SQL"
# printf "[%s]:  SEND MESSAGE TO【%s】:%s\n" "`date +'%Y-%m-%d %H:%M:%S'`" "$phone" "$3"

PCOUNT=`expr $PCOUNT + 1`
echo "PCOUNT=${PCOUNT}"
sleep 1
done
}

exesql()
{
sqlplus -s $DBSTR <<EOF
set autocommit off;
$1;
commit;
exit;
EOF
}