oracle查詢行轉(zhuǎn)列怎么寫(xiě)？

推薦用WM_CONCAT函數(shù) SELECT A.STD, WM_CONCAT(A.F3) NEW_RESUL FROM (SELECT STD, F3 FROM (SELECT STD, F1 F3 FROM TABLE_A UNION ALL SELECT STD, F2 F3 FROM TABLE_A) A) A GROUP BY A.STD