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;