声明一个记录类型，定义记录类型变量，保存员工信息

declare
  Type t_emp is record(deptno employees.departmentid%type,
                        fname employees.firstname%type,
                        sal employees.salary%type);
  v_emp t_emp;

begin
  select departmentid, firstname, salary
    into v_emp
    from employees
   where employeeid = 109;
  dbms_output.put_line(v_emp.deptno || ' ' || v_emp.fname || ' ' ||
                       v_emp.sal);
end;