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-09241: smsalo: error allocating SGA memory

1 Answers  


ORA-00071: process number must be between 1 and string

1 Answers  


ORA-32320: REFRESH FAST of "string"."string" unsupported after container table PMOPs

2 Answers  


ORA-25191: cannot reference overflow table of an index-organized table

1 Answers  


TNS-00077: the argument field

1 Answers  






ORA-00353: log corruption near block string change string time string

1 Answers  


NZE-29014: Maximum fragment length extension is incorrect.

1 Answers  


ORA-22914: DROP of nested tables not supported

1 Answers  


TNS-00040: INTCTL: failed to initialize trace context- Continuing anyway

1 Answers  


PCC-02354: A file included with #include may not contain SQL statements

1 Answers  


KUP-03011: OCI error getting database column size.

1 Answers  


ORA-12059: prebuilt table "string"."string" does not exist

1 Answers  


Categories