Another example of Pivot
In this example, a large table is summarized as a Pivot table:
- the Grouping Column is OWNER
- the Pivot Column is TABLESPACE_NAME
- there is no Analysis column. The cells in the Pivot tables give the number of rows with the given OWNER / TABLESPACE_NAME combination. For instance, the first line shows that there are 3 rows with an OWNER of 'COMP' and TABLESPACE_NAME of 'Example'