Example:
SQL> select * from dual; D - Xruns fine, while this:
SQL> select * from dual; -- some commentsstops at second line waiting for input:
SQL> select * from dual; -- some comment 2It was really unpleasant experience.
Cheers, Paweł
My thoughts about developing software. Problems descriptions and solutions, tips, tricks, links to useful resources. Mostly on Oracle, but also PHP, Delphi and other languages & tools.
SQL> select * from dual; D - Xruns fine, while this:
SQL> select * from dual; -- some commentsstops at second line waiting for input:
SQL> select * from dual; -- some comment 2It was really unpleasant experience.
|
Copyright © Paweł Barut
Printing from DOS to USB Printer |
|
4 comments:
In case you didn't know, the issue is the first - is treated as a continuation. So, plus thinks there's more coming on the next line.
Yes, I know this.
But it was a big surprise that adding comment at end of line caused this behavior.
The same thing happens with the slash and asterisk style comment:
SQL> select * from dual; /* some comment */
2
Hi,
This way it's not problematic:
SQL> select * from dual -- check this
2 /
IR
Post a Comment