Oracle uses ANTLR within SQL Developer

Jan Vervecken

unread,

Aug 12, 2016, 2:10:05 AM8/12/16

to antlr-discussion

hi

Currently at http://www.antlr.org/about.html

it says

"... Oracle uses ANTLR within SQL Developer IDE and their migration tools. ..."

Does anyone know about any ANTLR grammars (SQL, PL/SQL, ...) that Oracle may have made available somewhere?

There is https://github.com/antlr/grammars-v4/blob/master/plsql/plsql.g4

but that currently does not seem complete (and is not from Oracle).

Many thanks.

Jan Vervecken

unread,

Aug 12, 2016, 2:14:58 AM8/12/16

to antlr-discussion

fyi

I posted a similar question at https://community.oracle.com/message/13976240#13976240

Regards,

Jan Vervecken

Op vrijdag 12 augustus 2016 08:10:05 UTC+2 schreef Jan Vervecken:

Mike Lischke

unread,

Aug 12, 2016, 3:16:21 AM8/12/16

to antlr-di...@googlegroups.com

Hi Jan,

Does anyone know about any ANTLR grammars (SQL, PL/SQL, ...) that Oracle may have made available somewhere?

Yes. There is a MySQL grammar for ANTLR3 here: https://github.com/mysql/mysql-workbench/tree/master/library/mysql.parser/grammar.

And I'm currently working on the ANLTR4 grammar for MySQL.

There is https://github.com/antlr/grammars-v4/blob/master/plsql/plsql.g4
but that currently does not seem complete (and is not from Oracle).

Same for MySQL, which is highly incomplete.

Mike
--
www.soft-gems.net

Jan Vervecken

unread,

Aug 12, 2016, 4:12:20 AM8/12/16

to antlr-discussion

Thanks for your reply Mike.

The scope of my question should probably be narrowed to "an ANTLR grammar for PL/SQL made available by Oracle".

Any pointers?

Many thanks.

Jan Vervecken

Op vrijdag 12 augustus 2016 09:16:21 UTC+2 schreef Mike Lischke:

Jan Vervecken

unread,

Feb 28, 2017, 3:22:54 AM2/28/17

to antlr-discussion

hi

For your information.

In an Oracle service request (SR 3-14293816421) I asked for (an enhancement request for) a coherent formal grammar for plsql and/or sql.

The feedback I got from Oracle support was :

- The documentation team rejected my request for an enhancement request because my request was the only such request they got so far at Oracle.

- Because support considered this not a "pure technical bug/enhancement", no technical/development team could be bothered with this (because of "internal policy").

See also the discussion "coherent formal grammar for plsql and/or sql"

at https://community.oracle.com/thread/4021505

Regards

Jan Vervecken

Op vrijdag 12 augustus 2016 10:12:20 UTC+2 schreef Jan Vervecken:

Mike Lischke

unread,

Feb 28, 2017, 4:03:35 AM2/28/17

to antlr-di...@googlegroups.com

Hi Jan,

For your information.

In an Oracle service request (SR 3-14293816421) I asked for (an enhancement request for) a coherent formal grammar for plsql and/or sql.
The feedback I got from Oracle support was :
- The documentation team rejected my request for an enhancement request because my request was the only such request they got so far at Oracle.
- Because support considered this not a "pure technical bug/enhancement", no technical/development team could be bothered with this (because of "internal policy").

See also the discussion "coherent formal grammar for plsql and/or sql"
at https://community.oracle.com/thread/4021505

My focus has exclusively been on a 100% complete MySQL grammar, so I cannot say anything about a grammar for PL/SQL. If the grammar directory doesn't contain anything useful then there is probably no public grammar at all. Maybe it's time for you to sit down and create one ;-)

Mike
--
www.soft-gems.net

Reply all

Reply to author

Forward