ora-00913 : 值太多
insert into collection_temp
select *
from collection t
where substr(calssno, (length(CALSSNO)), 1) not in ('1','2','3','4','5','6','7','8','9','0')
我 select *
from collection t
where substr(calssno, (length(CALSSNO)), 1) not in ('1','2','3','4','5','6','7','8','9','0')
出来只有52条记录为什么会提示值太多呢
------解决方案--------------------
两张表的列要一致，你检查一下看看