例子
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 + (90/(24*60*60))');
4 COMMIT;
5 END;
6 /
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 + (90/(24*60*60))');
4 COMMIT;
5 END;
6 /
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货