Semicolon at the end of comment in command window

pavel_h

Member
Semicolon at the end of comment in command window splits the SQL command into pieces.

Example:
SELECT *
--;
FROM dual;

and result:
SELECT *
--

ORA-00923: FROM keyword not found where expected

FROM dual

ORA-00900: invalid SQL statement

The same error occurs in versions 11.0.6 and 12.0.2

 
Back
Top