ORA-00918: column ambiguously defined-优快云博客

本文介绍了一个关于Oracle SQL的ORA-00918错误：字段定义不明确的问题及其解决方法。该问题源于Java实体映射时两个不同属性映射到了同一个SQL字段上。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ORA-00918: column ambiguously defined

今天遇到了一个Oracle的SQL问题：ORA-00918: column ambiguously defined

大致的意思就是字段名称不明确，可能存在同名的字段

 
    SELECT *  
   FROM (SELECT ROW_.*, ROWNUM ROWNUM_  
           FROM (SELECT ACCEPT_DEPT_NAME,  
                        ACCEPT_NO,  
                        ACCEPT_TIME,  
                        FINISH_TIME,  
                        RECENT_OPINION,  
                        ACCEPT_USER_NAME,  
                        APPLY_USER_ID,  
                        FIRST_SUBMIT_TIME,  
                        INFOFLOW_ID,  
                        ACCEPT_DEPT_ID,  
                        BIZ_STATE,  
                        IS_SUPPLY,  
                        IS_SUBMIT,  
                        INFOFLOW_NAME,  
                        SERIAL_NO,  
                        APPLY_TYPE,  
                        APPLY_USER_NAME,  
                        INFOFLOW_TYPE_NAME,  
                        AREA_CODE,  
                        APPLY_SUBJECT_NAME,  
                        FINISH_TYPE,  
                        ACCEPT_ORGAN_INAME,  
                        IS_RESUBMIT,  
                        APPLY_NO,  
                        INFOFLOW_TYPE_ID,  
                        IS_SUBMIT,  
                        ACCEPT_USER_ID,  
                        ACCEPT_ORGAN_ID,  
                        RECENT_SAVETIME,  
                        RECENT_RESULT,  
                        AREA_NAME  
                   FROM DSPC_APPLY_BASE  
                  WHERE 1 = 1  
                    and IS_SUBMIT = '0'  
                    and APPLY_USER_ID = 'ADMIN') ROW_  
          WHERE ROWNUM <= 10)  
  WHERE ROWNUM_ > 0  
 
  