-- 参数游标
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;
Oracle 带参数游标
最新推荐文章于 2023-08-24 17:41:52 发布