Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[4.2EA] Closing Line comment with semicolon breaks query

DemetrioSep 23 2016 — edited Sep 26 2016

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;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2016
Added on Sep 23 2016
4 comments
1,107 views