create or replace function aaaaaaaaaaaa(tb in varchar2) return varchar2
is
strsql varchar2(8000);
strsql2 varchar2(1000);
strsql3 varchar2(1000);
type cur_type is ref cursor;
cur_test cur_type ;
begin
strsql := null;
strsql2 := null;
-- strsql3 := 'select CONCAT(tg.wzggname,'||','||',count(*))
-- from t_rkmx tx1, t_wzgg tg
-- where tx1.wzggid = tg.wzggid and tx1.rkdid='||tb||'group by tg.wzggname ' ;
strsql3 :='select tg.wzggname||''( ''||count(*)||'') '' from t_rkmx tx1, t_wzgg tg where tx1.wzggid = tg.wzggid and tx1.rkdid = '''||tb||''''||'group by tg.wzggname';
open cur_test for strsql3 ;
loop
exit when cur_test % notfound ;
fetch cur_test into strsql2 ;
strsql := strsql || strsql2 ;
end loop;
dbms_output.put_line(strsql);
return strsql ;
end ;
is
strsql varchar2(8000);
strsql2 varchar2(1000);
strsql3 varchar2(1000);
type cur_type is ref cursor;
cur_test cur_type ;
begin
strsql := null;
strsql2 := null;
-- strsql3 := 'select CONCAT(tg.wzggname,'||','||',count(*))
-- from t_rkmx tx1, t_wzgg tg
-- where tx1.wzggid = tg.wzggid and tx1.rkdid='||tb||'group by tg.wzggname ' ;
strsql3 :='select tg.wzggname||''( ''||count(*)||'') '' from t_rkmx tx1, t_wzgg tg where tx1.wzggid = tg.wzggid and tx1.rkdid = '''||tb||''''||'group by tg.wzggname';
open cur_test for strsql3 ;
loop
exit when cur_test % notfound ;
fetch cur_test into strsql2 ;
strsql := strsql || strsql2 ;
end loop;
dbms_output.put_line(strsql);
return strsql ;
end ;