Best Tutorials website


Analytic Functions in Oracle 8i and 9i

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: 1398 | Rating star | by Jason




View this tutorial
Broken link Report broken link?