Chapter 9. The Model Clause
The Model clause introduced in the Oracle Database version 10g provides an elegant method to replace the spreadsheet. With the Model clause, it is possible to utilize powerful features such as aggregation, parallelism, and multi-dimensional, multi-variate analysis in SQL statements. If you enjoy working with Excel spreadsheets to calculate formulas, you will enjoy working with the Model clause, too.
In situations where the amount of data to be processed is small, the inter-row referencing and calculating power of the spreadsheet is sufficient to accomplish the task at hand. However, scalability of such a spreadsheet as a data warehouse application is limited and cumbersome. For example, spreadsheets are ...