SQL> insert into t1(id ,pid) values((select id,pid from t1)); insert into t1(id ,pid) values((select id,pid from t1)) * ERROR at line 1: ORA-00947: not enough values -- 以下两种情况都失败了 SQL> insert into t1(id ,pid) values((select id,pid from t1),3); insert into t1...
错误1:ORA-00947: not enough values 原因:INSERT INTO语句中列的数量与SELECT语句中返回的列的数量不匹配。 解决方案:确保INSERT INTO语句中列的数量与SELECT语句中返回的列的数量完全匹配。 错误2:ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE"."COLUMN") 原因:尝试将NULL值插入到非空约束的列中...
SQL> insert into status (select tcn, 'CO', '12-JUL-05','16:51' from 2 i2p_tcn where pickup_record_nbr like 'M800%'); insert into status (select tcn, 'CO', '12-JUL-05','16:51' from * ERROR at line 1: ORA-00947: not enough values ...