create table student(name varchar2(20));
create or replace procedure my_pro(name1 varchar2) as
begin
insert into student(name) values(name1);
end; declare myjob number;
begin
sys.dbms_job.submit(job=>:myjob,
what=>'my_pro(''smith'');',
next_date=>sysdate,
interval=>'sysdate+ 1/1440',
no_parse => false);
sys.dbms_output.put_line( 'success ');
commit;
end;
create or replace procedure my_pro(name1 varchar2) as
begin
insert into student(name) values(name1);
end; declare myjob number;
begin
sys.dbms_job.submit(job=>:myjob,
what=>'my_pro(''smith'');',
next_date=>sysdate,
interval=>'sysdate+ 1/1440',
no_parse => false);
sys.dbms_output.put_line( 'success ');
commit;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货