JDev/ADF sample - Oracle Analytic Functions for Total and Average Calculation in ADF BC

• Oracle Analytic Functions for Total and Average Calculation in ADF BC. What is great about ADF BC - this framework is very close to the DB and makes data management and analysis operations implementation really easy. There are different ways to implement total and average value calculation. The best way probably is to use Oracle DB Analytic Functions. Using analytic functions minimizes custom Java code, simplifies handling search from Query criteria of from table filter. There is no need to specify GROUP BY in SQL when using analytic functions, this makes easier ADF BC VO implementation.

Download - ADFAnalyticFuncApp.zip