<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;
;
(% < 1)
;
;
;
;
pro_editInfo;
;
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);
;
(编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|