xflag=0;while [ $xflag -ne 10 ]doVALUE=`sqlplus -s dbusername/uspass@xxxx <<EOFset heading off;set feedback off;set pagesize 0;set verify off;set echo off;select service_sn from rule_phone_sell_activity where rownum=1 and flag=0 and sell_type=1;exit;EOF` echo "**************************"; if [ -z "$VALUE" ]; then echo "rule_phone_sell_activity 表中没有flag=0 的记录 "; exit 0; else echo "current service_sn : $VALUE"; hq2_kf_sell execsql sell_10010 file_seq $VALUE; fi echo "**************************";
done第一次写shell并用于实际项目
