oracle执行shell脚本

echo "请输入时间(yyyymmdd)"
read date
cd /home/ap/ssp/filedir/infiledir/makecard/jinbangda/
if [ ! -d "$date" ]
then
echo "file $date not exist"
exit 0
else
echo "jinbangda file $date is exist,gameover"
cp -rf $date $date.bak
echo "jinbangda file $date is copy,filename is $date.bak ok"
rm -rf $date
echo "jinbangda delete file $date ok"
fi

cd /home/ap/ssp/filedir/infiledir/makecard/zhongchao/
if [ ! -d "$date" ]
then
echo "zhongchao file $date not exist"
exit 0
else
echo "zhongchao file $date is exist,gameover"
cp -rf $date $date.bak
echo "zhongchao file $date is copy,filename is $date.bak ok"
rm -rf $date
echo "zhongchao delete file $date ok"
fi

cd /home/ap/ssp/filedir/infiledir/makecard/huangshi/
if [ ! -d "$date" ]
then
echo "huangshi file $date not exist"
exit 0
else
echo "huangshi file $date is exist,gameover"
cp -rf $date $date.bak
echo "huangshi file $date is copy,filename is $date.bak ok"
rm -rf $date
echo "huangshi delete file $date ok"
fi

cd /home/ap/ssp/filedir/infiledir/makecard/all/
if [ ! -d "$date" ]
then
echo "all file $date not exist"
exit 0
else
echo "all file $date is exist,gameover"
cp -rf $date $date.bak
echo "all file $date is copy,filename is $date.bak ok"
rm -rf $date
echo "all delete file $date ok"
fi

sq <<EOF
set linesize 1000;
select * from batstat where command='dealmakecard' and inputstr like '$date%';
delete file_mon where filedate='$date';
EOF