14Dec
migrating oracle apex pivot
By: Monty Latiolais On: December 14, 2016 In: Oracle APEX Comments: 0

From time to time we need to pivot data for presentation purposes. It’s not something I do everyday, so the syntax is usually something I have to pull from the old toolbox as needed. With Oracle APEX 5.0, you can now pivot data within an interactive report and it’s quite easy.

Let’s say we’ve got a table of Super Bowl quarterbacks and their pass attempts per quarter.

oracle apex pivot data

…but we really would like the data displayed where we can compare the quarterbacks side by side…a textbook pivot. To accomplish this, go to Actions / Format / Pivot. There you see a dialog box that requests the pivot column, the row columns and the data to be included in the grid. The “Sum” checkbox does exactly that…totals the columns.

oracle apex pivot data columns

…resulting in the following output.

Obviously you should season to taste, but there you have it! Your data instantly pivoted courtesy of APEX 5.0
If you have data presentation requirements you just can’t crack, please contact me for a free consultation. Making the call could be, well…PIVOTAL.

Contact Us

Leave reply:

Your email address will not be published. Required fields are marked *