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
Hi,
there is problem with quoted names of identifiers with with a colon inside used in Test Window. I prepared a simple example, but in fact I found this error when working with xml functions with this type of identifiers.
declare
"i:i" NUMBER := 1;
begin
dbms_output.put_line( "i:i" );
end...