You are here: PSPad forum > English discussion forum > Re: SQL (Oracle) Highlighting

Re: SQL (Oracle) Highlighting

#1 SQL (Oracle) Highlighting

Posted by: LucyFan | Date: 04/17/2012 14:11 | IP: IP Logged

Hi

From version 10g of Oracle it has been possible to specify alernate string identifiers...

A single inverted comma is no good if you have a single inverted comma in the string...

SELECT 'D'Arta' from dual

would cause a syntax error so you can now specify an additional identifier...

SELECT q'{D'Arta}' from dual

so in the above example q'{ starts the string and }' ends it...

It is possible to add this logic to the syntax highlighhter in PSPad, otherwise anything after the D' is no longer highlighted as text string.

Hope this makes sense

Thanks

Options: Reply | Quote | Up ^


#2 Re: SQL (Oracle) Highlighting

Posted by: pspad | Date: 04/17/2012 19:09 | IP: IP Logged

I will do it.

Options: Reply | Quote | Up ^


#3 Re: SQL (Oracle) Highlighting

Posted by: pspad | Date: 04/26/2012 12:44 | IP: IP Logged

Will be available in the next build

Options: Reply | Quote | Up ^


#4 Re: SQL (Oracle) Highlighting

Posted by: LucyFan | Date: 04/30/2012 17:58 | IP: IP Logged

Thanks that would be great

Options: Reply | Quote | Up ^


#5 Re: SQL (Oracle) Highlighting

Posted by: pspad | Date: 04/30/2012 20:09 | IP: IP Logged

Already available

Options: Reply | Quote | Up ^


#6 Re: SQL (Oracle) Highlighting

Posted by: LucyFan | Date: 06/19/2012 19:16 | IP: IP Logged

Sorry for not responding sooner, thank you very much works well :0)

Options: Reply | Quote | Up ^






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