如果有类似的需求，可以按照以下方式实现。
CREATE OR REPLACE PROCEDURE do_job IS
BEGIN
EXECUTE IMMEDIATE 'drop sequence Srno';
EXECUTE IMMEDIATE 'create sequence SrNo minvalue 1'||
' maxvalue 9999999'||
' start with 1'||
' increment by 1'||
' Order';
END do_job;
/
Declare
v_job BINARY_INTEGER;
begin
dbms_job.submit(v_job,'Begin do_job; end;',trunc(last_day(sysdate)+1)+(6/24),'trunc(last_day(sysdate)+1)+(6/24)');
end;
/
阅读(2450) | 评论(0) | 转发(0) |
