Re: SQL*Plus format problem

busch1_at_llnl.gov (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

Hi Jeff,

Try :

set feedback off

( seems to be the only thing you missed ! :-) )

Govind. Received on Tue Oct 29 1996 - 00:00:00 CET