begin
sys.dbms_job.submit(job => :v_jobAutoDel,
what => 'p_sysdeleteinfo;'); <--/*这是干嘛*/
next_date => to_date('28-07-2003 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'trunc(sysdate)+31/24');<-/*这是7天吗?*/
commit;
end;光说不练之龙飞虎听党的话,跟3个代表走,从ORACLE概念学
sys.dbms_job.submit(job => :v_jobAutoDel,
what => 'p_sysdeleteinfo;'); <--/*这是干嘛*/
next_date => to_date('28-07-2003 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'trunc(sysdate)+31/24');<-/*这是7天吗?*/
commit;
end;光说不练之龙飞虎听党的话,跟3个代表走,从ORACLE概念学
CREATE SEQUENCE temp_seq
START WITH 1
INCREMENT BY 1;
CREATE OR REPLACE PROCEDURE TempInsert AS
BEGIN
INSERT INTO temp_table (num_col, char_col)
VALUES (temp_seq.nextval,
TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')); COMMIT;
END TempInsert;
SQL> VARIABLE v_JobNum NUMBER
SQL> BEGIN
2 DBMS_JOB.SUBMIT(:v_JobNum, 'TempInsert;', SYSDATE,
3 'sysdate + 7');
4 COMMIT;
5 END;
6 /
PL/SQL procedure successfully completed.