I dont think I complete understand the consequences of a blank line in my sql query file, especially when I try to run it as a script in SQL Plus or CL.
From my understanding, it somehow stops or terminates the query (same thing with a ; ). But I still do not know what that means.
I just had a file involving a union which It did not work when it was
select * from a
union
select * from b.
However, when I did
select * from a
union
select * from b
it worked fine. I'm not completely understanding what is going on here.