有个问题请教

[xiangjai]

SQL> set serveroutput on;
SQL> declare
2 cursor c(v_deptno emp.deptno%type, v_job emp.job%type)
3 is
4 select ename, job from emp where v_deptno = deptno and v_job = job;
5 v_emp c%rowtype;
6 begin
7 for v_emp in c(30,'clerk') loop
8 dbms_output.put_line(v_emp.ename);
9 end loop;
10 end;
11 /

PL/SQL 过程已成功完成。
为什么 没有出现结果啊

下面是表信息


ENAME JOB SAL DEPTNO EMPNO
---------- --------- ---------- ---------- ----------
SMITH CLERK 800 20 7369
ALLEN SALESMAN 1600 30 7499
WARD SALESMAN 1250 30 7521
JONES MANAGER 2975 20 7566
MARTIN SALESMAN 1250 30 7654
BLAKE MANAGER 2850 30 7698
CLARK MANAGER 2450 10 7782
SCOTT ANALYST 3000 20 7788
KING PRESIDENT 5000 10 7839
TURNER SALESMAN 1500 30 7844
ADAMS CLERK 1100 20 7876

ENAME JOB SAL DEPTNO EMPNO
---------- --------- ---------- ---------- ----------
JAMES CLERK 950 30 7900
FORD ANALYST 3000 20 7902
MILLER CLERK 1300 10 7934

[Acesidonu]

4 select ename, job from emp where deptno = v_deptno and job = v_job;
注意前后位置

7 for v_emp in c(30,'CLERK') loop
注意大小写

[xiangjai]

谢谢了 解决

[吕大豹]

结贴率是0！！！！