以scott用户登录案例库,通过游标显示相关信息
Oracle,plsql编程,关联查询,分组查询
1.关联查询
3.21
–通过游标,循环输出某个部门员工信息(员工编号、员工名字、部门名称)
--关联查询
declare
cursor p is select empno,ename,dname from emp,dept where emp.deptno=dept.deptno;
v_empno emp.empno%type;
v_ename emp.ename%type;
v_dname dept.dname%type;
begin
open p;
fetch p into v_empno,v_ename,v_dname;
while p%FOUND loop
dbms_output.