Spooling via DBMS_OUTPUT.PUT_LINE without new lines
419273Sep 27 2006 — edited Sep 28 2006Is there a way to spool output to a file using DBMS_OUTPUT.PUT_LINE so that each line is placed on a same line? ie spool all output to one line?
I guess this probably goes against design of PUT_LINE as it is mean to put a line.
What I am trying to do is build a DOS command via a SQL script that spools to a file all on one line. this is so that when the spool file is run (either as a .bat or .sh file) the command can execute correctly since it is all on one line.
Any ideas?
Leigh.