- CREATE OR REPLACE PROCEDURE PRC_LJ IS
- CURSOR C_EMP IS --声明显式游标
- SELECT EMPNO,ENAME FROM EMP;
- C_ROW C_EMP%ROWTYPE; --定义游标变量,该变量的类型为基于游标C_EMP的记录
- BEGIN
- --For 循环
- FOR C_ROW IN C_EMP LOOP
- DBMS_OUTPUT.PUT_LINE(C_ROW.EMPNO || '--' || C_ROW.ENAME);
- END LOOP;
- --Fetch 循环
- OPEN C_EMP;--必须要明确的打开和关闭游标
- LOOP
- FETCH C_EMP
- INTO C_ROW;
- EXIT WHEN C_EMP%NOTFOUND;
- DBMS_OUTPUT.PUT_LINE(C_ROW.EMPNO || '++' || C_ROW.ENAME);
- END LOOP;
- CLOSE C_EMP;
- --While 循环
- OPEN C_EMP;--必须要明确的打开和关闭游标
- FETCH C_EMP INTO C_ROW;
- WHILE C_EMP%FOUND LOOP
- DBMS_OUTPUT.PUT_LINE(C_ROW.EMPNO || '**' || C_ROW.ENAME);
- FETCH C_EMP INTO C_ROW;
- END LOOP;
- CLOSE C_EMP;
- END PRC_LJ;
-