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';