The example shows the use of Oracle Model clause to create pivot
table/report. In the example shown below, the annual data
(counts) is displayed on a quarterly basis. This is based on
SQL Modeling syntax discussed in the website
In the query below data is summarized on a quarterly basis and
split into fours quarters per the specific year (refer
The syntax shown below allows data to be pivoted on non-existant
columns Qtr1, Qtr2, Qtr3 and Qtr4.