wmsys.wm_concat 战绩！2018年1月10日15:37:52-优快云博客

本文介绍了解决Struts框架中使用Oracle数据库进行分页查询时遇到的ORA-00923:未找到要求的FROM关键字错误的方法。通过调整wm_concat函数的应用位置，实现了正确的分页查询。

126455 [http-8080-6] INFO   -   
    select * from  (
    select axxx.* , rownum DB_ROW_NUM from ( select 
           t6.REQUISITION_NUM,t6.TEAM,t6.OPS_BASE_ID,t7.UPDATE_DATE,
           t9.BOOK_NAME,t9.BOOK_TYPE,t10.CAR_ID,
           wmsys.wm_concat(to_char(t8.FILE_NAME)) as FILE_NAME,
           wmsys.wm_concat(to_char(t8.FILE_PATH)) as FILE_PATH 
           from  BASEINFO_RECORD t6
           left join        
                (select t2.TEAM_ID ,t2.CAR_ID, t4.BOOK_ID
                from (select t1.CAR_NUM , t1.FILE_NAME from DB_CARFILEINDEX t1 where t1.FILE_TYPE = '3') t3
                left join DB_CARINFO t2 on t2.CAR_ID = t3.CAR_NUM
                left join COM_BASE_BOOK t4 on t4.BOOK_ID=t2.BOOK_ID) t5
            on   t5.TEAM_ID = t6.TEAM
            and  t5.BOOK_ID = t6.BOOK_ID
            and  t6.TASK_STATUS = 'C0001000500002'
            left join DATA_SUBMIT  t7 on t7.OPS_BASE_ID = t6.OPS_BASE_ID
            left join COM_FILE_INDEX       t8 on t8.ORG_ID = t7.FILE_NAME
            left join COM_BASE_BOOK        t9 on t9.BOOK_ID = t6.BOOK_ID
            left join DB_CARINFO   t10 on t10.BOOK_ID = t6.BOOK_ID
            where 1=1
            group by t6.REQUISITION_NUM,t6.TEAM,t6.OPS_BASE_ID,t7.UPDATE_DATE,
            t9.BOOK_NAME,t9.BOOK_TYPE,t10.CAR_ID
            order by car_id asc,update_date asc
            ) axxx    where rownum < 16 ) orpr where orpr.DB_ROW_NUM >= 1

Struts中OracleQueryByPageHelper 或 "ORA-00923: 未找到要求的 FROM关键字" 的解决方案，把wm_concat函数用在子查询中：

29715 [http-8080-7] INFO   -  
　　 select * from  (
　　　　select axxx.* , rownum DB_ROW_NUM from (
　　　　　　select
           t6.REQUISITION_NUM,t6.TEAM,t6.OPS_BASE_ID,t7.UPDATE_DATE,
           t9.BOOK_NAME,t9.BOOK_TYPE,t10.CAR_ID,
             t8.FILE_NAME,t8.FILE_PATH
           from  BASEINFO_RECORD t6
           left join        
                (select t2.TEAM_ID ,t2.CAR_ID, t4.BOOK_ID
                from 
                    (select t1.CAR_NUM , t1.FILE_NAME from DB_CARFILEINDEX t1 where t1.FILE_TYPE = '3') t3
                left join DB_CARINFO t2 on t2.CAR_ID = t3.CAR_NUM
                left join COM_BASE_BOOK t4 on t4.BOOK_ID=t2.BOOK_ID) t5
            on   t5.TEAM_ID = t6.TEAM
            and  t5.BOOK_ID = t6.BOOK_ID
            and  t6.TASK_STATUS = 'C0001000500002'
            left join DATA_SUBMIT  t7 on t7.OPS_BASE_ID = t6.OPS_BASE_ID
            left join COM_BASE_BOOK        t9 on t9.BOOK_ID = t6.BOOK_ID
            left join DB_CARINFO   t10 on t10.BOOK_ID = t6.BOOK_ID
            left join 
                (select wmsys.wm_concat(to_char(FILE_NAME)) as FILE_NAME,
                wmsys.wm_concat(to_char(FILE_PATH)) as FILE_PATH ,
                ORG_ID from COM_FILE_INDEX group by ORG_ID) t8
            on t8.ORG_ID = t7.FILE_NAME
            where 1=1
       　　　order by car_id asc,update_date asc 
　　　　　　  ) axxx    where rownum < 16 ) orpr where orpr.DB_ROW_NUM >= 1