PLS-00326: IN clause must contain same number of expressions as subquery

PLS-00326: IN clause must contain same number of expressions as subquery
Cause: The number of expressions in an IN clause did not equal the number of expressions in a corresponding subquery select list. For example, the following statement is invalid because the IN clause contains two expressions, but the subquery select list contains just one: ... WHERE (ename, sal) IN (SELECT sal FROM emp);
Action: Check the number of expressions in each set, then revise the statement to make the numbers equal.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00326：IN子句必须包含与子查询相同数量的表达式,
.原因： IN子句中的表达式数不等于相应子查询选择列表中的表达式数。例如，以下语句无效，因为IN子句包含两个表达式，但子查询选择列表只包含一个：... WHERE（ename，sal）IN（SELECT sal FROM emp）;,
.操作：检查每个集合中的表达式数，然后修改语句以使数字相等。,
.

aiaiDBA

13718043309

010-86462881

PLS-00326: IN clause must contain same number of expressions as subquery

1 个回答

相似问题