创建job

--创建过程

create or replace procedure t as
begin
  insert into tian(id) (se_a.nextval);
  commit;
  end;

 
 --创建job,每天凌晨2点执行 
declare  job number;      
begin
sys.dbms_job.submit(job,'t;',sysdate,'trunc(sysdate+1)+2/24');
end;

 

--删除重复数据
delete from tian a where rowid>  (select min(rowid) from tian b where a.id=b.id)