I’m typing this (perfectly valid) SQL statement into an editor window:
SELECT Running
FROM (SELECT 99 Running
FROM DUAL);
For some reason, the TOAD syntax checker puts a red zig-zag line (screenshot below) under the FROM and the second SELECT as if there was a syntax error, although the statement can in fact be run without any problems.
This behaviour presents a problem when working with PL/SQL code that include reference to a column called running, as the navigator fails to list any items after the supposed “error”:
Note in the above screenshot how the y() function does not appear in the navigator.
The problem can be worked around by using quotes around the column name like this:
SELECT “RUNNING”
FROM (SELECT 99 Running
FROM DUAL);
but it’s annoying to have to uglify ones code like that just to work around a Toad bug.
Toad v. 12.0.0.61 by the way.