oracle9i定义游标麻烦看下哪儿错了SQL codedeclarecursor is mycursor1 select ename,sal from empv_enam
oracle9i定义游标麻烦看下哪儿错了
- 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.myexception.cn/other/1391128.html