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


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

RMAN-05000: CONFIGURE AUXNAME required for datafile string

1 Answers  


TNS-12696: Double Encryption Turned On, login disallowed

1 Answers  


ORA-27153: wait operation failed

1 Answers  


ORA-27002: function called with invalid device structure

1 Answers  


ORA-01681: max # extents (string) reached in LOB segment in tablespace string

1 Answers  






ORA-27486: insufficient privileges

1 Answers  


NZE-28785: parameter does not exist

1 Answers  


LSX-00211: value "~1S" whose fractional digits exceeds ~2d

1 Answers  


PLS-00363: expression 'string' cannot be used as an assignment target

1 Answers  


ORA-32301: object-relational materialized views must be primary key based

1 Answers  


SQL*Loader-00500: Unable to open file (string)

1 Answers  


ORA-00151: invalid transaction ID

1 Answers  






Categories