17,382
社区成员




variable job number;
begin
sys.dbms_job.submit(:job,'SP_RUN_8;', to_date('04-12-2009 21:46:00', 'dd-mm-yyyy hh24:mi:ss'),'TRUNC(sysdate,''mi'') + 1 / (24*60)');
commit;
end;
OPER@tl> create table test(aaa date,bbb date);
表已创建。
OPER@tl> create or replace procedure p1
2 as
3 begin
4 insert into test(aaa) values(sysdate);
5 commit;
6 end;
7 /
过程已创建。
OPER@tl> create or replace procedure p2
2 as
3 begin
4 insert into test(bbb) values(sysdate);
5 commit;
6 end;
7 /
过程已创建。
OPER@tl> create or replace procedure p12
2 as
3 begin
4 p1;
5 p2;
6 end;
7 /
过程已创建。
OPER@tl> declare
2 i number;
3 begin
4 dbms_job.submit(i,'p12;',sysdate,'sysdate+1/3600/24');
5 end;
6 /
PL/SQL 过程已成功完成。
OPER@tl> commit;
提交完成。
OPER@tl> select * from test;
AAA BBB
------------------- -------------------
2009-12-04 22:30:14
2009-12-04 22:30:19
2009-12-04 22:30:24
2009-12-04 22:30:29
2009-12-04 22:30:29
OPER@tl> select * from test;
AAA BBB
------------------- -------------------
2009-12-04 22:30:14
2009-12-04 22:30:19
2009-12-04 22:30:24
2009-12-04 22:30:29
2009-12-04 22:30:29
OPER@tl> select * from test;
AAA BBB
------------------- -------------------
2009-12-04 22:30:14
2009-12-04 22:30:19
2009-12-04 22:30:24
2009-12-04 22:30:29
2009-12-04 22:30:29
2009-12-04 22:30:34
2009-12-04 22:30:34
已选择7行。
OPER@tl> select * from test;
AAA BBB
------------------- -------------------
2009-12-04 22:30:14
2009-12-04 22:30:19
2009-12-04 22:30:24
2009-12-04 22:30:29
2009-12-04 22:30:29
2009-12-04 22:30:34
2009-12-04 22:30:34
已选择7行。
OPER@tl> select * from test;
AAA BBB
------------------- -------------------
2009-12-04 22:30:14
2009-12-04 22:30:19
2009-12-04 22:30:24
2009-12-04 22:30:29
2009-12-04 22:30:29
2009-12-04 22:30:34
2009-12-04 22:30:34
已选择7行。
OPER@tl> select * from test;
AAA BBB
------------------- -------------------
2009-12-04 22:30:14
2009-12-04 22:30:19
2009-12-04 22:30:24
2009-12-04 22:30:29
2009-12-04 22:30:29
2009-12-04 22:30:34
2009-12-04 22:30:34
2009-12-04 22:30:39
2009-12-04 22:30:39
已选择9行。
OPER@tl> select * from test;
AAA BBB
------------------- -------------------
2009-12-04 22:30:14
2009-12-04 22:30:19
2009-12-04 22:30:24
2009-12-04 22:30:29
2009-12-04 22:30:29
2009-12-04 22:30:34
2009-12-04 22:30:34
2009-12-04 22:30:39
2009-12-04 22:30:39
已选择9行。
OPER@tl> select * from test;
AAA BBB
------------------- -------------------
2009-12-04 22:30:14
2009-12-04 22:30:19
2009-12-04 22:30:24
2009-12-04 22:30:29
2009-12-04 22:30:29
2009-12-04 22:30:34
2009-12-04 22:30:34
2009-12-04 22:30:39
2009-12-04 22:30:39
已选择9行。
OPER@tl> select * from test;
AAA BBB
------------------- -------------------
2009-12-04 22:30:14
2009-12-04 22:30:19
2009-12-04 22:30:24
2009-12-04 22:30:29
2009-12-04 22:30:29
2009-12-04 22:30:34
2009-12-04 22:30:34
2009-12-04 22:30:39
2009-12-04 22:30:39
2009-12-04 22:30:44
2009-12-04 22:30:44
已选择11行。