SQLDeveloper 1.1.0.21.41 - Running queries using F9
419978Nov 9 2006 — edited Nov 10 2006Windows XP
Couple of issues when running queries
Issue 1
SELECT *
FROM DUAL;
WHERE 1 = 0;
When I select the whole query above, and press F9, the query executes and returns data. But, if you see there is a SEMICOLON after DUAL. It should fail with syntax error. We were running couple of queries on production today, and we were not able to figure why the query was not working. We finally figured out after 20 minutes that the semicolon was the problem.
Issue 2
-- Comment here
SELECT *
FROM DUAL;
We have lots of queries with comments. It is a common practice to select the query along with the comment above, and press F9. The query never executes. Again, we were scratching our head, to figure out why it was not running. When we selected the query only (without the comment above) it worked.