create or replace procedure p2(v_deptno number) is
v_emp emp%rowtype;--%ROWTYPE用来声明一个和表中记录一样的record
my_cursor sys_refcursor;
begin
open my_cursor for select * from emp where deptno=v_deptno;
loop
fetch my_cursor into v_emp;
exit when my_cursor%notfound;
dbms_output.put_line(v_emp.ename);
end loop;
close my_cursor;
end;
call p2(10)
Oracle
最新推荐文章于 2024-05-31 10:15:00 发布