I'd like to report following bug:
SELECT 1 -- dummy;
FROM DUAL;
Error starting at line : 1 in command -
from dual
Error report -
Unknown Command
I looks like semicolon at the end of line comment is recognized as a statement end. Even sqlplus doesn't recognize the statement correctly, it raises an exception with following message:
select 1 -- dummy
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
In PL/SQL instead that doesn't make any difference, semicolon at the end of line comments is considered (correctly) a comment.
The following statement is correctly executed both in SQL Developer and sqlplus:
SELECT 1 -- dum;my
FROM DUAL;