首页 > 代码库 > ORA-02287: 此处不允许序号

ORA-02287: 此处不允许序号

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