刚学pl/sql不久,很菜。想在存储过程中使用游标,老是报错,请大家帮忙看看是什么地方错了。create or replace procedure p_find_sal() is
declare
cursor c is select * from emp;
begin
for r_emp in c loop
dbms_output.put_line(r_emp.sal);
end loop;
end;报错信息:
Errors for PROCEDURE SCOTT.P_FIND_SAL:
LINE/COL ERROR
-------- ----------------------------------------------------------------------------------------------------------------
1/22 PLS-00103: 出现符号 ")"在需要下列之一时: <an identifier> <a double-quoted delimited-identifier> current
declare
cursor c is select * from emp;
begin
for r_emp in c loop
dbms_output.put_line(r_emp.sal);
end loop;
end;报错信息:
Errors for PROCEDURE SCOTT.P_FIND_SAL:
LINE/COL ERROR
-------- ----------------------------------------------------------------------------------------------------------------
1/22 PLS-00103: 出现符号 ")"在需要下列之一时: <an identifier> <a double-quoted delimited-identifier> current
过程里面不需要declarecreate or replace procedure p_find_sal is
cursor c is select * from emp;
begin
for r_emp in c loop
dbms_output.put_line(r_emp.sal);
end loop;
end p_find_sal;