                        课程
                    
                        /数据库
                        
                            /Oracle
                        
                        /Oracle数据库开发必备利器之PL/SQL基础

pl/sql中的带参数的光标问题

set serveroutput on

declare

cursor cemp(dno number) is select ename from emp where empno=dno;

pename emp.ename%type;

begin

open cemp(10);

LOOP

fetch cemp into pename;

exit when cemp%notfound;

dbms_output.put_line(pename);

end loop;

close cemp;

end;

judyW

2017-06-01

源自：Oracle数据库开发必备利器之PL/SQL基础 3-5

关注问题我要回答

1452

操作

收起

1 回答

HelloiM00c 回答被采纳 +3 积分
2017-06-01

SQL--> select ename, empno from emp;

ENAME      EMPNO                  
---------- ---------------------- 
SMITH      7369                   
ALLEN      7499                   
WARD       7521                   
JONES      7566                   
MARTIN     7654                   
BLAKE      7698                   
CLARK      7782                   
SCOTT      7788                   
KING       7839                   
TURNER     7844                   
ADAMS      7876                   
JAMES      7900                   
FORD       7902                   
MILLER     7934

将参数dno赋值7369等值，就可以了