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