BEGIN

     FOR x IN (Select * from MISSIONARY) LOOP

     UPDATE MISSIONARY

     SET BASE = 'USA'

     WHERE MID = x.MID;

     END LOOP;

COMMIT;

END;