oracle RECORD 示例

来源：互联网发布：linux 物理内存大小编辑：程序博客网时间：2024/04/28 04:01

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;
/

0 0