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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2013 Karen Morton
About this chapter
Cite this chapter
Morton, K., Osborne, K., Sands, R., Shamsudeen, R., Still, J. (2013). The MODEL Clause. In: Pro Oracle SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-6221-3_9
Download citation
DOI: https://doi.org/10.1007/978-1-4302-6221-3_9
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-6220-6
Online ISBN: 978-1-4302-6221-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books