PL/SQL5分钟学习总结之一

1，%type 声明字段匹配类型

declare
v_ename emp.ename%type;

begin
select ename into v_ename from emp where empno=7369;
dbms_output.put_line(v_ename);
end;

2，%rowtype 声明一行记录匹配类型

declare
v_emp emp%rowtype;

begin
select * into v_emp from emp where empno=7369;
dbms_output.put_line(v_emp.sal);
end;

3，record 复合结构

declare
type v_emp_record is record (
v_ename emp.ename%type,
v_deptno emp.deptno%type
);

emp_record v_emp_record;

begin
select ename,deptno into emp_record from emp where empno=7369;
dbms_output.put_line(emp_record.v_ename);
end;