Advertisement

Pro Oracle SQL pp 251-282 | Cite as

The Model Clause

  • Karen Morton
  • Kerry Osborne
  • Robyn Sands
  • Riyaj Shamsudeen
  • Jared Still

Abstract

The Model clause introduced in the Oracle Database version l0g 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.

Keywords

Lookup Table Execution Plan Rule Evaluation Dimension Column Positional Notation 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Karen Morton, Kerry Osborne, Robyn Sands, Riyaj Shamsudeen, and Jared Still 2010

Authors and Affiliations

  • Karen Morton
  • Kerry Osborne
  • Robyn Sands
  • Riyaj Shamsudeen
  • Jared Still

There are no affiliations available

Personalised recommendations