给出ORA-00936

Question

我试图插入到一个表中，该表的值是相同的，只有少数是从同一个表中根据ID使用最大sequnce号的。

insert into ENT_ROLE_USERS_HISTORY(APP_ID,ROLE_ID,TAXID,CREATE_DT,CREATED_BY,STATUS,HIST_ID,ADD_DELETE) 
values(
select app_id, role_id, taxid, sysdate, 1233423123, 0, ent_role_us_hist_seq.nextval, 0 from (
select app_id, role_id, taxid from ENT_ROLE_USERS_HISTORY where app_id = 203 and TAXID = 13242342346 order by hist_id desc) where rownum = 1);

我执行内部select，它运行良好，并给我记录，但查询失败的插入。我得到了ORA-00936:缺少表达式。有人能让我知道出了什么问题吗?或者有没有其他最好的方法来做同样的事情？

Answer 1

insert into ENT_ROLE_USERS_HISTORY(APP_ID,ROLE_ID,TAXID,CREATE_DT,CREATED_BY,STATUS,HIST_ID,ADD_DELETE) 
select app_id, role_id, taxid, sysdate, 1233423123, 0, ent_role_us_hist_seq.nextval, 0 from 
 (
     select app_id, role_id, taxid from ENT_ROLE_USERS_HISTORY 
        where app_id = 203 and TAXID = 13242342346 order by hist_id desc
  ) where rownum = 1