通过Oracle存储过程每分钟 往 time_test 表中插入当前时间
-- 1建表
create table time_test(times Date);
Select * FROM time_test;
-- 2创建存储过程
create or replace procedure Pro_test
as
Begin
-- delete from time_test;
insert into time_test select Sysdate from dual;
End;
-- 3创建job
declare
jobno number;
begin
dbms_job.submit(jobno, 'Pro_test;', sysdate, 'TRUNC(sysdate,''mi'') + 1 / (24*60)');
commit;
end;
-- 4查看job号
select * from user_jobs;
-- 5操作job
--启动定时器
begin
dbms_job.run(4);
commit;
end;
--停止定时器
begin
dbms_job.broken(144,true);
commit;
end;
--定时器删除
begin
dbms_job.remove(144);
commit;
end;
Select * FROM time_test;
-- 1建表
create table time_test(times Date);
Select * FROM time_test;
-- 2创建存储过程
create or replace procedure Pro_test
as
Begin
-- delete from time_test;
insert into time_test select Sysdate from dual;
End;
-- 3创建job
declare
jobno number;
begin
dbms_job.submit(jobno, 'Pro_test;', sysdate, 'TRUNC(sysdate,''mi'') + 1 / (24*60)');
commit;
end;
-- 4查看job号
select * from user_jobs;
-- 5操作job
--启动定时器
begin
dbms_job.run(4);
commit;
end;
--停止定时器
begin
dbms_job.broken(144,true);
commit;
end;
--定时器删除
begin
dbms_job.remove(144);
commit;
end;
Select * FROM time_test;