declare
cursor cur is
select * from dept;
begin
for v_emp in cur loop
dbms_output.put('deptno='||v_emp.deptno);
dbms_output.put(' dname='||v_emp.dname);
dbms_output.put_line(' loc='||v_emp.loc);
end loop;
end;
cursor cur is
select * from dept;
begin
for v_emp in cur loop
dbms_output.put('deptno='||v_emp.deptno);
dbms_output.put(' dname='||v_emp.dname);
dbms_output.put_line(' loc='||v_emp.loc);
end loop;
end;