Oracle创建定时任务教程
1、创建任务执行的存储过程UpdateSettlementJobcreate or replace procedure UpdateSettlementJob isbegin update cmp_settlement set pk_tradetype = 'H194', pk_tradetypeid = '1001AA10000000008UOZ' where pk_tradetype = '~' and NVL(DR, 0) = 0 AND billcod