暂无图片

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

错误码

错误描述:INSERT statement's subquery yields wrong number of columns
错误原因: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 ...
解决方法:Change the column list of the INSERT or subquery so they are the same length. 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.

向认证技术专家提问

向技术专家提问

相关搜索
查看更多》