Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Silly little sqlplus question :)
I have a little silly problem in spooling data from sqlplus to a file in
the exact format I want. To demonstrate it, here is a simple test-case.
In sqlplus under unix I run those commands:
set linesize 9999
set pagesize 49999
set trimspool on
set feed off
set head off
set echo off
set verify off
set termout off
spool myfile.txt
select 'ABC' from dual;
select 'XYZ' from dual;
spool off
I put those commands in a script, and then run sqlplus user/password @myscript.sql
Now, my problem is that the output file will have a blank line before each row of output, i.e:
<blankline>
ABC
<blankline>
XYZ
rather than just
ABC
XYZ
that I would like.
Any way I can avoid those blank lines
(without post-processing the output, of course)?