Chapter 13. Advanced Analytic SQL

For years, SQL has been criticized for its inability to handle routine decision support queries. With the host of new analytic functions introduced in Oracle8i and Oracle9i, Oracle has taken giant strides towards eliminating this deficiency. In doing so, Oracle has further blurred the distinction between its multipurpose relational database server and other, special-purpose data warehouse and statistical analysis servers.