PLS-00517: Type mismatch between a select list element 'string' and corresponding table column in INSERT statement with a subquery

PLS-00517: Type mismatch between a select list element 'string' and corresponding table column in INSERT statement with a subquery
Cause: In an INSERT statement with subquery, at lease one of the elements of the select list was not type-compatible with the corresponding column of the table in the INTO clause. This error indicates that the subquery should be rewritten to match the structure of the target table.
Action: None

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00517：INSERT语句中的select list元素' string '与相应表列之间的类型不匹配，并带有子查询,
.原因：在具有子查询的INSERT语句中，选择列表的至少一个元素与INTO子句中的表的相应列不兼容。该错误表示子查询应该被重写以匹配目标表的结构。,
.行动：无,
.

aiaiDBA

13718043309

010-86462881

PLS-00517: Type mismatch between a select list element 'string' and corresponding table column in INSERT statement with a subquery

1 个回答

相似问题