Oracle PIVOT，两次？

Oracle PIVOT，两次？

从oracle-developer.net看来，它可以像这样完成：

SELECt somethingId, splitId1, splitName1, splitId2, splitName2FROM (SELECt somethingId, splitId      FROM SOMETHING JOIN SPLIT ON ... )      PIVOT ( MAX(splitId)  ,   MAX(splitName)    FOR displayOrder IN (1 AS splitName1, 2 as splitName2) )