Oracle-行结构转化为列结构

转换前：

转换后：

 SQL语句：

SELECT JX,ZPX,NUM
FROM TABLE
UNPIVOT
     (NUM
     FOR zpx
     IN (A AS 1,B AS 2,C AS 3))
ORDER BY JX, ZPX;