Oracle SQL错误:ORA-00923:找不到预期的“来自关键字" [英] Oracle SQL Error: ORA-00923: From Keyword not found where expected

问题描述

当我对Oracle使用以下sql命令时:

When I use the following sql command for Oracle:

SELECT CATEGORY,ANTIGENNAME,LATINCOMPOSITION,HYCORCODE,FDACLEARANCE, LISTAGG(ORCHARDCODE, ';')
    WITHIN GROUP (ORDER BY ORCHARDCODE) as code
from tablename
group by HYCORCODE

我似乎收到了ORA-00923错误.是什么原因导致错误显示出来?

I'm seem to be getting a ORA-00923 error. What could be causing the error to show up?

谢谢...

推荐答案

可能与使用代码"的标识符有关

Could be related to the indentifier try using "code"

SELECT CATEGORY,ANTIGENNAME,LATINCOMPOSITION,HYCORCODE,FDACLEARANCE,
    LISTAGG(ORCHARDCODE, ';')
     WITHIN GROUP (ORDER BY ORCHARDCODE) as "code"
 from tablename
 group by HYCORCODE

这篇关于Oracle SQL错误:ORA-00923:找不到预期的“来自关键字"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！