MySQL Forums
Forum List  »  Oracle

Advanced Search
New Topic

FOR LOOP IN ORACLE
Posted by: mou lei
Date: March 20, 2006 12:14AM

i have a procedure in oracle as below

FOR manager_rec IN (select userid from manager where logindomain=p_old_zone) LOOP
dbms_output.put_line('update manager set logindomain='||p_new_zone ||' where userid='||manager_rec.userid);
update manager set logindomain=p_new_zone where userid=manager_rec.userid;
END LOOP;

how to use it in mysql,thanks a lot.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
FOR LOOP IN ORACLE
4014
mou lei
March 20, 2006 12:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.