Re: SQL*Plus format problem

Jeff Busch wrote:
>
> The following select statement returns two rows, but when spooled to an
> output file an extra blank line shows up after the rows. Is there any way
> to stop SQL*Plus from outputting the blank line?
>
> set verify off
> set echo off
> set pagesize 0
> set newpage 0
> set linesize 88
> set trimout on
> set space 0
> set term off
> set wrap off
> clear buffer
> clear break
> clear columns
>
> spool test.dat
> select column_name from table
> /
> spool off
>
> ---
> Jeff Busch Internet busch1_at_llnl.gov
> Voice (510) 423-9134 Fax (408) 263-1360

Hope the following example helps. There maybe some overkill on the set statments but I didn't have time to do a lot of testing.

[UNIX:KSH] cat /tmp/tab1.sql
set showmode off
set echo off
set heading off
set verify off
set feedback off
set termout off
set pagesize 0
spool /tmp/tab1.lst
select * from tab1;
spool off
exit;
[UNIX:KSH] sqlplus -s / _at_/tmp/tab1.sql [UNIX:KSH] cat /tmp/tab1.lst
ROW ONE
ROW TWO
[UNIX:KSH]

-- 
                       \\|//
                       (0-0)
           +-----oOO----(_)-----------+
           | Brian P. Mac Lean        |
           | Database Analyst         |
           | brian.maclean_at_teldta.com |
           | http://www.teldta.com    |
           +-------------------oOO----+
                      |__|__|
                       || ||
                      ooO Ooo