kavya.jain kavya.jain - 1 year ago 137
SQL Question

Oracle math functions

I am trying to get a rounded value in Oracle (using SQL Developer) through following statement:

ROUND((1-POWER((SUM(D.PFY/100*E.OUT_8_)/SUM(E,OUT_8_)), (1/(SUM(PHOTO*E.OUT_8_)/SUM(E.OUT_8_)))))*1000000, 0) AS PFYPPM

However, I am getting an error as:

invalid number of arguments.

What is it that I am doing wrong?

Answer Source

Sometimes Oracle error messages are actually helpful.

invalid number of arguments

Check your function calls.

sum() takes only one argument.


should probably be