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并用于实际项目