oracle定时器，每分钟查询一次表中数据
declare
jobno number;
begin
dbms_job.submit(
jobno,
'select * from customers;',
interval => TRUNC(sysdate,'mi') + 1 / (24 * 60)
);
commit;
end;
[解决办法]
begin sys.dbms_job.submit(job => :job, what => '存储过程名称', next_date => sysdate, interval => 'sysdate+1'); commit; end;
[解决办法]
还是在pl/sql dev中创建吧，what里面存放要循环的内容，interval存放时间的间隔。有这两个就足够了