Oracle - 在游标中获取函数参数值

作者: v-star*위위
发布时间: 2024-01-04 06:19:20 (5月前)
转自：

2 条回复

0#
回复此人
关于贤的记忆 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 试试这个 </p> <pre> <code> create or replace package pk_server_control is function fn_get_employees_by_consultant(consultant_id number) return number; end; ----------------------------------------------------------------- create or replace package body pk_server_control is function fn_get_employees_by_consultant(consultant_id number) return number is val number := consultant_id; cursor employees is select c.CST_NAME, a.NO_OF_EMPLOYEES from NISHAN_LDS_ACCOUNT a join NISHAN_LDS_CONSULTANT c on c.CONSULTANT_ID = a.FK1_CONSULTANT_ID where c.CONSULTANT_ID =val; total number := 0; begin for data in employees loop total := total + data.NO_OF_EMPLOYEES; end loop; return total; end; end; begin dbms_output.put_line(pk_server_control.fn_get_employees_by_consultant(3)); end; </code> </pre> </DIV>

编辑

登录后才能参与评论