Oracle存储过程基本语法

http://www.cnblogs.com/hero4china/articles/base_rule_oracle_procedure.html

分享下，自己写的一个批量插入数据

declaresim_s varchar2(100);sim_e varchar2(200);sim_nail varchar2(20);ch_l  number;i number;begin  sim_s:='8986010960516039';  i:=0;  loop    ch_l:=length(to_char(i));    if ch_l=1 then      sim_nail:='00' || to_char(i);    elsif ch_l=2 then      sim_nail:='0' || to_char(i);    else      sim_nail:=to_char(i);    end if;    sim_e:=sim_s || sim_nail;    insert into i_sim(sim_id) values (sim_e);    i := i+1;    exit when i>999;  end loop;  commit;  exception    when others then      rollback;end;