create or replace procedure sp_delete_user is begin delete user where …… end sp_delete_user; / begin sys.dbms_job.submit(job => :job, what => 'sp_delete_user;', next_date => to_date('23-08-2004 12:00:00', 'dd-mm-yyyy hh24:mi:ss'), interval => 'sysdate+365'); commit; end; /
--建删除数据的过程 create or replace procedure delete_user_data as begin delete from user a where ...... commit; exception when others then rollback; end; --建JOB variable v_job; begin dbms_job.submit(:v_job,'delete_user_data;',sysdate,'sysdate+1'); end;
is
begin
delete user where ……
end sp_delete_user;
/
begin
sys.dbms_job.submit(job => :job,
what => 'sp_delete_user;',
next_date => to_date('23-08-2004 12:00:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'sysdate+365');
commit;
end;
/
create or replace procedure delete_user_data as
begin
delete from user a where ......
commit;
exception
when others then
rollback;
end;
--建JOB
variable v_job;
begin
dbms_job.submit(:v_job,'delete_user_data;',sysdate,'sysdate+1');
end;