sequence自动置位的问题～～高手救命～～～

Question

CREATE A JOB,
THEN DROP SEQUENCE THEN CREATE SEQUENCE IN JOB

Answer 1

1.建立一个任务：每天00:00:00执行下列语句：
2.drop sequence sequence_name;
3.CREATE SEQUENCE sequence_name INCREMENT BY 1 START WITH 1 MINVALUE 0 MAXVALUE 99999999999999999 NOCYCLE NOCACHE NOORDER;

Answer 2

create procedure pro
as
str varchar2(50);
begin
str:='drop sequence sequence_name';
execute immediate str;
str:='create sequence sequence_name START WITH     1000  INCREMENT BY   1';
execute immediate str;
end;
/
declare
jobno number;
begin
dbms_job.submit(jobno,'pro;',sysdate,'trunc(sysdate)+1');
commit;
end;
/