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-31499: null value specified for required parameter string

1 Answers  


LPX-00409: incorrect token encountered while parsing

1 Answers  


PLS-00751: cannot find PACKAGE SYS_STUB_FOR_PURITY_ANALYSIS

1 Answers  


KUP-11001: files not from the same unload operation

1 Answers  


O2I-00117: Internal error: No message file for component O2U

1 Answers  






ORA-38737: Expected sequence number string doesn't match string

1 Answers  


SQL*Loader-00915: Error closing cursor: [number]

1 Answers  


ORA-25436: invalid table alias: string

1 Answers  


ORA-04092: cannot string in a trigger

1 Answers  


ORA-07482: snlmini: cannot create lock manager instance.

1 Answers  


NCR-02003: NCRF: Invalid type passed to format interpreter.

1 Answers  


ORA-01478: array bind may not include any LONG columns

1 Answers  


Categories