                        課程
                    
                        /數(shù)據(jù)庫
                        
                            /Oracle
                        
                        /Oracle數(shù)據(jù)庫開發(fā)必備利器之PL/SQL基礎(chǔ)

pl/sql中的帶參數(shù)的光標(biāo)問題

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數(shù)據(jù)庫開發(fā)必備利器之PL/SQL基礎(chǔ) 3-5

關(guān)注問題我要回答

1514

操作

收起

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

將參數(shù)dno賦值7369等值，就可以了