oracle中如何在后台执行一条sql语句? oraclesql脚本linux 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 shell执行deletesqlplus username/password@database << eofwhenever sqlerror exit failure rollback;delete from ci_message_table where program_name ='GENBISWF' and TRUNC(date_time) = TO_DATE(sysdate,'dd-mon-yy');commit;eofRETURN_CODE="$?"if [ $RETURN_CODE != 0 ]thenecho " abnormal termination for program gen_bis_weekly_data" echo " return code is " $RETURN_CODE echo "\n *************************************** abnormal termination for job $JOBNAME ***************************************\n" exit 1fi shell执行deletesqlplus username/password@database << eofwhenever sqlerror exit failure rollback;delete from ci_message_table where program_name ='GENBISWF' and TRUNC(date_time) = TO_DATE(sysdate,'dd-mon-yy');commit;eofRETURN_CODE="$?"if [ $RETURN_CODE != 0 ]thenecho " abnormal termination for program gen_bis_weekly_data" echo " return code is " $RETURN_CODE echo "\n *************************************** abnormal termination for job $JOBNAME ***************************************\n" exit 1fishell执行deletesqlplus username/password@database << eofwhenever sqlerror exit failure rollback;delete from ci_message_table where program_name ='GENBISWF' and TRUNC(date_time) = TO_DATE(sysdate,'dd-mon-yy');commit;eofRETURN_CODE="$?"if [ $RETURN_CODE != 0 ]thenecho " abnormal termination for program gen_bis_weekly_data" echo " return code is " $RETURN_CODE echo "\n *************************************** abnormal termination for job $JOBNAME ***************************************\n" exit 1fi非常感谢! oracle如何复制表空间? Oracle中怎么用触发器实现一个表中不能存在两个PRESIDENT职业 求oracle连接SQL SERVER的方法!在线等 exp-00011 总是提示表不存在 但是确实存在阿 SQL求救!! 两张简单的表,请赐教一条语句 TO_CHAR(trunc(sysdate),'D')什么意思?? 高手们请帮个忙,小弟第一次提问 一点小问题 在线等 请教ORACLE日期时间计算统计问题 怎么把带有数字,英文字母和符号的行挑出来? oracle递归查询问题
sqlplus username/password@database << eof
whenever sqlerror exit failure rollback;delete from ci_message_table
where program_name ='GENBISWF'
and TRUNC(date_time) = TO_DATE(sysdate,'dd-mon-yy');
commit;eofRETURN_CODE="$?"
if [ $RETURN_CODE != 0 ]
then
echo " abnormal termination for program gen_bis_weekly_data"
echo " return code is " $RETURN_CODE
echo "\n
***************************************
abnormal termination for job $JOBNAME
***************************************\n"
exit 1
fi
sqlplus username/password@database << eof
whenever sqlerror exit failure rollback;delete from ci_message_table
where program_name ='GENBISWF'
and TRUNC(date_time) = TO_DATE(sysdate,'dd-mon-yy');
commit;eofRETURN_CODE="$?"
if [ $RETURN_CODE != 0 ]
then
echo " abnormal termination for program gen_bis_weekly_data"
echo " return code is " $RETURN_CODE
echo "\n
***************************************
abnormal termination for job $JOBNAME
***************************************\n"
exit 1
fi
shell执行delete
sqlplus username/password@database << eof
whenever sqlerror exit failure rollback;delete from ci_message_table
where program_name ='GENBISWF'
and TRUNC(date_time) = TO_DATE(sysdate,'dd-mon-yy');
commit;eofRETURN_CODE="$?"
if [ $RETURN_CODE != 0 ]
then
echo " abnormal termination for program gen_bis_weekly_data"
echo " return code is " $RETURN_CODE
echo "\n
***************************************
abnormal termination for job $JOBNAME
***************************************\n"
exit 1
fi
非常感谢!