Database Reference
In-Depth Information
Figure 11.19
GROUP BY and
the GROUPING
SETS Clause.
The next great leap is the SPREADSHEET clause, and a giant leap it
most certainly is! The SPREADSHEET clause is introduced in Oracle
Database 10
g
.
11.5
The SPREADSHEET (MODEL) Clause
The SPREADSHEET clause
1
can be used to create spreadsheet-style out-
put and can be extremely complex. The SPREADSHEET clause extends
the SELECT statement, allowing multidimensional array query output.
Calculations between resulting rows can be performed much like cross-tab-
bing or interdimensional data warehouse reporting. The result is a spread-
sheet or model. Let's look briefly at syntax.
