shell脚本操作oracle

#! /usr/bin/ksh
DBPWD=`GetDBPwd ${DBUSER}`
if [ $? -ne 0 -o -z "${DBPWD}" ]
then
        echo "Get DB PWD ERROR,DB USER is [${DBUSER}]"
        exit 1
fi


exp ${DBUSER}/${DBPWD}@${DBSID} file=20161104db_chg.dmp tables=table1 table2 table3
if [ $? != 0 ];
then
        echo "PLKHMXB备份数据失败"
        exit 1;
fi


sqlplus ${DBUSER}/${DBPWD}@${DBSID} <<!
spool select_zh_djlsh.log
set timi on
set time on
set line 1000


/* 更新语句 */


spool off
quit;
!


printf " 请确认是否继续执行(Y/N)"
read key
echo $key


while [ 1 -eq 1 ]
do
if [ "$key" = "Y" ] ;
then
echo "继续处理"
break;
elif [ "$key" = "N" ] ;
then
echo " 取消本次操作,退出处理"
exit 1;
else
printf " 输入有误 ，请重新输入(Y/N)"
read key
echo $key
fi
done


sqlplus ${DBUSER}/${DBPWD}@${DBSID} <<!
spool update_zh_djlsh.log
set timi on
set time on
set line 1000


/* 更新语句 */
        
commit;


spool off
quit;
!


printf " 请确认是否继续执行(Y/N)"
read key
echo $key


while [ 1 -eq 1 ]
do
if [ "$key" = "Y" ] ;
then
echo "继续处理"
break;
elif [ "$key" = "N" ] ;
then
echo " 取消本次操作,退出处理"
exit 1;
else
printf " 输入有误 ，请重新输入(Y/N)"
read key
echo $key
fi
done


sqlplus ${DBUSER}/${DBPWD}@${DBSID} <<!
spool select_zh_djlsh_result.log
set timi on
set time on
set line 1000


/* 更新语句 */


spool off
quit;
!


printf " 请确认是否继续执行(Y/N)"
read key
echo $key


while [ 1 -eq 1 ]
do
if [ "$key" = "Y" ] ;
then
echo "继续处理"
break;
elif [ "$key" = "N" ] ;
then
echo " 取消本次操作,退出处理"
exit 1;
else
printf " 输入有误 ，请重新输入(Y/N)"
read key
echo $key
fi
done


sqlplus ${DBUSER}/${DBPWD}@${DBSID} <<!
spool select_khzk_info.log
set timi on
set time on
set line 1000




/* 更新语句 */


spool off
quit;
!


printf " 请确认是否继续执行(Y/N)"
read key
echo $key


while [ 1 -eq 1 ]
do
if [ "$key" = "Y" ] ;
then
echo "继续处理"
break;
elif [ "$key" = "N" ] ;
then
echo " 取消本次操作,退出处理"
exit 1;
else
printf " 输入有误 ，请重新输入(Y/N)"
read key
echo $key
fi
done


sqlplus ${DBUSER}/${DBPWD}@${DBSID} <<!
spool update_khzk_info.log
set timi on
set time on
set line 1000




/* 更新语句 */
commit;


spool off
quit;
!


printf " 请确认是否继续执行(Y/N)"
read key
echo $key


while [ 1 -eq 1 ]
do
if [ "$key" = "Y" ] ;
then
echo "继续处理"
break;
elif [ "$key" = "N" ] ;
then
echo " 取消本次操作,退出处理"
exit 1;
else
printf " 输入有误 ，请重新输入(Y/N)"
read key
echo $key
fi
done


sqlplus ${DBUSER}/${DBPWD}@${DBSID} <<!
spool update_zh_djlsh.log
set timi on
set time on
set line 1000


SELECT * FROM T_ZKZY_ZKDJB WHERE KH='6231621131009928786' AND ZKZL='02' AND SDBZ='0';
SELECT * FROM T_ZKZY_ZKDJB WHERE KH='6224781323596595' AND ZKZL='02' AND SDBZ='0';


commit;


spool off
quit;
!