关于oracle job的问题，

Question

SQLPLUS:   USERNAME:EDUCATION   PASSWORD:EDUCATION后
   VARIABLE  X  NUMBER;
   EXECUTE DBMS_JOB.SUBMIT(:X,'delete from table1 where dat_no<sysdate-7;',SYSDATE,'SYSDATE+7');
   以上操作如果無錯誤則成功

Answer 1

VARIABLE jobno number;
begin
      DBMS_JOB.SUBMIT(:jobno, 
              'delete from tbname where sysdate-cr_time>7;', 
               SYSDATE, 'SYSDATE + 7');
         commit;
end;
/

Answer 2

能否 解释一下
我用pl\sql生成的语句
begin
  sys.dbms_job.submit(job => :job,
                      what => 'delete from table1 t  where sysdate-t.cr_time>7',
                      next_date => to_date('29-05-2003 12:47:04', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => '7');
  commit;
end;
/
 这样对吗