Chapter 9. Analytical Processing with SQL
Oracle has enhanced its ability to develop business intelligence. It has placed a variety of analytical functions in its database. These functions became available with the release of Oracle 8.1.6. The functions allow the business analyst to perform rankings, moving window calculations (i.e., moving averages), and lag/lead analysis. Oracle has also included families of statistic and regression functions in the database. These functions are part of the core SQL processing. Previous to this release, these functions could be obtained only through the use of purchased software. Incorporating these capabilities allows Oracle to enhance scalability, database performance, and simplicity.
Analytic functions ...
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
