17,086
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
beckhambobo 2003-10-16
- 打赏
- 举报
create procedure pro
as
begin
insert into aa value(...);
commit;
end;
/
declare
jobno number;
begin
dbms_job.submit(jobno,'pro;',sysdate,'sysdate+5/(24*60*60)');
commit;
end;
/
as
begin
insert into aa value(...);
commit;
end;
/
declare
jobno number;
begin
dbms_job.submit(jobno,'pro;',sysdate,'sysdate+5/(24*60*60)');
commit;
end;
/
