variable jobno number;
variable instno number;
begin
select instance_number into :instno from v$instance;
--A_TO_B是过程
dbms_job.submit(:jobno, 'A_TO_B;', trunc(sysdate+1), 'trunc(SYSDATE+1)', TRUE, :instno);
...
oracle job
最新推荐文章于 2023-12-16 10:45:00 发布