在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);
在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);