Oracle SQL错误:ORA-00923:找不到预期的“来自关键字"

本文介绍了Oracle SQL错误:ORA-00923:找不到预期的“来自关键字"的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

当我对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:找不到预期的“来自关键字"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！