MartinF
Member²
Hi,
I am using PLSQL Dev 9.0.6.1665 and I just notice something strange in command window.
Here is some sample code to reproduce the problem.
Open a command window and create the following table.
Now you run an update command that contain comment at the end of each line
If I put the symbol ';' before the comment, I am getting and error but if I put it after the comment it worked ???
Is it a bug?
Regards,
Martin
I am using PLSQL Dev 9.0.6.1665 and I just notice something strange in command window.
Here is some sample code to reproduce the problem.
Open a command window and create the following table.
Code:
create table test_mfa(col_1 number,col_2 varchar2(100),col_3 date);
insert into test_mfa values(1,'a',sysdate);
Now you run an update command that contain comment at the end of each line
SQL:
SQL> update test_mfa --line 1
2 set col_1 = 2 --line 2
3 where col_2 = 'a'; --line 3
update test_mfa --line 1
set col_1 = 2 --line 2
where col_2 = 'a'; --line
ORA-00911: invalid character
SQL> update test_mfa --line 1
2 set col_1 = 2 --line 2
3 where col_2 = 'a' --line 3;
1 row updated
SQL>
If I put the symbol ';' before the comment, I am getting and error but if I put it after the comment it worked ???
Is it a bug?
Regards,
Martin