PLS-00319: subquery in an IN or NOT IN clause must contain exactly one column

PLS-00319: subquery in an IN or NOT IN clause must contain exactly one column
Cause: An invalid expression such as X IN (SELECT A,B ...) was used. When a [NOT]IN clause is used with a subquery, it does not test for set membership. The number of expressions in the [NOT]IN clause and the subquery select list must match. So, in the example above, the subquery must specify at most one column.
Action: Change the subquery to select only one column.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00319：IN或NOT IN子句中的子查询必须只包含一列,
.原因：使用无效的表达式，例如X IN（SELECT A，B ...）。当[NOT] IN子句与子查询一起使用时，它不会对set成员进行测试。[NOT] IN子句和子查询选择列表中的表达式数必须匹配。因此，在上面的示例中，子查询最多必须指定一列。,
.操作：更改子查询以仅选择一列。,
.

aiaiDBA

13718043309

010-86462881

PLS-00319: subquery in an IN or NOT IN clause must contain exactly one column

1 个回答

相似问题