Oracle pivot函数支持哪些数据类型

Oracle的pivot函数支持以下数据类型：

CHARNCHARVARCHAR2NVARCHAR2CLOBNCLOBBLOBBFILELONGRAWLONG RAWROWIDDATETIMESTAMPTIMESTAMP WITH TIME ZONETIMESTAMP WITH LOCAL TIME ZONEINTERVAL YEAR TO MONTHINTERVAL DAY TO SECONDNUMBERBINARY_FLOATBINARY_DOUBLEXMLTYPE