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

LFI-00136: Unable to change type of open file.

1 Answers  


ORA-02073: sequence numbers not supported in remote updates

1 Answers  


ORA-30115: error when processing an environment variable

1 Answers  


ORA-01611: thread number string is invalid - must be between 1 and string

1 Answers  


ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_3970712838_6793 by 128 in tablespace SYSAUX? What is the solution for this issue?

2 Answers   Oracle,


ORA-00084: global area must be PGA, SGA, or UGA

1 Answers  


ORA-19622: archivelog thread string sequence string not restored due to string

1 Answers  


ORA-21526: initialization failed

1 Answers  


ORA-12013: updatable materialized views must be simple enough to do fast refresh

1 Answers  


ORA-34179: (MXCHGDCL20) workspace object is not a PARTITION TEMPLATE.

1 Answers  


ORA-19731: cannot apply change to unverified plugged-in datafile string

1 Answers  


ORA-06537: OUT bind variable bound to an IN position

1 Answers  


Categories