oracle在SQLPLUS 和PLSQL建 job 的区别

 

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; 

要这么写```