存储过程的定义及list的应用

create or replace procedure SP_update_abc as
begin

insert into joblog values
('SP_update_abc ', ‘procedure’,‘更新abc表：start’ , sysdate, ‘’ );

for list in
(select idcard,az.sid from info az where not exists (select 1 from bu_info_user oo
where oo.idcard=az.idcard and oo.sid =az.sid ))
loop

update bu_info_user oo set oo.sid=list.sid where oo.idcard=list.idcard;

end loop;

insert into joblog values
('SP_update_abc ', ‘procedure’,‘更新abc表：end’ , sysdate, ‘’ );
commit;

end;