oracle第四章循环分支语句练习

--1.使用记录变量的方式插入部门一条记录；
select * from dept;
declare
v_dept dept%rowtype;
begin
  v_dept.deptno := 99;
  v_dept.dname := 'hanhan';
  v_dept.loc := 'pipi';
  insert into dept values (v_dept.deptno,v_dept.dname,v_dept.loc);
end;
--2.使用for循环查询出各个部门工资最高的雇员信息的名称；
--第一种
select e.*,d.dname from emp e,dept d where e.deptno=d.deptno and (e.deptno,e.sal) in (select deptno,max(sal) from emp group by deptno);
declare
type mvps is record(
 ename emp.ename%type,
 sal emp.sal%type,
 dname dept.dname%type
);
mvp mvps;
begin
  for mvp in (select e.*,d.dname from emp e,dept d where e.deptno=d.deptno and (e.deptno,e.sal) in (select deptno,max(sal) from emp group by deptno))
    loop 
      dbms_output.put_line('姓名：'