Oracle 脚本- UNPIVOT 多列转多行

#行转列# #Oracle# #多列转多行#
 SELECT VENDORID,ORDERS,ORDERSNAME
  FROM  
     ( SELECT  VENDORID, EMP1, EMP2,VENDORANAME
      FROM  EMP) P
  UNPIVOT
     ((ORDERS,ORDERSNAME ) FOR  EMPLOYEE  IN ( 
        (EMP1, VENDORANAME) AS 1,(EMP2,VENDORANAME) AS 2
  ));