shell 讀取oracle資料庫表記錄

xflag=0;
while [ $xflag -ne 10 ]
do
VALUE=`sqlplus -s dbusername/uspass@xxxx <<EOF
set 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並用於實際項目