plsql PIVOT 行转列

SELECT * FROM test232323 ；

行转列

SELECT * FROM (
SELECT * FROM test232323) PIVOT (SUM(value) FOR name in(
'zhang' zhang,
'zhang12' zhang12
)) ;