ORA-02287: 此处不同意序号
insert into gls_vchitem
(viid,
yr,
km)
select gls_vchitem_seq.nextval as viid,
yr,
km
from gls_vchitem_tmp
order by km;
不能有order by 或group by
原文：http://www.cnblogs.com/yxwkf/p/5216604.html