Oracle»¥»»×ܽá

Oracle»¥»»×ܽá
1. ¶àÐл»³ÉÒ»ÐÐ
    col1  col2            col1  col2
    a       1
    a       2     ת»»ºó   a     1,2,3
    a       3
   A.
sys_connect_by_path
º¯Êý
        SELECT NAME, ltrim(MAX(sys_connect_by_path(userid, ',')), ',') userid
 
from(SELECT NAME, userid,row_number() over(PARTITION BY NAME ORDER BY userid) rn  from test)  START WITH rn = 1 CONNECT BY rn - 1 = PRIOR rn AND NAME = PRIOR NAME GROUP BY NAME ORDER BY NAME;
    B.wmsys.WM_CONCATº¯Êý
       select  NAME,wmsys.WM_CONCAT(userid)  from xj_class group by  NAME;
2. Ò»Ð뻶àÐÐ
       col                                   col
       1,2,3       ת»»ºó               1
                                               2
                                               3
   
       select substr(subjec