- SQL code
declarecursor is mycursor1 select ename,sal from emp;v_ename emp.ename%type;v_sal emp.sal%type;begin open mycursor1; loop fetch mycursor1 into v_ename,v_sal; exit when mycursor1%notfound; dbms_output.put_line('姓名:'||v_ename||',工资:'||v_sal); end loop; close mycursor1;end;/------解决方案--------------------
is mycursor1位置颠倒了。
代码迷推荐解决方案：软件开发者薪资,http://www.daimami.com/other/1391128.html