oracle功课

oracle作业

declare job number;BEGIN            SYS.DBMS_JOB.SUBMIT            ( job =>job               ,what => 'procedurename;'               ,next_date => to_date(to_char(sysdate+1,'yyyy-mm-dd')||'01:00:00','yyyy-mm-dd hh24:mi:ss'),               ,interval => 'trunc(sysdate+1)+(1/24)'               ,no_parse => FALSE            );

?每天凌晨1点执行procedurename存储过程