Oracle SQL解析器 [英] Parser for Oracle SQL

问题描述

对于我当前的项目，我需要一个SQL解析器来解析Oracle SQL语句. 目前，我一直在使用jsqlparser，它对于简单查询非常有效.但是当发生特定功能(例如cast()或(+))时，解析器将失败.

For my current project I need a SQL parser that parses Oracle SQL statements. Currently I've been using jsqlparser, which worked well for simple queries. But when specific functions occur (e.g. cast() or (+)) the parser fails.

任何人都可以建议一个完全符合Oracle SQL的解析器吗?

Can anyone suggest a parser that is fully compliant to Oracle SQL?

最好， 会

推荐答案

您是否考虑过常规SQL解析器 ?我本人没有任何经验，但是浏览他们的网站有潜力.我个人已经在Eclipse Data Tools Platform的解析器上构建了自己的数据库(很抱歉，我无法共享，它是专有的)，但是现在我必须评估我上面链接的那个，因为它声称对Oracle SQL的覆盖范围比对Oracle SQL的覆盖范围大.我的解析器可以.

Have you considered General SQL Parser? I don't have any experience with it myself but browsing their website it has potential. Personally I have rolled my own built on the parser in Eclipse Data Tools Platform (sorry I can't share, it's proprietary), but now I will have to evaluate the one I linked above because it claims to have more coverage of Oracle SQL than my parser does.

这篇关于Oracle SQL解析器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！