<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">--将方法和过程用包定义

404_2@ 404_2@ replace package pkg_emp

404_2@

查询出员工信息

404_2@ pro_findInfo(

404_2@ emp2.ename%type,
404_2@ emp2.sal%type          
修改本部门员工工资
404_2@ pro_editInfo(
404_2@ 404_2@
数据库
404_2@ pro_addInfo(
统计工资信息
404_2@ fun_sum(
404_2@ number;
404_2@ pkg_emp;
404_2@ 404_2@ replace package body pkg_emp
404_2@
查询出员工信息
404_2@ pro_findInfo(
404_2@ emp2.sal%type          
404_2@
404_2@
404_2@ ename,sal 404_2@ out_name,out_sal 404_2@ emp2 404_2@ empno = in_empno;
404_2@ pro_findInfo;
404_2@         
404_2@ emp2 404_2@ sal = in_emp_record.sal 404_2@ deptno = in_emp_record.deptno;
404_2@;
404_2@
404_2@
404_2@
404_2@
404_2@ (sql@H_404_2@%404_2@ < 1) 404_2@
404_2@;
404_2@
404_2@;
404_2@;
404_2@ 404_2@;
404_2@ pro_editInfo;
sql varchar2(200);
404_2@
sql := 404_2@;
404_2@ 404_2@ temp_sql 404_2@ 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;
404_2@;
404_2@;
统计工资信息
404_2@ fun_sum(
404_2@ number
404_2@
404_2@ num_a + num_b;
404_2@ fun_sum;
404_2@ pkg_emp;
404_2@
404_2@
404_2@;  
404_2@ * 404_2@ emp2;
404_2@
404_2@;
404_2@
404_2@ (flag = 404_2@) 404_2@
404_2@);
404_2@
404_2@);
404_2@ 404_2@;
404_2@;   
404_2@;
404_2@ pkg_emp.fun_sum(sal,nvl(comm,0)) 404_2@ sum_emp 404_2@ emp2
404_2@ empno = &员工编号;
404_2@ || sum_emp);
404_2@;