oracle RECORD 示例

DECLARE
  TYPE employee_record IS RECORD
  (
    name VARCHAR2(50),         --定义2个变量来存放employees表和departments表中的内容
    department_name varchar(20)
  );
  CURSOR emp_cur IS          --定义游标emp_cur
    SELECT name,department_name
    FROM employees e,departments d
    WHERE e.department_id=d.department_id; --选出所有员工的姓名和所在部门
BEGIN
  FOR employee_record IN emp_cur LOOP
    dbms_output.put_line(employee_record.name||' 在 '||employee_record.department_name);
                            --输出姓名和所在部门
  END LOOP;

END;

DECLARE
  name VARCHAR2(50);         --定义2个变量来存放employees表和departments表中的内容
  department_name varchar(20);
BEGIN
  SELECT name,department_name
  INTO name,department_name
  FROM employees e,departments d
  WHERE e.department_id=d.department_id and e.id=1;
  dbms_output.put_line(name||' 在 '||department_name);
END;
/