oracle 中 使用 begin end 批量更新，删除资料

1.插入资料

begin
  for i in 800001..800144 loop
    insert into sp_case values(i,'0','M084778',SYSDATE,'0','B3-S-2F',null,null);
  end loop;
  commit;
end;

2更新资料

begin
  for i in 650217..650252 loop
    update sp_case set cloc='B6B-N-1F' where casena=i and cloc='B6B-N-3F';
  end loop;
  commit;
end;

3. 删除资料

begin
  for i in 9072..9179 loop
    delete from sp_case where casena=i and cloc='A2-N-1F';
  end loop;
end;

4.查询资料

  select *
      from sp_case
     where casena between 5630 and 5646
       and cloc = 'A2-N-1F';