procedure name_pro(p_value data_type)
is
cursor c_sor is
select * from file_name_t where flag=0 for update of flag;
begin
for v_sor in t_sor loop
...
update file_name_t set flag=1 where current of c_sor;
end loop;
end name_pro;
/
procedure name_pro(p_value data_type)
is
cursor t_sor is
select * from file_name_t;
--where 条件=v_id;
begin
for v_sor in t_sor loop
update file_name_t set flag=1 where filename=v_sor.filename;
end loop;
end name_pro;