You are here: PSPad forum > English discussion forum > Re: Coloring Oracle Q-Literals

Re: Coloring Oracle Q-Literals

#1 Coloring Oracle Q-Literals

Posted by: garbuya | Date: 02/06/2018 15:33 | IP: IP Logged

Is there a way to proper color Oracle Q-Literals?
Oracle allows to enter literals in format
Q'open_char literal without doubling apostrophes closing_char'

For example
Q'[I'm back]'
Q'{I'm back}'

To enter a single apostrophe you can use
Q'{'}'

Currently this costs a complete mess in coloring -- everything after last apost is treated as a literal until next apost

Edited 2 time(s). Last edit at 02/06/2018 15:35 by garbuya.

Options: Reply | Quote | Up ^


#2 Re: Coloring Oracle Q-Literals

Posted by: pspad | Date: 02/06/2018 15:51 | IP: IP Logged

I must look at highlighter behavior. Because I don't use Oracle, same as most of other syntaxes, I depend of information from users that something is wrong.
Can you specify it more or give me link to syntax description what can be taken as open/close char?

Options: Reply | Quote | Up ^


#3 Re: Coloring Oracle Q-Literals

Posted by: garbuya | Date: 02/06/2018 15:55 | IP: IP Logged

Thank you for fast response.
Here is an example
livesql.oracle.com

Official site
docs.oracle.com

Edited 1 time(s). Last edit at 02/06/2018 15:59 by garbuya.

Options: Reply | Quote | Up ^


#4 Re: Coloring Oracle Q-Literals

Posted by: pspad | Date: 02/06/2018 16:08 | IP: IP Logged

It means it can be near any character and for bracket you must use pairs. It's little crazy from my point of view.
How to recognize if this construction starts from normal string?

Options: Reply | Quote | Up ^


#5 Re: Coloring Oracle Q-Literals

Posted by: garbuya | Date: 02/06/2018 16:16 | IP: IP Logged

Obviously, you cannot handle all possible permutations
I think, handling pairs [] {} <> () will be enough

So, if you see Q + apost + opening bracket, then everything till closed bracket + apost is literal

Edited 1 time(s). Last edit at 02/06/2018 16:19 by garbuya.

Options: Reply | Quote | Up ^


#6 Re: Coloring Oracle Q-Literals

Posted by: pspad | Date: 02/22/2018 13:12 | IP: IP Logged

Available from next build

Options: Reply | Quote | Up ^






Editor PSPad - freeware editor, © 2001 - 2018 Jan Fiala, Hosted by Webhosting TOJEONO.CZ, design by WebDesign PAY & SOFT, code Petr Dvořák, Privacy policy and GDPR