APP 
set serveroutput onDECLARE CURSOR cemp is select ename ,sal from emp ; pename emp.ename%TYPE ; psal emp.sal%TYPE ; BEGIN OPEN cemp; LOOP FETCH cemp INTO pename,psal; EXIT WHEN cemp%notfound; dbms_output.put_line(pename||'的薪水是'||psal); END LOOP; CLOSE cemp;END; set ......
本文摘自 ：https://www.cnblogs.com/
