SQL for Analysis and Reporting | RishOraDev's Oracle Blogs

Fun with Oracle Analytics SQL #1 : PIVOTS [ PART II ]

Posted on Sep 10, 2021 by RishOraDev Leave a comment

In my previous post, I showed how to rotate rows into column using the PIVOT operation in Oracle. I pivoted a single measure and dimension. But wait! When we create a PIVOT Table in spreadsheet, we get additional aggregated columns, a. showing the total quantity of items ordered across all organizations in each quarter, and b. showing the total quantity

Home
SQL/PLSQL

Fun with Oracle Analytics SQL #1 : PIVOTS [ PART I ]

Posted on Sep 9, 2021 by RishOraDev One comment

Creating a “Pivot Table” using a spreadsheet is pretty straight forward, and it enables you to transpose rows into columns. But, can we do the same operation using Oracle SQL? Yes, it can be done, indeed. The pivot_clause of the Select statement serves this purpose. It enables us to rotate rows into columns, aggregate the data in the process of