这是我第一次实践中使用游标,呵呵,在plsql里面run成功了!代码如下:declare var_ename emp.ename%type; var_sal emp.sal%type; var_dname dept.dname%type; cursor emp_cursor is select emp.ename,emp.sal,dept.dname from emp,dept where emp.deptno=dept.deptno; emp_record emp_cursor%rowtype; begin open emp_cursor; loop fetch emp_cursor into var_ename,var_sal,var_dname; exit when emp_cursor%notfound; dbms_output.put_line('员工姓名:'||var_ename); dbms_output.put_line('员工工资:'||var_sal); dbms_output.put_line('部门门称:'||var_dname); end loop; close emp_cursor; end; /
只要不是隐示的,都是显示的..
var_ename emp.ename%type;
var_sal emp.sal%type;
var_dname dept.dname%type;
cursor emp_cursor
is select emp.ename,emp.sal,dept.dname from emp,dept where emp.deptno=dept.deptno;
emp_record emp_cursor%rowtype;
begin
open emp_cursor;
loop
fetch emp_cursor into var_ename,var_sal,var_dname;
exit when emp_cursor%notfound;
dbms_output.put_line('员工姓名:'||var_ename);
dbms_output.put_line('员工工资:'||var_sal);
dbms_output.put_line('部门门称:'||var_dname);
end loop;
close emp_cursor;
end;
/