Navicat 连接Oracle数据库后想创建job,从plsql导出job的SQL在Navicat执行不了,求问如何在Navicat下建立job或者定时函数
plsql developer 直接查看job对象是长这个样子
begin
sys.dbms_job.submit(job => :job,
what => 'null;',
next_date => to_date('22-12-2021 00:40:02', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'trunc(sysdate)+1');
commit;
end;
/
需要稍微修改一下,声明个参数,用来接收job号就好了
declare
job number;
begin
sys.dbms_job.submit(job => job,
what => 'null;',
next_date => to_date('22-12-2021 00:40:02', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'trunc(sysdate)+1');
commit;
end;
/
注意参数前的冒号要去掉