SQL Developer

I have noticed that if you execute a statement that is missing a right parenthesis using the SQL Worksheet in SQL Developer, SQL Developer does not pick up the invalid SQL -- it attempts to run the statement.

Consider the following example:

SELECT *
FROM v$session
WHERE status IN ('ACTIVE', 'INACTIVE'
/

The statement is missing the right parenthesis. It should not be allowed to be executed as it contains invalid SQL. SQL Developer is still allowing it to run.

In the above case, no results are returned (which isn't such a bad thing), however this situation can cause an infinite loop in certain cases where an UPDATE statement is involved.

Is there a way to have SQL Developer not execute statements with invalid SQL?

Thanks,


neil