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非常感谢! 求SQL oracle dblink小问题 ORACLE 关联查询性能优化 存储过程中procedure_name和object_name有什么区别和联系? 请教一个关于从oracle导出数据到sqlserver的问题 oracle 判断语句如何写,高手请进 如果很好解决另付200分 定时器定时调用存储过程后,写入日志表中 高分求解:关于spool字符集的问题? 数据类型问题! oracle817,如何更改一个表中字段的长度?varchar2型,原来定义为3000,现在要改为2000 怎么把带有数字,英文字母和符号的行挑出来? 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
非常感谢!