欢迎投稿

今日深度:

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

www.htsjk.Com true http://www.htsjk.com/shujukunews/1774.html NewsArticle 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...
评论暂时关闭