oracle 包中定义全局变量
发布网友
发布时间:2022-04-20 07:23
我来回答
共3个回答
热心网友
时间:2022-04-09 09:55
这得用游标了,每次得出来后相加就行了,或者你说的是||,自己找下关于游标的例子吧 .
function fun_test(para number,type number)return varchar2
is
--客户名称游标
cursor cur_fac is select 字段 from table where xx;
quantity
temp1
temp2
begin
--打开客户名称游标,逐一对每个客户进行数据统计
open cur_fac
loop
fetch cur_fac into temp1;
exit when cur_fac r%NOTFOUND;
selete xx into temp2 from table
where temp1=xx;
quantity := quantity + temp2;
end loop;
close cust_name_cursor;
return quantity ;
exception
null;
end
热心网友
时间:2022-04-09 11:13
--package
create or replace package p_name as
function f_name(v1 in out number) return number;
procere p_name(v1 in out number);
end p_name;
--package body
create or replace package body p_name is
function f_name(v1 in out number) return number is
v2 number;
begin
return v2;
end;
--function
create or replace function f_name(v1 in out number) return number is
v2 number;
begin
v2 := v1; return v2;
end;
几种写法都给你 你自己参考了写吧。。。
热心网友
时间:2022-04-09 12:48
function fun_test(para number,type number)return varchar2
is
quantity number(15,2):=0;
temp number(15,2):=0;
begin
if type = 1
then
selete sum(1) into temp from table
where 条件;
quantity:=quantity+temp;
dbms_output.put_line(temp);
return quantity
end if;
end;