Analytic Functions in Oracle 8i and 9i

Analytic Functions, which have been available since Oracle 8.1.6, are designed to address such problems as 'Calculate a running total', 'Find percentages within a group', 'Top-N queries', 'Compute a moving average' and many more. Most of these problems can be solved using standard PL/SQL, however the performance is often not what it should be. Analytic Functions add extensions to the SQL language that not only make these operations easier to code; they make them faster than could be achieved with pure SQL or PL/SQL.

Views: 1514 | | by Jason

Report broken link?