                        課程
                    
                        /數據庫
                        
                            /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

關注問題我要回答

1532

操作

收起

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等值，就可以了