DECLARE
ROWNUM NUMBER;
BEGIN
ROWNUM := 175;
FOR i IN 1..ROWNUM
LOOP
UPDATE MEMBERS
SET
MEMBER_ID = 3000 + 2*(SELECT ID FROM MEMBERS WHERE ID = i)
WHERE ID = i;
END LOOP;
END;
DECLARE
ROWNUM NUMBER;
BEGIN ROWNUM := 164;
FOR i IN 1..ROWNUM
LOOP
UPDATE SUNDAY_VISITORS
SET VISITOR_ID = 900000 + 2*(SELECT ID FROM SUNDAY_VISITORS WHERE ID = i)
WHERE ID = i;
END LOOP;
END;