variable job1 number;
dbms_job.submit(:job1,'sp_reset_sequence;',to_date(to_char(sysdate,'yyyy')||'0101','yyyymmdd'),'to_date((to_char(sysdate,'yyyy')+1)||'0101','yyyymmdd')');
dbms_job.submit(:job1,'sp_reset_sequence;',to_date(to_char(sysdate,'yyyy')||'0101','yyyymmdd'),'to_date((to_char(sysdate,'yyyy')+1)||'0101','yyyymmdd')');
SQL>variable n number;
SQL>exec sp_reset_sequence(n);
难道可以不设变量吗?
jobno number;
begin
dbms_job.submit(jobno,'sp_reset_sequence;',sysdate,'trunc(sysdate,''yy'')+365');
commit;
end;
/