AVG function in Oracle Syntax Archives

AVG function in Oracle

January 2, 2024July 19, 2019 by Alex Martin

AVG is one of the vital Numeric/Math functions of Oracle. It is used to get the average value of an expression. The AVG function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, and Oracle 8i. Syntax: To calculate the simple average. SELECT AVG (aggregate_expression) FROM … Read more