Toad World® Forums

is this a bug? or a misconfiguration in my syntax highlighting?

is this a bug? or a misconfiguration in my syntax highlighting?

SELECT q’!xxxxxx!’,
q’[xxxxx]’,
q’(xxxxx)’,
q’xxxxxx’, — the q here is not highlighted as part of the string
q’’,
q’#xxxxx#’, — the q here is not highlighted as part of the string
q’!xxxxxx!’,
q’{xxxxx}’
FROM DUAL

This has already been fixed for Toad 11.5.

If you would like to fix this on your side, do the following.
View|Options|Editor|Behavior. Edit the PL/SQL language. Select the “Parser” tab.
Note the ordering and naming of categories that I have. All “String” categories
that you have can be removed and you can replace them with the 3 that you see in
my screenshot. Each of them should have the “Evaluates to…” and “Default
highlighting…” set to String. Nothing on the advanced tab is changed from
default values. The regular expressions for each are…

String Q-Quote

(?s) ( q’)((’|\Z)|((.?)()’|\Z)|({.?)(}’|\Z)|([.*?)(]’|\Z))

String Q-Quote Catchall

(?s) ( q’)((.).*?(\3’|\Z))

String

(?s) ( '|")(.*?)(\1|\Z)

Oops, I forgot the screenshot. Here it is.
image001.png