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

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