select * from test_table for update
begin
for cur in (
select id from test_table
)
loop
update test_table set name = '苏晓伟' where id = cur.id;
end loop;
END;
select * from test_table for update
begin
for cur in (
select id from test_table
)
loop
update test_table set name = '苏晓伟' where id = cur.id;
end loop;
END;