本文共 508 字,大约阅读时间需要 1 分钟。
xflag=0;
while [ $xflag -ne 10 ]doVALUE=`sqlplus -s <<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并用于实际项目转载地址:http://dlvwn.baihongyu.com/