PLS-00411: Number of values in aggregate and in subquery
don't match



PLS-00411: Number of values in aggregate and in subquery don't match..

Answer / guest

Cause: In a statement of the form aggregate = subquery, the
numbers of values in the aggregate and subquery are unequal.
For example, the code might look like ... WHERE (10,20,30) =
(SELECT empno,deptno FROM emp WHERE...);

Action: Revise the aggregate or subquery so that the numbers
of values match.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-51028: unexpected error in fuzzy match expansion: %(1)

1 Answers  


ORA-22275: invalid LOB locator specified

1 Answers  


QSM-01090: no query rewrite after view merging

1 Answers  


QSM-01094: outer-join filter not found in materialized join view

1 Answers  


ORA-27144: attempt to kill process failed

1 Answers  


ORA-38306: this object is not recoverable standalone

1 Answers  


ORA-06737: TLI Driver: connection failed

1 Answers  


ORA-06403: Unable to allocate memory.

1 Answers  


ORA-24156: duplicate table alias string

1 Answers  


ORA-09983: skxfidsht: Error shutting down SDI channel

1 Answers  


QSM-02096: mv references a named view

1 Answers  


ORA-16005: database requires recovery

1 Answers  


Categories