oracle在SQLPLUS 和PLSQL建 job 的区别
在SQLPLUS 是这样写
//建立job
variable test_job_really number;
begin
dbms_job.submit(:test_job_really,'test_jobproce;',sysdate,'sysdate+1/1440');
commit;
end;
--------------------------
如果是PLSQL的话
--declare
declare test_job_really number;
begin
dbms_job.submit(test_job_really,'test_jobproce;',sysdate,'sysdate+1/1440');//test_job_really前面去掉:号
commit;
end;
要这么写```