create or replace function f_getPro(type_id_value in number, activity_id_value in number) return varchar2 is
Result varchar2(10000);
begin
declare cursor c_cur is
select provice from t_bjoa_market_province where type_id = type_id_value and activity_id = activity_id_value;
begin
for v_result in c_cur loop
Result := Result||v_result.provice||',';
end loop;
end;
return(Result);
end f_getPro;
oralce function
最新推荐文章于 2022-02-25 19:38:17 发布