Sqlplus command separator and line breaks

From: David Wright <David_wright_at_spra.com>
Date: Thu, 02 May 2002 20:59:55 GMT
Message-ID: <9202827AFDavidwrightspracom@64.164.98.6>

Is there a way to make the command separator work in sqlplus?

for instance, the command

SQL> spool c:\junk.lst ; select * from mytable ; spool off;

Does not work. I have to either hit enter after each ; or put carrige returns in my @ batch files.

I tried all the different version of setting the command, the options are c, ;, on off I think. But that did not help.

Now, I am using version 8.1.7, on a (Dell XP) PC, lauching sqlplus from the cmd.exe (DOS) command prompt. Received on Thu May 02 2002 - 15:59:55 CDT