Question

与Oracle用户定义聚合函数的问题问题，怎么解决

Answer 1

create function xx(参数)
return number as
v_n number ;
v_data number ;
begin
select no,sum(data) into v_n,v_data from table where no=参数,, group by no;
return v_data;
exception
when no_data_found then
raise_application_error(-20001, 'xxxxx');
end ;

大致这样吧！