Alex Nuijten:
Analytic Functions Revisited
Make your life easier
Even though Oracle has enriched SQL with Analytic Functions a long time ago, they are still relatively unknown. Analytic Functions add inter-row calculations, aggregates over multiple dimensions, or rank assignment based on values within a group of values - all without a GROUP BY clause. They can make your life as a developer a lot easier once you get Analytic Functions in your fingertips. Even though the syntax may seem daunting at first, it becomes second nature very quickly. Oracle 11gR2 brings you new and exciting Analytic Functions.
This presentation will cover the syntax and is packed with real life examples of how to apply them on a daily basis. See the performance increase with just a few lines of code and bring you sheer development joy.
Alex Nuijten is Oracle consultant bij AMIS Services. Daarnaast verzorgt hij trainingen op het gebied van SQL en PL/SQL. Alex schrijft regelmatig artikelen voor Optimize en hij blogt op het Technology Blog van AMIS en op zijn eigen blog. Hij geeft regelmatig presentaties op nationale en internationale conferenties.
