oracle - for in loop 循环更新

在这BEGIN
 FOR r IN (
  SELECT
   A .*
  FROM
   SYS_STATIONS A
  WHERE
        a.STATION_LEVEL='3' and
        a.PARENT_ID='734B4980-DA31-4A80-AFD8-BEB7AEB0D2E2' and
        a.STATION_TYPE='0'
 ) loop
UPDATE SYS_STATIONS
SET OLD_STATION_ID = r.STATION_ID
WHERE
 STATION_ID = r.STATION_ID;
END loop ;
END;

BEGIN
 FOR 表1 IN (
SELECT [匹配字段]，[更新字段] FROM A表
 ) loop
UPDATE B表
SET B表.[需要更新字段]= 表1.[更新字段]；
WHERE
 B表.[匹配字段]= 表1.[匹配字段];
END loop ;
END;