Toad World® Forums

Some Oracle SQL functions are displayed like text

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)

PIVOT

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?

I put in a task to fix this, QAT-5913