Oracle 带参数游标

-- 参数游标declarecursor mycur(dno number) is select empno,ename,job,deptno from emp where deptno=dno;beginfor record in mycur(10) loopdbms_output.put_line('员工编号：'||record.empno||' 员工名称：'||r...

Dark丶照萤映雪

1072人浏览 · 2018-03-19 23:34:58

Dark丶照萤映雪 · 2018-03-19 23:34:58 发布

-- 参数游标
declare
   cursor mycur(dno number) is select empno,ename,job,deptno from emp where deptno=dno;
begin
  for record in mycur(10) loop
    dbms_output.put_line('员工编号：'||record.empno||' 员工名称：'||record.ename||' 员工职位：'||record.job||' 员工部门：'||record.deptno);
  end loop;
end;

-- 从窗口输入值
declare
   cursor mycur(dno number) is select empno,ename,job,deptno from emp where deptno=dno;
begin
  for record in mycur(&no) loop
    dbms_output.put_line(' 员工编号：'||record.empno||' 员工名称：'||record.ename||' 员工职位：'||record.job||' 员工部门：'||record.deptno);
  end loop;
end;