oracle数据库账号时间查询oracle多个结果集拼接字符串

oracle多个结果集拼接字符串

Java代码  

create or replace function getStrWxr(id in varchar2) RETURN varchar2 AS  

  v_wxrname varchar2(20);  

BEGIN  

  /* 

  SELECT  csrname into v_wxrname 

  FROM workorder_dispatch inner join csr on csr.csrid = workorder_dispatch.csr_id 

  WHERE wo_id=id; 

  */  

  SELECT ltrim(max(sys_connect_by_path(csrname, ',')), ',')  

    into v_wxrname  

    from (select csrname, rownum t  

            FROM workorder_dispatch  

           inner join csr on csr.csrid = workorder_dispatch.csr_id  

        &nboracle账号sp;  WHERE wo_id = id)  

  connect by prior t = t – 1  

   start with t = 1;  

  RETURN(v_wxrname);  

END getStrWxr;