orelce wm_concat (函数)列合并,行列转换

 在Orelce10g中,可以用wm_concat(column) 进行列合并,行列转换.

示例:

SELECT WM_CONCAT(SYSDATE) 
  FROM (SELECT SYSDATE FROM DUAL 
        UNION ALL 
        SELECT SYSDATE FROM DUAL 
        UNION ALL 
        SELECT SYSDATE FROM DUAL);