Question

在Oracle中写如下sql语句时报无效sql

cursor cemp is select * from emp;
pename emp.ename%type;
begin
open cemp;
loop
fetch cemp into pename;
exit when cemp%notfound;
dbms_output.putline(pename);
end loop;
close cemp;

Answer 1

1 2 3 4 5 6 7 8 9 10 11 12 13 14

declare   cursor cemp is     select ename from emp;   pename emp.ename%type; begin   open cemp;   loop     fetch cemp       into pename;     exit when cemp%notfound;     dbms_output.putline(pename);   end loop;   close cemp; end;

 你的变量类型不是只定义了ename嘛，那就不能select * 然后into，只select ename就可以了，而且这些要写在declare里。

Answer 2

缺少PL/SQL结束end