quote delimiters

dba_tom · Post by **dba_tom** » Tue Mar 10, 2015 1:46 pm

I apologize if this has been asked before but I can't find it with a search. Oracle has had the ability since version 10 to specify a quote delimiter in a string, for strings that have embedded quote characters. Oracle text literal documentation. Examples:

Code: Select all

q'{this is a test of TextPad's quote higlighting }'
q'[this is a test of TextPad's quote higlighting ]'
q'!this is a test of TextPad's quote higlighting !'

It is a valid text literal in Oracle but it isn't highlighted like I would expect. How do I fix that in my syntax definition file?