SQL Auto-select Bug

When you use the quote operator in a SQL statement to escape/ ignore single quotes and those quotes are unmatched PL/SQL Developer seems to not ignore them and fails to select the statement properly. Here is a working example:

SELECT *
FROM dual
WHERE 'x' LIKE q'[%'%]';

SELECT *
FROM dual;
 
Back
Top