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-11621: URL store: socket open error for string

1 Answers  


ORA-16136: Managed Standby Recovery not active

2 Answers  


KUP-04025: field extends beyond end of record

1 Answers  


DGM-16934: You must start instance "string" manually.

1 Answers  


ORA-01246: recovering files through TSPITR of tablespace string

1 Answers  






ORA-14051: invalid ALTER MATERIALIZED VIEW option

1 Answers  


ORA-29398: invalid privilege name specified

1 Answers  


TNS-00263: Navigator: Request Failed

1 Answers  


RMAN-07501: searching for all files in the recovery area

1 Answers  


NNL-00898: Responses sent: number

1 Answers  


PLS-00101: reserved for future use

1 Answers  


ORA-09923: Can't spawn process - user log directory not created properly

1 Answers  


Categories