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-22924: snapshot too old

1 Answers  


NNO-00332: warning: region store serial number reduced from number to number

1 Answers  


ORA-16014: log string sequence# string not archived, no available destinations

1 Answers  


ORA-28272: Domain policy restricts password based GLOBAL user authentication.

1 Answers  


QSM-01062: query has one or more manual partition(s)

1 Answers  






ORA-27460: cannot execute disabled job "string.string"

1 Answers  


ORA-23467: flavor lacks object "string"."string"

1 Answers  


ORA-13636: The specified value string provided for parameter string is not valid for this advisor.

1 Answers  


ORA-24166: evaluation context string.string has errors

1 Answers  


ORA-25101: duplicate REBUILD option specification

1 Answers  


ORA-14507: partition corrupt. all rows do not fall within partition bounds

1 Answers  


SQL-02104: Inconsistent host cache. No cursor cache available

1 Answers  


Categories