Oracle 插入记录后删除记录

SQL> create table t ( x int, deletion_time date );

Table created.

SQL> insert into t values (1, sysdate + 10/1440);

1 row created.

SQL> insert into t values (2, sysdate + 10/1440);

1 row created.

SQL> insert into t values (3, sysdate + 10/1440);

1 row created.

SQL> insert into t values (4, sysdate + 10/1440);

1 row created.

SQL> insert into t values (5, sysdate + 10/1440);

1 row created.

SQL> insert into t values (6, sysdate + 10/1440);

1 row created.

SQL>
SQL> select * from t;

         X DELETION_TIME
---------- -------------------
         1 30/06/2017 12:51:59
         2 30/06/2017 12:52:02
         3 30/06/2017 12:52:05
         4 30/06/2017 12:52:08
         5 30/06/2017 12:52:11
         6 30/06/2017 12:52:14

6 rows selected.

SQL> create or replace
  2  procedure del_old_rows is
  3  begin
  4    delete from t where deletion_time < sysdate ;
  5    commit;
  6  end;
  7  /

Procedure created.

SQL>
SQL> declare
  2    j int;
  3  begin
  4    dbms_job.submit(j,'del_old_rows;',sysdate,'sysdate+1/1440');
  5  end;
  6  /

PL/SQL procedure successfully completed.
复制