游标for循环
程序员文章站
2022-06-02 12:53:55
...
CREATE OR REPLACE PROCEDURE PRO_EMP_A IS
CURSOR CUR_AA IS
SELECT EMPNO, ENAME FROM EMP WHERE ENAME LIKE 'S%';
BEGIN
FOR CUR_BB IN CUR_AA LOOP
DBMS_OUTPUT.PUT_LINE(CUR_BB.EMPNO || CUR_BB.ENAME);
END LOOP;
END;
call PRO_EMP_A();
下一篇: iOS开发 self与super总结