search

antlr / grammars-v4

Grammars written for ANTLR v4; expectation that the grammars are free of actions.
MIT License
10.02k stars 3.68k forks source link

[PL/SQL] SQL functions misplaced in parser definition? #4080

Open AndersRongbyIMI opened 2 months ago

AndersRongbyIMI commented 2 months ago

There are three categories for standard oracle SQL functions (not java): string functions, numeric functions and other functions. I think that some functions are misplaced into string functions. Like for example NVL. Lots of function keywords are not categorized at all. My question is: Would it be a good idea to redo the parser function categorization and use Oracle's own categorization as much as possible. It can be found at this URL: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Single-Row-Functions.html

kaby76 commented 2 months ago

This sounds ok but the performance will need to be checked with a change.