The average in SQL Oracle function is an aggregate and analytic function taking an average of a set of numeric value lists.