Syntax highlighting and alternate quote notation

Kengoo.ru

Member
Doesn't PL/SQL Developer support correct syntax highlighting of quoted literals?
Writing in SQL or Program window:

declare
str varchar2(3000) := q'[Hello, I'm a 'string' :)]';
begin
dbms_output.put_line(str);
end;

Code is syntaxically correct, but highlighting fails. It's too bad because rest of code is hard to read and autoreplace won't work there (because it's considered to be a literal) :(
 
There is another case that isn't handled (more of an edge case, but still valid syntax).

declare
str1 varchar2(3000) := q'[Hello, I'm a 'string' :)]';
str2 varchar2(3000) := q'^Hello, I'm a 'string' :)^';
begin
dbms_output.put_line(str1);
dbms_output.put_line(str2);
end;

According to this,http://docs.oracle.com/cd/E11882_01/server.112/e41084/sql_elements003.htm#SQLRF00217 it recognizes "[]", "()", "{}" and "" specifically, but you can use most any character as the quote_delimiter.
 
Back
Top