如：
     ID VALUE
     1   A
     2   B
     3   C
    我要形成以下形式输出：
      A,b,c

解决办法:

scott@ORCL> select max(sys_CONNECT_BY_PATH(value,',')) from t start with id=1 connect by prior id+1=id;
    MAX(SYS_CONNECT_BY_PATH(VALUE,','))
   ---------------------------------------------------------------------------------------------------
    a,b,c

scott@ORCL> select substr(max(sys_CONNECT_BY_PATH(value,',')),2, length(max(sys_CONNECT_BY_PATH(value,',')))) from t
   start with id=1 connect by prior id+1=id;
    SUBSTR(MAX(SYS_CONNECT_BY_PATH(VALUE,',')),2,LENGTH(MAX(SYS_CONNECT_BY_PATH(VALUE,','))))
   ----------------------------------------------------------------------------------------------------
    a,b,c

ITPub博客

将某字段下的值输出成文本字符串

最新文章