Oracle 游标循环更新数据

DECLARE
    CURSOR cur IS
        SELECT *
        FROM ALY_TEST_RESULT2;
BEGIN
    FOR rw IN cur
    LOOP
        UPDATE ALY_TEST_RESULT2
        SET id2 = ALY_TEST_RESULT_autoid.NEXTVAL
        WHERE id = rw.id;
    END LOOP;
END;