Oracle存储过程基本语法

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

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

declare
sim_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;