Re: SQL*Plus format problem

Govindhan Padmavijayam wrote:
>
> 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.

Hi guys

set recsep off

is the statement that solves the problem.

-- 
I hope this help         +----------------------------------------+
                         | A.Jorge Florindo              PORTUGAL | 
  Regards                | E-Mail: ajf.63_at_mail.telepac.pt         |
   Jorge                 +----------------------------------------+