17,089
社区成员
发帖
与我相关
我的任务
分享
PROCEDURE ResetSeq Authid Current_User IS
V_SeqName varchar2(100);
BEGIN
select decode(mod(trunc(sysdate)-to_Date('2014-01-01','yyyy-mm-dd'),2),1,'SEQ_B','SEQ_A')
INTO V_SeqName from dual;
EXECUTE IMMEDIATE 'DROP SEQUENCE '||V_SeqName;
EXECUTE IMMEDIATE 'CREATE SEQUENCE '||V_SeqName||' increment by 1 start with 1 nocache nocycle';
END;
declare jobno number;
begin
DBMS_JOB.SUBMIT(:jobno,
'ResetSeq;',
TRUNC(SYSDATE),'trunc(sysdate)+1');
commit;
end;