There are APEX dictionary views for most of the data that represents the 'source' that is your APEX application meta-data. Note:  ...

A couple of years ago I posted a method to remove nulls from a report using the Value Attribute Paris - Column template. Here's an e...

I came across the need for an UNPIVOT today that require fairly basic syntax, so this is me noting it for later. A single column unpivot, no...

In looking for information on pivoting variable number of columns, I stumbled across a question I once managed to AskTom, many moons ago. h...

A couple of years ago I posted a simple example using PIVOT , converting rows to columns with the classic example of figures by months. Or...

It seems a very common question in APEX is how do you highlight the background of cells within reports? There is a heap of information out...

Today I found that SQL analytics go hand in hand with PIVOT statements. I had percentage data pivoted by a certain column, but I needed to...

A common requirement for queries is to turn rows into columns, or the other way around. In Excel, we can do this using TRANSPOSE, a bit of...

Spotted in the 11.1 Oracle documentation  ... Much improved in 11.2  :-) Ever found something similar in your own code?