Oracle 11g: Cross-tab report using PIVOT and UNPIVOT operator

Microsoft introduced the PIVOT and UNPIVOT operator in SQL Server 2005 to generate cross tab reports i.e. to convert rows into columns and columns into rows. You can read more on that in our whitepaper. We have also covered the traditional way of pivoting the data for prior version of SQL Server and

Read More - Register for Free Membership