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'