Advertisement

Pro Oracle SQL pp 231-259 | Cite as

The MODEL Clause

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

Abstract

The MODEL clause introduced in Oracle Database version 10g provides an elegant method to replace the spreadsheet. With the MODEL clause, it is possible to use powerful features such as aggregation, parallelism, and multidimensional, multivariate 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 Select Product Execution Plan Product Country Model Return 
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.

Copyright information

© Karen Morton 2013

Authors and Affiliations

  • Karen Morton
    • 1
  • Kerry Osborne
    • 1
  • Robyn Sands
    • 1
  • Riyaj Shamsudeen
    • 1
  • Jared Still
    • 1
  1. 1.FLUS

Personalised recommendations