SQL (Oracle) Highlighting

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

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 ^

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

I will do it.

Options: Reply | Quote | Up ^

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

Will be available in the next build

Options: Reply | Quote | Up ^

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

Thanks that would be great

Options: Reply | Quote | Up ^

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

Already available

Options: Reply | Quote | Up ^

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 ^