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
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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00411：聚合和子查询中的值不匹配,
.原因：在一个形式为aggregate = subquery的语句中，聚合和子查询中的值数不等。例如，代码可能看起来像... WHERE（10,20,30）=（SELECT empno，deptno FROM emp WHERE ...）;,
.操作：修改聚合或子查询，以使数值匹配。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题