oracle´æ´¢¹ý³Ì

create or replace procedure query_sal(eno employee.employeeno%type,name out
 employee.employeename%type,salary in out employee.sal%type)
is 
  v_sal number;
begin
  select employeename ,sal into name,v_sal
  from employee
  where employeeno = eno;
  salary := salary + v_sal;
  exception
  when no_data_found then
  raise_application_error(-20000,'¸Ã¹ÍÔ±²»´æÔÚ');
end query_sal;
--Ö´Ðд洢¹ý³Ì£º
declare
  name employee.employeename%type;
  salary employee.sal%type;
begin
  query_sal('1990-003',name,salary);
  dbms_output.put_line('¹ÍÔ±£º'||name||'µÄнˮΪ:'||salary);
end;
Ö»ÄÜÊä³öname,ΪʲôµÃ²»µ½salaryµÄÖµ£¿ÇëºÃÐÄÈË°ï¸ö棬°ïÎÒ¼ì²éÏ£¡

---

hrϵÄemployees±í£¿

---

employee±í£ºsal,employeename,employeenoÈý¸öÊôÐÔÃû

---

salary := salary + v_sal;
ÔÚÕâÀïÏÈÊä³öÏÂsalary µÄÖµ

---

ÒýÓÃ

SQL code
DECLARE
NAME employee.employeename%TYPE;
--ÐèÒª¸³Ò»¸ö³õÖµ,ĬÈÏΪnull,null+ÈκÎÊý,½á¹ûΪnull
salary employee.sal%TYPE := 0;
BEGIN
query_sal('7566', NAME, salary);
dbms_output.put_line('¹ÍÔ±£º' || N¡­¡­

ΪʲôҪÏȸ³ÓèÒ»¸öÖµÄØ£¬ÎÒemployeenameû¸³ÖµÍ¬Ñù¿ÉÒÔÊä³öµ«salaryû¸³ÖµÄÜÊä³öÄØ£¡

---

nameÏ൱ÓÚÖ±½Ó¸³Öµ£¬
µ«salaryΪnull£¬µ¼ÖÂsalary + v_salҲΪnull
salary := salary + v_sal;