if [ $# -ne 1 ] then echo "day" exit -1 fi day=$1 tmpfilename="common.${1}`date +%s`" sql="create or replace view v_dm_sosoad_common as select * from ( select * from t_dm_sosoad_common where statis_date = $1 );" echo "$sql" echo "exec SP_SOSOAD_COMMON($day);" > "$tmpfilename" echo "$sql" >> "$tmpfilename" echo "exit;" >> "$tmpfilename" sqlplus user/pw@db @${tmpfilename} >> log/${tmpfilename}.log 2>&1 mv $tmpfilename bak/ 将该脚本加到crontab即可