Re: SQL*Plus format problem

From: Ed Jennings <jennings_at_dca.net>
Date: 1996/10/30
Message-ID: <32780237.F9F_at_dca.net>#1/1


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

The one that will eliminate the blank line is -->

set feedback off

Ed Jennings

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~
jennings_at_dca.net
Received on Wed Oct 30 1996 - 00:00:00 CET

Original text of this message