Syntax highlighting for q

[Stew Stryker]

I've confirmed that code that used to have a problem has been fixed in Beta 2. The offending code had 2 single-quotes in a REGEXP, like this:

DECLARE
    l_string VARCHAR2(2000);
BEGIN
    l_string := q'[SELECT COUNT(*)
              FROM NAME n
             WHERE NOT regexp_like(n.nametag_name, '''[0-9]{2}.*')
               AND n.name_type_code = '00']';
END;

Thanks!

 

[Marco Kalter]

Thanks for confirming!

 

[rbrooker]

this is legend ... thank you `