DECLARE CURSOR XS_CUR2 IS
SELECT EMPNO,ENAME,JOB FROM emp WHERE JOB='CLERK';
BEGIN
OPEN XS_CUR2;
dbms_output.put_line(XS_CUR2%ROWCOUNT);
close XS_CUR2;
END;
...全文
493打赏收藏
一个简单的游标的问题
DECLARE CURSOR XS_CUR2 IS SELECT EMPNO,ENAME,JOB FROM emp WHERE JOB='CLERK'; BEGIN OPEN XS_CUR2; dbms_output.put_line(XS_CUR2%ROWCOUNT); close XS_CUR2; END;