oracle type 数据类型

–使用标量变量接受数据类型

declare
v_empname emp.empname%type;
v_sal emp.sal%type;
begin
select empname,sal into v_empname,V_sal from emp where empno = &no;
dbms_output.put_line (‘员工姓名:’ || v_empname);
dbms_output.put_line (‘员工薪水:’ || v_sal);

end;

–使用记录变量接收数据
declare
type mytype is record
(
v_empname varchar2(20),
v_sal varchar2(20)
) ;
real_record mytype;
begin
select empname,sal into real_record from emp where empno = &no;
dbms_output.put_line (‘员工姓名:’ || real_record.v_empname);
dbms_output.put_line (‘员工薪水:’ ||real_record.v_sal);
end;

–完全参找一个表来接收数据类型
declare
v_row emp%rowtype;
begin
select * into v_row from emp where empno = &no;
dbms_output.put_line (‘员工姓名:’ || v_row.empname);
dbms_output.put_line (‘员工薪水:’ ||v_row.sal);
end;