本帖最后由 tongleye 于 2012-2-29 15:24 编辑
create or replace procedure test1 as
begin
insert into a values(sysdate);
end;
create or replace procedure test2 as
declare
job number;
dbms_job.submit(:job,'test1;'sysdate, 'sysdate+1/1440 ');
begin
dbms_job.run(:job);
end;
select to_char(a, 'yyyy/mm/dd hh24:mi:ss ') from a
查询结果为空,请问问题出在哪?
ZALBB 发表于 2012-2-29 08:54
commit;
create or replace procedure test1 as
begin
insert into a values(sysdate);
end;
create or replace procedure test2 as
declare
job number;
dbms_job.submit(:job,'test1;'sysdate, 'sysdate+1/1440 ');
begin
dbms_job.run(:job);
commit;
end;
select to_char(a, 'yyyy/mm/dd hh24:mi:ss ') from a
这样吗?还是一样