官方文档挺详细的,在新功能那里有介绍到:http://www.oracle-developer.net/display.php?id=506
PIVOT的语法:https://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_10002.htm#SQLRF01702