SQL*Plus format problem

From: Jeff Busch <busch1_at_llnl.gov>
Date: 1996/10/29
Message-ID: <5558q3$ju2_at_lll-winken.llnl.gov>#1/1


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
Received on Tue Oct 29 1996 - 00:00:00 CET

Original text of this message