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;