存储过程
CREATE OR REPLACE
AS
countNum varchar2(10);
BEGIN
select count(*) Into countNum from 表
end;
任务调度
job
declare
jobno number;
DBMS_JOB.SUBMIT(
job => jobno,
what => '存储过程名字',
NEXT_DATE => sysdate+1(24*60),
Interval => 'trunc(sysdate,''mi'')+1/(24*60)'
);
commit;
end;