方法一:
TYPE CUR_TYPE IS REF CURSOR
CUR_EMP CUR_TYPE;
OPEN CUR_EMP FROM 'select name,id from t_emp';
FETCH CUR_MEP INTO ...
WHILE(CUR_MEP%FOUND) LOOP
END LOOP;
方法二:
FOR CUR_EMP IN (SELECT NAME,ID FROM T_EMP ) LOOP
END LOOP
方法三:
CURSOR CUR_EMP IS
SELECT NAME ,ID FROM T_EMP;
OPEN CUR_EMP;
TYPE CUR_TYPE IS REF CURSOR
CUR_EMP CUR_TYPE;
OPEN CUR_EMP FROM 'select name,id from t_emp';
FETCH CUR_MEP INTO ...
WHILE(CUR_MEP%FOUND) LOOP
END LOOP;
方法二:
FOR CUR_EMP IN (SELECT NAME,ID FROM T_EMP ) LOOP
END LOOP
方法三:
CURSOR CUR_EMP IS
SELECT NAME ,ID FROM T_EMP;
OPEN CUR_EMP;