–1/引用型变量type
declare
–说明部分
e_empno emp.empno%type;
e_ename emp.ename%type;
e_job emp.job%type;
e_mgr emp.mgr%type;
e_hiredate emp.hiredate%type;
e_sal emp.sal%type;
e_comm emp.comm%type;
e_deptno emp.deptno%type;
BEGIN
–给变量赋值
e_empno:=7902;
-把empno=7902的雇员的值赋给上述列出的变量
SELECT ename,job,mgr,hiredate,sal,comm,deptno INTO e_ename,e_job,e_mgr,e_hiredate,e_sal,e_comm,e_deptno
FROM emp
WHERE empno=e_empno;
–输出对应变量的值
dbms_output.put_line(‘employee No:’ || e_empno || 'employee Name: '|| e_ename || 'employee Position: ’ || e_job);
dbms_output.put_line('employee Manger NO: ’ || e_mgr || 'employee Hiredate: '|| e_hiredate ||'employee Salary: ’ || e_sal);
dbms_output.put_line('employee CMM: ’ || e_comm ||'employee DeptNO: ’ ||e_deptno);
END;
–2/记录型变量rowtype
declare
emp_rec emp%rowtype;
begin
–程序体
select * into emp_rec from emp where empno=7839;
dbms_output.put_line(emp_rec.ename||‘的薪水是’||emp_rec.sal);
end;