3,494
社区成员




SQL> create or replace procedure delete_recordjuncline as
2 begin
3 delete from recordjuncline t where t.datetime <(select max(l.datetime-20) from recordjuncline l);
4 end;
5 /
Procedure created
SQL> variable job1 number;
SQL> begin
2 dbms_job.submit(:job1,'delete_recordjuncline;',sysdate,'sysdate+1');
3 end;
4 /
PL/SQL procedure successfully completed
job1
---------
21
SQL> begin
2 dbms_job.run(:job1);
3 end;
4 /
PL/SQL procedure successfully completed
job1
---------
21
SQL>