Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PLS-00604: aggregate function is not allowed here



PLS-00604: aggregate function is not allowed here..

Answer / guest

Cause: One of the functions, such as AVG, COUNT, MAX, MIN,
SUM, STDDEV or VARIANCE, was used in a WHERE or GROUP BY clause

Action: Remove the group function from the WHERE or GROUP BY
clause. The desired result may be achieved by including the
function in a subquery or HAVING clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02347: cannot grant privileges on columns of an object table

1 Answers  


ORA-32506: expecting one of string, string, or string but found string

1 Answers  


ORA-36906: (XSAGDNGL45) 4. Model only includes one non-step dimension in the equations.

1 Answers  


ORA-01649: operation not allowed with a backup controlfile

1 Answers  


RMAN-06019: could not translate tablespace name "string"

1 Answers  






ORA-29524: wrong types of arguments in call to 'string'

1 Answers  


PLS-00639: NCHAR/NVARCHAR2 cannot be byte length semantics

1 Answers  


TNS-01026: Start Date string

1 Answers  


ORA-01511: error in renaming log/data files

1 Answers  


ORA-22972: NULL value not allowed in PRIMARY KEY-based object identifier

1 Answers  


ORA-01258: unable to delete temporary file string

1 Answers  


ORA-25114: invalid file number specified in the DUMP DATAFILE/TEMPFILE command

1 Answers  


Categories