oracle 循环

先定义游标

 

CURSOR CUR IS
   SELECT ADMIN_NAME FROM TBL_LINK_SPECIFY_ADMIN ;

 

 OPEN CUR;
  LOOP
      FETCH CUR INTO V_ADMIN_NAME;
      EXIT WHEN CUR%NOTFOUND;
     //do anything      

  END LOOP;