How To Use Oracle Analytic Functions
This tutorial will show you how to use Oracle’s Analytic Function extensions to SQL to produce efficient solutions to complex analysis of data.
SQL is a language that allows you to perform queries to answer a wide range of questions about your data. While standard SQL is quite powerful, there are many questions that it cannot answer at all or that it can only answer with complex and inefficient SQL workarounds. Questions about running totals, percent of total, and ranking within a group fall into this area. Also, more complex issues such as Top-N within a group and aggregates over a range also fall in this arena.
These questions can be easily answered via SQL statements that incorporate Analytic Functions.
Date: Apr 27, 2011
NOTE: Some corporate firewalls will not allow videos hosted by YouTube.