ERROR at line 1: ORA-00913: too many values SQL> insert into t1(id) values((select id,pid from t1)); insert into t1(id) values((select id,pid from t1)) * ERROR at line 1: ORA-00913: too many values SQL> 总结:values中放置的是一个一个的元素,而select的结果是一个集合。 insert ...
ORA-00913: too many values The INTO list contains more variables than the SELECT list.Code language: PHP (php) If the number of variables and elements in the select list are the same, but their corresponding datatypes are not compatible, Oracle cannot implicitly convert from one type to the...
sql：update b set a3=(select a3 from a where a.a1=b.b1 and a.a2=b.b2)备注：使用上边语句，不存在b表中的a表数据不会被更新。