grammars-v4
grammars-v4 copied to clipboard
[PL/SQL] SQL functions misplaced in parser definition?
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
This sounds ok but the performance will need to be checked with a change.