Oracle定时任务调用存储过程和TRUNC的使用
创建存储过程为,定时任务准备
--删除core,cmnet,sp,miq,4张表一周之前的数据
create or replace procedure del_alarm_others_cancel_info AS
begin
delete m_core_cancel where (sysdate-7) > ttime;
delete m_cmnet_cancel where (sy...
原创
2018-12-20 16:05:02 ·
1535 阅读 ·
0 评论