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
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.netReceived on Wed Oct 30 1996 - 00:00:00 CET