SUM

The Oracle and PL/SQL SUM function returns the sum of an expression.

The general format is:

SUM([DISTINCT | ALL] n)

Example 1:

SELECT SUM(price) FROM INVOICE;

returns:

4558763.4567