PL/SQL: SQL query with comments.
Hi there,
I am not sure if you met this situation before.
I wrote a SQL file named sql001.sql.
I did some normal queries like creating a table etc.
As I modified the original code, I used '--' to comment some old query commands.
As I edited this file in Jdeveloper, copied all the commands and pasted
them in SQL plus, it popuped Error. The error was located on my comment lines.
I did comment them with -- at the beginning. Why did it show me this error?
The old content that I commented is only used for my reference.
To run this SQL file, I have to completely delete the commented line and my SQL
file can be run smoothly. My friend told me there was some "un-seen" charactors in
the editor and made this kind of troubles. I have no idea why this happened.
Can anyone explain it?
Thanks.
Phil