--执行更新的过程 create or replace procedure proc_test as begin update table set ... where .....; commit; exception when others then rollback; end ;--job,30分钟运行一次:SQL> VARIABLE V_JOB NUMBER; SQL> BEGIN SQL> DBMS_JOB.SUBMIT(:V_JOB,'PROC_TEST;',SYSDATE,'SYSDATE+30/(24*60)'); SQL> END;
create or replace procedure proc_test as
begin
update table set ... where .....;
commit;
exception
when others then
rollback;
end ;--job,30分钟运行一次:SQL> VARIABLE V_JOB NUMBER;
SQL> BEGIN
SQL> DBMS_JOB.SUBMIT(:V_JOB,'PROC_TEST;',SYSDATE,'SYSDATE+30/(24*60)');
SQL> END;