PLS-00396: INSERT statement's subquery yields wrong number of columns

PLS-00396: INSERT statement's subquery yields wrong number of columns
Cause: The number of columns in an INSERT statement does not match the number of columns in a subquery select list. For example, the following statement is faulty because no corresponding column is specified for col3: INSERT INTO emp (ename, empno) SELECT col1, col2, col3 FROM ...
Action: Change the number of items in the column list of the INSERT statement or the number of items in the select list so that the numbers match.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00396：INSERT语句的子查询产生错误的列数,
.原因： INSERT语句中的列数与子查询选择列表中的列数不匹配。例如，以下语句有故障，因为没有为col3指定相应的列：INSERT INTO emp（ename，empno）SELECT col1，col2，col3 FROM ...,
.操作：更改INSERT语句列表中项目的数量或选择列表中的项目数，以使数字相匹配。,
.

aiaiDBA

13718043309

010-86462881

PLS-00396: INSERT statement's subquery yields wrong number of columns

1 个回答

相似问题