先定义游标
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;
先定义游标
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;