--建立临时表
create table pll_0319_test
(str varchar2(20),
insertdate date
);
select *
from pll_0319_test p
;--建立job的脚本
begin
sys.dbms_job.submit(job => :job,
what => 'insert into pll_0319_test
select ''test'',sysdate from dual;
commit;',
next_date => to_date('19-03-2007 20:33:17', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'sysdate+1/24/60');
commit;
end;
/
create table pll_0319_test
(str varchar2(20),
insertdate date
);
select *
from pll_0319_test p
;--建立job的脚本
begin
sys.dbms_job.submit(job => :job,
what => 'insert into pll_0319_test
select ''test'',sysdate from dual;
commit;',
next_date => to_date('19-03-2007 20:33:17', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'sysdate+1/24/60');
commit;
end;
/
SQL> begin
2 dbms_job.submit(:n,'kill_inactivate_session;',sysdate,'sysdate+1/1440 ');
3 commit;
4 end;
5 /PL/SQL procedure successfully completed
n
---------
514