pl/sql函数结果拼接

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 ;