在shell中執行sql 的通用方法

在shell中如需要對數庫進行操作，可以先建立一個相應的函數，如

DBSTR="tigger/pw123@orcl"

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

PHONELIST="13257718899
18605518899
"

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

SQL="insert into  tab_xx alues('"$COMM_SN"','alarm','"$phone"',to_char(sysdate,'YYYYMMDDHH24MISS'),'IOC_ALARM','2',to_char(sysdate,'YYYYMMDDHH24MISS'),'"$2"',0,0,0)"
exesql "$SQL"
SQL="insert into tab_xx  values('"$COMM_SN"','alarm','"$phone"',to_char(sysdate,'YYYYMMDDHH24MISS'),'IOC_ALARM','2',to_char(sysdate,'YYYYMMDDHH24MISS'),'"$2"',0,0,0)"
exesql "$SQL"

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

send_sms "01"  $msg