declare
cursor cura is
SELECT emp_name,sal FROM emp ;
begin
--open cura;
FOR curr IN cura
LOOP
dbms_output.put_line(curr.emp_name||curr.sal);
end loop;
--close cura;
end;
...全文
6386打赏收藏
弱弱的的问一个游标的问题
这个块中为什么不需要打开游标呢?? declare cursor cura is SELECT emp_name,sal FROM emp ; begin --open cura; FOR curr IN cura LOOP dbms_output.put_line(curr.emp_name||curr.sal); end loop; --close cura; end;