FOR LOOP IN ORACLE

[mou lei]

FOR manager_rec IN (select userid from manager where logindomain=p_old_zone) LOOP

update manager set logindomain=p_new_zone where userid=manager_rec.userid;
END LOOP;