The Options window for Editor - Highlighting Styles allows us to specify the color for Reserved Words, Functions, Operators, etc. However Toad Data Point apparently treats some valid Oracle SQL functions like text, therefore they don’t appear in the same color as other functions. (This issue also happened in earlier releases.) Here are the functions/commands and related words that I’ve noticed TDP displays as Text in the Oracle SQL editor window:
ANALYZE (table or index)
LISTAGG (xxx) WITHIN
The word SETS in: GROUP BY GROUPING SETS
The word OVER in: RANK () OVER (xxx)
The word LEFT or RIGHT in: LEFT OUTER JOIN or RIGHT OUTER JOIN
It would be great if you could display these words in the same color as other common functions. Maybe this would be considered an enhancement request?