declare
begin
for c in(select sercaid from serca_base where rownum<=100)
loop
begin
update serca_pic set inputusername='shouhou' where sercaid =c.sercaid;
update scene_base set caseplace='沈阳' where sceneid in (select sceneid from serca_pic where sercaid=c.sercaid);
update scene_pic set leftposition='窗台' where picid in (select picid from serca_pic where sercaid=c.sercaid);
update serca_base set sercaname='串案名称' where sercaid =c.sercaid;
end;
end loop;
update auth_department set deptdistrict='山东大队' where rownum<=100;
update auth_user set username='创建人' where rownum<=100;
end;
declare
name varchar2(50);
begin
for c in(select provincedeptid from copydeparment where depttypeid=2)
loop
begin
select deptname into name from copydeparment where provincedeptid=c.provincedeptid and depttypeid=2;
update copydeparment set provincedeptname=name where provincedeptid=c.provincedeptid;
end;
end loop;
end;