创建定时器
(1)创建表
create table stu(
name VARCHAR(10),
sex number(1),
phone varchar(11)
);
(2)创建存储
create or replace procedure p_myDemo
as
begin
insert into stu values ('XXX',1,1599992322);
commit;
end;
(3)创建定时任务
DECLARE
jobno NUMBER;
BEGIN
dbms_job.submit( jobno, 'p_myDemo();',
sysdate,
'sysdate+1/(24*60*60)'
);
END;