ORACLE 循环变更对应字段数据

begin
  for i in (select id, item_id, specifications
                from mrp_mps_schedule
               where specifications is null) loop
    update mrp_mps_schedule
       set specifications =
           (select specifications from bom_item where id = i.item_id) where id = i.id;
  end loop;
end;