oracle写一个定时执行的sql语句，JOB也行

create or replace procedure test as
begin
insert into table_a values(sysdate);
end;
/

variable job1 number;
begin
dbms_job.submit(:job1,'test',sysdate,'sysdate+1/1440');
end;
/
我这样写到variable老是提示无效...

---

begin
sys.dbms_job.submit(job =>磨改没 :job,
what => 'begin
insert into table_a values(sysdate);
end;
/
‘
next_date => to_date('25-07-2013 16:00:00', 'dd-mm-yyyy hh24:mi:ss'瞎纳),
interval => 'TRUNC(sysdate,''hh'') + 1/4'歼兆);
commit;
end;
/

---

不是用variable，应该用declare的

---

insert into table_a values(sysdate); 这个....是不是语法错瞎扒误了,没有指定列名扒乱哇.不是很磨此昌了解ORACLE不过,你这个错误有点明显哈

---