<div id="codeSnippetWrapper"> <div style="border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; padding-left: 0px; width: 100%; padding-right: 0px; font-family: 'Courier New',courier,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px" id="codeSnippet">
<pre style="border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: white; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: 'Courier New',monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">--将方法和过程用包定义

  replace package pkg_emp

查询出员工信息

 pro_findInfo(

 emp2.ename%type,
 emp2.sal%type          
修改本部门员工工资
 pro_editInfo(
 
数据库
 pro_addInfo(
统计工资信息
 fun_sum(
 number;
 pkg_emp;
  replace package body pkg_emp

查询出员工信息
 pro_findInfo(
 emp2.sal%type          


 ename,sal  out_name,out_sal  emp2  empno = in_empno;
 pro_findInfo;
         
 emp2  sal = in_emp_record.sal  deptno = in_emp_record.deptno;
;




 (sql% < 1) 
;

;
;
 ;
 pro_editInfo;
sql varchar2(200);

sql := ;
  temp_sql  in_emp_new_record.empno,in_emp_new_record.ename,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">               in_emp_new_record.sal,in_emp_new_record.comm,in_emp_new_record.deptno;
;
;
统计工资信息
 fun_sum(
 number

 num_a + num_b;
 fun_sum;
 pkg_emp;


;  
 *  emp2;

;

 (flag = ) 
);

);
 ;
;   
;
 pkg_emp.fun_sum(sal,nvl(comm,0))  sum_emp  emp2
 empno = &员工编号;
 || sum_emp);
;