Oracle sum() Function

The Oracle sum() function returns the total summed value of a numeric field. It is used when you need to addition the numeric fields value.

Oracle SUM FUNCTION Syntax

To count or calculate number of rows in a table, use the following syntax:

SELECT SUM(col1) 
FROM tablename
WHERE condition;

Parameters:

tablename: The table name from which you want to fetch records.

col1: The column or field name that will be summed. It will summed the numeric field values.

The following Oracle, adding the numeric field "workingHours" in the "tblCustomerLoan" table:

SELECT SUM(workingHours) AS TotalHover FROM tblCustomerLoan;